1
2
3
4
5
6
7
8
9
10
11
A B C D E F
Activity 1 Activity 2
Unit Profit $30 $20
Used Available
Resource A 1 0 3 <= 5
Resource B 0 1 3 <= 4
Resource C 2 1 9 <= 9
Resource D 3 4 21 <= 21
Activity 1 Activity 2 Total Profit
Number of Units
3 3 $150
Resource Used Per Unit
1
2
3
4
5
6
7
8
9
10
A B C D E F
Activity 1 Activity 2
Unit Profit $300 $200
Used Available
Resource A 5 3 30 <= 30
Resource B 2 3 21 <= 21
Resource C 0 1 5 <= 6
Activity 1 Activity 2 Total Profit
Number of Units
3 5 $1,900
Resource Used Per Unit
1
2
3
4
5
6
7
8
9
10
11
A B C D E F
Activity 1 Activity 2
Unit Profit 20 30 ($million)
Used Available
Resource A 5 4 16.25 <= 20
Resource B 6 9 30 <= 30
Resource C 2 5 15 <= 15
Total Profit
Activity 1 Activity 2 ($million)
Number of Units
1.25 2.50 100
Resource Used Per Unit
Adjustable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$11
Number of Units Activity 1 1.25 020 0 8
$C$11
Number of Units Activity 2 2.50 030 20 0
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$D$5 Resource A Used 16.2 020 1E+30 3.75
$D$6 Resource B Used 30 3.33333 30 2.6471 3
$D$7 Resource C Used 15 015 1.6667 2.1429
1
2
3
4
5
6
7
8
9
10
11
A B C D E F
Activity 1 Activity 2
Unit Profit 20 29.99 ($million)
Used Available
Resource A 5 4 20 <= 20
Resource B 6 9 30 <= 30
Resource C 2 5 12.857 <= 15
Total Profit
Activity 1 Activity 2 ($million)
Number of Units
2.86 1.43 99.99
Resource Used Per Unit
1
2
3
4
5
6
7
8
9
10
A B C D E F
Activity 1 Activity 2
Unit Profit $500 $300
Used Available
Resource A 15 5300 <= 300
Resource B 10 6240 <= 240
Resource C 8 12 300 <= 450
Activity 1 Activity 2 Total Profit
Number of Units
15 15 $12,000
Resource Used Per Unit
Adjustable Cells
Final
Reduced
Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$10
Number of Units Activity 1 15.00 0.00 500 400 0
$C$10
Number of Units Activity 2 15.00 0.00 300 0133.3333
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$D$5 Resource A Used 300 0300 60 83.3333
$D$6 Resource B Used 240 50 240 42.8571 40
$D$7 Resource C Used 300 0450 1E+30 150
1
2
3
4
5
6
7
8
9
10
A B C D E F
Activity 1 Activity 2
Unit Profit $500 $300.01
Used Available
Resource A 15 5216.67 <= 300
Resource B 10 6240 <= 240
Resource C 8 12 450 <= 450
Activity 1 Activity 2 Total Profit
Number of Units
2.5 35.8333 $12,000
Resource Used Per Unit
1
2
3
4
5
6
7
8
9
A B C D E F
Activity 1 Activity 2
Unit Cost $5,000 $7,000 Minimum
Benefit Acceptable
Achieved Level
Benefit 1 -2 1 0 >= 1
Benefit 2 1 -2 0>= 1
Activity 1 Activity 2 Total Cost
Number of Units
0 0 $0
Benefit Contribution per Unit
1
2
3
4
5
6
7
8
9
A B C D E F
Activity 1 Activity 2
Unit Profit 90 70
Available/
Level Minimum
Resource 2 1 2 <= 2
Benefit 1 -1 1>= 2
Activity 1 Activity 2 Total Profit
Number of Units
1 0 90
Benefit Contribution per Unit
1
2
3
4
5
6
7
8
9
A B C D E F
Activity 1 Activity 2
Unit Profit 1 -1
Used Available
Resource A -1 3 0 <= 30
Resource B -3 1 0 <= 30
Activity 1 Activity 2 Total Profit
Number of Units
0 0 0
Resource Used Per Unit