Scribd
Upload
16 views39 pages

Metron Truck

The Microsoft Excel Solver found a solution for the optimization problem, confirming that all constraints and optimality conditions are satisfied. The objective cell, representing contribution, has a final value of -8,600,000, with variable cells T101 and T102 both remaining at 0. The report includes details on constraints, variable cells, and sensitivity analysis, indicating binding and non-binding statuses.

Uploaded by

vvaibhavshankar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
16 views39 pages

Metron Truck

The Microsoft Excel Solver found a solution for the optimization problem, confirming that all constraints and optimality conditions are satisfied. The objective cell, representing contribution, has a final value of -8,600,000, with variable cells T101 and T102 both remaining at 0. The report includes details on constraints, variable cells, and sensitivity analysis, indicating binding and non-binding statuses.

Uploaded by

vvaibhavshankar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 39

Microsoft Excel 16.

0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:15:04
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.015 Seconds.
Iterations: 0 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 NonNegati

Objective Cell (Max)


Cell Name Original Value Final Value
$J$5 contribution -8600000 -8600000

Variable Cells
Cell Name Original Value Final Value Integer
$E$7 T101 0 0 Contin
$F$7 T102 0 0 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$G$9 EA LHS 4000 $G$9<=$I$9 Binding 0
$G$10 MS LHS 6000 $G$10<=$I$10 Binding 0
$G$11 101A LHS 4000 $G$11<=$I$11 Not Binding 1000
$G$12 102A LHS 3000 $G$12<=$I$12 Not Binding 1500
itions are satisfied.

matic Scaling
e 1%, Assume NonNegative
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:15:04

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$E$7 T101 0 0 0 0 1E+030
$F$7 T102 0 0 0 0 1E+030

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$G$9 EA LHS 4000 0 4000 1E+030 0
$G$10 MS LHS 6000 0 6000 1E+030 0
$G$11 101A LHS 4000 0 5000 1E+030 1000
$G$12 102A LHS 3000 0 4500 1E+030 1500
Microsoft Excel 16.0 Limits Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:15:04

Objective
Cell Name Value
$J$5 contribution -8600000

Variable Lower Objective Upper Objective


Cell Name Value Limit Result Limit Result
$E$7 T101 0 0 -8600000 #N/A #N/A
$F$7 T102 0 0 -8600000 #N/A #N/A
Microsoft Excel 16.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:18:15
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.015 Seconds.
Iterations: 0 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 NonNegati

Objective Cell (Max)


Cell Name Original Value Final Value
$J$5 contribution -8600000 -8600000

Variable Cells
Cell Name Original Value Final Value Integer
$E$7 T101 0 0 Contin
$F$7 T102 0 0 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$G$9 EA LHS 4000 $G$9<=$I$9 Binding 0
$G$10 MS LHS 6000 $G$10<=$I$10 Binding 0
$G$11 101A LHS 4000 $G$11<=$I$11 Not Binding 1000
$G$12 102A LHS 3000 $G$12<=$I$12 Not Binding 1500
$G$9 EA LHS 4000 $G$9<=$I$9 Binding 0
$G$10 MS LHS 6000 $G$10<=$I$10 Binding 0
$G$11 101A LHS 4000 $G$11<=$I$11 Not Binding 1000
$G$12 102A LHS 3000 $G$12<=$I$12 Not Binding 1500
itions are satisfied.

matic Scaling
e 1%, Assume NonNegative
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:18:15

Variable Cells
Final Reduced Objective Allowable
Cell Name Value Cost Coefficient Increase
$E$7 T101 0 0 0 0
$F$7 T102 0 0 0 0

Constraints
Final Shadow Constraint Allowable
Cell Name Value Price R.H. Side Increase
$G$9 EA LHS 4000 0 4000 1E+030
$G$10 MS LHS 6000 0 6000 1E+030
$G$11 101A LHS 4000 0 5000 1E+030
$G$12 102A LHS 3000 0 4500 1E+030
$G$9 EA LHS 4000 0 4000 1E+030
$G$10 MS LHS 6000 0 6000 1E+030
$G$11 101A LHS 4000 0 5000 1E+030
$G$12 102A LHS 3000 0 4500 1E+030
Allowable
Decrease
1000000000000000000000000000000.00
1E+030

Allowable
Decrease
0
0
1000
1500
0
0
1000
1500
Microsoft Excel 16.0 Limits Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:18:16

Objective
Cell Name Value
$J$5 contribution -8600000

Variable Lower Objective Upper Objective


Cell Name Value Limit Result Limit Result
$E$7 T101 0 0 -8600000 #N/A #N/A
$F$7 T102 0 0 -8600000 #N/A #N/A
Microsoft Excel 16.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:20:16
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0 Seconds.
Iterations: 0 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 NonNegati

Objective Cell (Max)


Cell Name Original Value Final Value
$J$5 contribution -8600000 -8600000

Variable Cells
Cell Name Original Value Final Value Integer
$E$7 T101 0 0 Contin
$F$7 T102 0 0 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$G$9 EA LHS 4000 $G$9<=$I$9 Binding 0
$G$10 MS LHS 6000 $G$10<=$I$10 Binding 0
$G$11 101A LHS 4000 $G$11<=$I$11 Not Binding 1000
$G$12 102A LHS 3000 $G$12<=$I$12 Not Binding 1500
itions are satisfied.

matic Scaling
e 1%, Assume NonNegative
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:20:16

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$E$7 T101 0 0 0 0 1E+030
$F$7 T102 0 0 0 0 1E+030

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$G$9 EA LHS 4000 0 4000 1E+030 0
$G$10 MS LHS 6000 0 6000 1E+030 0
$G$11 101A LHS 4000 0 5000 1E+030 1000
$G$12 102A LHS 3000 0 4500 1E+030 1500
Microsoft Excel 16.0 Limits Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:20:16

Objective
Cell Name Value
$J$5 contribution -8600000

Variable Lower Objective Upper Objective


Cell Name Value Limit Result Limit Result
$E$7 T101 0 0 -8600000 #N/A #N/A
$F$7 T102 0 0 -8600000 #N/A #N/A
Microsoft Excel 16.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:20:44
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0 Seconds.
Iterations: 0 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 NonNegati

Objective Cell (Max)


Cell Name Original Value Final Value
$J$5 contribution -8600000 -8600000

Variable Cells
Cell Name Original Value Final Value Integer
$E$5 contribution 3000 0 Contin
$F$5 contribution 5000 0 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$G$9 EA LHS 4000 $G$9<=$I$9 Binding 0
$G$10 MS LHS 6000 $G$10<=$I$10 Binding 0
$G$11 101A LHS 4000 $G$11<=$I$11 Not Binding 1000
$G$12 102A LHS 3000 $G$12<=$I$12 Not Binding 1500
itions are satisfied.

matic Scaling
e 1%, Assume NonNegative
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:20:44

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$E$5 contribution 0 0 0 0 1E+030
$F$5 contribution 0 0 0 0 1E+030

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$G$9 EA LHS 4000 0 4000 1E+030 0
$G$10 MS LHS 6000 0 6000 1E+030 0
$G$11 101A LHS 4000 0 5000 1E+030 1000
$G$12 102A LHS 3000 0 4500 1E+030 1500
Microsoft Excel 16.0 Limits Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:20:44

Objective
Cell Name Value
$J$5 contribution -8600000

Variable Lower Objective Upper Objective


Cell Name Value Limit Result Limit Result
$E$5 contribution 0 0 -8600000 #N/A #N/A
$F$5 contribution 0 0 -8600000 #N/A #N/A
Microsoft Excel 16.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:28:24
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.031 Seconds.
Iterations: 0 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 NonNegati

Objective Cell (Max)


Cell Name Original Value Final Value
$G$5 contribution 0 0

Variable Cells
Cell Name Original Value Final Value Integer
$E$5 contribution 3000 0 Contin
$F$5 contribution 5000 0 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$G$9 EA LHS 0 $G$9<=$I$9 Not Binding 4000
$G$10 MS LHS 0 $G$10<=$I$10 Not Binding 6000
$G$11 101A LHS 0 $G$11<=$I$11 Not Binding 5000
$G$12 102A LHS 0 $G$12<=$I$12 Not Binding 4500
itions are satisfied.

matic Scaling
e 1%, Assume NonNegative
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:28:24

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$E$5 contribution 0 0 0 0 1E+030
$F$5 contribution 0 0 0 0 1E+030

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$G$9 EA LHS 0 0 4000 1E+030 4000
$G$10 MS LHS 0 0 6000 1E+030 6000
$G$11 101A LHS 0 0 5000 1E+030 5000
$G$12 102A LHS 0 0 4500 1E+030 4500
Microsoft Excel 16.0 Limits Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:28:24

Objective
Cell Name Value
$G$5 contribution 0

Variable Lower Objective Upper Objective


Cell Name Value Limit Result Limit Result
$E$5 contribution 0 0 0 #N/A #N/A
$F$5 contribution 0 0 0 #N/A #N/A
Microsoft Excel 16.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:30:31
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.031 Seconds.
Iterations: 0 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 NonNegati

Objective Cell (Max)


Cell Name Original Value Final Value
$G$5 contribution 0 0

Variable Cells
Cell Name Original Value Final Value Integer
$E$7 T101 0 0 Contin
$F$7 T102 0 0 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$G$9 EA LHS 0 $G$9<=$I$9 Not Binding 4000
$G$10 MS LHS 0 $G$10<=$I$10 Not Binding 6000
$G$11 101A LHS 0 $G$11<=$I$11 Not Binding 5000
$G$12 102A LHS 0 $G$12<=$I$12 Not Binding 4500
itions are satisfied.

matic Scaling
e 1%, Assume NonNegative
Microsoft Excel 16.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:31:16
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.031 Seconds.
Iterations: 3 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 NonNegati

Objective Cell (Max)


Cell Name Original Value Final Value
$G$5 contribution 0 11000000

Variable Cells
Cell Name Original Value Final Value Integer
$E$7 T101 0 2000 Contin
$F$7 T102 0 1000 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$G$9 EA LHS 4000 $G$9<=$I$9 Binding 0
$G$10 MS LHS 6000 $G$10<=$I$10 Binding 0
$G$11 101A LHS 4000 $G$11<=$I$11 Not Binding 1000
$G$12 102A LHS 3000 $G$12<=$I$12 Not Binding 1500
itions are satisfied.

matic Scaling
e 1%, Assume NonNegative
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:31:16

Variable Cells
Final Reduced Objective
Cell Name Value Cost Coefficient
$E$7 T101 2000 0 3000
$F$7 T102 1000 0 5000

Constraints
Final Shadow Constraint
Cell Name Value Price R.H. Side
$G$9 EA LHS 4000 2000 4000
$G$10 MS LHS 6000 500 6000
$G$11 101A LHS 4000 0 5000
$G$12 102A LHS 3000 0 4500
Allowable Allowable
Increase Decrease
2000 500
1000 2000

Allowable Allowable
Increase Decrease
500 500
500 1000
1000000000000000000000000000000.00 1000
1E+030 1500
Microsoft Excel 16.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:36:05
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.015 Seconds.
Iterations: 3 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 NonNegati

Objective Cell (Max)


Cell Name Original Value Final Value
$G$5 contribution 11000000 11002000

Variable Cells
Cell Name Original Value Final Value Integer
$E$7 T101 2000 1999 Contin
$F$7 T102 1000 1001 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$G$9 EA LHS 4001 $G$9<=$I$9 Binding 0
$G$10 MS LHS 6000 $G$10<=$I$10 Binding 0
$G$11 101A LHS 3998 $G$11<=$I$11 Not Binding 1002
$G$12 102A LHS 3003 $G$12<=$I$12 Not Binding 1497
itions are satisfied.

matic Scaling
e 1%, Assume NonNegative
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:36:05

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$E$7 T101 1999 0 3000 2000 500
$F$7 T102 1001 0 5000 1000 2000

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$G$9 EA LHS 4001 2000 4001 499 501
$G$10 MS LHS 6000 500 6000 501 998
$G$11 101A LHS 3998 0 5000 1E+030 1002
$G$12 102A LHS 3003 0 4500 1E+030 1497
Microsoft Excel 16.0 Limits Report
Worksheet: [Book1]Sheet1
Report Created: 21-04-2025 19:36:06

Objective
Cell Name Value
$G$5 contribution 11002000

Variable Lower Objective Upper Objective


Cell Name Value Limit Result Limit Result
$E$7 T101 1999 0 5005000 1999 11002000
$F$7 T102 1001 0 5997000 1001 11002000
Microsoft Excel 16.0 Answer Report
Worksheet: [metron truck.xlsx]Sheet1
Report Created: 21-04-2025 19:41:39
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.015 Seconds.
Iterations: 3 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 NonNegati

Objective Cell (Max)


Cell Name Original Value Final Value
$G$5 contribution 0 11002000

Variable Cells
Cell Name Original Value Final Value Integer
$E$7 T101 0 1999 Contin
$F$7 T102 0 1001 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$G$9 EA LHS 4001 $G$9<=$I$9 Binding 0
$G$10 MS LHS 6000 $G$10<=$I$10 Binding 0
$G$11 101A LHS 3998 $G$11<=$I$11 Not Binding 1002
$G$12 102A LHS 3003 $G$12<=$I$12 Not Binding 1497
itions are satisfied.

matic Scaling
e 1%, Assume NonNegative
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [metron truck.xlsx]Sheet1
Report Created: 21-04-2025 19:41:39

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$E$7 T101 1999 0 3000 2000 500
$F$7 T102 1001 0 5000 1000 2000

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$G$9 EA LHS 4001 2000 4001 499 501
$G$10 MS LHS 6000 500 6000 501 998
$G$11 101A LHS 3998 0 5000 1E+030 1002
$G$12 102A LHS 3003 0 4500 1E+030 1497
Microsoft Excel 16.0 Answer Report
Worksheet: [metron truck.xlsx]Sheet1
Report Created: 21-04-2025 19:42:27
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.031 Seconds.
Iterations: 3 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 NonNegati

Objective Cell (Max)


Cell Name Original Value Final Value
$G$5 contribution 0 11000000

Variable Cells
Cell Name Original Value Final Value Integer
$E$7 T101 0 2000 Contin
$F$7 T102 0 1000 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$G$9 EA LHS 4000 $G$9<=$I$9 Binding 0
$G$10 MS LHS 6000 $G$10<=$I$10 Binding 0
$G$11 101A LHS 4000 $G$11<=$I$11 Not Binding 1000
$G$12 102A LHS 3000 $G$12<=$I$12 Not Binding 1500
itions are satisfied.

matic Scaling
e 1%, Assume NonNegative
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [metron truck.xlsx]Sheet1
Report Created: 21-04-2025 19:42:27

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$E$7 T101 2000 0 3000 2000 500
$F$7 T102 1000 0 5000 1000 2000

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$G$9 EA LHS 4000 2000 4000 500 500
$G$10 MS LHS 6000 500 6000 500 1000
$G$11 101A LHS 4000 0 5000 1E+030 1000
$G$12 102A LHS 3000 0 4500 1E+030 1500
contribution 3000 5000
T101 T102
2000 1000

EA 1 2
MS 2 2
101A 2 0
102A 0 3
11000000 8600000 2400000

LHS RHS
4000 <= 4000
6000 <= 6000
4000 <= 5000
3000 <= 4500

You might also like