The writer is very fast, professional and responded to the review request fast also. Thank you.
Presentation/PPT
27/08/2022
(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: 3×1 + X2 $9Constraint on resource 2: X1 + 2×2 $ 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)
Show more
The writer is very fast, professional and responded to the review request fast also. Thank you.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more