可口可乐excel表格资料大全.xlsVIP

Module2 Module1 B_4-4 B_4-3 B_4-2 B_4-1 B_3 B_2 B_1 A_4 A_3 A_2 A_1 6 5 4 3-6 3-5 3-4_Data 3-4 3-3 3-2 3-1 2-7 2-6 2-5 2-4 2-3 2-2 2-1j 2-1i 2-1h 2-1g 2-1f 2-1e 2-1d 2-1c 2-1b 2-1a 2-1 2-1 Chart 1-4 1-3 1-2 1-1 Index Note Coname ConameC Language Language Macro1 Macro10 Macro11 Macro12 Macro13 Macro14 Macro15 Macro17 Macro18 Macro19 Macro2 Macro20 Macro21 Macro22 Macro23 Macro24 Macro25 Macro26 Macro27 Macro28 Macro29 Macro3 Macro30 Macro4 Macro5 Macro6 Macro7 Macro8 Macro9 Module1.Macro17 Month sellingpriceeffect volumemixeffect DETAILS OF OVERDUE DEBTORS OVER 60 DAYS WITH INDIVIDUAL DEBTS OVER RMB 100K EACH 61-90 days 91-180 days 180 days TOTAL Remarks Others DETAILS OF CONTRACT PACK DEBTORS ANALYSIS OVER 60 DAYS COMPANY Swire Beverages 000 Swire case 000 unit case HZBC Swire Hefei BCD Others TRADE CREDITORS CREDITOR PAYMENT DAYS (a) (b) Subtotal Current Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec +/- % Wholesaler 批发 (1) Direct sales 直销 Direct sales as % of total 直销占总销量百分比 Customer Name 客户名称 Sales volume 销量 (000 sc)千太古箱 Gross contribution per swire case 每太古箱毛利 (￥) Gross contribution 毛利 (￥000) Cost of sales-Material at standard cost 销售物料标准成本 (￥000) Total 总计 Contract Pack Sales 代加工 Contract Pack Purchase 委托代加工 CSD 碳酸饮料 Prior month 上月 RB 250ml NOTE: MAT means Moving Annual Total which is the 12 months total to current month. Sprite Fanta Smart Mix % Change +/- Coke (000 swire case) and does not sell directly to consumers. If a wholesaler also has retail business, it should be classified as excludes wholesalers. Note: Month % Bottler Volume 主 要 销 售 经 营 指 标 装 卸 费 CAN % +/- P/Mth C/Mth STD 1-2: Variance Analysis 1-1: Profit and Loss Analysis 2-1: Sales Volume 差 异 分 析 营 运 资 本 分 析 资 本 支 出 分 析 分 包 装 销 量 分 析 (不 包 括 代 加 工 ) 1-4: Capital Expenditure Analysis 2-1a: Sales Analysis by Package (excluding contract pack) SCCDG 碳 酸 饮 料 包 装 和 品 牌 销 量 分 析 (不 包 括 代 加 工 ) 不 同 品 牌 销 量 分 析 (不 包 括 代 加 工 ) 客 户 种 类 销 量 分 析 2-1g: Sales Analysis by Customer Type 按