Construction Jobsite Temporary Utilities Cost Tracker in Excel

Every cost on a construction project stops when the work stops. Labor stops when the crew goes home. Material stops when the last delivery lands. Equipment stops when you send the lift back. Temporary utilities do not stop. The temp power meter spins through a two week owner decision, the propane rig burns through a shutdown for a permit revision, and the portable toilet rental invoices on the first of the month whether anybody used it or not. A construction jobsite temporary utilities cost tracker in Excel exists for one reason: this is the only category on your job cost report that bills against the calendar instead of against production, and the calendar is the thing that slips.

The lazy version of this tracker is a tab with five columns labeled power, heat, water, toilets, and dumpsters, a running total, and a comparison to budget. It tells you what you spent. It does not tell you what a delay costs, which is the only question anybody is going to ask you about this category, and it will get that question wrong by a factor of four in either direction.

Here is what this article builds instead. One workbook, one classification rule that splits the category by what actually drives each line, and a delay formula that prices the months you are actually going to be there rather than the months you already survived. The reference job is a $8.4 million, 42,000 square foot medical office shell and fit-out, eleven months, February 1 start, December 31 substantial completion.

The Only Jobsite Cost That Keeps Billing When Nobody Is Working

Temporary utilities on this job budgeted at $48,115. That is 0.57 percent of contract value and about 5.7 percent of a ten percent general conditions bucket. Nobody loses sleep over it during the bid. Here is the actual monthly burn.

Divide $48,115 by the 334 calendar days between February 1 and December 31 and you get $144 a day. That number is in every project manager's head and it is useless. A June day on this job costs $122. A January day, which is where a delay actually lands, costs $224. The $144 average sits between them and describes neither: it overstates a June day by 18 percent and understates a January day by 36 percent, which is the direction that costs you money.

The reason is structural, not seasonal. Schedule extensions do not happen in the middle of a job. They happen at the end, by definition, because the end date is the thing that moves. So the months you get paid for in a time extension are never the average months. They are the tail months, and on any job that finishes in the fourth quarter, the tail months are the most expensive temp utility months on the entire schedule.

Three Cost Drivers Hiding in One Budget Line

Split the category by what makes each line go up. There are exactly three drivers, and they behave completely differently when the schedule moves.

Calendar driven (C). Rental and standby charges that invoice on the first regardless of whether a single person shows up. Temp power service and distribution rental, the water meter and backflow assembly rental, the base portable toilet units, the trailer connection. A month of delay costs you one full month of these, every time, no exceptions.

Weather driven (W). Temporary heat in the north, temporary cooling and dehumidification in the south. These are not indexed to time. They are indexed to how cold or how humid it is during the months you are on site. Two months of delay in October costs a fraction of two months of delay in January, and the difference is not a judgment call, it is measurable.

Production driven (P). Waste hauling pulls, kilowatt hours above standby, toilet units above the base count, water consumption. These track the work, not the clock. A duration extension with no added scope does not increase them, because the same work is being done over a longer window, not more work.

The buckets come out at $7,975 calendar (16.6 percent), $9,920 weather (20.6 percent), and $30,220 production (62.8 percent). Read that split again, because it is the whole argument. Almost two thirds of what you spend on temporary utilities will not recur during a pure time extension. If you walk into the owner's office with a delay claim priced at the $4,374 average monthly burn, 63 percent of your number is a cost you are not going to incur, and the first thing the owner's rep does is ask for the utility bills.

The Tracker Layout and the Formulas That Do the Work

One sheet, one row per billing period per cost line. The column that makes this workbook different from a spending log is column C.

Column B and column G being separate fields is not bookkeeping fussiness. The distance between them is the reason your job cost report is wrong, and section six is built entirely on that gap.

Convert a meter read into dollars so you are not waiting on the utility to tell you what you spent:

=(D9-D8)*$H$9+$H$10 where H9 holds the blended rate per kilowatt hour, $0.112 on this job, and H10 holds the fixed monthly service charge of $46. Read the meter yourself on the last working day of the month. You now know your power cost three weeks before the bill arrives.

Pull the calendar bucket into a monthly rate you can multiply by anything:

=SUMIF($C$5:$C$60,"C",$F$5:$F$60)/$J$3 with J3 holding months elapsed. On this job it returns $725. That is the number that costs you money every single month of an extension, and it is the only piece of the category you can quote without doing any further work.

Flag a period that ran hot before it becomes a pattern:

=IF(AND(F12>E12*1.15,E12>0),"OVER","OK")

Get the cost of a single calendar day in the current month, which is the number a superintendent actually uses when deciding whether to work a Saturday to hold a date:

=F12/DAY(EOMONTH($A12,0))

Price Temp Heat the Way the Weather Prices It

Temporary heat is the largest single swing in this category and the one everybody prices with a shrug. It is also the easiest of the three to forecast accurately, because somebody already publishes the index. A heating degree day is the gap between a base temperature, conventionally 65 degrees Fahrenheit, and the day's mean temperature, summed across the month. NOAA publishes monthly normals by station, and your propane supplier is already using them to plan deliveries.

Calibrate against your own three months of actuals rather than a rule of thumb. This job's site normals and billed heat:

Three months, three readings, a spread of one cent. That is what a real cost driver looks like. Contrast it with dollars per month, which moved from $1,340 to $4,720 across the same three months, a 252 percent swing, and which is the basis most delay claims actually use.

Store the monthly normals in a lookup range and pull them by month number:

=XLOOKUP(MONTH($A20),$L$5:$L$16,$M$5:$M$16)

Then the rate itself, straight off the driver column:

=SUMIF($C$5:$C$60,"W",$F$5:$F$60)/SUM($M$5:$M$15)

January normals at this site are 1,100 degree days and February 985. At $4.70 that is $5,170 and $4,630. You now have a defensible temp heat number for two months you have not worked yet, built from your own invoices on this job, tied to a published index, in a form the owner's rep cannot argue with without arguing against the weather.

South of the heating belt, run the same structure on cooling degree days and add the dehumidification rental. Flooring and millwork manufacturers publish an ambient temperature and relative humidity window that has to hold before, during, and after installation, so temporary conditioning in a Gulf Coast August is not a comfort item, it is a warranty condition on the finishes. Same driver, same math, different index.

What a Two Month Delay Actually Costs

The owner sits on a lobby finish selection and substantial completion moves from December 31 to February 28. Two months. Here is what the two methods produce.

The average method understates a winter extension by $4,517 on a category nobody was watching. That is 52 percent, and it is money you had a contractual right to and did not ask for.

Now run the mirror. Same two month extension, but the delay hits in May and June instead. Calendar is still $1,450. Weather is zero, because the propane rig went back in April. Production adds maybe $593 in extra pulls and slow crew kilowatt hours. Driver based total: $2,043. The average method would have claimed $8,748 for the same two months, a 4.3 times overcharge.

The overstatement is the more expensive mistake, and this is the part most articles on delay claims get backwards. A claim that is 52 percent light gets paid at 52 percent light. A claim that is 4.3 times heavy gets audited, and once the owner's rep pulls three utility invoices and proves your temp utilities line is padded, every other line in that claim gets the same treatment. You do not lose the $6,705. You lose the extended overhead, the supervision, and the equipment standby that were all correctly calculated.

Two cells, keyed off the driver column, produce the defensible number:

=$J$4*$J$8 for the calendar portion, monthly rate times extension months.

=$J$5*SUM($N$20:$N$21) for the weather portion, dollars per degree day times the degree days of the specific extension months.

Production stays at whatever the closeout minimum actually is, and you say so in the claim narrative. Volunteering that 63 percent of your temporary utilities budget does not recur is the single most credible thing in the document, and it is what buys you the benefit of the doubt on the lines that do.

The Billing Lag That Hides Two Months of Spend

Utility invoices arrive three to six weeks after the service period ends. Waste hauling and propane are closer to two. Portable toilets bill in advance. Nothing in this category arrives in the month it belongs to, and none of it is under your control.

The consequence is mechanical. On December 10, when you close November for the job cost report, the last temp power invoice in the system covers the period ending October 24. Your report is showing a category that is running $6,000 to $7,000 a month at roughly $4,000, and the missing piece is the piece that is growing. On an eleven month job, the final two months of utilities land after you have billed the final application, released the sub retention, and reported the margin to your surety.

Accrue with the driver, not with a trailing average. On December 31, with the last read dated November 24, that is 37 unbilled days. The trailing three month average is September, October, and November, or $4,848 a month, which prorates to $5,980. The driver based accrual is $865 of calendar, $5,617 of weather at 1,195 degree days, and about $1,292 of closeout production, or $7,774. The trailing average leaves a $1,794 hole in a single month, and it opens the same hole in January, February, and March.

=$J$6/30*$J$7 gives you the flat rate version, daily rate times unbilled days, and it is fine for the calendar bucket. For the weather bucket, sum the actual degree days between column B's last read date and today and multiply by your calibrated rate. That is the whole difference between a WIP schedule that is right and one that gets restated at closeout.

Pull the period actuals for any window with a single formula:

=SUMIFS($F$5:$F$60,$B$5:$B$60,">="&$J$10,$B$5:$B$60,"<="&$J$11)

Cutting the Burn Without Cutting the Job

Once you know the extension months cost $6,633 each, the mitigation list stops being housekeeping and starts being worth a project manager's afternoon. Ranked by dollars against the two month winter extension.

The permanent HVAC item is the only one on that list that moves real money, and it is a genuine trade, not a free win. Two months of a twelve month labor warranty is 17 percent of your coverage against $9,800 of temp heat you do not spend. On a fit-out where the mechanical contractor's warranty exposure is a few thousand dollars of service calls, take the trade. On a job with a chiller plant, do not. The tracker's job is to put the $9,800 on the table so that conversation happens in November instead of never.

One more that is not on the list because it is not a saving, it is a recovery: if the owner takes beneficial occupancy of any portion of the building before substantial completion, install a check meter that day. Every kilowatt hour past that point is theirs, and without a meter reading dated to the occupancy you have no way to prove the split.

Track the Meter, Not the Month

Temporary utilities are a small line that behaves like no other line on the job. They bill against the calendar while everything else bills against production, they concentrate their spend in exactly the months where a schedule extension lands, and they invoice a month and a half after the money is gone. Those three properties together are why a category worth 0.57 percent of contract value can put a five figure hole in a delay claim.

Do three things and the category is solved. Put a driver code on every line, because C, W, and P escalate on completely different rules and a single blended monthly rate is wrong against all three. Calibrate temp heat against degree days from your own invoices, because the dollars per month figure swings 252 percent across a season while the dollars per degree day figure holds within a penny. Accrue from the last meter read date instead of the last invoice date, because the gap between those two columns is where a restated job margin comes from.

Temporary utilities are one line in a general conditions estimate that has a dozen more with the same problem. If you have not built the estimate side yet, our guide to the construction general conditions cost estimate in Excel covers the line item method that this tracker reports against, and the monthly burn rate logic the two share.

Building this from a blank workbook is a weekend, and the part that kills it is not the arithmetic, it is the plumbing: cost codes that match your accounting system, budget versus actual by period rather than by job to date, a committed cost view that shows the rental contracts you have already signed, and an accrual column that survives a month end close. Our Construction Budget Tracker ships with that structure already wired, so you add a driver column and a degree day table to a workbook that already handles the cost codes, the period variance, and the committed versus actual logic. You point it at last month's utility invoices and you have a defensible extension number the first time an owner moves your completion date, instead of a spreadsheet you abandoned in week two.