Reference no: EM133500709

Background:

A new ownership group has recently purchased ABC Graphics. You have been hired by the new management team to analyze their sales data for the past year and provide them with insights about their new company that will help their long-term success. Management provided you with sales data, and some other information related to vendors, employees, products and stores. Being so knew to the business, Management won't be of much help outside of this document as their background is real estate and not retail. Management provided the following requests, all of which must be completed accurately to obtain full payment (in your case a perfect score).

Management Request:

Perform the following five descriptive analytics to help Management understand the business environment. Management has requested a write-up, describing what you found. Appropriate visualizations should be included to back up your claims. (30 points total, 5 points for the writeup, and 5 points for accuracy of each analysis)
Sales dollars by store and product size. Which combination of store and size was the most popular, what was the least? (5 points)
Sales quantities by vendor. Who were the top 5 vendors and bottom 5 vendors from an overall quantity perspective (5 points)
Sales Dollars by employee by store. Which employee sold the most in each location (5 points)
Net Income in Dollars by Store by Month. Which stores were profitable, and which were not? What month had the highest profit overall across all stores, which month was least profitable? (5 points)