Use Solver to create a Sensitivity Report for question $34$ at the end of chapter $3$ and answer the following questions.

The Pelletier Corporation has just discovered that it will not have enough warehouse space for the next $5$ months. The additional warehouse space requirements for this period are listed in the following table:

To cover its space requirements, the firm plans to lease additional warehouse space on a short$-$term basis. Over the next $5$ months, a local warehouse has agreed to lease Pelletier any amount of space for any number of months according to the following cost schedule.

This schedule of leasing options is available to Pelletier at the beginning of each of the next $5$ months. For example, the company could elect to lease $5,000$ square feet for $4$ months beginning in month $1($at a cost of $850\backslash$times $5)$ and lease $10,000$ square feet for $2$ months beginning in month $3($at a cost of $525\backslash$times $10).$

Formulate an LP model for this problem.

Create a spreadsheet model for this problem and solve it using Solver.

What is the optimal solution?

A$.$ Is the solution degenerate?

B$.$ Is the solution unique?