What each job type leaves after parts, commission, burden, card fees and its share of fixed costs; break-even in calls a month from a closed year; and a check of one technician's commission week against the minimum wage and the overtime premium.
The file opens on the book's fictional company, Corlanby Overhead Door, in FY2026. Fixed costs of $670,692 over 8,911 billable technician hours make $75.27 an hour. A spring job at $395 leaves $214.67 after parts, commission, burden and card fee, and $101.77 after its 1.5 hours of fixed costs; an opener job at $465 leaves $40.21. The year needed 362.3 calls a month to break even and ran 549.5.
One Excel file, no macros, nothing locked on the Inputs tab. Free: enter your email address and the download opens at once, along with the other free models.
Garage_Door_Job_Profit_and_Break_Even_Calculator.xlsx (12 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.
This file is drawn from workbooks 1, 2 and 3 of The Garage Door Company Owner, which follows one fictional garage door company through two fiscal years: four technicians paid by the hour, then seven on commission with a weekly guarantee, an install crew, a home builder, financing on new doors, a maintenance plan, three new vans, break-even in calls a month and a letter of intent from an SBA-backed buyer.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Three sheets. Blue type on a yellow fill is an input; black type is a formula, protected against overtyping with no password.
Raise the commission from 24 to 25 percent. The burden moves with it; the card fee and the fixed cost an hour do not. The spring job falls from $101.77 to $97.24 after fixed costs, and the opener job, at $34.89, drops below the tune-up's $35.86: a commission on the ticket weighs most on the job with the most expensive parts.
Add $40,000 a year to the FY2026 fixed costs of the closed year. Break-even moves from 362.3 to 383.9 calls a month, and the margin of safety from 34.1 to 30.1 percent.
Type the credited tickets of a median week, $5,381.43. The file opens on a new technician's ride-along week, when a commission of $248.80 needs a top-up of $77.45 to reach the guarantee. On the median week the commission is $1,291.54, no top-up is due, the regular rate is $28.70, the overtime premium for the 5 hours above 40 is $71.76 and the week's pay is $1,364.
Because a commission is pay for the hours worked. Under federal rules as in force in November 2026, the week's pay divided by every hour worked must reach the minimum wage, and the hours above 40 earn an overtime premium of half the regular rate on top of the commission. A state or city may set a higher floor; the calculator lets you type it.
Not in the margin per job: in the book's split, paid calls and referral gifts are variable costs of the year, and they sit in the closed year's totals that drive break-even. The book's workbook 4 sets each lead channel's cost against the jobs it brings.