任一產(chǎn)品（編號）每月銷售額業(yè)績達(dá)成分析（三張表）1

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

任一產(chǎn)品（編號）年度每月銷售額業(yè)績達(dá)成分析（含每月比較分析，自動獲取數(shù)據(jù)）,,,,,,,,,,,,,

說明：本工具主要用于系統(tǒng)分析任一產(chǎn)品（編號）全年每月銷售額業(yè)績達(dá)成情況，其中包括各月度對比分析、年度業(yè)績總體分析、各月度環(huán)比增長分析。此分析表根據(jù)銷售數(shù)據(jù)明細(xì)表自動生成。使用方法：先在銷售數(shù)據(jù)明細(xì)表、銷售業(yè)績目標(biāo)設(shè)定表填入相關(guān)數(shù)據(jù)及信息，然后在本表中通過下拉菜單輸入產(chǎn)品編號（要求與明細(xì)表一致）即可，其他數(shù)據(jù)及圖表為自動生成。,,,,,,,,,,,,,

產(chǎn)品編號,201603008,,產(chǎn)品類別,類別2,產(chǎn)品名稱,產(chǎn)品名稱4,,規(guī)格型號,LLL,單位,個,,

銷售額,"￥129,500.00",,目標(biāo)銷售額,"￥150,084.00",,年度達(dá)成率,86.29%,占總額比例,11.03%,月均增長率,-15.67%,,

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

項目,1月,2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,年度合計

目標(biāo)銷售額,"￥10,007.00","￥10,007.00","￥20,007.00","￥10,007.00","￥10,007.00","￥10,007.00","￥20,007.00","￥10,007.00","￥10,007.00","￥20,007.00","￥10,007.00","￥10,007.00","￥150,084.00"

實際銷售額,"￥8,800.00",￥0.00,"￥12,000.00","￥12,000.00",￥0.00,"￥65,600.00",￥0.00,"￥28,400.00",￥0.00,￥0.00,"￥1,350.00","￥1,350.00","￥129,500.00"

達(dá)成率,87.94%,0.00%,59.98%,119.92%,0.00%,655.54%,0.00%,283.80%,0.00%,0.00%,13.49%,13.49%,86.29%

占該時間段公司銷售總額比例,8.92%,0.00%,16.39%,13.99%,0.00%,12.17%,0.00%,44.10%,0.00%,0.00%,5.29%,15.08%,11.03%

占該產(chǎn)品年度銷售總額比例,6.80%,0.00%,9.27%,9.27%,0.00%,50.66%,0.00%,21.93%,0.00%,0.00%,1.04%,1.04%,100.00%

環(huán)比增長率,,-100.00%,#DIV/0!,0.00%,-100.00%,#DIV/0!,-100.00%,#DIV/0!,-100.00%,#DIV/0!,#DIV/0!,0.00%,

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

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

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

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

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

,,,,,,,,,,