Answered You can buy a ready-made answer or pick a professional tutor to order an original one.
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 (Janu
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.
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.
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 Sunshine 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.
- @
- 1030 orders completed
- ANSWER
-
Tutor has posted answer for $150.00. See answer's preview
******** ***** Barn ***************************** ***** **** ************************** Floor **** *** completed compiling the results *** *** ***** ***** ******** *** ******* *********** **** ********** performance assessment is ******** for the future progress ** the ******* (Ewards ***** **** ****** ********* *** *********** ** Sunshine Floor **** ** *** first ***** ******** *** **** ********* by *** lead ********** at ******** ********** ***** Currently ******** ***** ******** ** **** ******* ****** the ******* ** *** ****** ******** in 18 ********* and * product ***** Regional managers **** ******* ******** ***** sales ******** *** *** 5 ******* lines *** ****** **** ** ********* *** ***** *********** in *** **** ******* across the **** ******* lines Pivot Tables *** ***** ****** will ** used to ******* *** raw **** **** *** ******** managers *********** trends will be identified across *** ******* ** better understand *** ******* ******* *************** for *********** ************ *** ******** Floor Barn **** ** provided at *** end of *** ************* PerformanceThe total ***** *** *** three ******** **** ******** ** * ******** ** *** ***** ******* *** ***** **** ** * ******* *** * ******* ** ******* 2 In the ***** ******* *** ***** revenues **** ** $ ******* ******* one had *** ******* sales revenues ***** ******* three *** *** worst ***** revenues ********* *** *********** as * percentage one can ******** that *** ***** *** *** ******* *** stagnant ****** *** ******** Chart 1 ***** **** quarter * sales are 34% ** *** ***** ***** ******* * *** 3 *** *** **** ** *** ***** ******** The ******* ******* ********* **** *** sales are stable ****** *** ******* * ****** *********** ***** **** *** sales are decreasing ** a **** **** ********* 1Regional PerformanceThe *********** *** not ****** **** **** *** ******* ***** ******** ** the **** **** $2 ******* *** ********** $ ******* *** South * 3210361 and *** **** * 3309949 ** shown in ***** * *** **** ********** ****** was *** **** ***** *** East ******** *** ****** sales revenues ** percentage *** **** had 28% ** *** revenues the ******** ****** ******** *** ** *** ******** *** *** mid-States region ******** *** of the ******** while the Easter ****** **** ******** 22% ** *** ***** revenues *** **** *** *** mid ****** ******* **** have stored ** **** locations ***** the southern ****** *** *** Western region have **** ***** locations ** ** ******** **** the ******* **** **** ********* ********* better ***** ******** **** the ******* **** lesser ****** Regions **** equal ***** ******** ******* only ********* * ** ********** ** *********** ** *** ** concluded that *** **** had ****** performance **** *** **** *** ** ***** ***** ************** 2Location ************* the **** Buffalo **** *** the ***** sales ** * 643865 and ********* *** *** highest ***** ** ******* ** *** Mid-West ******* **** had *** ***** ***** ** $ ****** *** ******** **** had *** ******* ***** ** ******* ** *** ***** *** ******* **** *** the ***** ***** ** * ****** and ************ *** *** ******* ***** ** ******* ** **** San ***** **** *** the least ***** ** * ****** *** Boise *** *** ******* ***** ** ********** **** that *** *** ***** performance *** New Orleans **** **** *** sales ******** of * ****** *** ******* sales ******** **** ******** ** ******** **** * 734175 These ******** show **** *** ******* **** exhibited ****** *********** only managed ** ** so ******* ** *** extra ********** ************* of average *********** ******** an ******* **** *** ******* ***** *********** The ******* ******** *********** *** *** whole ******* is $ 660 256 (11884622/18) *** **** *** ** ******* performance of * 661990 *** *** ***** had ** ******* performance ** * 642072 *** ******** *** East *** ** average *********** ** $ ****** *** location ***** the ********** *** * performance ** * ****** *** ***** From *** ******** *** **** ********** ********* *** **** the ********** ***** *** ***** ********** ********* *** **** the ***** ***** ******* results prove **** *** ****** ** ********* **** indeed ********* the total ******** **** **** ****** In *** ******* ******** ***** ** ***** ******** the **** *** ** *** *** ******** ** *** ***** ***** was ******** by *** Mid-States *** ******* the **** ** *** average ********* *** Mid-States ** ** *** *** ******** ** *** **** followed ** *** **** *** ******* *** South ** ******* the locations **** **** ********* *** better performing ****** **** those locations **** **** ************* **** ************** ************ ******* ** the **** was ******** **** * ****** and *** ***** *** Oak **** $ ****** ** *** ********** *** ************ ******* *** ***** **** * ****** *** *** worst *** ****** **** * 492194 ** sales ** the ***** *** best-selling ******* **** *** ****** **** $680419 ** revenue *** the worst was ***** with * ****** In the West *** ************ ******* was Bamboo with $689865 *** Cherry *** *** ***** ** $639791In ******* ****** had * ***** revenue ** ******** ******** *** $ ******* ****** *** * ******* ***** *** $ ******* *** *** *** $ 2303423 ** ********** ***** shown by chart 3 ****** *** *** ** *** revenues ******** had *** of the ******** ****** *** *** ** *** ******** ***** *** *** ** *** ******** *** Oak *** *** ** *** ******** ****** ******* as *** best ********** products ** *** ******* while *** worst ********** product ** OakChart ******** ** Performance **************** ***** **** *** its **** *********** in *** first quarter *** the ***** *********** ** *** ****** ******* ***** ******** are ******** if *** ***** ******** ***** ***** **** ** *********** ** the ****** ******* ** ***** ** ***** ***** the **** ********** ****** *** *** west *** the ***** ********** ****** was *** East ******* with **** stores ***** *** South) ******** higher revenues **** ******* with **** ****** ***** *** Mid-States) ** ***** ** ******* ***** *** location ******* with four ****** had ****** *********** **** regions with **** ****** *** ********** *** the **** ******* sales ***** *** South had the ***** ******* sales per ******** Amarillo ** the ********** was the **** ******** ***** *** ***** ********** location *** *** ******* ** the South For ******* lines ****** had *** **** *********** *** *** *** the ****** ***** ****** *** ********* **** in *** **** *** South ******** ********* **** in the **** ***** Maple was the *************** ******* ** *** Mid-States *** ********* ***** ** *** **** ***** ***** ********* ***** in *** ***** Cherry performed ***** in the Mid-States *** *** ********************** ******* should ******** ********* its marketing ******** The ***** ******** *** ********* *** **** should ** done ** *** ********* ********** to increase ***** **** **** ****** *** **** ***** ** *** ******* ******** the sales ******** **** ******** ****** ***** *** ***** ***** ** declining *** so ***** is * ******* ********** ** seasonal ******* Sales strategies ******** by the ******** location should ** ******** ** *** whole company Their ******** ***** ** ** ******* ***** *** location *** *** highest ***** ****************** the ****** ** ***** ********* *** ******** the ******* ******** **** ****** ***** ********* revenues ** ****** by *** ******* *** ******** ******* ***** increases ** *** ********** *** *** East **** **** increase *** company ************ bamboo ****** be ******* ** *** ******* ***** it has *** highest ***** ********** ****** ******* **** ****** be emphasized ** *** **** and South ***** ** ****** *** ***** ****** ********* *** the *** product line ****** ** ********* since ** had *** lowest ***** Mahogany product ***** ****** be ********* in the **** while ***** should be ********* in *** Mid-States since they ****** ****** performance ** ***** ******* ***** should ******* ** stocked **** ** *** south *** ****** in the ********** and *** **** *** to ***** *** *********** ** *** ******* ** essence * ************* ********* ****** **** ***** *** ******* ****** be *********** * ***** ********* ****** will assist **** ******* ***** across *** regions ***** ** ***** ******** *********** ************ 2016)ReferencesEdwards D (2014) *** **** Between ******* ************* and ********* *********** ********** ********* ************** * J ****** ********* ******** *** management ******** ******************** * (2016) Logistics & ****** ***** management Pearson **
