您好,欢迎访问三七文档
当前位置:首页 > 商业/管理/HR > 经营企划 > 01-【日常费用管理】-05-ABC分类费用数据透视表
公司名称单位:元行标签求和项:占可控费用的比例求和项:项目累计百分比A类费用68.28%4.44%办公费9.22%0.48%差旅费7.05%0.79%车辆费用7.89%0.64%低值易耗品摊销6.09%0.95%会议费5.43%1.11%业务招待费18.11%0.16%支付物流费14.49%0.32%B类费用22.09%10.00%包装费4.14%1.59%水电费2.10%2.06%销售管理和打假经费2.59%1.91%修理费(除车辆修理)3.81%1.75%宣传费4.30%1.43%运输费用5.14%1.27%C类费用9.63%85.56%总计100.00%100.00%ABC分类费用数据透视表费用监控的类型费用监控的重点类型行次项目名称项目百分比项目累计百分比可控A类费用1业务招待费2.86%2.86%可控A类费用2支付物流费2.85%5.71%可控A类费用3办公费2.86%8.57%可控A类费用4车辆费用2.86%11.43%可控A类费用5差旅费2.86%14.29%可控A类费用6低值易耗品摊销2.85%17.14%可控A类费用7会议费2.86%20.00%可控B类费用8运输费用2.86%22.86%可控B类费用9宣传费2.85%25.71%可控B类费用10包装费2.86%28.57%可控B类费用11修理费(除车辆修理)2.86%31.43%可控B类费用12销售管理和打假经费2.86%34.29%可控B类费用13水电费2.85%37.14%可控C类费用14技术开发费2.86%40.00%可控C类费用15其他2.86%42.86%可控C类费用16审计费2.85%45.71%可控C类费用17咨询费2.86%48.57%可控C类费用18租赁费2.86%51.43%可控C类费用19其他2.86%54.29%可控C类费用20保险费(除车辆保险)2.85%57.14%可控C类费用21涉外费2.86%60.00%可控C类费用22软件服务费2.86%62.86%可控C类费用23消防警卫费2.85%65.71%可控C类费用24绿化费2.86%68.57%可控C类费用25检验费2.86%71.43%可控C类费用26标识费2.86%74.29%可控C类费用27物业管理费2.85%77.14%可控C类费用28保管费2.86%80.00%可控C类费用29排污费2.86%82.86%可控C类费用30整理费2.85%85.71%可控C类费用31仓储费用2.86%88.57%可控C类费用32广告费2.86%91.43%可控C类费用33土地使用费2.86%94.29%可控C类费用34库存商品盘亏2.85%97.14%可控C类费用35库存商品盘亏2.86%100.00%商品流通费用明细表项目名称及累计百分比本年累计金额占可控费用的比例金额累计百分比2.86%业务招待费196118.11%18.11%5.71%支付物流费156914.49%32.59%8.57%办公费9999.22%41.82%11.43%车辆费用8557.89%49.71%14.29%差旅费7637.05%56.76%17.14%低值易耗品摊销6606.09%62.85%20.00%会议费5885.43%68.28%22.86%运输费用5575.14%73.43%25.71%宣传费4664.30%77.73%28.57%包装费4484.14%81.87%31.43%修理费(除车辆修理)4133.81%85.68%34.29%销售管理和打假经费2812.59%88.27%37.14%水电费2272.10%90.37%40.00%技术开发费1251.15%91.52%42.86%其他1211.12%92.64%45.71%审计费1161.07%93.71%48.57%咨询费930.86%94.57%51.43%租赁费920.85%95.42%54.29%其他750.69%96.11%57.14%保险费(除车辆保险)670.62%96.73%60.00%涉外费620.57%97.30%62.86%软件服务费550.51%97.81%65.71%消防警卫费520.48%98.29%68.57%绿化费400.37%98.66%71.43%检验费390.36%99.02%74.29%标识费360.33%99.35%77.14%物业管理费250.23%99.58%80.00%保管费230.21%99.80%82.86%排污费220.20%100.00%85.71%整理费00.00%100.00%88.57%仓储费用00.00%100.00%91.43%广告费00.00%100.00%94.29%土地使用费00.00%100.00%97.14%库存商品盘亏00.00%100.00%100.00%库存商品盘亏00.00%100.00%商品流通费用明细表
本文标题:01-【日常费用管理】-05-ABC分类费用数据透视表
链接地址:https://www.777doc.com/doc-12855797 .html