How sunshine floor barn should improve sales performance

Assignment Help Accounting Basics

Reference no: EM131945473

Case: Pivot table and multi-attribute decision analysis

Assignment Overview: You are the lead consultant for the Diligent Consulting Group. It is mid-October. One of your top clients, Sunshine Floor Barn, has just closed the books for the first three quarters of the year (January through September). Sunshine 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 Sunshine 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 Sunshine Floor Barn in which you discuss and analyze the data, and make appropriate recommendations relative to how Sunshine Floor Barn should improve its sales performance going forward.

Information related to above question is enclosed below:

Attachment:- Assignment.rar

Reference no: EM131945473

Questions Cloud

Define and provide examples of touch points : Select an organization that you purchase products or services from and identify the organization's touch points.

Many molecules and steps : How could you explain to them WHY cellular respiration involves so many molecules and steps based on how life obeys and exploits the Laws of Thermodynamics?

Perform a qualitative risk analysis : Describe at least 5 risks for your project. Use the categories you described in Unit 1 to help you define the 5 risks.

Will johnny be successful if he files a lawsuit alleging : Lulu phones Peter and tells him he is in breachbecause the pants are the wrong color. Which of the following statements is true?

How sunshine floor barn should improve sales performance : 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.

Segmental arrangement of the embryonic paraxial mesoderm : Describe the segmental arrangement of the embryonic paraxial mesoderm, and its relationship to adult mesodermal derivatives.

Write a problem solving report in direct format : Write a problem solving report in direct format (after brief intro, the recommendations come first) addressing President Wisner's request(s) found in the text.

Trace blood from point of origin : The assignment is a blood tracer. It asks to "trace blood from point of origin (the right brachial vein) to the upper left leg

Determine the phenotypic ratio of offspring for cross : Use a Punnett Square to determine the phenotypic ratio of offspring for this cross: A heterozygous purple plant crossed with a homozygous purple plant.

User Account

All Pages