Week 3 Case Study - On the tab labeled"Case Update I have...

This preview shows page 1 - 3 out of 3 pages.

On the tab labeled "Case Update", I have provided the modeling of Case 4.3 beginning on Pages 184. Carefully read the case in the textbook and then review the model to familiarize yourself with the integration of the LP into Excel. On the "Case Update" tab, there are five questions. After loading the ASPE solver, solve the model, obtain the sensitivity report, and use the sensitivity report to answer Questions 1 though 5. Each question is worth 16 points: 8 points for correctly identifying the cell value(s) you used from the sensitivity report to justify your response and 8 points for a clear, concise, grammatically response correctly answering the question. Your responses should be typed in unbolded black font right after the statement of each question. (HINT: If you have loaded the ASPE solver correctly, Cell N22 should reflect a total cost between $1.9M and $2.0M to fill this order) Remember, cases are individual work. Good luck and as always...HAVE FUN!
Microsoft Excel 15.0 Sensitivity ReportWorksheet: [c2_ch4_4.3 (2).xlsx]Case UpdateReport Created: 4/8/2015 11:44:06 PMEngine: Standard LP/QuadraticObjective Cell (Min)CellNameFinal Value$N$22Total Cost Buy Cost1902864.3128Decision Variable CellsFinalReducedObjectiveAllowableAllowableCellName

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture