What is the total quantity sold and total sales

Assignment Help Case Study
Reference no: EM131040177


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

Reference no: EM131040177

Why are engineers not interested in experiments explain

Case Study: Science and Engineering. What does he mean when he says that engineering is top down? Why does this not work for science? Why are engineers not interested in exper

Case study- stratified custom manufacturing

Case study- Stratified Custom Manufacturing, Write a three to four (3-4) page paper in which you: Select a U.S. state or another national government as a point of reference

Type of sexual abuse from which jeremy may be suffering

Fully define, describe, and explain the type of sexual abuse from which Jeremy may be suffering. What type of treatment program would you suggest for Jeremy to participate in

What are the key issues mistine should address

What are the key issues Mistine should address in its strategic planning as it looks to continue its growth and dominance in the Thai market? Discuss - How can Mistine match

Identify the requirements of the company

Identify the requirements of the company and Provide a sample of documentation for one of the elements - implement those parts of your model, which relate to the management o

How vulnerable end-users are leaving themselves

Research and then present the current and future malware that is targeting electronic devices. Students should present the scale and nature of the malware problem and the fu

In what ways is this situation bene?cial to computer users

More than 90 percent of personal computers run a version of the Microsoft Windows operating system. In what ways is this situation bene?cial to computer users? In what ways

Prepare in good form a research memorandum

Acct. 5339-001 Fall Semester 2014 - Based upon the information above, can Oswald claim Zoe as a dependent on his 2014 Federal income tax return and what effect does Harriet's


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd