You are employed by a supermarket chain which has recently begun offering a new line of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
The supermarket lines organic data contains vital information that can influence how the management ... View the full answer
Related Book For
Materials and process in manufacturing
ISBN: 978-0471656531
9th edition
Authors: E. Paul DeGarmo, J T. Black, Ronald A. Kohser
Posted Date:
Students also viewed these accounting questions
-
You are employed by a firm engaging in heavy manufacturing. Its direct materials are sourced globally, but its nonoperating inputs are sourced from a variety of U.S. vendors. You have been charged...
-
You are employed by a firm that produces tangible products. These products are then sold to a consuming populace that is unaffected by place, income, sex, race, age, or any environmental concerns....
-
The Constitution in Your Community You are employed by a law firm that has been retained by Mae Shen, a prominent and wealthy business leader in your community. Dissatisfied with your citys support...
-
Best Buys GeekSquad performs computer and home theater installation and service, for an upfront flat price. How can Best Buy use a job order costing system?
-
A painter has three different jars of paint colors available, in colors green, yellow, and purple. She wants to paint something abstract, so she blindfolds herself, randomly dips her brush, and...
-
Bill incorporated his business four years ago and owns 100 percent of its stock. The corporation distributes a piece of land, used as a parking lot for the customers, to Bill. Bills basis in his...
-
A six cylinder, four stroke petrol engine has the following data: bore \(=8 \mathrm{~cm}\), stroke \(=10 \mathrm{~cm}\), clearance volume \(=70\) c.c., speed \(=4000 \mathrm{rpm}\), consumption \(=20...
-
1. What do you think the construction project manager should have done when the Director of Security stopped attending the project meetings? 2. Do you think it is an effective communications tool to...
-
Harding Corp., a lamp manufacturer, provided the following information for the year ended December 31, 2024: (Click the icon to view account balances.) (Click the icon to view other information.)...
-
Three years ago, the Oak Street TCBY bought a frozen yogurt machine for $8,000. A salesman has just suggested to the TCBY manager that she replace the machine with a new, $12,500 machine. The manager...
-
(a) Using Newman projections, draw all staggered and eclipsed conformations that result from rotation around the bond highlighted in red in each molecule; (b) draw a graph of energy versus dihedral...
-
21. The Wilson Company has provided the following information: Net sales, $200,000 Net operating income, $40,000 Net income, $20,000 Average total assets, $125,000 Average net fixed assets; $80,000...
-
How many grams of calcium chloride, CaCl2 (110.98 g/mol), are needed to make up 271 mL of a solution that is 0.491 M? Report to one decimal point. T I
-
a) Find the price of a 7-year maturity semi-annual bond with a coupon of 6% (annualized) and a continuously compounded yield of 5%. Use continuous compounding. b) Suppose instead that the price of...
-
What would be the volume ( cm 3 ) of a piece of Styrofoam if it had a mass of 3 5 0 g , no matter its shape? Show calculation.
-
Explain how you can use the logarithm function in a business calculation.? Give one example for the same.
-
Baby Steps Company makes AJES at year-end of December 31 only (i.e. no monthly AJES are made). Prepare the December 31 adjusting journal entry below for each situation. PREPAID ASSET AJE a) On...
-
Wal-Mart is the second largest retailer in the world. The data file on the disk holds monthly data on Wal-Marts revenue, along with several possibly related economic variables. a) Using computer...
-
What are some of the ways in which a steel product might be hardened to a greater depth?
-
What is the DCL?
-
Why is the atomic radius of an atom often assigned different values for different crystal structures?
-
Most countries in Europe do not have stringent laws to protect whistleblowers. True/false
-
In view of significant financial losses to investors, corporate fraud does not really affect the U.S. economy and investor confidence. True/false
-
The National Crisis Inquiry Report (2011) concluded that the financial crisis was unavoidable. True/false
Study smarter with the SolutionInn App