Speedy Lube has 4 bays in its shop and 3 cars waiting for an oil change.The estimated time (in minutes)to change the oil and filter for each car in each bay is given as follows:
$\begin{array}{llll}
\text { CarBay } & \mathrm{A}& \mathrm{B}&{\mathrm{C}} \
1 & 10 & 12 & 12 \
2 & 15 & 13 & 12 \
3 & 14 & 12 & 10 \
4 & 13 & 11 & 12
\end{array}$

Which car should be assigned to which bay if Speedy Lube wants to minimize its total service time? Use Excel to formulate and solve this problem.

Question

Speedy Lube has 4 bays in its shop and 3 cars waiting for an oil change.The estimated time (in minutes)to change the oil and filter for each car in each bay is given as follows:
 $\begin{array}{llll}
\text { CarBay } & \mathrm{A}& \mathrm{B}&{\mathrm{C}}  \
1 & 10 & 12 & 12 \
2 & 15 & 13 & 12 \
3 & 14 & 12 & 10 \
4 & 13 & 11 & 12
\end{array}$
 
Which car should be assigned to which bay if Speedy Lube wants to minimize its total service time? Use Excel to formulate and solve this problem.

Quizplus · Accepted Answer

The Answer of Speedy Lube has 4 bays in its shop and 3 cars waiting for an oil change.The estimated time (in minutes)to change the oil and filter for each car in each bay is given as follows:
 $\begin{array}{llll}
\text { CarBay } & \mathrm{A}& \mathrm{B}&{\mathrm{C}}  \
1 & 10 & 12 & 12 \
2 & 15 & 13 & 12 \
3 & 14 & 12 & 10 \
4 & 13 & 11 & 12
\end{array}$
 
Which car should be assigned to which bay if Speedy Lube wants to minimize its total service time? Use Excel to formulate and solve this problem.

Speedy Lube Has 4 Bays in Its Shop and 3