Vehicle Repair Dashboard




🚗 Vehicle Service & Repair Dashboard Analysis
🔧 1. Workshop/Supplier Performance
Top Performer: Mecho Auto Tech handled 43 repairs/services (43.43%), leading the supplier chart. Dominated with 30 Routine and 14 Repair services.
Runner-Up: Adhoc (Others) followed closely with 34 services, mostly Routine (28).
Low-Activity Vendors: Mikano, Elizade (JAC), and Affordable Cars — only 1 record each.
Insight: Heavy reliance on 2 providers. Diversify to mitigate vendor concentration risk.
🚘 2. Vehicle Repair/Service Insights
Service Types:
- Repair: 73.74%
- Routine Service: 25.25%
- Routine: 1.01% (negligible)
Top Brands Requiring Repairs:
- JAC: 38 cases, mostly serviced by 5Speed Tech.
- Mini Van: 18 repairs — serviced by Mecho Auto Tech.
- Nissan Models: Almera, Pick Up, and Kicks show consistent issues.
Observation: JAC repairs heavily rely on a single workshop — vendor dependency risk.
📊 3. Service Trends in 2024
Repair Trend: Noticeable spike mid-year (July–August).
Routine Services: Fluctuate at low levels — preventive maintenance underutilized.
Operational Risk: Reactive maintenance dominates. This is inefficient and cost-intensive.
📌 Strategic Recommendations
- Boost Preventive Maintenance: Increase Routine/Routine Service activities to avoid unplanned repairs.
- Balance Vendor Load: Reduce dependency on Mecho Auto Tech and Adhoc. Onboard and empower alternatives.
- JAC & Mini Van Analysis: High repair frequency — investigate usage patterns or quality issues.
- Monitor Monthly Trends: Use monthly data to forecast and reduce peak maintenance pressure.
🧠 Executive Summary
| Metric | Top Performer / Insight |
|---|---|
| 🛠️ Most Used Workshop | Mecho Auto Tech (43 services) |
| 🚗 Most Serviced Vehicle | JAC (38 repairs, serviced by 5Speed Tech.) |
| 🔧 Dominant Service Type | Repairs (73%) – preventive services are lagging |
| 📉 Underutilized Vendors | Affordable Cars, Mikano, Elizade |
| 📈 Trend Observation | Repair peaks mid-year; preventive efforts are minimal |




















