Question: can someone pls help me with this probke? Problem 2: Worksheet 'customers' has the R (recency), F (frequency), and M (Monetary value) related information for

can someone pls help me with this probke?  can someone pls help me with this probke? Problem 2: Worksheet
'customers' has the R (recency), F (frequency), and M (Monetary value) related

Problem 2: Worksheet 'customers' has the R (recency), F (frequency), and M (Monetary value) related information for the representative 10 customers of a home store. Recency is the number of months since the last purchase made by the customer. Frequency is the average number of times the customer comes to the store for purchase. Monetary value is the average dollar value of the transactions that the customer makes with the store. The home store has decided to introduce loyalty programs to the customers whose recency is not more than 6 months, frequency is at least 4 times a year, and the average monetary value is more than $150. The store wants to offer cashback promotion to such loyal customers. For the rest of the customers, the store wants to offer coupons based promotion. Use appropriate formula to determine the type of promotion offered to each customer in the Promotion Type column of the worksheet 20 Points Exam2V1 (2) - Excel Acrobat Team Telly Accounting Copy $ - %, 8. Conditio Formattin Number K L M File Home Insert Page Layout Formulas Data Review View ChemOffice17 Xcut Calibri 11A == . Wrap Text BIU. . OA-EEEEE Merge & Center - Format Painter Clipboard 5 Font G Alignment D11 - x x 30 D E F G H I J 1 Customer Recency (Frequeno Average Promotion Type (Cashback or coupon) 4 $460.00 1 S 58.00 8 $ 126.00 2 $ 70.00 0 $ 400.00 2 $ 158.00 12 $112.00 1 $ 490.00 2 $ 48.00 3 $ 30.00 00 cartoant customers Product Catalog Orders carloan2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!