Reference no: EM131083660
Module 1 - Case
Assumed Certainty: Pivot Tables and Multi-Attribute Decision Making
Pivot Tables and Pivot Charts
Assignment Overview
You are the lead consultant for the Excellent Consulting Group. It is mid-October. One of your top clients, Buddy's Floor Barn, has just closed the books for the first three quarters of the year (January through September). Buddy's Floor Barn requests that you analyze the sales performance of its 5 product lines over this 3-quarter period. From past consulting work you have done for the company, you know that Buddy's Floor Barn has 4 regions and 18 total store locations.
Each Regional Manager at the company has compiled the data for his/her region. The raw data provided consists of the sales revenue for each of the 5 premium flooring lines for all 4 regions and 18 locations for the first three quarters of the current year.
Case Assignment
The data have been provided in list format. Generate a Pivot Table Report with Charts. Use the Pivot Table and Charts to analyze the data. Following your in-depth analysis of the data, write a report to Buddy's Floor Barn in which you discuss and analyze the data, and make appropriate recommendations relative to how Buddy's Floor Barn should improve its sales performance going forward.
Excel Analysis:
- Provide accurate and complete Excel analysis (Pivot Table with Charts).
Written report:
- Length requirement: 4-5 pages minimum (not including Cover and Reference pages). NOTE: You must have 4-5 pages of written discussion and analysis. This means you should avoid use of tables and charts as "space fillers."
- Provide a brief introduction to/background of the problem.
- Using the Pivot Table and Pivot Charts, discuss and analyze the data, noting key highs and lows, trends, etc.
- Include charts from your Pivot Table to support your written analysis. (Please do not use charts as "space fillers." Instead, use them strategically to support your written analysis.)
- In a "Recommendations" section, give clear, specific, and meaningful recommendations that Buddy's Floor Barn should use to improve overall company sales.
- Be sure to consider highs, lows, and trends in the data. Which cities are the highest performers? Lowest? Which regions and quarter had the highest sales? Lowest sales? Consider what may be driving the numbers: Poor marketing? Outstanding marketing strategies? Inventory management? Seasonal sales? Other? There are innumerable possibilities. Your role is to reflect on the data, and ultimately, to use the data to give useful recommendations.
Attachment:- Case Assignment.rar
|
Question regarding the theoretical contract price
: Assume that the Treasury yield curve is flat at 3.2 percent and the annualized dividend yield on the S&P index is 1.8 percent. Using the cost of carry model, demonstrate what the theoretical contract price should be for a futures position expiring..
|
|
When the peak years when smokers start to smoke
: The World Health Organization estimates that, in the twentieth century, _____ million people died prematurely of tobacco-related diseases.
|
|
Determine the number of colorings of the grid
: Math 171: Abstract Algebra, Fall 2014- Assignment 6. A coloring of the grid below is an assignment of colors to its triangular cells, where any given triangular cell is colored red or green. Determine the number of colorings of the grid
|
|
Find the concentration of a solution of tryptamine
: Find the concentration of a solution of tryptamine that reacts at a rate of 0.18 μm/min in the presence of monoamine oxidase under the above conditions. Assume that [tryptamine] « Km.
|
|
Pivot tables and multi-attribute decision making
: Pivot Tables and Multi-Attribute Decision Making - write a report to Buddy's Floor Barn in which you discuss and analyze the data, and make appropriate recommendations relative to how Buddy's Floor Barn should improve its sales performance going fo..
|
|
Calculate the company debt-to-equity ratio
: Boulder Mountain Ski Company has total assets of $474,300,000 and a debt ratio of 0.30. Calculate the company's debt-to-equity ratio.
|
|
Question regarding the level of inventory
: Soaring Eagles Corp. has total current assets of $11,372,000, current liabilities of $5,572,000 and a quick ratio of 0.85. What is its level of inventory?
|
|
Write a primary source analysis paper about muslim empires
: Write a three to four page primary source analysis paper about Muslim Empires. Please be plagarism free, paper will be submitted through plagarism checker.
|
|
What are the appropriate uses of a budget
: Why is budgeting important? What are the appropriate uses of a budget? How can budgets be mismanaged or misunderstood? What are some criteria you would use to choose between a fixed and a flexible budget? Explain your answers.
|