A breakeven utilization template for modular factories

This is the modular factory breakeven template I use with clients. It answers one question: how full does the line have to run before the plant makes money? It’s a plain Excel workbook, four tabs, no macros, and it’s free.

Why utilization is the number that matters

A modular factory almost never builds something nobody bought. Nearly every module on the line is already sold. So the question usually isn’t whether you can sell what you build. It’s whether you’re building enough of it.

Rent, equipment, supervisors, engineering, and most of the line crew cost the same whether the line is full or half empty. A trained crew you send home for three weeks doesn’t come back, so in practice they’re fixed too. Every empty slot on the schedule still has to carry its share of all that.

That’s what utilization measures: what you built divided by what the plant was built to produce. Below a certain utilization, the plant loses money every month no matter how good the product is. Above it, each extra module drops almost straight to profit, because the fixed costs are already paid. Most owners have a feel for where that line is. Very few have the actual number.

How modular factory breakeven works

The whole workbook comes down to one formula:

Breakeven utilization = monthly fixed costs ÷ (contribution per unit × designed units per month)

Contribution is the price of a unit minus the costs that only show up when you build it: materials, freight and crane, site work you sub out, per-job labor, commission, and warranty reserve.

Here’s the sample that comes in the workbook. The numbers are made up to show how it works, not a benchmark. A plant built for 16 modules a month carries $625,000 a month in fixed costs. Each module sells for $173,000 and contributes $58,800 after variable costs. Breakeven is about 10.6 modules a month, or 66% utilization. At 12.5 modules a month the plant earns about $110,000. At 9.6 modules it loses about $60,000. Every ten points of utilization is worth about $94,000 a month, in either direction.

That swing is operating leverage. It’s why a factory can’t scale down the way a general contractor can, and why a slow sales quarter hits a plant much harder than its margin percentage suggests.

What’s in the workbook

Read Me. The one idea, how to pick your unit, and how to read the answer.

Fixed Costs. Everything you pay each month whether or not anything ships: occupancy and equipment, the people you keep when the line is empty, software, and interest. It totals your monthly nut and shows how much of it is people.

Breakeven. Pick the unit your line counts (modules, panels, square feet, boxes, or homes), then enter designed capacity, price, and variable cost per unit. You get breakeven units per month, breakeven utilization, where you are today against it, and a plain verdict. It also shows what every utilization from 30% to 100% does to operating profit, what it takes to hit a profit target and whether that’s physically possible, and how breakeven moves if fixed costs or contribution change by 10% or 20%.

Backlog. The next 12 months of signed completions. It shows which months sit above or below breakeven, how many months in a row the signed book keeps you profitable, and the 12-month result if you sold nothing else.

Three things that keep the answer honest

Use job cost, not the proposal. Contribution has to come from what the jobs actually cost. If your books can’t tell you that, start there. The chart of accounts I use for modular clients splits production, logistics, set, and sitework costs so they can.
Use designed capacity, not your best month. Capacity is what the plant was built and staffed to produce in a normal month. Your record month overstates it, and every utilization number on the sheet comes out wrong.
Count what shipped, not what started. For where you are today, use units shipped and set, averaged over the last three months. On Backlog, signed contracts only. A verbal yes is not backlog.

What’s included

The Excel workbook, four tabs, no macros
Sample numbers in every input, so you can see how it works before you change anything
A Read Me tab on picking your unit and reading the result

If your breakeven comes out higher than you expected, or Backlog shows a run of months below the line, that’s worth a conversation. Email me or book a 15-minute call, and bring the Breakeven tab. If you’d rather have someone keep these numbers current every month, here’s how we work.