Due in 24 hours
Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
Assignment SLP part 1
Scenario: 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.
Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
Provide accurate and complete Excel analysis (Pivot Table with Charts).
Assignment SLP part 2 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.
· 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.
· Avoid redundancy and general statements
Sheet1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Quarter |
Region |
City |
Product |
Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Q1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| East |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Boston |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Maple |
34333 |
Q1 East
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Buffalo |
Maple
55108 |
Q1 East
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Baltimore |
Maple
50340 |
Q1 East
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Charlotte |
Maple
51819 |
Q1 East Boston
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cherry |
50400 |
Q1 East Buffalo Cherry
| 46616 |
Q1 East Baltimore Cherry
| 48819 |
Q1 East Charlotte Cherry
| 50675 |
Q1 East Boston
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Bamboo |
59278 |
Q1 East Buffalo Bamboo
| 42227 |
Q1 East Baltimore Bamboo
| 52110 |
Q1 East Charlotte Bamboo
| 55228 |
Q1 East Boston
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Oak |
38767 |
Q1 East Buffalo Oak
| 36600 |
Q1 East Baltimore Oak
| 50811 |
Q1 East Charlotte Oak
| 39360 |
Q1 East Boston
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mahogany |
49425 |
Q1 East Buffalo Mahogany
| 26325 |
Q1 East Baltimore Mahogany
| 46491 |
Q1 East Charlotte Mahogany
| 55617 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Q2 |
East Boston Maple
52933 |
Q2 East Buffalo Maple
| 58616 |
Q2 East Baltimore Maple
| 26024 |
Q2 East Charlotte Maple
| 31578 |
Q2 East Boston Cherry
| 40033 |
Q2 East Buffalo Cherry
| 49574 |
Q2 East Baltimore Cherry
| 30360 |
Q2 East Charlotte Cherry
| 38443 |
Q2 East Boston Bamboo
| 49119 |
Q2 East Buffalo Bamboo
| 55238 |
Q2 East Baltimore Bamboo
| 25391 |
Q2 East Charlotte Bamboo
| 30028 |
Q2 East Boston Oak
| 27913 |
Q2 East Buffalo Oak
| 25411 |
Q2 East Baltimore Oak
| 49386 |
Q2 East Charlotte Oak
| 36078 |
Q2 East Boston Mahogany
| 57029 |
Q2 East Buffalo Mahogany
| 56829 |
Q2 East Baltimore Mahogany
| 50823 |
Q2 East Charlotte Mahogany
| 43620 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Q3 |
East Boston Maple
26788 |
Q3 East Buffalo Maple
| 58724 |
Q3 East Baltimore Maple
| 46343 |
Q3 East Charlotte Maple
| 25561 |
Q3 East Boston Cherry
| 59594 |
Q3 East Buffalo Cherry
| 25748 |
Q3 East Baltimore Cherry
| 58557 |
Q3 East Charlotte Cherry
| 58385 |
Q3 East Boston Bamboo
| 35751 |
Q3 East Buffalo Bamboo
| 41835 |
Q3 East Baltimore Bamboo
| 49418 |
Q3 East Charlotte Bamboo
| 56719 |
Q3 East Boston Oak
| 48001 |
Q3 East Buffalo Oak
| 26364 |
Q3 East Baltimore Oak
| 55429 |
Q3 East Charlotte Oak
| 43880 |
Q3 East Boston Mahogany
| 48741 |
Q3 East Buffalo Mahogany
| 38650 |
Q3 East Baltimore Mahogany
| 47651 |
Q3 East Charlotte Mahogany
| 36962 |
Q1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| South |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Atlanta |
Maple
33492 |
Q1 South
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Jacksonville |
Maple
44045 |
Q1 South
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| New Orleans |
Maple
33785 |
Q1 South
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Montgomery |
Maple
47897 |
Q1 South
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Memphis |
Maple
48379 |
Q1 South Atlanta Cherry
| 47861 |
Q1 South Jacksonville Cherry
| 28226 |
Q1 South New Orleans Cherry
| 48290 |
Q1 South Montgomery Cherry
| 43202 |
Q1 South Memphis Cherry
| 32655 |
Q1 South Atlanta Bamboo
| 31768 |
Q1 South Jacksonville Bamboo
| 55938 |
Q1 South New Orleans Bamboo
| 48281 |
Q1 South Montgomery Bamboo
| 48489 |
Q1 South Memphis Bamboo
| 57384 |
Q1 South Atlanta Oak
| 52322 |
Q1 South Jacksonville Oak
| 47195 |
Q1 South New Orleans Oak
| 49613 |
Q1 South Montgomery Oak
| 27876 |
Q1 South Memphis Oak
| 49811 |
Q1 South Atlanta Mahogany
| 58368 |
Q1 South Jacksonville Mahogany
| 30837 |
Q1 South New Orleans Mahogany
| 27586 |
Q1 South Montgomery Mahogany
| 29355 |
Q1 South Memphis Mahogany
| 47282 |
Q2 South Atlanta Maple
| 34451 |
Q2 South Jacksonville Maple
| 49984 |
Q2 South New Orleans Maple
| 47462 |
Q2 South Montgomery Maple
| 25896 |
Q2 South Memphis Maple
| 31382 |
Q2 South Atlanta Cherry
| 46927 |
Q2 South Jacksonville Cherry
| 54709 |
Q2 South New Orleans Cherry
| 47070 |
Q2 South Montgomery Cherry
| 40054 |
Q2 South Memphis Cherry
| 52657 |
Q2 South Atlanta Bamboo
| 30835 |
Q2 South Jacksonville Bamboo
| 48766 |
Q2 South New Orleans Bamboo
| 52200 |
Q2 South Montgomery Bamboo
| 38702 |
Q2 South Memphis Bamboo
| 30509 |
Q2 South Atlanta Oak
| 48866 |
Q2 South Jacksonville Oak
| 59721 |
Q2 South New Orleans Oak
| 43127 |
Q2 South Montgomery Oak
| 48522 |
Q2 South Memphis Oak
| 30317 |
Q2 South Atlanta Mahogany
| 58150 |
Q2 South Jacksonville Mahogany
| 43988 |
Q2 South New Orleans Mahogany
| 36337 |
Q2 South Montgomery Mahogany
| 36503 |
Q2 South Memphis Mahogany
| 28976 |
Q3 South Atlanta Maple
| 36769 |
Q3 South Jacksonville Maple
| 48237 |
Q3 South New Orleans Maple
| 25645 |
Q3 South Montgomery Maple
| 55630 |
Q3 South Memphis Maple
| 37753 |
Q3 South Atlanta Cherry
| 43545 |
Q3 South Jacksonville Cherry
| 55808 |
Q3 South New Orleans Cherry
| 34140 |
Q3 South Montgomery Cherry
| 49491 |
Q3 South Memphis Cherry
| 46213 |
Q3 South Atlanta Bamboo
| 47514 |
Q3 South Jacksonville Bamboo
| 43679 |
Q3 South New Orleans Bamboo
| 37490 |
Q3 South Montgomery Bamboo
| 50142 |
Q3 South Memphis Bamboo
| 58722 |
Q3 South Atlanta Oak
| 36155 |
Q3 South Jacksonville Oak
| 40761 |
Q3 South New Orleans Oak
| 28760 |
Q3 South Montgomery Oak
| 50814 |
Q3 South Memphis Oak
| 25163 |
Q3 South Atlanta Mahogany
| 33909 |
Q3 South Jacksonville Mahogany
| 46003 |
Q3 South New Orleans Mahogany
| 51592 |
Q3 South Montgomery Mahogany
| 40415 |
Q3 South Memphis Mahogany
| 49963 |
Q1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Mid-States |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Columbus |
Maple
59178 |
Q1 Mid-States
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Chicago |
Maple
44363 |
Q1 Mid-States
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Kansas City |
Maple
56622 |
Q1 Mid-States
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Amarillo |
Maple
50548 |
Q1 Mid-States Columbus Cherry
| 47535 |
Q1 Mid-States Chicago Cherry
| 32114 |
Q1 Mid-States Kansas City Cherry
| 48174 |
Q1 Mid-States Amarillo Cherry
| 38826 |
Q1 Mid-States Columbus Bamboo
| 59942 |
Q1 Mid-States Chicago Bamboo
| 48133 |
Q1 Mid-States Kansas City Bamboo
| 32961 |
Q1 Mid-States Amarillo Bamboo
| 58502 |
Q1 Mid-States Columbus Oak
| 30754 |
Q1 Mid-States Chicago Oak
| 53732 |
Q1 Mid-States Kansas City Oak
| 48607 |
Q1 Mid-States Amarillo Oak
| 55422 |
Q1 Mid-States Columbus Mahogany
| 44342 |
Q1 Mid-States Chicago Mahogany
| 40047 |
Q1 Mid-States Kansas City Mahogany
| 51715 |
Q1 Mid-States Amarillo Mahogany
| 54539 |
Q2 Mid-States Columbus Maple
| 36059 |
Q2 Mid-States Chicago Maple
| 39931 |
Q2 Mid-States Kansas City Maple
| 49786 |
Q2 Mid-States Amarillo Maple
| 54658 |
Q2 Mid-States Columbus Cherry
| 38031 |
Q2 Mid-States Chicago Cherry
| 35202 |
Q2 Mid-States Kansas City Cherry
| 37583 |
Q2 Mid-States Amarillo Cherry
| 48998 |
Q2 Mid-States Columbus Bamboo
| 48251 |
Q2 Mid-States Chicago Bamboo
| 37513 |
Q2 Mid-States Kansas City Bamboo
| 55737 |
Q2 Mid-States Amarillo Bamboo
| 30166 |
Q2 Mid-States Columbus Oak
| 28606 |
Q2 Mid-States Chicago Oak
| 42121 |
Q2 Mid-States Kansas City Oak
| 33784 |
Q2 Mid-States Amarillo Oak
| 44789 |
Q2 Mid-States Columbus Mahogany
| 49188 |
Q2 Mid-States Chicago Mahogany
| 45784 |
Q2 Mid-States Kansas City Mahogany
| 59385 |
Q2 Mid-States Amarillo Mahogany
| 54585 |
Q3 Mid-States Columbus Maple
| 50718 |
Q3 Mid-States Chicago Maple
| 35928 |
Q3 Mid-States Kansas City Maple
| 46282 |
Q3 Mid-States Amarillo Maple
| 53009 |
Q3 Mid-States Columbus Cherry
| 26030 |
Q3 Mid-States Chicago Cherry
| 51763 |
Q3 Mid-States Kansas City Cherry
| 37984 |
Q3 Mid-States Amarillo Cherry
| 49954 |
Q3 Mid-States Columbus Bamboo
| 38330 |
Q3 Mid-States Chicago Bamboo
| 27490 |
Q3 Mid-States Kansas City Bamboo
| 55990 |
Q3 Mid-States Amarillo Bamboo
| 41987 |
Q3 Mid-States Columbus Oak
| 57102 |
Q3 Mid-States Chicago Oak
| 44019 |
Q3 Mid-States Kansas City Oak
| 45119 |
Q3 Mid-States Amarillo Oak
| 42744 |
Q3 Mid-States Columbus Mahogany
| 25587 |
Q3 Mid-States Chicago Mahogany
| 55251 |
Q3 Mid-States Kansas City Mahogany
| 33488 |
Q3 Mid-States Amarillo Mahogany
| 55448 |
Q1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| West |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Denver |
Maple
47445 |
Q1 West
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Boise |
Maple
46961 |
Q1 West
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Las Vegas |
Maple
38469 |
Q1 West
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| San Diego |
Maple
39936 |
Q1 West
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Seattle |
Maple
56356 |
Q1 West Denver Cherry
| 44887 |
Q1 West Boise Cherry
| 59139 |
Q1 West Las Vegas Cherry
| 26352 |
Q1 West San Diego Cherry
| 26179 |
Q1 West Seattle Cherry
| 38488 |
Q1 West Denver Bamboo
| 59018 |
Q1 West Boise Bamboo
| 37985 |
Q1 West Las Vegas Bamboo
| 34771 |
Q1 West San Diego Bamboo
| 31540 |
Q1 West Seattle Bamboo
| 58225 |
Q1 West Denver Oak
| 31761 |
Q1 West Boise Oak
| 44062 |
Q1 West Las Vegas Oak
| 53829 |
Q1 West San Diego Oak
| 37081 |
Q1 West Seattle Oak
| 48811 |
Q1 West Denver Mahogany
| 30050 |
Q1 West Boise Mahogany
| 46770 |
Q1 West Las Vegas Mahogany
| 56348 |
Q1 West San Diego Mahogany
| 43877 |
Q1 West Seattle Mahogany
| 43605 |
Q2 West Denver Maple
| 59975 |
Q2 West Boise Maple
| 45456 |
Q2 West Las Vegas Maple
| 55003 |
Q2 West San Diego Maple
| 29699 |
Q2 West Seattle Maple
| 32790 |
Q2 West Denver Cherry
| 48373 |
Q2 West Boise Cherry
| 27789 |
Q2 West Las Vegas Cherry
| 53298 |
Q2 West San Diego Cherry
| 57227 |
Q2 West Seattle Cherry
| 42499 |
Q2 West Denver Bamboo
| 47843 |
Q2 West Boise Bamboo
| 45603 |
Q2 West Las Vegas Bamboo
| 59025 |
Q2 West San Diego Bamboo
| 59373 |
Q2 West Seattle Bamboo
| 28106 |
Q2 West Denver Oak
| 28994 |
Q2 West Boise Oak
| 56821 |
Q2 West Las Vegas Oak
| 48044 |
Q2 West San Diego Oak
| 45690 |
Q2 West Seattle Oak
| 51720 |
Q2 West Denver Mahogany
| 52309 |
Q2 West Boise Mahogany
| 56503 |
Q2 West Las Vegas Mahogany
| 43664 |
Q2 West San Diego Mahogany
| 34260 |
Q2 West Seattle Mahogany
| 44437 |
Q3 West Denver Maple
| 39699 |
Q3 West Boise Maple
| 31591 |
Q3 West Las Vegas Maple
| 49802 |
Q3 West San Diego Maple
| 49247 |
Q3 West Seattle Maple
| 32570 |
Q3 West Denver Cherry
| 42629 |
Q3 West Boise Cherry
| 55646 |
Q3 West Las Vegas Cherry
| 41333 |
Q3 West San Diego Cherry
| 47873 |
Q3 West Seattle Cherry
| 28079 |
Q3 West Denver Bamboo
| 40429 |
Q3 West Boise Bamboo
| 49528 |
Q3 West Las Vegas Bamboo
| 40639 |
Q3 West San Diego Bamboo
| 48620 |
Q3 West Seattle Bamboo
| 49160 |
Q3 West Denver Oak
| 39437 |
Q3 West Boise Oak
| 50513 |
Q3 West Las Vegas Oak
| 29282 |
Q3 West San Diego Oak
| 36949 |
Q3 West Seattle Oak
| 56607 |
Q3 West Denver Mahogany
| 44819 |
Q3 West Boise Mahogany
| 26240 |
Q3 West Las Vegas Mahogany
| 47119 |
Q3 West San Diego Mahogany
| 55748 |
Q3 West Seattle Mahogany
| 39944 |
Turn in your highest-quality paper
Get a qualified writer to help you with
“ MATH GURU ONLY ”
Get high-quality paper
Guarantee! All work is written by expert writers!
USA: +1(669)289-8683 
Sign in
