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
tive
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

#### You've reached the end of your free preview.

Want to read all 12 pages?

• Fall '05
• EL
• LHS