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

Previous Q& A

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

  Closing case cengage uses information technology

The Problem Cengage Learning (www.cengage.com) is the second-largest higher-education textbook company in the United States. It has 5,500 employees, generates revenues of approximately $2 billion, and operates in more than 20 countries. The compan..

  What is the equilibrium price of laptops

Consider the market for laptops. The demand for laptops is Q = 1800 - 3P. Suppose the supply of laptops is given by Q= -200 +2P. Enter numbers only. If decimal, include decimal and round to nearest tenth. What is the equilibrium price of laptops?

  What does that mean to you as a manager

What are the major capital budgeting models and why are they essential to the firm's earnings, capital growth and value creation?

  Sales and operations planning can be integrated

Summarize the ways through which sales and operations planning can be integrated. Then, extend your findings to additional supply chain management processes that you feel could be better integrated. Which two (or more) processes did you integrate? Wh..

  Accused of artificially undervaluing

China has been accused of artificially undervaluing their currency over the past several years. If that is true, what is the impact on the United States and on China as those two countries are the largest two economies in the world?

  Most effective private cybercrime fighters

Fire Eye (www.fireeye.com) is one of the world's most effective private cybercrime fighters. The company defends corporations and governments against targeted malicious software. Fire Eye's clients include Fortune 500 companies and members of the ..


Write a Review


Similar Q& A

  Product design and global distribution

Watch an NBA quoteunquote team that's got this superstar that totally just wants to be the stud and doesn't work well with anybody else

  What are sources of risks faced by global supply chain

What are the sources of risks faced by the global supply chain - How can companies mitigate these risks?

  External memo of law and an internal memo of law

Difference between an external memo of law and an internal memo of law - Brief any cases that you are planning on citing to in your appellate brief.

  Develop a set of own responsibilities objectives

Develop a set of own responsibilities and performance objectives and evaluate own effectiveness against defined objectives

  Why do you want to proceed with project

Why do you want to proceed with this project? What research do you have to support your project and who will be assisted? Who is the target group, the demographic?

  Analyzing a case study- apple inc

Case Study: Apple Inc., Analyzing a Case Study and Writing a Case Study Analysis

  Who are the relevant market and nonmarket stakeholders

Case: A Brawl in Mickey's Backyard, Who are the relevant market and nonmarket stakeholders in this situation

  Strategy of matching the inmate to the correctional facility

Develop a profile of the so-called perfect candidate to participate in an intensive supervised probation program. The profile should contain at least three attributes that you believe make this defendant the perfect candidate for this type of prob..

  Case study - faster flying- just add two more engine

Case Study - Faster Flying- Just add two more engine. Introduction and summary of case study and Identify the problem with Heading

  Write a research paper about a topic related to your major

Write a research paper about a topic related to your major or intended career, which follows the problem solution strategy.

  Describe various factors that are analyzed to study

describe various factors that are analyzed to study demographic profiles and theirimportance in tourism

  The airlines fault because of safety violations

Research an air incident that was considered to be the airlines fault because of safety violations. Give the details of the cases and the url for the case (only include the url at the end of the post). Lastly, give your opinion of why airlines cut sa..

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