Business Management Consultancy and Financial Analysis

GROSS PROFIT REPORT OCT TO MARCH

Sales

Labour Sales$313,121
Parts Sales$290,091
Paint & Materials Sales$70,180
Sublet Sales$53,460
Other Sales$578
Total Sales$727,430

Costs

Labour Costs$143,976
Parts Costs$229,356
Paint & Materials Costs$66,270
Sublet Costs$42,798
Total Costs$482,400


Estimates Produced631
Jobs631
Jobs Completed631
Working Days118
Hours Worked Per Day8
Production Workers (PW)5
Oct 20 to March 21AnalysisBenchmarks
Labour GP$169,145 
Labour % GP54.0%58%
Labour % of Total Sales43.0%46%
Parts GP$60,735 
Parts % GP 26.5%13%
Parts to Labour sales93%75%
P&M GP$3,910 
P&M % GP5.6%26%
P&M Cost % of Total Sales9.1%9%
Sublet GP$10,662 
Sublet % GP19.9%15%
Sublet % of Total Sales7.3%4%
Total GP$244,452 
GP % of Total Sales33.6%38%
Estimate Win Rate100.0%90%
Hours At Work4,720 
Hours sold3,479 
Hours sold % hours at work74%85%
Average Labour / Repair $496 
Average Parts / Repair$460 
Average P&M / Repair$111 
Average Sublet / Repair$85 
Average Value / Repair $1,153$2,387.00
Average # Jobs/Day5.3 
Total Sales$727,430 
Average Hrs/Job7.48 
Labour GP % Paintshop44.1%58%
Labour GP % Panelshop63.3%58%
Achieved Hourly Labour sale $$66.34 
Effective Hourly Labour Cost $$30.50 
Achieved Hourly Labour Margin $$35.84 
Paint Cost % Paint sales18.2%19%
Average Paint Sale per J/O$319.61$658.00
Sales Per Technician (Monthly)$24,247.67$35,149.00
Vehicles through Booth per Day5.33.6

Quick Check KPI