Jul 16, 2017

# Analysis of the Data

This paper concentrates on the primary theme of Analysis of the Data in which you have to explain and evaluate its intricate aspects in detail. In addition to this, this paper has been reviewed and purchased by most of the students hence; it has been rated 4.8 points on the scale of 5 points. Besides, the price of this paper starts from £ 40. For more details and full access to the paper, please refer to the site.

# Analysis of the Data

INSTRUCTIONS:

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 10 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 using the MADM model and theory.

Written report:

• Accurate and complete review of the situation.
• Accurate and complete discussion of the analysis.
• Accurate and complete Recommendation
• Accurate and complete explanation of the rationale and logic.
CONTENT:

STEW-MOD1-CASE-520 Student: Institution: Analysis of the data The MADM model and theory is used to analyze on the given data. The abbreviation refers to Multiple Attribute Decision Making. It is a theory used by organization in order to analyze on the sales of products and hence evaluate on the performance over a certain period of time. Through this analyses that are carried out an organization can be able to asses itself as it can be able to make out on its strengths, weakness, opportunities and threats. The following is an analysis of the four managers in the different regions of the organization. Table Q1Q2Q3TotalEast940, 349770,806889, 1072,620,256South1,019,4371,066,1111,074,3133,159,861Mid states956,056870,157874,1432,700,356West 1,081,945

...

100% Plagiarism Free & Custom Written,