CP Excel Spreadsheet - Future Needs

Note that BMAR equals Deferred Maintenance, and IFCS is the same as Capital Renewal.

Future Renewal and Funding Needs are entered by the user in cells O5 to S36. This allows you to enter the following information for new facilities and/or funding additions planned in the future:

• New GSF: Enter any new GSF planned to be built in each upcoming budget cycle.
• Construction Costs - $/GSF: Enter the inflated construction cost per square foot based on the mid-point date of the budget period this building will be built.
• Renewal Costs - $/GSF: Enter the inflated cost per square foot for additional predicted Cyclic Renewal needs based on the mid-point date of the budget period this is entered for.
• Budget Period Renewal Additions: This is a calculated field which is provided to base special funding additions on.
• Budget Funding Additions: Enter any additional predicted funding increases here to see how they impact the overall BMAR spend down and Facilities Condition Index.

Important: Make sure you have accurate funding entered here because this impacts the calculations for the new square footage added in the following ways:

• If the funding is insufficient and within the spend-down period, the overall spend-down time is increased.
• If the funding is insufficient and beyond the spend-down period, the graph starts to show insufficient funding starting at the biennium the new square footage was added.
• If the funding is more than needed and within the spend-down period, the overall spend-down time is decreased.
• If the funding is more than needed and beyond the spend-down period, the graph is not affected.

This provides an excellent planning tool for predicting the future impacts of any additional facilities, cyclic renewal needs, increased funding needs, or additional funding on your BMAR and Facilities Condition Index.