7117-IBA ABC Retail Company Transactions For Sales Transactions Analysis : Fountain Essays

Question:

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:

  1. The minimum amount spent is o and the maximum amount spent is 163.
  2. 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:

  1. 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.
  2. 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:

  1. 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. 
  1. 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.
  1. 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. 
  1. 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.  
 
  1. 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.

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Order your essay today and save 25% with the discount code: COCONUTPlace Order
+