NC能源统计2016.03energy(utilities budget Ver 2).xls

2016 NC88K (electricity)/ diesel cost 2016 targetdiff2016 NC88Kwater2016 target Jan.443,586.02378,175.23-65,410.79Jan.17,096.839,209.43 Feb.319,272.19314,344.74-4,927.45Feb.10,824.329,062.96 Mar452,183.91385,953.79-66,230.12Mar16,861.7311,803.20 Apr410,211.15Apr13,481.53 May422,870.56May16,548.51 Jun480,328.12Jun14,616.69 Jul638,862.94Jul17,845.17 Aug616,823.36Aug25,676.01 Sep566,182.78Sep26,067.17 Oct448,067.39Oct11,611.38 Nov446,493.94Nov11,326.52 Dec458,335.45Dec18,507.65 Total：5,566,649.45Total：185,756.22 shortfall-136,568.36shortfall 2015 NC88K Total in 2015 (electricity)/ diesel cost Total in 2015water Jan.500,733.53Jan.11,869.74 Feb.402,876.23Feb.5,667.25 Mar406,375.89Mar9,883.95 Apr504,913.44Apr8,098.23 May370,102.59May13,845.53 Jun453,877.07Jun13,805.52 Jul568,194.85Jul21,128.44 Aug731,527.30Aug14,515.80 Sep503,296.09Sep12,159.86 Oct386,231.27Oct11,264.50 Nov469,802.67Nov13,085.22 Dec478,616.60Dec14,675.86 Total：5,776,547.53Total：149,999.90 diff2016 NC88Kgas2016 targetdiff -7,887.40Jan.159,649.217,315.31-152,333.90 -1,761.36Feb.34,697.8088,201.2153,503.41 -5,058.53Mar0.000.000.00 Apr0.00 May0.00 Jun0.00 Jul0.00 Aug0.00 Sep0.00 Oct0.00 Nov0.00 Dec143,210.94 Total：238,727.46 -14,707.29shortfall-98,830.49 Total in 2015gas Jan.238,019.89 Feb.0.00 Mar209,552.92 Apr0.00 May0.00 Jun0.00 Jul0.00 Aug0.00 Sep0.00 Oct0.00 Nov10,197.91 Dec58,785.24 Total：516,555.96 NC88K每每月月费费用用 Monthly Consumption 描述 DescriptionUnit Jan.Feb.MarAprMayJunJulAugSepOctNovDec 2016Total： 月份 Month/2016 Power 总总计计金金额额 TotalTotal CostCostRMB443,586.02319,272.19452,183.91 契约电量 Contract capacityKW200020002000200020002000200020002000200020002000 fixed costs-base charge for 2000KW RMB840008400084000840008400084000840008400084000840008400084000 有功消耗 Active ConsumptionKW474120316919501181 variable costs related to Active Consumption(peak& normal&valley time with different unit price) 无功消耗 Inactive ConsumptionKW14160188200107820 总总消消耗耗 GeneralGeneral ConsumptionConsumptionKW474,120316,919501,181 功功率率因因数数(标标准准0.90)power factor0.960.960.98 Water 总消耗 General ConsumptionM3341821643371 总计金额 Total CostRMB17,096.8310,824.3216,861.73 LPG 总消耗 General ConsumptionM336533794001 总计金额 Total CostRMB159,649.2134,697.800.00 依依据据及及计计算算 AccordingsAccordings 2016Cost Center PowerWaterLPG Production RatioHCRatioHVACRatio Kw%Sqm% Total1600100%1428100.00%30800100.00%总计 PP&FoamIBITNK98321613.50%1359.45%00.00%PP Leather cuttingIBISNK81319212.00%20214.15%780025.32%裁剪 Carpentry& beltingIBITNK80854834.25%20214.15%00.00%木工 Sewing&liningIBISNK83537423.38%25117.58%500016.23%缝工 Assembly & packagingIBISNK83716310.19%38026.61%1200038.96%包工包装 WW supply chainSBOXNK510563.50%1409.80%600019.48%供应链(皮仓库，物流部) OfficeSBOXNC198483.00%966.72%00.00%办公室 maintenanceIBVSNK84430.19%221.54%00.00%维修部 Cost Center JanFebMarAprMayJunJulAugSepOctNovDec powerWaterLPGpowerWaterLPGpowerWaterLPGpowerWaterLPGpowerWaterLPGpowerWaterLPGpowerWaterLPGpowerWaterLPGpowerWaterLPGpowerWaterLPGpowerWaterLPGpowerWaterLPG PP &FoamIBITNK98359884.111616.300.0043101.751023.310.0061044.831594.070.000.000.000.000.000.000.000.000.000.000.00#REF!0.000.000.000.000.0000.000.000.0000.000.000.0000.000.000.0000.000.00 Leather cuttingIBISNK81353230.322418.4640430.6438312.661531.178787.1154262.072385.200.000.000.000.000.000.000.000.000.000.000.00#REF!0.000.000.000.000.0000.000.000.0000.000.000.0000.000.000.0000.000.00 Carpentry& beltingIBITNK819151928.212418.460.00109350.731531.170.00154872.992385.200.000.000.000.000.000.000.000.000.000.000.00#REF!0.000.000.000.000.0000.000.000.0000.000.000.0000.000.000.0000.000.00 Sewing&liningIBISNK835103688.233005.1225917.0874629.871902.595632.76105697.992963.790.000.000.000.000.000.000.000.000.000.000.00#REF!0.000.000.000.000.0000.000.000.0000.000.000.0000.000.000.0000.000.00 Assembly & packagingIBISNK83745190.334549.5862200.9932525.852880.4213518.6246066.244487.010.000.000.000.000.000.000.000.000.000.000.00#REF!0.000.000.000.000.0000.000.000.0000.000.000.0000.000.000.0000.000.00 WW supply chainSBOXNK51015525.511676.1631100.5011174.531061.216759.3115826.441653.110.000.000.000.000.000.000.000.000.000.000.00#REF!0.000.000.000.000.0000.000.000.0000.000.000.0000.000.000.0000.000.00 OfficeSBOXNC19813307.581149.370.009578.17727.690.0013565.521133.560.000.000.000.000.000.000.000.000.000.000.00#REF!0.000.000.000.000.0000.000.000.0000.000.000.0000.000.000.0000.000.00 maintenanceIBVSNK844831.72263.400.00598.64166.760.00847.84259.770.000.000.000.000.000.000.000.000.000.000.00#REF!0.000.000.000.000.0000.000.000.0000.000.000.0000.000.000.0000.000.00 13.50% 12.00% 34.25% 23.38% 10.19% 3.50% 3.00% 0.19% P Po ow we er r PP&Foam Leather cutting Carpentry& belting Sewing&lining Assembly & packaging WW supply chain Office maintenance 9.45% 14.15% 14.15% 17.58% 26.61% 9.80% 6.72% 1.54% W Wa at te er r PP&Foam Leather cutting Carpentry& belting Sewing&lining Assembly & packaging WW supply chain Office maintenance 25.32% 16.23% 38.96% 19.48% L LP PG G PP&Foam Leather cutting Carpentry& belting Sewing&lining Jan.Feb.MarAprMayJunJulAugSepOctNovDec 0.00 50,000.00 100,000.00 150,000.00 200,000.00 250,000.00 300,000.00 350,000.00 400,000.00 450,000.00 500,000.00 Power Water LPG 2015 NC88K (electricity)/ diesel cost 2015 targetdiff2015 NC88Kwater2015 target Jan.500,733.53378,175.23-122,558.30Jan.11,869.749,209.43 Feb.402,876.23314,344.74-88,531.49Feb.5,667.259,062.96 Mar406,375.89385,953.79-20,422.10Mar9,883.9511,803.20 Apr504,913.44410,211.15-94,702.29Apr8,098.2313,481.53 May370,102.59422,870.5652,767.97May13,845.5316,548.51 Jun453,877.07480,328.1226,451.05Jun13,805.5214,616.69 Jul568,194.85638,862.9470,668.09Jul21,128.4417,845.17 Aug731,527.30616,823.36-114,703.94Aug14,515.8025,676.01 Sep503,296.09566,182.7862,886.69Sep12,159.8626,067.17 Oct386,231.27448,067.3961,836.12Oct11,264.5011,611.38 Nov469,802.67446,493.94-23,308.73Nov13,085.2211,326.52 Dec478,616.60458,335.45-20,281.15Dec14,675.8618,507.65 Total：5,566,649.46Total：185,756.20 shortfall-209,898.07shortfall 2014 NC88K Total in 2014 (electricity)/ diesel cost Total in 2014water Jan.444,912.04Jan.10,834.62 Feb.369,817.34Feb.10,662.30 Mar454,063.28Mar13,886.12 Apr482,601.35Apr15,860.62 May497,494.78May19,468.83 Jun565,091.90Jun17,196.10 Jul751,603.46Jul20,994.32 Aug725,674.54Aug30,207.07 Sep666,097.39Sep30,667.26 Oct527,138.11Oct13,660.45 Nov525,286.99Nov13,325.32 Dec539,218.18Dec21,773.70 Total：6,548,999.36Total：218,536.71 diff2015 NC88Kgas2015 targetdiff -2,660.31Jan.238,019.897,315.31-230,704.58 3,395.71Feb.0.0088,201.21-121,351.71 1,919.25Mar209,552.920.000.00 5,383.30Apr0.000.000.00 2,702.98May0.000.000.00 811.16Jun0.000.000.00 -3,283.27Jul0.000.000.00 11,160.21Aug0.000.000.00 13,907.31Sep0.000.000.00 346.88Oct0.000.000.00 -1,758.70Nov10,197.910.00-10,197.91 3,831.79Dec58,785.24143,210.9484,425.70 Total：238,727.46 35,756.30shortfall-277,828.50 Total in 2014gas Jan.8,606.25 Feb.103,766.13 Mar0.00 Apr0.00 May0.00 Jun0.00 Jul0.00 Aug0.00 Sep0.00 Oct0.00 Nov0.00 Dec168,483.46 Total：280,855.84