3. SOLUTIONS ADM2302 Assignment2 S17 Prob 1-3.xlsx - Microsoft Excel 14.0 Answer Report Worksheet[Assignment 1 Solution 1st problem]Toy maker Report

3. SOLUTIONS ADM2302 Assignment2 S17 Prob 1-3.xlsx -...

This preview shows page 1 - 4 out of 12 pages.

Microsoft Excel 14.0 Answer ReportWorksheet: [Assignment 1 Solution 1st problem.xlsx]Toy makerReport Created: 9/11/2015 10:28:46 PMResult: Solver found a solution. All Constraints and optimality conditions are satisfied.Solver EngineEngine: Simplex LPSolution Time: 0 Seconds.Iterations: 2 Subproblems: 0Solver OptionsMax Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic ScalingMax Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegatiObjective Cell (Max)CellNameOriginal ValueFinal Value$D$5Profit Total Profit 156,000.00 ###Variable CellsCellNameOriginal ValueFinal ValueInteger$B$3Solution Police Cars4800.004800.00 Contin$C$3Solution Fire Trucks2400.002400.00 ContinConstraintsCellNameCell ValueFormulaStatusSlack$D$11Demand LHS0.000 $D$11>=$F$11Binding0.000$D$8Wood LHS19200.000 $D$8<=$F$8Not Binding6800$D$9Plastic LHS36000.000 $D$9<=$F$9Binding0$D$10Production capacity (time) LHS4000.000 $D$10<=$F$10Not Binding2000
Background image
tive
Background image
Microsoft Excel 14.0 Sensitivity ReportWorksheet: [Assignment 1 Solution 1st problem.xlsx]Toy makerReport Created: 9/11/2015 10:28:46 PMVariable CellsFinalReducedObjectiveAllowableAllowableCellNameValueCostCoefficientIncreaseDecrease$B$3Solution Police Cars48000203032.5$C$3Solution Fire Trucks2400025 1.000E+03015ConstraintsFinalShadowConstraintAllowableAllowableCellNameValuePriceR.H. SideIncreaseDecrease$D$11
Background image
Image of page 4

You've reached the end of your free preview.

Want to read all 12 pages?

  • Fall '05
  • EL
  • LHS

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes