Elite Academic Institute 068 053 8213 /0717 513 144/ 061 262 1185
ademic In
Ac sti
te
tu
Eli
te
W
er
de
a
h
eG M
raduates Ar e
Educating the world for a better change
,Elite Academic Institute 068 053 8213 /0717 513 144/ 061 262 1185
WARNING: PLEASE NOTE THAT PLAGIARISM IS A SERIOUS ACADEMIC
OFFENSE, therefore, the documents provided here including past assignments, tests
and notes are intended SOLELY for educational purposes and as a guide to help
students understand academic concepts and improve their writing skills. These
materials should not be submitted as final work, as doing so may constitute academic
dishonesty. Students are encouraged to use them as reference points, develop their
own understanding and produce original work that reflects their knowledge and critical
thinking. Students are also encouraged to regenerate their own (personalized)
solutions paying particular attention to module contents as prescribed by module
facilitators, lecturers and supervisors. If this document is plagiarized by the users and
fails, ELITE ACADEMIC INSTITUTE should not be rendered accountable since the
contents in this document only give learners a kick-start on what is expected of them
from their areas of specialty.
CAUTION: STUDENTS ARE NOT MANDATED TO USE ALL THE INFORMATION IN
THIS DOCUMENT IN WRITING THEIR ASSIGNMENT
Educating the world for a better change
, Elite Academic Institute 068 053 8213 /0717 513 144/ 061 262 1185
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 ................................................................................ 5
4. Attrition rates by segment ................................................................................... 6
Which segment appears most stable? ................................................................... 6
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
1. Annual margin .................................................................................................... 15
2. Customer Lifetime Value for all three segments ............................................. 15
Educating the world for a better change
ademic In
Ac sti
te
tu
Eli
te
W
er
de
a
h
eG M
raduates Ar e
Educating the world for a better change
,Elite Academic Institute 068 053 8213 /0717 513 144/ 061 262 1185
WARNING: PLEASE NOTE THAT PLAGIARISM IS A SERIOUS ACADEMIC
OFFENSE, therefore, the documents provided here including past assignments, tests
and notes are intended SOLELY for educational purposes and as a guide to help
students understand academic concepts and improve their writing skills. These
materials should not be submitted as final work, as doing so may constitute academic
dishonesty. Students are encouraged to use them as reference points, develop their
own understanding and produce original work that reflects their knowledge and critical
thinking. Students are also encouraged to regenerate their own (personalized)
solutions paying particular attention to module contents as prescribed by module
facilitators, lecturers and supervisors. If this document is plagiarized by the users and
fails, ELITE ACADEMIC INSTITUTE should not be rendered accountable since the
contents in this document only give learners a kick-start on what is expected of them
from their areas of specialty.
CAUTION: STUDENTS ARE NOT MANDATED TO USE ALL THE INFORMATION IN
THIS DOCUMENT IN WRITING THEIR ASSIGNMENT
Educating the world for a better change
, Elite Academic Institute 068 053 8213 /0717 513 144/ 061 262 1185
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 ................................................................................ 5
4. Attrition rates by segment ................................................................................... 6
Which segment appears most stable? ................................................................... 6
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
1. Annual margin .................................................................................................... 15
2. Customer Lifetime Value for all three segments ............................................. 15
Educating the world for a better change
