. The Newcoat Painting Company has for some time been experiencing high demand for its automobile repainting service. Because it has had to turn away business, management is concerned that the limited space available to store cars awaiting painting has cost them in lost revenue. A small vacant lot next to the painting facility has recently been made available for rental on a long-term basis at a cost of $10 per day. Management believes that each lost customer costs $20 in profit. Current demand is estimated to be 21 cars per day with exponential interarrival times (including those turned away), and the facility can service at an exponential rate of 24 cars per day. Cars are processed on a FCFS basis. Waiting space is now limited to 9 cars but can be increased to 20 cars with the lease of the vacant lot.Newcoat wants to determine whether the vacant lot should be leased. Management also wants to know the expected daily lost profit due to turning away customers if the lot is leased. Only one car can be painted at a time. Try using the Limited Queue Template.xlsm file for an analytical solution and the Multiserver Simulation.xlsm file for a simulation solution
. The Newcoat Painting Company has for some time
been experiencing high demand for its automobile
repainting service. Because it has had to turn away business, management is concerned that the limited space
available to store cars awaiting painting has cost them
in lost revenue. A small vacant lot next to the painting
facility has recently been made available for rental on a
long-term basis at a cost of $10 per day. Management
believes that each lost customer costs $20 in profit.
Current demand is estimated to be 21 cars per day with
exponential interarrival times (including those turned
away), and the facility can service at an exponential
rate of 24 cars per day. Cars are processed on a FCFS
basis. Waiting space is now limited to 9 cars but can
be increased to 20 cars with the lease of the vacant lot.Newcoat wants to determine whether the vacant lot
should be leased. Management also wants to know the
expected daily lost profit due to turning away customers if the lot is leased. Only one car can be painted at
a time. Try using the Limited Queue Template.xlsm
file for an analytical solution and the Multiserver
Simulation.xlsm file for a simulation solution
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
