Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Giant Dragon has three customers: Andrew, Pat and Sarah. The store wants to pick up one customer who is the most valuable to it. Please

Giant Dragon has three customers: Andrew, Pat and Sarah. The store wants to pick up one customer who is the most valuable to it. Please use the RFM analysis and help the store choose the right customer. The point allocation rules are listed in Table 3. The customer data is listed in Table 4.

Table 3. Point Allocation Rules

Recency

20 if within past 2 months; 10 if within past 4 months; 05 if within past 6 months;03 if within past 9 months; 01 if within past 12 months;

Frequency

3 points for each purchase within 12 months. Maximum = 15 points.

Monetary Value

10 percent of the $ Volume of Purchase with 12 months; Maximum = 25 point

Weight

Recency

Frequency

Monetary ($)

6

3

4

Table 4. Consumer Data

Consumer

Month

Recency

Frequency

Monetary ($)

Andrew

September

2

2

70

July

4

2

100

February

9

1

80

Pat

April

7

2

500

Sarah

October

1

1

80

June

5

2

90

May

6

1

50

Februrary

9

1

30

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cornerstones of Financial and Managerial Accounting

Authors: Rich Jones, Mowen, Hansen, Heitger

1st Edition

9780538751292, 324787359, 538751290, 978-0324787351

More Books

Students also viewed these Accounting questions

Question

Explain how the process view of business includes various functions

Answered: 1 week ago

Question

oose the correct answer below A Pr B Pr n r n D n n r n C nPr r n r

Answered: 1 week ago

Question

Discuss the various types of policies ?

Answered: 1 week ago

Question

Briefly explain the various types of leadership ?

Answered: 1 week ago

Question

Explain the need for and importance of co-ordination?

Answered: 1 week ago

Question

Explain the contribution of Peter F. Drucker to Management .

Answered: 1 week ago