Please let me know if you can open this up... Need this by 4:00 pm today.

Module 1 Case - Formatting of data, Pivot Table + Chart To the left is my formatted data - note the order in which I've arranged it. Also, note that I have left space no between the headings and the actual data. On the right of the chart is the \"Pivot Table Field List\" - if you set up table accurately, you will be able to click on select fields - and your chart will change accordingly. Below, I've selected \"Product\" and \"Revenue\" - this automatically gives me a table showing most profitable and least profitable products: If I change the fields to report to Region and Revenue only, the Pivot Chart changes - to reflect the following (Revenue by Region): If I check Quarter, Product, and Revenue, the Chart changes to the following....note that I can now determine how each product fared by quarter: Or, I can check only City and Revenue: Assignment Overview 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 five 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. Assignment Expectations Analysis: Accurate and complete analysis in Excel. Written report: Length requirements = 4-5 pages minimum (not including Cover and Reference pages) Provide a brief introduction/ background of the problem. Complete and accurate Excel analysis. Written analysis that supports Excel analysis, and provides thorough discussion and analysis of assumptions, rationale, and logic used. Complete, meaningful, and accurate recommendation(s). East South Boston Buffalo Baltimore Charlotte Atlanta Jacksonville New Orleans Montgomery Memphis Columbus Chicago Mid-States Kansas City Amarillo West Denver Boise Las Vegas San Diego Seattle Maple Cherry 34333 50400 55108 46616 50340 48819 51819 50675 Q1 Bamboo Oak Mahogany 59278 38767 49425 42227 36600 26325 52110 50811 46491 55228 39360 55617 Maple Cherry 52933 40033 58616 49574 26024 30360 31578 38443 Q2 Bamboo Oak Mahogany 49119 27913 57029 55238 25411 56829 25391 49386 50823 30028 36078 43620 Maple Cherry 26788 59594 58724 25748 46343 58557 25561 58385 Q3 Bamboo Oak Mahogany 35751 48001 48741 41835 26364 38650 49418 55429 47651 56719 43880 36962 33492 44045 33785 47897 48379 47861 28226 48290 43202 32655 31768 55938 48281 48489 57384 52322 47195 49613 27876 49811 58368 30837 27586 29355 47282 34451 49984 47462 25896 31382 46927 54709 47070 40054 52657 30835 48766 52200 38702 30509 48866 59721 43127 48522 30317 58150 43988 36337 36503 28976 36769 48237 25645 55630 37753 43545 55808 34140 49491 46213 47514 43679 37490 50142 58722 36155 40761 28760 50814 25163 33909 46003 51592 40415 49963 59178 44363 56622 50548 47535 32114 48174 38826 59942 48133 32961 58502 30754 53732 48607 55422 44342 40047 51715 54539 36059 39931 49786 54658 38031 35202 37583 48998 48251 37513 55737 30166 28606 42121 33784 44789 49188 45784 59385 54585 50718 35928 46282 53009 26030 51763 37984 49954 38330 27490 55990 41987 57102 44019 45119 42744 25587 55251 33488 55448 47445 46961 38469 39936 56356 44887 59139 26352 26179 38488 59018 37985 34771 31540 58225 31761 44062 53829 37081 48811 30050 46770 56348 43877 43605 59975 45456 55003 29699 32790 48373 27789 53298 57227 42499 47843 45603 59025 59373 28106 28994 56821 48044 45690 51720 52309 56503 43664 34260 44437 39699 31591 49802 49247 32570 42629 55646 41333 47873 28079 40429 49528 40639 48620 49160 39437 50513 29282 36949 56607 44819 26240 47119 55748 39944