Analysis Assignment 6 – Sugarland Outfitters Data Analysis
Case Narrative
You are the Senior Manager of Problem Solving and Decision Making for Sugarland Outfitters.
Sugarland Outfitters, a division of Planet Pants Depot, is a chain of men and women’s adventure apparel stores operating throughout the western hemisphere in upscale shopping locations. The chain recently ran a promotion in which discount coupons were sent to customers of other Planet Pants Depot stores.
Data collected from a sample of 100 in-store credit card transactions at Sugarland Outfitters during one day while the promotion was running is contained in the file named BUSI 5413 Sugarland Data.xlsx. Table 1 shows a portion of the data set.
The Proprietary Card method of payment refers to charges made using a Planet Pants Depot charge card. Customers who made a purchase using a discount coupon are referred to as promotional customers, and customers who made a purchase but did not use a discount coupon are referred to as regular customers. Because the promotional coupons were not sent to regular Sugarland Outfitters customers, management considers the sales made to people presenting the promotional coupons as sales it would not otherwise make. Of course, Sugarland also hopes that the promotional customers will continue to shop at its stores.
Using the Case Narrative and the Excel database provided (Sugarland Data.xlsx), prepare a formal Report to Management. The Report will be delivered to the Sales Evaluation Committee. Members of the Sales Evaluation Committee are,
- Chief Executive Officer, Planet Pants Depot
- Vice President of Finance, Planet Pants Depot
- Vice President of People (Human Resources), Planet Pants Depot
- Regional Marketing Manager (Minneapolis Region), Planet Pants Depot
- Chief Operating Officer, Sugarland Outfitters
- Vice President of Marketing, Sugarland Outfitters
- Retail Marketing Manager (Kansas City Region), Sugarland Outfitters
- Store Manager (Amarillo, Texas), Sugarland Outfitters
Prepare and deliver the formal Managerial Report as instructed. It would be best if you assumed that members of the committee are not experienced in data analysis. Therefore, your report should be prepared for the unsophisticated data consumer. Concisely describe the results. Consider the number of Marketing individuals involved. Lots of pictures are recommended.
The Managerial Report requirements include the tabular or graphical presentation requested and a concise narrative of what the data tells the unsophisticated reader.
Assignment Requirements
Use tabular and graphical methods of descriptive statistics to help management develop a customer profile and evaluate the promotional campaign’s impact. At a minimum, your report should include the following, well presented:
- Percent frequency distribution for key variables,
- A histogram and a pie chart showing the number of customer purchases attributable to the method of payment. (HR people love pie!)
- A scatter diagram to explore the relationship between net sales and customer age.
- A cross-tabulation of type of customer (regular or promotional) versus net sales,
- Descriptive statistics concerning the relationship between age and net sales,
- Descriptive statistics of net sales by various classifications of customers.
- Does the data suggest any customer focus for Sugarland Outfitters? For Planet Pants Depot?
- Is there a positive relationship between net sales and age? Or? Explain.
- Should Sugarland continue including Planet Pants Depot stores in their promotions? Why or why not?
- Comment on the sample size and strengths and weaknesses of the data. What suggestions do you have for the data collection?
- Your concise commentary on any similarities or differences present in the data will be of considerable value.
Most of the variables shown in Table 1 are self-explanatory, but two of the variables require some clarification.
Variables | Description |
Items | The total number of items purchased, i.e., two pairs of shoes = two items |
Net Sales | The total amount ($) charged to the credit card |
Planet Pants Depot s management would like to use this sample data to learn about its customer base and evaluate the promotion involving discount coupons.
Table 1 BUSI 5413 Sugarland Data.xlsx
Note 1: You must show all your work (including all calculations) step by step to earn credit. Answers alone are not sufficient. Failure to include the Excel worksheet will result in substantial penalties, more likely no credit for the assignment. It is the “show your work” thang.
Note 2: Save your management in a Word file. The required file name standard is, LastNameFirst initial_AA6. Example: TimmonsR_AA6. docx. If an Excel file, example: TimmonsR_AA5. xlsx.
How to View Instructor Feedback on Assignments Written Tutorial
Please note when naming your assignment submission file, MyFIRE will not accept documents with special characters in the title. For more information as to which special characters cannot be used, please visit: https://owasp.org/www-community/password-special-characters