库存仿真模型.xls

《库存仿真模型.xls》由会员分享，可在线阅读，更多相关《库存仿真模型.xls（14页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、LandsEnd 公司的Excel仿真模型羊绒衫成本$50.00冬季的售价$150.00冬季的需求量均值3000冬季的需求量标准差1000打折品需求量的均值250打折品需求量的标准差83订购量3000订购成本$150,000.00冬季需求量4604冬季的销售收入$450,000.00将要打折的羊绒衫数量0打折品的销售收入$0.00打折后的价格$150.00捐赠的净利润$0.00折扣价下的需求量264纯利润$300,000.00打折商品销量0捐赠数量0平均利润$264,982.65打折销售的羊绒衫平均数384利润的标准差捐赠的羊绒衫平均数188纯利润打折销售数量捐赠数量300000.000026

2、3694.40556204292277.553930223226.00720541299193.551270278030.8059642124867.6014761178300000.0000207406.50930591295910.202860296748.752550300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000299911.80420299338.751150283432.25295106116595.2516011106300000.0000120350.

3、7515931048300000.0000223615.10894427299405.951090300000.0000299999.9510227951.35899372295736.802920191423.301167565218232.601182168300000.0000299963.55270300000.0000300000.0000300000.0000282119.805980300000.0000300000.0000300000.0000155849.301471637298829.551530278875.6055357300000.0000252815.806982

4、40300000.0000295881.552870299988.75150299740.80720300000.0000204112.701047529120852.0015481128300000.0000129379.3015111037298415.801780300000.0000267647.50525179300000.0000300000.0000300000.0000299671.95810300000.0000300000.0000300000.0000126162.0015611001268396.80484188285510.4044941113436.25165510

5、50300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000170101.851269742300000.0000300000.0000300000.000028929.2522171322299879.9549093052.60184497769070.6019641197300000.0000126604.0014401202300000.0000300000.0

6、000300000.0000171199.001230776300000.0000300000.0000300000.0000300000.0000207097.60912608294847.953210299047.801380300000.0000270411.2570550194178.101137563300000.0000142139.051521782300000.0000171947.851321638230304.40962286300000.0000160595.501310831268975.30641107296435.552670300000.0000297623.80

7、2180300000.0000300000.0000289098.103115364594.4520031166300000.0000190434.851151598300000.0000253831.40514316300000.0000299998.7550300000.0000300000.0000232864.00980236300000.0000299167.951290300000.0000267668.85571158253761.70603281159775.001428653300000.0000258315.55469288300000.0000300000.0000282

8、911.2035995283786.0047646300000.0000300000.0000137528.401356113433940.2521851318168263.851177878261248.80739123290277.1026653300000.0000238735.00658408300000.0000300000.0000(69875.00)28901725300000.0000245949.60796248300000.0000299718.75750180382.401288559293663.203560300000.0000300000.0000300000.00

9、00300000.0000300000.0000294185.953410300000.0000300000.0000300000.0000245724.55783260299879.95490300000.0000284192.5043459286635.555170300000.0000300000.0000300000.0000284770.0037474300000.0000300000.0000280684.9051359274146.20478136300000.0000253980.15609276266444.80368240300000.0000300000.00003000

10、00.0000300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000298059.551970300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000245823.60652338300000.0000300000.0000300000.0000300000.0000236288.40876294262099.30434263238765.30827305261574.0073

11、0126300000.0000300000.0000300000.0000299115.551330300000.0000280280.806280295500.003000300000.0000300000.0000298735.951590300000.0000300000.0000299243.551230246595.50709299300000.0000167327.40133868425885.6022581122300000.0000300000.0000300000.0000149637.451459770300000.0000300000.000084578.40177414

12、06300000.0000300000.0000300000.000084068.2018221284300000.0000300000.0000246605.10702303300000.0000298919.551470300000.0000300000.0000300000.0000300000.0000300000.0000298948.751450300000.0000296774.202540297513.552230300000.0000294422.203340293191.953690300000.0000300000.0000300000.0000199208.951043

13、596229765.75711476299889.55470261846.40563219300000.0000299843.20560300000.0000264731.00483223300000.0000270140.3070255300000.0000267249.7047820129151.7021381831203148.501029559259667.60657193300000.0000163168.001203923300000.0000268015.80372225282795.7539984300000.000073510.0018921342300000.0000276

14、288.0052098300000.0000300000.0000300000.0000112679.5016311121295409.553030189934.001088673188480.10112665392128.4017921171209416.40976529300000.0000234031.20864330290054.204460298059.551970292741.953810300000.0000300000.0000299231.201240250576.00596316300000.0000221265.40957401300000.000051683.20208

15、11225300000.0000215859.00876531300000.0000300000.0000300000.0000300000.0000113613.401748789300000.0000276097.85477118300000.0000300000.0000299995.9590300000.0000300000.0000160043.651403694300000.0000300000.0000164990.501415589300000.000034866.2521411566298919.551470231566.75841376300000.0000299997.5

16、570300000.0000300000.0000300000.0000288671.204760360.0023761551300000.0000300000.000058546.7520551112266031.25485210299361.551130300000.0000236860.00800346300000.0000291635.954090300000.0000265291.60496213300000.000029028.5022151333262572.05691142300000.0000244422.70842229300000.0000297731.552130249

17、620.00775223300000.0000300000.0000300000.0000300000.0000299848.75550283232.7041475230937.40833389250314.85473362300000.0000299977.95210300000.0000300000.0000299963.55270264856.60589177197209.551023640285987.5541948161042.651331794290484.8037622300000.0000300000.0000274919.35527108(5204.80)2394181016

18、7240.001480415300000.0000232212.40908314223507.00770512300000.0000296924.802480300000.0000217963.40906484264901.90563189300000.0000300000.0000299837.55570300000.0000200795.201151455295795.002900267233.00484199300000.0000300000.0000300000.0000300000.0000300000.0000272174.80578110133300.65156984630000

19、0.0000300000.0000300000.0000300000.0000155278.8012361002300000.0000196083.50955709300000.0000300000.0000300000.0000300000.0000300000.0000218540.00984409(13940.00)24501842300000.0000299427.55107038712.0021541314207542.85913602189344.651157606196392.501063613300000.0000300000.0000231049.60872358300000

20、.0000274305.1067133300000.0000300000.0000300000.0000284669.2044650300000.0000298751.801580299416.801080300000.000072797.5018101605300000.0000245465.80596367300000.0000299991.55130300000.0000299995.00100212581.401108349207865.90951569298814.201540300000.0000300000.0000295589.552970300000.0000300000.0

21、000204708.201116445273850.00350178300000.0000300000.0000300000.0000300000.0000300000.0000300000.0000299879.95490280957.3548768300000.0000298889.951490173580.251263698267826.40576154(18495.20)24741978300000.0000300000.0000300000.0000300000.0000300000.0000229554.00976281143982.151477836281261.00420911

22、08823.951807704300000.0000300000.0000299509.95990249991.15779216119321.601668892145240.751445872300000.0000299907.55430300000.0000192269.201212494268838.4057614484100.0017861386300000.0000300000.0000214324.201021425300000.0000300000.0000300000.0000298977.551430206016.85887638300000.0000273178.004301

23、62299960.80280300000.0000243965.80853225262502.10529227利率6%本金利息￥1,080￥1,500￥1,320￥900￥18,000￥1,08010%￥1,800￥2,500￥2,200￥1,500￥25,000￥1,5007%￥1,260￥1,750￥1,540￥1,050￥22,000￥1,3208%￥1,440￥2,000￥1,760￥1,200￥15,000￥90012%￥2,160￥3,000￥2,640￥1,800利率6%本金利息￥18,000￥1,080#￥25,000￥22,000￥15,00010%￥2,500￥2,200￥1,5007%￥1,750￥1,540￥1,0508%￥2,000￥1,760￥1,20012%￥3,000￥2,640￥1,800