Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are employed by a supermarket chain which has recently begun offering a new line of organic products. Senior management of the supermarket want
You are employed by a supermarket chain which has recently begun offering a new line of organic products. Senior management of the supermarket want to identify which customers are likely to purchase these products. They have asked you to analyse some existing data and make a recommendation to assist them with this task. The supermarket has a customer loyalty program. As an initial buyer incentive plan, the supermarket provided coupons for the organic products to all of the loyalty program participants and collected data from their purchases, including whether these customers purchased any of the organic products. Required You need to perform an analysis to identify which customers are likely to purchase organic products. It's up to you to decide which data items are meaningful, you will need to play around or a while to build an understanding of how the patterns for each data item are playing out. You require to use charts to more accurately visualize the data patterns. 1. Once you have identified your target customers you require to prepare a brief report (maximum 300 words) suitable for senior management. Make sure you include a clear recommendation identifying which customers should be targeted as a priority for future promotions involving organic products. You need to justify your target recommendation by referring to the analytical results you obtained (10 marks). 2. You must incorporate three charts to visually illustrate the patterns you relied on when you selected your target customers (10 marks). The ORGANICS data set is available through the LMS and contains 13 variables and more than 22,000 observations. The variables in the data set and a brief description of each are shown below (please refer to the next page). An Excel file that Includes the charts must be submitted to the LMS. Report should be submitted in a separate MS Word file to the LMS. Name Description ID Customer loyalty identification number DemAff Affluence grade on a scale from 1 to 30 DemAge Age, in years DemCluster Type of residential neighborhood DemClusterGroup Neighborhood group DemGender M= male, F female, U = unknown DemRegion Geographic region DemTVReg Television region PromClass Loyalty status: tin, silver, gold, or platinum PromSpend Total amount spent PromTime Time as loyalty card member TargetBuy Organics purchased? 1= Yes, 0 = No TargetAmt Number of organic products purchased DenA DemAge DemCluster DemOuterireup DemGender Demteg DemTVReg PromClass Promdpend Promtime Targetbuy TergetAnt 9O 040 10 76 16 Midiands Midiands Wales& West Gold wales & West Gold 16000 A. 40 GO00 27 Midiands wales&West Siver 0.02 10 M Midiands Midands Tin 0.01 00 04 Midiands Midands Tin 0.01 72 North NWest Platinum 20759 81 74 Midlands East Tin 0.01 13 32 North N East Tin 0.01 30 62 49 Midland East Sver 20, 76 14 43 49 Gold 1.
Step by Step Solution
★★★★★
3.44 Rating (157 Votes )
There are 3 Steps involved in it
Step: 1
The supermarket lines organic data contains vital information that can influence how the management ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started