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

The Pelletier Corporation has just discovered that it will not have enough warehouse space for the next five months. The additional warehouse space requirements for this period are listed in the following table: Month 1 2 3 4 5 Additional Space Needed (in 1,000 sq ft) 25 10 20 10 5 To cover its space requirements, the firm plans to lease additional ware ouse space on a short-term basis. Over the next five months, a local warehouse has agreed to lease Pelletierany amount of space for any number of months according to the following cost schedule. Length of Lease (in months) 1 2 3 4 5 Cost per 1,000 square feet 5310 $530 $760 $870 5965 This schedu e 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 forfour months beginning in month 1. (at a cost of $870 x S) and lease 10,000 square feet for two montis beginning in month 3 (at a cost of $530 x 10). Formulate an LP model, then use Solver to create a Sensitivity Report for your model and answer the following questions. (a) Is the solution degenerate? Yes C) No ./ (b) Is the solution unique? 0 None of the allowable increase or decrease values for the objective coefficients are zero, so the optimal solution is unique. Q) We cannot determine if the optimal solution is unique based on our sensitivrtv report because the solution is degenerate. 0 None of the allowable increase or decrease values for the RHS values are zero, so the optimal solution is unique. a) Some of the allowable increase or decrease values for the RHS values are zero, so there are alternate optimal solutions. 0 Some of the allowable increase or decrease values for the objective coefficients are zero] so there are alternate optimal solutions. @ Use a Solver Table to determine the maximum price (in dollars per 1,000 square feet) the Pelletier Corporation should be willing to pay for a tonmonth lease. (Hint: Add a constraint that forces the total amount of square footage leased for two months to be nonnegative. Vary the cost per 1,000 square feet between $400 and $500 at $1 intervals (101 major axis points). Round your answer to the nearest integer.) 3;: per 1,000 square feet (d) Suppose the company is not certain that it Will need exactly 20,000 sq. ft. in month 3 and believes that actual amount needed may be as low as 15,000 sq ft or as high as 25,000 sq. ft. Use a Solver Tabe to determine if this would have any impact on the leasing arrangements the company selects in months 1 and 2. O The leasing arrangements for months 1 and 2 change for every additional 1,000 sq ft added, seemingly at random. 0 When the amount needed is close to 15,000 sq ft, the solution uses 1 month, 2 month, and 3 month leases in months 1 and 2, but switches to using 1 month, 4 month, and 5 month leases as the amount needed approaches 25,000 sq ft. 0 When the amount needed is close to 15,000 sq ft, the solution uses 1 month, 4 month, and 5 month leases in months 1 and 2, but switches to using 1 month, 2 month, and 3 month leases as the amount needed approaches 25,000 sq ft. The leasing arrangements for months 1 and 2 do not change within this region. Q When the amount needed is at or below 20,000 sq ft, the leasing arrangements for months 1 and 2 do not change, but above 20,000 sq ft there are no feasible solutions to the LP. C. Write lease cost from 420 to 426 with the increment of 1. Amount leased can be calculated by using formula =|F(PsiOptStatus(B18)=0,Psi0ptValue($D $11,318), "Error") ln cell D18 and drag the same formula up to cell D23. To obtain the table, go to Analytic solver platform > Optimize > Solve complete problem. The obtained table is shown below: 2Month Amount Scenario Lease Cost Leased 1 420 10 2 421 10 3 422 10 4 423 10 5 425 10 6 426 0