THE BMZ ACADEMY
THE BMZ ACADEMY
053 8213
BMZ ACADEMY 061 262 1185/068 053 8213Page 1 of 20
, THE BMZ ACADEMY
IMPORTANT NOTES TO CONSIDER
THIS IS ONLY A FRAMEWORK, NO ONE SHOULD SUBMIT IT FOR FINAL
ASSESSMENT.
STUDENTS SHOULD COMPLETE THEIR OWN ASSIGNMENT, BUT KEEP IN MIND
THE RULES/INSTRUCTIONS
AS A TIP, IF YOU FIND THIS GUIDE USEFUL, YOU CAN CALL/WHATASPP US IF
YOU WANT A UNIQUE AND CUSTOMISED SOLUTION, SOMETHING THAT WE
GIVE YOU ALONE AND NOT SHARED WITH OTHER PEOPLE NOR SOLD ON
STUVIA AND OTHER ONLINE SITES
********************************************************************************************
AT BMZ Academy, WE WISH YOU THE BEST IN ALL YOUR STUDIES.
WE ARE YOUR MATES TO PASSING EXCELLENTLY IN ALL YOUR STUDIES.
DO NOT FORGET TO REACH OUT TO US FOR ANY FURTHER AND OTHER
ASSISTANCE!
GOOD LUCKY
BMZ ACADEMY 061 262 1185/068 053 8213
, THE BMZ ACADEMY
Table of Contents
Task 1: Customer Count, Retention and Customer Segmentation Analysis ................... 5
1. Total customer count ................................................................................................... 5
2. Percentage of customers in each segment ................................................................. 5
3. Retention rates by segment ........................................................................................ 6
4. Attrition rates by segment ............................................................................................ 6
Which segment appears most stable? ............................................................................ 7
Which segment presents the greatest risk? .................................................................... 7
Why is retention more informative than simple customer counts? .................................. 7
Which segment should receive the greatest retention investment? ................................ 8
Task 2: Customer Profitability Analysis ........................................................................... 9
1. Segment Contribution Margin ...................................................................................... 9
2. Margin per customer ................................................................................................. 10
3. Total Segment Profit.................................................................................................. 10
Which segments are most profitable? ........................................................................... 11
Are some customers contributing disproportionately to profits? .................................... 12
Does the company have any potentially low-value customer groups? .......................... 12
Task 3: Customer Lifetime Value (CLV) Analysis .......................................................... 15
BMZ ACADEMY 061 262 1185/068 053 8213
THE BMZ ACADEMY
053 8213
BMZ ACADEMY 061 262 1185/068 053 8213Page 1 of 20
, THE BMZ ACADEMY
IMPORTANT NOTES TO CONSIDER
THIS IS ONLY A FRAMEWORK, NO ONE SHOULD SUBMIT IT FOR FINAL
ASSESSMENT.
STUDENTS SHOULD COMPLETE THEIR OWN ASSIGNMENT, BUT KEEP IN MIND
THE RULES/INSTRUCTIONS
AS A TIP, IF YOU FIND THIS GUIDE USEFUL, YOU CAN CALL/WHATASPP US IF
YOU WANT A UNIQUE AND CUSTOMISED SOLUTION, SOMETHING THAT WE
GIVE YOU ALONE AND NOT SHARED WITH OTHER PEOPLE NOR SOLD ON
STUVIA AND OTHER ONLINE SITES
********************************************************************************************
AT BMZ Academy, WE WISH YOU THE BEST IN ALL YOUR STUDIES.
WE ARE YOUR MATES TO PASSING EXCELLENTLY IN ALL YOUR STUDIES.
DO NOT FORGET TO REACH OUT TO US FOR ANY FURTHER AND OTHER
ASSISTANCE!
GOOD LUCKY
BMZ ACADEMY 061 262 1185/068 053 8213
, THE BMZ ACADEMY
Table of Contents
Task 1: Customer Count, Retention and Customer Segmentation Analysis ................... 5
1. Total customer count ................................................................................................... 5
2. Percentage of customers in each segment ................................................................. 5
3. Retention rates by segment ........................................................................................ 6
4. Attrition rates by segment ............................................................................................ 6
Which segment appears most stable? ............................................................................ 7
Which segment presents the greatest risk? .................................................................... 7
Why is retention more informative than simple customer counts? .................................. 7
Which segment should receive the greatest retention investment? ................................ 8
Task 2: Customer Profitability Analysis ........................................................................... 9
1. Segment Contribution Margin ...................................................................................... 9
2. Margin per customer ................................................................................................. 10
3. Total Segment Profit.................................................................................................. 10
Which segments are most profitable? ........................................................................... 11
Are some customers contributing disproportionately to profits? .................................... 12
Does the company have any potentially low-value customer groups? .......................... 12
Task 3: Customer Lifetime Value (CLV) Analysis .......................................................... 15
BMZ ACADEMY 061 262 1185/068 053 8213
