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

《表格模板-可口可乐EXCEL表格资料大全 精品.xls》由会员分享，可在线阅读，更多相关《表格模板-可口可乐EXCEL表格资料大全 精品.xls（47页珍藏版）》请在第一文库网上搜索。

1、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 (

2、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 Type

3、h)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

4、 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.xlsInde

5、x2022/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 costOw

6、n 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

7、 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 BudgetC

8、umulative 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 N

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

10、l 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 pric

11、eConcentrateUnit#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 yie

12、ld varianceRaw materialsUnitActualconsumptionBudgetconsumptionVariance000Reasons for variance amount over 100KConcentrateUnitSugarKGCanBody+endCarton (weighted average) BoxPET bottlesBottle5Conversion costItemActual 000Budget 000Variance 000Reasons for variance amount over 100K6Selling & Marketing e

13、xpenseItemActual 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:营营 运运 资资 本本 分分

14、 析析 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 daysStoc

15、k 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 COLLECT

16、ION 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