Kindly, find a reference for RFM cases to further clarify how RFM is calculated and analyzed.

With reference to the sample cases, please, calculate the case in Assignment 5 document.

Assignment 5: Case: If there are two hypermarkets and you need to evaluate RFM per hypermarket so that we can decide which is more profitable whether to start our business in both hypermarkets or select one or dismiss both 100 100 100 Hypermarket A: Customer ID Product Unit Price of Units Date 1 Heathly Food Al 30 11-Feb-22 1 Heathly Food-B 15 50/15-Feb-221 Heathly Food-A 100 15/15-Feb-22 2 Heathly Food A 1020-Feb-22 2 Heathly Food-A S 11-Feb-22 2 Heathly Food-B 15 30/15-Feb-221 2 Heathly Food-A 100 2/15-Feb-22 2 Heathly Food-A 100 1020-Feb-22 3 Heathly Food-A 100 10/15-Feb-221 3 Heathly Food-B 15 1015-Feb-22 3 Heathly Food A 100 2/19-Feb-22 3 Heathly Food A 100 1015-Feb-22) 3 Heathly Food-A 1001 10/15-Feb-22 4 Heathly Food-B 15 1515-Feb-221 4 Heathly Food-A 100 2 il-Feb-22 S Heathly Food-A 100 10/15-Feb-22 5 Heathly Food-A 100 1020-Feb-22 Heathly Food-A 100 10 11-Feb-221 6 Heathly Food-A 100 10 19-Feb-221 Heathly Food-B 151 10/15-Feb-221 7 Heathly Food-B 15 10/15-Feb-221 Heathly Food A 100 215-Feb-22 Heathly Food-A 100 211-Feb-22 9 Heathly Food A 100 1020-Feb-22 9 Heathly Food A 100 1020-Feb-221 10 Heathly Food A 100 2/15-Feb-22 10 Heathly Food-A 100 10120-Feb-22 10 Heathly Food-A 100 211-Feb-22 10 Heathly Food-A 219-Feb-22 11 Heathly Food Al 100 1015-Feb-22 11 Heathly Food-B 15 25|15-Feb-22 12 Heathly Food- 100 2/15-Feb-22 12 Heathly Food-A 100 10.20-Feb-22 13 Heathly Food-A 100 10/19-Feb-221 13 Heathly Food-B 151 1120-Feb-22 13 Heathly Food-A 100 211-Feb-22 14 Heathly Food- 100 10 20-Feb-22 15 Heathly Food A 100 1011-Feb-221 15 Heathly Food-B 15 5115-Feb-22 15 Heathly Food A 100 2/15-Feb-22 100 Hypermarket B: Customer ID Product Unit Price of Units Date 1 Healthy Food-AI 2001 101 1-Jan-22 1 Healthy Food-B 20 30 2-Jan-22 Healthy Food-A 2001 23-Jan-22 2 Healthy Food-A 2001 11 4-Jan-22 2 Healthy Food-A 2001 10 5-Jan-22 2 Healthy Food-B 20 1516-Jan-22 2 Healthy Food-A 2001 27-Jan-22 2 Healthy Food-Al 2001 11 8-Jan-22 3 Healthy Food-Al 200 10 9-Jan-22 3 Healthy Food-B 20 5 10-Jan-22 3 Healthy Food-A 2001 2 11-Jan-22 3 Healthy Food-A 200 112-Jan-22 3 Healthy Food-AI 200 10 13-Jan-22 4 Healthy Food-B 20 10 1-Feb-22 4 Healthy Food-A 200 22-Feb-22 S Healthy Food-A 200 11 3-Feb-22 S Healthy Food-A 200 14-Feb-22 6 Healthy Food-A 200 105-Feb-22 6 Healthy Food-A 200 106-Feb-22 7 Healthy Food-B 201 57-Feb-22 7 Healthy Food-B 20 S 8-Feb-22 & Healthy Food-A 200 219-Feb-22 8 Healthy Food-A 200 210-Feb-22 9 Healthy Food-A 200 111-Feb-22 9 Healthy Food-A 200 112-Feb-22 10 Healthy Food-A 200 213-Feb-22 10 Healthy Food-A 200 1/14-Feb-22 10 Healthy Food-A 200 215-Feb-22 10 Healthy Food-A 200 216-Feb-22 11 Healthy Food-A 200 10/17-Feb-22 11 Healthy Food-B 201 2018-Feb-22 12 Healthy Food-A 200 2119-Feb-22 12 Healthy Food-A 200 1 20-Feb-22 13 Healthy Food-A 200 10 1-Feb-22 13 Healthy Food-B 20 12-Feb-22 13 Healthy Food-A 200 21 3-Feb-22 14 Healthy Food-A 200 11 4-Feb-22 15 Healthy Fo 200 105-Feb-22 15 Healthy Food-B 20 S 6-Feb-22 15 Healthy Food-A 2001 27-Feb-22 Assignment 5: Case: If there are two hypermarkets and you need to evaluate RFM per hypermarket so that we can decide which is more profitable whether to start our business in both hypermarkets or select one or dismiss both 100 100 100 Hypermarket A: Customer ID Product Unit Price of Units Date 1 Heathly Food Al 30 11-Feb-22 1 Heathly Food-B 15 50/15-Feb-221 Heathly Food-A 100 15/15-Feb-22 2 Heathly Food A 1020-Feb-22 2 Heathly Food-A S 11-Feb-22 2 Heathly Food-B 15 30/15-Feb-221 2 Heathly Food-A 100 2/15-Feb-22 2 Heathly Food-A 100 1020-Feb-22 3 Heathly Food-A 100 10/15-Feb-221 3 Heathly Food-B 15 1015-Feb-22 3 Heathly Food A 100 2/19-Feb-22 3 Heathly Food A 100 1015-Feb-22) 3 Heathly Food-A 1001 10/15-Feb-22 4 Heathly Food-B 15 1515-Feb-221 4 Heathly Food-A 100 2 il-Feb-22 S Heathly Food-A 100 10/15-Feb-22 5 Heathly Food-A 100 1020-Feb-22 Heathly Food-A 100 10 11-Feb-221 6 Heathly Food-A 100 10 19-Feb-221 Heathly Food-B 151 10/15-Feb-221 7 Heathly Food-B 15 10/15-Feb-221 Heathly Food A 100 215-Feb-22 Heathly Food-A 100 211-Feb-22 9 Heathly Food A 100 1020-Feb-22 9 Heathly Food A 100 1020-Feb-221 10 Heathly Food A 100 2/15-Feb-22 10 Heathly Food-A 100 10120-Feb-22 10 Heathly Food-A 100 211-Feb-22 10 Heathly Food-A 219-Feb-22 11 Heathly Food Al 100 1015-Feb-22 11 Heathly Food-B 15 25|15-Feb-22 12 Heathly Food- 100 2/15-Feb-22 12 Heathly Food-A 100 10.20-Feb-22 13 Heathly Food-A 100 10/19-Feb-221 13 Heathly Food-B 151 1120-Feb-22 13 Heathly Food-A 100 211-Feb-22 14 Heathly Food- 100 10 20-Feb-22 15 Heathly Food A 100 1011-Feb-221 15 Heathly Food-B 15 5115-Feb-22 15 Heathly Food A 100 2/15-Feb-22 100 Hypermarket B: Customer ID Product Unit Price of Units Date 1 Healthy Food-AI 2001 101 1-Jan-22 1 Healthy Food-B 20 30 2-Jan-22 Healthy Food-A 2001 23-Jan-22 2 Healthy Food-A 2001 11 4-Jan-22 2 Healthy Food-A 2001 10 5-Jan-22 2 Healthy Food-B 20 1516-Jan-22 2 Healthy Food-A 2001 27-Jan-22 2 Healthy Food-Al 2001 11 8-Jan-22 3 Healthy Food-Al 200 10 9-Jan-22 3 Healthy Food-B 20 5 10-Jan-22 3 Healthy Food-A 2001 2 11-Jan-22 3 Healthy Food-A 200 112-Jan-22 3 Healthy Food-AI 200 10 13-Jan-22 4 Healthy Food-B 20 10 1-Feb-22 4 Healthy Food-A 200 22-Feb-22 S Healthy Food-A 200 11 3-Feb-22 S Healthy Food-A 200 14-Feb-22 6 Healthy Food-A 200 105-Feb-22 6 Healthy Food-A 200 106-Feb-22 7 Healthy Food-B 201 57-Feb-22 7 Healthy Food-B 20 S 8-Feb-22 & Healthy Food-A 200 219-Feb-22 8 Healthy Food-A 200 210-Feb-22 9 Healthy Food-A 200 111-Feb-22 9 Healthy Food-A 200 112-Feb-22 10 Healthy Food-A 200 213-Feb-22 10 Healthy Food-A 200 1/14-Feb-22 10 Healthy Food-A 200 215-Feb-22 10 Healthy Food-A 200 216-Feb-22 11 Healthy Food-A 200 10/17-Feb-22 11 Healthy Food-B 201 2018-Feb-22 12 Healthy Food-A 200 2119-Feb-22 12 Healthy Food-A 200 1 20-Feb-22 13 Healthy Food-A 200 10 1-Feb-22 13 Healthy Food-B 20 12-Feb-22 13 Healthy Food-A 200 21 3-Feb-22 14 Healthy Food-A 200 11 4-Feb-22 15 Healthy Fo 200 105-Feb-22 15 Healthy Food-B 20 S 6-Feb-22 15 Healthy Food-A 2001 27-Feb-22