Reference no: EM131040177
REQUIREMENTS
You are a member of a business intelligence team supporting management of ABC Retail Company. The company uses a computer-based sales system. You are provided with the following data table:
TRANSACTIONS SampleTableof sales transactions. (Refer to Appendix 1)
The TRANSACTIONS table contains a sample ofsales that took place over a period of various weeks, after all transactions have been posted. The transaction information includes not only date and time, but also demographic, geographic and product information.
You have been asked to use Base SASprogramsto analyse the TRANSACTIONS, and provide information and insights to management, for store management, potential market segmentation or new promotional campaigns. You are to produce a management report with sections dealing with each of the issues on the next page. Your report should cover each issue and include (where appropriate) a summary of findings.
For each issue, comment on what you found, its significance, and its implications for the company.You should support your findings with appropriately labelled and totalled reports generated with SAS (in html format). See Appendix 2 for information on generating reports.
Report headers should identify the company, the time period covered, your name and the title of the report. All SAS reports should be sorted in a manner, which focuses attention on thehigh valueitems. Submit these SAS reports along with your management report. Also, you are required to submit your Base SAS programs used to generate these reports.
1. Descriptive Analysis
Q1. What is the total quantity sold and total sales in value of each product in each region during the period?
Q2. Which20 products have the highest sales in value during the period.
Q3. Which day of the week produces the most sales in value?
Q4. On each day of the week, when is the busiest shopping hour, in terms of number of products sold?
Q5. What is the distribution of spending during a week by customers according to customer price sensitivity, basket size, and basket price sensitivity?
Q6. What's the total number of sold products in region E01 in week 200607?
Q7. What's the total amount of money spent per weekend?
Q8. How many unique customers does region W01 have?
Q9. Based on number of unique customers, what are the top 3 busiest days of your dataset and to which week(s) do they belong?
Q10. Describe the distribution of spending in a week of your choice based on customer lifestage,?
2. Creative Insights
Q11. How would you use the results of these reports to enhance this retailer's business?
Q12. Suggest 5 strategiesthat can be implemented to improve operational efficiency, customer satisfaction and business revenues?
Attachment:- Assignment.rar
Past decade that affect barbecue sauce manufacturer
: In what ways have American eating habits changed over the past decade that affect a barbecue sauce manufacturer? How can Ken Davis Products do marketing research on consumers to find out what they eat, to learn how they use barbecue sauces, and to ge..
|
Evaluate whether it exhibits the features of good tax system
: BULAW3731 Income Tax Law & Practice Assignment Topic. Identify and explain the key areas of the Policy, then evaluate whether it exhibits the features (characteristics) of a good tax system
|
What is the formula for the net interest margin
: Floating-Rate Loans Does the use of floating rate loans eliminate interest rate risk? Explain.
|
Summarize five models used to organize training departments
: Identify and summarize five models used to organize training departments. If you were the Vice President of Human Resource Training, which model would you choose to organize your department? Explain why you would choose this model
|
What is the total quantity sold and total sales
: 7117IBA Applied Case Study. Descriptive Analysis - What is the total quantity sold and total sales in value of each product in each region during the period? And which20 products have the highest sales in value during the period
|
Describe the method in which ge has grown the organization
: Using the Ansoff matrix, describe the method in which GE has grown the organization? What were the drivers for growing in this manner? Which of the three types of corporate parent is GE? Support your answer by the characteristics of GE’s parenting st..
|
Find the radius that optimizes the surface area of the can
: WRITE a formula for the surface area of a can with that volume. Your surface area function will originally have two variables (height and radius). Remember, we are holding the volume constant. So use that fact to write the height in terms of th..
|
Combination of waiters and busboys
: 1) Is this combination of waiters and busboys the optimal? 2) Based on your answer above, what kind of changes should Sarah make?
|
When learning about time signatures
: When learning about time signatures, we discussed the fact that many times the time signature is related to a dance. For this discussion board, find a piece of music that was written specifically to dance to. It may be an old dance, a new dance, or a..
|