# The Landscaping Business Owner: companion files

Julian R. Sterling

## What is here

- LSBO_1_Routes_and_Pricing.xlsx (Chapters 4 and 5; Routes and Pricing workbook of Appendix A): sheets Inputs, Revenue, Account, Routes, then Checks. Residential revenue ($193,200 then $225,000), what one account left over a season ($748.58 then $917.54) and the crew hours the denser routes saved (450).
- LSBO_2_Crews_and_Labor.xlsx (Chapters 6 and 7; Crews and Labor workbook): sheets Inputs, Crew bill, Overtime, H-2B, then Checks. The crew bill of both years ($187,036 then $221,823), the overtime premium and the H-2B program costs of the case.
- LSBO_3_Equipment_and_Fuel.xlsx (Chapters 8 and 9; Equipment and Fuel workbook): sheets Inputs, Crew setup, Fuel, then Checks. What the third crew setup costs per hour it runs ($28.28 with fuel, before the crew) and the fuel and repairs of both years.
- LSBO_4_Installations.xlsx (Chapter 10; Installations workbook): sheets Inputs, Patio, Win rate, then Checks. The patio's price ($19,080), what it left as estimated and as worked, and the win rate of both years.
- LSBO_5_Snow.xlsx (Chapter 12; Snow workbook): sheets Inputs, Winter, Per push, then Checks. What each winter left before fixed costs ($83,455 then $102,433) and the per-push line, account by account.
- LSBO_6_Margins_Cash_and_Value.xlsx (Chapters 13, 14 and 16; Margins, Cash and Value workbook): sheets Inputs, Break-even, Installment, SDE, Indication, then Checks. Both income statements and the break-even ($711,864 then $820,977), the monthly installment ($22,625), seller's discretionary earnings ($160,253 then $196,692) and the fictional buyer's indication.
- LSBO_Landscaping_Checklists.docx: the 8 checklists of Appendix B, editable (The residential agreement; The commercial contract and its renewal; The Monday route sheet; The crew setup at the gate; The installation quote; The snow contract and the storm night; The hiring calendar; The monthly review page).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input in two input columns, followed by a Used column: the case's figures in blue on a light blue background, and an empty yellow column for yours. The Used column takes your figure when you type one and the case figure otherwise, and every other sheet reads the Used column. Black type is a formula, green type a link to another sheet. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow column is empty. Each of the 18 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the sheet says how.

Two inputs to try first:

1. In LSBO_1_Routes_and_Pricing.xlsx, on Inputs, type your own driving hours per visit for FY2026: the Routes sheet shows what a tighter route is worth in crew hours and dollars before you drop a single account.
2. In LSBO_5_Snow.xlsx, on Inputs, type a heavier or a lighter count of snow events: the per-push line moves with the weather, the seasonal contracts do not.

To use a workbook on your own company, fill the yellow column from your route sheets, payroll records, fuel receipts, equipment loan schedule, quotes and income statement, in the order Appendix A gives, and keep a copy with the case column for comparison. The workbooks are separate files with no link between them.

## A word of caution

Brackenholt Grounds Care, LLC, the town of Brackenholt, its clients, crews and lender, and the regional company that gave an indication are fictional. Prices, wages, hours, gallons, costs, counts, snow events and multiples are teaching assumptions, not market norms or recommendations. Sales tax, motor carrier, small-engine, immigration, employment and insurance rules change and differ by state and town: read them in their current text, with your outside CPA, your insurance broker, your immigration attorney and your counsel. No equipment maker, software or insurer is described or recommended. Nothing here is legal, tax, immigration, insurance or accounting advice.
