Forecast

Document Sample
Forecast Powered By Docstoc
					Appendix D

BUDGET PLANNING & TRACKING SHEET
PROJECT TITLE: PROJECT SPONSOR: PROJECT MANAGER: SAP Cost Centre: SAP Fund Code: Report Date: SAP data date: ORIGINAL COST ESTIMATE Original Concept Budget Salaried/Contract Staff: Consultant Staff: Software: Hardware: Other Costs: Total Allocated Budget

Current Forecast Summary Staff Costs: Non Staff Costs Current Forecast Total Forecast Remaining 0 0 0 0 0 0 Actual 0 0 0

0

Variance 0

REMAINING COST ESTIMATE - TIME PHASED Jan 0 Feb 0 Mar 0 Apr 0 May 0 Jun 0 Jul 0 Aug 0 Sep 0 Oct 0 Nov 0 Dec Total 0 Actual to Date

Salaried Staff HEW Level EFT % Annual typical Salary month 0 0 0 0 0 0 0 0 0 0 0 0 Total Months Base + On-cost 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Role & Name

Non Staff Costs Item 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

c9b7d5eb-4176-44ca-8d8e-638a74355201.xls

1

2:49 PM 3/13/2009

PROJECT BUDGET PLANNING & TRACKING GRAPH
PROJECT TITLE: PROJECT MANAGER: SAP Cost Centre: SAP Fund Code: 0 0 0 0

ITS Project Office
Note: Cells requiring data entry are indicated by grey shading.

Report Date: 00-Jan-00 SAP data date: 00-Jan-00

Graph Data (Cumulative)
Month Allocated budget Original Cost Estimate Actuals (in SAP) Commitments (in SAP) Actuals + Commitments (in SAP) Remaining Forecast Cost Estimate (Actuals + Remaining Costs) $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Variance to Original Forecast budget

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

$ $ $ $ $ $ $ $ $ $ $ $

-

$

-

Budget Tracking Chart
$1 $1

$1
$1 $1 $1
Allocated budget Original Cost Estimate
Actuals (in SAP) Actuals + Commitments (in SAP)

$0
$0 $0

Forecast (Actuals + Remaining Costs)

$0
$Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Comments:

Salary Classification

Hew Level HEW-01, Step-3 HEW-01, Step-2 HEW-01, Step-1 HEW-02, Step-3 HEW-02, Step-2 HEW-02, Step-1 HEW-03, Step-7 HEW-03, Step-6 HEW-03, Step-5 HEW-03, Step-4 HEW-03, Step-3 HEW-03, Step-2 HEW-03, Step-1 HEW-04, Step-4 HEW-04, Step-3 HEW-04, Step-2 HEW-04, Step-1 HEW-05, Step-8 HEW-05, Step-7 HEW-05, Step-6 HEW-05, Step-5 HEW-05, Step-4 HEW-05, Step-3 HEW-05, Step-2 HEW-05, Step-1 HEW-06, Step-5 HEW-06, Step-4 HEW-06, Step-3 HEW-06, Step-2 HEW-06, Step-1 HEW-07, Step-6 HEW-07, Step-5 HEW-07, Step-4 HEW-07, Step-3 HEW-07, Step-2 HEW-07, Step-1 HEW-08, Step-6 HEW-08, Step-5 HEW-08, Step-4

Hew_Level_Abbreviation 1-3 1-2 1-1 2-3 2-2 2-1 3-7 3-6 3-5 3-4 3-3 3-2 3-1 4-4 4-3 4-2 4-1 5-8 5-7 5-6 5-5 5-4 5-3 5-2 5-1 6-5 6-4 6-3 6-2 6-1 7-6 7-5 7-4 7-3 7-2 7-1 8-6 8-5 8-4

Salaries as at 31/3/08 $ 34,484 $ 35,187 $ 35,892 $ 37,227 $ 37,970 $ 38,717 $ 39,186 $ 39,968 $ 40,754 $ 41,576 $ 42,399 $ 43,246 $ 44,111 $ 45,059 $ 45,964 $ 47,023 $ 48,197 $ 48,982 $ 49,962 $ 50,981 $ 51,996 $ 53,020 $ 54,076 $ 55,157 $ 56,263 $ 56,817 $ 57,952 $ 59,130 $ 60,307 $ 61,326 $ 62,699 $ 63,954 $ 65,242 $ 66,539 $ 67,868 $ 68,770 $ 70,537 $ 71,942 $ 73,395

HEW-08, Step-3 HEW-08, Step-2 HEW-08, Step-1 HEW-09, Step-4 HEW-09, Step-3 HEW-09, Step-2 HEW-09, Step-1 HEW-10A, Step-1

8-3 8-2 8-1 9-4 9-3 9-2 9-1 10-1

$ $ $ $ $ $ $ $

74,843 76,333 77,862 82,291 83,936 85,620 87,346 88,169

Initial Completion at start of year Put names, HEW levels and fractions in the Salaried Staff area. The sheet will forecast a monthly salary for each entry and calculate a total salary forecast. If it is know that some positions will not be filled in particular months i.e. will not start until March or will finish in September, remove the forecasted salary figures by deleting the relevant months. The total forecast amount will be automatically adjusted.

Each month Obtain SAP report from Corporate Services Compare the forecast expenditure for the month just ended with that reported in SAP. Attempt to match actual expenditure against the previously forecast expenditure. If forecast expenditure has not occurred then consult with Project Manager and adjust accordingly. Any planmned expenditure that has not occurred needs to pushed into a future month. At the end of the update, there should be no values in past month columns. For example, if you have SAP data as