監(jiān)測業(yè)務(wù)業(yè)績

營銷實戰(zhàn)工具——銷售業(yè)務(wù)管理,,,,,,,,,,

銷售額業(yè)績達標動態(tài)監(jiān)測分析工具（任一月度所有產(chǎn)品編號）,,,,,,,,,,

說明：本工具主要用于靈活、動態(tài)監(jiān)測任一月度所有產(chǎn)品（編號）銷售額的銷售業(yè)績達標情況。具體分析數(shù)據(jù)包括所有產(chǎn)品（編號）及公司整體的該月度業(yè)績達成情況、截止月底累計業(yè)績達成情況、截止月底年度業(yè)績目標達成情況。此表查詢結(jié)果及分析數(shù)據(jù)根據(jù)銷售數(shù)據(jù)明細表自動生成。使用方法：先在銷售數(shù)據(jù)明細表、銷售業(yè)績目標設(shè)定表填入相關(guān)數(shù)據(jù)及信息，然后在本表中填入月份（直接修改日期的月份數(shù)字即可，格式保持不變）、產(chǎn)品編號（與明細表一致）即可，其他數(shù)據(jù)為自動生成。（注：本分析表格若行數(shù)不夠，請選中帶公式的單元格下拉拖動復制即可。）,,,,,,,,,,

,,,,,,,,,,,

,,,,,,,,,,,

月份,2017年10月,,月度,銷售額,"￥242,550.00",,占公司年度/目前銷售總額比例,,29.53%,

,,,,,,,,,,,

,,,,,,,,,,,

產(chǎn)品編號,當月目標業(yè)績額,當月實際銷售額,占比,當月業(yè)績目標達成率,截止月底目標業(yè)績額,截止月底累計銷售額,占比,截至月底累計目標業(yè)績達成率,年度業(yè)績目標,截止月底年度業(yè)績目標達成率

公司整體,"￥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!

,￥