2017 BPC财务预算模板.xls

年年份份Dec 17 版版本本Budget Budget PeriodicPeriodic Profit Loss Summary2016 012016 02 1 Sales Volume Excl W S 1 4121 106 Direct retail自有零售 7055 546428 796623 1 4121 106 2 Net Sales To 3rd party 7 0545 525 Direct retail自有零售 345270 2 8832 258 3 8262 997 7 0545 525 3 Cost To 3rd party 5 223 4 091 Direct retail自有零售 258 202 2 021 1 583 2 944 2 306 5 223 4 091 4 Gross profit Excl W S 1 8301 434 Direct retail自有零售 8768 862675 882691 1 8301 434 5 Gross profit Excl W S 1 2971 297 Direct retail自有零售 1 2401 240 1 5771 577 1 1091 109 1 2971 297 Gross profit 1 8301 434 Release of deposits Maintenance fees1313 Rental income and meter fees 管理费 场地租金 设备租金收入 55 New activities 入此科目请先沟通 Other total Other2 service fee for account opening开户手续费收入 Other3 other metrials water etc 其他物料销售 Other4 Other5 Other6 Other7 Split not available other activities Intercompany sales rent and other serv 关联方合计 Gross profit other1818 TOTAL GROSS PROFIT1 8491 452 Salaries and wages 薪金与工资 503 512 Depreciation and depletion 折旧和摊销 61 61 Other costs fixed其他成本 固定 432 432 Other costs variable其他成本 变动 Service fee 总部服务费 TotalTotal operatingoperating expensesexpenses 总总营营运运费费用用 997 1 005 Income from investments in affiliates 对联营公司投资收益 Income from private equity investments 少数股权投资收益 OperatingOperating incomeincome 营营业业收收益益 IFCEIFCE息息税税前前利利润润 852447 Interest third parties net 第三方利息收支净额00 Intercompany interest net 关联方利息收支净额 OtherOther financialfinancial incomeincome andand expensesexpenses 其其他他财财务务费费用用 1 1 Currency exchange gain or loss汇兑损益 Tax for cash pooling income现金池利息收入税费 Bank charges银行手续费 1 1 FinancialFinancial resultresult 财财务务费费用用合合计计 0 1 Disposals处置 Reorganizations重组 Impairment资产减值 Pensions养老金 Indemnities claims赔偿 Other其他 ExtraordinaryExtraordinary incomeincome andand expensesexpenses 特特殊殊事事项项收收支支 EariningsEarinings beforebefore taxestaxes 税税前前利利润润852446 Income taxes Current 当期所得税 230 120 Income taxes Deferred 递延所得税 IncomeIncome taxestaxes 所所得得税税合合计计 230 120 Income taxes on result from affiliates 因关联公司产生的收入所得税 Withholding taxes 代扣代缴所得税 NetNet incomeincome 净净利利润润622326 Results of companies to be consolidated 子公司净利润 Income to third party interest in subsidiaries 归属于少数股东的净利润 Net income according to balance sheets 归归属属于于母母公公司司净净利利润润622326 SWAPSWAP 纸纸货货 EffectiveEffective taxtax raterate 有有效效所所得得税税率率27 0 27 0 IFCE exclude service fee 息税前利润 不含服务费852447 Net income exclude service fee 净利润 不含服务费622326 Check 1 Sales Volume Excl W S 2 Net Sales To 3rd party 3 Cost To 3rd party TotalTotal operatingoperating expensesexpenses 总总营营运运费费用用 OperatingOperating incomeincome 营营业业收收益益 IFCEIFCE息息税税前前利利润润 OtherOther financialfinancial incomeincome andand expensesexpenses 其其他他财财务务费费用用 FinancialFinancial resultresult 财财务务费费用用合合计计 ExtraordinaryExtraordinary incomeincome andand expensesexpenses 特特殊殊事事项项收收支支 EariningsEarinings beforebefore taxestaxes 税税前前利利润润 IncomeIncome taxestaxes 所所得得税税合合计计 NetNet incomeincome 净净利利润润 Net income according to balance sheets 归归属属于于母母公公司司净净利利润润 Expense item2016 012016 02 Salaries and wages 薪薪金金与与工工资资 503 512 Depreciation and depletion 折折旧旧和和摊摊销销 61 61 Other costs fixed其其他他成成本本 固固定定 432 432 Other costs variable其其他他成成本本 变变动动 Service fee 总总部部服服务务费费 Salaries and wages 薪薪金金与与工工资资 503 512 Personnel cost Fixed固定工资 262 262 Personnel costs variable浮动工资 包括 计件 绩效 销售提成 其他浮动 51 46 Personnel costs OT加班费 48 62 Bonus 年终奖 70 70 Social Insurance Housing Fund社保及住房公积金 73 73 Depreciation and depletion 折折旧旧和和摊摊销销 61 61 Depreciation new investments of year itself 当年新增投资折旧 Depreciation older investments previous years 以前年度投资折旧 61 61 Amortization acquisition 摊销 收购公司 Other costs fixed其其他他成成本本 固固定定 432 432 Rental Fee租赁费 62 62 Veichle expenses Diesel Toll fee Maintainance 车辆运行费 油费 路桥费及停车费 固定规费 日常维修费 检测费 修补轮胎 新购轮胎 53 44 Retesting Fee检测费 6 6 Equipment Maintainace Fee设备维修费 8 7 Entertainment Fee 接待费用 35 83 Consultant Auditor Lawyer Fee咨询 审计 律师费 21 21 Travel差旅费 17 17 Staff Welfare 其他员工福利 64 29 Marketing expenses市场推广费 55 55 outscouring外包人员 Others其他费用 111 109 Service fee总总部部服服务务费费 Other costs variable其其他他成成本本 变变动动 Ouscource Bicycle Freight临时劳务费 配送费 送气工 Outscource Truck Freight 外包配送运费 Others其他变动费用 工资 固定工资Salary and wage fixed 262 262 工资 变动工资 绩效工资Salary and wage variable performance pay 11 11 工资 变动工资 计件工资Salary and wage variable piece wage 19 15 工资 变动工资 销售提成Salary and wage variable sales commission 4 3 工资 变动工资 加班费Salary and wage variable overtime pay 48 62 工资 变动工资 其他Salary and wage variable other 17 17 工资 年终奖金Salary and wage year end bonus 70 70 工资 社会保险费Salary and wage social insurance charges 59 59 工资 住房公积金Salary and wage housing fund 15 15 折旧费 土地Depreciation cost land 折旧费 码头及建筑物Depreciation cost wharf and building 31 31 折旧费 工业设备Depreciation cost industrial equipment 折旧费 气站设备Depreciation cost gas station equipment 18 18 折旧费 运输设备Depreciation cost transportation equipmen 7 7 折旧费 钢瓶Depreciation cost cylinder 0 0 折旧费 储罐 投资客户 Depreciation cost storage tank i 折旧费 办公设备Depreciation cost office equipment 5 5 摊销 商誉Amortization goodwill 摊销 EMA 委托经营管理协议 Amortization EMA Entrusted manageme 摊销 其他无形资产 商标等 Amortization Other intengible assets bra 摊销 特许经营权Amortization franchising rights 租赁费 场地租赁费rental venue 58 58 租赁费 设备租赁费rental equipment 租赁费 员工房租rental employee house rent 3 3 安全设施费 安全设施费Safety facilities fee safety facilities 11 11 安全设施费 其他配件及其他检测费Safety facilities fee other test fee 0 0 安全设施费 罐体检测费Safety facilities fee tank test fee 6 6 安全设施费 压力管线检测费Safety facilities fee pressure pipe 安全设施费 防雷检测费Safety facilities fee lightning prote 1 1 安全设施费 电子称及台秤检测费Safety facilities 1 1 安全设施费 浓度报警器检测费Safety facilities fee concentrati 1 1 安全设施费 安全阀检测费Safety facilities fee safety valve test 1 1 安全设施费 加气枪检测费Safety facilities fee gas gun test fee 上缴政府费用 治安联防费turned over to the government cost security 上缴政府费用 垃圾清运费turned over to the government cost garbage dispose 0 0 上缴政府费用 残疾人就业保障金turned over to the government cost obligation for 3 3 上缴政府费用 堤围费及其他turned over to the government cost dam fee and oth 6 6 董事会费the board of directors fee 执照检验费 工商营业执照license examination fees business license 执照检验费 组织机构代码证license examination fees organization certificate 执照检验费 商务许可license examination fees commercial permit 执照检验费 外汇年检license examination fees foreign exchange audit 执照检验费 劳动年检license examination fees labour inspection 执照检验费 税务登记证license examination fees tax certificate 执照检验费 危险品运输许可license examination fees transport permit 执照检验费 交通安全检查license examination fees traffic 执照检验费 消防检查license examination fees fire inspection 执照检验费 专业上岗证license examination fees professional work license 0 0 保险费 车辆 交通强制险insurance compulsory insurance for vehicle 1 1 保险费 车辆 车辆商业保险insurance commercial insurance for vehichle 3 3 保险费 车辆 承运人责任险insurance carrier liability 保险费 财产及其他 财产及其他资产险insurance property and other asset 保险费 财产及其他 产品责任险insurance product liability 1 1 保险费 财产及其他 雇员忠诚险insurance employee loyalty 保险费 财产及其他 现金险insurance cash on hand 保险费 财产及其他 雇主责任险和商业医疗insurance employers liability commercial medi 4 4 维修费 车辆检测费maintenance cost vehicle test fee 1 1 维修费 车辆日常维修费maintenance cost vehicle repare 12 12 维修费 新购轮胎maintenance cost new tire 1 1 维修费 修补轮胎maintenance cost tire patching 0 0 维修费 设备维修费maintenance cost equipment maintenance 8 7 维修费 其他维修费maintenance cost other 8 6 车辆运行费 油费Vehicle exp petrol 30 24 车辆运行费 路桥费及停车费等Vehicle exp toll and parking 6 5 车辆运行费 固定规费Vehicle exp regular charge 2 1 瓶车运费Cylinder truck transportation 槽车运费Tank truck transportation 物料消耗 material consumption 物料消耗 material consumption 10 10 物料消耗 material consumption 0 0 物料消耗 material consumption 物料消耗 其他material consumption others 5 5 水费water fee 1 1 电费electric charge 6 6 装修费decoration 3 3 差旅费 餐饮费travel expense meal 3 3 差旅费 住宿费travel expense accommodation 5 5 差旅费 会务费travel expense conference 1 1 差旅费 机票travel expense plane 2 2 差旅费 车船票travel expense train ship 6 6 差旅费 国外差旅费travel expense foreign travel 差旅费 外籍国外差旅费travel expense foreigner foreign travel 其他员工福利 伤病报销other staff welfare expense account 0 0 其他员工福利 年度体检费other staff welfare health checkup 其他员工福利 员工活动及福利other staff welfare staff activities 55 20 其他员工福利 节假日物品other staff welfare holiday gifts 1 1 其他员工福利 公司提供或划拨的工会经费other staff welfare other 0 其他员工福利 救济金 抚恤金 慰问金other staff welfare salvation 1 1 其他员工福利 公司食堂开支other staff welfare company cafeteria 8 8 办公费用 文具用品office expenses stationery 1 1 办公费用 纸张office expenses paper 2 2 办公费用 快递费office expenses express fee 0 0 办公费用 饮用水office expenses purefied water 0 0 办公费用 IT小配件office expenses small parts for IT 0 0 办公费用 硒鼓及墨盒office expenses toner cartridges 0 0 办公费用 其他office expenses ink cartridge 0 0 办公费用 办公家具office expenses office furniture 1 1 接待费用entertainment fee 35 83 通讯费 固定电话费correspondence fee telephone 2 2 通讯费 移动电话费correspondence fee mobile fee 4 4 通讯费 网络费用correspondence fee network charge 2 2 IT费用 网络维护费等 IT cost network maintenance 0 0 培训费 上岗证training expense work permit 5 5 培训费 其他培训training expense other training 2 2 工会费labour union expense 8 8 外籍员工费用Expat expense 市场推广费 媒体广告费advertising fee Media advertisement fee 10 10 市场推广费 促销活动advertising fee sales promotion 43 43 市场推广费 销售物料设计制作费advertising fee design 市场推广费 市场研究费用advertising fee market research expenses 2 2 书刊费books fee 1 1 印刷费printing expenses 0 0 招聘费recruiting cost 专业费用 总部服务费professional fees Headquarters service 专业费用 审计费professional fees audit fee 10 10 专业费用 诉讼费professional fees legal cost 专业费用 信用调查professional fees credit inquiry 专业费用 市场调查professional fees market research 2 2 专业费用 商会会费professional fees fee for chamber of commerce 3 3 专业费用 咨询服务professional fees consulting and other service 7 7 专业费用 评估费professional fees valuation fee 专业费用 信息服务professional fees information service 押钞费Security escort fee 软件服务费 财务软件software service charge financial softwar 软件服务费 电话中心软件software service charge call center sof 软件服务费 ERP软件software service charge ERP software 软件服务费 BI软件software service charge BI software 钢瓶检验费cylinder retest 劳保用品labour protection appliance 5 5 税金 印花税taxes stamp tax 2 1 税金 房产税taxes housing property tax 2 2 税金 车船使用税taxes vehicle and vessel usage tax 0 0 税金 土地使用税taxes land use charge 2 2 税金 代扣代缴税金taxes withholding tax 2 2 税费 教育费附加education surcharge 0 0 税费 城建税urban construction tax 0 0 税费 营业税business tax 3 2 坏帐损失bad debts 资产减值准备impairment of assets 报关费用customs clearance fee 其其他他others 各种费用收回 负数表示 cost redemptory negative 临时劳务费 保安公司服务费temporary service fees security 临时劳务费 临时人员费用temporary service labor 临时劳务费 外包终端客户维修费temporary service external service to customers 临时劳务费 管道燃气代扣手续费temporary service pipeline gas IC card 临时劳务费 其他外包人员temporary service outsourcing other 临时劳务费 外包配送人员temporary service delivery 业务外包费business outsourcing 外包配送运费delivery fee 充装服务费gas filling fee PeriodicPeriodicPeriodicPeriodicPeriodicPeriodicPeriodicPeriodic 2016 032016 042016 052016 062016 072016 082016 092016 10 1 1401 0899939089419909841 072 5654494547494953 441421384352364383381415 643614560512531558555604 1 1401 0899939089419909841 072 5 6975 4404 9624 5394 7044 9494 9175 355 279266243222230242240262 2 3292 2232 0281 8551 9222 0232 0102 188 3 0902 9512 6912 4622 5512 6842 6672 904 5 6975 4404 9624 5394 7044 9494 9175 355 4 219 4 028 3 674 3 361 3 483 3 665 3 641 3 965 209 199 182 166 172 181 180 196 1 633 1 559 1 422 1 301 1 348 1 418 1 409 1 534 2 378 2 270 2 071 1 894 1 963 2 065 2 052 2 235 4 219 4 028 3 674 3 361 3 483 3 665 3 641 3 965 1 4781 4121 2881 1781 2211 2841 2761 390 7067615658616066 696664606554575604601654 713680621568588619615670 1 4781 4121 2881 1781 2211 2841 2761 390 1 2971 2971 2971 2971 2971 2971 2971 297 1 2401 2401 2401 2401 2401 2401 2401 240 1 5771 5771 5771 5771 5771 5771 5771 577 1 1091 1091 1091 1091 1091 1091 1091 109 1 2971 2971 2971 2971 2971 2971 2971 297 1 4781 4121 2881 1781 2211 2841 2761 390 1313131313131313 55555555 1818181818181818 1 4971 4301 3061 1961 2391 3031 2941 408 492 498 496 495 494 495 501 516 61 61 61 61 61 61 61 61 380 359 351 351 394 381 364 424 933 919 909 907 949 937 927 1 001 564511397289290365367407 00000000 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 563511397288289365367406 152 138 107 78 78 99 99 110 152 138 107 78 78 99 99 110 411373289211211266268296 411373289211211266268296 27 0 27 0 27 0 27 0 27 0 27 0 27 0 27 0 564511397289290365367407 411373289211211266268296 0 2016 032016 042016 052016 062016 072016 082016 092016 10 492 498 496 495 494 495 501 516 61 61 61 61 61 61 61 61 380 359 351 351 394 381 364 424 492 498 496 495 494 495 501 516 262 262 262 262 262 262 262 262 46 45 44 42 43 44 44 45 42 48 48 48 42 42 48 62 70 70 70 70 70 70 70 70 73 73 73 73 78 78 78 78 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 61 380 359 351 351 394 381 364 424 62 62 62 62 62 62 62 62 45 44 41 39 39 41 41 43 6 6 6 6 6 6 6 6 7 7 6 5 6 6 6 6 43 31 27 20 22 22 24 82 21 21 21 21 21 21 21 21 17 17 17 17 17 17 17 17 16 9 9 20 59 44 26 24 55 55 55 55 55 55 55 55 109 108 108 107 107 108 107 108 262 262 262 262 262 262 262 262 11 11 11 11 11 11 11 11 16 15 14 12 13 14 14 15 3 3 3 3 3 3 3 3 42 48 48 48 42 42 48 62 17 17 17 17 17 17 17 17 70 70 70 70 70 70 70 70 59 59 59 59 63 63 63 63 15 15 15 15 16 16 16 16 31 31 31 31 31 31 31 31 18 18 18 18 18 18 18 18 7 7 7 7 7 7 7 7 0 0 0 0 0 0 0 0 5 5 5 5 5 5 5 5 58 58 58 58 58 58 58 58 3 3 3 3 3 3 3 3 11 11 11 11 11 11 11 11 0 0 0 0 0 0 0 0 6 6 6 6 6 6 6 6 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 3 3 3 3 3 3 3 3 6 6 6 6 6 6 6 6 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 3 3 3 3 3 3 3 3 1 1 1 1 1 1 1 1 4 4 4 4 4 4 4 4 1 1 1 1 1 1 1 1 12 12 12 12 12 12 12 12 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 7 7 6 5 6 6 6 6 6 6 6 5 5 6 6 6 24 23 21 19 20 21 21 23 5 5 4 4 4 4 4 5 1 1 1 1 1 1 1 1 10 10 10 10 10 10 10 10 0 0 0 0 0 0 0 0 5 5 5 5 5 5 5 5 1 1 1 1 1 1 1 1 6 6 6 6 6 6 6 6 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 5 5 5 5 5 5 5 5 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 6 6 6 6 6 6 6 6 0 0 0 0 0 0 0 0 15 6 11 35 35 17 14 1 1 1 1 1 1 1 1 0 0 0 0 0 0 1 1 1 1 1 1 1 1 8 8 8 8 8 8 8 8 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 43 31 27 20 22 22 24 82 2 2 2 2 2 2 2 2 4 4 4 4 4 4 4 4 2 2 2 2 2 2 2 2 0 0 0 0 0 0 0 0 5 5 5 5 5 5 5 5 2 2 2 2 2 2 2 2 8 8 8 8 8 8 8 8 10 10 10 10 10 10 10 10 43 43 43 43 43 43 43 43 2 2 2 2 2 2 2 2 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 10 10 10 10 10 10 10 10 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 7 7 7 7 7 7 7 7 5 5 5 5 5 5 5 5 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 0 0 0 0 0 0 0 0 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 2 2 2 2 2 2 2 Pe