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.

that all the surplus cars are sent where they are needed, and that each location needing cars receives at least five.

Formulate an LP model, then use Solver to create a Sensitivity Report for your model and answer the following questions.

$($a$)$ Is the optimal solution unique? How can you tell?

Some of the allowable increase or decrease values for the RHS values are zero, so there are alternate optimal solutions.

None of the allowable increase or decrease values for the RHS values are zero, so the optimal solution is unique.

None of the allowable increase or decrease values for the objective coefficients are zero, so the optimal solution is unique.

We cannot determine if the optimal solution is unique based on our sensitivity report because the solution is degenerate.

Some of the allowable increase or decrease values for the objective coefficients are zero, so there are alternate optimal solutions.

$($b$)$ Which location is receiving the fewest cars?

location $3$

location $4$

location $5$

location $6$

$($c$)$ Suppose a particular car at location $1$ must be sent to location $6$ in order to meet a customer's request. How much does this increase costs for the company $($in dollars$)?$

It increases costs by $

$].$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 $19$ and $17$ 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

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

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

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

Because $36$ surplus cars are available at locations $1$ and $2,$ and $40$ cars are needed at locations $3,4,5,$ and $6,$ some locations will not receive as many cars as they need. However, management wants to make sure that all the surplus cars are sent where they are needed, and that each location needing cars receives at least five.

Formulate an LP model, then use Solver to create a Sensitivity Report for your model and answer the following questions.

$($a$)$

Is the optimal solution unique? How can you tell?

Some of the allowable increase or decrease values for the RHS values are zero, so there are alternate optimal solutions.

None of the allowable increase or decrease values for the RHS values are zero, so the optimal solution is unique.

None of the allowable increase or decrease values for the objective coefficients are zero, so the optimal solution is unique.

We cannot determine if the optimal solution is unique based on our sensitivity report because the solution is degenerate.

Some of the allowable increase or decrease values for the objective coefficients are zero, so there are alternate optimal solutions.

$($b$)$

Which location is receiving the fewest cars?

location $3$

location $4$

location $5$

location $6$

$($c$)$

Suppose a particular car at location $1$ must be sent to location $6$ in order to meet a customer's request. How much does this increase costs for the company $($in dollars$)?$

It increases costs by $

$54$

Incorrect: Your answer is incorrect.

$.$

$($d$)$

Suppose location $5$ must have at least eight cars shipped to it$.$ What impact does this have on the optimal objective function value $($in dollars$)?($Enter your answer as a positive number.$)$

This will

raise

the total cost by $

$248$

Please Answer all questions $,$ thank you

USe Excel and Analytical Solver to answer the questions