Spreadsheet: 865058d1712147833-filter-with-indirect-function-new-forecasting-template-draft-to-share-v5
Sheet: Baseline

 |  |  |  |  |  |  |  | Source |  | Prior Year | Current year | 25/26 | 26/27 | 27/28 | 28/29 | 29/30 | Amount
 | PROJECT NAME |  |  |  |  |  | Approved Funding |  |  | 100000 | 500000 | 3000000 |  |  |  |  |  |  | Local contribution (spent) |  |  |  | INSTRUCTIONS |  |  |  |  |  |  |  |  |  | BLUE | Formulas - Please don't touch
 | CA Project ID | P0095 |  |  |  |  | Approved Funding |  |  |  |  |  |  |  |  |  |  |  | Forecasted cost per stage |  |  |  | 1. There is a tab for each month. Please fill in the data for the current month and do not replace data from previous months. |  |  |  |  |  |  |  |  |  | BLACK | Project & Funding Information - please fill in.
 | [NAME] |  |  |  |  |  | Approved Funding |  |  |  |  |  |  |  |  |  |  |  | SOBC |  |  |  | 2. Fill in the grey columns with the actual spend figures. You will receive these transactions from the Finance team each month. |  |  |  |  |  |  |  |  |  | GREY | Actuals - please update with the previous months' / years' actuals.
 | Revenue Cost Centre |  |  |  |  |  | Approved Funding |  |  |  |  |  |  |  |  |  |  |  | OBC |  |  |  | 3. Review your remaining forecast months to see if they are in line with your expectations. |  |  |  |  |  |  |  |  |  | WHITE | Descriptions & Forecast - please fill in with your forecast figures.
 | Capital Cost Centre |  |  |  |  |  | Approved Funding |  |  |  |  |  |  |  |  |  |  |  | FBC
 | Current Year | 24/25 |  |  |  |  | Total funding |  |  |  |  |  |  |  |  |  |  |  | Delivery |  |  |  |  |  |  |  |  |  |  |  |  |  | 1. Enter the Project & Funding Information in the black cells.
 | Current Reporting Period | April |  |  |  |  | Forecasted spend per year |  |  |  |  |  |  |  |  |  |  |  | Post Completion |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. Update the previous month's Actuals in the grey columns. E.g. if you are updating to February, please enter January actuals in column Z.
 | Stage Project Funded to | Delivery |  |  |  |  | Contingency |  |  |  |  |  |  |  |  |  |  |  | AFC
 | UA Project Reference |  |  |  |  |  | Total including Contingency & Risk |  |  |  |  |  |  |  |  |  |  |  | Allocation |  | 4000000 |  |  |  |  |  |  |  |  |  |  |  | 3. Review the Forecast figures in the remaining white columns.
 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC |  |  | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC |  |  | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC |  |  | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC | SOBC |  |  | SOBC | Delivery | Delivery | Delivery | Delivery | Delivery | Delivery | Delivery | Delivery | Delivery | Delivery | Delivery
 | ABW YTD
 | For use by BCC
 |  | TOTALS
 | Workorder | Supplier / Description | Stage | Contract Status | Level 5 WBS | Level 6 WBS | Prior Years Spend (Actual) | Actual Spend: YTD |  | Total Remaining Forecast | Current Year Remaining Forecast |  |  |  |  |  | Anticipated Final Cost (AFC) |  | April | May | June | July | August | September | October | November | December | January | February | March |  |  | April | May | June | July | August | September | October | November | December | January | February | March |  |  | April | May | June | July | August | September | October | November | December | January | February | March |  |  | April | May | June | July | August | September | October | November | December | January | February | March |  |  | April | May | June | July | August | September | October | November | December | January | February | March |  |  | April | May | June | July | August | September | October | November | December | January | February | March
 | Contingency |  |  |  |  |  | 294901 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100000 |  |  |  | 1000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 |  | 94000
 | 10092-100 | [NAME] the Builder | OBC | Completed |  |  | 1150000 |  |  |  |  |  |  |  |  |  |  |  |  | 1000 |  |  |  |  | 0 | 0 | 0 | 100000 | 0 | 0 |  |  | 10000 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
 | 10092-200 | [NAME]'s Ladders | OBC | Let Contract |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 0 | 0 | 20 | 20 | 20 |  |  | 1000 | 1000 | 1000 | 1000 | 1000 | 0 | 0 | 0 | 0 | 0 | 0
 | 10092-300 | [NAME]'s Architects | SOBC | Completed |  |  | 250000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 25000 | 1000 | 1000 | 1000 | 1000 | 1000 | 6000 | 0 | 0 | 0 | 3000
 | 10092-400 | Archeology Survey | Delivery | Contract |  |  | 30000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100000 |  |  |  | 1000 | 0 | 0 | 0 | 0 | 3000 |  |  | 10000 | 3000 | 3000 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 10092-500 | Ecology Survey | FBC | Let Contract |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  | 150000 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 40000 | 0 | 0 | 0 | 10000 | 150000 | 45000 | 10000 | 0 | 0 | 0
 | 10092-600 | M&E | Post Completion | Unallocated Costs |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150000 | 45000 | 10000 | 0 | 0 | 0 |  |  | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
 | 10092-700 | Saul's Lawyers | Revenue | Unallocated Costs |  |  | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000