The price of a typical job of each fence type by the foot, with gates and removal; what it leaves after materials with waste, piece pay, burden, card fees, the loader and its share of fixed costs; break-even in feet a month from a closed year; and a check of one installer's piece-rate week against the minimum wage and the overtime premium.
The file opens on the book's fictional company, Ravelcourt Fence, in FY2026. Fixed costs of $565,520 over 1,173 crew-days installed make $482.11 a crew-day. A 150-foot wood privacy fence with one gate at $41.00 a foot is a $7,030.00 job; it leaves $2,722.59 after materials, piece pay, burden, card fees and the loader, and $1,517.32 after its 2.5 crew-days of fixed costs. The year needed 2,936 feet a month to break even and installed 5,791.
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.
Fence_Job_Price_and_Break_Even_Calculator.xlsx (14 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 Fence Company Owner, which follows one fictional fence company through two fiscal years: three crews paid by the hour, then five crews on a piece rate a foot with a weekly guarantee, an estimator, a loader with an auger, a materials depot, financing, commercial work for general contractors with retainage, break-even in feet 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 every materials cost a foot by 6 percent, prices unchanged. That is a supplier's rise between the signed price and the order. The wood privacy fence falls from $1,517.32 to $1,381.24 after fixed costs, the vinyl fence from $2,397.07 to $2,182.03 and the chain link fence from $1,010.06 to $906.18: the fence with the most material in its price loses the most.
Add $40,000 a year to the FY2026 fixed costs of the closed year. Break-even moves from 2,936 to 3,144 feet a month, and the margin of safety from 49.3 to 45.7 percent.
Type the busy week instead of the frozen one. The file opens on week 68, a frozen-ground week of 32 hours: the crew's piece earnings of $504.00 give the installer $226.80, below the guarantee, so the top-up is $5.20 and the regular rate exactly $7.25. Type $2,466.60 and 48 hours, week 81: the installer earns $1,109.97, no top-up is due, the regular rate is $23.12, the overtime premium for the 8 hours above 40 is $92.50 and the week's pay is $1,203.
Because piece pay is pay for every hour worked, productive or not. Under federal rules as in force in November 2026, the week's piece earnings divided by all the hours worked must reach the minimum wage, and the hours above 40 earn an overtime premium of half the regular rate on top. A state or city may set a higher floor; the calculator lets you type it.
Not in the margin a job: in the book's split, paid estimate requests 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: $412.27 a job signed from paid estimate requests in the case.