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 weekly costs of full-time detailers is $564. Part-time detailers cost $70 per four-hour shift.

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. This file is not accessible to your client.