Question $16$

$($provide all your logic and calculations; besides, if you use Excel, upload your Excel to

Blackboard$)$

${?}^{}$ Subra Carwash company specializes in several customized services, including the following:

The car wash company specializes in customized packages as

Package $1$: includes only A

Package $2$: includes only A and B

Package $3$: includes only A$,$ B$,$ and C

Package $4$: consists of all four services $($A$,$ B$,$ C$,$ and D$)$

Cars arrive at a rate of $50$ per day. Of these, $45\%$ choose Package $1$; $10\%$ choose Package $2$;

$15\%$ choose Package $3$; and $30\%$ choose Package $4.$ The store operates $14$ hours a day.

a$.$ What is the implied utilization of all services?

b$.$ Which resource has the highest implied utilization? And why?

Subra anticipates that customer demand may increase next summer to $70$ customers daily.

Together with this growth, the composition of car arrivals is expected to change as $30\%$ choose

package $1,10\%$ choose package $2,10\%$ choose package $3,$ and $50\%$ choose package $4.$ The

company installs an additional machine to serve A $.$ The store plans to operate $10$ hours daily.

c$.$ What will be the new bottleneck in the process? And why?

d$.$ How many cars of which type are not served? Why? Explain your reasoning! $($use a

logic to serve more cars$)$

e$.$ Draw a flow process chart to show the processes and packages.

$($Assume that cars of non$-$integer values are acceptable for calculation purposes$)$