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

 |  |  |  |  |  |  |  | Source |  | Prior Year | Current year | 25/26 | 26/27 | 27/28 | 28/29 | 29/30 | Amount
 | PROJECT NAME |  |  |  |  |  | Approved Funding |  |  |  |  |  |  |  |  |  |  |  | Local contribution (spent) |  |  |  | BLUE | Formulas - Please don't touch
 | Project ID |  |  |  |  |  | Approved Funding |  |  |  |  |  |  |  |  |  |  |  | Forecasted cost per stage |  |  |  | BLACK | Project & Funding Information - please fill in.
 | [NAME] |  |  |  |  |  | Approved Funding |  |  |  |  |  |  |  |  |  |  |  | SOBC |  |  |  | GREY | Actuals - please update with the previous months' / years' actuals.
 | Revenue Cost Centre |  |  |  |  |  | Approved Funding |  |  |  |  |  |  |  |  |  |  |  | OBC |  |  |  | WHITE | Descriptions & Forecast - please fill in with your forecast figures.
 | Capital Cost Centre |  |  |  |  |  | Approved Funding |  |  |  |  |  |  |  |  |  |  |  | FBC
 | Current Year |  |  |  |  |  | Total funding |  |  |  |  |  |  |  |  |  |  |  | Delivery |  |  |  | 1. Enter the Project & Funding Information in the black cells.
 | Current Reporting Period | July |  |  |  |  | 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 |  |  |  |  |  | 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 (OPTIONAL) | Stage | Contract Status | Level 5 WBS | Level 6 WBS | Prior Year Spend | 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
 |  |  |  | Completed
 |  |  |  | Let Contract
 |  |  |  | Completed
 |  |  |  | Contract
 |  |  |  | Let Contract
 |  |  |  | Unallocated Costs
 |  |  |  | Unallocated Costs