Microsoft Excel 16.
0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 3/19/2024 2:55:53 PM
Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$E$14 Solution DTV 10 0 65 25 65
$F$14 Solution ETV 0 -65 90 65 1E+030
$G$14 Solution DN 25 0 40 1E+030 16
$H$14 Solution SN 2 0 60 40 16.666666667
$I$14 Solution R 30 0 20 1E+030 14
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$J$11 TV Restriction 1 function 10 -25 10 1.3333333333 10
$J$12 TV Restriction 2 function 15000 0 18000 1E+030 3000
$J$13 Customers Reached function 61500 0 50000 11500 1E+030
$J$6 Availability 1 function 10 0 15 1E+030 5
$J$7 Availability 2 function 0 0 10 1E+030 10
$J$8 Availability 3 function 25 16 25 5 23
$J$9 Availability 4 function 30 14 30 20 30
$J$10 Budget function 30000 0.06 30000 1E+030 2000
decision variable DTV ETV DN SN R
Maximize 65 90 40 60 20
Availability 1 1 0 0 0 0
Availability 2 0 1 0 0 0
Availability 3 0 0 1 0 0
Availability 4 0 0 0 0 1
Availability 5 0 0 0 1 0
Budget 1500 3000 400 1000 100
TV Restriction 1 1 1
TV Restriction 2 1500 3000
Customers Reached 1000 2000 1500 2500 300
Solution 10 0 25 2 30
function RHS Slack/Surplus
2370
10 <= 15 5
0 <= 10 10
25 <= 25 0
30 <= 30 0
2 <= 4 2
30000 <= 30000 0
10 >= 10 0
15000 <= 18000 3000
61500 >= 50000 -11500
Transportation Model
origin Boston Chicago St. Louis Lexington Availability
Cleveland 3 2 7 6 5000
Bedford 7 5 2 3 6000
York 2 5 4 5 2500
Requirement 6000 4000 2000 1500
origin Boston Chicago St. Louis Lexington Sum Availability
Cleveland 3500 1500 0 0 5000 5000
Bedford 0 2500 2000 1500 6000 6000
York 2500 0 0 0 2500 2500
Sum 6000 4000 2000 1500
Requirement 6000 4000 2000 1500
Cost 39500
Availability
origin D1 D2 D3 Availability
S1 5 4 3 100
S2 8 4 3 300
S3 9 7 5 300
Requireme 300 200 200
origin D1 D2 D3 Sum Availability
S1 100 0 0 100 100
S2 0 200 100 300 300
S3 200 0 100 300 300
Sum 300 200 200
Requireme 300 200 200
Cost 3900
Availability
origin T1 T2 D1 D2
S1 2 3 100000 100000
S2 3 1 100000 100000
T1 100000 100000 2 6
T2 100000 100000 4 4
Demand 200 150
Cost
origin T1 T2 D1 D2
S1 550 50 0 0
S2 0 400 0 0
T1 0 0 200 0
T2 0 0 0 150
SUM 550 450 200 150
Demand 200 150
Cost 5200
D3 D4 Av.
100000 100000 600
100000 100000 400
3 6
6 5
350 300
D3 D4 Sum Av.
0 0 600 600
0 0 400 400
350 0 550
0 300 450
350 300
350 300
ASSIGNMENT MODEL
origin C1 C2 C3
PL 1 10 15 9
PL 2 9 18 5
PL 3 6 14 3
origin C1 C2 C3 Sum
PL 1 0 1 0 1
PL 2 0 0 1 1
PL 3 1 0 0 1
Sum 1 1 1
RHS 1 1 1
Objective 26
RHS
1
1
1
ASSIGNMENT MODEL
Crew 1 2 3 4 5
Red 30 44 38 47 31
white 25 32 45 44 25
blue 23 40 37 39 29
green 26 38 37 45 28
brown 26 34 44 43 28
Crew 1 2 3 4 5 sum RHS
Red 0 0 1 0 0 1 1
white 0 0 0 0 1 1 1
blue 0 0 0 1 0 1 1
green 1 0 0 0 0 1 1
brown 0 1 0 0 0 1 1
sum 1 1 1 1 1
RHS 1 1 1 1 1
Objective 162
House 1 House 2 House 3 Availability
p 3 3 2 25
o 4 2 3 40
m 3 2 3 30
requirement 30 30 35
House 1 House 2 House 3 Sum
p 0 0 25 25 25
o 0 30 10 40 40
m 30 0 0 30 30
Sum 30 30 35
requirement 30 30 35
Cost 230
c W X Y Z
A12 10 14 16 13
A15 12 13 15 12
B2 9 12 12 11
B9 14 16 18 16
c W X Y Z Sum RHS
A12 1 0 0 0 1 1
A15 0 0 0 1 1 1
B2 0 0 1 0 1 1
B9 0 1 0 0 1 1
Sum 1 1 1 1
RHS 1 1 1 1
Cost 50
Chandeliers Fans function RHS
Max Profit 7 6 35
Wire 2 3 10 <= 12
Assembly 6 5 30 <= 30
solution 5 0
