决策模型1

决策单非决策单部分参考数据价格市场1市场2市场3市场4广告费（K元）预测广告和促销价格产品A00000广告ABCD2400240026002600产品B000004,696.34,696.35,165.95,165.94800480050005000产品C00000促销1.02.03.04.05700570059005900产品D000004,696.34,696.35,165.95,165.97548754876007600促销费（K元）0000生产安排后计算向市场供货量市场1市场2市场3市场4总量产品可供货量加市场库存后总量供货产品A00000A35335311911912494456产品B00000B19219222222828100产品C00000C323200000产品D00000D434300000生产安排第一班第二班研发废品（产品数量）正班加班正班加班费用（K元）最多可买机器300000产品A3550000最少辞退人数50000产品B66013300可发贷款数目（K元）800080000000产品C004300可发债券数目（K元）5099.941090000产品D000580可分红数目（K元）985.85711发展新雇人数辞退人数买机器买原材料（K单位）90500本期市场需求市场1市场2市场3市场4总量财务银行贷款发债券买国债分红工资系数（%）产品A100.0100.0100.053.0353（K元）0001产品B0.00.00.00.00产品C0.00.00.00.00产品D0.00.00.00.00#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!企业财务预算会计项目收支本期收入本期成本现金累计上期转来4,891,617银行贷款+04,891,617公司净资产发债券+04,891,617项目金额累计还债券本金-50,0004,841,617现金4,915,952.34,915,952.3还债券利息-18,000180004,823,617国债+0.04,915,952.3新工人培训费-45,000630004,778,617原材料+1,422,300.06,338,252.3解雇工人安置费-5,000680004,773,617存货A+671,500.07,009,752.3工人基本工资-3,081710814,770,536存货B+900,985.07,910,737.3机器维修费-20,000910814,750,536存货C+233,457.08,144,194.3研发费-04,750,536存货D+391,545.08,535,739.3研发费分摊-091081研发费待摊+0.08,535,739.3购原材料-04,750,536机器原值+8,000,000.016,535,739.3购原材料优惠+004,750,536机器折旧-3,600,000.012,935,739.3购材料运费-0910814,750,536债券-550,000.012,385,739.3使用材料费-593,700684781特殊班工资-1,1966859774,749,340合计12,385,739.3管理费-54,0007399774,695,340成品运输费-07399774,695,340各指标7899770会计项目本期利润0.21408367.11广告费-07399774,695,340市场份额0.15不知道怎么算促销费-07399774,695,340累计分红0.120销售收入+7514007514005,446,740累计缴税0.12695,305废品损失07399775,446,740净资产0.1612,385,739.3机器折旧费-400,0001139977人均利润率0.125216.1744814815产品库存变化(1,905,222)-765244.61资本利润率0.130.1088741105原材料存储费-85,958-679287.115,360,782上期国债本息+07514005,360,782成品存储费-22,320-656967.115,338,462付银行贷款-05,338,462付银行利息-0-656967.115,338,462本期纳税-422,5104,915,952买机器-04,915,952分红-04,915,952买国债-04,915,952最后收入751400最后成本-656967.11本期利润1408367.11一班二班产品工资产品生产总量需机器数100正班加班正班加班可用机器数100产品A3550001,597.5355本期可用原材料(元)2,016,000剩余原材料（K单位）产品B66013301,460.0199使用原材料(元)593,7001,422,300产品C00430378.443本期至少购原材料(元)0产品D00058835.258本期退休人数5人机比1.277884615400.73999589580.5714285714本期需雇人数88.538最多可雇人数90第一正班人数127.7884615385一正用机器数100.00本期可用人数197.50第一加班人数0一加用机器数0.00需用人数量197.13第二正班人数69.3461538462二正用机器数93.711538462生产安排可能性true第二加班人数53.5384615385二加用机器数93.69工人基本工资3,0812066.6666666667特殊班工资1,196总工资4,277生产费用58,277一正产A能力520.0000二正产A能力520.0000一正产B能力208.0000二正产B能力208.0000产品本期至少需生产总量本期 计划 项目进度计划表范例计划下载计划下载计划下载课程教学计划下载 生产一正产C能力144.4444二正产C能力144.4444A4923530一正产D能力123.8095二正产D能力123.8095B76199一加产A能力260.0000二加产A能力260.0000C043一加产B能力104.0000二加产B能力104.0000D058一加产C能力72.2222二加产C能力72.2222最少需机器数96.0692307692一加产D能力61.9048二加产D能力61.9048各产品人机比ABCD平均本期企业自身人机比1.50.80.61111111110.57142857140.87063492061.975200000第一班第二班总计产品A产品B产品C产品D固定费用(产品A)4,00004,000机时100250360420固定费用(产品B)8,00010,00018,000人力150200220240固定费用(产品C)012,00012,000原材料300120020002800固定费用(产品D)020,00020,000#DIV/0!#DIV/0!2800产品A产品B市场1市场2市场3市场4市场1市场2市场3市场4售价0000售价0000原材料成本300300300300原材料成本1200120012001200工人工资5.55.55.55.5工人工资7.37.37.37.3机器消耗335.8335.8335.8335.8机器消耗839.4839.4839.4839.4运输成本0.00.00.00.0运输成本#DIV/0!#DIV/0!#DIV/0!#DIV/0!管理成本11.311.311.311.3管理成本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!成本贡献率#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!产品C产品D市场1市场2市场3市场4市场1市场2市场3市场4售价0000售价0000原材料成本2000200020002000原材料成本2800280028002800工人工资8.18.18.18.1工人工资8.88.88.88.8机器消耗1,208.71,208.71,208.71,208.7机器消耗1,410.21,410.21,410.21,410.2运输成本0.00.00.00.0运输成本0.00.00.00.0管理成本279.1279.1279.1279.1管理成本344.8344.8344.8344.8广告成本0.00.00.00.0广告成本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!#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!#REF!机器贡献率#DIV/0!#DIV/0!#DIV/0!#DIV/0!员工贡献率#DIV/0!#DIV/0!#DIV/0!#DIV/0!员工贡献率#DIV/0!#DIV/0!#DIV/0!#DIV/0!产品市场上期预定本期需求本期销售上期库存期末库存废品废品参考供货参考100%90%85%80%70%60%50%40%84%82%80%75%70%65%60%55%A11910000000.00000000000000000001A21910000000.00000000000000000001A32410000000.00000000000000000001A4415300000.00000000000000000001B122000000.00000000000000000001B222000000.00000000000000000001B328000000.00000000000000000001B428000000.00000000000000000001C10000000.00000000000000000001C20000000.00000000000000000001C30000000.00000000000000000001C40000000.00000000000000000001D10000000.00000000000000000001D20000000.00000000000000000001D30000000.00000000000000000001D40000000.00000000000000000001123456789101112131415161产品工厂库存本期研发上期库存预测产品等级预测正品率A1A4420870.0000.849B1B2420430.0000.857C1C43000.0000.863D1D58000.0000.87上期人数180产品市场上期预定上期库存机器数100期末机器100A1190期初原材料数2,016,000A2190上期末现金4,891,617A3240累计折旧3,200,000A4410截止上期贷款信用额度8,000,000B1220上期末国债数0B2220上期债券数600,000B3280累计研发费300,000310.05B4280截止上期累计交税272,795C100截止上期累计分红00C200期初的净资产11,399,882C300上期库存价值C400产品A132,173D100产品B160,092D200产品C0D300产品D0D400上期发行的债券0上期还的债券本金50,000上期研发费用0357上期各产品价格405.9价格市场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.960产品B430200,0001.0000.960产品C0000.0000.960产品D0000.0000.960机器价格80,000管理费用数据分红现金流底线2,500,000原材料价格(>=)单位/元第一班A4,000第二班A6,000正常退休比例0.0301第一班B8,000第二班B10,000最初银行信用额度8,000,00010000000.98第一班C10,000第二班C12,000原材料运输固定费500015000000.96第一班D15,000第二班D20,000原材料运输变动费0.0220000000.94变动运输费用原材料当期到货比0.5A的价值1519.2307692308市场1市场2市场3市场4招收人数限制比0.5B的价值3723.0769230769产品A8045200250债券限额比0.5C的价值5429.2307692308产品B445355600650国债利率0.08D的价值6750.7692307692产品C645555800850还债比0.05单个存储费用产品D74565510001050债券利率0.12A20固定费用生产供货比0.75B80产品A1,5919094,0005,000原材料库存费率0.05C100产品B8,9097,09112,00013,000折旧率0.05D120产品C12,90911,09116,00017,000机器折旧率0.05新工人培训费500产品D14,90913,09118,00019,000银行贷款利率0.08解雇工人安置费1000生产单个产品的资源税率0.3机器维修费200产品A产品B产品C产品D工资系数参数 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf 累税和分红效应7%机时100250360420A1.05订货比人力150200220240B0.97ABCD原材料300120020002800C0.91130%35%40%40%员工待遇D0.84230%35%40%40%一班单位二班影响度0.3320%25%30%30%正班加班正班加班初始正品率422%28%25%25%34.5元/时46A0.95B0.95C0.95D0.95研发数据一级二级三级四级五级产品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