Homework Assignmet
Queen Mabella
Jennifer.Anderson-SanDiegoSailing-02.xlsxFleet
| San Diego Sailing | ||||||||
| Rental and Charter Fleet | ||||||||
| Boat ID | Make and Model | Length | Model Year | Seats | Sleeps | Galley with Stove | Half-Day Rate | Full Day Rate |
| 1010 | Catalina Wave | 28'4" | 2010 | 8 | 6 | $375.00 | $650.00 | |
| 1015 | Catalina Sky | 28'4" | 2012 | 8 | 6 | $425.00 | $725.00 | |
| 1146 | Hunter Ray | 33'6" | 2014 | 10 | 6 | $350.00 | $500.00 | |
| 1150 | Capri MKZ | 24'8" | 2011 | 6 | 4 | $325.00 | $500.00 | |
| 1152 | Capri 22 Mk II | 24'8" | 2016 | 6 | 4 | $325.00 | $500.00 | |
| 1164 | Capri 22 Mk II | 24'8" | 2016 | 6 | 4 | $325.00 | $500.00 | |
| 1168 | Hunter 33 | 33'6" | 2018 | 10 | 6 | $425.00 | $725.00 | |
| 1175 | Beneteau 40 | 39'10" | 2018 | 12 | 6 | $489.00 | $750.00 | |
| 1180 | Beneteau 373 | 36'11" | 2017 | 10 | 6 | $369.00 | $725.00 | |
| 1185 | Hunter Sea | 35'6" | 2009 | 10 | 6 | $349.00 | $550.00 | |
| 1190 | Beneteau 373 | 36'11" | 2017 | 10 | 6 | $369.00 | $625.00 | |
| 1200 | Beneteau 373 | 36'11" | 2017 | 10 | 6 | $369.00 | $625.00 | |
| 1205 | Beneteau 40 | 39'10" | 2018 | 12 | 6 | $489.00 | $750.00 | |
| 1225 | Hunter Sea | 35'6" | 2012 | 10 | 6 | $349.00 | $725.00 | |
| 1230 | Catalina Wave | 28'4" | 2019 | 8 | 6 | $439.00 | $675.00 |
New Prices
| San Diego Sailing | ||||||
| New Prices at 5% and 10% Increases | ||||||
| Half-Day | Full Day | |||||
| Boat ID | Make and Model | Length | 5% | 10% | 5% | 10% |
| 1010 | Catalina Wave | 28'4" | $393.75 | |||
| 1015 | Catalina Sky | 28'4" | ||||
| 1146 | Hunter Ray | 33'6" | ||||
| 1150 | Capri MKZ | 24'8" | ||||
| 1152 | Capri 22 Mk II | 24'8" | ||||
| 1164 | Capri 22 Mk II | 24'8" | ||||
| 1168 | Hunter 33 | 33'6" | ||||
| 1175 | Beneteau 40 | 39'10" | ||||
| 1180 | Beneteau 373 | 36'11" | ||||
| 1185 | Hunter Sea | 35'6" | ||||
| 1190 | Beneteau 373 | 36'11" | ||||
| 1200 | Beneteau 373 | 36'11" | ||||
| 1205 | Beneteau 40 | 39'10" | ||||
| 1225 | Hunter Sea | 35'6" | ||||
| 1230 | Catalina Wave | 28'4" |
Bookings
| San Diego Sailing Bookings | |||||
| Revenue per Passenger | |||||
| Date | Boat ID | Make and Model | # of Passengers | Total Fees | Revenue per Passenger |
| 4/5/20 | 1010 | Catalina Wave | 4 | 525 | |
| 4/8/20 | 1015 | Catalina Sky | 6 | 850 | |
| 4/11/20 | 1146 | Hunter Ray | 6 | 500 | |
| 4/14/20 | 1150 | Capri MKZ | 6 | 525 | |
| 4/17/20 | 1152 | Capri 22 Mk II | 4 | 325 | |
| 4/20/20 | 1164 | Capri 22 Mk II | 3 | 475 | |
| 4/23/20 | 1168 | Hunter 33 | 6 | 725 | |
| 4/26/20 | 1175 | Beneteau 40 | 10 | 850 | |
| 4/29/20 | 1180 | Beneteau 373 | 8 | 350 | |
| 5/2/20 | 1185 | Hunter Sea | 8 | 650 | |
| 5/5/20 | 1190 | Beneteau 373 | 10 | 625 | |
| 5/8/20 | 1200 | Beneteau 373 | 8 | 725 | |
| 5/11/20 | 1205 | Beneteau 40 | 12 | 850 | |
| 5/14/20 | 1225 | Hunter Sea | 8 | 725 | |
| 5/17/20 | 1230 | Catalina Wave | 6 | 675 | |
| Bookings by Make | |||||
| Count | Total Revenue | ||||
| Beneteau | |||||
| Capri | |||||
| Catalina | |||||
| Hunter |
