# The Construction Estimator: companion files

Julian R. Sterling

## What is here

- **Construction_Estimator_Model.xlsx**: the workbook that rebuilds the Elsmoor County Library and Learning Center case, from the first conceptual number to the GMP, with live formulas. Sheets: Conceptual, Design estimates, Takeoff, Labor, Leveling, General conditions, Markups, Checks.
- **Construction_Estimator_Toolkit.docx**: the 8 checklists of Appendix B (plan and specification review; addenda and the bid form; scope sheet; public work: prevailing wage and bonds; bid leveling; the sealed self-perform number; bid day, hour by hour; post-bid review), in editable form.

## Which sheet answers which chapter

- Chapter 5: Conceptual (three completed projects escalated to the midpoint: $16,767,000, reported from $14,252,000 to $20,120,000)
- Chapters 6 and 7: Design estimates (SD GMP estimate $17,861,413, DD GMP estimate $16,578,288, value engineering and design growth)
- Chapter 8: Takeoff (slabs, footings and walls of the self-performed concrete, quantities before and after waste)
- Chapter 9: Labor (crew hours, the invented Elsmoor County wage schedule, the sealed self-perform number $714,000, rough carpentry)
- Chapters 11 and 14: Leveling (HVAC, electrical and concrete bids with their plugs: lowest base M1, lowest leveled M2)
- Chapter 12: General conditions ($1,036,778 over 15 months plus one month of closeout)
- Chapters 2, 13, 14 and 15: Markups (base GMP $15,820,745, the alternates, the GMP proposal $16,233,288, the hard bid comparison and the markup curve)
- Appendix A: 14 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Labor, set the productivity factor to 1.20 (every self-performed task takes 20 percent more hours): the sealed number rises to $753,000, above the best leveled concrete bid of $749,720, and the decision flips to subcontract.
2. On Leveling, set the plug for M1's missing temperature controls to $70,000: M1 levels lower, but the carried HVAC bidder does not change. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. The inputs sit on the sheet that uses them. The price depends on insurance and the bond, which depend on the price: the Markups sheet solves it in closed form, tier by tier of the bond schedule, so there is no circular reference. No macro, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs. Amounts are in US dollars.

Talhurst Builders, Elsmoor County and every bidder are fictional. Prices, quantities, productivity, wage rates, insurance and bond rates, fee and contingency are teaching assumptions, not market prices, wage determinations or the rates of any insurer or surety. Wage rules, bond thresholds and contract forms change: check the current texts and the bid documents before relying on any of them.
