Speedy Lube Has 4 Bays in Its Shop and 3

Essay

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.