Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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? image text in transcribed
image text in transcribed
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

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

Information Systems Control And Audit

Authors: Et Al. Hyo-Jeong Kim, Michael Mannino, Compiled By Koros Press Editorial Board

1st Edition

1781639426, 978-1781639429

More Books

Students also viewed these Accounting questions