# The Commercial Cleaning Business Owner: companion files

Julian R. Sterling

## What is here

- CCBO_1_Site_Quote.xlsx (Chapters 4 to 6; Site Quote workbook of Appendix A): sheets Inputs, Quote, Flat price, then Checks. From cleanable square feet and a production rate to planned hours and a monthly price (a 30,000-square-foot office at five nights: 203.1 planned hours, $6,200 a month), the labor cost per planned hour ($19.39 then $20.05), what a site leaves each month, and an office price per square foot set beside the labor of a medical site.
- CCBO_2_Labor_and_Turnover.xlsx (Chapters 9 and 10; Labor and Turnover workbook): sheets Inputs, Overtime, Turnover, then Checks. The overtime premium ($14,338 then $5,280), a weekly register of each cleaner's hours across sites, turnover (140.5 then 70.9 percent) and the cost of hiring.
- CCBO_3_Floors_and_Bids.xlsx (Chapters 7 and 8; Floors and Bids workbook): sheets Inputs, Floors, Bonds, then Checks. Floor work costed in-house against a subcontractor's quote, periodic work by year, your own timed job, and a public bid with its bid bond, performance bond and premium ($2,716).
- CCBO_4_Collections_and_Cash.xlsx (Chapters 13 and 14; Collections and Cash workbook): sheets Inputs, Late payer, Days owed, then Checks. A late payer month by month to the write-off ($11,034), a register for your own slowest payer, days of revenue owed (51.2 then 48.2) and cash against the floor.
- CCBO_5_Earnings_and_Sale.xlsx (Chapters 14 to 16; Earnings and Sale workbook): sheets Inputs, SDE, Indication, Transferable, then Checks. Seller's discretionary earnings ($83,396 then $118,878) with each add-back on its own line, net income per owner hour, the fictional buyer's indication with its terms, and transferable earnings ($45,718).
- CCBO_Commercial_Cleaning_Checklists.docx: the 13 checklists of Appendix B, editable (Walkthrough and quote; Starting a new site; The site contract; A bid or a rebid; Scheduling and overtime; Hiring and the first week; The site inspection; A complaint; The supply closet and keys; Periodic work and the subcontractor; Collections; Losing a contract; The monthly review of the company).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input in two columns side by side: Case, with the case's figures in blue on a light blue background, and Your company, an empty yellow column for yours. A cell at the top of the sheet chooses which column the formulas read; the Used column applies that choice (a blank yellow cell falls back to the case figure), and every other sheet reads the Used column. The Note column is yours: write the date and the document of each input. 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 top cell reads Case. Each of the 11 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. A month has 52 / 12 weeks. When a figure is rounded, the note at the top of the sheet says how.

Two inputs to try first:

1. In CCBO_1_Site_Quote.xlsx, on Inputs, change the production rate of the kind of site you quote most: the planned hours move, and the price follows them.
2. In CCBO_2_Labor_and_Turnover.xlsx, on Overtime, enter one week of a cleaner who works at two or three sites: the register adds the hours across sites and marks what passes the threshold.

To use a workbook on your own company, set the top cell to Your company and fill the yellow column from your walkthroughs, your payroll and timesheets, your bid documents, your aging report and your income statement, in the order Appendix A gives, and keep a dated copy at each year end. The workbooks are separate files with no link between them.

## A word of caution

Stavelock Commercial Cleaning, LLC, the town of Stavelock, Tolvane Medical Offices, Brindleworth Logistics, Orrinsby County, Calderwyn Software and the regional facility services company that gave an indication are fictional. Prices, production rates, wages, hours, counts, payment delays, premiums, draws and multiples are teaching assumptions, not market norms or recommendations. Federal, state and local rules on wages and hours, workplace safety, worker status, insurance, licensing and public bidding change and may or may not reach a given company: read them in their current text, with your outside accountant, your insurance broker, your surety and your counsel. No company, franchisor, product or vendor is described or recommended. Nothing here is legal, tax, insurance or safety advice.
