What the columns mean on this sheet
Budget is the planned dollars for that phase. Committed is dollars promised on a purchase order or subcontract that are not already in Actual. Actual is dollars already spent. Variance is Budget minus Actual minus Committed. Percent spent is Actual divided by Budget. You type the first three. The last two are formulas. The bar under the sheet is that same percent: actual as a share of the budget. It turns amber when actual is over the budget.
Site work on the addition sample is the check: 8,000 minus 5,500 minus 2,000 is 500. Percent spent is 5,500 divided by 8,000, which is 68.75 percent. Framing is 11,000 divided by 18,000, which is 61.11 percent when rounded to two decimals. The whole job has spent 34,000 of 86,350, which is 39.37 percent when rounded to two decimals.
Contingency is a percent you set
On the addition sample the phase budgets add to 78,500. At 10 percent the contingency budget is 7,850, and the total budget is 86,350. Change the percent to 4 and the contingency budget becomes 3,140, and the total budget becomes 81,640. Those two results are the formula, not a second sample price.
The 10 percent is the starting value so you can check that multiplication. It is not a rule for a house. Pennsylvania DGS cost estimating standards (2025, section 4.4, read October 14, 2026) say the Department's typical construction contingency is 10 percent of the Base Construction Allocation, the Department considers the project risks, and a deviation must be approved by the DGS Director of Design Management. That is their rule for their projects.
The WSDOT cost-risk glossary (read October 14, 2026) says change order contingency is usually 4 percent for WSDOT design-bid-build projects. The Oregon DOT estimating manual (read October 14, 2026) recommends 3.5 percent of contingency for use during construction, and it points to the department's PD-08 for that figure. A house budget follows your own risk, not those manuals. None of this is estimating or legal advice: the right contingency depends on the job, the contract and where you build.
If you put a whole purchase order in Committed and then also put its invoices in Actual, the variance counts that money twice. On this sheet, Committed is only the part that is promised and not yet spent.
What the sample dollars are not
The addition sample is one job at 418 Westfield Ave. The kitchen remodel sample renames the phases, and the new build sample keeps these phase names with different dollars. Codes 01 to 08 are labels for the rows. None of the dollars come from a cost guide, and the split is not a recommended split. Replace the numbers with yours.
This sheet does not price the job for the client. A choice between two ways to build it, with the approach and the schedule, is the contractor proposal template. A priced scope that can still change is the construction estimate example. What the job cost after the receipts are in is the job costing spreadsheet, and the write-up is job costing for contractors. More forms are on the templates page.