BUS 520 Module 1 Case
antony34Module 1 - Case
ASSUMED CERTAINTY: PIVOT TABLES AND MULTI-ATTRIBUTE DECISION MAKING
Assignment Overview
You are working as a data analyst for the Excellent Consulting Group. Your client, Buddy’s Floor Barn, wants to analyze how they are doing in their 18 locations in four regions across their five product lines over the last 3 quarters. Each Regional Manager has compiled the data for his/her region showing the sales revenue for each of the five product lines (premium flooring) for each of the first three quarters.
Case Assignment
Assemble the data from each Store Manager into a data table in list format. And then generate Pivot Table Report. Use this report to analyze the data to answer Buddy’s questions. Write a business report to Buddy’s Floor Barn that provides the answers and discusses the issues.
Data: Download Case 1-Data.xlsx with the data from the four regional managers for the first three quarters showing sales of their five premium flooring products.
Assignment Expectations
Analysis:
- Accurate and complete analysis in Excel.
Written report:
- Length requirements = 4–5 pages minimum (not including Cover and Reference pages)
- Provide a brief introduction/ background of the problem.
- Complete and accurate Excel analysis.
- Written analysis that supports Excel analysis, and provides thorough discussion and analysis of assumptions, rationale, and logic used.
- Complete, meaningful, and accurate recommendation(s).
- 8 years ago
- 20
Purchase the answer to view it
- pivot_table_1.xlsx
- performance_management.docx
- Cultural Mistakes
- Assignment 2: Job Evaluation at MPBS Review the team report on MPBS located in the Case Study Overview. In this assignment you...
- Database 6
- Calculations Shown
- Marketing
- case analysis
- A stationary power plant operating on an ideal Brayton cycle has a pressure ratio of 8. Gas temp is 300k...
- The Organization and the People in It Your textbook, Moral Issues in Business, Eleventh Edition, by William H. Shaw and Vincent Barry, Answers For: Read in the Read in Pages 413–470 Pages 472–534 Pages 536–605 Pages 606–657 1. The Sarbanes-Oxley Act of
- BUSN 460 Senior Project Week 5 Discussions Devry
- NETFLIX 1167