Week 3 Student Team Project 2.2a only: Reconsider the Wyndoor glass case study introduced in Section 2.1 (the Excel file is provided in your CANVAS

(f) Use Solver to solve this model (to get the yellow decision cells and the orange total profit cell) by creating your Excel linear programming model with the information above and running Excel's Solver (Data tab > Solver)

see attachment

Week 3 Student Team Project2.2a only:Reconsider the Wyndoor glass case study introduced in Section 2.1 (the Excel file is provided in yourCANVAS Week 3 Team Project assignment, called "Wyndoor.xIsx". Suppose that the estimates for theunit profits for the two new products now have been revised to $600 profit for the doors and $300profit for the windows. Use Excel's Solver (Data tab > Solver) to solve this revised linear programmingmodel. (a) What is the new profit? (b) When you get the Solver Results dialog page, run a sensitivityreport (see below) and interpret the allowable increase and decrease for both the variable cells (doorsand windows produced) and the constraints (Plants 1,2, and 3). Sensitivity reports and interpretation arediscussed in the text on pp. 160-162.Variable CellsFinalReduced Objective Allowable AllowableCellNameValueCost Coefficientncrease Decrease$C$12Units Produced Doors$D$12Units Produced WindowsConstraintsFinalShadow ConstraintAllowable AllowableCellNameValuePriceR.H. Side Increase DecreaseSE$7Plant 1 Used$E$8Plant 2 UsedSE$9Plant 3 UsedOriginal File Needed: Wyndor.xls (found in chapter 2 textbook spreadsheets, also uploaded to theWeek 3 module in CANVAS).2.8You are given the following linear programming model (see below) in algebraic form, where x1and x2 are the decision variables and Z is the value of the overall measure of performance.The goal is to maximize the objective function Z = 3X1 + 2X2 subject to:Constraint on resource 1: 3x1 + X2 $9Constraint on resource 2: X1 + 2x2 $ 8And x1 and x2 are not negative, i.e., x1 2 0 and x2 2 0.(a) Identify the objective function (Z = ??), the functional constraints, and the nonnegativityconstraints in this model (see Hillier text pages 33-34 for a review).(b) Incorporate this model into a spreadsheet using the picture below as a guide for theExcel spreadsheet you develop: (the unit profit cells have been filled in for you to giveyou a start). Hint: There are SUMPRODUCT functions in the two "Resource Used" cells,and another SUMPRODUCT function in the "Total Profit" cell.X1X2Unit Profit32ResourceResourceResource UsageUsedAvailableResource 1Resource 2X1X2Total ProfitDecisionHint: to answer questions parts c, d, and e, substitute each X1 and X2 values in parts c, d, and e belowinto the constraints on resources 1 and 2 given above.(c ) Is (X1, X2) = (2,1) a feasible solution?(d) Is (X1, X2) = (2,3) a feasible solution?(e) Is (X1,X2) = (0, 5) a feasible solution?(f) Use Solver to solve this model (to get the yellow decision cells and the orange total profit cell) bycreating your Excel linear programming model with the information above and runningExcel's Solver (Data tab > Solver)