《决策模型1.xls》由会员分享，可在线阅读，更多相关《决策模型1.xls（20页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、决决策策单单价格市场1市场2市场3市场4广告费（K元）预预测测广广告告和和促促销销产品A0 00 00 00 00 0广告A产品B0 00 00 00 00 04,696.3产品C0 00 00 00 00 0促销1.0产品D0 00 00 00 00 04,696.3促销费（K元）0 00 00 00 0生产安排后计算向市场供货量 市场1市场2市场3市场4总量 产品可供货量产品A0 00 00 00 00 A353产品B0 00 00 00 00 B192产品C0 00 00 00 00 C32产品D0 00 00 00 00 D43生产安排第一班第二班研发（产品数量）正班加班正班加班费用（
2、K元）最多可买机器产品A3550000 0最少辞退人数产品B66013300 0可发贷款数目（K元）产品C004300 0可发债券数目（K元）产品D000580 0可分红数目（K元）发展新雇人数辞退人数买机器买原材料（K单位）90905 50 00 0财务银行贷款发债券买国债分红工资系数（%）产品A（K元）0 00 00 01 1产品B产品C产品D 非非决决策策单单部部分分 参参考考数数据据价价格格BCD24002400260026004,696.35,165.95,165.948004800500050002.03.04.057005700590059004,696.35,165.95,16
3、5.97548754876007600加市场库存后总量供供货货353119119124944561922222282810032000004300000废废品品300000500008000800000005099.941090000985.85711本本期期市市场场需需求求市场1市场2市场3市场4总量100.0100.0100.0100.0100.0100.053.053.03530.00.00.00.00.00.00.00.000.00.00.00.00.00.00.00.000.00.00.00.00.00.00.00.00#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV
4、/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!预预测测广广告告和和促促销销生产安排后计算企业财务预算会计项目收支本期收入本期成本 现金累计上期转来4,891,617银行贷款+04,891,617发债券+04,891,617还债券本金-50,0004,841,617还债券利息-18,000180004,823,617新工人培训费-45,000630004,778,617解雇工人安置费-5,000680004,773,617工人基本工资-3,081710814,770,536机器维修费
5、-20,000910814,750,536研发费-04,750,536研发费分摊-091081购原材料-04,750,536购原材料优惠+004,750,536购材料运费-0910814,750,536使用材料费-593,700684781特殊班工资-1,1966859774,749,340管理费-54,0007399774,695,340成品运输费-07399774,695,3407899770会计项目广告费-07399774,695,340促销费-07399774,695,340销售收入+7514007514005,446,740废品损失07399775,446,740机器折旧费-400,
6、0001139977产品库存变化(1,905,222)-765245原材料存储费-85,958-6792875,360,782上期国债本息+07514005,360,782成品存储费-22,320-6569675,338,462付银行贷款-05,338,462付银行利息-0-6569675,338,462本期纳税-422,5104,915,952买机器-04,915,952分红-04,915,952买国债-04,915,952最后收入751400最后成本-656967本期利润1408367.1公司净资产项目金额累计现金4,915,952.34,915,952.3国债+0.04,915,952.
7、3原材料+1,422,300.06,338,252.3存货A+671,500.07,009,752.3存货B+900,985.07,910,737.3存货C+233,457.08,144,194.3存货D+391,545.08,535,739.3研发费待摊+0.08,535,739.3机器原值+8,000,000.016,535,739.3机器折旧-3,600,000.012,935,739.3债券-550,000.012,385,739.3合计12,385,739.3各指标本期利润0.21408367.11市场份额0.15不知道怎么算累计分红0.120累计缴税0.12695,305净资产0.
8、1612,385,739.3人均利润率0.125216.174481资本利润率0.130.108874111一班二班产品工资正班加班正班加班产品A3550001,597.5产品B66013301,460.0产品C00430378.4产品D00058835.2人机比1.277884600.739995896 0.5714286第一正班人数127.7884615一正用机器数第一加班人数0一加用机器数第二正班人数69.34615385二正用机器数第二加班人数53.53846154二加用机器数一正产A能力520.0000二正产A能力一正产B能力208.0000二正产B能力一正产C能力144.4444二
9、正产C能力一正产D能力123.8095二正产D能力一加产A能力260.0000二加产A能力一加产B能力104.0000二加产B能力一加产C能力72.2222二加产C能力一加产D能力61.9048二加产D能力各产品人机比ABCD1.50.80.61111110.571428571第一班第二班总计固定费用(产品A)4,00004,000机时固定费用(产品B)8,00010,00018,000人力固定费用(产品C)012,00012,000原材料固定费用(产品D)020,00020,000产品生产总量需机器数100可用机器数100355本期可用原材料(元)2,016,000剩余原材料（K单位）199
10、使用原材料(元)593,7001,422,30043本期至少购原材料(元)058本期退休人数5本期需雇人数88.538最多可雇人数90100.00本期可用人数197.500.00需用人数量197.1393.711538462生产安排可能性TRUE93.69工人基本工资3,0812066.666667特殊班工资1,196总工资4,2774,277生生产产费费用用58,277520.0000208.0000产品本期至少需生产总量本期计划生产144.4444A4923530123.8095B76199260.0000C043104.0000D05872.2222最少需机器数96.0692307761
11、.9048平均本期企业自身人机比0.8706349211.975200000产品A产品B产品C产品D100250360420150200220240300120020002800#DIV/0!#DIV/0!2800剩余原材料（K单位）产产品品A产产品品B市场1市场2市场3市场4售售价价0 00 00 00 0售售价价原材料成本300300300300原材料成本工人工资5.55.55.55.5工人工资机器消耗335.8335.8335.8335.8机器消耗运输成本0.00.00.00.0运输成本管理成本11.311.311.311.3管理成本广告成本#DIV/0!#DIV/0!#DIV/0!#D
12、IV/0!广告成本促销成本#DIV/0!#DIV/0!#DIV/0!#DIV/0!促销成本总总成成本本#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!总总成成本本单单个个产产品品利利润润#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!单单个个产产品品利利润润成本贡献率#DIV/0!#DIV/0!#DIV/0!#DIV/0!成本贡献率机器贡献率#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!机器贡献率员工贡献率#DIV/0!#DIV/
13、0!#DIV/0!#DIV/0!员工贡献率产产品品C产产品品D市场1市场2市场3市场4售售价价0 00 00 00 0售售价价原材料成本2000200020002000原材料成本工人工资8.18.18.18.1工人工资机器消耗1,208.71,208.71,208.71,208.7机器消耗运输成本0.00.00.00.0运输成本管理成本279.1279.1279.1279.1管理成本广告成本0.00.00.00.0广告成本促销成本#DIV/0!#DIV/0!#DIV/0!#DIV/0!促销成本总总成成本本#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DI
14、V/0!#DIV/0!总总成成本本单单个个产产品品利利润润#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!单单个个产产品品利利润润成本贡献率#DIV/0!#DIV/0!#DIV/0!#DIV/0!成本贡献率机器贡献率#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#REF!机器贡献率员工贡献率#DIV/0!#DIV/0!#DIV/0!#DIV/0!员工贡献率市场1市场2市场3市场40 00 00 00 012001200120012007.37.37.37.3839.4839.4839.4839.4#DIV/
15、0!#DIV/0!#DIV/0!#DIV/0!90.590.590.590.5#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!市场1市场2市场3
16、市场40 00 00 00 028002800280028008.88.88.88.81,410.21,410.21,410.21,410.20.00.00.00.0344.8344.8344.8344.80.00.00.00.0#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DI
17、V/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!产产品品B产产品品D产品市场上期预定本期需求本期销售上期库存期末库存废品废品参考供货参考100%A11910000000.0000A21910000000.0000A32410000000.0000A4415300000.0000B122000000.0000B222000000.0000B328000000.0000B428000000.0000C10000000.0000C20000000.0000C30000000.0000C40000000.0000D10000000.0000D20000000.0000D3
18、0000000.0000D40000000.00001 1产品工厂库存本期研发上期库存 预测产品等级 预测正品率AA4420870.0000.849BB2420430.0000.857CC43000.0000.863DD58000.0000.8790%85%80%70%60%50%40%84%82%80%75%70%65%60%55%0000000000000001 10000000000000001 10000000000000001 10000000000000001 10000000000000001 10000000000000001 10000000000000001 1000000
19、0000000001 10000000000000001 10000000000000001 10000000000000001 10000000000000001 10000000000000001 10000000000000001 10000000000000001 10000000000000001 12 23 34 45 56 67 78 89101112131415161 11111上期人数180产品机器数100期末机器100A期初原材料数2,016,000A上期末现金4,891,617A累计折旧3,200,000A截止上期贷款信用额度8,000,000B上期末国债数0B上期债券数
20、600,000B累计研发费300,000310.05B截止上期累计交税272,795C截止上期累计分红00C期初的净资产11,399,882C上期库存价值C产品A132,173D产品B160,092D产品C0D产品D0D上期发行的债券0上期还的债券本金50,000上期研发费用0上期各产品价格价格市场1市场2市场3市场4产品A2,4002,4002,6002,600产品B4,8004,8005,0005,000产品C5,7005,7005,9005,900产品D7,4007,4007,6007,600工厂库存上期研发累积研发费 上期产品等级 上期正品率产品A870100,0001.0000.96
21、0产品B430200,0001.0000.960产品C0000.0000.960产品D0000.0000.960市场上期预定上期库存11902190324044101220222032804280100200300400100200300400357405.9机器价格80,000管理费用数据原材料价格(=)单位/元第一班A4,000第二班A6,00001第一班B8,000第二班B10,00010000000.98第一班C10,000第二班C12,00015000000.96第一班D15,000第二班D20,00020000000.94变动运输费用A的价值1519.2308市场1市场2市场3B的
22、价值3723.0769产品A8045200C的价值5429.2308产品B445355600D的价值6750.7692产品C645555800单个存储费用产品D7456551000A20固定费用B80产品A1,5919094,000C100产品B8,9097,09112,000D120产品C12,90911,09116,000新工人培训费500产品D14,90913,09118,000解雇工人安置费1000生产单个产品的资源机器维修费200产品A产品B产品C累税和分红效应7%机时100250360人力150200220原材料30012002000员工待遇一班单位二班正班加班正班34.5元/时4
23、研发数据一级二级三级四级五级产品A100,000200,000300,000400,000500,000产品B200,000350,000480,000600,000700,000产品C300,000450,000580,000700,000800,000产品D500,000600,000700,000850,0001,000,000100,000100,000100,000100,000150,000130,000120,000100,000150,000130,000120,000100,000100,000100,000150,000150,000分红现金流底线2,500,000正常退休
24、比例0.03最初银行信用额度8,000,000原材料运输固定费5000原材料运输变动费0.02原材料当期到货比0.5市场4招收人数限制比0.5250债券限额比0.5650国债利率0.08850还债比0.051050债券利率0.12生产供货比0.755,000原材料库存费率0.0513,000折旧率0.0517,000机器折旧率0.0519,000银行贷款利率0.08税率0.3产品D工资系数参数表420A1.05订货比240B0.97ABC2800C0.91130%35%40%D0.84230%35%40%影响度0.3320%25%30%加班初始正品率422%28%25%6A0.95B0.95C0.95D0.95二班D40%40%30%25%