Homework Assignmet
Queen MabellaJennifer.Anderson-SanDiegoSailing-02.xlsx
Fleet
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 |