You have been asked to use SAS Enterprise Guide programs to 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 briefly 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.
Answer:
Introduction
The ABC Retail Company uses a computer-based sales system and want to know about insights to management, for store management, potential market segmentation or new promotional campaigns.
To analysis the requirements the company collected the data for the TRANSACTIONS which contain Sample Table of sales transactions. The data table contains a sample of sales that acquired 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.
The issue related to the study are given below:
Q1. The management want to know about the total amount of money spent per weekend on each shopping week, so it is required to Identifies the week of the basket corresponding to the Spend associated to the items bought. The Format of the week of the basket is YYYYWW where the first 4 characters identify the fiscal year and the other two characters identify the specific week within the year.
Q2. The management want to know about the money was spent by each age group, so it is required to Customer’s Life stage corresponding to the Spend associated to the items bought. The customer life stage is a categorical variable which can be described as, YA=Young Adults, OA=Older Adults, YF=Young Families, OF=Older Families, PE=Pensioners, OT=Other, XX=unclassified.
Q3. The management want to know about total amount of sales of each product in each state. So, it is required to make a cross frequency table for the number of items of the same product bought in this basket, Product Code and store location by state code corresponding to each other.
The management also want to know about total quantity sold of each product in each state. So, it is required to make a cross frequency table for the spend amount associated to the items bought, Product Code and store location by state code corresponding to each other.
Q4. The management want to know about 20 products have the highest sales in value where more than 1 item was sold. So, it is require to make a frequency table for nnumber of items of the same product bought in this basket corresponding to the product code. The product code is a categorical variable which indicates the products.
Q5. The management want to know unique customers does region W01 have. So, it is require to make a frequency table for region the store belongs to and the Customer’s Life stage. The product code is a categorical variable which indicates the products.
Q6. The management want to know about the 5 strategies regarding the above scenarios to enhance this retailer’s business.
Summary findings:
The finding for the issue “Q1. The management want to know about the total amount of money spent per weekend on each shopping week” are given below:
- The minimum amount spent is o and the maximum amount spent is 163.
- The total amount spend in week 7 is 7091, for the week 9 is 7557, for the week 12 is 7416 and for the week 19 is 7543.
iii. The total amount spent in all 4 weeks is 29607.
The finding for the issue “Q2. The money was spent by each age group, so it is required to Customer’s Life stage corresponding to the Spend associated to the items bought” are given below:
- The money spent by Young Adults is 3112, by Older Adults is 3142, by Young Families is 4900, Ob Older Families is 1158, by Pensioners is 1829, by Other is 6334 and by unclassified is 0.
- The total amount spent by all age categories is 20875.
The finding for the issue Q3 that the total amount of sales of each product in each state is 29607 and the total quantity sold of each product in each state is 20875.
The 20 products have the highest sales in value where more than 1 item was sold for Q4 are very less so the retailors should focus on all the products sales.
The Unique customer’s does region W01 have for the question Q5 is 1699.
Overall Conclusion:
The 5 strategies regarding the 5 scenarios to enhance this retailer’s business can be defined as:
- The total amount of money spent for shopping week 7 is 7091, for the week 9 is 7557, for the week 12 is 7416 and for the week 19 is 7543. Thus, the amount spent in shopping increases moderately and then decreases in the week 12. Thus, the retailer should focus on the promotions strategies for each weekend and provided some good offers to customers, so they can come in next weekends.
- The money spent by Young Adults is 3112, by Older Adults is 3142, by Young Families is 4900, Ob Older Families is 1158, by Pensioners is 1829, by Other is 6334 and by unclassified is 0. Thus, the money spent by older families and pensioners is less than other age groups, so the retailors should provide more products and accessories for old age people.
- The finding for the issue Q3 that the total amount of sales of each product in each state is 29607 and the total quantity sold of each product in each state is 20875.
- The 20 products have the highest sales in value where more than 1 item was sold are very less so the retailors should focus on all the products sales.
- The unique customers in the region W01 are 1699. Which is less than the region E01, E02, E03 and W03. So, the retailors should focus on customers in the region W01 to increases the number of customers.
