Auto Detailing Service
PK Village offers, in select locations, full car detailing services. Using a proprietary app, customers make reservations before 10:00PM for the next day. Upon dropping their vehicle for service, customers are offered transportation to destinations located within the service area (5 miles).
Customers are notified though the app when their vehicles are ready. They can then confirm pick-up time and location.
Reservations are taken for service starting at 6:30 AM. The last reservation is taken for 3:00 PM. Customers are promised to have their vehicles ready by 8:00 PM, Monday through Saturday. This service is not offered on Sundays.
PK Village offers six different types of detailing services. The estimated time to complete these services, as well as their observed percentages are shown in the table below.
Based on reliable forecasts, the manager of one of PK Village’s detailing shops is expecting the throughput shown below for the last week of January.
PK Village employs a mix of full and part-time detailers. Full time detailers work 8-hour shifts (including a one-hour beak) six days per week. Part time detailers work 4-hour shifts without break. On a fully-allocated basis, the hourly costs of full-time detailers is $11.75. Part-time detailers cost $17.50 per hour (approximately 50% more).
Service Price Man-Hours %
Platinum Plus $250 4.5 4
Platinum $225 4.0 9
Gold Plus $200 3.5 12
Gold $150 3.0 15
Silver Plus $100 2.5 20
Silver $50 1.5 40
Day Vehicles Day Vehicles
Monday 45 Thursday 27
Tuesday 37 Friday 50
Wednesday 35 Saturday 32
Deliverables:
Consulting document (letter) addressed to the operations manager of PK Village’s auto detailing shop (your client) including your staffing recommendation for the week being planned. The note should have sections (a) describing the opportunity or problem, (b) listing assumptions made in the analysis, and (c) explaining the methodology used, along with (d) justified recommendations. The most relevant recommendation is a staffing plan for the upcoming week (combination of full-time and part time detailers), justified on cost.
Excel spreadsheet with the cost estimate for all possible combinations of full-time and part-time employees.
Use proper business language.