(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)

What, if any, legal problems do you see with how this health insurance plan is being administered?  What should the plan administrator be doing differently?

The administrator of a group health insurance plan reports the following:

1) An employee has informed us that his divorce has been finalized. At his request, we have changed him to individual coverage.

2) An employee was terminated effective September 1, 2016. We sent notice of his right to elect continuation coverage on September 7, 2016. The employee failed to make payment by October 7, 2016, so his coverage under the health plan was ended.

3) To comply with changes in the law, we have instituted a uniform pre-existing condition exclusionary period of 12 months for all employees.

4) To keep costs low, we will limit employees with mental health problems to four therapist visits a year. We will discontinue providing health coverage to our retirees.

5) Due to the high costs associated with child birth, we will require that employees pay an extra $200 deductible before any child birth expenses are covered.

6) To resolve disputes over health insurance claims expeditiously, we are now requiring that any disputed claims be appealed within 30 days of the denial. We will maintain continuity and expedite the handling of appeals by having the same individuals decide both initial determinations and appeals.