前三季度每月各产品（编号）销售数量业绩达成分析1

营销实战工具——销售业务管理,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

前三季度每月各产品（编号）销售数量业绩达成分析（含各月、总体分析，自动获取数据）,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

说明：本工具主要用于系统分析前三季度各产品（编号）各月度以及累计销售数量业绩达成情况，其中包括各月度业绩对比分析、产品之间业绩对比分析以及前三季度业绩总体分析。此分析表根据销售数据明细表自动生成。使用方法：先在销售数据明细表、销售业绩目标设定表填入相关数据及信息，然后在本表中输入产品编号（要求与明细表一致）即可，其他数据及图表为自动生成。（注：名称列的空格为预留单元格，目前可设置15个产品，空格对应的数据单元格都已经设置好了自动计算函数公式，请不要随意删除，如果本分析表格的行数不够，建议从8-22行之间插入行（确保分析图数据范围有效），再设置函数公式，即选中带公式的单元格下拉拖动复制即可。）,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

产品编号,1月,,,2月,,,3月,,,4月,,,5月,,,6月,,,7月,,,8月,,,9月,,,前三季度合计,,,,,,

,销量,目标销量,1月业绩达成率,销量,目标销量,2月业绩达成率,销量,目标销量,3月业绩达成率,销量,目标销量,4月业绩达成率,销量,目标销量,5月业绩达成率,销量,目标销量,6月业绩达成率,销量,目标销量,7月业绩达成率,销量,目标销量,8月业绩达成率,销量,目标销量,9月业绩达成率,前3季度累计销售数量,前3季度目标销售数量,年度业绩目标销售数量,前3季度累计达成率,年度业绩达成率,占比,排名

公司整体,1950,2466,79.08%,430,2466,17.44%,1740,4866,35.76%,1640,2466,66.50%,960,2466,38.93%,3840,2466,155.72%,540,4866,11.10%,1340,2466,54.34%,3360,2466,136.25%,15800,26994,36792,58.53%,42.94%,100.00%,

201603001,30,200,15.00%,0,200,0.00%,0,400,0.00%,0,200,0.00%,0,200,0.00%,290,200,145.00%,0,400,0.00%,0,200,0.00%,400,200,200.00%,720,2200,3000,32.73%,24.00%,4.56%,11

201603002,0,201,0.00%,0,201,0.00%,80,401,19.95%,0,201,0.00%,0,201,0.00%,0,201,0.00%,0,401,0.00%,0,201,0.00%,0,201,0.00%,80,2209,3012,3.62%,2.66%,0.51%,12

201603003,800,202,396.04%,0,202,0.00%,0,402,0.00%,0,202,0.00%,90,202,44.55%,0,202,0.00%,0,402,0.00%,0,202,0.00%,1300,202,643.56%,2190,2218,3024,98.74%,72.42%,13.86%,2

201603004,0,203,0.00%,0,203,0.00%,0,403,0.00%,260,203,128.08%,0,203,0.00%,800,203,394.09%,0,403,0.00%,0,203,0.00%,0,203,0.00%,1060,2227,3036,47.60%,34.91%,6.71%,8

201603005,200,204,98.04%,0,204,0.00%,0,404,0.00%,280,204,137.25%,0,204,0.00%,320,204,156.86%,0,404,0.00%,0,204,0.00%,0,204,0.00%,800,2236,3048,35.78%,26.25%,5.06%,9

201603006,220,205,107.32%,0,205,0.00%,100,405,24.69%,300,205,146.34%,190,205,92.68%,0,205,0.00%,480,405,118.52%,0,205,0.00%,0,205,0.00%,1290,2245,3060,57.46%,42.16%,8.16%,6

201603007,540,206,262.14%,0,206,0.00%,120,406,29.56%,560,206,271.84%,220,206,106.80%,0,206,0.00%,60,406,14.78%,300,206,145.63%,0,206,0.00%,1800,2254,3072,79.86%,58.59%,11.39%,4

201603008,160,207,77.29%,0,207,0.00%,240,407,58.97%,200,207,96.62%,0,207,0.00%,1120,207,541.06%,0,407,0.00%,500,207,241.55%,0,207,0.00%,2220,2263,3084,98.10%,71.98%,14.05%,1

201603009,0,208,0.00%,180,208,86.54%,120,408,29.41%,40,208,19.23%,220,208,105.77%,0,208,0.00%,0,408,0.00%,540,208,259.62%,0,208,0.00%,1100,2272,3096,48.42%,35.53%,6.96%,7

201603010,0,209,0.00%,200,209,95.69%,180,409,44.01%,0,209,0.00%,160,209,76.56%,540,209,258.37%,0,409,0.00%,0,209,0.00%,660,209,315.79%,1740,2281,3108,76.28%,55.98%,11.01%,5

201603011,0,210,0.00%,50,210,23.81%,420,410,102.44%,0,210,0.00%,80,210,38.10%,470,210,223.81%,0,410,0.00%,0,210,0.00%,1000,210,476.19%,2020,2290,3120,88.21%,64.74%,12.78%,3

201603012,0,211,0.00%,0,211,0.00%,480,411,116.79%,0,211,0.00%,0,211,0.00%,300,211,142.18%,0,411,0.00%,0,211,0.00%,0,211,0.00%,780,2299,3132,33.93%,24.90%,4.94%,10

,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,0,#DIV/0!,#DIV/0!,0.00%,

,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,0,#DIV/0!,#DIV/0!,0.00%,

,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,#DIV/0!,0,0,0,#DIV/0!,#DIV/0!,0.00%,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,