{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["开机成本","生产成本","成本核算总结","其它"],"not_rendered":{"charts":7,"images":1,"external_links":1,"comments":65},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"开机成本","index":0,"n_rows":45,"n_cols":2,"rows_kept":45,"merged":[[0,0,0,1],[2,0,2,1],[7,0,7,1],[19,0,19,1],[26,0,26,1],[33,0,33,1],[41,0,41,1]],"flags":["formulas_cached_only"]}
["开机节约成本分析"]
[]
["说明"]
["描述","数据"]
["需要使用者填写数据的单元格","举例数据"]
["系统自动计算的单元格","系统自动计算"]
[]
["生产参数"]
["每天开机次数",1]
["每年度工作日次数",240]
["开机时生产线速度（m/min）",0.5]
["生产时线速度（m/min）",1.4]
["挤出材料密度（kg/m3）",950]
["单位时间投入非材料成本（￥/小时）",{"v":150,"d":"￥150"}]
["材料单价（￥/kg）",{"v":9,"d":"￥9.00"}]
["产品单价（￥/kg）",{"v":14,"d":"￥14.00"}]
["产品标称外径（mm）",{"v":200,"d":"200.00"}]
["产品标称厚度（mm）",{"v":11.9,"d":"11.90"}]
[]
["系统安装前相关参数"]
["平均开机时间（min）",6]
["每年开机废品长度（m）",720]
["每年开机废品消耗成本（￥）",{"v":43289.66657367268,"d":"￥43,290"}]
["每年开机消耗时间（小时）",24]
["开机占用非材料成本（￥）",{"v":3600,"d":"￥3,600"}]
[]
["系统安装后相关参数"]
["平均开机时间（min）",2]
["每年开机废品长度（m）",240]
["每年开机废品消耗成本（￥）",{"v":14429.888857890894,"d":"￥14,430"}]
["每年开机消耗时间（小时）",8]
["开机占用非材料成本（￥）",{"v":1200,"d":"￥1,200"}]
[]
["材料节约量"]
["开机消耗时间变化量（小时）",20]
["废品长度变化量（m）",480]
["消耗时间降低后产出量（m）",{"v":1344,"d":"1,344"}]
[]
["系统安装前废品量（kg）",{"v":4809.962952630298,"d":"4809.96"}]
["系统安装前废品量（kg）",{"v":1603.3209842100994,"d":"1603.32"}]
[]
["成本节约量"]
["非材料成本节约值",{"v":3000,"d":"￥3,000"}]
["材料成本节约值",{"v":28859.777715781784,"d":"￥28,860"}]
["节约时间完成产值",{"v":18816,"d":"￥18,816"}]

{"sheet":"生产成本","index":1,"n_rows":45,"n_cols":2,"rows_kept":45,"merged":[[0,0,0,1],[2,0,2,1],[7,0,7,1],[18,0,18,1],[26,0,26,1],[38,0,38,1],[42,0,42,1]],"flags":["formulas_cached_only"]}
["生产成本核算"]
[]
["说明"]
["描述","数据"]
["需要使用者填写数据的单元格","举例数据"]
["系统自动计算的单元格","系统自动计算"]
[]
["产品规格/技术指标"]
["挤出外径，标称值（mm）",{"v":400,"d":"400.00"}]
["挤出外径，公差（±mm）",{"v":1,"d":"1.00"}]
["挤出外径，标准偏差（mm）",{"v":3.6,"d":"3.60"}]
["挤出壁厚，标称值（mm）",{"v":23.7,"d":"23.70"}]
["挤出壁厚，公差（±mm）",{"v":2,"d":"2.00"}]
["挤出壁厚，标准偏差（mm）",{"v":4.7,"d":"4.70"}]
["挤出材料密度（kg/m3）",{"v":950,"d":"950.00"}]
["材料单价 （￥/kg）",{"v":8.5,"d":"￥8.50"}]
["产品单价（￥/kg）",{"v":13.5,"d":"￥13.50"}]
[]
["系统安装前相关参数"]
["同心度（最小壁厚/最大壁厚）（百分数表示）",{"v":0.99,"d":"99.0%"}]
["年挤出长度（m）",{"v":483840,"d":"483,840"}]
["控制前产品外径（mm）",{"v":200.8,"d":"200.80"}]
["控制前产品厚度（mm）",{"v":13,"d":"13.00"}]
["每年材料用量，系统安装前（kg）",{"v":3525446.980782921,"d":"3,525,447"}]
["每年材料成本，系统安装前（￥）",{"v":29966299.336654827,"d":"￥29,966,299"}]
[]
["系统安装后相关参数"]
["同心度（%）",{"v":0.96,"d":"96.0%"}]
["年挤出长度，系统安装后（m）",{"v":484560,"d":"484,560"}]
["控制后产品外径（mm）",{"v":200.8,"d":"200.80"}]
["控制后产品壁厚（mm）",{"v":12.3,"d":"12.30"}]
["最大壁厚（给出同心度及最小壁厚值）（mm）",{"v":12.812500000000002,"d":"12.81"}]
["最小内径（给出最小外径及最小/大壁厚要求）（mm）",{"v":175.6875,"d":"175.69"}]
["每年材料用量，系统安装后（kg）",{"v":3348048.290855346,"d":"3,348,048"}]
["每年材料成本，系统安装后（￥）",{"v":28458410.47227044,"d":"￥28,458,410"}]
[]
["系统安装后截面积",{"v":0.0072839396469806155,"d":"0.00728393965"}]
[]
["改变产量参数"]
["系统安装后年节约挤出材料量（kg）",{"v":177398.68992757518,"d":"177,399"}]
["系统安装后年生产合格品提高量（kg）",{"v":25636.602186711505,"d":"25,637"}]
[]
["成本节约量"]
["系统安装后年材料节约成本",{"v":1507888.864384389,"d":"￥1,507,889"}]
["节约材料产出价值",{"v":346094.1295206053,"d":"￥346,094"}]

{"sheet":"成本核算总结","index":2,"n_rows":25,"n_cols":2,"rows_kept":25,"merged":[[0,0,0,1],[2,0,2,1],[3,0,3,1],[5,0,5,1],[6,0,6,1],[8,0,8,1],[11,0,11,1],[16,0,16,1],[21,0,21,1]],"flags":["formulas_cached_only"]}
["成本核算总结"]
[]
["使用商"]
[]
[]
["产品名称"]
[]
[]
["年节约时间产品产值"]
["因开机时间的节约的非材料成本",{"v":3000,"d":"￥3,000"}]
[]
["年材料节约成本"]
["开机年节约成本",{"v":28859.777715781784,"d":"￥28,860"}]
["正常生产中节约成本",{"v":1507888.864384389,"d":"￥1,507,889"}]
["总材料节约成本",{"v":1536748.6421001707,"d":"￥1,536,749"}]
[]
["年生产能力的提高"]
["节约的开机时间的产品产值",{"v":18816,"d":"￥18,816"}]
["生产节约材料的年产品产值",{"v":346094.1295206053,"d":"￥346,094"}]
["生产力的提高带来的总产值",{"v":364910.1295206053,"d":"￥364,910"}]
[]
["系统回报期"]
["系统投入",{"v":560000,"d":"￥560,000"}]
["回报期，仅考虑材料节约的成本，生产中及开机时（月）",{"v":4.364348710081746,"d":"4.36"}]
["回报期，仅考虑年生产能力的提高的产品产值（月）",{"v":18.415493175890433,"d":"18.42"}]

{"sheet":"其它","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"merged":[[0,0,0,3],[3,0,3,3],[7,0,7,1],[7,2,7,3],[8,0,8,1],[8,2,8,3],[11,0,11,1],[11,2,11,3],[12,0,12,1],[12,2,12,3],[14,2,14,3],[15,0,15,1],[15,2,15,3],[16,0,16,1],[17,0,17,1],[18,0,18,1]],"flags":["formulas_cached_only"]}
["在线系统引入的其它效益"]
[]
[]
["对使用者而言，本软件中提供的Beta LaserMike控制系统在经济效应上的反映表现是系统是否采购的重要依据。但本系统带来的益处还体现在下文中提供的各方面："]
[]
[]
["质量的提高",null,"生产能力的提高"]
["* 减低产品的不合格率",null,"* 可提高每次开机的产量"]
["* 提高产品的一致性",null,"* 可提高生产速度"]
[]
["市场竞争力的提高",null,"提高研发能力"]
["* 符合ISO对系统竞争能力的要求",null,"* 减少研发的速度及难度"]
["* 增加最终用户的采购意愿",null,"* 与其它系统联网更便利"]
[]
["减少产品的成本",null,"便于系统维护"]
["* 降低开机时间",null,"* 通过对产品的检控获得系统的部件的磨损情况"]
["* 降低材料的投入",null,null,"   "]
["* 减少生产时间"]
["* 减少劳动力成本投入"]