资源描述：
《chapter11exerciseanswers：第0110exercise 0answers》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。
1、Chapter11:ManagingEconomiesofScaleUncertaintyinatheSupplyChain: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=1065ExcelWorksheet11-1illustratesthesecomputations2.DL=(T+L)D=(2
2、+3)(300)=1500===447ss=FS-1(CSL)´sL=FS-1(0.95)´447=736(where,FS-1(0.95)=NORMSINV(0.95))OUL=D(T+L)+ss=1500+736=2236ExcelWorksheet11-2illustratesthesecomputations3.DL=LD=(2)(300)=600===283ESC=(1–fr)Q=(1–0.99)500=5Weusethefollowingexpressiontodeterminethesafetystock(ss):ESC
3、=–ss[1–NORMDIST(ss/sL,0,1,1)]+sLNORMDIST(ss/sL,0,1,0).WeutilizetheGOALSEEKfunctioninEXCELindeterminingsafetystock(ss)byusingssasthechangingvaluethatresultsinanESCvalueof5.15ExcelWorksheet11-3illustratesthesecomputations.GoalSeekset-up:SETCELL:C29TOVALUE:5BYCHANGINGCELL:
4、C27Thisresultsinanssvalueof477andthereorderpointof:ROP=DL+ss=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-
5、(43.86/1000)=0.96ExcelWorksheet11-4illustratesthesecomputations5.DL=LD=(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.99115Standarddevia
6、tionofleadtimeRequiredsafetyinventory 1.507091.005390.504050.00349ExcelWorksheet11-5illustratesthesecomputations6.FollowingaretheevaluationsfortheKhakipants:DisaggregatedOption:DL=LD=(4)(800)=3200===200Coefficientofvariation==100/800=0.13ssperstore=FS-1(CSL)´sL=FS-1(0.
7、95)´200=329(where,FS-1(0.95)=NORMSINV(0.95))Totalsafetyinventory=(329)(900)=296,074Totalvalueofsafetyinventory=(296,074)(30)=$8,882,210Totalannualsafetyinventoryholdingcost=(8,882,210)(0.25)=$2,220,552Holdingcostperunitsold=2220552/(800)(900)=$3.08AggregatedOption:=(900
8、)(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)=
