EXCEL财务模型库-非累进折扣的经济订货量.xls

文档编号:121215 上传时间:2022-06-15 格式:XLS 页数:11 大小:68KB
下载 相关 举报
EXCEL财务模型库-非累进折扣的经济订货量.xls_第1页
第1页 / 共11页
EXCEL财务模型库-非累进折扣的经济订货量.xls_第2页
第2页 / 共11页
EXCEL财务模型库-非累进折扣的经济订货量.xls_第3页
第3页 / 共11页
点击查看更多>>
资源描述

1、决决策策内内部部依依据据年需要量5400每次订货费用580单位存储成本6决决策策外外部部依依据据折扣点批量价格11010209.8决决策策过过程程经济批量是否有效1,021.76无效1,021.76有效订货批量订货成本购置成本存储成本总成本204.8152935400061469907408.6766554000122662891612.4511454000183760952816.23837540002449602861019.99307154000306060131订货批量为1021.76时,可取得最小存货总成本59050.5810203071529203060590511223.8255

2、9529203671591511427.62194529204283593971631.41920529204894597341835.217075292055066013220391536529206117605732500200015001000500052000 54000 56000 58000 60000 62000 64000 66000 68000 70000 72000 订货批量存货总成本1021.76间距203.8按经济批量计算费用按折扣起点计算费用两个费用取小小费用对应数量无效3,186,003.003,186,003.001.0059050.5790959,050.595

3、9,050.581,021.76订货批量为1021.76时,可取得最小存货总成本59050.58决决策策内内部部依依据据年需要量6127每次订货费用786单位存储成本7决决策策外外部部依依据据折扣点批量价格11010009.820009.6决决策策过过程程经济批量是否有效1173.008586无效1173.008586有效1173.008586无效订货批量订货成本购置成本存储成本总成本200.8239836127070385956400.61202261270140274694600.4802161270210171392订货批量为2000时,可取得最小存货总成本68227.11800.260

4、1861270280170089999.99481661270350069586100048166004535006836012004013600454200682581400344060045490068384160030106004556006865418002675600456300690201999.9924086004570006945220002408588197000682272200218958819770068708240020075881984006922626001852588199100697712800172058819980070339300025002000150

5、01000500064000 66000 68000 70000 72000 74000 76000 订货批量存货总成本2000间距199.8间距200按经济批量计算费用按折扣起点计算费用两个费用取小小费用对应数量无效4877095.54877095.5168255.660168360.42268255.66011173.008586无效68227.11168227.1112000订货批量为2000时,可取得最小存货总成本68227.11决决策策内内部部依依据据年需要量5627每次订货费用886单位存储成本6决决策策外外部部依依据据折扣点批量价格11010009.820009.630009.4

6、决决策策过过程程经济批量是否有效订货批量订货成本购置成本存储成本总成本1289.123992无效200.82482856270602817011289.123992有效400.612445562701202699171289.123992无效600.48304562701801663751289.123992无效800.2623056270240164901999.9949865627030006425610004986551453000631301200415555145360062899订货批量为2000时,可取得最小存货总成本62511.9614003561551454200629061

7、60031165514548006306118002770551455400633141999.99249355145600063637200024935401960006251222002266540196600628852400207754019720063297260019185401978006373728001781540198400642002999.991662540199000646813000166252894900063556320015585289496006405234001466528941020064560360013855289410800650793800131

8、25289411400656064000350030002500200015001000500058000 60000 62000 64000 66000 68000 70000 72000 订货批量存货总成本2000间距199.8间距200间距200按经济批量计算费用按折扣起点计算费用两个费用取小小费用对应数量无效50417955041795162879.3439563130.12262879.343951289.123992无效62511.96162511.9612000无效63555.6406763555.640673000订货批量为2000时,可取得最小存货总成本62511.96决决策

9、策内内部部依依据据年需要量5636每次订货费用806单位存储成本6决决策策外外部部依依据据折扣点批量价格11010009.820009.630009.440009.2决决策策过过程程经济批量是否有效订货批量订货成本购置成本存储成本总成本1230.530509无效200.82262356360602795851230.530509有效400.611340563601202689011230.530509无效600.47566563601801657271230.530509无效800.25677563602401644371230.530509无效999.99454356360300063903

10、100045435523330006277512003786552333600626181400324555233420062678订货批量为2000时,可取得最小存货总成本62376.91160028395523348006287218002524552335400631561999.99227155233600063504200022715410660006237722002065541066600627702400189354106720063198260017475410678006365328001622541068400641282999.991514541069000646203

11、00015145297890006349332001420529789600639983400133652978102006451436001262529781080065040380011955297811400655743999.99113652978120006611440001136518511200064987420010825185112600655334400103251851132006608446009885185113800666394800946518511440067198600050004000300020001000059000 61000 63000 65000

12、67000 69000 71000 订货批量存货总成本2000间距199.8间距200间距200间距200按经济批量计算费用按折扣起点计算费用两个费用取小小费用对应数量无效45989794598979162615.9830562775.41662615.983051230.530509无效62376.90862376.9082000无效63492.6053363492.605333000无效64986.85464986.8544000订货批量为2000时,可取得最小存货总成本62376.91决决策策内内部部依依据据年需要量5600每次订货费用760单位存储成本6决决策策外外部部依依据据折扣点批

13、量价格11010009.820009.630009.440009.250009决决策策过过程程订货批量订货成本购置成本存储成本总成本经济批量是否有效200.82119556000602777981191.077943无效400.610624560001202678261191.077943有效600.47089560001801648901191.077943无效800.25319560002401637191191.077943无效999.994256560003000632561191.077943无效10004256548803000621361191.077943无效120035475

14、4880360062027140030405488042006212016002660548804800623401800236454880540062644订货批量为2000时,可取得最小存货总成本618881999.99212854880600063008200021285376060006188822001935537606600622952400177353760720062733260016375376078006319728001520537608400636802999.9914195376090006417930001419526409000630593200133052640

15、9600635703400125252640102006409236001182526401080064622380011205264011400651603999.99106452640120006570440001064515201200064584420010135152012600651334400967515201320065687460092551520138006624548008875152014400668074999.9985151520150006737150008515040015000662515200818504001560066818540078850400162

16、00673887000600050004000300020001000058000 60000 62000 64000 66000 68000 70000 订货批量存货总成本560076050400168006796058007345040017400685342000间距199.8间距200间距200间距200间距200按经济批量计算费用按折扣起点计算费用两个费用取小小费用对应数量无效43120034312003162026.467666213662026.467661191.077943无效61888618882000无效63058.6666763058.666673000无效64584645844000无效66251.266251.25000订货批量为2000时,可取得最小存货总成本61888

展开阅读全文
相关资源
猜你喜欢
相关搜索

当前位置:首页 > 办公文档 > Excle表格

启牛文库网为“电子文档交易平台”,即用户上传的文档直接卖给(下载)用户,本站只是中间服务平台,本站所有文档下载所得的收益归上传人(含作者)所有。

本站是网络服务平台方,若您的权利被侵害,请立刻联系我们并提供证据,侵权客服QQ:709425133 欢迎举报。

©2012-2025 by www.wojuba.com. All Rights Reserved.

经营许可证编号:京ICP备14006015号