Excel 2016 | Module 5: SAM Project 1a
XielentSC_EX16_5a_JordanSmith_1.xlsx
Documentation
Shelly Cashman Excel 2016 | Module 5: SAM Project 1a | |
11th Gear Bike Rental | |
WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS | |
Author: | Jordan Smith |
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. | |
Santa Monica
11th Gear Bike Rentals | |||||||||||||
Santa Monica | |||||||||||||
2019 Monthly Rentals | |||||||||||||
Rental Type | January | February | March | April | May | June | July | August | September | October | November | December | Total |
Cruiser | 133 | 277 | 142 | 128 | 141 | 517 | 216 | 340 | 438 | 147 | 249 | 92 | 2820 |
Stret | 340 | 320 | 201 | 485 | 196 | 280 | 73 | 100 | 164 | 508 | 75 | 280 | 3022 |
Trycycle | 28 | 43 | 86 | 203 | 85 | 47 | 165 | 63 | 22 | 113 | 29 | 166 | 1050 |
Tandem | 119 | 61 | 265 | 92 | 251 | 51 | 126 | 91 | 173 | 168 | 79 | 80 | 1556 |
Youth | 185 | 352 | 302 | 172 | 155 | 155 | 189 | 40 | 85 | 306 | 192 | 220 | 2353 |
Kid's Trailer | 26 | 29 | 63 | 75 | 108 | 52 | 74 | 87 | 121 | 41 | 63 | 22 | 761 |
2019 Monthly Revenue | |||||||||||||
Rental Type | January | February | March | April | May | June | July | August | September | October | November | December | Total |
Cruiser | 2793 | 5817 | 2982 | 2688 | 2961 | 10857 | 4536 | 7140 | 9198 | 3087 | 5229 | 1932 | 59220 |
Street | 7140 | 6720 | 4221 | 10185 | 4116 | 5880 | 1533 | 2100 | 3444 | 10668 | 1575 | 5880 | 63462 |
Tricycle | 644 | 989 | 1978 | 4669 | 1955 | 1081 | 3795 | 1449 | 506 | 2599 | 667 | 3818 | 24150 |
Tandem | 5236 | 2684 | 11660 | 4048 | 11044 | 2244 | 5544 | 4004 | 7612 | 7392 | 3476 | 3520 | 68464 |
Youth | 2405 | 4576 | 3926 | 2236 | 2015 | 2015 | 2457 | 520 | 1105 | 3978 | 2496 | 2860 | 30589 |
Kid's Trailer | 520 | 580 | 1260 | 1500 | 2160 | 1040 | 1480 | 1740 | 2420 | 820 | 1260 | 440 | 15220 |
Total | $ 18,738 | $ 21,366 | $ 26,027 | $ 25,326 | $ 24,251 | $ 23,117 | $ 19,345 | $ 16,953 | $ 24,285 | $ 28,544 | $ 14,703 | $ 18,450 | $ 261,105 |
Venice Beach
11th Gear Bike Rentals | |||||||||||||
Venice Beach | |||||||||||||
2019 Monthly Rentals | |||||||||||||
Rental Type | January | February | March | April | May | June | July | August | September | October | November | December | Total |
Cruiser | 446 | 152 | 565 | 306 | 271 | 459 | 368 | 179 | 296 | 369 | 252 | 261 | 3924 |
Stret | 133 | 207 | 425 | 160 | 250 | 220 | 253 | 423 | 105 | 89 | 184 | 498 | 2947 |
Trycycle | 70 | 35 | 33 | 146 | 184 | 142 | 140 | 48 | 94 | 86 | 35 | 69 | 1082 |
Tandem | 178 | 109 | 153 | 106 | 162 | 92 | 172 | 191 | 134 | 246 | 94 | 127 | 1764 |
Youth | 76 | 53 | 58 | 88 | 204 | 179 | 359 | 144 | 61 | 151 | 113 | 71 | 1557 |
Kid's Trailer | 80 | 169 | 43 | 128 | 186 | 173 | 160 | 194 | 53 | 161 | 141 | 47 | 1535 |
2019 Monthly Revenue | |||||||||||||
Rental Type | January | February | March | April | May | June | July | August | September | October | November | December | Total |
Cruiser | 9366 | 3192 | 11865 | 6426 | 5691 | 9639 | 7728 | 3759 | 6216 | 7749 | 5292 | 5481 | 82404 |
Street | 2793 | 4347 | 8925 | 3360 | 5250 | 4620 | 5313 | 8883 | 2205 | 1869 | 3864 | 10458 | 61887 |
Tricycle | 1610 | 805 | 759 | 3358 | 4232 | 3266 | 3220 | 1104 | 2162 | 1978 | 805 | 1587 | 24886 |
Tandem | 7832 | 4796 | 6732 | 4664 | 7128 | 4048 | 7568 | 8404 | 5896 | 10824 | 4136 | 5588 | 77616 |
Youth | 988 | 689 | 754 | 1144 | 2652 | 2327 | 4667 | 1872 | 793 | 1963 | 1469 | 923 | 20241 |
Kid's Trailer | 1600 | 3380 | 860 | 2560 | 3720 | 3460 | 3200 | 3880 | 1060 | 3220 | 2820 | 940 | 30700 |
Total | $ 24,189 | $ 17,209 | $ 29,895 | $ 21,512 | $ 28,673 | $ 27,360 | $ 31,696 | $ 27,902 | $ 18,332 | $ 27,603 | $ 18,386 | $ 24,977 | $ 297,734 |
Marina Del Rey
11th Gear Bike Rentals | |||||||||||||
Marina Del Ray | |||||||||||||
2019 Monthly Rentals | |||||||||||||
Rental Type | January | February | March | April | May | June | July | August | September | October | November | December | Total |
Cruiser | 268 | 447 | 200 | 284 | 218 | 107 | 124 | 196 | 230 | 377 | 216 | 121 | 2788 |
Stret | 367 | 263 | 396 | 263 | 348 | 71 | 316 | 85 | 199 | 408 | 515 | 467 | 3698 |
Trycycle | 58 | 70 | 56 | 146 | 61 | 168 | 66 | 15 | 159 | 71 | 72 | 98 | 1040 |
Tandem | 97 | 93 | 171 | 100 | 108 | 244 | 102 | 48 | 85 | 216 | 164 | 34 | 1462 |
Youth | 174 | 383 | 168 | 150 | 447 | 263 | 130 | 174 | 65 | 58 | 287 | 46 | 2345 |
Kid's Trailer | 138 | 90 | 51 | 146 | 59 | 63 | 136 | 108 | 40 | 86 | 93 | 66 | 1076 |
2019 Monthly Revenue | |||||||||||||
Rental Type | January | February | March | April | May | June | July | August | September | October | November | December | Total |
Cruiser | 5628 | 9387 | 4200 | 5964 | 4578 | 2247 | 2604 | 4116 | 4830 | 7917 | 4536 | 2541 | 58548 |
Street | 7707 | 5523 | 8316 | 5523 | 7308 | 1491 | 6636 | 1785 | 4179 | 8568 | 10815 | 9807 | 77658 |
Tricycle | 1334 | 1610 | 1288 | 3358 | 1403 | 3864 | 1518 | 345 | 3657 | 1633 | 1656 | 2254 | 23920 |
Tandem | 4268 | 4092 | 7524 | 4400 | 4752 | 10736 | 4488 | 2112 | 3740 | 9504 | 7216 | 1496 | 64328 |
Youth | 2262 | 4979 | 2184 | 1950 | 5811 | 3419 | 1690 | 2262 | 845 | 754 | 3731 | 598 | 30485 |
Kid's Trailer | 2760 | 1800 | 1020 | 2920 | 1180 | 1260 | 2720 | 2160 | 800 | 1720 | 1860 | 1320 | 21520 |
Total | $ 23,959 | $ 27,391 | $ 24,532 | $ 24,115 | $ 25,032 | $ 23,017 | $ 19,656 | $ 12,780 | $ 18,051 | $ 30,096 | $ 29,814 | $ 18,016 | $ 276,459 |
All Locations
11th Gear Bike Rentals | |||||||||||||
All Locations | |||||||||||||
Date Generated | |||||||||||||
2019 Monthly Rentals | |||||||||||||
Rental Type | January | February | March | April | May | June | July | August | September | October | November | December | Total |
Cruiser | 0 | ||||||||||||
Street | 0 | ||||||||||||
Tricycle | 0 | ||||||||||||
Tandem | 0 | ||||||||||||
Youth | 0 | ||||||||||||
Kid's Trailer | 0 | ||||||||||||
2019 Monthly Revenue | |||||||||||||
Rental Type | January | February | March | April | May | June | July | August | September | October | November | December | Total |
Cruiser | $ 17,787 | $ 18,396 | $ 19,047 | $ 15,078 | $ 13,230 | $ 22,743 | $ 14,868 | $ 15,015 | $ 20,244 | $ 18,753 | $ 15,057 | $ 9,954 | $ 200,172 |
Street | 17,640 | 16,590 | 21,462 | 19,068 | 16,674 | 11,991 | 13,482 | 12,768 | 9,828 | 21,105 | 16,254 | 26,145 | $ 203,007 |
Tricycle | 3,588 | 3,404 | 4,025 | 11,385 | 7,590 | 8,211 | 8,533 | 2,898 | 6,325 | 6,210 | 3,128 | 7,659 | $ 72,956 |
Tandem | 17,336 | 11,572 | 25,916 | 13,112 | 22,924 | 17,028 | 17,600 | 14,520 | 17,248 | 27,720 | 14,828 | 10,604 | $ 210,408 |
Youth | 5,655 | 10,244 | 6,864 | 5,330 | 10,478 | 7,761 | 8,814 | 4,654 | 2,743 | 6,695 | 7,696 | 4,381 | $ 81,315 |
Kid's Trailer | 4,880 | 5,760 | 3,140 | 6,980 | 7,060 | 5,760 | 7,400 | 7,780 | 4,280 | 5,760 | 5,940 | 2,700 | $ 67,440 |
Total | $ 66,886 | $ 65,966 | $ 80,454 | $ 70,953 | $ 77,956 | $ 73,494 | $ 70,697 | $ 57,635 | $ 60,668 | $ 86,243 | $ 62,903 | $ 61,443 | $ 835,298 |
2019 Total Revenue
Cruiser Street Tricycle Tandem Youth Kid's Trailer 200172 203007 72956 210408 81315 67440
Helmets Per Location
11th Gear Bike Rentals | ||||
Location | Max Daily Rentals | Damaged Helments (%) | Total Helmets Required (%) | Helmets Per Location |
Santa Monica | 412 | 100% | ||
Venice Beach | 471 | 100% | ||
Marina Del Rey | 440 | 100% |