An auto maintenance shop suddenly has more customers than it can
handle in a given day. The shop currently has one maintenance bay
and is considering adding additional bays. The current options are
to continue operations with 1 bay or expand to 2, 3, or 4 bays.
Each additional bay costs $10,000 per day. There is no cost for the
existing bay. Each day a random number of cars arrive and the
single bay serves as many cars as possible. The number of cars the
bay can handle each day is also random. If there are 10 or more
cars waiting to be served, the night crew is hired for $12,000 to
work on cars overnight. 10 of the cars are sent to the overnight
crew, all cars above 10 are sent to a competitor resulting in no
cost or revenue. Any of the 10 cars the night crew cannot handle
are added to the list for the next day. Revenues are generated for
each car served by the day crew and the night crew. Example: 45
cars arrive, the bay services 20 cars resulting in 25 cars waiting
to be serviced. 15 of the 25 are sent away and the remaining 10 are
left for the night crew. If the night crew works on 7, the final 3
cars are left for the next day.
DATA
The attached Excel file contains historical data for the auto
shop for the past 60 days. Use the data supplied to determine the
best distributions to use to model the system. The data includes
the following:
GOAL
An auto maintenance shop suddenly has more customers than it can handle in a given day. The shop currently has one maint
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
An auto maintenance shop suddenly has more customers than it can handle in a given day. The shop currently has one maint
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!