可口可樂-ka渠道銷售分析樣表

1、KA. Shipment monthly sales update(P.C.)-Period 2003-01Date:Period Jan.Entering time:2003/02/15LocationKey Account MonthYTDNCBCSDNamethis lastSSP(1.0L)Can355ml124Can355ml64this last%Chg2003Last% Chgthis last%Chgthis last%Chgthis last%Chgthis last%ChgXMXM沃爾瑪世貿(mào)32051165175%32051165175%692203360%3960100%

2、44523292%27022023%沃爾瑪SM33211442130%33211442130%43440985%6370100%359604-41%245115113%好又多富山4380660564%4380660564%700513900%800253100%520381268%1250120942%好又多定安14290100%14290100%1790100%3500100%1210100%1900100%閩客隆44381063317%44381063317%1052104912%1690100%52141027%380100%倍順2198593271%2198593271%8475813

3、60%11830293%39494319%000%麥當(dāng)勞169515807%169515807%000%000%320140129%000%廈門航空125984549%125984549%1200100%000%000%000%Total219257348198%219257348198%40242271673%2470554391%2680151877%1993455338%FZFZ麥德龍263610284-74%263610284-74%2750100%000%400115248%0600-100%山姆店1515010314609%1515010314609%110000100%40001

4、00%20000100%1000100%沃爾瑪利嘉4911657647%4911657647%484331367%5031567%652241171%445780%沃爾瑪長城2309697231%2309697231%3610-16%4300100%223247-10%15130403%好又多聯(lián)信2258175828%2258175828%22012083%40057900%18516115%3200100%好又多融僑32711340144%32711340144%3300100%10020400%10020400%6610100%好又多黎明6872848-76%6872848-76%4001

5、00%8115440%31343-91%100100%好又多東街13730100%13730100%1600100%4000100%3930100%1300100%好又多五里亭37880100%37880100%5540100%3000100%2620100%2800100%好又多永升城23400100%1600100%1600100%300100%400100%2790100%好又多廣場1420100%170100%170100%000%000%650100%好又多花開富貴26320100%26320100%5050100%1500100%3370100%2950100%永輝連鎖超市9814

6、1167741%98141167741%9110100%902811175%882387128%3700100%福興連鎖超市1570320391%1570320391%114366600%20136600%42286391%000%新華都19581195700%19581195700%1550100%2850100%1650100%200100%德克士2069104299%2069104299%000%000%000%000%Total5690820217181%5460320217170%152861897988%3729546806%60921600281%2725635329%QZQZ百

7、姓超市29148506%29148506%4610360%250100%000%000%奇龍超市141895548%141895548%600100%000%30630-95%000%百匯超市1224252386%1224252386%187111600%450100%22012182%4000100%好運(yùn)來超市508230121%508230121%13834306%600100%2579-68%000%富華超市76549255%76549255%185121442%800100%0281-100%000%安盛超市1906359431%1906359431%37039849%500100%2

8、001953%000%利民超市37825648%37825648%1250100%250100%20105-81%000%奎生超市44270531%44270531%302050%05-100%700100%000%威蘭超市1050322226%1050322226%240102300%255400%33080313%090-100%新華都27400100%27400100%4050100%1500100%3900100%800100%Total107222984259%107222984259460104500%12851491-14%48090433%ZZZZ薌客

9、隆超市1175100417%1175100417%17024608%500100%95590-84%000%吉馬超市2585217519%2585217519%3550100%1500100%1195450166%000%新華都11453097-63%11453097-63%180101700%400100%501768-97%200100%Total49056276-22%49056276-22%705341974%2400100%13402808-52%200100%全省9446036825157%9215536825150%218015863620%68991195697%1139774

10、1754%52181180342%注： （1）YTD年累計銷量（2）%Bud年累計銷量/全年預(yù)算銷量（3）Bud=全年預(yù)算銷量（4）Month=當(dāng)月銷量（5）%Chg=（當(dāng)月銷量去年同月銷量）/去年同月銷量500ml1151.25L1122L185GALthis last%Chgthis last%Chgthis last%Chgthis last%Chg31053485%312153104%78048760%000%18475145%310133133%1152475143%000%320251180%2400100%55044723%000%690100%2200100%3000100%0

11、00%103174-41%1557355339%994204870%40100%24652373%32929412%24752375%171331%000%000%000%13751440-5%000%113984535%000%000%1232379225%41071780131%40231481172%13961453-4%10100-90%18718619-78%80850-91%000%500100%12000100%400100300%03-100%887517%3023446770%570256123%000%41390%780192306%32318971%000%908013%

12、603655-8%440737-40%000%1100100%62036072%135094044%000%1080-88%2751260-78%2401150-79%000%300100%600100%2000100%000%1920100%10500100%11500100%000%90100%3220100%15000100%000%000%600100%000%000%2250100%5850100%5350100%000%84796%1644483240%50212102291%000%7212500%31118370%4500100%000%80100%300129900%1025

13、0100%000%000%8600100%000%1209104216%1019465119% 13564 1179715%132844432200%1209104516%000%40385%1800100%000%300100%100325-69%11980100%000%12338224%06-100%24976228%000%270100%1231175%1350100%000%4556-20%305143113%1500100%000%180100%529125323%7390100%000%000%65135-52%14316794%000%270100%22045389%95010

14、0%000%1020-50%1409252%305251120%000%1300100%5250100%10600100%000%410114260%20471026100%42541173536%000%600100%51039031%2900100%000%KA. Shipment monthly sales update(P.C.)-Period 2003-01CSD1059511%5001630-69%2800100%000%5182-38%124580-79%6806574%000%21617722%11342600-56%125065790%000%28771135153% 208

15、52 1720321%228116687241%260524984%KA. Shipment monthly sales update(P.C.)-Period 2003-01Date:Period Jan.Entering time:2003/02/15LocationKey Account MonthYTDNCBCSDNamethis lastSSP(1.0L)Can355ml124Can355ml64this last%Chg2003Last% Chgthis last%Chgthis last%Chgthis last%Chgthis last%ChgXMXM沃爾瑪世貿(mào)51005133

16、-1%8512629835%636222791%15230100%277842-67%4103886%沃爾瑪SM7742591231%11063735450%787651111%25650100%47941515%47032047%好又多富山8555341-84%52356001-13%110155-29%35021067%5198-97%301020-97%好又多定安13140100%22450100%2530100%000%480100%3650100%閩客隆6143435641%10581541995%2155281667%5840100%7651002-24%1290100%倍順119

17、71932-38%3395252534%650199227%604243%164455-64%000%麥當(dāng)勞2775248911%415039296%000%000%000%000%廈門航空17102027-16%316930125%100100%000%157222-29%000%Total2683627190-1%483503453840%4601722537%50822521917%18953134-40%14041728-19%FZFZ麥德龍76540659-98%340150943-93%3550100%000%101600-99%0660-100%山姆店148242575476%2

18、997426751021%10025100%13000100%15000100%300395-24%沃爾瑪利嘉151552532499%200663189529%55852279150% 1360719329%2012529280%191527%沃爾瑪長城80993845111%104084542129%5010-4%5200100%4559589674%1950100%好又多聯(lián)信20682358-12%432641165%23240480%749126142%85148-43%398201890%好又多融僑7901464-46%4061280445%14024483%20030567%050

19、0-100%4500100%好又多黎明10524338%7922872-72%310100%000%3014114%4010300%好又多東街5660100%19390100%1320100%20100%320100%1200100%好又多五里亭2080100%39960100%400100%1080100%200100%300100%好又多永升城9910100%33310100%1480100%3300100%130100%4930100%好又多廣場2930100%4350100%300100%500100%300100%400100%好又多花開富貴3270100%29590100%9201

20、00%1200100%100100%850100%永輝連鎖超市160063862314%258205029413%21450100%27620100%100957077%8700100%福興連鎖超市1868711163%34381031233%696173750%7723750%22117228%000%新華都18112039-11%3769204085%4300100%3050100%305425-28%1150100%德克士2401163946%4470268267%000%000%000%000%Total66277617087%1231858192350%205828324698%78

21、835115357%98364547116%31551100187%QZQZ百姓超市47042411%76147261%17529503%9024400%956742%000%奇龍超市135897839%2776193344%36336908%1800100%420146188%000%百匯超市10259409%2249119289%365162181%8524150%140242-42%300100%好運(yùn)來超市435513-15%94374327%21860263%000%8088-9%000%富華超市340871-61%11051363-19%19046313%000%30365-92%0

22、00%安盛超市16831744-3%3589210371%555491033%400172253%465685-32%000%利民超市88649978%126475667%2860100%800100%125152-18%000%奎生超市6325878%107465763%267141807%5014900%60115-48%000%威蘭超市100877031%2058109288%53075607%350100%65150-57%100100%新華都33140100%60540100%12370100%8500100%4170100%2590100%Total11151732652%2187

23、310311112%41863251188%1770227945%18972010-6%2990100%ZZZZ薌客隆超市3048152899%42234532-7%1055244296%3150100%728150385%400100%吉馬超市3300174090%5885391550%760601167%2900100%465770-40%400100%新華都26163495-25%37616592-43%250300-17%2300100%245855-71%300100%Total8964676333%1386915039-8%2065384438%8350100%14381775-1

24、9%1100100%全省113228 10298710%207277 14181146%3143415141976%155703254691%15066 1146631%4968282876%注： （1）YTD年累計銷量（2）%Bud年累計銷量/全年預(yù)算銷量（3）Bud=全年預(yù)算銷量（4）Month=當(dāng)月銷量（5）%Chg=（當(dāng)月銷量去年同月銷量）/去年同月銷量500ml1151.25L1122L185GALthis last%Chgthis last%Chgthis last%Chgthis last%Chg36187315%102524-81%17913270-45%000%2371001

25、37%240359-33%29644653-36%000%0128-100%360915-61%02715-100%000%300100%550100%5630100%000%30524127%8582832-70%13470100%000%99156-37%82756-89%136304-55%620-70%000%000%000%2775248911%000%15431805-15%000%000%103271245%32407191-55%680110942-38%2781250911%000%40036700-99%01699-100%000%1000100%3003000%12991

26、880-31%000%17514322%52163441416%7881492-47%000%1402210%150486873%6802167-69%000%453050%160478-67%3991630-76%000%050-100%0270-100%0590-100%000%40100%000%000%000%350100%650100%1800100%000%100100%000%000%000%70100%000%000%000%000%1080100%350100%000%000%000%200100%000%31269352%48492068134%40591155251%00

27、0%7235106%198318-38%604167262%000%97109-11%109815-87%450690-35%000%000%9310100%000%14701639-10%99765752%13840 42161-67%851411470-26%14701639-10%530-83%85296-71%200100%000%500100%345676-49%0120-100%000%7079-11%136208-35%199393-49%000%843-81%20239-92%1098331%000%050-100%0347-100%1206390%000%630100%509

28、13-95%1508088%000%000%155262-41%24085182%000%251567%15362-96%21580169%000%2075-73%29824024%50230-78%000%2100100%3410100%000%000%45129254%14453543-59%11031134-3%000%19570179%325884-63%390400-3%000%KA. Shipment monthly sales update(P.C.)-Period 2003-01CSD17020750%110089024%4750100%000%68180-62%7853401

29、31%10081820-45%000%43327060%221021145%18732220-16%000%2913193151%20735 55009-62%18291 25766-29%425141482%KA. Shipment monthly sales update(P.C.)-Period 2003-03Date:Period Mar.Entering time:2003/04/03LocationKey Account MonthYTDNCBCSDNamethis lastthis lastSSP(1.0L)Can355ml124Can355ml64this last%Chg20

30、03Last% Chgthis last%Chgthis last%Chgthis last%Chgthis last%ChgXMXM沃爾瑪世貿(mào)2924215336%11482845136%83748573%4274202%354172106%31080288%沃爾瑪SM3298246734926391137%310424-27%930334178%313150109%好又多富山8851332-34%7933632925%37329925%202288-30%70210-67%000%好又多定安7080100%30190100%3700100%650100%10010

31、0%1050100%麥德龍47640100%47650100%11640100%2000100%12450100%5600100%閩客隆612256468%168071180442%2636783237%5002328-79%119711742%89062%倍順21642787-22%576855674%12301509-18%187389-52%241449-46%000%麥當(dāng)勞21862550-14%000%000%000%000%000%廈門航空15212078-27%46905090-8%000%000%140216-35%000%Total245721901329%688354706

32、246%75363467117%18913849-51%4187255564%1377230499%FZFZ麥德龍392521754-82%732672697-900250-100%283960-99%01640-100%山姆店257183568621%556926243792%1338211501064%100470-79%73065001361%200450-56%沃爾瑪利嘉1976133548%220474524387%1317280370%7071-1%374445-16%660100%沃爾瑪長城1758772128%121665314129%81490226

33、%250104140%148228-35%22340458%好又多聯(lián)信7781585833%7781586833%105053198%1279122948%407599-32%883150489%好又多融僑560636-12%4621344034%33027620%6070-14%600100%1001000%好又多黎明49226586%12843096-59%1229726%041-100%185151133%55105-48%好又多東街10520100%29910100%5300100%50100%1800100%550100%好又多五里亭10600100%50560100%5970100

34、%1700100%820100%450100%好又多永升城4860100%38170100%2810100%500100%000%1000100%好又多廣場2420100%6770100%1000100%000%290100%400100%好又多花開富貴7850100%38240100%3790100%50100%800100%200100%永輝連鎖超市126396043109%349969111284%3357648418%1489644131%4330279055%6840100%福興連鎖超市12771394-8%4715242594%592302-39%111181-39%254407-

35、38%000%新華都1385121014%5154325059%595130358%18560208%180270-33%403033%上海世紀(jì)聯(lián)華72970100%205960100%25480100%5300100%6340100%600100%德克士13061379-5%4784358334%000%000%000%000%Total697394421458%197527 11955165%278913624670%43042013114257125152%QZQZ百姓超市51639929%127787346%2052-62%20516127%17669155%

36、000%奇龍超市1917101289%4693294559%42034223%100105-5%892240272%000%百匯超市1608681136%38571874106%653163301%10034194%37528432%2210100%好運(yùn)來超市97570838%1918145132%2512414%1051-80%470198137%50100%富華超市125988143%236422943%45029453%4075-47%700272157%100100%安盛超市2666168059%6339378368%93046998%47181-74%1080407165%10010

37、0%利民超市91570430%2179146049%490133268%300100%220290-24%000%奎生超市815903-10%1889156121%26418245%605020%35524545%000%威蘭超市8101211-33%286828032%46035131%2598-74%210268-22%000%新華都26650100%87190100%8650100%2100100%9150100%1600100%Tota361031904490%48032227116%82775510%53932273137%4060100%ZZZZ薌客隆超市

38、1655125632%5878378855%800266201%11010010%270600-55%400100%吉馬超市10301233-16%6915514834%450746-40%50112-55%18016013%300100%信義超市99051094%2987174471%565260117%3070-57%17515017%100100%新華都92874025%46897332-36%40032025%1109022%130190-32%1230100%Total4603373923%204691801214%2215159239%300372-19%7551100-31%20

39、30100%全省113060 7514550%322934 20366959%4244510910289%732269895%24612 1514263%4557274566%注： （1）YTD年累計銷量（2）%Bud年累計銷量/全年預(yù)算銷量（3）Bud=全年預(yù)算銷量（4）Month=當(dāng)月銷量（5）%Chg=（當(dāng)月銷量去年同月銷量）/去年同月銷量500ml1151.25L1122L185GALthis last%Chgthis last%Chgthis last%Chgthis last%Chg354115208%18726619%455855-47%000%27390203%18616811

40、%360910-60%000%24080200%0120-100%0335-100%000%580100%800100%200100%000%6800100%4650100%4500100%59236562%601996-40%5070100%000%2930100%104287-64%103133-23%620-70%000%000%000%21862550-14%000%13811862-26%000%000%2490650283%30043459-13%18952233-15%21922570-15%100200-50%190014884-87%0700-100%000%1000100%

41、4430498790%200500-60%000%13610826%571-93%8360-98%000%61550%16840320%94215-56%000%38725651%2924169872%8512502-66%000%035-100%105100%0150-100%000%500100%7523650%550%000%1720100%600100%500100%000%460100%1200100%000%000%420100%50100%80100%000%150100%450100%130100%000%10100%3000100%000%000%568201183%1318

42、111019%89365037%000%1241231%82256-68%114125-9%000%95906%90280-68%200350-43%000%570100%33800100%880100%000%000%4990100%000%8071379-41%1954106883%15411 18844-18%25245557-55%8071379-41%150100%30117-74%700100%000%400100%15325-95%4500100%000%12952148%7084-17%6064-6%000%52496%108126-14%794384%000%3943-9%2

43、0130-85%067-100%000%056-100%250537-53%349301063%000%000%115221-48%60600%000%9640140%20266-92%20120-83%000%5055-9%55289-81%10150-93%000%800100%950100%3400100%000%KA. Shipment monthly sales update(P.C.)-Period 2003-03CSD50129570%7782095-63%1438534169%000%14070100%22520013%7020250%000%15011530%20100-80

44、%1500100%000%18520825%2510150%000%000%654063%3070-57%7030133%000%540245120%300380-21%29050480%000%54852258143% 19493 24778-21%61478374-27%29993949-24%KA. Shipment monthly sales update(P.C.)-Period 2003-04Date:Period APRILEntering time:2003/05/07LocationKey Account MonthYTDNCBCSDNamethis lastthis las

45、tSSP(1.0L)Can355ml124Can355ml64this last%Chg2003Last% Chgthis last%Chgthis last%Chgthis last%Chgthis last%ChgXMXM沃爾瑪世貿(mào)3535248542%150291093637%121611486%2300100%35125936%1200355238%沃爾瑪SM3350277421%177321259541%95558763%225557-60%46536926%985345186%好又多富山9622330-59%102630100%230669-66%0660-100%25011711

46、4%100440-77%好又多定安3870100%34070100%3310100%100100%60100%200100%麥德龍20100100%67800100%6700100%1000100%7800100%500100%閩客隆60076398-6%229351746231%23102564-10%229569-60%10861374-21%363113%倍順26203042-14%84528666-2%13671485-8%141408-65%344476-28%000%麥當(dāng)勞16962095-19%80328574-6%000%000%000%000%廈門航空12801537-17%

47、59706627-10%000%000%100174-43%000%Total21847206616%986006486052%7079645310%9352194-57%3382276922%23911143109%FZFZ麥德龍3175183173%1050174528-86%8401055-20%0400-100%3350100%000%山姆店244408220197%8013314463454%107692500331%652930-30%3131214046%328720-54%沃爾瑪利嘉38901845111%119161249854%1580513208%1470340332%3

48、28495-34%1450100%沃爾瑪長城13681564-13%3610977269%614517412%120266-55%315343-8%880100%好又多聯(lián)信111574-99%74664471570%11662-98%0170-100%0165-100%060-100%好又多融僑270860-69%4891430014%130190-32%4020100%0115-100%100230-57%好又多黎明3229-99%12883330-61%384-96%000%026-100%015-100%好又多東街12971-99%3010971210%12193-94%037-100%

49、0161-100%0340-100%好又多五里亭6901-99%5066901462%671-92%014-100%0179-100%064-100%好又多永升城10100%38190100%10100%000%000%000%好又多廣場000%6780100%000%000%000%000%好又多花開富貴000%38260100%000%000%000%000%永輝連鎖超市11089649371%4609015604195%2758143792%630757-17%2332152053%6870100%福興連鎖超市10642405-56%5780483020%356529-47%76144-

50、47%316831-62%000%新華都152214148%6710467444%78459033%135170-21%340150127%800100%上海世紀(jì)聯(lián)華39200100%245160100%4730100%5000100%650100%600100%德克士139313910%6177497424%000%000%000%000%Total521642969876%225477 13124872%183378341120%3623324812%7162612517%148814294%QZQZ百姓超市397633-37%1674150611%161233-31%1573-79%15

51、012025%000%奇龍超市16551717-4%6348466236%47028565%060-100%120925-87%000%百匯超市2074120972%5931308392%890289208%1106569%59439750%850100%好運(yùn)來超市504991-49%24222442-1%36027730%1539-62%56379-85%000%富華超市7011146-39%30653492-12%46040813%6065-8%80535-85%000%安盛超市17502577-32%8089636027%121085342%28720044%401223-97%000%

52、利民超市77556138%2954202146%400118239%6013362%90220-59%000%奎生超市115910599%3048262016%568167240%038-100%380635-40%000%威蘭超市875338159%3773264143%395150163%704556%270129109%000%新華都12980100%100170100%6610100%1280100%1270100%1430100%Total11188102319%473212882764%55752780101%74559825%19074563-58%2280100%ZZZZ薌客隆

53、超市14691612-9%7373540037%69359616%999010%300510-41%000%吉馬超市1929171013%8846696827%799280185%1308063%310570-46%000%信義超市544667-18%3531242146%24013085%020-100%40240-83%000%新華都4361598-73%51278930-43%236410-42%0159-100%100350-71%000%Total43785587-22%24877237195%1968141639%229349-34%7501670-55%000%全省8957766

54、17735%396275 24865459%329591899074%55326389-13%13201 15127-13%4107257260%注： （1）YTD年累計銷量（2）%Bud年累計銷量/全年預(yù)算銷量（3）Bud=全年預(yù)算銷量（4）Month=當(dāng)月銷量（5）%Chg=（當(dāng)月銷量去年同月銷量）/去年同月銷量分分析析：1。QOOPET1.5L的包裝，在五一期間進(jìn)行捆綁促銷，取得比較好的效果。但受好又多斷貨的影響，銷量不如去年同期水平。2。 4月份CSDPET1。25L的銷量由于五一節(jié)的促銷普遍增長，全區(qū)增長了36%，尤其是福州增長了2倍多，但在漳州卻沒有什么效果，主要是漳州的大客戶薌客

55、隆及百匯商場均出現(xiàn)從外地進(jìn)貨，也沒有參加促銷，對銷量的影響比較大。3。4月份廈門和福州最主要的銷量影響出現(xiàn)在好又多，由于好又多沒有按時付款，出現(xiàn)了較長時間的斷貨現(xiàn)象。一個月基本上沒有訂單量。4。麥當(dāng)勞出現(xiàn)下降主要是在福州地區(qū)，廈門地區(qū)基本與去年持平。而福州地區(qū)關(guān)閉了兩個店，在其他地區(qū)新開。單店的銷量出現(xiàn)了下降。5 倍順關(guān)閉了兩個分店。銷量比去年同期有所下降。6。漳州新華都開始實(shí)行零庫存制，致使銷量減少。7 由于供貨價格的提高，客戶又不愿及時提高零售價，導(dǎo)致毛利率降低，一定程度上影響了客戶進(jìn)貨的積極性。8 4月份SARS的影響，賣場的人流量普遍減少。500ml1151.25L1122L185GA

56、Lthis last%Chgthis last%Chgthis last%Chgthis last%Chg27428879%117214-45%147481-69%000%20056257%150296-49%370564-34%000%13245193%20010198%50298-83%000%160100%40100%000%000%1000100%3100100%000%1061499113%93884511%347544-36%000%34325634%252277-9%17314024%0%000%000%000%16962095-19%000%11801363-13%000%00

57、0%2126884140%315130962%10872027-46%16962095-19%100120-17%1900563293%0200-100%000%1900100%92701400562%100530-81%000%7698-22%219274-20%72125-42%000%70770%71130-45%90231-61%000%070-100%0190-100%0257-100%000%090-100%010-100%0205-100%000%015-100%05-100%084-100%000%057-100%043-100%0140-100%000%0137-100%06

58、5-100%0371-100%000%000%000%000%000%000%000%000%000%000%000%000%000%867308181%2700157871%111589325%000%115169-32%102539-81%99193-49%000%11510015%3140-98%65264-75%000%570100%27300100%350100%000%000%4090100%000%9841391-29%1590124128%174044430293%15763493-55%9841391-29%5184-39%20123-84%000%000%90856%975

59、302223%060-100%000%25517050%85239-64%554912%000%63104-39%1099-90%093-100%000%6674-11%352075%044-100%000%93185-50%7021233%5095-47%000%040-100%11510015%1107057%000%17670151%15120-88%2029-31%000%500100%9042150%010-100%000%2080100%310100%000%000%KA. Shipment monthly sales update(P.C.)-Period 2003-04CSD1

60、05281230%1446102841%235450-48%000%19216914%18516016%087-100%000%250120108%300390-23%140270-48%000%55110-50%15960165%50107-53%000%3090-67%0439-100%70150-53%000%5274898%6441049-39%260614-58%000%5295342655%226459603136%31586584-52%26803486-23%QOOPET1.5L的包裝，在五一期間進(jìn)行捆綁促銷，取得比較好的效果。但受好又多斷貨的影響，銷量不如去年同期水平。4月份