Cleaning Business Math: Production Rates, Job Quotes, Recurring Plans, Supplies & Crew Schedules

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Look up production rates by room type and soil factors by soil level, turn a home's room areas into cleaner-hours and plan the time on site for a team of two.
• Load the wage with on-costs, add travel time, supplies and vehicle costs to get the full job cost, then set a price for a target margin and round it to a customer-friendly number.
• Price weekly, fortnightly and monthly plans from one standard price, add a first-clean surcharge, compare first-year client value, set monthly billing and total the recurring revenue of the client base.
• Count December's cleaning visits with NETWORKDAYS and the office's closed days, turn them into cleaner-hours, price the month for a target margin and express it per square metre.
• Read 1:n ratios from fictional product labels, convert them into millilitres of concentrate per litre, total the concentrate a month needs and round the order up to whole bottles after counting the shelf.
• Summarise a week's job list per cleaner and per day with COUNTIFS and SUMIFS, convert travel minutes into hours and measure how much of each cleaner's paid time is spent on site.
• Build a move-out quote from a base price per m² with a minimum charge, an add-on menu priced per unit, a weekend surcharge with IF and OR, and a final price rounded with MROUND.
• Build six months of P&L from recurring clients and one-off jobs, total the half year, find the number of recurring clients that covers the fixed costs and chart the profit by month.