Capital Planning and Budgeting
Local Government and School Accountability
Capital Planning and Budgeting
A Tutorial for Local Government Officials
Module 1 - The Capital Improvement Plan
Assets Inventory: Assigning Scores
You can now calculate a score for each project, based on the weighted criteria, using the following formula:
project score = (criteria1 weight*criteria1 score) + (criteria2 weight*criteria2 score) + (criteria3 weight *criteria3 score)....+ (criteriaN weight *criteriaN score)
The table below shows the project scores for each of our projects:
| Safety (w=10) | Cost (w=7) | Community Support (w=2) | Project Score | ||||
|---|---|---|---|---|---|---|---|
| Project 1 | 10*3 | + | 7*1 | + | 2*7 | = | 51 |
| Project 2 | 10*4 | + | 7*8 | + | 2*2 | = | 100 |
| Project 3 | 10*9 | + | 7*6 | + | 2*2 | = | 136 |
You can then prioritize your projects based on their project scores.
This system can help choose between different alternatives for individual capital acquisitions, as well. For instance, in replacing a snowplow, your criteria may be purchase cost, fuel-efficiency and estimated cost of maintenance. These criteria are weighted and then each alternative plow is scored on each of the criteria, and the total equipment score is calculated.
We have provided an Excel spreadsheet to assist you with this process. Download it here.
