当前位置:
文档之家› EXCEL图表制作(内部培训用)
EXCEL图表制作(内部培训用)
2.53% 2.17% 2.57% 5.12% 2.08% 2.71% 2.41% 2.51% 3.22% 1.91% 2.86% 2.97% 2.00% 3.33% 3.10% 3.00% 3.27% 3.15% 2.24% 3.39% 3.16% 3.25% 4.50%
2.89% 2.22% 3.65% 1.68% 2.73% 3.18% 2.67% 2.63% 3.45% 1.89% 2.81% 2.33% 2.46% 3.39% 3.13% 3.72% 3.22% 4.50% 3.31% 2.59% 2.90% 3.57% 2.70%
务费
金
固定费用
差
费用
用
0.40%
0.40%
3.45%
2.32%
1.87%
0.22%
0.37%
-0.15%
0.57%
0.56%
1.57%
2.30%
3.11%
3.36%
0.63%
2.73%
0.28%
0.13%
1.87%
1.87%
3.53%
2.67%
0.00%
2.67%
0.25%
0.54%
1.62%
2.26%
0.88% 4.91% 0.55% 0.92% 3.25% 1.91% 0.23% 4.29% 5.62% 1.25% 0.85% 3.30% -0.12% 2.70% 1.11% 3.87% 1.10% -1.65% 4.64% -0.13% 6.31% 1.69% 2.30%
0.54% 0.90% 0.32% 0.92% 0.19% 0.00% 0.00% 3.64% 3.18% 2.18% 1.26% 3.30% 0.01% 2.31% 1.09% 1.49% 0.98% 0.03% 4.69% 0.49% 1.59% 0.00% 0.33%
-1.12%
-0.24%
-0.39%
2.38% 1.47% 4.20% 1.85% -5.17% 0.00% -5.74% 5.29% 6.46% -6.52% 3.74% -0.34% 15.74% 0.20% 0.00% 0.00% 0.00% 1.14% 0.00% 0.52% 0.94% 0.89% 0.00%
4月分公司费 4月售后服务 4月储运费 4月销售佣金 4月经营部固 4月推广费 4月调价补差 4月倒开票费
用
费
定费用
用
0.55%
0.33%
0.28%
1.47%
2.46%
3.26%
1.74%
0.02%
0.67%
0.06%
0.39%
1.91%
1.99%
3.67%
2.90%
1.43%
0.43%
0.15%
0.38%
0.% 0.60% 0.60% 0.60% 0.60% 0.60% 0.60% 0.60% 0.60% 0.60% 0.60% 0.60% 0.60% 0.60% 0.60% 0.60% 0.60% 0.60% 0.60%
0.40% 0.40%
0.40% 0.40% 0.40% 0.40% 0.40% 0.40% 0.40% 0.40% 0.40% 0.40% 0.40% 0.40% 0.40% 0.40% 0.40% 0.40% 0.40% 0.40% 0.40% 0.40% 0.40%
1.72% 1.31% 1.07% 0.89% 1.56% 1.52% 2.78% 2.06% 1.53% 1.97% 2.07% 2.14% 1.70% 1.88% 2.20% 1.95% 1.38% 1.43% 1.59% 2.74% 2.32% 2.34% 1.25%
2.64% 1.75% 1.59% 2.44% 2.35% 9.78% 2.62% 2.30% 2.69% 2.09% 2.22% 2.79% 2.84% 1.76% 2.36% 1.63% 2.07% 2.67% 3.22% 2.87% 1.81% 1.66% 2.12%
分公司费用
售后服务费 储运费 销售佣金
经营部固定 费用
推广费
调价补差
倒开票费用 票折费用
分公司
新疆 南昌 郑州
1-4月分公司 费用 0.81%
0.74%
0.78%
重庆
0.50%
西安
0.70%
合肥
0.85%
昆明 福州
长沙 长春 贵阳 石家庄 南宁 成都 太原 沈阳 南京 呼市 惠州 广州 杭州 济南 武汉 天津 上海 深圳 哈尔滨 兰州 北京
1.58%
1.79%
2.48%
3.11%
0.00%
南昌
0.67%
0.68%
0.39%
2.68%
2.92%
4.34%
-0.63%
0.49%
长沙
0.82%
0.35%
0.16%
1.52%
1.77%
4.14%
0.19%
0.43%
惠州
1.02%
0.37%
0.16%
1.25%
1.56%
2.73%
-0.37%
0.02%
3.98% 2.82% 3.95% 5.01% 4.88% 2.34% 3.20% 2.68% 5.45% 2.86% 3.18% 5.66% 2.74% 2.69% 3.00% 4.47% 2.75% 3.76% 1.06% 5.71% 4.32% 3.26% 2.71%
2.59% 1.62% 4.20% 2.11% -5.02% 1.40% -3.22% 5.29% 8.43% -6.52% 3.74% 1.38% 19.76% 0.66% 0.00% 1.22% 0.00% 1.28% 6.27% 4.34% 2.94% 1.92% 0.00%
0.22% 0.14% 0.00% 0.26% 0.15% 1.40% 2.52% 0.00% 1.97% 0.00% 0.00% 1.72% 4.02% 0.46% 0.00% 1.22% 0.00% 0.14% 6.27% 3.82% 2.00% 1.04% 0.00%
4月票折费用
1.72% 1.47% 3.11%
管理利润 管理利润
率
率排名
KPI排名
销售收入 (万元)
费用率
费用率排 名
管理利润
管理利润 KPI排名
费用率
费用率排
销售收入(万 元)
分公司费用
标准:
1.00%
1.00%
售后服务费
标准 :
0.60%
0.60%
储运费标准 :0.40%
0.40%
销售佣金标 准:2.00%
2.00%
1.00% 0.60% 0.40% 2.00%
1.02% 0.78% 0.77% 0.74% 0.70% 0.82% 0.51% 0.81% 1.06% 0.78% 0.78% 0.97% 0.31% 0.81% 0.95% 1.09% 1.01% 0.99% 0.71% 1.83% 1.01% 0.85% 0.88%
1-4月售后服 1-4月储运费 1-4月销售佣 1-4月经营部 1-4月推广费 1-4月调价补 1-4月倒开票 1-4月票折费
0.24% 0.43% 0.40% 0.23% 0.50% 0.44% 0.70% 0.34% 0.56% 0.35% 0.67% 0.83% 0.37% 0.46% 0.59% 0.25% 0.62% 0.96% 0.37% 0.62% 0.74% 0.49% 0.35%
1.94% 2.41% 1.61% 2.01% 1.69% 2.20% 2.80% 2.26% 2.25% 2.75% 2.51% 1.94% 1.91% 2.86% 2.24% 2.18% 2.55% 1.81% 4.02% 2.85% 2.43% 1.61% 2.34%
1.00% 0.60% 0.40% 2.00%
1.00% 0.60% 0.40% 2.00%
1.00% 0.60% 0.40% 2.00%
1.00% 0.60% 0.40% 2.00%
1.00% 1.00%
1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00%
2.00% 2.00%
2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00%
经营部固定 费用标准:
2.50%
实际费用率与标准费用率偏差动态图
筛选区:
注:用于检测费 用标准合理性。
6.0%
1-4月经营部固定费用
经营部固定费用标准:
5.0%
4.0%
3.0%
2.0%
1.0%
0.0%
新南郑重西合昆福长长贵石南成太沈南呼惠广杭济武 疆昌州庆安肥明州沙春阳家宁都原阳京市州州州南汉
庄
定费用标准: 2.50% 武天上深哈兰北 汉津海圳尔州京 滨
2.37%
1.85%
0.00%
1.85%
0.27%
0.22%
1.64%
2.25%
2.58%
2.75%
0.56%
2.19%
0.50%
0.24%
1.96%
2.59%
2.93%
2.92%
0.23%