ࡱ> '` lbjbj{P{P At::y`0`0`0`0|0QS2|1^1111EFEFEFRRRRRRR$ThVREFQEEFEFEFR11w S[L[L[LEFL11R[LEFR[L[L:OO1p1 H$K`0IROP!S0QSZO,WUJWOO^WOEFEF[LEFEFEFEFEFRR?LEFEFEFQSEFEFEFEF\!\! OPIM 4050 Supply Chain Management Homework 3 Solutions 1. Answer Exercise 2 from Chapter 6 about Unipart, a manufacturer of auto parts. so Year 1s costs are incurred now and Year 2 costs are incurred in a year means  SHAPE \* MERGEFORMAT  Step 1. Draw the decision tree:  SHAPE \* MERGEFORMAT  Step 2. Calculate the NPV (there are multiple ways to do this, one method is shown below) For Parts4U ScenarioC0 + C1/(1+k) = NPVProbNPV*Prob150, 150150*0.05 + (150*0.05)/1.2 = 13.750.3755.15150, 135150*0.05 + (135*0.05)/1.2 = 13.1250.3754.92135, 135135*0.05 + (135*0.05)/1.2 = 12.3750.1251.55135, 121.5135*0.05 + (121.5*0.05)/1.2 = 11.81250.1251.48NPV for Parts4U13.10 million For AllMRO ScenarioC0 + C1/(1+k) = NPVProbNPV*Prob150, 15010 + 150*0.01 + (150*0.01)/1.2 = 12.750.3754.78150, 13510 + 150*0.01 + (135*0.01)/1.2 = 12.6250.3754.73135, 13510 + 135*0.01 + (135*0.01)/1.2 = 12.4750.1251.56135, 121.510 + 135*0.01 + (121.5*0.01)/1.2 = 12.36250.1251.55NPV for AllMRO12.62 million The NPV of the commission is lower for AllMRO. Hence, choose AllMRO. 2. Use the following demand data for parts (a) and (b)  SHAPE \* MERGEFORMAT  a) What is the demand forecast for periods 7 and 8 when using the 3-period moving average forecasting method? The forecast for period 7 depends on the level for period 6 F7 = L6 The level for period 6 is the average demand of periods 6, 5, and 4 L6 = (D6 + D5 + D4) / 3 = (987 + 1128 + 911) / 3 = 1008.67 Hence, F7 = 1008.67 The forecast for period 8 depends on the level for period 7 (we cannot calculate the level for period 7, so we can use the level for period 6) F8 = L6 Hence, F8 = 1008.67 b) What is the demand forecast for periods 1 and 2 when using the simple exponential smoothing forecasting method with smoothing parameter ( = 0.2? The forecast for period 1 depends on the level for period 0 F1 = L0 The level for period 0 is the average demand over all periods L0 = (D6 + D5 + D4 + D3 + D2 + D1) / 6 = (987 + 1128 + 911 + 897 + 979 + 1019) / 6 = 986.83 Hence, F1 = 986.83 The forecast for period 2 depends on the level for period 1 F2 = L1 The level for period 1 can be calculated as follows L1 = (D1 + (1 ()L0 = 0.2*1019 + 0.8*986.83 = 993.26 Hence, F2 = 993.26 Use the following demand, level, and trend data for parts (c)  SHAPE \* MERGEFORMAT  c) What is the demand forecast for periods 1 and 2 when using Holts method with smoothing parameters ( = 0.1 and ( = 0.1? The forecast for period 1 depends on the level and trend for period 0 F1 = L0 + T0 The level and trend for period 0 are given L0 + T0 = 105 + 11 = 116 Hence, F1 = 116 The forecast for period 2 depends on the level and trend for period 1 F2 = L1 + T1 The level for period 1 can be calculated as follows L1 = (D1 + (1 ()(L0 + T0) = 0.1*123 + 0.9*(105 + 11) = 116.7 The trend for period 1 can be calculated as follows T1 = ((L1 L0) + (1 ()T0 = 0.1*(116.7 105) + 0.9*11 = 11.07 Thus the sum of level and trend for period 1 is L1 + T1 = 116.7 + 11.07 = 127.77 Hence, F2 = 127.77 Use the following demand and forecast data for parts (d) and (e)  SHAPE \* MERGEFORMAT  d) For periods 1, 2, and 3, calculate the: Forecast Errors (Et) Absolute Deviation (At) Mean Absolute Percentage Error (MAPEt) Mean Squared Error (MSEt) E1 = F1 D1 = 203 213 = 10 E2 = F2 D2 = 254 246 = 8 E3 = F3 D3 = 290 276 = 14 A1 = |E1| = 10 A2 = |E2| = 8 A3 = |E3| = 14 Let us first calculate the Absolute Percentage Error (APE) before calculating the Mean Absolute Percentage Error (basically, the average of Absolute Percentage Error) APE1 = (A1/D1)*100 = (10/213)*100 = 4.69 APE2 = (A2/D2)*100 = (8/246)*100 = 3.25 APE3 = (A3/D3)*100 = (14/276)*100 = 5.07 MAPE1 = (APE1) / 1 = (4.69) / 1 = 4.69 MAPE2 = (APE1 + APE2) / 2 = (4.69 + 3.25) / 2 = 3.97 MAPE3 = (APE1 + APE2 + APE3) / 3 = (4.69 + 3.25 + 5.07) / 3 = 4.34 MSE1 = (E12) / 1 = (100) / 1 = 100 MSE2 = (E12 + E22) / 1 = (100 + 64) / 2 = 82 MSE3 = (E12 + E22 + E32) / 1 = (100 + 64 + 196) / 3 = 120 e) For period 3, calculate the mean absolute deviation (MADt) and provide an estimate for the standard deviation of the forecast error for period 3. MAD3 = (A1 + A2 + A3) / 3 = (10 + 8 + 14) / 3 = 10.67 To estimate the standard deviation of the forecast error for period 3 we take 1.25*MAD3 Hence, STDEV(Forecast Error) =1.25*10.67 = 13.34 3. Use the data in Exercise 1 from Chapter 7 about ABC Corporation (see also online template). a) Use the static forecasting method to forecast monthly demand for ABC Corporation for year 6. See online Excel sheet b) Evaluate the Forecast Errors (Et), Absolute Deviation (At), Bias (biast), Mean Absolute Deviation (MADt), Tracking Signal (TSt), Mean Absolute Percentage Error (MAPEt), and the Mean Squared Error (MSEt). See online Excel sheet c) Looking at the tracking signal only (see TrackingSignal tab), is the forecast considered to be good or bad? The forecast is mostly good, but it could be better as there are three tracking signal points that fall below -6. t = 1 t = 0 No Cashflow 150 135 135 121.5 150 135 No Cashflow t = 0 t = 1 0.75 0.25 0.5 0.5 0.5 0.5 !-.89:=MO^k  ! " 9 : ; ̻ѱю~ttc!jhBg5UmHnHtHujhBg5U hBghBghBg hr5 h! 5jh#h#5U!jh#5UmHnHtHujh#5U!jh5UmHnHtHu h5 s5 h#5h5 sh5 s5 h5 hBg5 h@5 h4ZG5h'kgh5 h ]5"9:  ! > $Ifgdgdk; < = > F     3 4 9 : > I k l q r v  4 ùùñͬͨըըըըըըըըըըըըձùùñhlD hlD 5>*h hlD 5hlD hlD 5hlD hlD 5H*hlD hlD 56hlD h5hlD hBg hBghBg hBg5jhBg5UjhBghBg5U<   [RRRR $Ifgdkd $$Ifl\ $X8 t0644 laytlD    4 : ? [RIRR $Ifgd $Ifgdkd$$Ifl\ $X8 t0644 laytlD ? @ I l r w [RRRR $IfgdkdB$$Ifl\ $X8 t0644 laytlD w x [RRRR $Ifgdkd$$Ifl\ $X8 t0644 laytlD  [OF $Ifgd $$Ifa$gdlD kdd$$Ifl\ $X8 t0644 laytlD   |wnnnn $Ifgd gdlD gd}kd$$Ifl0 $ t0644 laytlD   < B G [RRRR $Ifgd kdZ$$Ifl\ $X8 t0644 layt 4 8 B F r v       ! # g h j k . / 0 l m n 뼸zh}h}6 h}h}hd8hG# h^Lh,jh,Ujh,UmHnHtHujh,Uh, h,5 hBg5h}hBg5>*h}h}5>*hlD hlD 5>* h}5>* h}5hlD hlD 5hlD h}0G H Q y  [RRRR $Ifgd kd$$Ifl\ $X8 t0644 layt  [RRRR $Ifgd kd|$$Ifl\ $X8 t0644 layt   [RRRR $Ifgd kd $$Ifl\ $X8 t0644 layt    ! [OF $Ifgd $$Ifa$gd kd$$Ifl\ $X8 t0644 layt ! " # h i j 0 1 m u |wwwwwwwwwrwgd}gdgdlD }kd/$$Ifl0 $ t0644 layt n o r s t u  @AJKX۳󯨯󕐝 h\D!H*h}h\D!6h\D! jahLy h^LhLyhLyh}5>*H* h}h}h,h}h}5>*h}h}5>*H*h}h}56>* h}H*h}h}6h}h}h}H*6u  JK)<=y@A^_gd\D!gdLygdgd}0125;yz{~9:>?@ABYZĽĽ󱩤jh{W5U h{W5 h ]5h{Wh{W5 h\D!5 jah\D! h\D!5>*h}h\D!5>*h\D!5>*H*h}h\D!56>* h\D!H* h\D!6h}h\D!6h\D!h}h\D!H*8Z[\]_j!"#&'(+,-.YZ[^_`qryz{~Ǽǵǰ}ukd h\D!5>*h}h\D!5>*h\D!5>*H*h}h\D!56>* h\D!h\D!h\D!h\D!H*h\D!h\D!6 h\D!H*h}h\D!6h\D! h\D!5 jbh{W jah{WhdFdh{W h{Wh{W h{W5jh{W5Uj$h{Wh{W5U!jh{W5UmHnHtHu'_!.Yr I}"de & Fgdgd\D!gd   "#$&*+,/456@CH}~ǿԺǿ jbhAp hAp6hAphApH*hAphAp6 h\D!6hAp jah\D! h\D!h\D!h\D!h\D!6h\D! h\D!H*h}h\D!6F!"#VWYZ\bcdef}~ʷ|tjhG#hG#6H*hG#hG#6htEhG#h]h# hd8hd8jh ]Ujh ]UmHnHtHuh ]jh ]Uhd8 hC5 h5 hG#5 hd85 h{W5 hAp5>*h}h\D!5>*hAp5>*H*h}h\D!56>*hAph\D!)"#$'()8;=>?BCDGHIXY[\]`abefgvx{|}ǿǿǿǬǬǬǬǬǬhAph H* h 6 hAp5>* hApH*hAphAp5>*hAphAphApH*hAphAp6h]h]6H*h]h]6h]hG#hG#6H* hG#6hG#hrhtE:=[z{Ox&ijLMgd gdApgd}NORSWXYZ[\x{|ǿh mHsHh h mHsHh H*mHsHh h 6mHsHh h H*h h 6h Ah A6h A h Ah A h 5>* h H* hAp5>*h h 5>*hAph H* h 6h 5  !%&*+ÿÿuih h H*mHsHh h 5>*mH sH h mH sH h h mH sH h h H*mH sH h h 6mH sH  h 5>*h h 5>*h h h H*h h 6 h 6h mHsHh H*mHsHh h 6mHsHh h mHsH)+/2369:=@Adhjmnqrstuݻϰݻ駻ǰݻ駻駻ǰhG#h#h hApmHsHh H*mHsHh 5>*mHsHh h H*mHsHh mHsHh h 5>*mHsHh h H*mHsHh h 6mHsHh h mHsH:-01{ FKLNOQĺijЫ}xsnjh" h"5 h{W5 hr5h+h5 h,5 h&5 h&h! h&h&5>*h& h&h&h&h H* h h h h 5>*h h h H*h h 6 h! 5 hd85hXhG#hG#6H*hG#hG#6hG#h])M'( #$gdBg$a$gdgdrgd&gd"gd &'()+4GIJKNW`bcdgmqr¸ʴ|w|ohLyh_6 hLy6h_hLyhtE6H* htE6huhtE6H*huhtE6htEhLyh76H* h76h7hLyhLy6H*hLyhLy6hLyh"h,h&h&h@5>*h&h&5>* h"h@hr h"h"'5NVW`q<=CDJOPUVZ[_`deijklûûôôôôôôðhA hBgh hBgh 6h hrh 6h&h@5>* h&5>*h7h&h&5>*h"h_hLyh_6H**$()-.;<BCIJOPUVZ[_`deijklgd$a$gdBggdBg21h:pO/ =!"#$% @=-Ÿ0S˒p"ixݚk\EϽIظl֚am7*hV Z"izb7H7M>T0EQl Ry={8{s/Ap993&FrTHO=; `$@B"h~2,D{w|\_Q WQdߗ<}N]Nw=GPc{tۢaZ{c[6!Fߪ碒CmP:}Bn慬:,QR޸sZdejݟrؒfuIqujΡėfg'|-rƪXWp xᵦ.%ʟL@淄ǽ#퉰n߷uJO 8}Ru*d^[32$66QpUQ7x{qVI鋳E,^8ΫQD#Ϗ[)U! =r{֧Fg<+'I#rHy?spwBjDE;«v} EٛDoiM^>sNl){R0{=fؓY'DgVhFD4gej~V]뵳2]uqVd^֩r_o)S9Cso>X!tDvUz!gg;Ng@ɼ>LjMY?yPq=Umɘ./;ѩ:61y;.bKE2q4:U[Gs똧yF<9aB TGݚ44Eda.Z籺y!~у2_B@^ Kȿ_ ?Y%_֬R5OF^wXC4n X0kkkM`Ă6d!o>"d'5ء*/U1&_7zc̰6Vkт' |~;⥚?-1զ[iigOIVx([}]Z6ŖelY,dY[|rȒceSlyƖa#KM[,V6Vbl%X[}RfelYq{cqRnŦ:o|C{Za{Z G&eKRv8d[ǗCĽ+d&xqP60layv7Osyr7bcl}! %[2[0[C e[6[0[B [>[0[B [)[0[C U[%[lѐiCcVoUO 0{Yl4)F//t󏰿O7QȞRoݚ4qM~7`q@=iZdid j9`'Y%7xݚOh\EKc6(*ͦi/\ӃDQJm+& l LC7dCă {Ћhk ^Jh3o9=C)_wfI (u<␬<`h,ElQwg1 B<-GP%w|TH(Z\]l{TK6nG`iO!WW-9vM庈 Pwa~cc:1&d;CBv i=kűPԶN_;LbPu!WžwYEtVa!cĖ/ye!X%{o(R&T »p^+R 7cpzRȸ"K 3z#.B{E^ːyLoޮe~^nŠ/H=rڇkgų3N7¼ƹ{Ϩ^D\z/zv_El{ e[V$SuMnUGn'>3"ׇclmPkDiӫ^2«ZphFQP{{C>Ϝ"[ʞP{aaoJ$߄bkZikD;fKYKG_FSՅjL -LFzfwѻSѫfϚ*߳6'úԆo^)Y3ʞ%ڳTY_cҞ5)>~ppl(./g?rXҞMh#^fu4$v:zD=Oڬ?%SgqMdJoIA#.bq]B>RsHڽ !Vy1yxHPvv5TajPS||;6KqE߇*㷘ѲU1S~iicM88+[u'ʖdlI$M[ʃ-,)V6Ŗfli4Y[e<2ȒaeSlYƖ`"KM[΃-,9V6Ŗglyda@=[yukDy psxY][E>7?MMӮ.*6 jIB 7I-Z6rDPK_|jgn|U">,> EUgn {i'sf̙oΜ3^ ΁_\kp/1sOCRP~MT#PC E>˸q*@$d =Ky;;H>{D/1OWk9ݱ ]~7v!~'.cHFl[ח"e|m~,kHwQE$u<שh.&~vi%|?ٙ{sLn={)w- ʷ.`^h% ?:5 O.fAaߤtjDg'/­:I?1,}9QnSAa8\8[Fg<2}nOߐ8|鍚U},5 )oD}5: H[)iٕwas{.&SChIw@g[۳4/m*/AU;${ f=96y:kk$z2toV֖cVNth^CSnZGi!Αm,xdx}37IR2嘐qىGџ$=26}~/x+_(?7.̯q_O+W晌(sF' y!&+27<JQX^dinsx{ lb9:!>4:?@Ilrwx  <BGHQy!"#hij01mu JK)<=y @ A ^ _ ! . Y r I }  " d e    = [ z { Ox&ijLM'( #$()-.;<BCIJOPUVZ[_`deijm0000000000000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 @0 0 0 0 @0 0 0 0 0 0 0 0 0 00@0 @0 @0 0 @0 @0 0 0 0 0 @0 0 0 0 @0 @0 0 @0 0 @0 @0 0 0 0 @0 0 0 0 @0000000000000000000000000000000000000000000000000000000000000 0 0 0 0000000000000000000000000000000000000000000000000000000000000000000000000000004:?@Ilrwx  BGHQy!"#01mu JK)<=y@ ! . Y r I } "    = [ z { Ox&ijM'(m00J0000 00 00 00 00h00 00 00 0 0 00 h00 0 0 0 0 0 0 0 0 RGh00 00MN00 00J0000 00 00 00 00h00 00 00 0 0 00 h00 0 0 0 0 0 0 0 0 Gh00 0&0 00 00h00j00j00j00\*0-00-00.00000.002000300.00.0@0@0090090 0000<0 020@00?0 090 0000<0 0<0 @0@00F0GijN090 0000<0 0<0 @00L0M`N090 0000<0 0<0 0<0 0<0 @000U0 VDJ0U0 0U0 0000000000000^0 00000a00a0 0a0 0000000g0 0000000k0 000000 t{D000000r0s,?_"$-Ÿ0S˒4b"$Zdid j9q#h"$[yukDn"$R71))?6>"$X8@ z`(  t  S @@A S"`?t  S @@A S"`?t  S @@A S"`?z f0* #  s"*?`  c $X99?f0*42    42  \ 42  \ 42  f42  t(42  642  DH  #  G\ UH  #  U\ cH  # cH  # cH  # GH   # G  i0*" '#  s"*?` & c $X99?i0*"42 ( T N2 )  \  N2 *   \ q  N2 +  ci N2 ,  c N2 -  a N2 .  d H 0 #  \ H 1 #  \ H 2 # dH 3 # aH 4 # cH 5 # wch 6 3  "`@ ]!  h 7 3  "` H"  h 8 3  "`P"  h 9 3  "`p   h : 3 "`p h ; 3 "`, h < 3 "`,* h = 3 "`,' h > 3 "`,  \2 # 3 "` \2 $ 3 "` \2 % 3 "` B S  ?  ()0 (*1 *.2*-3),4)+5:Z ~ l%w$t$TTP pt# T pt$8t'$\ t t tO t  JP`f   HNx|&+/36:=AEFJUX\`adhjqruyz~-1mr;I 2:m>E  x&hj"(IKm333333333 !>@#Rj/ Y I } # jM( "$'),.:<ACHJNPTVY[^`cehmHNm{`Yh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hH{`Y         K6D@)KF&Rm.)D@x8lKFx8l>=@XlD AGr&O\D!iF#G#S(,"h7%=4'@4ZG^Lw?PKYT^qX!\ ]+_4[bebdFdAp5 sawLy} d8! 7uBg}CO5X ^F+]{_ )"w{W AE8tE_#fBaB4:?@Ilrwx  <BGHQy!"m@MM{MM $lP@UnknownG: Times New Roman5Symbol3& : Arial?5 z Courier New;Wingdings"qhC⦕N $ $!24d2QHX)?2!SYST 4050 Supply Chain ManagementMenkes van den BrielMenkes van den Briel Oh+'0 <H h t $SYST 4050 Supply Chain ManagementMenkes van den Briel Normal.dotMenkes van den Briel5Microsoft Office Word@T @C9@@K՜.+,0 hp|   $ ' "SYST 4050 Supply Chain Management Title  !"#$%&'()*+,-./0123456789:<=>?@ABDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnpqrstuvxyz{|}~Root Entry FK$KData ;1TableCWWordDocumentAtSummaryInformation(oDocumentSummaryInformation8wCompObjq  FMicrosoft Office Word Document MSWordDocWord.Document.89q