20000 B37D37 Binding Microsoft Excel 160 Sensitivity Report Worksheet HW

20000 b37d37 binding microsoft excel 160 sensitivity

This preview shows page 5 - 6 out of 6 pages.

20000 $B$37=$D$37Binding0
Background image
Microsoft Excel 16.0 Sensitivity ReportWorksheet: [HW 2.xlsx]Sheet2Report Created: 2/2/2017 10:41:48 AMVariable CellsFinalReducedObjectiveAllowableAllowableCellNameValueCostCoefficientIncreaseDecrease$B$21Amounts P136666.666667020.1250.1$C$21Amounts P233333.333333020.10.125$D$21Amounts P350000020.22$E$21Amounts IP116666.66666700.10.1250.1$F$21Amounts IP200.20.1 1.00000E+0300.2$G$21Amounts IP31000000.1 1.00000E+030 1.00000E+030$H$21Amounts C16000002.5 1.00000E+030 0.0833333333$I$21Amounts C210000002.5 0.0833333333 0.2166666667$J$21Amounts C39000002.5 0.21666666672.5$K$21Amounts IC10 0.08333333330.15 1.00000E+030 0.0833333333$L$21Amounts IC20 0.21666666670.15 1.00000E+030 0.2166666667$M$21Amounts IC32000000.15 1.00000E+030 1.00000E+030ConstraintsFinalShadowConstraintAllowableAllowableCellNameValuePriceR.H. SideIncreaseDecrease$B$24Month 1 Demand Peanut Power LHS20000220000 6666.6666667 36666.666667$B$25Month 2 Demand Peanut Power LHS500002.150000 6666.6666667 16666.666667$B$26Month 3 Demand Peanut Power LHS40000240000 6666.666666750000$B$27Month 1 Demand Peanut Crunch LHS600002.5600001000060000$B$28Month 2 Demand Peanut Crunch LHS100000 2.56666666671000001000025000$B$29Month 3 Demand Peanut Crunch LHS700002.5700001000090000$B$30Peanuts Month 1 LHS460005000 1.00000E+030400$B$31Peanuts Month 2 LHS6000 -1.666666666760001000400$B$32Peanuts Month 3 LHS660007000 1.00000E+030400$B$33Baking Month 1 LHS1266.666666701500 1.00000E+030 233.33333333$B$34Baking Month 2 LHS1833.333333302000 1.00000E+030 166.66666667$B$35Baking Month 3 LHS185002000 1.00000E+030150$B$36Final Inventory Peanut Power LHS100002.110000 6666.666666710000$B$37Final Inventory Peanut Crunch LHS200002.65200001000020000
Background image

You've reached the end of your free preview.

Want to read all 6 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture