Doors Windows

Unit Profits 300.00 500.00

Hours Used Per Unit Produced Hours Used

Plant 1 1.00 0.00 2.00 <=
Plant 2 0.00 2.00 12.00 <=
Plant 3 3.00 2.00 18.00 <=

Doors Windows
Units Produced 2.00 6.00
Hours Avialable
4.00
12.00
18.00

Total Profit
3600.00
 TV PM
UNit Cost 1 2

Increase in sales/unit of ad Min Increase Minimum increase required

SR 0 1 3 >= 3
LD 3 2 18 >= 18
PW -1 4 8 >= 4

TV PM Total cost
unit of ad 4 3 10
 Product 1 Product 2
Unit Profits 1 2
Parts needed D/F Products have
Frame work 1 3 200 <= 200
Electrical Comp 2 2 300 <= 300
Total Profit
Units produced 125 25 175

P2 <= 60
 Beef Gravy Peas Carrot Dinner roll
COST 0.40 0.35 0.15 0.18 0.10

Beef Gravy Peas Carrot Dinner roll >=

TC 54.00 20.00 15.00 8.00 40.00 320.00 280.00
CFAT 19.00 15.00 0.00 0.00 10.00 96.00 41.10
VA 0.00 0.00 15.00 350.00 0.00 600.00 600.00
VC 0.00 1.00 3.00 1.00 0.00 12.38 10.00
P 8.00 0.00 1.00 1.00 1.00 30.00 30.00

b g p c d TC
CON 2.94 1.47 3.11 1.58 1.82 2.62
2

30% 50%
fat c 96 <= 137 96
gry 1 >= 1 1.46803
<=
320
<=
>=
>=
>=
Oneway analysis for Solver model in Nutri Jenny worksheet

gravy (cell $C$4) values along side, output cell(s) along top

$I$16
1
0.20 2.40
0.22 2.43
0.24 2.46
0.26 2.49
0.28 2.52
0.30 2.55
0.32 2.58
0.34 2.61
0.36 2.64
0.38 2.67
0.40 2.69

2.75
2.7
2.65
2.6
2.55
2.5
2.45
2.4
2.35
2.3
2.25
0.20 0.2
Sensitivity of $I$16 to gravy

Data for chart

When you select an output from the
$I$16

dropdown list in cell $K$4, the chart

will adapt to that output.
2.401214
2.430575
2.459936
2.489296
2.518657
2.548018
2.577378
2.606739
2.636099
2.66546
2.69482

Sensitivity of $I$16 to gravy

2.75
2.7
2.65
2.6
2.55
2.5
2.45
2.4
2.35
2.3
2.25
0.20 0.22 0.24 0.26 0.28 0.30 0.32 0.34 0.36 0.38 0.40
gravy ($C$4)
Twoway analysis for Solver model in Nutri Jenny worksheet

Vitamin C (cell $I$11) values along side, Protein (cell $I$12) values along top, output cell in corner

$I$16 15.00 20.00 25.00 30.00 35.00 40.00 45.00 1

5.00 1.91 1.91 2.18 2.62 3.06 4.07 Not feasible OutputVal
7.50 1.98 1.98 2.18 2.62 3.06 4.07 Not feasible
10.00 2.06 2.06 2.21 2.62 3.06 4.07 Not feasible
12.50 2.15 2.15 2.27 2.62 3.06 4.07 Not feasible
15.00 2.24 2.24 2.33 2.65 3.06 4.32 Not feasible
17.50 2.33 2.33 2.39 2.70 3.06 4.60 Not feasible
20.00 2.42 2.42 2.45 2.76 3.11 4.89 Not feasible

4.5
4
3.5
3
2.5
2
1.5
1
0.5
0
15.00 20
Sensitivity of $I$16 to Protein Sensitivity of $I$16 to Vitamin C
Output and Vitamin C value for chart Output and Protein value for chart
Output Vitamin C value Output Protein value
By making appropriate selections in ce
$I$16

$I$16
5 1 1 15 1 and $P$4, you can chart any row (in le
right chart) of any table to the left.
1.91 OutputVal 1.91
1.91 1.98
2.18 2.06
2.62 2.15
3.06 2.24
4.07 2.33
Not feasible 2.42

Sensitivity of $I$16 to Protein Sen

4.5 3
4
2.5
3.5
3 2
2.5
1.5
2
1.5 1
1
0.5
0.5
0 0
15.00 20.00 25.00 30.00 35.00 40.00 45.00 5.00 7.50
Protein ($I$12)
ng appropriate selections in cells $K$4, $L$4, $O$4,
4, you can chart any row (in left chart) or column (in
art) of any table to the left.

Sensitivity of $I$16 to Vitamin C

3

2.5

1.5

0.5

0
5.00 7.50 10.00 12.50 15.00 17.50 20.00
Vitamin C ($I$11)
$I$16
Twoway analysis for Solver model in Nutri Jenny worksheet

Vitamin C (cell $I$11) values along side, Protein (cell $I$12) values along top, output cell in corner

$B$16 15.00 20.00 25.00 30.00 35.00 40.00 45.00 1

5.00 2.00 2.00 2.32 2.94 3.55 3.62 Not feasible OutputVal
7.50 2.00 2.00 2.34 2.94 3.55 3.62 Not feasible
10.00 2.00 2.00 2.38 2.94 3.55 3.62 Not feasible
12.50 2.00 2.00 2.30 2.94 3.55 3.62 Not feasible
15.00 2.00 2.00 2.22 3.01 3.55 3.33 Not feasible
17.50 2.00 2.00 2.14 2.93 3.55 3.00 Not feasible
20.00 2.00 2.00 2.06 2.85 3.49 2.67 Not feasible

$C$16 15.00 20.00 25.00 30.00 35.00 40.00 45.00

5.00 1.00 1.00 1.16 1.47 1.78 1.81 Not feasible
7.50 1.00 1.00 1.17 1.47 1.78 1.81 Not feasible 4
10.00 1.00 1.00 1.19 1.47 1.78 1.81 Not feasible 3.5
12.50 1.00 1.00 1.15 1.47 1.78 1.81 Not feasible 3
15.00 1.00 1.00 1.11 1.51 1.78 1.67 Not feasible
2.5
17.50 1.00 1.00 1.07 1.47 1.78 1.50 Not feasible
2
20.00 1.00 1.00 1.03 1.43 1.75 1.33 Not feasible
1.5
$D$16 15.00 20.00 25.00 30.00 35.00 40.00 45.00 1
5.00 0.97 0.97 1.34 3.11 4.88 0.00 Not feasible 0.5
7.50 1.62 1.62 1.56 3.11 4.88 0.00 Not feasible 0
10.00 2.46 2.46 2.40 3.11 4.88 0.00 Not feasible 15.00 2
12.50 3.31 3.31 3.26 3.15 4.88 0.00 Not feasible
15.00 4.15 4.15 4.12 3.98 4.88 0.00 Not feasible
17.50 5.00 5.00 4.98 4.84 4.88 0.00 Not feasible
20.00 5.85 5.85 5.84 5.70 5.59 0.00 Not feasible

$E$16 15.00 20.00 25.00 30.00 35.00 40.00 45.00

5.00 1.67 1.67 1.66 1.58 1.51 11.02 Not feasible
7.50 1.64 1.64 1.65 1.58 1.51 11.02 Not feasible
10.00 1.61 1.61 1.61 1.58 1.51 11.02 Not feasible
12.50 1.57 1.57 1.57 1.58 1.51 11.02 Not feasible
15.00 1.54 1.54 1.54 1.54 1.51 13.33 Not feasible
17.50 1.50 1.50 1.50 1.51 1.51 16.00 Not feasible
20.00 1.46 1.46 1.46 1.47 1.47 18.67 Not feasible

$F$16 15.00 20.00 25.00 30.00 35.00 40.00 45.00

5.00 3.10 3.10 3.46 1.82 0.18 0.00 Not feasible
7.50 2.86 2.86 3.06 1.82 0.18 0.00 Not feasible
10.00 2.55 2.55 1.97 1.82 0.18 0.00 Not feasible
12.50 2.24 2.24 1.79 1.75 0.18 0.00 Not feasible
15.00 1.93 1.93 1.60 0.38 0.18 0.00 Not feasible
17.50 1.63 1.63 1.41 0.19 0.18 0.00 Not feasible
20.00 1.32 1.32 1.22 0.00 0.00 0.00 Not feasible
Sensitivity of $B$16 to Protein Sensitivity of $B$16 to Vitamin C
Output and Vitamin C value for chart Output and Protein value for chart
Output Vitamin C value Output Protein value
By making appropriate selections in ce
$B$16

$B$16
and $P$4, you can chart any row (in le
5 1 1 15 1 right chart) of any table to the left.
2.00 OutputVal 2.00
2.00 2.00
2.32 2.00
2.94 2.00
3.55 2.00
3.62 2.00
Not feasible 2.00

Sensitivity of $B$16 to Protein Sen

4 2.5
3.5
2
3
2.5 1.5
2
1.5 1
1
0.5
0.5
0 0
15.00 20.00 25.00 30.00 35.00 40.00 45.00 5.00 7.50
Protein ($I$12)
ng appropriate selections in cells $K$4, $L$4, $O$4,
4, you can chart any row (in left chart) or column (in
art) of any table to the left.

Sensitivity of $B$16 to Vitamin C

2.5

1.5

0.5

0
5.00 7.50 10.00 12.50 15.00 17.50 20.00
Vitamin C ($I$11)
$B$16
$C$16

$D$16
$E$16
$F$16
Sellmore company
Required Time Task
Word Processing Graphics Packets Registrations
Ann 35 41 27 40
Ian 47 45 32 51
Joan 39 56 36 43
Sean 32 51 25 46

Task
Word Processing Graphics Packets Registrations
Ann $490 $574 $378 $560
Ian $564 $540 $384 $612
Joan $507 $728 $468 $559
Sean $480 $765 $375 $690

Task
Word Processing Graphics Packets Registrations Total Assignment
Ann 0 0 1 0 1
Ian 0 1 0 0 1
Joan 0 0 0 1 1
Sean 1 0 0 0 1
Total Assigned 1 1 1 1
= = = =
Demand 1 1 1 1
 Hourly Wage
$14
$12
$13
$15

Supply
= 1
= 1
= 1
= 1

Total Cost
$1,957.00
 Shift 1 Shift 2 Shift 3 Shift 4 Shift 5
6am-2pm 8am-4pm noon-8am 4pm-midnight 10pm-6am
Cost per shift $170.00 $160.00 $175.00 $180.00 $195.00

time period shift works the period?(1=yes,0=no) total working

6am-8am 1 0 0 0 0 48 >=
8am-10am 1 1 0 0 0 79 >=
10am-12pm 1 1 0 0 0 79 >=
12p,-2pm 1 1 1 0 0 118 >=
2pm-4pm 0 1 1 0 0 70 >=
4pm-6pm 0 0 1 1 0 82 >=
6pm-8pm 0 0 1 1 0 82 >=
8pm-10pm 0 0 0 1 0 43 >=
10pm-12am 0 0 0 1 1 58 >=
12am-6am 0 0 0 0 1 15 >=
Shift 1 Shift 2 Shift 3 Shift 4 Shift 5
6am-2pm 8am-4pm noon-8am 4pm-midnight 10pm-6am
No of working 48 31 39 43 15
minimum needed
48
79
65
87
64
73
82
43
52
15

Total Cost
$30,610.00
 port
ship 1 2 3 4
1 500 400 600 700
2 600 600 700 500
3 700 500 700 600
4 500 400 600 600

Ship Port Total ship Supply

1 2 3 4
1 1 0 0 0 1 = 1
2 0 0 0 1 1 = 1
3 0 1 0 0 1 = 1
4 0 0 1 0 1 = 1
Ship assigned 1 1 1 1
= = = = Total cost
Demand 1 1 1 1 $2,100.00
 Shipping Cost
Customer 1 Customer 2 Customer 3
Factory 1 $700.00 $900.00 $800.00
Factory 2 $800.00 $900.00 $700.00

Unit Shipped Customer 1 Customer 2 Customer 3 Toal Shipped Output

Factory 1 10 2 0 12 = 12
Factory 2 0 6 9 15 = 15
Total to Customer 10 8 9
= = = Total Cost
Order Size 10.00 8.00 9.00 $20,500.00
 F1 F2 F3 P1 P2 P3 P4
Cost per shift $112.00 $112.00 $112.00 $48.00 $48.00 $48.00 $48.00

Time Period minimum required workers total worker

8am-noon 1 0 0 1 0 0 0 6
noon-4pm 1 1 0 0 1 0 0 8
4pm-8pm 0 1 1 0 0 1 0 12
8pm- midnight 0 0 1 0 0 0 1 6

F1 F2 F3 P1 P2 P3 P4
worker per shift 4 2 6 2 2 4 0

2
Total Total
Time Period Full time Part timer
8am-noon 4 >= 2
noon-4pm 6 >= 2
4pm-8pm 8 >= 4
8pm- midnight 6 >= 0
 Minimum Needed

>= 6
>= 8
>= 12
>= 6

total cost
$1,728.00
 Shipping Profit
Profit 320.00 400.00 360.00 290.00
Volume 500.00 700.00 600.00 400.00
C1 C2 C3 C4 Total Weight
Front 0 0 11 1 12 <=
Center 0 6 0 12 18 <=
Back 10 0 0 0 10 <=
Total 10 6 11 13
<= <= <= <=
Tons avail 20 16 25 13

Percentage of front capacity 100% = 100% Percentage of middle capacity

Percentage of front capacity 100% = 100% Percentage of back capacity
 Weight capacity Total Volume Volume capacity
12 7000 <= 7000
18 9000 <= 9000
10 5000 <= 5000
Total profit

13330.00

centage of middle capacity

centage of back capacity
 From To Stop Capacity Unit Cost Nodes Net Flow
F1 W1 30 700 F1 80 =
F1 DC 50 <= 50 300 F2 70 =
DC W1 30 <= 50 200 DC 0 =
DC W2 50 <= 50 400 W1 -60 =
F2 DC 30 <= 50 500 W2 -90 =
F2 W2 40 1000
Total Cost
117000
Supply/Demand
80
70
0
-60
-90
From TO Ship Capacity Nodes Net Flow Supply/Demand
ST RO 50 <= 50 ST 150
ST BO 70 <= 70 RO 0 = 0
ST LI 30 <= 40 BO 0 = 0
RO NY 50 <= 60 LI 0 = 0
BO NY 30 <= 40 NO 0 = 0
BO NO 40 <= 50 NY 0 = 0
LI NO 30 <= 30 LA -150
NY LA 80 <= 80
NO LA 70 <= 70

Maximum Flow
150
From TO Ship Capacity Nodes Net Flow Supply/Demand
BE HA 60 <= 60 BE 80
BE RO 20 <= 20 ST 140
ST RO 40 <= 50 HA 0 = 0
ST BO 70 <= 70 RO 0 = 0
ST LI 30 <= 40 BO 0 = 0
HA BN 30 <= 40 LI 0 = 0
HA NY 30 <= 30 BN 0 = 0
RO NY 60 <= 60 NY 0 = 0
BO NY 30 <= 40 NO 0 = 0
BO NO 40 <= 50 SE -60
LI NO 30 <= 30 LA -160
BN SE 20 <= 20
BN LA 10 <= 10
NY SE 40 <= 40
NY LA 80 <= 80
NO LA 70 <= 70

Maximum Flow 220

pply/Demand
From TO Route Distance Nodes Net Flow
O A 1 <= 3 O 1 =
O B 0 <= 6 A 0 =
O C 0 <= 4 B 0 =
A D 0 <= 6 C 0 =
A B 1 <= 1 D 0 =
B A 0 <= 1 E 0 =
B D 0 <= 4 F 0 =
B E 1 <= 5 G 0 =
B C 0 <= 2 H 0 =
C E 0 <= 7 F 0 =
C B 0 <= 2 T -1 =
D F 0 <= 8
D E 0 <= 3
E D 0 <= 3
E F 1 <= 6
E G 0 <= 5
E H 0 <= 4
F G 0 <= 3
F T 1 <= 4
G F 0 <= 3
G H 0 <= 2
G T 0 <= 6
H G 0 <= 2
H T 0 <= 7

Total Distance
19
Supply /Demand
1
0
0
0
0
0
0
0
0
0
-1
 NPV LA SF
Warehouse 6 4
Factory 8 5

Capital Required LA SF
Warehouse 5 2 Capital Spend Capital Available
Factory 6 3 9 <= 10

Bulding LA Sf Total Maximum

Warehouse 0 0 Warehouse Warehouse
Facrory 1 1 0 <= 1

Total NPV 13
Oneway analysis for Solver model in Sheet1 worksheet

Input (cell $G$7) values along side, output cell(s) along top

$B$13
1
5 9
6 9
7 9
8 9
9 13
10 13
11 17
12 17
13 17
14 19
15 19

20
18
16
14
12
10
8
6
4
2
0
5 6
Sensitivity of $B$13 to Input

Data for chart

When you select an output from the
$B$13

dropdown list in cell $K$4, the chart

will adapt to that output.
9
9
9
9
13
13
17
17
17
19
19

Sensitivity of $B$13 to Input

20
18
16
14
12
10
8
6
4
2
0
5 6 7 8 9 10 11 12 13 14 15
Input ($G$7)
 Invest. Oppor. 1 2 3 4 5 6 7
Profit Estimated 17 10 15 19 7 13 9
Invest. Oppor. 1 2 3 4 5 6 7
Capital required 43 28 34 48 17 32 23
Invest. Oppor. 1 2 3 4 5 6 7
Investment 1 0 1 0 0 0 1
<= <=
1 1
1 <= 1
1 <= 1
Capital spent Capital available
100 <= 100
Total Profit
41
 Fire Station In tract
1 2 3 4 5 6 7
1 2 8 18 9 23 22 16
2 9 3 10 12 16 14 21
3 17 8 4 20 21 8 22
4 10 13 19 2 18 21 6
5 21 12 16 13 5 11 9
6 25 15 7 21 15 3 14
7 14 22 18 7 13 15 2
8 30 24 15 14 17 9 8

Cost of Station 350 250 450 300 50 400 300

Response time 1 2 3 4 5 6 7
<= 1 1 1 0 1 0 0 0
10 2 1 1 1 0 0 0 0
3 0 1 1 0 0 1 0
4 1 0 0 1 0 0 1
5 0 0 0 0 1 0 1
6 0 0 1 0 0 1 0
7 0 0 0 1 0 0 1
8 0 0 0 0 0 1 1

Stattion in Tract 0 1 0 0 0 0 1
8
28
25
17
12
12
8
9
3

200

8 Number Covering
0 1 >= 1
0 1 >= 1
0 1 >= 1
0 1 >= 1
0 1 >= 1
1 1 >= 1
1 2 >= 1
1 2 >= 1

Total Cost
1 750
 Route
1 2 3 4 5 6 7 8
Time Hours 6 4 7 5 4 6 5 3

Location 1 2 3 4 5 6 7 8
A 1 0 0 0 1 0 0 0
B 0 1 0 1 0 1 0 0
C 0 0 1 1 0 0 1 0
D 1 0 0 0 0 1 0 1
E 0 0 1 1 0 1 0 0
F 1 1 0 0 1 0 0 0
G 1 0 0 0 0 0 1 1
H 0 0 1 0 1 0 0 0
I 0 1 0 1 0 0 1 0

No. Of Drivers 0 0 0 1 1 0 0 1

Drivers Needed 3 <= 3

9 10
7 6

9 10 Total No Route
1 0 1 >= 1
1 1 1 >= 1
0 0 1 >= 1
0 0 1 >= 1
0 0 1 >= 1
0 0 1 >= 1
0 1 1 >= 1
0 1 1 >= 1
0 0 1 >= 1
Total Time
0 0 12
 Flight Sequence
1 2 3 4 5 6 7 8
Cost 2 3 4 6 7 5 7 8

Segment 1 2 3 4 5 6 7 8
SFO-LAX 1 0 0 1 0 0 1 0
SFO-DEN 0 1 0 0 1 0 0 1
SFO-SEA 0 0 1 0 0 1 0 0
LAX-ORD 0 0 0 1 0 0 1 0
LAX-SFO 1 0 0 0 0 1 0 0
ORD-DEN 0 0 0 1 1 0 0 0
ORD-SEA 0 0 0 0 0 0 1 1
DEN-SFO 0 1 0 0 1 0 0 0
DEN-ORD 0 0 0 0 1 0 0 1
SEA-SFO 0 0 1 0 0 0 1 1
SEA-LAX 0 0 0 0 0 1 0 0

1 2 3 4 5 6 7 8
Fly sequence 1 0 0 0 1 0 0 0
9 10 11 12
9 9 8 9

9 10 11 12 Total At least one

0 1 0 0 1 >= 1
0 0 1 0 1 >= 1
1 0 0 1 1 >= 1
1 1 0 1 1 >= 1
0 1 1 0 1 >= 1
1 0 0 0 1 >= 1
0 1 1 1 1 >= 1
1 0 0 0 1 >= 1
0 0 1 0 1 >= 1
0 0 0 1 1 >= 1
1 1 1 1 1 >= 1

9 10 11 12 Total Sequence Number of crew

0 0 0 1 3 <= 3
Total Cost 18
 Doors Windows
UnIt Profit 300 500
Setup Cost 700 1300
Hours used per unit produced Hours used Hours available
Plant 1 1 0 0 <= 4
Plant 2 0 2 12 <= 12
Plant 3 3 2 12 <= 16
Doors Windows
Units produced 0 6
<= <=
Only if setup 0 99 Production Profit 3000
Seup? 0 1 Total Setup Cost 1300
Total Profit 1700
 Generator A B C D E
Cost per Mega watt 5 4 6 6 7
Fixed setup cost 3000 2000 2500 1500 1000
Maximum Capacity 2100 1800 2500 1500 1000

Startup Generator(binary) 1 1 1 0 1
Mega watt genrated 2100 1800 2500 0 100 6500
<= <= <= <= <=
Capacity 2100 1800 2500 0 1000
 >= 6500

Fixed cost 8500

Mega watt Cost 33400
Total Cost 41900
 The Primo Insurance Company
Special Risk Insurance Mortgages
Expected Profit/Unit 5 2

Department Special Risk Insurance Mortgages Work Hours Available

Underwriting 3 2 2400 <= 2400
Administrations 0 1 300 <= 800
Claims 2 0 1200 <= 1200

Special Risk Insurance Mortgages Total Profit

New Sales quota 600 300 3600
 The Oak Works
Table Chair
Profit 400 100
Table Chair
Oak requi. 50 25 2500 <= 2500
Labour Hour req 6 6 450 <= 480
Table Chair
No. of chairs and tables 25 50 15000
>=
50
Web Mercantile
Cost 65 100 135 160 190 65 100 135

Month of Lease 1 1 1 1 1 2 2 2
Length of Lease 1 2 3 4 5 1 2 3
Month 1 1 1 1 1 1
Month 2 1 1 1 1 1 1 1
Month 3 1 1 1 1 1
Month 4 1 1 1
Month 5 1

Lease 0 0 0 0 30000 0 0 0
160 65 100 135 65 100 65

2 3 3 3 4 4 5 Total Lease
4 1 2 3 1 2 1 Space Required
30000 >=
1 30000 >=
1 1 1 1 40000 >=
1 1 1 1 1 30000 >=
1 1 1 1 50000 >=

0 10000 0 0 0 0 20000
 Space
Required
30000
20000
40000
10000
50000
Total Cost
7650000
 Shipping Cost
Customer 1 Customer 2 Customer 3
Factory 1 600 800 400
Factory 2 400 900 500

Unit Shipped Customer 1 Customer 2 Customer 3 Total Shipped Output

Factory 1 0 200 200 400 <= 400
Factory 2 300 0 200 500 <= 500
Total to customer 300 200 400
= = = Total Cost
300 200 400 460000
 Shipping Cost S1 S2
M1 2000 1700
M2 1600 1100

P 400 800

Capacity S1 S2
M1 30 30 Unit Shipped <= Capacity
M2 50 50

Units Shipped S1 S2 Total shipped out of S1 & S2 Output

M1 30 10 40 = 40
M2 10 50 60 = 60
Total into S1 & S2 40 60
= =
Total out of S1 & S2 40 60 Total shipped into P Needed
P 40 60 100 = 100
<= <=
Capacity 70 70 Total Cost
212000
 Men's Women's Children's
Gross Profit 8 10 6
Full Time Part Time
Labour Cost/Hour 13 10
Hours Worked 40 20
Total Labour Cost 520 200
Men's Women's Children's Rescource Used
Materials 2 1.5 1 5000 <=
Labour Required 30 45 40 75000 <=

Men's Women's Children's

Production Per Week 2500 0 0 Gross Profit
Full Time Part Time Labour Cost
Employees 25 12.5 Net Profit
>=
Minimum Full Time 20
Two Times Part Time 25 >=
Resource Available Hours Worked Minutes Hours Worked In Minutes
5000 Full Time 40 * 60 = 2400
75000 Part Time 20 * 60 = 1200

20000
15500
4500
Unit Profit
Customer 1 Customer 2 Customer 3 Customer 4
Plant 1 800 700 500 200
Plant 2 500 200 100 300
Plant 3 600 400 300 500

Customer 1 Customer 2 Customer 3 Customer 4

Plant 1 0 60 0 0 60 <= 60
Plant 2 40 0 0 40 80 <= 80
Plant 3 0 0 20 20 40 <= 40
40 60 20 60
= = >= Total Profit
40 60 20 90000
From To Ship Capacity Nodes Net Flow
TX NO 11 <= 11 TX 28
TX CH 7 <= 7 CA 24
TX SE 2 <= 2 AK 28
TX SL 8 <= 8 ME 28
CA NO 5 <= 5 NO 0
CA CH 4 <= 4 CH 0
CA SE 8 <= 8 SE 0
CA SL 7 <= 7 SL 0
AK NO 7 <= 7 PT -26
AK CH 3 <= 3 AT -33
AK SE 12 <= 12 KC -30
AK SL 6 <= 6 SF -19
ME NO 1 <= 8
ME CH 9 <= 9
ME SE 3 <= 4
ME SL 15 <= 15
NO PT 5 <= 5
NO AT 9 <= 9
NO KC 6 <= 6
NO SF 4 <= 4
CH PT 8 <= 8
CH AT 7 <= 7
CH KC 8 <= 9
CH SF 0 <= 5
SE PT 4 <= 4
SE AT 6 <= 6
SE KC 7 <= 7
SE SF 8 <= 8
SL PT 9 <= 12
SL AT 11 <= 11
SL KC 9 <= 9
SL SF 7 <= 7

Maximum Flow 108

 Supply/ Demand

= 0
= 0
= 0
= 0
Time Needed Per Work Marketing Cooking Dish Washing Laundry
Eve 4.5 7.8 3.6 2.9
Steven 4.9 7.2 4.3 3.1

Time Needed Marketing Cooking Dish Washing Laundry Task Performed

Eve 1 0 1 0 2
Steven 0 1 0 1 2
1 1 1 1
= = = =
Supply 1 1 1 1 Total Time
18.4
 Demand
= 2
= 2
 Customer 1 Customer 2 Customer 3
Startup Cost 3 2 0
Marginal Net Revenue 2 3 0.8 Capacit Used
Capacity Used Per Plane 20% 40% 20% 100% <=
Maximum Order 3 2 5

Startup (Binary) 0 1 1 Total Startup Cost

Total Revenue
Planes to produce 0 2 1 Total Profit
<= <= <=
Maximum Order(if startup) 0 2 5
Capacity Available
100%

2
6.8
4.8
 Cost Educamp Macwin McElectronics
Fixed Cost 45000 35000 50000
Variable Cost 750 775 700
Capacity 700 700 1000
Educamp Macwin McElectronics Total Purchased
No. Of Purchase 0 350 1000 1350 =
<= <= <=
0 700 1000 Fixed Cost
Fixed Cost(Binary) 0 1 1 Variable Cost
Total Cost
Computers Nedded
1350

85000
971250
1056250