Excel Modify 3

profilejymojica
SC_EX16_5b_JesusMojica_1.xlsx
Home>Information Systems homework help>Excel Modify 3

Documentation

Shelly Cashman Excel 2016 | Module 5: SAM Project 1b
Gulf Coast Kayak
WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
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.

Naples

Gulf Coast Kayak
Naples
2019 Monthly Enrollment
School January February March April May June July August September October November December Total
Beginner 8 9 19 20 22 20 19 9 18 8 7 9 168
Ocen 9 5 15 25 25 25 15 5 25 9 5 5 168
Roughwater 11 6 26 31 20 31 26 6 20 11 6 6 200
Kids 7 3 30 25 27 25 30 3 23 7 3 9 192
Performance 5 8 29 15 15 15 29 8 19 5 8 11 167
Private 9 11 19 18 17 18 19 11 18 9 11 10 170
2019 Monthly Revenue
School January February March April May June July August September October November December Total
Beginner 440 495 1045 1100 1210 1100 1045 495 990 440 385 495 9240
Ocean 495 275 825 1375 1375 1375 825 275 1375 495 275 275 9240
Rough-water 605 330 1430 1705 1100 1705 1430 330 1100 605 330 330 11000
Kids 245 105 1050 875 945 875 1050 105 805 245 105 315 6720
Performance 300 480 1740 900 900 900 1740 480 1140 300 480 660 10020
Private 675 825 1425 1350 1275 1350 1425 825 1350 675 825 750 12750
Total $ 2,760 $ 2,510 $ 7,515 $ 7,305 $ 6,805 $ 7,305 $ 7,515 $ 2,510 $ 6,760 $ 2,760 $ 2,400 $ 2,825 $ 58,970

Sarasota

Gulf Coast Kayak
Sarasota
2019 Monthly Enrollment
School January February March April May June July August September October November December Total
Beginner 5 18 19 25 22 18 19 14 18 8 7 5 178
Ocen 7 15 12 25 25 25 15 5 25 9 5 8 176
Roughwater 9 8 26 31 15 31 26 6 20 11 6 10 199
Kids 11 3 30 25 27 25 30 3 23 7 7 8 199
Performance 9 8 29 19 15 15 29 8 19 13 8 12 184
Private 2 11 19 18 17 18 19 11 18 9 11 10 163
2019 Monthly Revenue
School January February March April May June July August September October November December Total
Beginner 275 990 1045 1375 1210 990 1045 770 990 440 385 275 9790
Ocean 385 825 660 1375 1375 1375 825 275 1375 495 275 440 9680
Rough-water 495 440 1430 1705 825 1705 1430 330 1100 605 330 550 10945
Kids 385 105 1050 875 945 875 1050 105 805 245 245 280 6965
Performance 540 480 1740 1140 900 900 1740 480 1140 780 480 720 11040
Private 150 825 1425 1350 1275 1350 1425 825 1350 675 825 750 12225
Total $ 2,230 $ 3,665 $ 7,350 $ 7,820 $ 6,530 $ 7,195 $ 7,515 $ 2,785 $ 6,760 $ 3,240 $ 2,540 $ 3,015 $ 60,645

Tampa

Gulf Coast Kayak
Tampa
2019 Monthly Enrollment
School January February March April May June July August September October November December Total
Beginner 10 12 19 25 22 20 19 9 18 8 11 14 187
Ocen 9 5 15 25 25 25 15 5 19 9 5 13 170
Roughwater 11 6 26 31 20 27 26 8 20 11 6 6 198
Kids 7 10 28 25 18 25 30 3 23 7 3 9 188
Performance 5 8 29 15 15 15 29 8 19 5 8 11 167
Private 9 11 19 23 17 18 19 11 18 9 11 10 175
2019 Monthly Revenue
School January February March April May June July August September October November December Total
Beginner 550 660 1045 1375 1210 1100 1045 495 990 440 605 770 10285
Ocean 495 275 825 1375 1375 1375 825 275 1045 495 275 715 9350
Rough-water 605 330 1430 1705 1100 1485 1430 440 1100 605 330 330 10890
Kids 245 350 980 875 630 875 1050 105 805 245 105 315 6580
Performance 300 480 1740 900 900 900 1740 480 1140 300 480 660 10020
Private 675 825 1425 1725 1275 1350 1425 825 1350 675 825 750 13125
Total $ 2,870 $ 2,920 $ 7,445 $ 7,955 $ 6,490 $ 7,085 $ 7,515 $ 2,620 $ 6,430 $ 2,760 $ 2,620 $ 3,540 $ 60,250

All Locations

Gulf Coast Kayak
All Locations
Date Generated
2019 Monthly Enrollment
School January February March April May June July August September October November December Total
Beginner 0
Ocean 0
Rough-water 0
Kids 0
Performance 0
Private 0
2019 Monthly Revenue
School January February March April May June July August September October November December Total
Beginner 1265 2145 3135 3850 3630 3190 3135 1760 2970 1320 1375 1540 29315
Ocean 1375 1375 2310 4125 4125 4125 2475 825 3795 1485 825 1430 28270
Rough-water 1705 1100 4290 5115 3025 4895 4290 1100 3300 1815 990 1210 32835
Kids 875 560 3080 2625 2520 2625 3150 315 2415 735 455 910 20265
Performance 1140 1440 5220 2940 2700 2700 5220 1440 3420 1380 1440 2040 31080
Private 1500 2475 4275 4425 3825 4050 4275 2475 4050 2025 2475 2250 38100
Total $ 7,860 $ 9,095 $ 22,310 $ 23,080 $ 19,825 $ 21,585 $ 22,545 $ 7,915 $ 19,950 $ 8,760 $ 7,560 $ 9,380 $ 179,865

2019 Total Revenue

Beginner Ocean Rough-water Kids Performance Private 29315 28270 32835 20265 31080 38100

Vests Per Location

Gulf Coast Kayak
Location Max Daily Students Lost Vests (%) Total Vests Required (%) Vests Per Location
Naples 138 100%
Sarasota 143 100%
Tampa 144 100%