Attachment E - Detailed Project Budget
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Applicant: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Project Title: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Instructions for Completing This Template: Enter a descriptive name for each item or group of items in the appropriate category. Use the Unit Cost and Number of Units fields to further break down the costs. When multiple items are included in one “unit”, use the description column to provide enough detail that the reviewers can easily see how you arrived at that unit cost. Then multiply the Unit Cost and Number of Units to get a sub-total for each line. Then total each column at the bottom of each budget category and provide a Grant Total of all items included in each budget category added together. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Step 1: Please complete the table below for the different budget categories you will require to complete the project. Each category should be broken down to the appropriate level to identify each unit cost. |
|
|
|
|
|
|
|
|
|
|
|
|
DETAIL OF PROJECT COST SCHEDULE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Unit Cost |
No. of |
Total Project |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Units |
Costs |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
NETWORK AND ACCESS EQUIPMENT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
- |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Equipment |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Routing |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Transport |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Access |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OUTSIDE PLANT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
- |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cables |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Conduits |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ducts |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Poles |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Towers |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Repeaters |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
BUILDINGS AND LAND |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Improvements & |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Renovation |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CUSTOMER PREMISE EQUIPMENT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
- |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Modems |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Inside Wiring |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OPERATING EQUIPMENT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
- |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Computers |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Workstations |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Equipment/ |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Furniture |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PROFESSIONAL SERVICES |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
- |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Engineering |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Design |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Project |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Management |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Consulting |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
BROADBAND SERVICE TO LIBRARY |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The cost of providing |
|
$- |
- |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
free broadband service to |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
the rural library |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OTHER UPFRONT COSTS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
- |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Site |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Preparation |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other |
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
GRAND TOTAL |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Step 2: This table shows the estimated depreciation based on the average useful life of the project assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USEFUL LIFE and ASSET DEPRECIATION |
|
|
|
|
|
|
|
|
|
|
|
|
USEFUL LIFE OF ASSETS AND ESTIMATED DEPRECIATION |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SUMMARY OF PROJECT COSTS |
TOTAL CATEGORY SPEND FROM DETAIL SCHEDULE ABOVE |
ENTER AVERAGE USEFUL LIFE BY CATEGORY |
ESTIMATED ANNUAL DEPRECIATION |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Network and Access Equipment |
$- |
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Outside Plant |
$- |
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Buildings and Land |
$- |
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Customer Premise Equipment |
$- |
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Operating Equipment |
$- |
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Professional Services |
$- |
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Broadband Service to Library |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other Upfront Costs |
|
$- |
|
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Project Costs and Avg Useful Life |
|
$- |
- |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Step 3: Calculate the Weighted Average Useful Life |
|
|
|
|
|
|
|
|
|
|
|
|
Weighted Average Useful Life - calculate from useful life above |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|