Tabellab
Trades & Local Services Beginner

Running a Painting & Decorating Business: Surface Takeoffs, Production Rates, Coats & Coverage, Crew Days, Job Pricing and Profit per Job

Quote painting jobs that win and still pay. You will measure walls, ceilings, trim and doors, apply fictional production rates per surface, compute paint and materials from coats and coverage, turn hours into crew days, price the job with overhead and margin, and compare quoted vs actual hours afterwards, with every cell checked as you go.

8 lessons 8 labs 2.1 h Certificate

One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.

About this course

This course follows one fictional painting and decorating firm from the first measurement to the profit after the job. You take off net wall areas, ceilings and skirting metres, look up prep rates by surface condition with XLOOKUP and production rates by surface and method with INDEX and MATCH, turn areas and coats into litres and whole cans with CEILING, convert hours into crew working days and finish dates with WORKDAY, price a job from labour, materials and overhead with margin versus markup, compare quoted and actual hours and build a dashboard with profit per crew day and a chart.

Lessons

  1. The Takeoff: Wall and Ceiling Areas minus Openings, Skirting Metres and TotalsLab15 min Pro
  2. Surface Preparation: Condition Ratings, Prep Rates by Lookup and Prep HoursLab15 min Pro
  3. Production Rates: m² per Hour by Surface and Method, Painting Hours per RoomLab16 min Pro
  4. Materials: Litres from Coats and Coverage, Whole Cans with CEILING and SundriesLab15 min Pro
  5. Crew Days and Job Duration: Hours to Working Days, Drying Gaps and Finish Dates (WORKDAY)Lab16 min Pro
  6. Pricing the Job: Labour, Materials, Overhead per Day, Margin vs Markup and Price per m²Lab15 min Pro
  7. Job Costing: Quoted vs Actual Hours and Materials, Variances and Profit per JobLab15 min Pro
  8. Capstone: The Business Dashboard – Win Rate, Average Job, Profit per Crew Day and a ChartLab18 min Pro