Simple Schedule of Values Templates (Excel / Word)

project schedule of values template

Schedule of values template is a document that includes the cost of each phase of the project. It also contains the finer details such as the kind of work, things to be done, and the time within which it must be done. After adding all the work items together, you have the exact cost of the entire project.

What to include in a schedule of values?

Without money, no construction project can run. A construction schedule of values is used by project engineers and architectural designers to measure the projected cost of a project against the quoted value.

The project could easily run out of cash and stall without the schedule of values. Moreover, the schedule of values breaks down the whole project cost into bits. This indicates project costs in phases and the items involved in each phase. When a project phase is completed then the project managers can do the following tasks;

  • Measure the cost incurred in that phase
  • Make the necessary payments
  • To keep the project progressing, check if the balance at hand shall be able

However, the large projects in most cases are paid in phases. The contract should include the following details in the schedule of values to make sure a smooth progression of any construction project; You may also like Dupont shift schedule templates.

The head:

At the top of the schedule of values, there is the head that should include the following;

  • The project’s name: this is usually assigned by the owner as contained in the contract document.
  • Project number
  • Contractor’s name
  • Contract application number
  • Contract application date
  • Expected finishing period

The body:

This is the main part of the schedule of values that should include the following columns;

  • Item number: For easy identification by the project managers, auditors, and engineers, each item of work must be numbered. In terms of the number of digits, the numbering could take any form. For instance, you can use three digits like 001, 002, 003, and so on. Also, you can use four digits like 5001, 5002, and so forth.
  • Work description: Work description provides details of works expected to be carried out in every phase. This may include earthmoving works, piping and electrical installations, demolitions, and so on.
  • Scheduled value: It includes the amount of money assigned to each item of work that covers the whole project. Depending on the amount of work involved, it can range from a few hundred dollars to thousands or ten thousand.
  • Completed works: In measuring the amount spent against the projected budget, the project progresses by phases making the inclusion of completed works essential. The completed works column can further be divided into two columns i.e. the previous schedule of values and the current schedule of values.
  • Materials in for non-completed work: For easy accountability, this item includes the value of materials in the project’s store. Non-completed work materials indicate the money that can be used in the current phase or in the next phase of the project.
  • Materials in store for completed work: This column indicates the value of money that spent in all the previous phases of the project. You can use it to measure the progress of the project in terms of percentages.
  • Percentage of completed items of work: This column shows how far the project has progressed. This column makes it easier to know the percentage of the remainder. It makes the project owner and contractor able to calculate the amount of time left to the project completion.
  • Balance to finish: it indicates the amount of money required until the completion of the project.
  • Retainage: until the project is complete, this is the amount of money held back as an incentive to the contractor.
  • Totals: As its name implies, it shows the total of each of the above-discussed items.

How to fill a schedule of values?

Let us discuss step-by-step how to fill a schedule of values;

The item’s number:

Without following the numbers in a serialized way, fill in the numbers allocated to each item. You can offer an item such as;

  • laying of foundation number 001
  • excavation number 002
  • electrical works number 0555 and so on

Enter details of work:

According to the corresponding work number, provide the work details. In order to make sure that there is no confusion on the amount allocated for each item, each item of work must correspond with the item number.

Enter the values:

The amount each item is likely to consume in the whole project, the scheduled values are governed by it. The values in the schedule of values spreadsheet are assigned as per to the contract value.

Fill in the details of work completed:

In each phase, fill in your construction schedule of values upon the completion of work. This is equal the amount each work item consumed.

Fill in the values of the current phase:

Fill in the values as zero if the excavation work and foundation lying are fully complete. Then, in the next row, allocate the values for the current phase.

Stored materials for non-completed work:

Measure the value of the material in the store for work that is ongoing in this column. It will assist you in knowing the quantity to order to avoid wastage.

For completed work, fill in the total value of material stored:

This value is achieved by adding the amount in the previous phase, in the current phase, and the value of stored material for non-completed work.

Calculate and enter the percentage:

Indicate the percentage of completed work against each item of work.

Calculate and enter balance to finish:

In the schedule of values form, the balance to finish is calculated by taking difference of the total scheduled value and the total amount spent to date.

Calculate and enter the Retainage percentage:

You can calculate it by taking the value of the total completed stored to date x 10%. You should also check construction schedule templates.

Conclusion:

In conclusion, a schedule of values template is used by the project owner and engineers. It assists them in getting a quick overview of the budget expenditure against the total allocation. This document breaks down the entire project cost into bits.

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.

As you found this post useful...

Follow us on social media!

You Might Also Like