Scribd
Upload
2K views22 pages

Northwest Newsprint

The document appears to be an optimization model for allocating production of different newsprint products (SM, NM, DU) across various plants (Chicago, Dallas, etc.) to maximize total profits. It lists the decision variables (production quantities), revenues, costs and profit margins for each product/plant combination. It also shows the model found an optimal solution with total profits of $125,460,012.75 by allocating production across the different options within the capacity constraints for each plant.

Uploaded by

Samantha Hazell
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
2K views22 pages

Northwest Newsprint

The document appears to be an optimization model for allocating production of different newsprint products (SM, NM, DU) across various plants (Chicago, Dallas, etc.) to maximize total profits. It lists the decision variables (production quantities), revenues, costs and profit margins for each product/plant combination. It also shows the model found an optimal solution with total profits of $125,460,012.75 by allocating production across the different options within the capacity constraints for each plant.

Uploaded by

Samantha Hazell
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 22

Decision Variables Revenue/Ton Prod Cost Ship Cost Profit Margin

a 55608 SM-Chicago $ 750 $ 89.77 $ 390 $ 270.23


b 64976 SM-Dallas $ 750 $ 162.24 $ 390 $ 197.76
c 0 SM-NO $ 750 $ 166.18 $ 390 $ 193.82
d 23832 SM-Denver $ 750 $ 151.77 $ 390 $ 208.23
e 0 SM-SF $ 750 $ 151.11 $ 390 $ 208.89
f 40727 NM-Seattle $ 750 $ 46.68 $ 415 $ 288.32
g 0 NM-Chicago $ 750 $ 128.82 $ 415 $ 206.18
h 27704 NM-Dallas $ 750 $ 204.13 $ 415 $ 130.87 Seattle
i 92680 NM-NO $ 750 $ 195.08 $ 415 $ 139.92 Chicago
j 0 NM-Denver $ 750 $ 162.83 $ 415 $ 172.17 Dallas
k 22401 NM-LA $ 750 $ 147.46 $ 415 $ 187.54 NO
l 52960 NM-SF $ 750 $ 115.49 $ 415 $ 219.51 Denver
m 0 NM-Vancouver $ 700 $ 72.42 $ 415 $ 212.58 LA
n 0 NM-Calgary $ 700 $ 77.50 $ 415 $ 207.50 SF
o 0 DU-Seattle $ 750 $ 52.80 $ 415 $ 282.20 Vancouver
p 0 DU-Chicago $ 750 $ 97.17 $ 415 $ 237.83 Calgary
q 0 DU-Dallas $ 750 $ 210.42 $ 415 $ 124.58
r 0 DU-NO $ 750 $ 200.62 $ 415 $ 134.38
s 0 DU-Denver $ 750 $ 142.82 $ 415 $ 192.18
t 189440 DU-LA $ 750 $ 150.14 $ 415 $ 184.86
u 0 DU-SF $ 750 $ 124.83 $ 415 $ 210.17
v 32581 DU-Vancouver $ 700 $ 42.17 $ 415 $ 242.83
w 8145 DU-Calgary $ 700 $ 87.94 $ 415 $ 197.06
144,416 Total Capacity <= 166,320
236,472 Total Capacity <= 272,340
230,166 Total Capacity <= 265,077

144,416 Total Operating Level >= 133,056


236,472 Total Operating Level >= 217,340
230,166 Total Operating Level >= 212,062
40,727 Total Demand = 40,727
55,608 Total Demand = 55,608
92,680 Total Demand = 92,680
92,680 Total Demand = 92,680
23,832 Total Demand = 23,832
211,841 Total Demand = 211,841
52,960 Total Demand = 52,960
32,581 Total Demand = 32,581
8,145 Total Demand = 8,145

Max Profits $ 121,537,867.15


Microsoft Excel 14.0 Answer Report
Worksheet: [NorthwestNewsprintV2.xlsx]AfterOptimization
Report Created: 1/7/2016 1:11:33 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.046 Seconds.
Iterations: 19 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 (Max)


Cell Name Original Value Final Value
$K$19 Max Profits $ 121,537,867.15 $ 125,460,012.75

Variable Cells
Cell Name Original Value Final Value Integer
$B$2 a Decision Variables 55608 0 Contin
$B$3 b Decision Variables 64976 92680 Contin
$B$4 c Decision Variables 0 73640 Contin
$B$5 d Decision Variables 23832 0 Contin
$B$6 e Decision Variables 0 0 Contin
$B$7 f Decision Variables 40727 40727 Contin
$B$8 g Decision Variables 0 0 Contin
$B$9 h Decision Variables 27704 0 Contin
$B$10 i Decision Variables 92680 19040 Contin
$B$11 j Decision Variables 0 0 Contin
$B$12 k Decision Variables 22401 96654 Contin
$B$13 l Decision Variables 52960 52960 Contin
$B$14 m Decision Variables 0 0 Contin
$B$15 n Decision Variables 0 8145 Contin
$B$16 o Decision Variables 0 0 Contin
$B$17 p Decision Variables 0 55608 Contin
$B$18 q Decision Variables 0 0 Contin
$B$19 r Decision Variables 0 0 Contin
$B$20 s Decision Variables 0 23832 Contin
$B$21 t Decision Variables 189440 115187 Contin
$B$22 u Decision Variables 0 0 Contin
$B$23 v Decision Variables 32581 32581 Contin
$B$24 w Decision Variables 8145 0 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$I$2 SM-Chicago 166,320 $I$2<=$K$2 Binding 0
$I$3 SM-Dallas 217,526 $I$3<=$K$3 Not Binding 54814
$I$4 SM-NO 227,208 $I$4<=$K$4 Not Binding 37869
$I$6 SM-SF 166,320 $I$6>=$K$6 Not Binding 33,264
$I$7 NM-Seattle 217,526 $I$7>=$K$7 Not Binding 186
$I$8 NM-Chicago 227,208 $I$8>=$K$8 Binding -
$I$9 Seattle 40,727 $I$9=$K$9 Binding 0
$I$10 Chicago 55,608 $I$10=$K$10 Binding 0
$I$11 Dallas 92,680 $I$11=$K$11 Binding 0
$I$12 NO 92,680 $I$12=$K$12 Binding 0
$I$13 Denver 23,832 $I$13=$K$13 Binding 0
$I$14 LA 211,841 $I$14=$K$14 Binding 0
$I$15 SF 52,960 $I$15=$K$15 Binding 0
$I$16 Vancouver 32,581 $I$16=$K$16 Binding 0
$I$17 Calgary 8,145 $I$17=$K$17 Binding 0
Microsoft Excel 14.0 Sensitivity Report
Worksheet: [NorthwestNewsprintV2.xlsx]AfterOptimization
Report Created: 1/7/2016 1:11:34 AM

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$2 a Decision Variables 0 -24.18 270.23 24.18 1E+030
$B$3 b Decision Variables 92680 0 197.76 1E+030 12.99
$B$4 c Decision Variables 73640 0 193.82 12.99 24.18
$B$5 d Decision Variables 0 -40.53 208.23 40.53 1E+030
$B$6 e Decision Variables 0 -64.52 208.89 64.52 1E+030
$B$7 f Decision Variables 40727 0 288.32 1E+030 3.44
$B$8 g Decision Variables 0 -34.33 206.18 34.33 1E+030
$B$9 h Decision Variables 0 -12.99 130.87 12.99 1E+030
$B$10 i Decision Variables 19040 0 139.92 24.18 2.86
$B$11 j Decision Variables 0 -22.69 172.17 22.69 1E+030
$B$12 k Decision Variables 96654 0 187.54 2.86 2.68
$B$13 l Decision Variables 52960 0 219.51 1E+030 6.66
$B$14 m Decision Variables 0 -32.93 212.58 32.93 1E+030
$B$15 n Decision Variables 8145 0 207.5 1E+030 7.76
$B$16 o Decision Variables 0 -3.44 282.2 3.44 1E+030
$B$17 p Decision Variables 55608 0 237.83 1E+030 24.18
$B$18 q Decision Variables 0 -16.6 124.58 16.6 1E+030
$B$19 r Decision Variables 0 -2.86 134.38 2.86 1E+030
$B$20 s Decision Variables 23832 0 192.18 1E+030 22.69
$B$21 t Decision Variables 115187 0 184.86 2.68 2.86
$B$22 u Decision Variables 0 -6.66 210.17 6.66 1E+030
$B$23 v Decision Variables 32581 0 242.83 1E+030 32.93
$B$24 w Decision Variables 0 -7.76 197.06 7.76 1E+030

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$I$2 SM-Chicago 166320 53.9 166320 186 33264
$I$3 SM-Dallas 217526 0 272340 1E+030 54814
$I$4 SM-NO 227208 0 265077 1E+030 37869
$I$6 SM-SF 166320 0 133056 33264 1E+030
$I$7 NM-Seattle 217526 0 217340 186 1E+030
$I$8 NM-Chicago 227208 -2.68 227208 186 54814
$I$9 Seattle 40727 288.32 40727 54814 186
$I$10 Chicago 55608 240.51 55608 54814 186
$I$11 Dallas 92680 143.86 92680 54814 186
$I$12 NO 92680 139.92 92680 54814 186
$I$13 Denver 23832 194.86 23832 54814 186
$I$14 LA 211841 187.54 211841 54814 186
$I$15 SF 52960 219.51 52960 54814 186
$I$16 Vancouver 32581 245.51 32581 54814 186
$I$17 Calgary 8145 207.5 8145 54814 186
Microsoft Excel 14.0 Limits Report
Worksheet: [NorthwestNewsprintV2.xlsx]AfterOptimization
Report Created: 1/7/2016 1:11:34 AM

Objective
Cell Name Value
$K$19 Max Profits $ 125,460,012.75

Variable Lower Objective Upper Objective


Cell Name Value Limit Result Limit Result
$B$2 a Decision Variables 0 0 125460012.8 0 125460012.8
$B$3 b Decision Variables 92680 92680 125460012.8 92680 125460012.8
$B$4 c Decision Variables 73640 73640 125460012.8 73640 125460012.8
$B$5 d Decision Variables 0 0 125460012.8 0 125460012.8
$B$6 e Decision Variables 0 0 125460012.8 0 125460012.8
$B$7 f Decision Variables 40727 40727 125460012.8 40727 125460012.8
$B$8 g Decision Variables 0 0 125460012.8 0 125460012.8
$B$9 h Decision Variables 0 0 125460012.8 0 125460012.8
$B$10 i Decision Variables 19040 19040 125460012.8 19040 125460012.8
$B$11 j Decision Variables 0 0 125460012.8 0 125460012.8
$B$12 k Decision Variables 96654 96654 125460012.8 96654 125460012.8
$B$13 l Decision Variables 52960 52960 125460012.8 52960 125460012.8
$B$14 m Decision Variables 0 0 125460012.8 0 125460012.8
$B$15 n Decision Variables 8145 8145 125460012.8 8145 125460012.8
$B$16 o Decision Variables 0 0 125460012.8 0 125460012.8
$B$17 p Decision Variables 55608 55608 125460012.8 55608 125460012.8
$B$18 q Decision Variables 0 0 125460012.8 0 125460012.8
$B$19 r Decision Variables 0 0 125460012.8 0 125460012.8
$B$20 s Decision Variables 23832 23832 125460012.8 23832 125460012.8
$B$21 t Decision Variables 115187 115187 125460012.8 115187 125460012.8
$B$22 u Decision Variables 0 0 125460012.8 0 125460012.8
$B$23 v Decision Variables 32581 32581 125460012.8 32581 125460012.8
$B$24 w Decision Variables 0 0 125460012.8 0 125460012.8
Decision Variables Revenue/Ton Prod Cost Ship Cost Profit Margin
a - SM-Chicago $ 750 $ 89.77 $ 390 $ 270.23
b 92,680 SM-Dallas $ 750 $ 162.24 $ 390 $ 197.76
c 73,640 SM-NO $ 750 $ 166.18 $ 390 $ 193.82
d - SM-Denver $ 750 $ 151.77 $ 390 $ 208.23
e - SM-SF $ 750 $ 151.11 $ 390 $ 208.89
f 40,727 NM-Seattle $ 750 $ 46.68 $ 415 $ 288.32
g - NM-Chicago $ 750 $ 128.82 $ 415 $ 206.18
h - NM-Dallas $ 750 $ 204.13 $ 415 $ 130.87 Seattle
i 19,040 NM-NO $ 750 $ 195.08 $ 415 $ 139.92 Chicago
j - NM-Denver $ 750 $ 162.83 $ 415 $ 172.17 Dallas
k 111,800 NM-LA $ 750 $ 147.46 $ 415 $ 187.54 NO
l 52,960 NM-SF $ 750 $ 115.49 $ 415 $ 219.51 Denver
m - NM-Vancouver $ 700 $ 72.42 $ 415 $ 212.58 LA
n 8,145 NM-Calgary $ 700 $ 77.50 $ 415 $ 207.50 SF
o - DU-Seattle $ 750 $ 52.80 $ 415 $ 282.20 Vancouver
p 55,608 DU-Chicago $ 750 $ 97.17 $ 415 $ 237.83 Calgary
q - DU-Dallas $ 750 $ 210.42 $ 415 $ 124.58
r - DU-NO $ 750 $ 200.62 $ 415 $ 134.38
s 23,832 DU-Denver $ 750 $ 142.82 $ 415 $ 192.18
t 100,041 DU-LA $ 750 $ 150.14 $ 415 $ 184.86
u - DU-SF $ 750 $ 124.83 $ 415 $ 210.17
v 32,581 DU-Vancouver $ 700 $ 42.17 $ 415 $ 242.83
w - DU-Calgary $ 700 $ 87.94 $ 415 $ 197.06
166,320 Total Capacity <= 166,320
232,672 Total Capacity <= 272,340
212,062 Total Capacity <= 265,077

166,320 Total Operating Level >= 133,056


232,672 Total Operating Level >= 217,340
212,062 Total Operating Level >= 212,062
40,727 Total Demand = 40,727
55,608 Total Demand = 55,608
92,680 Total Demand = 92,680
92,680 Total Demand = 92,680
23,832 Total Demand = 23,832
211,841 Total Demand = 211,841
52,960 Total Demand = 52,960
32,581 Total Demand = 32,581
8,145 Total Demand = 8,145

Max Profits $ 125,500,604.03


Decision Variables Revenue/Ton Prod Cost Ship Cost Profit Margin
a - SM-Chicago $ 750 $ 89.77 $ 390 $ 270.23
b 92,680 SM-Dallas $ 750 $ 162.24 $ 390 $ 197.76
c 73,640 SM-NO $ 750 $ 166.18 $ 390 $ 193.82
d - SM-Denver $ 750 $ 151.77 $ 390 $ 208.23
e - SM-SF $ 750 $ 151.11 $ 390 $ 208.89
f 40,727 NM-Seattle $ 750 $ 46.68 $ 415 $ 288.32
g - NM-Chicago $ 750 $ 128.82 $ 415 $ 206.18
h - NM-Dallas $ 750 $ 204.13 $ 415 $ 130.87 Seattle
i 19,040 NM-NO $ 750 $ 195.08 $ 415 $ 139.92 Chicago
j - NM-Denver $ 750 $ 162.83 $ 415 $ 172.17 Dallas
k 111,800 NM-LA $ 750 $ 147.46 $ 394 $ 208.29 NO
l 52,960 NM-SF $ 750 $ 115.49 $ 415 $ 219.51 Denver
m - NM-Vancouver $ 700 $ 72.42 $ 415 $ 212.58 LA
n 8,145 NM-Calgary $ 700 $ 77.50 $ 415 $ 207.50 SF
o - DU-Seattle $ 750 $ 52.80 $ 415 $ 282.20 Vancouver
p 55,608 DU-Chicago $ 750 $ 97.17 $ 415 $ 237.83 Calgary
q - DU-Dallas $ 750 $ 210.42 $ 415 $ 124.58
r - DU-NO $ 750 $ 200.62 $ 415 $ 134.38
s 23,832 DU-Denver $ 750 $ 142.82 $ 415 $ 192.18
t 100,041 DU-LA $ 750 $ 150.14 $ 394 $ 205.61
u - DU-SF $ 750 $ 124.83 $ 415 $ 210.17
v 32,581 DU-Vancouver $ 700 $ 42.17 $ 415 $ 242.83
w - DU-Calgary $ 700 $ 87.94 $ 415 $ 197.06
166,320 Total Capacity <= 166,320
232,672 Total Capacity <= 272,340
212,062 Total Capacity <= 265,077

166,320 Total Operating Level >= 133,056


232,672 Total Operating Level >= 217,340
212,062 Total Operating Level >= 212,062
40,727 Total Demand = 40,727
55,608 Total Demand = 55,608
92,680 Total Demand = 92,680
92,680 Total Demand = 92,680
23,832 Total Demand = 23,832
211,841 Total Demand = 211,841
52,960 Total Demand = 52,960
32,581 Total Demand = 32,581
8,145 Total Demand = 8,145

Max Profits $ 129,896,304.78


Decision Variables Revenue/Ton Prod Cost Ship Cost Profit Margin
a 55608 SM-Chicago $ 750 $ 89.77 $ 390 $ 270.23 SM
b 64976 SM-Dallas $ 750 $ 162.24 $ 390 $ 197.76 NM
c 0 SM-NO $ 750 $ 166.18 $ 390 $ 193.82 DU
d 23832 SM-Denver $ 750 $ 151.77 $ 390 $ 208.23
e 0 SM-SF $ 750 $ 151.11 $ 390 $ 208.89 SM
f 40727 NM-Seattle $ 750 $ 46.68 $ 415 $ 288.32 NM
g 0 NM-Chicago $ 750 $ 128.82 $ 415 $ 206.18 DU
h 27704 NM-Dallas $ 750 $ 204.13 $ 415 $ 130.87 Seattle
i 92680 NM-NO $ 750 $ 195.08 $ 415 $ 139.92 Chicago
j 0 NM-Denver $ 750 $ 162.83 $ 415 $ 172.17 Dallas
k 22401 NM-LA $ 750 $ 147.46 $ 415 $ 187.54 NO
l 52960 NM-SF $ 750 $ 115.49 $ 415 $ 219.51 Denver
m 0 NM-Vancouver $ 700 $ 72.42 $ 415 $ 212.58 LA
n 0 NM-Calgary $ 700 $ 77.50 $ 415 $ 207.50 SF
o 0 DU-Seattle $ 750 $ 52.80 $ 415 $ 282.20 Vancouver
p 0 DU-Chicago $ 750 $ 97.17 $ 415 $ 237.83 Calgary
q 0 DU-Dallas $ 750 $ 210.42 $ 415 $ 124.58
r 0 DU-NO $ 750 $ 200.62 $ 415 $ 134.38
s 0 DU-Denver $ 750 $ 142.82 $ 415 $ 192.18
t 189440 DU-LA $ 750 $ 150.14 $ 415 $ 184.86
u 0 DU-SF $ 750 $ 124.83 $ 415 $ 210.17
v 32581 DU-Vancouver $ 700 $ 42.17 $ 415 $ 242.83
w 8145 DU-Calgary $ 700 $ 87.94 $ 415 $ 197.06
144,416 Total Capacity <= 166,320
236,472 Total Capacity <= 272,340
230,166 Total Capacity <= 265,077

144,416 Total Operating Level >= 133,056


236,472 Total Operating Level >= 217,340
230,166 Total Operating Level >= 212,062
40,727 Total Demand = 40,727
55,608 Total Demand = 55,608
92,680 Total Demand = 92,680
92,680 Total Demand = 92,680
23,832 Total Demand = 23,832
211,841 Total Demand = 211,841
52,960 Total Demand = 52,960
32,581 Total Demand = 32,581
8,145 Total Demand = 8,145

Max Profits $ 121,537,867.15


Microsoft Excel 14.0 Answer Report
Worksheet: [NorthwestNewsprintV2.xlsx]AfterOptAlt1
Report Created: 1/7/2016 2:08:10 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.047 Seconds.
Iterations: 20 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 (Max)


Cell Name Original Value Final Value
$K$19 Max Profits $ 125,451,474.27 $ 125,451,474.27

Variable Cells
Cell Name Original Value Final Value Integer
$B$2 a Decision Variables 0 0 Contin
$B$3 b Decision Variables 92680 92680 Contin
$B$4 c Decision Variables 73640 73640 Contin
$B$5 d Decision Variables 0 0 Contin
$B$6 e Decision Variables 0 0 Contin
$B$7 f Decision Variables 40727 40727 Contin
$B$8 g Decision Variables 0 0 Contin
$B$9 h Decision Variables 0 0 Contin
$B$10 i Decision Variables 19040 19040 Contin
$B$11 j Decision Variables 0 0 Contin
$B$12 k Decision Variables 93468 93468 Contin
$B$13 l Decision Variables 52960 52960 Contin
$B$14 m Decision Variables 0 0 Contin
$B$15 n Decision Variables 8145 8145 Contin
$B$16 o Decision Variables 0 0 Contin
$B$17 p Decision Variables 55608 55608 Contin
$B$18 q Decision Variables 0 0 Contin
$B$19 r Decision Variables 0 0 Contin
$B$20 s Decision Variables 23832 23832 Contin
$B$21 t Decision Variables 118373 118373 Contin
$B$22 u Decision Variables 0 0 Contin
$B$23 v Decision Variables 32581 32581 Contin
$B$24 w Decision Variables 0 0 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$I$2 SM 166,320 $I$2<=$K$2 Binding 0
$I$3 NM 214,340 $I$3<=$K$3 Binding 0
$I$4 DU 230,394 $I$4<=$K$4 Not Binding 34683
$I$6 SM 166,320 $I$6>=$K$6 Not Binding 33,264
$I$7 NM 214,340 $I$7>=$K$7 Not Binding 30,563
$I$8 DU 230,394 $I$8>=$K$8 Not Binding 18,332
$I$9 Seattle 40,727 $I$9=$K$9 Binding 0
$I$10 Chicago 55,608 $I$10=$K$10 Binding 0
$I$11 Dallas 92,680 $I$11=$K$11 Binding 0
$I$12 NO 92,680 $I$12=$K$12 Binding 0
$I$13 Denver 23,832 $I$13=$K$13 Binding 0
$I$14 LA 211,841 $I$14=$K$14 Binding 0
$I$15 SF 52,960 $I$15=$K$15 Binding 0
$I$16 Vancouver 32,581 $I$16=$K$16 Binding 0
$I$17 Calgary 8,145 $I$17=$K$17 Binding 0
Microsoft Excel 14.0 Sensitivity Report
Worksheet: [NorthwestNewsprintV2.xlsx]AfterOptAlt1
Report Created: 1/7/2016 2:08:11 AM

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$2 a Decision Variables 0 -24.18 270.23 24.18 1E+030
$B$3 b Decision Variables 92680 0 197.76 1E+030 12.99
$B$4 c Decision Variables 73640 0 193.82 12.99 24.18
$B$5 d Decision Variables 0 -40.53 208.23 40.53 1E+030
$B$6 e Decision Variables 0 -64.52 208.89 64.52 1E+030
$B$7 f Decision Variables 40727 0 288.32 1E+030 3.44
$B$8 g Decision Variables 0 -34.33 206.18 34.33 1E+030
$B$9 h Decision Variables 0 -12.99 130.87 12.99 1E+030
$B$10 i Decision Variables 19040 0 139.92 24.18 2.86
$B$11 j Decision Variables 0 -22.69 172.17 22.69 1E+030
$B$12 k Decision Variables 93468 0 187.54 2.86 2.68
$B$13 l Decision Variables 52960 0 219.51 1E+030 6.66
$B$14 m Decision Variables 0 -32.93 212.58 32.93 1E+030
$B$15 n Decision Variables 8145 0 207.5 1E+030 7.76
$B$16 o Decision Variables 0 -3.44 282.2 3.44 1E+030
$B$17 p Decision Variables 55608 0 237.83 1E+030 24.18
$B$18 q Decision Variables 0 -16.6 124.58 16.6 1E+030
$B$19 r Decision Variables 0 -2.86 134.38 2.86 1E+030
$B$20 s Decision Variables 23832 0 192.18 1E+030 22.69
$B$21 t Decision Variables 118373 0 184.86 2.68 2.86
$B$22 u Decision Variables 0 -6.66 210.17 6.66 1E+030
$B$23 v Decision Variables 32581 0 242.83 1E+030 32.93
$B$24 w Decision Variables 0 -7.76 197.06 7.76 1E+030

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$I$2 SM 166320 56.58 166320 18332 33264
$I$3 NM 214340 2.68 214340 18332 30562.7406
$I$4 DU 230394 0 265077 1E+030 34683
$I$6 SM 166320 0 133056 33264 1E+030
$I$7 NM 214340 0 183777.2594 30562.7406 1E+030
$I$8 DU 230394 0 212062 18332 1E+030
$I$9 Seattle 40727 285.64 40727 34683 18332
$I$10 Chicago 55608 237.83 55608 34683 18332
$I$11 Dallas 92680 141.18 92680 34683 18332
$I$12 NO 92680 137.24 92680 34683 18332
$I$13 Denver 23832 192.18 23832 34683 18332
$I$14 LA 211841 184.86 211841 34683 18332
$I$15 SF 52960 216.83 52960 34683 18332
$I$16 Vancouver 32581 242.83 32581 34683 18332
$I$17 Calgary 8145 204.82 8145 34683 8145
Microsoft Excel 14.0 Limits Report
Worksheet: [NorthwestNewsprintV2.xlsx]AfterOptAlt1
Report Created: 1/7/2016 2:08:11 AM

Objective
Cell Name Value
$K$19 Max Profits $ 125,451,474.27

Variable Lower Objective Upper Objective


Cell Name Value Limit Result Limit Result
$B$2 a Decision Variables 0 0 125451474.3 0 125451474.3
$B$3 b Decision Variables 92680 92680 125451474.3 92680 125451474.3
$B$4 c Decision Variables 73640 73640 125451474.3 73640 125451474.3
$B$5 d Decision Variables 0 0 125451474.3 0 125451474.3
$B$6 e Decision Variables 0 0 125451474.3 0 125451474.3
$B$7 f Decision Variables 40727 40727 125451474.3 40727 125451474.3
$B$8 g Decision Variables 0 0 125451474.3 0 125451474.3
$B$9 h Decision Variables 0 0 125451474.3 0 125451474.3
$B$10 i Decision Variables 19040 19040 125451474.3 19040 125451474.3
$B$11 j Decision Variables 0 0 125451474.3 0 125451474.3
$B$12 k Decision Variables 93468 93468 125451474.3 93468 125451474.3
$B$13 l Decision Variables 52960 52960 125451474.3 52960 125451474.3
$B$14 m Decision Variables 0 0 125451474.3 0 125451474.3
$B$15 n Decision Variables 8145 8145 125451474.3 8145 125451474.3
$B$16 o Decision Variables 0 0 125451474.3 0 125451474.3
$B$17 p Decision Variables 55608 55608 125451474.3 55608 125451474.3
$B$18 q Decision Variables 0 0 125451474.3 0 125451474.3
$B$19 r Decision Variables 0 0 125451474.3 0 125451474.3
$B$20 s Decision Variables 23832 23832 125451474.3 23832 125451474.3
$B$21 t Decision Variables 118373 118373 125451474.3 118373 125451474.3
$B$22 u Decision Variables 0 0 125451474.3 0 125451474.3
$B$23 v Decision Variables 32581 32581 125451474.3 32581 125451474.3
$B$24 w Decision Variables 0 0 125451474.3 0 125451474.3
Decision Variables Revenue/Ton Prod Cost Ship Cost Profit Margin
a 0 SM-Chicago $ 750 $ 89.77 $ 390 $ 270.23 SM
b 92680 SM-Dallas $ 750 $ 162.24 $ 390 $ 197.76 NM
c 73640 SM-NO $ 750 $ 166.18 $ 390 $ 193.82 DU
d 0 SM-Denver $ 750 $ 151.77 $ 390 $ 208.23
e 0 SM-SF $ 750 $ 151.11 $ 390 $ 208.89 SM
f 40727 NM-Seattle $ 750 $ 46.68 $ 415 $ 288.32 NM
g 0 NM-Chicago $ 750 $ 128.82 $ 415 $ 206.18 DU
h 0 NM-Dallas $ 750 $ 204.13 $ 415 $ 130.87 Seattle
i 19040 NM-NO $ 750 $ 195.08 $ 415 $ 139.92 Chicago
j 0 NM-Denver $ 750 $ 162.83 $ 415 $ 172.17 Dallas
k 93468 NM-LA $ 750 $ 147.46 $ 415 $ 187.54 NO
l 52960 NM-SF $ 750 $ 115.49 $ 415 $ 219.51 Denver
m 0 NM-Vancouver $ 700 $ 72.42 $ 415 $ 212.58 LA
n 8145 NM-Calgary $ 700 $ 77.50 $ 415 $ 207.50 SF
o 0 DU-Seattle $ 750 $ 52.80 $ 415 $ 282.20 Vancouver
p 55608 DU-Chicago $ 750 $ 97.17 $ 415 $ 237.83 Calgary
q 0 DU-Dallas $ 750 $ 210.42 $ 415 $ 124.58
r 0 DU-NO $ 750 $ 200.62 $ 415 $ 134.38
s 23832 DU-Denver $ 750 $ 142.82 $ 415 $ 192.18
t 118373 DU-LA $ 750 $ 150.14 $ 415 $ 184.86
u 0 DU-SF $ 750 $ 124.83 $ 415 $ 210.17
v 32581 DU-Vancouver $ 700 $ 42.17 $ 415 $ 242.83
w 0 DU-Calgary $ 700 $ 87.94 $ 415 $ 197.06
166,320 Total Capacity <= 166,320
214,340 Total Capacity <= 214,340 Reduction 58000
230,394 Total Capacity <= 265,077

166,320 Total Operating Level >= 133,056


214,340 Total Operating Level >= 183,777
230,394 Total Operating Level >= 212,062
40,727 Total Demand = 40,727
55,608 Total Demand = 55,608
92,680 Total Demand = 92,680
92,680 Total Demand = 92,680
23,832 Total Demand = 23,832
211,841 Total Demand = 211,841
52,960 Total Demand = 52,960
32,581 Total Demand = 32,581
8,145 Total Demand = 8,145

Max Profits $ 125,451,474.27


Production Before Optimization Route Optimization Δ Production
Spruce 144416 166320 7%
Naomee 236472 232672 -0.81%
Duchesne 230166 212062 -4.09%
Profit $ 121,537,867 $ 125,500,604 2%
100K Discount (NM/DU-LA) Δ Production Alt1 58K Press Reduction Δ Production
166,320 7% 166,320 7%
232,672 -0.81% 214,340 -4.91%
212,062 -4.09% 230,394 0.05%
$ 129,896,305 3% $ 125,451,474 2%

You might also like