Precise Mechanical Repairs
Executive Dashboard · Live Data
Connecting to Google Sheets…
⚠ Could not load live data.

Precise Mechanical Repairs

EXECUTIVE PERFORMANCE DASHBOARD · LIVE DATA

Synced
4 Locations · Technicians · LIVE SYNC · Loading…
Total Revenue
Avg Car Service Value
Avg Dollar Efficiency
Target: 55%
Avg Hourly Efficiency
Target: 55%
Revenue Summary
Revenue by location · Labour · Parts · Tires · Subcontract · Selected Period
Revenue Summary by Location CHART
Selected period — quick visual
Revenue by Location & Category
Every revenue category, broken out per location  · 
Revenue Mix
Revenue share by location — selected period
Auto-Generated Insights
Performance Flag Report
Technicians Requiring Attention
Efficiency below 45% threshold
TechnicianLocationAvg Dollar EffIssueAction
Labour Revenue by Location
All months with data — updates automatically
Labour Revenue by Location CHART
Selected period — quick visual
Labour Gross Profit Margin %  TARGET/KPI
Gross profit ÷ revenue per location · monthly — green ≥target · amber near · red below
% Changes apply instantly
Labour Gross Profit Margin % CHART
Last 12 months — from every $1 earned
Parts Revenue by Location
All months with data
Parts Revenue by Location CHART
Selected period — quick visual
Parts Gross Profit Margin %  TARGET/KPI
Gross profit ÷ revenue per location · parts only — shop supplies & EPA excluded · monthly — green ≥target · amber near · red below
% Changes apply instantly
Parts Gross Profit Margin % CHART
Last 12 months — from every $1 earned
Tires Revenue by Location
All months with data
Tires Revenue by Location CHART
Selected period — quick visual
Tires Profit Margin % CHART
Last 12 months — from every $1 earned
Subcontract Revenue by Location
All months with data
Subcontract Revenue by Location CHART
Selected period — quick visual
Subcontract Profit Margin % CHART
Last 12 months — from every $1 earned
Efficiency Targets
%
%
Changes apply instantly to all charts, badges & insights below
Hourly Efficiency — by Technician
≥55% Strong 45–55% Good <45% Monitor <0% Flag · Target 55%
Hourly Efficiency by Location CHART
Green ≥ target · Blue near target · Red below
Dollar Sales Efficiency — by Location
≥55% Strong 45–55% Good <45% Monitor <0% Flag · Target 55%
Dollar Sales Efficiency by Location CHART
Green ≥ target · Blue near target · Red below
Dollar Sales Efficiency Trend CHART
Last 12 months with data · per location · independent of the period filter
Billable Hours by Location
Total billable hours for the selected period & location filter above
Billable Hours by Location CHART
Selected period — quick visual
Cars Serviced
Volume by location — monthly detail
Revenue Per Car
Total revenue ÷ cars serviced · monthly avg
Cars Serviced CHART
Total vehicles per location — selected period
Revenue Per Car CHART
Total revenue each visit generates — by location
🔒
Admin — Password Protected
Enter the password to view admin tools and wage data