资源描述：
《Chapter 12 Exercise answers》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、Chapter12:ManagingUncertaintyinaSupplyChain:SafetyInventoryExerciseSolutions1.DL=LD=(2)(300)=600===283ss=FS-1(CSL)´sL=FS-1(0.95)´283=465(where,FS-1(0.95)=NORMSINV(0.95))ROP=DL+ss=600+465=1065ExcelWorksheet12-1illustratesthesecomputations2.DL=(T+L)D=(2+3)(300)=1500===447ss=FS-1(CSL)´
2、sL=FS-1(0.95)´447=736(where,FS-1(0.95)=NORMSINV(0.95))OUL=D(T+L)+ss=1500+736=2236ExcelWorksheet12-2illustratesthesecomputations3.DL=LD=(2)(300)=600===283ESC=(1–fr)Q=(1–0.99)500=5Weusethefollowingexpressiontodeterminethesafetystock(ss):ESC=–ss[1–NORMDIST(ss/sL,0,1,1)]+sLNORMDIST(ss/s
3、L,0,1,0).WeutilizetheGOALSEEKfunctioninEXCELindeterminingsafetystock(ss)byusingssasthechangingvaluethatresultsinanESCvalueof5.ExcelWorksheet12-3illustratesthesecomputations.14GoalSeekset-up:SETCELL:C29TOVALUE:5BYCHANGINGCELL:C27Thisresultsinassvalueof477andthereorderpointof:ROP=DL+s
4、s=600+477=1,0774.DL=LD=(2)(250)=500===212ss=ROP–ss=600–500=100CSL=F(DL+ss,DL,sL)=F(600,500,212)=NORMDIST(600,500,212,1)=0.68ESC=–ss[1–NORMDIST(ss/sL,0,1,1)]+sLNORMDIST(ss/sL,0,1,0)=43.86Fillrate(fr)=1-(ESC/Q)=1-(43.86/1000)=0.96ExcelWorksheet12-4illustratesthesecomputations5.DL=LD=(
5、2)(250)=500sL===431ss=FS-1(CSL)´sL=FS-1(0.95)´431=709(where,FS-1(0.95)=NORMSINV(0.95))ESC=–ss[1–NORMDIST(ss/sL,0,1,1)]+sLNORMDIST(ss/sL,0,1,0)=9Fillrate(fr)=1-(ESC/Q)=1-(9/1000)=0.99114StandarddeviationofleadtimeRequiredsafetyinventory 1.507091.005390.504050.00349ExcelWorksheet12-5
6、illustratesthesecomputations6.FollowingaretheevaluationsfortheKhakipants:DisaggregatedOption:DL=LD=(4)(800)=3200===200Coefficientofvariation==100/800=0.13ssperstore=FS-1(CSL)´sL=FS-1(0.95)´200=329(where,FS-1(0.95)=NORMSINV(0.95))Totalsafetyinventory=(329)(900)=296,074Totalvalueofsaf
7、etyinventory=(296,074)(30)=$8,882,210Totalannualsafetyinventoryholdingcost=(8,882,210)(0.25)=$2,220,552Holdingcostperunitsold=2220552/(800)(900)=$3.08AggregatedOption:=(900)(800)=720000==3000DL=LDC=(4)(800)(900)=2,880,000===6000ss=FS-1(CSL)´sL=FS-1(0.95)´6000=9869(where,FS-1(0.95)=N
8、ORMSINV(0.95))Total
