Final Project 1 - Microsoft Excel 16.0 Sensitivity Report Worksheet[Assignment 5]Sheet1 Report Created 5:35:53 PM Variable Cells Cell $B$5 $C$5 $D$5

Final Project 1 - Microsoft Excel 16.0 Sensitivity Report...

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

Microsoft Excel 16.0 Sensitivity ReportWorksheet: [Assignment 5.xlsx]Sheet1Report Created: 4/8/2016 5:35:53 PMVariable CellsFinalReducedObjectiveAllowableAllowableCellNameValueCostCoefficientIncreaseDecrease$B$5Number of pounds Powder A0.12501.330.23 1.00E+030$C$5Number of pounds Powder B00.231.561.0000E+0300.23$D$5Number of pounds Powder C00.852.181.0000E+0300.85$E$5Number of pounds Powder D01.222.551.0000E+0301.22ConstraintsFinalShadowConstraintAllowableAllowableCellNameValuePriceR.H. SideIncreaseDecrease$F$12Total Mix0.1251.330.125 0.2198275860.125$F$8Sodium0.502.31.0000E+0301.8$F$9Potassium1.262504.71.0000E+0303.4375$F$10 Riboflavin1.45041.0000E+0302.55$F$11 Sugars2.375037.51.0000E+03035.125
Background image
Microsoft Excel 16.0 Answer ReportWorksheet: [Assignment 5.xlsx]Sheet1Report Created: 4/8/2016 5:47:02 PMResult: Solver found a solution. All Constraints and optimality conditions are satisfied.Solver EngineEngine: Simplex LPSolution Time: 0.062 Seconds.Iterations: 2 Subproblems: 0Solver OptionsMax Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
Background image
Image of page 3

You've reached the end of your free preview.

Want to read all 7 pages?

  • Fall '13
  • pounds Powder

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture