Use this question $34$ to answer question $23$ 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:

Month $12345$

Additional Space Needed

$($in $1,000$ sq ft$)251020105$

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.

Length of Lease $($in months$)12345$

Cost per $1,000$ square feet $$300$ $$525$ $$775$ $$850$ $$975$

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 $85035)$ and lease $10,000$ square feet for $2$ months beginning in month $3($at a cost of $525310).$

a$.$ Formulate an LP model for this problem.

b$.$ Create a spreadsheet model for this problem and solve it using Solver. c$.$ What is the optimal solution?

$23$ Use Solver to create a Sensitivity Report for question $34$ at the end of chapter $3$ and

answer the following questions.

a$.$ Is the solution degenerate?

b$.$ Is the solution unique?