Speedy Lube Has 4 Bays in Its Shop and 3

question 25

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.

---

Definitions:

Cash Loan

A financial agreement where a borrower receives a specific amount of cash from a lender and agrees to repay it, with interest, over a set period.

Interest to be Collected

The amount of interest income that has been earned but not yet received in cash.

Cash Loan

A short-term loan provided to a borrower in cash, meant to be repaid with interest over a predetermined period.

Interest Collected

The amount of interest payments received by a lender from a borrower over a specified period of time.