WIP SAYS 65 PERCENT COMPLETE. NOT ONE BEAM IS ERECTED.
A fabricate and erect contract is two businesses under one number. Fabrication uses 65 percent of the cost before a crane reaches the site. A cost to cost WIP schedule reads that as 65 percent of the profit earned.
On a $1.4M fabricate and erect contract with $1,078,000 of estimated cost, fabrication usually uses about $700,000 of it. At the end of the shop phase the job is 65 percent complete on a cost to cost basis. So the WIP schedule books $910,000 of revenue and $209,100 of gross profit before any steel is erected. Erection has the crane, the weather and the sequence risk. Overruns come after the profit was already booked, and they appear as a final month reversal. Structural steel subs at $1M to $5M average 23 percent gross and 8 percent net before taxes.
Your WIP schedule is doing what it was built to do. It was built for a contract where cost and progress move together.
This post covers one WIP calculation on one contract type. That page covers how the trade works and where steel margin goes across a year. Read CFO for Structural Steel Contractors for the complete treatment, worked figures included.
WHY IS A STEEL CONTRACT TWO BUSINESSES?
Fabrication is a shop. Tons move through a plant on a schedule you control. Labor is indoors and predictable, and the cost is mostly material and shop hours. Once the drawings are approved, fabrication is the easiest work a steel contractor does to forecast.
Erection is field work. Crews, a crane, weather, site access, other trades, and a sequence that changes when the concrete is late. It's a small part of the cost and most of the risk.
One subcontract covers both, and one WIP schedule reports both. That's where it goes wrong. The two phases have opposite cost and risk, and the schedule treats them as one smooth curve.
WHAT COST TO COST DOES TO THE NUMBERS.
Take a $1.4M contract. At structural steel's 23 percent gross margin the estimated cost is $1,078,000 and the estimated gross profit is $322,000. Split it the way the work splits: about $700,000 of fabrication cost and $378,000 of erection.
The shop finishes. You've spent $700,000 against $1,078,000, which is 65 percent. Cost to cost says the job is 65 percent complete. So the WIP schedule books 65 percent of the contract, $910,000 of revenue, and 65 percent of the profit, $209,100. That figure goes on the schedule, into year to date net income and onto the statement your surety reads.
Nothing is erected. No crane is on site. Every hour of risk in the job is still in front of you, and two thirds of the profit is already on the books.
THEN ERECTION COMES IN OVER.
Erection is where steel loses money, in ways the shop never does. Concrete cures late, so the sequence changes. A pick gets re-rigged. The crane waits two days because nobody cured the slab in time. Say erection comes in 12 percent over. That's an extra $45,360.
Final cost is $1,123,360 and final gross profit is $276,640. That's a 19.8 percent job against a 23 percent bid. It's a normal outcome.
The problem is the reporting. The $209,100 booked in month three was overstated by about $30,000. The whole correction appears in the closing month as a reversal. On your income statement that month, a profitable job shows a loss.
MOST SUBS MISS THIS: THE SURETY SEES THE REVERSAL.
This costs you more than the $30,000. Your bonding capacity is set from your work in progress schedule and your interim statements. An underwriter reads a WIP schedule for one thing above all: whether your estimates hold.
A job reports 65 percent complete with strong profit in month three. Then it gives back $30,000 in month eight. From the outside that looks the same as an estimating problem. The underwriter can't see that the profit was never earned in month three. He sees a company whose forecasts move.
Do that on three jobs in a year and your single job limit gets harder to raise. It gets harder in the year you planned to bid bigger work. The reversal costs you bonding capacity, and capacity costs more than margin.
HOW TO SPLIT THE WIP WITHOUT NEW SOFTWARE.
You don't need a different accounting method. You need the contract split into two performance obligations and reported that way.
1. Split the contract value at bid into a fabrication amount and an erection amount. Give each its own estimated cost and its own gross margin. The estimator already has both numbers to reach the total.
2. Measure percent complete separately for each phase. Fabrication on cost to cost, or better, on tons fabricated against tons contracted. Erection on tons erected against tons contracted. A superintendent can confirm that by walking the building.
3. Report them as two lines on the WIP schedule under one contract number, and total them. A reader sees fabrication at 100 percent and erection at zero. That's what happened.
4. Keep the erection contingency inside the erection phase. If you keep job contingency at the contract level, cost to cost releases it during fabrication. That's the same error one level down.
WHAT THE SPLIT BUYS YOU.
You get three things, and only one is cleaner accounting.
First, you stop reporting profit you haven't earned. The final month stops showing surprise reversals, and an underwriter can trust your interim statements.
Second, you learn your two real gross margins. Fabrication usually comes in several points above the blended 23 percent and erection several points below. That changes how you bid the next fabricate and erect job, and whether you want the erection scope at all.
Third, you can tell whether a job was good. Structural steel at $1M to $5M averages 8 percent net profit before taxes against an 11.5 percent target. For a $4M contractor that difference is $140,000 a year. You can't close it while two businesses with different margins report as one number.
