Question $1(10$ marks$)$:

$$

$$ RVW $($Restored Volkswagens$)$ buys $15$ used VW$\text{'}$s at each of two car auctions each week held at different locations. It then transports the cars to repair shops it contracts with. When they are restored to RVW$\text{'}$s specifications, RVW sells $10$ each to three different used car lots. There are various costs associated with the average purchase and transportation prices from each auction to each repair shop. Also there are transportation costs between the repair shops and from the repair shops to the used car lots. RVW is concerned with minimizing its total cost given the costs in the table below.

$$

$$

Repair Shops

$$

$$

Repair Shops

$$

$$

$$

Used Car Lots

$$

$$

S$1$

S$2$

$$

S$1$

S$2$

$$

L$1$

L$2$

L$3$

Auction $1$

$750$

$600$

S$1$

$-----$

$50$

S$1$

$300$

$350$

$550$

Auction $2$

$550$

$450$

S$2$

$50$

$------$

S$2$

$380$

$530$

$370$

$$

Formulate and solve a spreadsheet model for this transshipment problem. Insert $($copy and paste$)$ your solved$($spreadsheet$)$ model below:

How do we do it in excel $?$