塑胶注塑厂201X年产能负荷分析模版

塑胶注塑厂201X年产能负荷状况,,,,,,,,,,,,,,,,,,

序号,设备(工站)名称,现有设备数量,单台设备占地面积,月份,1月份,2月份,3月份,4月份,5月份,6月份,7月份,8月份,9月份,10月份,11月份,12月份,AVERAGE,备注

,,,,月计算天数,25,21,27,26,25,25,27,26,25,23,26,26,25.2,

1,50T,5,20,拥有工时(H),"3,000","2,520","3,240","3,120","3,000","3,000","3,240","3,120","3,000","2,760","3,120","3,120","3,020",

,,,,需求工时(H),181,181,181,181,181,181,181,181,181,181,181,181,181,

,,,,负荷率(%),6%,7%,6%,6%,6%,6%,6%,6%,6%,7%,6%,6%,6%,

,,,,计算拥有人力,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5,

,,,,实际拥有人力,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,8.0,

,,,,计算需求人力,0.5,0.5,0.4,0.4,0.5,0.5,0.4,0.4,0.5,0.5,0.4,0.4,0.4,

,,,,实际需求人力,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,

,,,,计算需求设备,0.3,0.4,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,

,,,,实际需求设备,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,

,,,,需求面积(m2),20,20,20,20,20,20,20,20,20,20,20,20,20,

2,100-130T,10,25,拥有工时(H),"6,000","5,040","6,480","6,240","6,000","6,000","6,480","6,240","6,000","5,520","6,240","6,240","6,040",

,,,,需求工时(H),"1,199","1,199","1,199","1,199","1,199","1,199","1,199","1,199","1,199","1,199","1,199","1,199","1,199",

,,,,负荷率(%),20%,24%,19%,19%,20%,20%,19%,19%,20%,22%,19%,19%,20%,

,,,,计算拥有人力,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,

,,,,实际拥有人力,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,20.0,

,,,,计算需求人力,4.0,4.8,3.7,3.8,4.0,4.0,3.7,3.8,4.0,4.3,3.8,3.8,4.0,

,,,,实际需求人力,4.0,5.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,5.0,4.0,4.0,4.0,

,,,,计算需求设备,2.0,2.4,1.9,1.9,2.0,2.0,1.9,1.9,2.0,2.2,1.9,1.9,2.0,

,,,,实际需求设备,2.0,3.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,3.0,2.0,2.0,2.0,

,,,,需求面积(m2),50,75,50,50,50,50,50,50,50,75,50,50,50,

3,180T-250T,21,45,拥有工时(H),"12,600","10,584","13,608","13,104","12,600","12,600","13,608","13,104","12,600","11,592","13,104","13,104","12,684",

,,,,需求工时(H),456,456,456,456,456,456,456,456,456,456,456,456,456,

,,,,负荷率(%),4%,4%,3%,3%,4%,4%,3%,3%,4%,4%,3%,3%,4%,

,,,,计算拥有人力,63.0,63.0,63.0,63.0,63.0,63.0,63.0,63.0,63.0,63.0,63.0,63.0,63.0,

,,,,实际拥有人力,63.0,63.0,63.0,63.0,63.0,63.0,63.0,63.0,63.0,63.0,63.0,63.0,63.0,

,,,,计算需求人力,2.3,2.7,2.1,2.2,2.3,2.3,2.1,2.2,2.3,2.5,2.2,2.2,2.3,

,,,,实际需求人力,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,

,,,,计算需求设备,0.8,0.9,0.7,0.7,0.8,0.8,0.7,0.7,0.8,0.8,0.7,0.7,0.8,

,,,,实际需求设备,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,

,,,,需求面积(m2),45,45,45,45,45,45,45,45,45,45,45,45,45,

4,350-650T,26,60,拥有工时(H),"15,600","13,104","16,848","16,224","15,600","15,600","16,848","16,224","15,600","14,352","16,224","16,224","15,704",

,,,,需求工时(H),371,371,371,371,371,371,371,371,371,371,371,371,371,

,,,,负荷率(%),2%,3%,2%,2%,2%,2%,2%,2%,2%,3%,2%,2%,2%,

,,,,计算拥有人力,104.0,104.0,104.0,104.0,104.0,104.0,104.0,104.0,104.0,104.0,104.0,104.0,104.0,

,,,,实际拥有人力,104.0,104.0,104.0,104.0,104.0,104.0,104.0,104.0,104.0,104.0,104.0,104.0,104.0,

,,,,计算需求人力,2.5,2.9,2.3,2.4,2.5,2.5,2.3,2.4,2.5,2.7,2.4,2.4,2.5,

,,,,实际需求人力,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,

,,,,计算需求设备,0.6,0.7,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.7,0.6,0.6,0.6,

,,,,实际需求设备,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,

,,,,需求面积(m2),37,44,34,36,37,37,34,36,37,40,36,36,37,

5,表面处理,4,45,拥有工时(H),"2,000","1,680","2,160","2,080","2,000","2,000","2,160","2,080","2,000","1,840","2,080","2,080","2,013",

,,,,需求工时(H),"2,371","2,371","2,371","2,371","2,371","2,371","2,371","2,371","2,371","2,371","2,371","2,371","2,371",

,,,,负荷率(%),119%,141%,110%,114%,119%,119%,110%,114%,119%,129%,114%,114%,118%,

,,,,计算拥有人力,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,

,,,,实际拥有人力,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,48.0,

,,,,计算需求人力,56.9,67.7,52.7,54.7,56.9,56.9,52.7,54.7,56.9,61.8,54.7,54.7,56.5,

,,,,实际需求人力,57.0,68.0,53.0,55.0,57.0,57.0,53.0,55.0,57.0,62.0,55.0,55.0,57.0,

,,,,计算需求设备,4.7,5.6,4.4,4.6,4.7,4.7,4.4,4.6,4.7,5.2,4.6,4.6,4.7,

,,,,实际需求设备,5.0,6.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,6.0,5.0,5.0,5.0,

,,,,需求面积(m2),225,270,225,225,225,225,225,225,225,270,225,225,225,

总拥有(人力)工时(H),,,,,"60,750","51,030","65,610","63,180","60,750","60,750","65,610","63,180","60,750","55,890","63,180","63,180","61,155",

总需求(人力)工时(H),,,,,"17,000","16,800","17,280","17,160","17,000","17,000","17,280","17,160","17,000","17,020","17,160","17,160","17,113",

实际总负荷率(%),,,,,28%,33%,26%,27%,28%,28%,26%,27%,28%,30%,