CocaCola Limited Monthly Management Report

1、Move RightUpdate Automaticallymove MMReportmove down4a83e62ade889227713e53d68ea92bc2.xlsIndex2022/1/15Swire Guangdong Coca-Cola Limited Monthly Management Report1.Financial Results1.1Profit and Loss Analysis1.2Variance Analysis1.3Working Capital Analysis1.4Capital Expenditure Analysis2.Sales and Mar

2、keting2.1Sales Volumea)Sales Analysis by Package (excluding contract pack)b)Sales Analysis by Brand (excluding contract pack)c)Sales Analysis by CSD Package + Brand (Excluding Contract Pack)d)Sales Analysis by NCSD Package + Brand (Excluding Contract Pack)e)Sales Analysis by Territoryf)Sales Analysi

3、s by Sales Centerg)Sales Analysis by Customer Typeh)Top Ten Wholesaler Profitability Analysis by Standard Cost Basisii)Top Ten DSD Customers Profitability Analysis by Standard Cost Basis j)Contract Pack Activity 2.2Selling Price (Including VAT)2.3Marketing Activities2.4Direct Marketing Expenditure2.

4、5Competitive Intelligence2.6Sales and Distribution Key Business Indicators3.Plant and Facilities3.1Mechanical Efficiency3.2Production Output3.3Usage Variance3.4Warehouse3.5Stock Age Analysis Finished Goods3.6Product Quality4.Monthly Raw Material Purchasing Report5.Human Resources6.Current Year Profi

5、t Forecast4a83e62ade889227713e53d68ea92bc2.xls112022/1/15Swire Guangdong Coca-Cola Limited 1-1: Profit and Loss Analysis盈盈 利利 分分 析析 1.FINANCIAL RESULT1 12 2月月- -9 99 9YTDCurrent month1998ActualBudgetVariance1998ActualBudgetVarianceMMMM Operating company resultMMMMOwn sales Net revenueCost of sales M

6、aterialsOwn sales Gross contributionConversion costOwn sales Gross profitOverheadOwn sales Operating profitContract pack contributionTotal operating profitInterest expensesMiscellaneous incomeExceptional itemTaxationProfit attributable to shareholdersCost of capital adjustmentCompany EPSales volumeO

7、wn sales (000 sc)Contract pack (000 sc)Own sales (000 uc)Contract pack (000 uc)Commentary giving reasons for results.1999 Company Economic ProfitJanFebMarAprMayJunJulAugSepOctNovDec 2 4 6 8 10 12 14 10 20 30 40 50 60 70 80 Current month (RMBM)Cumulative (RMBM)Monthly Lst yr. actualBudgetActualCumula

8、tive Lst yr. actualBudgetAdjusted Actual4a83e62ade889227713e53d68ea92bc2.xls122022/1/15Swire Guangdong Coca-Cola Limited 1-2: Variance Analysis差差 异异 分分 析析 1 12 2月月- -9 99 9YTDCurrent monthOwn salesContractTotalOwn salesContractTotal000000000Ref.000000000-Budget economic profit-VarianceNet selling pr

9、ice1Material price2 Net margin variance3Sales volumeMaterial yield4Gross contribution varianceConversion cost5Operating expenses6Operating profit varianceInterest expenseMiscellaneous incomeExceptional itemTaxationMinority interestProfit attributable to shareholdersCost of capital adjustmentEconomic

10、 profit varianceActual economic profit-1Net selling price by SKU variance: PackageActual netselling priceBudget netselling price Variance 000 Reasons for variance amount over 100KPET 1.25LCanPET 0.5LTYD 250mlCan Smart2Material price variance (including VAT):Raw materialsUnitActual priceBudget priceV

11、ariance000 Act/Bud priceConcentrateUnit#DIV/0!SugarKG#DIV/0!CanBody+end#DIV/0!Carton (weighted average) Box#DIV/0!PET bottlesBottle#DIV/0!3Sales volume by SKU variance:PackageActual salesvol. 000 scBudget salesvol. 000 scVariance 000 Reasons for variance amount over 100KPET 1.25LCanPET 0.5LTYD 250ml

12、Can Smart4Material yield varianceRaw materialsUnitActualconsumptionBudgetconsumptionVariance000Reasons for variance amount over 100KConcentrateUnitSugarKGCanBody+endCarton (weighted average) BoxPET bottlesBottle5Conversion costItemActual 000Budget 000Variance 000Reasons for variance amount over 100K

13、6Selling & Marketing expenseItemActual 000Budget 000Variance 000Reasons for variance amount over 100K7Administration expenseItemActual 000Budget 000Variance 000Reasons for variance amount over 100K4a83e62ade889227713e53d68ea92bc2.xls132022/1/15Swire Guangdong Coca-Cola Limited 1-3: Working Capital A

14、nalysis:营营 运运 资资 本本 分分 析析 1 12 2月月- -9 99 9a)InventoryCLASSIFICATIONCURRENT YEAROPENINGPREVIOUS MONTHACTUALCURRENT MONTHACTUALCURRENT MONTHBUDGETMOVEMENT (A)(B) (B)-(A)Raw materialFinished goodsReturnable packaging materialSpare partsOthersNET TOTALRaw materials inventory turnover daysFinished goods

15、 inventory turnover daysStock turnover = Stock / Cost of sales *30b)Trade debtors - Own salesCLASSIFICATIONCURRENT YEAROPENINGPREVIOUS MONTHACTUALCURRENT MONTHACTUALCURRENT MONTHBUDGETMOVEMENT (A)(B) (B)-(A)030 days3160 days6190 days91180 days181270 days271365 daysOver 1 yearLess: Provision for bad

16、debtsNET TOTALDEBTOR COLLECTION DAYSOwn sales debtors collection days = Debtors / Net revenue *30DETAILS OF OVERDUE DEBTORS OVER 60 DAYSWITH INDIVIDUAL DEBTS OVER RMB 100K EACHTOP 20 DEBTORS61-90 days91-180 days 180 daysTOTALRemarks12345678910111213141516171819202122232425TotalCOMMENTS COMMENTS COMM

17、ENTS 4a83e62ade889227713e53d68ea92bc2.xls132022/1/15Swire Guangdong Coca-Cola Limited 1-3: Working Capital Analysis:营营 运运 资资 本本 分分 析析 1 12 2月月- -9 99 9COMMENTS COMMENTS COMMENTS COMMENTS COMMENTS COMMENTS COMMENTS c)Trade debtors - Contract packCLASSIFICATIONCURRENT YEAROPENINGPREVIOUS MONTHACTUALCU

18、RRENT MONTHACTUALCURRENT MONTHBUDGETMOVEMENT (A)(B) (B)-(A)030 days3160 daysOver 60 days Current year Previous yearNET TOTALDETAILS OF CONTRACT PACK DEBTORS ANALYSIS OVER 60 DAYSCOMPANY 180 daysTOTAL1Swire Beverages2SGC3HZBC4Swire Hefei 5NJBC6SCX7Xian BC8Swire Z.zhou9BCD10GMF11SBD12Others TOTALd)Tra

19、de debtors - OthersDETAILS OF OTHER DEBTORS WITH INDIVIDUAL DEBTS OVER RMB 500K EACH CLASSIFICATIONCURRENT YEAROPENINGPREVIOUS MONTHACTUALCURRENT MONTHACTUALCURRENT MONTHBUDGETMOVEMENT (A)(B) (B)-(A)NET TOTALe)Trade creditorsTRADE CREDITORSCLASSIFICATIONCURRENT YEAROPENINGPREVIOUS MONTHACTUALCURRENT

20、 MONTHACTUALCURRENT MONTHBUDGETMOVEMENT (A)(B) (B)-(A)1234567TOTALCREDITOR PAYMENT DAYS Creditor payment day = Creditor / Actual purchase for the month * 30COMMENTS COMMENTS COMMENTS COMMENTS 4a83e62ade889227713e53d68ea92bc2.xls142022/1/15Swire Guangdong Coca-Cola Limited 1-4: Capital Expenditure An

21、alysis资资 本本 支支 出出 分分 析析 1 12 2月月- -9 99 9AnnualAnnual budgetbudget 年年 度度 预预 算算 AlreadyAlready paidpaid 已已 经经 支支 付付 Budget balanceITEMCurrentCurrent monthmonth 本本 月月 YTDYTD 本本 年年 累累 计计 预预 算算 余余 额额 QtyQty 数数 量量 AmtAmt 金金 额额 BudgetBudget 预预 算算 ActualActual 实实 际际 BudgetBudget 预预 算算 ActualActual 实实 际际 (d

22、eficit) (超 支 ) (a)(b)(a)(b)Building Construction Construction of new plant Sales building & product warehouse Decoration & otherSubtotalProduction Equipment Crimping machine Canline crimping Printer big Printer little Water treatment plant Rinser Cleaner Testing plant New plant projectSubtotalDistri

23、bution equipment Forklift Freight car 6TA truck Truck 2.75T RB truck 0.5T truck Other carrying equipment Motor cycle SubtotalSales & Marketing Equipment Postmix Cooler (400L) Cooler (260L) Slot machine CoolerSubtotalElectricity & Office Equipment Computer Printer Fax Camera Television camera TV set

24、TV camera UPS Copy machine Attendance recorder Network exchange SDS & SCALA expense Tinkpad Projecting apparatus Server Network test equipment Office furniture Other office equipmentSubtotalOthers Mobile Pager Condition Bicycle SubtotalTotal-4a83e62ade889227713e53d68ea92bc2.xls21 Chart2022/1/15Swire

25、 Guangdong Coca-Cola Limited 2-1: Sales Volume销量Period 2 20002. Sales & Marketing2-1 Sales VolumeCurrent Month 当月YTD 累计(000 case 箱)Prior year 去年Actual 实际Budget 预算Prior year 去年Actual 实际Budget 预算Swire太古箱Unit标准箱Swire太古箱Unit标准箱Swire太古箱Unit标准箱Swire太古箱Unit标准箱Swire太古箱Unit标准箱Swire太古箱Unit标准箱Own sales 自销1,477

26、2,8961,5083,1331,8413,4042,6815,2992,9645,9953,3896,384Contract pack sales 代加工122671123511826TOTALTOTAL 合合计计1,4772,8961,5203,1591,8483,4152,6815,2992,9866,0453,4076,410Own Sales - Sales VolumeJanFebMarAprMayJunJulAugSepOctNovDec 500 1,000 1,500 2,000 2,500 3,000 3,500 4,000 4,500 0 0 1 1 1 1 MTDYTD1

27、999 MTD ACT2000 MTD BUD2000 MTD ACT1999 YTD ACT2000 YTD BUD2000 YTD ACT4a83e62ade889227713e53d68ea92bc2.xls212022/1/152-1 Sales volume000 Swire caseJanFebMarAprMayJunJulAugSepOctNovDec1999 MTD ACT2000 MTD BUD2000 MTD ACT1999 YTD ACT2000 YTD BUD2000 YTD ACT000 unit caseJanFebMarAprMayJunJulAugSepOctN

28、ovDec4a83e62ade889227713e53d68ea92bc2.xls21a2022/1/15Swire Guangdong Coca-Cola Limited 2-1a: Sales Analysis by Package (excluding contract pack)分分 包包 装装 销销 量量 分分 析析 ( (不不 包包 括括 代代 加加 工工 ) )Period 2 20002-1a) Sales Analysis by Package (excluding contract pack)分分 包包 装装 销销 量量 分分 析析 ( (不不 包包 括括 代代 加加 工工

29、 ) )CurrentCurrent monthmonth 当当月月YTDYTD 累累计计MATMAT 累累计计十十二二个个月月000 swire case 太古箱+/%000 swire case 太古箱+/%000 swire case+/%P/Yr.去年Actual实际Budget预算P/Yr.去年Budget预算P/Yr.去年Actual实际Budget预算P/Yr.去年Budget预算Actual实际Budget预算Budget预算RB 192ml玻璃瓶192毫升12113928014.2550.4622926149313.8547.113,9794,51011.78RB 250ml

30、玻璃瓶250毫升8113027.1464.0432215334.7360.9234587760.66Can 355ml罐装355毫升67954575519.7727.851,1631,2231,3525.169.5610,55514,83728.87PET 0.5L塑料瓶0.5升1449214236.3235.312101902509.2123.962,2063,83142.41PET 1.25L塑料瓶1.25升39254944640.1022.8783895186813.539.545,4934,97310.44PET 2.0L塑料瓶2升60946356.7648.339515013556.

31、8710.7983472215.49POM - McDonald现调糖浆 - 麦当劳35402515.6963.3566785216.9149.3143849010.46POM - Others现调糖浆 - 其他23162428.7532.4923385162.2825.583824096.63CSD Sub-total碳酸饮料合计1,4631,4861,7661.5515.882,6562,9113,2559.5910.5624,23130,64920.94NCSD - Water 水0.000.00PET 500ml塑料瓶500毫升41437295.6862.1762666306.7461

32、.3229419550.42PET 770ml塑料瓶770毫升0.000.000.000.000.00PET 1.5L塑料瓶1.5升0.000.000.000.000.00Water Sub-total水合计41437295.6862.1762666306.7461.3229419550.42NCSD - Tea 茶Can 340ml罐装340毫升0140.0068.670480.0048.71328297.25PET 500ml塑料瓶500毫升06270.0079.57019490.0061.5131649543.36Tea Sub-total茶合计07320.0078.04023570.0

33、059.7134857508.80NCSD - Juice 果汁0.000.00Can 240ml罐装240毫升61679.7478.72941159.5763.954626282.56TBK 250ml利乐包250毫升10.000.0040.000.00105581.36Can 334ml罐装334毫升30.000.0050.000.0055090.55Juice Sub-total果汁合计101687.9978.721841179.2763.956136683.47NCSD Sub-total非碳酸合计14227555.0270.242552134109.2660.8470361913.5

34、0TOTALTOTAL 总总计计1,4771,5081,8412.0718.102,6812,9643,38910.5212.5524,93431,26820.26NOTE:MAT means Moving Annual Total which is the 12 months total to current month.4a83e62ade889227713e53d68ea92bc2.xls21b2022/1/15Swire Guangdong Coca-Cola Limited 2-1b: Sales Analysis by Brand (excluding contract pack)

35、不不 同同 品品 牌牌 销销 量量 分分 析析 ( (不不 包包 括括 代代 加加 工工 ) )Period 2 20002-1b) Sales Analysis by Brand (excluding contract pack)不不 同同 品品 牌牌 销销 量量 分分 析析 ( (不不 包包 括括 代代 加加 工工 ) )CurrentCurrent monthmonth 当当月月YTDYTD 累累计计MATMAT 累累计计十十二二个个月月000 swire case 太古箱+/%000 swire case 太古箱+/%000 swire case+/%P/Yr.去年Actual实际Bu

36、dget预算P/Yr.去年Budget预算P/Yr.去年Actual实际Budget预算P/Yr.去年Budget预算Actual实际Budget预算Budget预算Coca-Cola 可乐 (1)9291,223(8.71)(24.04)1,8922,0162,2506.55(10.40)16,82317,534(4.05)Sprite 雪碧51444528.0115.3668781082417.90(1.69)5,4944,92911.46Fanta 芬达4094(2.82)(57.57)73791737.91(54.44)6161,728(64.33)Smart 醒目3229.52165

37、30.858555.66Others 其他02(92.21)(88.31)414(86.13)(85.95)1,2906,454(80.01)CSD Sub-total碳酸合计1,4861,7661.55(15.88)2,6562,9113,2559.59(10.56)24,23130,649(20.94)TYD 天与地2275120.55(70.24)1652134225.82(60.84)195514(62.16)Hi-C 阳光0.000.0090.000.0093105(11.12)Others 其他0.000.000.000.004150.00NCSD Sub-total非碳酸合计22

38、7555.02(70.24)2552134109.26(60.84)70361913.50TOTALTOTAL 总总计计1,5081,8412.07(18.10)2,6812,9643,38910.52(12.55)24,93431,268(20.26)CurrentCurrent monthmonth 当当月月YTDYTD 累累计计Mix %Change +/ (2)Mix %Change +/P/Yr.去年Actual实际Budget预算P/Yr.去年Budget预算P/Yr.去年Actual实际Budget预算P/Yr.去年Budget预算Coca-Cola 可乐66(7.27)(4.8

39、2)716866(2.54)1.63Sprite 雪碧246.909.882627241.713.02Fanta 芬达5(0.13)(2.46)335(0.06)(2.45)Smart 醒目00.070000.07Others 其他0(0.16)(0.08)000(0.12)(0.09)CSD Sub-total碳酸合计96(0.50)2.59999896(0.84)2.18TYD 天与地40.79(2.59)1241.17(2.18)Hi-C 阳光(0.29)0.000(0.33)0.00Others 其他0.000.000.000.00NCSD Sub-total非碳酸合计40.50(2.

40、59)1240.84(2.18)TOTALTOTAL 总总计计1000.000.001001001000.000.00NOTE:1. Brand CocaCola including Diet Coke2. Change +/ = change in percentage points. e.g.from 36% to 25% = (11).4a83e62ade889227713e53d68ea92bc2.xls21c2022/1/15Swire Guangdong Coca-Cola Limited 2-1c: Sales Analysis by CSD package & brand (e

41、xcluding contract pack)碳碳 酸酸 饮饮 料料 包包 装装 和和 品品 牌牌 销销 量量 分分 析析 ( (不不 包包 括括 代代 加加 工工 ) )Period 2 2000 2-1c) Sales Analysis by CSD package & brand (excluding contract pack)碳碳 酸酸 饮饮 料料 包包 装装 和和 品品 牌牌 销销 量量 分分 析析 ( (不不 包包 括括 代代 加加 工工 ) )CurrentCurrent monthmonth 当当月月(000 swire case)CokeCoke 可可乐乐SpriteSpr

42、ite 雪雪碧碧FantaFanta 芬芬达达SmartSmart 醒醒目目OthersOthers 其其他他CSDCSD Sub-totalSub-total 碳碳酸酸合合计计千太古箱Budget预算Actual实际+/ %Budget预算Actual实际+/ %Budget预算Actual实际+/ %Budget预算Actual实际+/ %Budget预算Actual实际+/ %Budget预算Actual实际+/ %RB 192ml 玻璃瓶192毫升RB 250ml 玻璃瓶250毫升Can 355ml 罐装355毫升PET 0.5L 塑料瓶0.5升PET 1.25L 塑料瓶1.25升PE

43、T 2.0L 塑料瓶2升POM - McDonald 现调糖浆-麦当劳POM - Others 现调糖浆-其他CSD Sub-total 碳酸合计YTDYTD 累累计计(000 swire case)CokeCoke 可可乐乐SpriteSprite 雪雪碧碧FantaFanta 芬芬达达SmartSmart 醒醒目目OthersOthers 其其他他CSDCSD Sub-totalSub-total 碳碳酸酸合合计计千太古箱Budget预算Actual实际+/ %Budget预算Actual实际+/ %Budget预算Actual实际+/ %Budget预算Actual实际+/ %Budge

44、t预算Actual实际+/ %Budget预算Actual实际+/ %RB 192ml 玻璃瓶192毫升RB 250ml 玻璃瓶250毫升Can 355ml 罐装355毫升PET 0.5L 塑料瓶0.5升PET 1.25L 塑料瓶1.25升PET 2.0L 塑料瓶2升POM - McDonald 现调糖浆-麦当劳POM - Others 现调糖浆-其他CSD Sub-total 碳酸合计4a83e62ade889227713e53d68ea92bc2.xls21d2022/1/15Swire Guangdong Coca-Cola Limited 2-1d: Sales Analysis by

45、 NCSD package & brand (excluding contract pack)非非 碳碳 酸酸 饮饮 料料 包包 装装 和和 品品 牌牌 销销 量量 分分 析析 ( (不不 包包 括括 代代 加加 工工 ) )Period 2 20002-1d) Sales Analysis by NCSD package & brand (excluding contract pack)非非 碳碳 酸酸 饮饮 料料 包包 装装 和和 品品 牌牌 销销 量量 分分 析析 ( (不不 包包 括括 代代 加加 工工 ) )CurrentCurrent monthmonth 当当月月(000 swi

46、re case)TYDTYD JuiceJuice 天天与与地地果果汁汁TYDTYD WaterWater 天天与与地地水水TYDTYD TeaTea 天天与与地地茶茶Hi-CHi-C 阳阳光光NCSDNCSD Sub-totalSub-total 非非碳碳酸酸合合计计千太古箱Budget预算Actual实际+/ %Budget预算Actual实际+/ %Budget预算Actual实际+/ %Budget预算Actual实际+/ %Budget预算Actual实际+/ %TBK 250ml 利乐包250毫升0.000.000.000.000.00CAN 240ml 罐装240毫升61(78.

47、72)0.000.000.0061(78.72)CAN 334ml 罐装334毫升0.000.000.000.000.00CAN 340ml 罐装340毫升0.000.0041(68.67)0.0041(68.67)PET 500ml 塑料瓶500毫升0.003714(62.17)276(79.57)0.006420(69.58)PET 770ml 塑料瓶770毫升0.000.000.000.000.00Pet 1.5L 塑料瓶1.5升0.000.000.000.000.00NCSD Sub-total 非碳酸合计61(78.72)3714(62.17)327(78.04)0.007522(7

48、0.24)YTDYTD 累累计计(000 swire case)TYDTYD JuiceJuice 天天与与地地果果汁汁TYDTYD WaterWater 天天与与地地水水TYDTYD TeaTea 天天与与地地茶茶Hi-CHi-C 阳阳光光NCSDNCSD Sub-totalSub-total 非非碳碳酸酸合合计计千太古箱Budget预算Actual实际+/ %Budget预算Actual实际+/ %Budget预算Actual实际+/ %Budget预算Actual实际+/ %Budget预算Actual实际+/ %TBK 250ml 利乐包250毫升0.000.000.000.000.0

49、0CAN 240ml 罐装240毫升114(63.95)0.000.000.00114(63.95)CAN 334ml 罐装334毫升0.000.000.000.000.00CAN 340ml 罐装340毫升0.000.0084(48.71)0.0084(48.71)PET 500ml 塑料瓶500毫升0.006626(61.32)4919(61.51)0.0011545(61.40)PET 770ml 塑料瓶770毫升0.000.000.000.000.00Pet 1.5L 塑料瓶1.5升0.000.000.000.000.00NCSD Sub-total 非碳酸合计114(63.95)66

50、26(61.32)5723(59.71)0.0013452(60.84)4a83e62ade889227713e53d68ea92bc2.xls21e2022/1/15Swire Guangdong Coca-Cola Limited 2-1e: Sales Analysis by Territory不不 同同 销销 售售 区区 域域 销销 量量 分分 析析 Period 2 20002-1e) Sales Analysis by Territory不不 同同 销销 售售 区区 域域 销销 量量 分分 析析 (000 swire case)千太古箱Jan一月Feb二月Mar三月Apr四月May

51、五月Jun六月Jul七月Aug八月Sep九月Oct十月Nov十一月Dec十二月YTD累计In-City 市内Budget 预算4154745355937581,0217167169095505596067,851Actual 实际333374707+/ %(19.79)(20.99)0.000.000.000.000.000.000.000.000.000.00(90.99)Sales center 营业所Budget 预算6006857748571,0961,4761,0351,0351,31579580987611,351Actual 实际485500985+/ %(19.09)(27.0

52、8)0.000.000.000.000.000.000.000.000.000.00(91.32)Post mix 现调糖浆Budget 预算4349566279106747495575863816Actual 实际5957116+/ %36.2915.220.000.000.000.000.000.000.000.000.000.00(85.84)Others 其他Budget 预算4906336808551,1351,5291,0571,0571,35984279588611,319Actual 实际5795771,156+/ %18.11(8.80)0.000.000.000.000.0

53、00.000.000.000.000.00(89.79)TOTAL 总计Budget 预算1,5481,8412,0452,3663,0674,1322,8822,8823,6782,2442,2212,43131,338Actual 实际1,4561,5082,964+/ %(5.96)(18.10)0.000.000.000.000.000.000.000.000.000.00(90.54)4a83e62ade889227713e53d68ea92bc2.xls21f2022/1/15Swire Guangdong Coca-Cola Limited 2-1f: Sales Analysi

54、s by Sales Center分分 公公 司司 ， 营营 业业 所所 销销 量量 分分 析析 Period 2 20002-1f) Sales Analysis by Sales Center分分 公公 司司 ， 营营 业业 所所 销销 量量 分分 析析 (000 swire case)千太古箱Jan一月Feb二月Mar三月Apr四月May五月Jun六月Jul七月Aug八月Sep九月Oct十月Nov十一月Dec十二月YTD累计Shenzhen 深圳Budget 预算2242562893204095513873874912973023274,241Actual 实际148146294+/ %

55、(33.84)(42.88)0.000.000.000.000.000.000.000.000.000.00(93.06)Foshan 佛山Budget 预算1721962222463144232972973772282322513,253Actual 实际155149304+/ %(9.87)(24.22)0.000.000.000.000.000.000.000.000.000.00(90.66)Shunda 顺德Budget 预算647382911161571101101408486931,206Actual 实际5963122+/ %(7.84)(12.85)0.000.000.000

56、.000.000.000.000.000.000.00(89.87)Shantou 汕头Budget 预算647383911171571101101408586931,210Actual 实际5670126+/ %(11.93)(4.72)0.000.000.000.000.000.000.000.000.000.00(89.60)Huizhou 惠州Budget 预算45525965831127878100606166861Actual 实际444287+/ %(2.80)(18.59)0.000.000.000.000.000.000.000.000.000.00(89.95)Shaogu

57、an 韶关Budget 预算313540445676535367414145581Actual 实际232952+/ %(25.54)(16.37)0.000.000.000.000.000.000.000.000.000.00(91.02)4a83e62ade889227713e53d68ea92bc2.xls21g2022/1/15Swire Guangdong Coca-Cola Limited 2-1g: Sales Analysis by Customer Type客客 户户 种种 类类 销销 量量 分分 析析 Period 2 20002-1g) Sales Analysis by

58、 Customer Type客客 户户 种种 类类 销销 量量 分分 析析 (000 swire case)千太古箱Jan一月Feb二月Mar三月Apr四月May五月Jun六月Jul七月Aug八月Sep九月Oct十月Nov十一月Dec十二月YTD累计Wholesaler 批发 (1)Budget 预算Actual 实际+/ %9.17(3.24)0.000.000.000.000.000.000.000.000.000.00(88.92)Direct sales 直销Budget 预算4219231,4792,1232,9584,0834,8685,6526,6547,2647,8698,53

59、18,531Actual 实际226211437+/ %(46.40)(77.09)0.000.000.000.000.000.000.000.000.000.00(94.87)Direct sales as % oftotal直销占总销量百分比15.5114.020.000.000.000.000.000.000.000.000.000.0014.75NOTE: 1. Wholesaler means customer which has its own distribution system to either other distributors or retailers,and doe

60、s not sell directly to consumers. If a wholesaler also has retail business, it should be classified asa wholesaler or retailer depending on which part of its business generates the larger volume. 2. Direct sales outlets means retail outlets which purchase product direct from bottler within the past