表格模板-可口可乐EXCEL表格资料大全 精品.xls

Move RightUpdate Automaticallymove MMReportmove downSwire Guangdong Coca-Cola Limited Monthly Management Report1.Financial Results1.1Profit and Loss Analysis1.2Variance Analysis1.3Working Capital Analysis1.4Capital Expenditure Analysis2.Sales and Marketing2.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 Analysis 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.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 Profit Forecast87ed5e5bf46a79a5653a2ebc6dcae1b4.xlsIndex2022/9/16Swire Guangdong Coca-Cola Limited 1-1: Profit and Loss Analysis盈盈 利利 分分 析析 1.FINANCIAL RESULT1 1月月-00-00YTDCurrent month1998ActualBudgetVariance1998ActualBudgetVarianceMMMM Operating company resultMMMMOwn sales Net revenueCost of sales MaterialsOwn sales Gross contributionConversion costOwn sales Gross profitOverheadOwn sales Operating profitContract pack contributionTotal operating profitInterest expensesMiscellaneous incomeExceptional itemTaxationProfit attributable to shareholdersCost of capital adjustmentCompany EPSales volumeOwn 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. actualMonthly BudgetMonthly ActualCumulative Lst yr. actualCumulative BudgetCumulative Adjusted Actual87ed5e5bf46a79a5653a2ebc6dcae1b4.xls112022/9/16Swire Guangdong Coca-Cola Limited 1-2: Variance Analysis差差 异异 分分 析析 1 1月月-00-00YTDCurrent monthOwn salesContractTotalOwn salesContractTotal000000000Ref.000000000-Budget economic profit-VarianceNet selling price1Material price2 Net margin variance3Sales volumeMaterial yield4Gross contribution varianceConversion cost5Operating expenses6Operating profit varianceInterest expenseMiscellaneous incomeExceptional itemTaxationMinority interestProfit attributable to shareholdersCost of capital adjustmentEconomic profit varianceActual economic profit-1Net selling price by SKU variance: PackageActual netselling priceBudget netselling priceVariance000 Reasons for variance amount over 100KPET 1.25LCanPET 0.5LTYD 250mlCan Smart2Material price variance (including VAT):Raw materialsUnitActual priceBudget priceVariance000 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 sc Variance 000 Reasons for variance amount over 100KPET 1.25LCanPET 0.5LTYD 250mlCan Smart4Material yield varianceRaw materialsUnitActualconsumptionBudgetconsumptionVariance000Reasons for variance amount over 100KConcentrateUnitSugarKGCanBody+endCarton (weighted average) BoxPET bottlesBottle5Conversion costItemActual 000Budget 000Variance 000Reasons for variance amount over 100K6Selling & Marketing expenseItemActual 000Budget 000Variance 000Reasons for variance amount over 100K7Administration expenseItemActual 000Budget 000Variance 000Reasons for variance amount over 100K87ed5e5bf46a79a5653a2ebc6dcae1b4.xls122022/9/16Swire Guangdong Coca-Cola Limited 1-3: Working Capital Analysis:营营 运运 资资 本本 分分 析析 1 1月月-00-00a)InventoryCLASSIFICATIONCURRENT YEAROPENINGPREVIOUS MONTHACTUALCURRENT MONTHACTUALCURRENT MONTHBUDGETMOVEMENT (A)(B) (B)-(A)Raw materialFinished goodsReturnable packaging materialSpare partsOthersNET TOTALRaw materials inventory turnover daysFinished goods 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 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 COMMENTS 87ed5e5bf46a79a5653a2ebc6dcae1b4.xls132022/9/16c)Trade debtors - Contract packCLASSIFICATIONCURRENT YEAROPENINGPREVIOUS MONTHACTUALCURRENT MONTHACTUALCURRENT MONTHBUDGETMOVEMENT (A)(B) (B)-(A)030 days3160 daysOver 60 days C