机械制造企业安全费用提取标准
=IF(C2<=1000,C2*0.0235,23.5)
=IF(C2<=1000,0,IF(C2<=10000,(C2-1000)*0.0125,112.5))
=IF(C2<=10000,0,IF(C2<=100000,(C2-10000)*0.0025,225))
=IF(C2<=100000,0,IF(C2<=500000,(C2-100000)*0.001,400))
=IF(C2<=500000,0,(C2-500000)*0.0005)
=SUM(C3:C7)
煤矿原煤单位产量安全费用提取标准
=IF(B3=0,"",50*B3)
=IF(B4=0,"",30*B4)
=IF(B5=0,"",15*B5)
=IF(B6=0,"",5*B6)
非煤矿山安全费用提取标准
=IF(C3=0,"",5*C3)
=IF(C4=0,"",15*C4)
=IF(C5=0,"",25*C5)
=IF(C6=0,"",3*C6)
=IF(C7=0,"",8*C7)
=IF(C8=0,"",2*C8)
=IF(C9=0,"",4*C9)
=IF(C10=0,"",5*C10)
=IF(C13=0,"",C13*0.02)
石油天然气安全费用提取标准
=IF(C3=0,"",20*C3)
=IF(C4=0,"",7.5*C4)
建筑工程施工企业安全费用提取标准
=IF(B3=0,"",0.035*B3)
=IF(B4=0,"",0.03*B4)
=IF(B5=0,"",0.025*B5)
=IF(B6=0,"",0.02*B6)
=IF(B7=0,"",0.015*B7)
危化企业安全费用提取标准
=IF(C2<=1000,C2*0.045,45)
=IF(C2<=1000,C2*0.045,45)
=IF(C2<=2000,0,IF(C2<=10000,(C2-1000)*0.0225,202.5))
=IF(C2<=10000,0,IF(C2<=100000,(C2-10000)*0.0055,495))
=IF(C2<=100000,0,(C2-100000)*0.002)
=SUM(C3:C6)
交通企业安全费用提取标准
=IF(B3=0,"",0.01*B3)
=IF(B4=0,"",0.015*B4)
冶金企业安全费用提取标准
=IF(C2<=1000,C2*0.03,30)
=IF(C2<=1000,0,IF(C2<=10000,(C2-1000)*0.015,135))
=IF(C2<=10000,0,IF(C2<=100000,(C2-10000)*0.005,450))
=IF(C2<=100000,0,IF(C2<=500000,(C2-100000)*0.002,800))
=IF(C2<=500000,0,IF(C2<=1000000,(C2-500000)*0.001,500))
=IF(C2<=1000000,0,(C2-1000000)*0.0005)
=SUM(C3:C8)
烟花爆竹生产企业安全费用提取标准
=IF(C2<=1000,C2*0.04,40)
=IF(C2<=1000,0,IF(C2<=2000,(C2-1000)*0.03,30))
=IF(C2<=2000,0,(C2-2000)*0.025)
=SUM(C3:C5)