Submit a Microsoft Excel file with your Linear Optimization solution $($LP Solution with Excel Solver$)$ to the Rent$-$A$-$Dent problem using the template provided:

Hint: The optimal solution for the problem is $$908.$

The Rent$-$A$-$Dent car rental company allows its customers to pick up a rental car at one location

and return it to any of its locations. Currently, two locations $(1$ and $2)$ have $26$ and $18$ surplus

cars, respectively, and four locations $(3,4,5,$ and $6)$ each need $10$ cars. The costs of moving the

surplus cars from locations $1$ and $2$ to the other locations are summarized in the following table.

Costs of Transporting Cars Between Locations

Location $3$ Location $4$ Location $5$ Location $6$

Location $1$ $$54$ $$17$ $$23$ $$30$

Location $2$ $$24$ $$18$ $$19$ $$31$

Create a spreadsheet model for this problem and find the optimal solution using Solver.