Ppt. and Data analysis
COFFEE REVIEW 2024
Author: Maria Milka Mensching
Outline:
➢ Customer Profile
➢ YTD June 2024 Coffee Business Review
➢ Coffee Performance Scorecard
➢ Category Analysis
COFFEE BUSINESS TOTAL
Area
YTD'24 YTD BGT YTD'23
vol
vol
vol
2,-,426
CONFIDENTIAL
Grand Total
2,-,945
2,-,608
vs BGT
vs LY
82%
92%
80%
75%
81%
82%
-7%
9%
1%
-24%
-16%
-7%
SHARE OF
BUSINESS
33%
25%
25%
16%
100%
TOP 10 SKUs
Area
SKU 1
SKU 10
Sum of
YTD'23
vol
Sum of
YTD BGT
vol
Sum of
YTD'24
vol
282
374
414
vs BGT
vs LY
% CONTRIBUTION
364
97%
129%
15%
535
351
66%
85%
14%
211
190
253
133%
120%
10%
214
226
216
96%
101%
9%
58
65
112
171%
193%
5%
7
65
112
174%
1600%
5%
121
94
98
104%
81%
4%
153
116
86
74%
56%
4%
74
155
73
47%
99%
3%
51
98
64
66%
125%
3%
KEY POINTS:
➢ Total coffee for ? were
down vs BGT only and
with growth vs LY.
TOTAL AREA AND PER CHAIN - SCORECARD
MEASURES
Year-To-Date
% GROWTH
Actual
TGT
LY
COFFEE Volume (in '000
cases)
2,426 2,945 2,608
SUGARFREE
1,426 1,431 1,294
REGULAR
399
578
471
JARS
166
219
276
WHITE
65
90
99
BGT
LY
%
CONTRIBU
TION
100%
82%
-7%
100%
10%
59%
69%
-15%
16%
76%
-40%
7%
72%
-34%
3%
KEY POINTS:
➢ Total coffee business for
Sugarfree is at 59% share
of business performed flat
for YTD.
Sum of CSL
Row Labels-
Grand Total
Column
Labels
Jan
Feb
Mar
Apr
May
Jun
89%
84%
87%
92%
84%
88%
85%
87%
86%
86%
95%
90%
91%
93%
92%
94%
86%
90%
Grand
Total
89%
88%
89%
COFFEE PERFORMANCE - SCORECARD
Area
3-IN-1
SUGARFREE
REGULAR
WHITE
Grand Total
YTD'24 YTD BGT YTD'23
vol
vol
vol
vs BGT
vs LY
1,927
2,123
1,864
91%
3%
1,426
1,431
1,294
100%
10%
399
65
578
90
471
99
69%
72%
-15%
-34%
1,927
2,123
1,864
91%
3%
KEY POINTS:
➢ CONFIDENTIAL DATA
YTD June 2024 Service level
Row Labels
Jan'24
Wk 1
Wk 2
Wk 3
Wk 4
Wk 5
Feb'24
Wk 1
Wk 2
Wk 3
Wk 4
Wk 5
Mar'24
Wk 2
Wk 3
Wk 4
Wk 5
Apr'24
Wk 1
Wk 2
Wk 3
Wk 4
Wk 5
May'24
Wk 1
Wk 2
Wk 3
Wk 4
Wk 5
Jun'24
Wk 2
Wk 3
Wk 4
Wk 5
Grand Total
Booked kg
1,-,-,-,067
Delivered
kg
1,-,-,-,508
Devuelto
kg
Rejected kg-,134
% Service
level
97%
100%
98%
100%
95%
96%
91%
97%
96%
87%
95%
76%
92%
88%
95%
98%
87%
98%
98%
98%
99%
97%
91%
87%
86%
81%
83%
81%
95%
80%
73%
64%
94%
94%
91%
2024 PER CATEGORY VOL ANALYSIS
Sum of Sum of Sum of Sum of Sum of Sum of Sum of
CATEGORY Jan'24 Feb'24 Mar'24 Apr'24 May'24 Jun'24 YTD'24
vol
vol
vol
vol
vol
vol
vol
SUGARFREE-,426
REGULAR-
WHITE-
Grand Total-,426
Row Labels
Booked kg
Delivered kg
Devuelto
kg
Rejected kg
%
CONTRIBUTI
ON
59%
16%
3%
100%
% Service
level
Jan'24
1,081
1,049
3
85
97%
Feb'24
953
864
-
235
91%
Mar'24
1,146
1,056
-
224
92%
Apr'24
818
800
3
65
98%
May'24
1,205
1,044
-
391
87%
Jun'24
864
694
35
135
80%
6,067
5,508
42
1,134
91%
Grand Total
KEY POINTS:
❖ Major contributor volume contributor for Coffee business is the sugarfree it’s peak reaches 300 cs last March. 24 vol