Attachment_10_-_Schedule-of-Values-Template.xlsx
XLSX spreadsheet 81 KB Posted
- Solicitation number
- 140P3022R0017
About this file
This document includes a schedule of values template to be used for tracking project costs on the Chesapeake & Ohio Canal National Historical Park 4 Locks Boat Ramp Improvement project. The template outlines a breakdown of estimated costs by line item for general requirements, divisions of work, and any other required items. It also includes columns to track the value of completed work and stored materials from previous and current payment periods to calculate total percentage completion and remaining balance. The related federal contract opportunity is solicitation number 140P3022R0017 issued by the National Park Service within the Department of the Interior to improve boat ramps and locks at Chesapeake & Ohio Canal National Historical Park.
View the file
Other files
Show all 14
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Schedule of Values
Schedule of Values Template
| Project Name: | Application #: |
| Project #: | Application Date: |
| Contractor: | Period to: |
| Item # | Description of Work | Scheduled Value | WORK COMPLETED | Stored Materials (not in D or E) | Total Completed & Stored to Date | % Complete | Balance to Finish | |
| Previous Application | This Period | |||||||
| General Requirements | ||||||||
| Bonds and Insurances | ||||||||
| Project Manager | ||||||||
| Project Superintendent | ||||||||
| Temporary Utilities | ||||||||
| Temporary Toilets | ||||||||
| Office Trailer | ||||||||
| Storage Trailer | ||||||||
| Daily Cleanup | ||||||||
| Dumpsters | ||||||||
| Final Cleanup | ||||||||
| Punchlist / Closeout | ||||||||
| Overhead | ||||||||
| Profit | ||||||||
| any other items required | ||||||||
| Divisions of Work | ||||||||
| break down each item over $25,000 by labor and material by Division of Work. | ||||||||
| EXAMPLE | ||||||||
| Site Utilities | ||||||||
| Site Water Labor | ||||||||
| Site Water Material | ||||||||
| Site Sewer Labor | ||||||||
| Site Sewer Material |
Totals $ 1.00 $ - 0 $ - 0 $ - 0 $ - 0 0% $ - 0
000000&P
Guide to using Schedule of Values Template:
Columns A, B, C: In these columns, enter the item number, description, and estimated cost for each line item. Each line can represent items of work or subcontractors.
Column D: In this column, enter the amount of work that was listed as completed in previous pay applications. If there were no previous applications, you can leave this column blank.
Column E: In this column, enter the amount of work completed in the current period. This should include all work completed by the application date that was not included in any previous pay applications.
Column F: In this column, enter the value of stored materials for which you are seeking payment. Do not include the value of materials that are accounted for in columns D or E.
Column G: This column calculates the total amount of the completed work and stored materials. (D + E + F)
Column H: This column calculates the percent of work completed. (G ⁒ C)
Column I: This column calculates the value of work still remaining until completion. (C - G)
File details come from the government source that posted it. Updated .