监测业务业绩

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

销售额业绩达标动态监测分析工具（任一月度所有产品编号）,,,,,,,,,,

说明：本工具主要用于灵活、动态监测任一月度所有产品（编号）销售额的销售业绩达标情况。具体分析数据包括所有产品（编号）及公司整体的该月度业绩达成情况、截止月底累计业绩达成情况、截止月底年度业绩目标达成情况。此表查询结果及分析数据根据销售数据明细表自动生成。使用方法：先在销售数据明细表、销售业绩目标设定表填入相关数据及信息，然后在本表中填入月份（直接修改日期的月份数字即可，格式保持不变）、产品编号（与明细表一致）即可，其他数据为自动生成。（注：本分析表格若行数不够，请选中带公式的单元格下拉拖动复制即可。）,,,,,,,,,,

,,,,,,,,,,,

,,,,,,,,,,,

月份,2017年10月,,月度,销售额,"￥242,550.00",,占公司年度/目前销售总额比例,,29.53%,

,,,,,,,,,,,

,,,,,,,,,,,

产品编号,当月目标业绩额,当月实际销售额,占比,当月业绩目标达成率,截止月底目标业绩额,截止月底累计销售额,占比,截至月底累计目标业绩达成率,年度业绩目标,截止月底年度业绩目标达成率

公司整体,"￥240,066.00","￥242,550.00",100.00%,101.03%,"￥1,560,660.00","￥812,550.00",100.00%,52.06%,"￥1,800,792.00",45.12%

201603001,"￥20,000.00","￥12,000.00",4.95%,60.00%,"￥130,000.00","￥37,100.00",4.57%,28.54%,"￥150,000.00",24.73%

201603002,"￥20,001.00",￥0.00,0.00%,0.00%,"￥130,010.00","￥2,800.00",0.34%,2.15%,"￥150,012.00",1.87%

201603003,"￥20,002.00","￥91,000.00",37.52%,454.95%,"￥130,020.00","￥134,600.00",16.57%,103.52%,"￥150,024.00",89.72%

201603004,"￥20,003.00",￥0.00,0.00%,0.00%,"￥130,030.00","￥20,400.00",2.51%,15.69%,"￥150,036.00",13.60%

201603005,"￥20,004.00","￥28,000.00",11.54%,139.97%,"￥130,040.00","￥75,200.00",9.25%,57.83%,"￥150,048.00",50.12%

201603006,"￥20,005.00","￥17,500.00",7.22%,87.48%,"￥130,050.00","￥61,750.00",7.60%,47.48%,"￥150,060.00",41.15%

201603007,"￥20,006.00","￥10,000.00",4.12%,49.99%,"￥130,060.00","￥94,000.00",11.57%,72.27%,"￥150,072.00",62.64%

201603008,"￥20,007.00","￥1,350.00",0.56%,6.75%,"￥130,070.00","￥84,950.00",10.45%,65.31%,"￥150,084.00",56.60%

201603009,"￥20,008.00","￥40,000.00",16.49%,199.92%,"￥130,080.00","￥94,400.00",11.62%,72.57%,"￥150,096.00",62.89%

201603010,"￥20,009.00","￥2,700.00",1.11%,13.49%,"￥130,090.00","￥96,700.00",11.90%,74.33%,"￥150,108.00",64.42%

201603011,"￥20,010.00","￥40,000.00",16.49%,199.90%,"￥130,100.00","￥80,250.00",9.88%,61.68%,"￥150,120.00",53.46%

201603012,"￥20,011.00",￥0.00,0.00%,0.00%,"￥130,110.00","￥30,400.00",3.74%,23.36%,"￥150,132.00",20.25%

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

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

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

,￥