Linear Programming_Solver_Statistics

profileselen7
Copyofhw2soln.xlsx
Home>Mathematics homework help>Statistics homework help>Linear Programming_Solver_Statistics

Sungram Problem

Sungram Problem
Decision Variables Jump Run Walk
Quantities 150 250 0
Profit $65 $75 $25
Constraints Total Used Stock
Wifi Module 1 1 0 400 <= 450
Cellular Module 0 1 0 250 <= 250
Heart Rate Monitor 2 2 1 800 <= 800
GPS Module 1 1 0 400 <= 450
LCD Screen 2 1 1 550 <= 600
Total Profit $28,500

Answer Report (Sungram)

Microsoft Excel 16.0 Answer Report
Worksheet: [hw2soln.xlsx]Sungram Problem
Report Created: 5/18/2019 10:34:28 PM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.015 Seconds.
Iterations: 2 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative
Objective Cell (Max)
Cell Name Original Value Final Value
$C$16 Total_Profit $0 $28,500
Variable Cells
Cell Name Original Value Final Value Integer
$C$6 Quantities Jump 0 150 Contin
$D$6 Quantities Run 0 250 Contin
$E$6 Quantities Walk 0 0 Contin
Constraints
Cell Name Cell Value Formula Status Slack
$G$10 Wifi Module Total Used 400 $G$10<=$I$10 Not Binding 50
$G$11 Cellular Module Total Used 250 $G$11<=$I$11 Binding 0
$G$12 Heart Rate Monitor Total Used 800 $G$12<=$I$12 Binding 0
$G$13 GPS Module Total Used 400 $G$13<=$I$13 Not Binding 50
$G$14 LCD Screen Total Used 550 $G$14<=$I$14 Not Binding 50

Sensitivity Report (Sungram)

Microsoft Excel 16.0 Sensitivity Report
Worksheet: [hw2soln.xlsx]Sungram Problem
Report Created: 5/18/2019 10:34:28 PM
Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$C$6 Quantities Jump 150 0 65 10 15
$D$6 Quantities Run 250 0 75 1E+30 10
$E$6 Quantities Walk 0 -7.5 25 7.5 1E+30
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$G$10 Wifi Module Total Used 400 0 450 1E+30 50
$G$11 Cellular Module Total Used 250 10 250 150 50
$G$12 Heart Rate Monitor Total Used 800 32.5 800 50 300
$G$13 GPS Module Total Used 400 0 450 1E+30 50
$G$14 LCD Screen Total Used 550 0 600 1E+30 50

Braxton(a)

Braxton Oil Company COLOR KEY Decision Variables
Constraints
Decisions Objective
Crude 1 Crude 2 Crude 3 Crude 4 Output Required Prices
Reg 1068.75 356.25 0.00 0.00 1425 <= 1500 8.50
Mul 31.25 231.25 737.50 0.00 1000 <= 1000 9.00
Prem 0.00 512.50 212.50 275.00 1000 <= 1000 10.00
Extreme 0.00 0.00 150.00 600.00 750 <= 750 10.50
Total 1100 1100 1100 875
<= <= <= <=
1100 1100 1100 1100
Objective Profit
costs 7.10 8.50 7.70 9.00 5482.50
prices 8.50 9.00 10.00 10.50
Data
Index 20 40 30 55
Constraints for blend (demands and supply capacities are modeled above)
Blends LHS RHS
Reg -5 15 5 30 -0.00 >= 0
Mul -12 8 -2 23 -0.00 >= 0
Prem -22 -2 -12 13 -0.00 >= 0
Ext -30 -10 -20 5 0.00 >= 0
Blending Data (not a constraint)
Blends Actual Target
Reg 20 40 30 55 25 25
Mul 20 40 30 55 32 32
Prem 20 40 30 55 42 42
Ext 20 40 30 55 50 50

Braxton(b)

Braxton Oil Company COLOR KEY Decision Variables
Constraints
Decisions Objective
Crude 1 Crude 2 Crude 3 Crude 4 Output Required Prices
Reg 1012.50 487.50 0.00 0.00 1500 "=" 1500 8.50
Mul 87.50 287.50 625.00 0.00 1000 "=" 1000 9.00
Prem 0.00 75.00 475.00 450.00 1000 "=" 1000 10.00
Extreme 0.00 250.00 0.00 500.00 750 "=" 750 10.50
Total 1100 1100 1100 950 Change demand constraints to =
<= <= <= <=
1100 1100 1100 1100
Objective Profit
costs 7.10 8.50 7.70 9.00 5445.00
prices 8.50 9.00 10.00 10.50
Data
Index 20 40 30 55
Constraints for blend (demands and supply capacities are modeled above)
Blends LHS RHS
Reg -5 15 5 30 2250.00 >= 0
Mul -12 8 -2 23 0.00 >= 0
Prem -22 -2 -12 13 0.00 >= 0
Ext -30 -10 -20 5 -0.00 >= 0
Blending Data (not a constraint)
Blends Actual Target
Reg 20 40 30 55 26.5 25
Mul 20 40 30 55 32 32
Prem 20 40 30 55 42 42
Ext 20 40 30 55 50 50

Braxton(c)

Braxton Oil Company COLOR KEY Decision Variables
Constraints
Decisions Objective
Crude 1 Crude 2 Crude 3 Crude 4 Output Required Prices
Reg 975.00 525.00 0.00 0.00 1500 >= 1500 8.50
Mul 125.00 325.00 550.00 0.00 1000 >= 1000 9.00
Prem 0.00 250.00 370.00 380.00 1000 >= 1000 10.00
Extreme 0.00 0.00 180.00 720.00 900 >= 750 10.50
Total 1100 1100 1100 1100 Change demand constraints to >=
<= <= <= <=
1100 1100 1100 1100
Objective Profit
costs 7.10 8.50 7.70 9.00 5670.00
prices 8.50 9.00 10.00 10.50
Data
Index 20 40 30 55
Constraints for blend (demands and supply capacities are modeled above)
Blends LHS RHS
Reg -5 15 5 30 3000.00 >= 0
Mul -12 8 -2 23 0.00 >= 0
Prem -22 -2 -12 13 0.00 >= 0
Ext -30 -10 -20 5 0.00 >= 0
Blending Data (not a constraint)
Blends Actual Target
Reg 20 40 30 55 27 25
Mul 20 40 30 55 32 32
Prem 20 40 30 55 42 42
Ext 20 40 30 55 50 50