Use Excel Solver to create a Sensitivity Report for question 36 and answer the following questions.

1. Is the solution degenerate?
2. Is the solution unique?
3. If the per 1000 square feet cost of a two-month lease is decreased by $40, will it change our current optimal solution? What about the price being increased by $200? Specify the reason.
4. d. If 5000 more square feet are needed in month 5, without re-solving the problem, can you tell how much the total cost will increase?)

This is the question:

36. The Pelletier Corporation has just discovered that it will not have enough ware- house space for the next five months. The additional warehouse space requirements for this period are:

Month	1	2	3	4	5
Additional Space Needed per 1000	25	10	20	10	5

To cover its space requirements, the firm plans to lease additional warehouse space on a short-term basis. Over the next five 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 (months)	1	2	3	4	5
Cost per 1000 square feet	$300	$525	$775	$850	$975

This schedule of leasing options is available to Pelletier at the beginning of each of the next five 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 5) and lease 10,000 square feet for 2 months beginning in month 3 (at a cost of $525 10).

1. Formulate an LP model for this problem.
2. Create a spreadsheet model for this problem and solve it using Solver.
3. What is the optimal solution?