Develop a LP and spreadsheet model for Problem $23$ at the end of Chapter $3$ in the Ragsdale portion of your book.

$23.$ 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 $16$ and $18$ surplus cars, respectively, and four locations $(3,4,5,$ and $6)$ each need $10$ cars. The costs of getting the surplus cars from locations $1$ and $2$ to the other locations are summarized in the following table.

Costs of Transporting Cars Between

Locations

$\backslash$table$[[$Location $3,$Location,Location,Location,$],[,4,5,6,],[$Location $1,$$$54,$$$17,$$$23,$$$30$