Cleaning Supply Reorder List From Job Usage

Reads the supplies used on each job plus what is on the shelf now, works out how much was used, and builds a reorder list so the crew does not run out mid-week.

House cleaningHome Services and Trades✓ Checkedv1.0

Before and after

BEFORE · what the owner typed

Reedworth Home Cleaning, Dunland. Need my supply order for next week. I counted last week's 5 jobs. Crew was Jacqueline Lim and James Mbeki. Jobs: Mon 6403 Owlworth St (2 bed), Tue 6782 Plumworth Ave (3 bed, big), Wed 6403 Owlworth St again (deep clean), Thu 6782 Plumworth Ave (move out), Fri a small condo. Usage for the 5 jobs total: all purpose spray 4 bottles, glass cleaner 2 bottles, toilet bowl cleaner 3 bottles, microfiber cloths washed and reused so none, trash bags 40, floor cleaner Sudsy Meadow Pine 3 jugs, sponges 10, vacuum bags 0. On hand now: all purpose spray 2 bottles, glass cleaner 3, toilet bowl cleaner 1, trash bags 25, floor cleaner 1 jug, sponges 4, vacuum bags 6. Next week I expect 10 jobs. I want a cushion of 1 bottle for each spray and cleaner, 10 trash bags, 1 jug of floor cleaner, 4 sponges. Vacuum bags no cushion needed. Supplier packs: all purpose spray comes 6 bottles per case at $21.00 a case. Glass cleaner 6 per case at $18.00. Toilet bowl cleaner 6 per case at $24.00. Trash bags 50 per box at $12.50. Floor cleaner 2 jugs per case at $19.00. Sponges 12 per pack at $9.00. Call Jeanne Osman at the supplier, 402-555-0198, to place it.

AFTER · what the skill produced

Supply reorder list for Reedworth Home Cleaning
Based on 5 jobs last week, planning for 10 jobs next week.

Order now

All purpose spray: used 4 over 5 jobs, average 0.8 per job. Expected need for 10 jobs: 8. Cushion 1. On hand 2. Order 8 + 1 - 2 = 7 bottles. At 6 per case, order 2 cases (12 bottles). Cost: 2 x $21.00 = $42.00
Glass cleaner: used 2, average 0.4 per job. Expected need: 4. Cushion 1. On hand 3. Order 4 + 1 - 3 = 2 bottles. At 6 per case, order 1 case (6 bottles). Cost: $18.00
Toilet bowl cleaner: used 3, average 0.6 per job. Expected need: 6. Cushion 1. On hand 1. Order 6 + 1 - 1 = 6 bottles. At 6 per case, order 1 case (6 bottles). Cost: $24.00
Trash bags: used 40, average 8 per job. Expected need: 80. Cushion 10. On hand 25. Order 80 + 10 - 25 = 65 bags. At 50 per box, order 2 boxes (100 bags). Cost: 2 x $12.50 = $25.00
Floor cleaner (Sudsy Meadow Pine): used 3 jugs, average 0.6 per job. Expected need: 6. Cushion 1. On hand 1. Order 6 + 1 - 1 = 6 jugs. At 2 per case, order 3 cases (6 jugs). Cost: 3 x $19.00 = $57.00
Sponges: used 10, average 1 per job. Expected need: 10. Cushion 4. On hand 4. Order 10 + 4 - 4 = 10 sponges. At 12 per pack, order 1 pack (12 sponges). Cost: $9.00

No order needed

Vacuum bags: used 0, expected need 0, no cushion, on hand 6. Nothing to order.
Microfiber cloths: washed and reused, none used up.

Total cost: $42.00 + $18.00 + $24.00 + $25.00 + $57.00 + $9.00 = $175.00

Place the order with Jeanne Osman at the supplier, 402-555-0198. Follow each product label and safety data sheet for storage, and never mix products.

Questions for the owner

Last week included a move out and a deep clean, which can use more supplies than a regular visit. Should next week's 10 jobs be planned at the same average, or are they mostly regular visits?
Vacuum bags show 0 used on all 5 jobs. Is that correct, or were they not counted?
Do you want a cushion for microfiber cloths, or are you tracking them another way?

What it does

Reads the supplies used on each job plus what is on the shelf now, works out how much was used, and builds a reorder list so the crew does not run out mid-week.

Use it when: Use when a house cleaning business wants to turn per-job supply usage notes and current stock counts into a reorder list, such as "what do I need to reorder," "make a supply list," or "we're running low on supplies."