Navy example - setup

Microsoft Excel 16.0 Answer Report Worksheet: [Example 1.xlsx]Sheet1 Report Created: 2022-08-08 7:18:54 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 9 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 (Min) Cell Name Original Value Final Value $C$8 TOTAL COST Norfolk 0 142000 Variable Cells Cell Name Original Value Final Value Integer $G$4 Truck San Diego 0 1000 Contin $H$4 Truck Norfolk 0 2000 Contin $I$4 Truck Pensacola 0 0 Contin $G$5 Railroad San Diego 0 0 Contin $H$5 Railroad Norfolk 0 500 Contin $I$5 Railroad Pensacola 0 2500 Contin $G$6 Airplane San Diego 0 3000 Contin $H$6 Airplane Norfolk 0 0 Contin $I$6 Airplane Pensacola 0 0 Contin Constraints Cell Name Cell Value Formula Status Slack $G$7 TOTAL San Diego 4000 $G$7=$G$8 Binding 0 $H$7 TOTAL Norfolk 2500 $H$7=$H$8 Binding 0 $I$7 TOTAL Pensacola 2500 $I$7=$I$8 Binding 0 $J$4 Truck TOTAL 3000 $J$4=$K$4 Binding 0 $J$5 Railroad TOTAL 3000 $J$5=$K$5 Binding 0 $J$6 Airplane TOTAL 3000 $J$6=$K$6 Binding 0

Microsoft Excel 16.0 Answer Report Worksheet: [Navy example - setup.xlsx]Sheet1 Report Created: 2023-10-04 9:16:25 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.032 Seconds. Iterations: 9 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 (Min) Cell Name Original Value Final Value $C$8 TOTAL COST Norfolk 0 142000 Variable Cells Cell Name Original Value Final Value Integer $G$4 Truck San Diego 0 1000 Contin $H$4 Truck Norfolk 0 2000 Contin $I$4 Truck Pensacola 0 0 Contin $G$5 Railroad San Diego 0 0 Contin $H$5 Railroad Norfolk 0 500 Contin $I$5 Railroad Pensacola 0 2500 Contin $G$6 Airplane San Diego 0 3000 Contin $H$6 Airplane Norfolk 0 0 Contin $I$6 Airplane Pensacola 0 0 Contin Constraints Cell Name Cell Value Formula Status Slack $G$7 TOTAL San Diego 4000 $G$7=$G$8 Binding 0 $H$7 TOTAL Norfolk 2500 $H$7=$H$8 Binding 0 $I$7 TOTAL Pensacola 2500 $I$7=$I$8 Binding 0 $J$4 Truck TOTAL 3000 $J$4=$K$4 Binding 0 $J$5 Railroad TOTAL 3000 $J$5=$K$5 Binding 0 $J$6 Airplane TOTAL 3000 $J$6=$K$6 Binding 0

COST: SHIPPED: DESTINATION DESTINATION MODE San Diego Norfolk Pensacola MODE San Diego Norfolk Pensacola TOTAL Truck 12 6 5 Truck 0 0 1000 1000 Railroad 20 11 9 Railroad 1000 1500 1500 4000 Airplane 30 26 28 Airplane 3000 1000 0 4000 TOTAL 4000 2500 2500 TOTAL COST 171000 Demand 4000 2500 2500 Pensacola Truck (min) 1000 Railroad (max) 1500 No Pensocola by Rail 0

Supply 4000 4000 4000 0