(e) Is (X1,X2) = (0, 5) a feasible solution?

see attachment

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 Week 3 Team Project assignment, called "Wyndoor.xIsx". Suppose that the estimates for the unit profits for the two new products now have been revised to $600 profit for the doors and $300 profit for the windows. Use Excel's Solver (Data tab Solver) to solve this revised linear programming model. (a) What is the new profit? (b) When you get the Solver Results dialog page, run a sensitivity report (see below) and interpret the allowable increase and decrease for both the variable cells (doors and windows produced) and the constraints (Plants 1,2, and 3). Sensitivity reports and interpretation are discussed in the text on pp. 160-162. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficientncrease Decrease $C$12 Units Produced Doors $D$12 Units Produced Windows Constraints Final Shadow ConstraintAllowable Allowable Cell Name Value Price R.H. Side Increase Decrease SE$7 Plant 1 Used $E$8 Plant 2 Used SE$9 Plant 3 Used Original File Needed: Wyndor.xls (found in chapter 2 textbook spreadsheets, also uploaded to the Week 3 module in CANVAS). 2.8 You are given the following linear programming model (see below) in algebraic form, where x1 and 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 $9 Constraint on resource 2: X1 + 2x2 $ 8 And 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 nonnegativity constraints 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 the Excel spreadsheet you develop: (the unit profit cells have been filled in for you to give you a start). Hint: There are SUMPRODUCT functions in the two "Resource Used" cells, and another SUMPRODUCT function in the "Total Profit" cell. X1 X2 Unit Profit 3 2 Resource Resource Resource Usage Used Available Resource 1 Resource 2 X1 X2 Total Profit Decision Hint: to answer questions parts c, d, and e, substitute each X1 and X2 values in parts c, d, and e below into 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) by creating your Excel linear programming model with the information above and running Excel's Solver (Data tab Solver)