（专业财务模板）ABC分类费用数据透视表.xlsx

《（专业财务模板）ABC分类费用数据透视表.xlsx》由会员分享，可在线阅读，更多相关《（专业财务模板）ABC分类费用数据透视表.xlsx（3页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、ABCABC分分类类费费用用数数据据透透视视表表公司名称华云信息有限公司单位：元行行标标签签求求和和项项:占占可可控控费费用用的的比比例例求求和和项项:项项目目累累计计百百分分比比A A类类费费用用68.28%68.28%4.44%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 B类类费费用用22.09%22.09%10.00%10.00%包装费4.14%1.59%水电费2.10%2.06%销售管理和打假经费2.59%1.91

2、%修理费（除车辆修理）3.81%1.75%宣传费4.30%1.43%运输费用5.14%1.27%C C类类费费用用9.63%9.63%85.56%85.56%总总计计100.00%100.00%100.00%100.00%商品流通费用明细表费用监控的类型费用监控的重点类型行次项目名称项目百分比项目累计百分比可控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

3、%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 保险费（除车

4、辆保险）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

5、.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

6、.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

7、%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%商品流通费用明细表