Microsoft Excel 16.

0 Answer Report
Worksheet: [1820093.xlsx]Cost Minimization
Report Created: 1/20/2021 11:45:06 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.047 Seconds.
Iterations: 6 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative

Objective Cell (Min)

Cell Name Original Value Final Value
$B$14 Total Shipping Cost Customer 1 0 282800

Variable Cells
Cell Name Original Value Final Value Integer
$B$8 Warehouse 1 Customer 1 0 3000 Contin
$C$8 Warehouse 1 Customer 2 0 22000 Contin
$D$8 Warehouse 1 Customer 3 0 0 Contin
$E$8 Warehouse 1 Customer 4 0 0 Contin
$B$9 Warehouse 2 Customer 1 0 32000 Contin
$C$9 Warehouse 2 Customer 2 0 0 Contin
$D$9 Warehouse 2 Customer 3 0 18000 Contin
$E$9 Warehouse 2 Customer 4 0 30000 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$B$11 Actual Order Received Customer 1 35000 $B$11=$B$12 Binding 0
$C$11 Actual Order Received Customer 2 22000 $C$11=$C$12 Binding 0
$D$11 Actual Order Received Customer 3 18000 $D$11=$D$12 Binding 0
$E$11 Actual Order Received Customer 4 30000 $E$11=$E$12 Binding 0
$G$8 Warehouse 1 Actual Products Shipped 25000 $G$8<=$H$8 Not Binding 35000
$G$9 Warehouse 2 Actual Products Shipped 80000 $G$9<=$H$9 Binding 0
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [1820093.xlsx]Cost Minimization
Report Created: 1/20/2021 11:45:07 AM

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$8 Warehouse 1 Customer 1 3000 0 3 1.9 1.1
$C$8 Warehouse 1 Customer 2 22000 0 3 5.1 1E+030
$D$8 Warehouse 1 Customer 3 0 2.9 5.5 1E+030 2.9
$E$8 Warehouse 1 Customer 4 0 1.9 7 1E+030 1.9
$B$9 Warehouse 2 Customer 1 32000 0 1.9 1.1 1.9
$C$9 Warehouse 2 Customer 2 0 5.1 7 1E+030 5.1
$D$9 Warehouse 2 Customer 3 18000 0 1.5 2.9 1E+030
$E$9 Warehouse 2 Customer 4 30000 0 4 1.9 1E+030

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$B$11 Actual Order Received Customer 1 35000 3 35000 35000 3000
$C$11 Actual Order Received Customer 2 22000 3 22000 35000 22000
$D$11 Actual Order Received Customer 3 18000 2.6 18000 32000 3000
$E$11 Actual Order Received Customer 4 30000 5.1 30000 32000 3000
$G$8 Warehouse 1 Actual Products Shipped 25000 0 60000 1E+030 35000
$G$9 Warehouse 2 Actual Products Shipped 80000 -1.1 80000 3000 32000
Microsoft Excel 16.0 Limits Report
Worksheet: [1820093.xlsx]Cost Minimization
Report Created: 1/20/2021 11:45:08 AM

Objective
Cell Name Value
$B$14 Total Shipping Cost Customer 1 282800

Variable Lower Objective Upper Objective

Cell Name Value Limit Result Limit Result
$B$8 Warehouse 1 Customer 1 3000 3000 282800 3000 282800
$C$8 Warehouse 1 Customer 2 22000 22000 282800 22000 282800
$D$8 Warehouse 1 Customer 3 0 0 282800 0 282800
$E$8 Warehouse 1 Customer 4 0 0 282800 0 282800
$B$9 Warehouse 2 Customer 1 32000 32000 282800 32000 282800
$C$9 Warehouse 2 Customer 2 0 0 282800 0 282800
$D$9 Warehouse 2 Customer 3 18000 18000 282800 18000 282800
$E$9 Warehouse 2 Customer 4 30000 30000 282800 30000 282800
 Cost of Shipping ($ Per Product)
Customer 1 Customer 2 Customer 3
Warehouse 1 3 3 5.5
Warehouse 2 1.9 7 1.5

Number of prodcusts Shipped

Customer 1 Customer 2 Customer 3
Warehouse 1 3000 22000 0
Warehouse 2 32000 0 18000

Actual Order Received 35000 22000 18000

Demand 35000 22000 18000

Total Shipping Cost 282800

Constraints:
1. Actual products shipped must be less than equal to products available
2. Actual order received must be equal to demand
 Customer 4
7
4

Customer 4 Actual Products Shipped Available

0 25000 60000
30000 80000 80000

30000
30000

ailable