Excel Sheet 2
jymojica
SC_EX16_7a_JesusMojica_1.xlsxDocumentation
| Shelly Cashman Excel 2016 | Module 7: SAM Project 1a | |
| Antioch Sports Center | |
| IMPORTING DATA AND WORKING WITH SMARTART, IMAGES, AND SCREENSHOTS | |
| Author: | Jesus Mojica |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Candidates
| Merger Candidates |
Prime Sports
| Prime Sports - 2020 Sales | |||||||||||||
| Sales | Q1 | Q2 | Q3 | Q4 | Total | ||||||||
| Events | $ 6,500 | $ 7,750 | $ 7,450 | $ 8,000 | $ 29,700 | ||||||||
| Leagues | $ 7,000 | $ 7,000 | $ 8,550 | $ 9,750 | $ 32,300 | ||||||||
| Memberships | $ 36,000 | $ 39,000 | $ 45,550 | $ 47,500 | $ 168,050 | ||||||||
| Programs | $ 42,000 | $ 41,500 | $ 49,800 | $ 50,750 | $ 184,050 | ||||||||
| Total | $ 91,500 | $ 95,250 | $ 111,350 | $ 116,000 | $ 414,100 | ||||||||
| Prime Sports - Historical Sales | |||||||||||||
Tony Brown
| Tony Brown - 2020 Sales | ||||||
| Tony Brown - Historical Sales | ||||||
| Sales | 2016 | 2017 | 2018 | 2019 | 2020 | |
| Q1 18550 | $ 43,760 | $ 55,000 | $ 56,500 | $ 61,900 | ||
| Q2 25455 | $ 44,750 | $ 51,800 | $ 55,000 | $ 65,750 | ||
| Q3 30650 | $ 50,500 | $ 53,900 | $ 59,300 | $ 67,300 | ||
| Q4 44500 | $ 52,900 | $ 55,500 | $ 62,750 | $ 70,750 | ||
| Total | ||||||
Northside
| Northside Sports - 2020 Sales | ||||||
| Sales | Events | Leagues | Memberships | Programs | Total | |
| Q1 | $ 7,150 | $ 3,250 | $ 11,700 | $ 10,400 | $ 32,500 | |
| Q2 | $ 8,085 | $ 3,675 | $ 13,230 | $ 11,760 | $ 36,750 | |
| Q3 | $ 6,116 | $ 2,780 | $ 10,008 | $ 8,896 | $ 27,800 | |
| Q4 | $ 7,425 | $ 3,375 | $ 12,150 | $ 10,800 | $ 33,750 | |
| Total | $ 28,776 | $ 13,080 | $ 47,088 | $ 41,856 | $ 130,800 | |
| Northside Sports - Historical Sales | ||||||
| Sales | 2016 | 2017 | 2018 | 2019 | 2020 | |
| Quarter1 | $ 26,500 | $ 25,900 | $ 27,000 | $ 29,750 | $ 32,500 | |
| Quarter2 | $ 22,700 | $ 30,000 | $ 28,500 | $ 32,550 | $ 36,750 | |
| Quarter3 | $ 21,600 | $ 25,000 | $ 23,575 | $ 28,750 | $ 27,800 | |
| Quarter4 | $ 27,700 | $ 26,500 | $ 27,000 | $ 31,500 | $ 33,750 | |
| Totals | $ 98,500 | $ 107,400 | $ 106,075 | $ 122,550 | $ 130,800 | |
Northside Revenue Chart
Northside Sports Center
Totals 2016 2017 2018 2019 2020 98500 107400 106075 122550 130800
Sales
Stillman
| Stillman Center - 2020 Sales | ||||||
| Sales | Events | Leagues | Memberships | Programs | Total | |
| Q1 | 11594 | 5270 | 18972 | 16864 | 52700 | |
| Q2 | 14091 | 6405 | 23058 | 20496 | 64050 | |
| Q3 | 12490.5 | 5677.5 | 20439 | 18168 | 56775 | |
| Q4 | 13211 | 6005 | 21618 | 19216 | 60050 | |
| Total | 51386.5 | 23357.5 | 84087 | 74744 | 233575 | |
| Stillman Center - Historical Sales | ||||||
| Total | 0 | 0 | 0 | 0 | 0 | |
