What is the total quantity sold and total sales

Assignment Help Case Study
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

Reference no: EM131040177

Questions Cloud

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

Reviews

Write a Review

 

Case Study Questions & Answers

  Discuss the use of pallets in a shipping system

Discuss the use of pallets in a shipping system. What considerations must be taken when deciding whether or not a pallet is required for a specific shipment of boxes?

  What accounts for andy garafallo'' success in business

What accounts for Andy Garafallo's success in the restaurant business? From a skills perspective, how would you describe the three managers: Kelly, Danielle, and Patrick? What does each of them need to do to improve his or her skills

  Discuss the systems integration solutions at ups

What are some of the system integration challenges faced by UPS and discuss the systems integration solutions at UPS. How does. it help UPS integrate new technologies?

  What were the rights of walmart

What were the rights of Walmart, the employer, during these two organizing drives? The certification of the first Walmart was hailed by labour as a milestone event. Why? In your opinion, can Walmart remain union free indefinitely? Why or why not

  Case study on forced decryption ruled unconstitutional

Analyze the decision by the 11th U.S. Circuit of Appeals to determine whether you believe the decision rendered was correct or incorrect based on the evidence suspected by the government

  Evaluate the positives and negatives of the business plan

Evaluate the positives and negatives of the Business plan - Individual Case Study response on any suitable business Plan

  The road haulage role in intermodalism

After evaluating the reading, please take one of the topics and describe it to the class - In your description, include a short synopsis of the issue and your opinion of the issue.

  Discuss two to three significant opinions

Discuss two to three significant opinions that this justice has drafted - either as majority opinions, concurring opinions, or dissenting opinions. Your discussion should include the justice's decision in the case, the Court's decision, the justice's..

  Examine the dissenting opinion of justice douglas

Examine the dissenting opinion of Justice Douglas, as discussed in the case. Discuss the origins and importance of probable cause as it relates to law enforcement's discretion to search Terry's car in this case

  Brief review of the key points of the case study

Brief review of the key points of the case study, with the review connected to the key points you are going to draw from the literature

  State the risk of understatement

State the risk of understatement/overstatement and the audit evidence to be collected to verify the financial report assertions of the items - Inventory

  Explain infosys technologys success in global marketplace

According to Hofstede's research, India has a high score on the power distance dimension. To what degree could this high score help to explain Infosys Technology's success in the global marketplace?

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