I ONLY NEED ANSWERS TO E F AND G

Problem 5. The Whitt Window Company, a company with three plants, makes two different kinds of hand-crafted windows: a wood-framed window and an aluminum-framed window. Plant 1 makes wood frames. Plant 2 makes aluminum frames. Plant 3 assembles both wood-framed windows and aluminum-framed windows. Suppose Plant 1 can spend 6 hours per week in making wood-frames, Plant 2 can spend 4 hours per week in making aluminum frames, and Plant 3 can spend 48 hours per week to assemble windows. It takes one hour of Plant 1 and six hours of Plant 3 to produce one thousand wood-framed windows. It takes one hour of Plant 2 and eight hours of Plant 3 to produce one thousand aluminum-framed windows. The company earns $300 revenue for selling one thousand wood-framed window and $150 revenue for selling one thousand aluminum-framed window. The company wishes to determine how many windows of each type to produce per week to maximize the total revenue. 14 1 0 1 0 (a) (3pt) Formulate a linear program for this problem. (b) (2pt] Let 13, 14, and 25 denote the slack variables for the constraints of the primal LP in part (a). After we apply the simplex method, the final simplex tableau is: Basic Var.2 21 22 25 RHS Z 100 187.5 0 18.75 2025 0 1 0 6 0 0 0 0.75 1 -0.125 2.5 0 0 1 -0.75 0 0.125 1.5 What is the optimal solution? (c) [2pt] Suppose the mumber of available working hours of Plant 3 increases from 48 to 54. Write down the new optimization problem and update the corresponding simplex tableau, using the matrix form of LP. (d) (2pt] Does the updated simplex tableau give an optimal CPF solution of the new optimization problem? If so, explain why, and write down the optimal CPF solution; if not, find the new optimal solution by utilizing the matrix form of LP. 14 22 (e) [2pt] After using Excel to solve the problem, the sensitivity report is the following: Variable Cells Cell Name $B$10 Wood-Framed Windows (in thousands) $B$11 Aluminum-Framed Windows (in thousands) Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 6 0 300 1E+30 187.5 1.5 0 150 250 150 Constraints Name Cell $B$19 Plant 1 Hours $B$20 Plant 2 Hours $B$21 Plant 3 Hours Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 6 187.5 6 2 3.333333333 1.5 0 4 1E+30 2.5 18.75 48 20 48 12 Please explain the meaning of the two "allowable increase" in the " variable cells part and "constraints" part 6 respectively. You can use one row as an example for each part. Your explanation should involve the numbers in the table. () [2pt] If the number of available working hours of Plant 3 increases from 48 to 60. What will be the optimal value of the new problem? Describe how you compute this new value, just by looking at the sensitivity report. You are not allowed to use computer. (9) [2pt] What business insights can you obtain based on this table? Write at least two of them. Your answer may include the analysis, but you should highlight the sentences that can be understood by someone who has not learned any linear program before these sentences are the ones that appear in a report to the manager, thus are important). Remark: No computer/software is needed in this