BUS520Module3CaseAssignmentV1.xlsx
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 |
Titi
