XLS《成本费用》

"表1.

1",,

,,

, ,,

,,

, "城市供水企业成本费用调查审核表",,

,,

, ,,

,,

, "项目名称","行次及互相关系","(13)年","(14)年","(15)年","备注" "年供水总量(m3)","B1=表

3、

1、2A35","2300000","2300000","2300000", "年售水总量(m3)","B2=表

3、

1、2A36","1941430","1822750","1904630", "管网漏损率(%)","B3=表

3、

1、2A50","15.590009765625","20.75","17.19", "

一、制水成本(元)","B4=B5+B11+B21+B24+B26+B27+B28+B33","2418421.37","2885993.73","2535673.48", "

1、原水费","B5=B6+B9","20016","40907.4","83516.4", "(1)原水费","B6=B7+B8",,

,,

"购原水量(m3)","B7",,

,,

"平均原水单价(元/m3)","B8",,

,,

"(2)水资源费","B9","20016","40907.4","83516.4", "地下水采水量(m3)","B10","2300000","2300000","2300000", "

2、原材料费","BB11=B12+B16+B20","84441","409743.9","52252", "(1)消毒药剂","B12","84441","409743.9","52252", "其中:盐酸,氯酸钠","B13",,

,,

"?盐酸,氯酸钠用量(kg)","B14",,

,,

"?单位消毒药用量(kg/m3)","B15=B14÷B1",,

,,

"(2)混凝药剂","B16",,

,,

"其中:氯化铝费用","B17",,

,,

"氯化铝用量(kg)","B18",,

,,

"单位氯化用量(kg/m3)","B19=B18÷B1",,

,,

"(3)其他材料","B20",,

,,

"

3、动力费","B21","840559.92","939746.56","833267.9", "其中:消耗动力电量(千瓦时)","B22","1158392","1280686","1163560", "单位制水耗电量(千瓦时/m3)","B23=B22÷B1","0.55","0.610000305175781","0.55", "?

4、外购成品水费","B24",,

,,

"其中:外购成品水量(m3)","B25",,

,,

"

5、修理费","B26","253863.3","228568.8","98716.88", "

6、制水环节职工薪酬","B27=表

3、

4、1D1","1003772.85","1174515.03","1318899.97", ,,

,,

, ,,

,,

, "表1.2",,

,,

, ,,

,,

, "城市供水企业成本费用调查审核表(续)",,

,,

, ,,

,,

, "项目名称","行次及互相关系","(13)年","(14)年","(15)年","备注" "

7、固定资产折旧","B28=B29+B30+B31+B32","70427.88","69854.7","61435.96", "(1)房屋","B29","2884.3225","2884.3225","2884.3225", "(2)专用设备","B30","23892.26","24587.3","24587.3", "(3)净水构筑物","B31","11753.89","11753.89","11753.89", "(4)其他固定资产","B32","31897.46","30629.22","22210.5", "

8、其他制水费用","B33","145340.42","22657.34","87584.45", "

二、输配成本(元)","B34=B35+B36+B41+B44…+B47","1718065.65","1943543.82","2452754.9", "

1、输配环节职工薪酬","B35=表

3、

4、1D14","1269348.71","1483617.48","1690897.37", "

2、固定资产折旧","B36+B37+B38+B39+B40","39314.76","39048.12","37969.8", "(1)房屋","B37","4593.6","4593.6","4593.6", "(2)管网","B38","21639.48","21639.48","21639.48", "(3)专用设备","B39","1384.56125","1384.56125","1384.56125", "(4)其他固定资产","B40","11697.13","11430.49","10352.165", "

3、动力费","B41","240159.98","268499.02","238076.53", "其中:消耗动力电量(千瓦时)","B42","891462","996656","884100", "?单位输配耗电量(千瓦时/m3)","B43=B42÷B1","0.388","0.433","0.384", "

4、修理费","B44","169242.2","152379.2","65811.24", "

5、机物料消耗","B45",,

,,

"

6、管网检测费","B46",,