Case pivot table and multi-attribute decision, Ask an Expert

Accounting

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

View complete question

Accounting Basics, Accounting

Category:- Accounting Basics
Reference No.:- M92784129

Have any Question?Write your Review or question?

Related Questions in Accounting Basics

Question - at december 31 2016 grouper corporation reported

Question - At December 31, 2016, Grouper Corporation reported current assets of $384,870 and current liabilities of $206,100. The following items may have been recorded incorrectly. 1. Goods purchased costing $22,150 wer ...

Question - phil goode will receive 112000 in 19 years his

Question - Phil Goode will receive $112,000 in 19 years. His friends are very jealous of him. If the funds are discounted back at a rate of 14 percent, what is the present value of his future "pot of gold"?

Question - mr young operates a photography studio as a sole

Question - Mr. Young operates a photography studio as a sole proprietorship. His average annual income from the business is $100,000. Because Mr. Young does not need the entire cash flow for personal consumption, he is c ...

Question - blue co reported 150000 of net income for 2017

Question - Blue Co. reported $150,000 of net income for 2017. The accountant, in preparing the statement of cash flows, noted the following items occurring during 2017 that might affect cash flows from operating activiti ...

Question - brankov company has current assets of 95000 and

Question - Brankov Company has current assets of $ 95000 and current liabilities of $110,000. The company decides to issue stock and receives cash of $100,000. After this transaction, the company's current ratio will be: ...

Question - greg owns and operates an illegal gambling

Question - Greg owns and operates an illegal gambling establishment. In connection with this activity, he has the following expenses during the year: Rent - $28,000 Bribes - $80,000 Travel - $16,000 Utilities - $24,000 W ...

Question - on july 1 2016 alpha company purchased for 70000

Question - On July 1, 2016, Alpha Company purchased for $70,000, equipment having a service life of eight years and an estimated residual value of $10,000. Alpha has recorded depreciation of the equipment using the strai ...

Question - poe inc had the following bank reconciliation at

Question - Poe, Inc. had the following bank reconciliation at March 31, year 2: Balance per bank statement, 3/31/Y2 $46,500 Add deposit in transit 10,300 56,800 Less outstanding checks 12,600 Balance per books, 3/31/Y2 $ ...

Question - jabiru corporation purchased a 20 interest in

Question - Jabiru Corporation purchased a 20% interest in Fish Company common stock on January 1, 2002 for $300,000. This investment was accounted for using the complete equity method and the correct balance in the Inves ...

Question -a calculate the ending balance of the

Question - (a) Calculate the ending balance of the Manufacturing Overhead account for November. Lawler and Associates, a C.P.A. firm, uses job order costing to capture the costs of its audit jobs. There were no audit job ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Accounting Basics Expert