EXCEL财务模型库-存货组合模拟.xls
《EXCEL财务模型库-存货组合模拟.xls》由会员分享,可在线阅读,更多相关《EXCEL财务模型库-存货组合模拟.xls(18页珍藏版)》请在启牛文库网上搜索。
1、基基本本信信息息每每日日需需求求量量提提前前期期单位存储成本0.02概率累计概率随机数可能值概率累计概率每次订货成本250.030.0301400.110.11单位缺货成本0.10.090.1231450.650.76期初库存6000.160.28121480.160.92订货点2000.240.52281500.081订货批量5000.290.81521550.110.92811600.050.97921650.03197170模拟过程时间随机数需求量库存量订货批量随机数提前期到货量控制值订货次数060019416543500000026115528000000039316511550031
2、2051467155000000052014835200050000库存量模拟1112131415161718191101 111 121 131 141 151 161 171 181 191 201 211 221 231 241 251 261 271 281 291 301 311 321 331 341 351 3610100200300400500600700时间缺货量模拟1112131415161718191101 111 121 131 141 151 161 171 181 191 201 211 221 231 241 251 261 271 281 291 301 311
3、 321 331 341 351 361020406080100120140160180时间62915020200000078216042500202091813148000000095215534500050000101014520050038201211171155450000001268155390000500001363155235000000143215085500222016115841600000000161314835200050000178416019250025201911838150420000001986160382000500002027148234000000215
4、615579500692023122631550000000237815534500050000241514819750096402812560155420000002697170000000027741550000000284415035000050000294615020050026203113052155450000003141150395000500003278155240000000335515585500512035134441500000000352014835200050000361114520700000037201485950098404113891160000000039
5、201480000000405615500000004171155345000500004256155190500712044143271484200000044501503920005000045721552370000004613148895009840501474315000000004824148000000049361500000000501140360000500005122148212000000524915062500192054153421500000000549216034000050000556015518550059205715665155300000005719148
6、382000500005876155227000000591414879500682061160151480000000617145355000500006247150205000000639216540500272065164621550000000654515035000050000666415519550080306916727148470000006874155000000069541553450005000070481501955008430731714715045000000724145000000073914535500050000741014521000000075551555
7、550086307817690160000000077251480000000789145355000500007961155200500232081180841604000000081691553850005000082871602250000008361155705002520851843145000000085571553450005000086621551905006520881873115040000000881614839200050000892214824400000090241489650020209219185160000000092881603400005000093431
8、501905001620951947115535000000958216037500050000967715522000000097414575500642099198371500000000998145355000500001006015520050024201021101901604000000010251150390000500001031414824200000010487160825003420106110529150000000010670155345000500001076015519050098401111108501504000000010931400000000110961
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- EXCEL 财务 模型库 存货 组合 模拟