Reve Revenu nue/ e/T Ton Decision Variables Variables a 5560 SSM M!Chicago " #50 b 6($#6 SM SM!Dallas " #50 c 0 SM!*+ " #50 d '&&' SSM M!Denver " #50 e 0 SM!S, " #50 (0#'# *M *M!Sea.le " #50 g 0 *M!Chicago " #50 h '##0( *M *M!Dallas " #50 i $'60 *M!*+ " #50 0 *M!Denver " #50 ''(0) *M!12 " #50 l 5'$60 *M!S, " #50 3 0 *M!Vancouver " #00 n 0 *M!Calgar4 " #00 o 0 D!Sea.le " #50 p 0 D!Chicago " #50 0 D!Dallas " #50 r 0 D!*+ " #50 s 0 D!Denver " #50 t )$((0 D!12 " #50 u 0 D!S, " #50 v &'5) D!Vancouver " #00 7 )(5 D!Calgar4 " #00
Prod Prod Cost Cost " $%## " )6'%'( " )66%) " )5)%## " )5)%)) " (6%6 " )'%' " '0(%)& " )$5%0 " )6'%& " )(#%(6 " ))5%($ " #'%(' " ##%50 " 5'%0 " $#%)# " ')0%(' " '00%6' " )('%' " )50%)( " )'(%& " ('%)# " #%$(
Ship Ship Cost Cost " &$ &$0 " &$ &$0 " &$0 " &$ &$0 " &$0 " ()5 " ()5 " () ( )5 " () ()5 " ()5 " () ()5 " () ()5 " ()5 " ()5 " () ()5 " () ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5
Prof Proftt Margi Margin n " '#0%'& " )$#%#6 " )$&%' " '0%'& " '0%$ " '%&' " '06%) " )&0%# " )&$%$' " )#'%)# " )#%5( " ')$%5) " ')'%5 " '0#%50 " ''%'0 " '%& " )'(%5 " )&(%& " )$'%) " )(%6 " ')0%)# " '('%& " )$#%06
Sea.le Chicago Dallas *+ Denver 12 S, Vancouver Calgar4
)((8()6 '&68(#' '&08)66
Total Capacit4 9: Total Capacit4 9: Total Capacit4 9:
)668&'0 '#'8&(0 '6580##
)((8()6 Total +pera;ng +pera;ng 1eve 1evell <: '&68(#' Total +pera;ng +pera;ng 1eve 1evell <: '&08)66 Total +pera;ng +pera;ng 1eve 1evell <: (08#'# Total De3and : 55860 Total De3and : $'860 Total De3and : $'860 Total De3and : '&8&' Total De3and : '))8() Total De3and : 5'8$60 Total De3and : &'85) Total De3and : 8)(5 Total De3and :
)&&8056 ')#8&(0 ')'806' (08#'# 55860 $'860 $'860 '&8&' '))8() 5'8$60 &'85) 8)(5
Ma= Profts Profts " )')856#%) )')856#%)5 5
Microsof Excel 14.0 Answer Report Worksheet: [NorthwestNewsprintV2.xlsx]Aferp!"i#$!on Report %re$te&: 1'('201) 1:11:** AM Res+lt: ,ol-er o+n& $ sol+!on. All %onstr$ints $n& op!"$lit/ con&i!ons $re s$!se&. ,ol-er Enine >ngine? Si3ple= 1P Solu;on Ti3e? 0%0(6 Seconds% @tera;ons? )$ Subproble3s? 0 ,ol-er p!ons Ma= Ti3e nli3ited8 @tera;ons nli3ited8 Precision 0%00000)8 se 2uto3a;c Scaling Ma= Subproble3s nli3ited8 Ma= @nteger Sols nli3ited8 @nteger Tolerance )A8 2ssu3e *on*ega;ve
+bec;ve Cell BMa= %ell N$"e "")$ Ma= Profts
Variable Cells %ell N$"e "E"' a Decision Variables "E"& b Decision Variables "E"( c Decision Variables "E"5 d Decision Variables "E"6 e Decision Variables "E"# - Decision Variables "E" g Decision Variables "E"$ h Decision Variables "E")0 i Decision Variables "E")) Decision Variables "E")' Decision Variables "E")& l Decision Variables "E")( 3 Decision Variables "E")5 n Decision Variables "E")6 o Decision Variables "E")# p Decision Variables "E") Decision Variables "E")$ r Decision Variables "E"'0 s Decision Variables "E"') t Decision Variables "E"'' u Decision Variables "E"'& v Decision Variables "E"'( 7 Decision Variables
Constraints %ell
N$"e
riin$l V$l+e in$l V$l+e " )')856#%)5 " )'58(6080)'%#5
riin$l V$l+e 5560 6($#6 0 '&&' 0 (0#'# 0 '##0( $'60 0 ''(0) 5'$60 0 0 0 0 0 0 0 )$((0 0 &'5) )(5
%ell V$l+e
in$l V$l+e
3nteer 0 Con;n $'60 Con;n #&6(0 Con;n 0 Con;n 0 Con;n (0#'# Con;n 0 Con;n 0 Con;n )$0(0 Con;n 0 Con;n $665( Con;n 5'$60 Con;n 0 Con;n )(5 Con;n 0 Con;n 5560 Con;n 0 Con;n 0 Con;n '&&' Con;n ))5)# Con;n 0 Con;n &'5) Con;n 0 Con;n
or"+l$
,t$t+s
,l$ck
"@"' "@"& "@"( "@"6 "@"# "@" "@"$ "@")0 "@")) "@")' "@")& "@")( "@")5 "@")6 "@")#
SM!Chicago SM!Dallas SM!*+ SM!S, *M!Sea.le *M!Chicago Sea.le Chicago Dallas *+ Denver 12 S, Vancouver Calgar4
)668&'0 ')#85'6 ''#8'0 )668&'0 ')#85'6 ''#8'0 (08#'# 55860 $'860 $'860 '&8&' '))8() 5'8$60 &'85) 8)(5
"@"'9:""' "@"&9:""& "@"(9:""( "@"6<:""6 "@"#<:""# "@"<:"" "@"$:""$ "@")0:"")0 "@")):"")) "@")':"")' "@")&:"")& "@")(:"")( "@")5:"")5 "@")6:"")6 "@")#:"")#
Einding *ot Einding *ot Einding *ot Einding *ot Einding Einding Einding Einding Einding Einding Einding Einding Einding Einding Einding
0 5()( 6$ &&8'6( )6 ! 0 0 0 0 0 0 0 0 0
Microsof Excel 14.0 ,ensi!-it/ Report Worksheet: [NorthwestNewsprintV2.xlsx]Aferp!"i#$!on Report %re$te&: 1'('201) 1:11:*4 AM
Variable Cells in$l Re&+ce& 5ec!-e Allow$le Allow$le %ell N$"e V$l+e %ost %oe6cient 3ncre$se 7ecre$se "E"' a Decision Variables 0 !'(%) '#0%'& '(%) )>F0&0 "E"& b Decision Variables $'60 0 )$#%#6 )>F0&0 )'%$$ "E"( c Decision Variables #&6(0 0 )$&%' )'%$$ '(%) "E"5 d Decision Variables 0 !(0%5& '0%'& (0%5& )>F0&0 "E"6 e Decision Variables 0 !6(%5' '0%$ 6(%5' )>F0&0 "E"# - Decision Variables (0#'# 0 '%&' )>F0&0 &%(( "E" g Decision Variables 0 !&(%&& '06%) &(%&& )>F0&0 "E"$ h Decision Variables 0 !)'%$$ )&0%# )'%$$ )>F0&0 "E")0 i Decision Variables )$0(0 0 )&$%$' '(%) '%6 "E")) Decision Variables 0 !''%6$ )#'%)# ''%6$ )>F0&0 "E")' Decision Variables $665( 0 )#%5( '%6 '%6 "E")& l Decision Variables 5'$60 0 ')$%5) )>F0&0 6%66 "E")( 3 Decision Variables 0 !&'%$& ')'%5 &'%$& )>F0&0 "E")5 n Decision Variables )(5 0 '0#%5 )>F0&0 #%#6 "E")6 o Decision Variables 0 !&%(( ''%' &%(( )>F0&0 "E")# p Decision Variables 5560 0 '%& )>F0&0 '(%) "E") Decision Variables 0 !)6%6 )'(%5 )6%6 )>F0&0 "E")$ r Decision Variables 0 !'%6 )&(%& '%6 )>F0&0 "E"'0 s Decision Variables '&&' 0 )$'%) )>F0&0 ''%6$ "E"') t Decision Variables ))5)# 0 )(%6 '%6 '%6 "E"'' u Decision Variables 0 !6%66 ')0%)# 6%66 )>F0&0 "E"'& v Decision Variables &'5) 0 '('%& )>F0&0 &'%$& "E"'( 7 Decision Variables 0 !#%#6 )$#%06 #%#6 )>F0&0 Constraints %ell "@"' "@"& "@"( "@"6 "@"# "@" "@"$ "@")0 "@")) "@")' "@")& "@")(
N$"e SM!Chicago SM!Dallas SM!*+ SM!S, *M!Sea.le *M!Chicago Sea.le Chicago Dallas *+ Denver 12
in$l ,h$&ow %onstr$int Allow$le Allow$le V$l+e 8rice R.9. ,i&e 3ncre$se 7ecre$se )66&'0 5&%$ )66&'0 )6 &&'6( ')#5'6 0 '#'&(0 )>F0&0 5()( ''#'0 0 '650## )>F0&0 6$ )66&'0 0 )&&056 &&'6( )>F0&0 ')#5'6 0 ')#&(0 )6 )>F0&0 ''#'0 !'%6 ''#'0 )6 5()( (0#'# '%&' (0#'# 5()( )6 5560 '(0%5) 5560 5()( )6 $'60 )(&%6 $'60 5()( )6 $'60 )&$%$' $'60 5()( )6 '&&' )$(%6 '&&' 5()( )6 '))() )#%5( '))() 5()( )6
"@")5 S, "@")6 Vancouver "@")# Calgar4
5'$60 &'5) )(5
')$%5) '(5%5) '0#%5
5'$60 &'5) )(5
5()( 5()( 5()(
)6 )6 )6
Microsof Excel 14.0 i"its Report Worksheet: [NorthwestNewsprintV2.xlsx]Aferp!"i#$!on Report %re$te&: 1'('201) 1:11:*4 AM
5ec!-e %ell N$"e "")$ Ma= Profts
%ell "E"' "E"& "E"( "E"5 "E"6 "E"# "E" "E"$ "E")0 "E")) "E")' "E")& "E")( "E")5 "E")6 "E")# "E") "E")$ "E"'0 "E"') "E"'' "E"'& "E"'(
V$ri$le N$"e a Decision Variables b Decision Variables c Decision Variables d Decision Variables e Decision Variables - Decision Variables g Decision Variables h Decision Variables i Decision Variables Decision Variables Decision Variables l Decision Variables 3 Decision Variables n Decision Variables o Decision Variables p Decision Variables Decision Variables r Decision Variables s Decision Variables t Decision Variables u Decision Variables v Decision Variables 7 Decision Variables
V$l+e " )'58(6080)'%#5
V$l+e 0 $'60 #&6(0 0 0 (0#'# 0 0 )$0(0 0 $665( 5'$60 0 )(5 0 5560 0 0 '&&' ))5)# 0 &'5) 0
ower i"it 0 $'60 #&6(0 0 0 (0#'# 0 0 )$0(0 0 $665( 5'$60 0 )(5 0 5560 0 0 '&&' ))5)# 0 &'5) 0
5ec!-e Res+lt )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'%
;pper i"it 0 $'60 #&6(0 0 0 (0#'# 0 0 )$0(0 0 $665( 5'$60 0 )(5 0 5560 0 0 '&&' ))5)# 0 &'5) 0
5ec!-e Res+lt )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'% )'5(600)'%
Decision Variables a ! b $'860 c #&86(0 d ! e ! (08#'# g ! h ! i )$80(0 ! )))800 l 5'8$60 3 ! n 8)(5 o ! p 55860 ! r ! s '&8&' t )0080() u ! v &'85) 7 !
Revenue/Ton SM!Chicago " #50 SM!Dallas " #50 SM!*+ " #50 SM!Denver " #50 SM!S, " #50 *M!Sea.le " #50 *M!Chicago " #50 *M!Dallas " #50 *M!*+ " #50 *M!Denver " #50 *M!12 " #50 *M!S, " #50 *M!Vancouver " #00 *M!Calgar4 " #00 D!Sea.le " #50 D!Chicago " #50 D!Dallas " #50 D!*+ " #50 D!Denver " #50 D!12 " #50 D!S, " #50 D!Vancouver " #00 D!Calgar4 " #00
Prod Cost " $%## " )6'%'( " )66%) " )5)%## " )5)%)) " (6%6 " )'%' " '0(%)& " )$5%0 " )6'%& " )(#%(6 " ))5%($ " #'%(' " ##%50 " 5'%0 " $#%)# " ')0%(' " '00%6' " )('%' " )50%)( " )'(%& " ('%)# " #%$(
Ship Cost " &$0 " &$0 " &$0 " &$0 " &$0 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5
Proft Margin " '#0%'& " )$#%#6 " )$&%' " ' 0%'& " '0%$ " '%&' " '06%) " )&0%# " )&$%$' " )#'%)# " )#%5( " ')$%5) " ')'%5 " '0#%50 " ''%'0 " '%& " )'(%5 " )&(%& " )$'%) " )(%6 " ')0%)# " '('%& " )$#%06
Sea.le Chicago Dallas *+ Denver 12 S, Vancouver Calgar4
)668&'0 '&'86#' ')'806'
Total Capacit4 9: Total Capacit4 9: Total Capacit4 9:
)668&'0 '#'8&(0 '6580##
)668&'0 Total +pera;ng 1evel <: '&'86#' Total +pera;ng 1evel <: ')'806' Total +pera;ng 1evel <: (08#'# Total De3and : 55860 Total De3and : $'860 Total De3and : $'860 Total De3and : '&8&' Total De3and : '))8() Total De3and : 5'8$60 Total De3and : &'85) Total De3and : 8)(5 Total De3and :
)&&8056 ')#8&(0 ')'806' (08#'# 55860 $'860 $'860 '&8&' '))8() 5'8$60 &'85) 8)(5
Ma= Profts " )'58500860(%0&
Decision Variables a ! b $'860 c #&86(0 d ! e ! (08#'# g ! h ! i )$80(0 ! )))800 l 5'8$60 3 ! n 8)(5 o ! p 55860 ! r ! s '&8&' t )0080() u ! v &'85) 7 !
Revenue/Ton SM!Chicago " #50 SM!Dallas " #50 SM!*+ " #50 SM!Denver " #50 SM!S, " #50 *M!Sea.le " #50 *M!Chicago " #50 *M!Dallas " #50 *M!*+ " #50 *M!Denver " #50 *M!12 " #50 *M!S, " #50 *M!Vancouver " #00 *M!Calgar4 " #00 D!Sea.le " #50 D!Chicago " #50 D!Dallas " #50 D!*+ " #50 D!Denver " #50 D!12 " #50 D!S, " #50 D!Vancouver " #00 D!Calgar4 " #00
Prod Cost " $%## " )6'%'( " )66%) " )5)%## " )5)%)) " (6%6 " )'%' " '0(%)& " )$5%0 " )6'%& " )(#%(6 " ))5%($ " #'%(' " ##%50 " 5'%0 " $#%)# " ')0%(' " '00%6' " )('%' " )50%)( " )'(%& " ('%)# " #%$(
Ship Cost " &$0 " &$0 " &$0 " &$0 " &$0 " ()5 " ()5 " ()5 " ()5 " ()5 " &$( " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " ()5 " &$( " ()5 " ()5 " ()5
Proft Margin " '#0%'& " )$#%#6 " )$&%' " ' 0%'& " '0%$ " '%&' " '06%) " )&0%# " )&$%$' " )#'%)# " '0%'$ " ')$%5) " ')'%5 " '0#%50 " ''%'0 " '%& " )'(%5 " )&(%& " )$'%) " '05%6) " ')0%)# " '('%& " )$#%06
Sea.le Chicago Dallas *+ Denver 12 S, Vancouver Calgar4
)668&'0 '&'86#' ')'806'
Total Capacit4 9: Total Capacit4 9: Total Capacit4 9:
)668&'0 '#'8&(0 '6580##
)668&'0 Total +pera;ng 1evel <: '&'86#' Total +pera;ng 1evel <: ')'806' Total +pera;ng 1evel <: (08#'# Total De3and : 55860 Total De3and : $'860 Total De3and : $'860 Total De3and : '&8&' Total De3and : '))8() Total De3and : 5'8$60 Total De3and : &'85) Total De3and : 8)(5 Total De3and :
)&&8056 ')#8&(0 ')'806' (08#'# 55860 $'860 $'860 '&8&' '))8() 5'8$60 &'85) 8)(5
M$x 8rots < 12=>?=)>*04.(?
Revenue/Ton Prod Cost Ship Cost Decision Variables a 5560 SM!Chicago " #50 " $%## " &$0 b 6($#6 SM!Dallas " #50 " )6'%'( " &$0 c 0 SM!*+ " #50 " )66%) " &$0 d '&&' SM!Denver " #50 " )5)%## " &$0 e 0 SM!S, " #50 " )5)%)) " &$0 (0#'# *M!Sea.le " #50 " (6%6 " ()5 g 0 *M!Chicago " #50 " )'%' " ()5 h '##0( *M!Dallas " #50 " '0(%)& " ()5 i $'60 *M!*+ " #50 " )$5%0 " ()5 0 *M!Denver " #50 " )6'%& " ()5 ''(0) *M!12 " #50 " )(#%(6 " ()5 l 5'$60 *M!S, " #50 " ))5%($ " ()5 3 0 *M!Vancouver " #00 " #'%(' " ()5 n 0 *M!Calgar4 " #00 " ##%50 " ()5 o 0 D!Sea.le " #50 " 5'%0 " ()5 p 0 D!Chicago " #50 " $#%)# " ()5 0 D!Dallas " #50 " ')0%(' " ()5 r 0 D!*+ " #50 " '00%6' " ()5 s 0 D!Denver " #50 " )('%' " ()5 t )$((0 D!12 " #50 " )50%)( " ()5 u 0 D!S, " #50 " )'(%& " ()5 v &'5) D!Vancouver " #00 " ('%)# " ()5 7 )(5 D!Calgar4 " #00 " #%$( " ()5
Proft Margin " '#0%'& " )$#%#6 " )$&%' " '0%'& " '0%$ " '%&' " '06%) " )&0%# " )&$%$' " )#'%)# " )#%5( " ')$%5) " ')'%5 " '0#%50 " ''%'0 " '%& " )'(%5 " )&(%& " )$'%) " )(%6 " ')0%)# " '('%& " )$#%06
SM *M D SM *M D Sea.le Chicago Dallas *+ Denver 12 S, Vancouver Calgar4
)((8()6 '&68(#' '&08)66
Total Capacit4 9: Total Capacit4 9: Total Capacit4 9:
)668&'0 '#'8&(0 '6580##
)((8()6 Total +pera;ng 1evel <: '&68(#' Total +pera;ng 1evel <: '&08)66 Total +pera;ng 1evel <: (08#'# Total De3and : 55860 Total De3and : $'860 Total De3and : $'860 Total De3and : '&8&' Total De3and : '))8() Total De3and : 5'8$60 Total De3and : &'85) Total De3and : 8)(5 Total De3and :
)&&8056 ')#8&(0 ')'806' (08#'# 55860 $'860 $'860 '&8&' '))8() 5'8$60 &'85) 8)(5
Ma= Profts " )')856#%)5
Microsof Excel 14.0 Answer Report Worksheet: [NorthwestNewsprintV2.xlsx]AferptAlt1 Report %re$te&: 1'('201) 2:0?:10 AM Res+lt: ,ol-er o+n& $ sol+!on. All %onstr$ints $n& op!"$lit/ con&i!ons $re s$!se&. ,ol-er Enine >ngine? Si3ple= 1P Solu;on Ti3e? 0%0(# Seconds% @tera;ons? '0 Subproble3s? 0 ,ol-er p!ons Ma= Ti3e nli3ited8 @tera;ons nli3ited8 Precision 0%00000)8 se 2uto3a;c Scaling Ma= Subproble3s nli3ited8 Ma= @nteger Sols nli3ited8 @nteger Tolerance )A8 2ssu3e *on*ega;ve
+bec;ve Cell BMa= %ell N$"e "")$ Ma= Profts
Variable Cells %ell N$"e "E"' a Decision Variables "E"& b Decision Variables "E"( c Decision Variables "E"5 d Decision Variables "E"6 e Decision Variables "E"# - Decision Variables "E" g Decision Variables "E"$ h Decision Variables "E")0 i Decision Variables "E")) Decision Variables "E")' Decision Variables "E")& l Decision Variables "E")( 3 Decision Variables "E")5 n Decision Variables "E")6 o Decision Variables "E")# p Decision Variables "E") Decision Variables "E")$ r Decision Variables "E"'0 s Decision Variables "E"') t Decision Variables "E"'' u Decision Variables "E"'& v Decision Variables "E"'( 7 Decision Variables
Constraints %ell
N$"e
riin$l V$l+e in$l V$l+e " )'58(5)8(#(%'# " )'58(5)8(#(%'#
riin$l V$l+e 0 $'60 #&6(0 0 0 (0#'# 0 0 )$0(0 0 $&(6 5'$60 0 )(5 0 5560 0 0 '&&' ))& 0 &'5) 0
%ell V$l+e
in$l V$l+e
3nteer 0 Con;n $'60 Con;n #&6(0 Con;n 0 Con;n 0 Con;n (0#'# Con;n 0 Con;n 0 Con;n )$0(0 Con;n 0 Con;n $&(6 Con;n 5'$60 Con;n 0 Con;n )(5 Con;n 0 Con;n 5560 Con;n 0 Con;n 0 Con;n '&&' Con;n ))& Con;n 0 Con;n &'5) Con;n 0 Con;n
or"+l$
,t$t+s
,l$ck
"@"' "@"& "@"( "@"6 "@"# "@" "@"$ "@")0 "@")) "@")' "@")& "@")( "@")5 "@")6 "@")#
SM *M D SM *M D Sea.le Chicago Dallas *+ Denver 12 S, Vancouver Calgar4
)668&'0 ')(8&(0 '&08&$( )668&'0 ')(8&(0 '&08&$( (08#'# 55860 $'860 $'860 '&8&' '))8() 5'8$60 &'85) 8)(5
"@"'9:""' "@"&9:""& "@"(9:""( "@"6<:""6 "@"#<:""# "@"<:"" "@"$:""$ "@")0:"")0 "@")):"")) "@")':"")' "@")&:"")& "@")(:"")( "@")5:"")5 "@")6:"")6 "@")#:"")#
Einding Einding *ot Einding *ot Einding *ot Einding *ot Einding Einding Einding Einding Einding Einding Einding Einding Einding Einding
0 0 &(6& &&8'6( &0856& )8&&' 0 0 0 0 0 0 0 0 0
Microsof Excel 14.0 ,ensi!-it/ Report Worksheet: [NorthwestNewsprintV2.xlsx]AferptAlt1 Report %re$te&: 1'('201) 2:0?:11 AM
Variable Cells in$l Re&+ce& 5ec!-e Allow$le Allow$le %ell N$"e V$l+e %ost %oe6cient 3ncre$se 7ecre$se "E"' a Decision Variables 0 !'(%) '#0%'& '(%) )>F0&0 "E"& b Decision Variables $'60 0 )$#%#6 )>F0&0 )'%$$ "E"( c Decision Variables #&6(0 0 )$&%' )'%$$ '(%) "E"5 d Decision Variables 0 !(0%5& '0%'& (0%5& )>F0&0 "E"6 e Decision Variables 0 !6(%5' '0%$ 6(%5' )>F0&0 "E"# - Decision Variables (0#'# 0 '%&' )>F0&0 &%(( "E" g Decision Variables 0 !&(%&& '06%) &(%&& )>F0&0 "E"$ h Decision Variables 0 !)'%$$ )&0%# )'%$$ )>F0&0 "E")0 i Decision Variables )$0(0 0 )&$%$' '(%) '%6 "E")) Decision Variables 0 !''%6$ )#'%)# ''%6$ )>F0&0 "E")' Decision Variables $&(6 0 )#%5( '%6 '%6 "E")& l Decision Variables 5'$60 0 ')$%5) )>F0&0 6%66 "E")( 3 Decision Variables 0 !&'%$& ')'%5 &'%$& )>F0&0 "E")5 n Decision Variables )(5 0 '0#%5 )>F0&0 #%#6 "E")6 o Decision Variables 0 !&%(( ''%' &%(( )>F0&0 "E")# p Decision Variables 5560 0 '%& )>F0&0 '(%) "E") Decision Variables 0 !)6%6 )'(%5 )6%6 )>F0&0 "E")$ r Decision Variables 0 !'%6 )&(%& '%6 )>F0&0 "E"'0 s Decision Variables '&&' 0 )$'%) )>F0&0 ''%6$ "E"') t Decision Variables ))& 0 )(%6 '%6 '%6 "E"'' u Decision Variables 0 !6%66 ')0%)# 6%66 )>F0&0 "E"'& v Decision Variables &'5) 0 '('%& )>F0&0 &'%$& "E"'( 7 Decision Variables 0 !#%#6 )$#%06 #%#6 )>F0&0 Constraints %ell "@"' "@"& "@"( "@"6 "@"# "@" "@"$ "@")0 "@")) "@")' "@")& "@")(
N$"e SM *M D SM *M D Sea.le Chicago Dallas *+ Denver 12
in$l ,h$&ow %onstr$int Allow$le Allow$le V$l+e 8rice R.9. ,i&e 3ncre$se 7ecre$se )66&'0 56%5 )66&'0 )&&' &&'6( ')(&(0 '%6 ')(&(0 )&&' &056'%#(06 '&0&$( 0 '650## )>F0&0 &(6& )66&'0 0 )&&056 &&'6( )>F0&0 ')(&(0 0 )##%'5$( &056'%#(06 )>F0&0 '&0&$( 0 ')'06' )&&' )>F0&0 (0#'# '5%6( (0#'# &(6& )&&' 5560 '%& 5560 &(6& )&&' $'60 )()%) $'60 &(6& )&&' $'60 )%'( $'60 &(6& )&&' '&&' )$'%) '&&' &(6& )&&' '))() )(%6 '))() &(6& )&&'
"@")5 S, "@")6 Vancouver "@")# Calgar4
5'$60 &'5) )(5
')6%& '('%& '0(%'
5'$60 &'5) )(5
&(6& &(6& &(6&
)&&' )&&' )(5
Microsof Excel 14.0 i"its Report Worksheet: [NorthwestNewsprintV2.xlsx]AferptAlt1 Report %re$te&: 1'('201) 2:0?:11 AM
5ec!-e %ell N$"e "")$ Ma= Profts
%ell "E"' "E"& "E"( "E"5 "E"6 "E"# "E" "E"$ "E")0 "E")) "E")' "E")& "E")( "E")5 "E")6 "E")# "E") "E")$ "E"'0 "E"') "E"'' "E"'& "E"'(
V$ri$le N$"e a Decision Variables b Decision Variables c Decision Variables d Decision Variables e Decision Variables - Decision Variables g Decision Variables h Decision Variables i Decision Variables Decision Variables Decision Variables l Decision Variables 3 Decision Variables n Decision Variables o Decision Variables p Decision Variables Decision Variables r Decision Variables s Decision Variables t Decision Variables u Decision Variables v Decision Variables 7 Decision Variables
V$l+e " )'58(5)8(#(%'#
V$l+e 0 $'60 #&6(0 0 0 (0#'# 0 0 )$0(0 0 $&(6 5'$60 0 )(5 0 5560 0 0 '&&' ))& 0 &'5) 0
ower i"it 0 $'60 #&6(0 0 0 (0#'# 0 0 )$0(0 0 $&(6 5'$60 0 )(5 0 5560 0 0 '&&' ))& 0 &'5) 0
5ec!-e Res+lt )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%&
;pper i"it 0 $'60 #&6(0 0 0 (0#'# 0 0 )$0(0 0 $&(6 5'$60 0 )(5 0 5560 0 0 '&&' ))& 0 &'5) 0
5ec!-e Res+lt )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%& )'5(5)(#(%&
Revenue/Ton Prod Cost Ship Cost Decision Variables a 0 SM!Chicago " #50 " $%## " &$0 b $'60 SM!Dallas " #50 " )6'%'( " &$0 c #&6(0 SM!*+ " #50 " )66%) " &$0 d 0 SM!Denver " #50 " )5)%## " &$0 e 0 SM!S, " #50 " )5)%)) " &$0 (0#'# *M!Sea.le " #50 " (6%6 " ()5 g 0 *M!Chicago " #50 " )'%' " ()5 h 0 *M!Dallas " #50 " '0(%)& " ()5 i )$0(0 *M!*+ " #50 " )$5%0 " ()5 0 *M!Denver " #50 " )6'%& " ()5 $&(6 *M!12 " #50 " )(#%(6 " ()5 l 5'$60 *M!S, " #50 " ))5%($ " ()5 3 0 *M!Vancouver " #00 " #'%(' " ()5 n )(5 *M!Calgar4 " #00 " ##%50 " ()5 o 0 D!Sea.le " #50 " 5'%0 " ()5 p 5560 D!Chicago " #50 " $#%)# " ()5 0 D!Dallas " #50 " ')0%(' " ()5 r 0 D!*+ " #50 " '00%6' " ()5 s '&&' D!Denver " #50 " )('%' " ()5 t ))& D!12 " #50 " )50%)( " ()5 u 0 D!S, " #50 " )'(%& " ()5 v &'5) D!Vancouver " #00 " ('%)# " ()5 7 0 D!Calgar4 " #00 " #%$( " ()5
Proft Margin " '#0%'& " )$#%#6 " )$&%' " '0%'& " '0%$ " '%&' " '06%) " )&0%# " )&$%$' " )#'%)# " )#%5( " ')$%5) " ')'%5 " '0#%50 " ''%'0 " '%& " )'(%5 " )&(%& " )$'%) " )(%6 " ')0%)# " '('%& " )$#%06
SM *M D SM *M D Sea.le Chicago Dallas *+ Denver 12 S, Vancouver Calgar4
)668&'0 ')(8&(0 '&08&$(
Total Capacit4 9: Total Capacit4 9: Total Capacit4 9:
)668&'0 Total +pera;ng 1evel <: ')(8&(0 Total +pera;ng 1evel <: '&08&$( Total +pera;ng 1evel <: (08#'# Total De3and : 55860 Total De3and : $'860 Total De3and : $'860 Total De3and : '&8&' Total De3and : '))8() Total De3and : 5'8$60 Total De3and : &'85) Total De3and : 8)(5 Total De3and :
)668&'0 ')(8&(0 Reduc;on '6580## )&&8056 )&8### ')'806' (08#'# 55860 $'860 $'860 '&8&' '))8() 5'8$60 &'85) 8)(5
Ma= Profts " )'58(5)8(#(%'#
5000
Produc;on Ee-ore +p;3iGa;on Route +p;3iGa;on H Produc;on ,pr+ce )((()6 )66&'0 (@ N$o"ee '&6(#' '&'6#' 0.?1@ 7+chesne '&0)66 ')'06' 4.0=@ 8rot " )')856# " )'58500860( 2@
)00 Discount B*M/D!12 H Produc;on 2lt) 5 Press Reduc;on H Produc;on )668&'0 (@ )668&'0 (@ '&'86#' 0.?1@ ')(8&(0 4.=1@ ')'806' 4.0=@ '&08&$( 0.0B@ " )'$8$68&05 *@ " )'58(5)8(#( 2@