GMC春哥队决策模型

,,,,上季库存/未交,,-44,,,101,,,123,,,,,产品1,产品2,产品3,,,预计订单数量修正,,,,,,,,

,,,,,,-88,,,118,,,5,,预留库存,,国内,235,120,40,1285750,,3675,1700,525,,,,,,

,信春哥,,,,,0,,,61,,,294,,,,北美,103,60,10,593190,,1115,630,70,,,,,,

,,,,上季度订单,,3075,,,1429,,,427,,,,互联网,252,135,45,1390050,,3755,1705,600,,,,,,

,,,,,,1085,,,612,,,85,,,,库存销售额,1461740,1165500,633500,3260740,,,,,,,,,,

,,,,,,3076,,,1401,,,489,,,,,,,,,,,,,,,,,,

,,,,预计订单,,3675.3,19.5,,1700.3,19.0,,525.7,23.1,,,国内,北美,互联网,,,,,,,,,,,,

,决策部分,,,,,1116.1,2.9,,628.3,2.7,,66.4,-21.9,关于集装箱(个),,18.32,5.5,17.938,,,,,,,,,,,,

,,,,,,3756.0,22.1,,1705.1,21.7,,600.4,22.8,,,,,,,,,,,,,,,,,

生产及交付产品数,,最终修正数值(销售量),,,,产品1,%,,产品2,%,,产品3,%,,,,,,,,,,,,,,,,,

交付产品数:,,中国国内代理商,,,,3954,29,,1719,20,,442,4,6355,,,,,,,,,,,,,,,,

(星号代表,,北美自由贸易区经销商,,,,1306,20,,572,-7,,75,-12,2029,,,,,,,,,,,,,,,,

未完全交货),,国际互联网经销商,,,,4007,0,,1779,0,,351,0,6377,,组装工人工作时数,,加周日班,加周六班,正常班,,工人最大可用时数,,,,,,,,

,,,,预计交付销售量,,9267,,,4070,,,868,,14761,,预计下季度可用时数,,5124,5124,25620,,35868,,,,,,,,

,,,,预计机加工量,,9620,,,4235,,,906,,本季销售额,,缺勤时数,,,,,,0.900418426,(组装工人使用率),,,,,,,

价格(RMB'),,中国国内,,,,2450,-3.921568627,,3700,-3.896103896,,6650,-3.623188406,18785000,,预计本度实际工作时数,,1552,5124,32296,,,,,,,,,,

,,北美自由贸易区,,,,2730,-2.5,,3950,-2.469135802,,7500,0,6057450,,实际工资预算,,419717,1039147,,,,,,,,,,,

,,国际互联网,,,,2400,-4,,3650,-3.947368421,,6500,-3.703703704,19135250,,对应工资最大值,,1385530,1039147,3463824,,,,,,,,,,

,,,,销售额,,21059700,,,15001750,,,7916250,,43977700,,机器运行时数,,加周日班,加周六班,正常班,,机器最大可用时数,,,,,,,,

广告支出(RMB'000),,,公司形象,,,产品广告,,,,,,,,广告费,,预计下季度可用时数,,2856,1428,14280,,18564,,,,,,,,

,中国国内,,,10,,700,,,570,,,300,,3600,,故障机时,,,,31,,0.975120057,(机器使用率),,,,,,,

,北美自由贸易区,,,10,,200,,,160,,,10,,8.19%,,计划内维修时数,,,,51,,平均机器效率,,,,,,,,

,国际互联网,,,10,,750,,,530,,,350,,,,预计本季度实际运行时数,,2394,1428,18102,,92.4,,售后服务,,保修费用,,488573,,

,,,,,,60,,,75,,,120,,,,实际工资预算,,2244224,1003941,,,,,保修比,,0.028456453,,0.035735038,,0.042957043

产品组装时间(分钟),,,,,,105,,,151,,,318,,,,对应工资最大值,,2677176,1003941,6692941,,,,预计保修数,,274,,151,,39

产品改进(要=1;不要=0),,,,,,0,,,0,,,0,,,,原材料,,,,,,,,保修费,,600,,1500,,2500

产品研发费用(RMB'000),,,,,,300,,,0,,,0,,,,上季度末可用库存,,,,0,,,,运输,,中国国内,,北美自由贸易区,,国际互联网

,,,,,,,,,,,,,,,,本季度到货量,,,,21000,,,,平均运输距离(公里),,1381,,500,,300

原材料订购,,,,,,下季度,,,3个月后,,,6个月后,,,,上季度补缺购入量,,,,0,,,,集装箱数,,19,,6,,18

（单位：1000）,,,,,,5,,,0,,,0,,,,丢失/损坏,,,,0,,,,,运费,26000,,93000,,6500

,,,,原材料价格,,355355,,,337584,,,324624,,,,预计下季度实际耗用量,,,,20809,,,,,,494000,,558000,,117000

,,,,,,下季度,,,支持,,,,,,,本季度末剩余库存,,,,191,,,,,,,,,,

,,,,,,需求,,,费用,,,佣金%,,,,下季度到货量,,,,,,,预测销售额,产品1,产品2,产品3,,,,

代理商和经销商,,,,,,总数,,,（RMB'000）,,,,,,,上季度购入量,,,,0,,,国内,9003750,6290000,3491250,,,,

,中国国内代理商,,,,,8,,,130,,,9,,,,上上季度购入量,,,,0,,,北美,3043950,2488500,525000,,,,

,北美自由贸易区经销商,,,,,6,,,130,,,6,,,,下下季度到货量,,,,,,,互联网,9012000,6223250,3900000,,,,

,国际互联网经销商,,,,,xxxxx,,,120,,,5.5,,,,上季度购入量,,,,0,,,,21059700,15001750,7916250,,,,

,,,,,,,,,,,,,,,,,,,,,,广告,国内,7.83%,9.12%,8.65%,,,,

生产,欲购机器,,,1,,网站接口数,,,,,,25,,,,人力资源管理,,,组装,非技术,,,北美,6.74%,6.59%,2.07%,,,,

,欲售机器,,,0,,网站建设(RMB'000),,,第三期提升,,,450,,,,上季度初员工数,,,61,110,,,互联网,8.37%,8.57%,9.03%,,,,

每台机器维修时数,,,,3,,,,,,,,,,,,上季度招聘员工数,,,2,32,,,,7.90%,8.47%,8.40%,,,,

组装工人小时工资(RMB'),,,,135.2,,,,,轮班次数(1-3),,,2,,,,培训员工数,,,0,,,,,,,,,,,

组装工人的雇佣(+)/解雇(-),,,,2,,培训组装工人,,,,,,0,,,,解雇员工数,,,0,,,,,,,,,,,

,,,,,,,,,,,,,,,,上季度预计离职员工数,,,,6,,历史广告,国内,7.59%,7.81%,14.26%,,,,

投资(+/-RMB'000),,,,5000,,中期贷款(RMB'000),,,,,,16000,,,,下季度可用员工数,,,63,136,,,北美,14.04%,13.02%,27.56%,,,,

管理预算(RMB'000),,,,1550,,,,,%股息,第四期分红,,0,,,,,,,,,,,互联网,8.09%,8.74%,15.07%,,,,

公司活动信息(要=1;不要=0),,,,0,,市场占有率信息(要=1;不要=0),,,,,,0,,,,代理商和经销商,,中国国内,北美,国际互联网,,,,8.96%,9.24%,17.00%,,,,

保险方案代码(0-4),,,,4,,,,,,,,,,,,上季度可用,,6,3,1,,,,,,,,,,

,,,,,,,,,,,,,,,,上季度离开,,0,0,,,,,,,,,,,

,,,,,,,,,,,,,,,,上季度终止,,0,0,0,,,,,,,,,,

国际企业管理挑战赛中国