Markup & Landed Cost Calculator

Because a 40% markup returns a 28.6% gross margin, and the sheet ships with a 30% margin floor. That is the arithmetic, not an error. Markup is measured against cost; margin is measured against price. To actually clear a 30% margin you need a 42.9% markup — the FLOOR CHECK block does that conversion for you.

Everything that happened to the item before it reached your job: the invoice price, inbound freight, the sales tax you actually paid, a waste or breakage allowance, and any flat per-unit handling adder you apply. If you price off the invoice line alone you are quietly donating the difference on every single unit.

Usually not. The Price Book gives every row its own markup cell for exactly that reason. Fast-moving small-ticket items carry more markup than a big membrane roll a customer can price online in thirty seconds. What matters is the blended margin on the Dashboard, not any single row.

They are real landed costs from a working contractor material price card — flat roofing membrane, coatings, repair materials and shingles — with the manufacturer brand names generalised out. Type your own numbers over them. Your supply house is not the same as anyone else's.

Because it comes off the top, not off the profit. On a job running a 28.6% materials margin, a 10% fee on gross revenue removes better than a third of what was left. That is the whole reason the job block sits on the same tab as the item price — an item can pass and the job it lives in can still fail.

Yes. Every workbook is built with an older, universal formula vocabulary so it imports into free Google Sheets without add-ons, and it opens in Excel as well. You get both in one purchase.

The workbook was opened in a calculation engine, fully rebuilt, and 40 figures were compared to values worked out independently in code from the same seed inputs. One disagreement would have stopped the release. An excerpt of that ledger is on this page.