工厂生产管理表

, 日期,制程43525.043526.043527.043528.043529.043530.043531.043532.043533.043534.043535.043536.043537.043538.043539.043540.043541.043542.043543.043544.043545.043546.043547.043548.043549.043550.043551.043552.043553.043554.043555.0,加工制程1,加工制程2,加工制程31950.0,加工制程41900.0,日期43525.043526.0,序号品名类型单位单价,原材原材片40.080000.080000.0,2.0生产人力300.060000.060000.0,3.0加工设备设备台/天50000.050000.0,4.0切削油桶/天1000.0,返修油石棒跟/天,6.0品质人力300.015000.015000.0,7.0酒精升/天,8.0口罩,9.0橡胶手套,不良标签,11.0采购人力380.01900.01900.0,11.0采购费用,12.0销售人力2500.02500.0,13.0销售费用1000.0,14.0仓库人力400.04000.04000.0,15.0仓储费用,16.0水电费用,17.0,18.0,19.0,20.0,21.0,22.0,23.0, 日期,制程43525.043526.043527.043528.043529.043530.043531.043532.0,加工制程12000.01999.02000.01996.0,加工制程21990.0,加工制程31985.01980.01985.01981.0,加工制程41958.0,日期43525.043526.0, 制程,项目制程1制程2制程3制程4制程1制程2制程3制程4,投入数2000.01999.01980.02000.01996.01981.0,一次产出数1950.01925.01994.01985.01970.01950.0,一次良率0.99750.9954977488740.9774436090230.9722222222220.9970.9944889779560.9899497487440.984351337708,返修数5.030.035.02.05.011.08.0,NG数1.015.020.06.09.023.0,二次产出数1999.01980.01960.01996.01981.01958.0,二次良率0.99950.99799899950.9924812030080.9898989898990.9980.9969939879760.9954773869350.988389702171,返修明细,NG明细,日期43525.043526.043527.043528.0,原库存160.0318.0318.0,入库数量1960.01958.0,单价,金额980000.0979000.0,销售出库1800.01800.0,日期43525.043526.0,序号消耗部门金额金额,1.0生产部197050.0195050.0,2.0品质部15250.015250.0,3.0采购部2100.01900.0,4.0销售部3500.02500.0,5.0仓储部9000.09000.0,合计,日期43525.043526.0,序号费用项目金额金额,1.0原材80000.080000.0,2.0人力83400.083400.0,3.0设备50000.050000.0,4.0耗材5300.05300.0,5.0耗损8200.05000.0,6.0成品980000.0979000.0,7.0毛利润753100.0755300.0,合计