Free Excel templates

A free concrete job bid calculator in Excel

Square feet, thickness, ready-mix, pump, crew hours, wages, payroll taxes and insurance in; the cubic yards to order, the direct cost per square foot, the price for a target margin and the margin at a quoted price out. No macros.

The price a concrete job needs is its direct cost per square foot divided by one minus the target margin. In the worked case of the book, a warehouse slab cost $7.35 a square foot to place in 2025: a 15.0 percent contribution margin needed $8.65 a square foot, and the company had bid $6.60. The calculator builds that cost line by line for one job and gives the price your margin needs.

Get the calculator

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.

Concrete_Job_Bid_Calculator.xlsx (16 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this calculator

This file is the one-page summary of The Concrete Contractor. The book explains every line: why the cost of 1,000 square feet comes before the price, how crew hours and overtime decide a fixed-price job, why a job is judged on its result after the costs it alone causes, how pay applications and retainage push a company onto its line, and how the year is planned to the bank covenant.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is in the file

Four sheets. Blue type is an input; black type is a formula.

Inputs
Square feet; thickness in inches; waste; the ready-mix price per cubic yard; other materials and pump service per 1,000 square feet; crew hours per 1,000 square feet; the average wage and the overtime share; FICA, workers comp, unemployment and hiring cost, health and equipment per crew hour, liability insurance; the quoted price per square foot and the target contribution margin.
Calculator
The cubic yards to order; per 1,000 square feet: ready-mix, other materials, pump, wages at straight time, overtime premium, payroll taxes and workers comp, health, unemployment and hiring, equipment, liability insurance and the direct cost; the price for the target margin; the contribution and the margin at the quoted price; the whole job; the price needed for margins from 10 to 30 percent. Each line has a one-line definition beside it.
Read Me
How to replace the case with your own figures, and why the result is an estimate, not a quote.
Checks
The calculator compared with the figures printed in the book.

Three things to try

Raise the crew hours. The file opens on the book's repriced warehouse slab for 2026: 200,000 square feet, 8 inches, 30 crew hours per 1,000 square feet, overtime at 10.0 percent, a direct cost of $7.25 a square foot and a 13.7 percent margin at $8.40. Put the crew hours back to the 38 the 2025 slab took and watch the margin go.

Change the ready-mix price. Concrete is the largest line of a thick slab. Raise the price per cubic yard by the supplier's next increase and read the price your margin now needs.

Replace the case. Type your own quotes, wages, tax and insurance rates over the blue cells. If a line does not make sense, the definition beside it says what it measures.

Related reading