SchoolsWeb

Salary Modeller and Q2 Forecast Workshop

Salary Modeller and Q2 Forecast Workshop

New user and refresher

Overview

Salary Modeller – new user and refresher

Aimed at individuals who have had limited or no experience of using the salary modeller tool.

This part of the session will cover the basics of how the tool works and how it is used for budget setting and monitoring, to be delivered at a slower pace.  There will also be the opportunity to review the data in your current salary modeller tool and make any necessary amendments.

Q2 Forecast

In line with Forecasting monitoring procedures, schools are required to review the Financial Plan set in April/May against the actual expenditure to date, and to project a revised forecast to year end which is a best estimate. You will be able to work on the forecast spreadsheet (included within the Salary Modeller tool) in a quiet environment with Finance staff on hand to answer any questions.

The Q2 deadline is 18 October 2019

Suitable For: All Finance Staff and Bursars (especially beneficial for new Finance Staff)

Date & Venue: Please see the Training Schedule

Time: Full Day 9:30am to 2:30pm with a break for lunch (not provided). Refreshments provided.

Cost: If you have a Finance package 150 credits for the first delegate and 75 credits for an additional delegate. If no Finance Package has been purchased please refer to Schools Finance Packages 

 

What you will need to bring

  • Your school’s log in and password
  • You may wish to bring any SIMS information and a copy of your latest monthly summary report on which you may want to work before transferring the data onto the spreadsheet.
  • Your current salary modeller
  • Lunch

What we will provide

  • We will provide a copy of your September monthly summary report
  • The latest version of your salary modeller (we will request you send this to us via Anycomms before the workshop-details will be provided).

Objectives

By the end of the course you will be able to:

  • use the salary Modeller tool to its full advantage and how it can assist with your monthly monitoring.
  • understand the functionality of the Salary Modeller and the Forecast spreadsheet.
  • complete your forecast
  • consider outcomes that may affect your year- end forecast position.

 

Details

  • Salary modeller tool- work individually on a PC. Review your current data and how to make changes within the tool
  • Demonstrate how changes will impact your budget position
  • Demonstrate how the tool can be used for budget setting and budget monitoring. To be delivered at a pace suitable for the attendees
  • Explore the different elements of the tool and explain its functionality
  • Q2 Forecast -work individually on a PC on a live version of your Forecast spreadsheet with Finance staff on hand to assist
  • Explain how to complete the forecast submission spreadsheet
  • Any work completed will be saved by the school finance team on the day and will be sent to you via Anycomms by the following day.

 

 

Was this page helpful?

Very poor
Poor
Neither good nor poor
Good
Very good