可口可乐EXCEL表格资料大全

MoveRightUpdateAutomaticallymoveMMReportmovedownSwireGuangdongCoca-ColaLimited1.FinancialResults1.1ProfitandLossAnalysis1.2VarianceAnalysis1.3WorkingCapitalAnalysis1.4CapitalExpenditureAnalysis2.SalesandMarketing2.1SalesVolumea)SalesAnalysisbyPackage(excludingcontractpack)b)SalesAnalysisbyBrand(excludingcontractpack)c)SalesAnalysisbyCSDPackage+Brand(ExcludingContractPack)d)SalesAnalysisbyNCSDPackage+Brand(ExcludingContractPack)e)SalesAnalysisbyTerritoryf)SalesAnalysisbySalesCenterg)SalesAnalysisbyCustomerTypeh)TopTenWholesalerProfitabilityAnalysisbyStandardCostBasisii)TopTenDSDCustomersProfitabilityAnalysisbyStandardCostBasisj)ContractPackActivity2.2SellingPrice(IncludingVAT)2.3MarketingActivities2.4DirectMarketingExpenditure2.5CompetitiveIntelligence2.6SalesandDistributionKeyBusinessIndicators3.PlantandFacilities3.1MechanicalEfficiency3.2ProductionOutput3.3UsageVariance3.4Warehouse3.5StockAgeAnalysis-FinishedGoods3.6ProductQuality4.MonthlyRawMaterialPurchasingReport5.HumanResources6.CurrentYearProfitForecastMonthlyManagementReport1484353976861Index2019/9/20SwireGuangdongCoca-ColaLimited1-1:ProfitandLossAnalysis盈利分析1.FINANCIALRESULTJan-001998ActualBudgetVariance1998ActualBudgetVariance¥'M¥'M¥'M¥'MOperatingcompanyresult¥'M¥'M¥'M¥'M-Ownsales-Netrevenue--Costofsales-Materials-----Ownsales-Grosscontribution-----Conversioncost-----Ownsales-Grossprofit-----Overhead-----Ownsales-Operatingprofit-----Contractpackcontribution-----Totaloperatingprofit-----Interestexpenses--Miscellaneousincome--Exceptionalitem--Taxation-----Profitattributabletoshareholders-----Costofcapitaladjustment-----CompanyEP----Salesvolume-Ownsales('000sc)--Contractpack('000sc)--Ownsales('000uc)--Contractpack('000uc)-YTDCurrentmonth[Commentarygivingreasonsforresults.]-1020304050607080-2468101214JanFebMarAprMayJunJulAugSepOctNovDecCumulative(RMB'M)Currentmonth(RMB'M)1999CompanyEconomicProfitMonthlyLstyr.actualMonthlyBudgetMonthlyActualCumulativeLstyr.actualCumulativeBudgetCumulativeAdjustedActual14843539768611-12019/9/20SwireGuangdongCoca-ColaLimited1-2:VarianceAnalysis差异分析Jan-00YTDCurrentmonthOwnsalesContractTotalOwnsalesContractTotal¥'000¥'000¥'000Ref.¥'000¥'000¥'000-Budgeteconomicprofit-Variance-Netsellingprice1--Materialprice2--Netmarginvariance3----Salesvolume--Materialyield4--Grosscontributionvariance----Conversioncost5--Operatingexpenses6----Operatingprofitvariance---Interestexpense-Miscellaneousincome-Exceptionalitem-Taxation-MinorityinterestProfitattributabletoshareholders-Costofcapitaladjustment-Economicprofitvariance-Actualeconomicprofit-1NetsellingpricebySKUvariance:PackageActualnetsellingpriceBudgetnetsellingpriceVariance¥'000Reasonsforvarianceamountover¥100KPET1.25LCanPET0.5LTYD250mlCanSmart2Materialpricevariance(includingVAT):UnitActualpriceBudgetpriceVariance¥'000Act/BudpriceConcentrateUnit#DIV/0!SugarKG#DIV/0!CanBody+end#DIV/0!Carton(weightedaverage)Box#DIV/0!PETbottlesBottle#DIV/0!3SalesvolumebySKUvariance:PackageActualsalesvol.'000scBudgetsalesvol.'000scVariance¥'000Reasonsforvarianceamountover¥100KPET1.25LCanPET0.5LTYD250mlCanSmart4MaterialyieldvarianceUnitActualconsumptionBudgetconsumptionVariance¥'000ConcentrateUnitSugarKGCanBody+endCarton(weightedaverage)BoxPETbottlesBottle5ConversioncostItemActual¥'000Budget¥'000Variance¥'0006Selling&MarketingexpenseItemActual¥'000Budget¥'000Variance¥'0007AdministrationexpenseItemActual¥'000Budget¥'000Variance¥'000Reasonsforvarianceamountover¥100KRawmaterialsRawmaterialsReasonsforvarianceamountover¥100KReasonsforvarianceamountover¥100KReasonsforvarianceamountover¥100K14843539768611-22019/9/20SwireGuangdongCoca-ColaLimited1-3:WorkingCapitalAnalysis:营运资本分析Jan-00a)InventoryCLASSIFICATIONCURRENTYEAROPENINGPREVIOUSMONTHACTUALCURRENTMONTHACTUALCURRENTMONTHBUDGETMOVEMENT(A)(B)(B)-(A)Rawmaterial-Finishedgoods-Returnablepackagingmaterial-Spareparts-Others-NETTOTAL-----RawmaterialsinventoryturnoverdaysFinishedgoodsinventoryturnoverdaysStockturnover=Stock/Costofsales*30b)Tradedebtors-OwnsalesCLASSIFICATIONCURRENTYEAROPENINGPREVIOUSMONTHACTUALCURRENTMONTHACTUALCURRENTMONTHBUDGETMOVEMENT(A)(B)(B)-(A)0-30days-31-60days-61-90days-91-180days-181-270days-271-365days-Over1year-Less:Provisionforbaddebts-NETTOTAL-----DEBTORCOLLECTIONDAYSOwnsalesdebtorscollectiondays=Debtors/Netrevenue*30DETAILSOFOVERDUEDEBTORSOVER60DAYSWITHINDIVIDUALDEBTSOVERRMB100KEACHTOP20DEBTORS61-90days91-180days180daysTOTALRemarks1-2-3-4-5-6-7-8-9-10-11-12-13-14-15-16-17-18-19-20-21-22-23-24-25-Total----COMMENTSCOMMENTSCOMMENTS14843539768611-32019/9/20SwireGuangdongCoca-ColaLimited1-3:WorkingCapitalAnalysis:营运资本分析Jan-00c)Tradedebtors-ContractpackCLASSIFICATIONCURRENTYEAROPENINGPREVIOUSMONTHACTUALCURRENTMONTHACTUALCURRENTMONTHBUDGETMOVEMENT(A)(B)(B)-(A)0-30days-31-60days-Over60days--Currentyear--Previousyear-NETTOTAL-----COMPANY60-90days61-90days91-180days180daysTOTAL1SwireBeverages-2SGC-3HZBC-4SwireHefei-5NJBC-6SCX-7XianBC-8SwireZ.zhou-9BCD-10GMF-11SBD-12Others-TOTAL-----d)Tradedebtors-OthersDETAILSOFOTHERDEBTORSWITHINDIVIDUALDEBTSOVER