Homework Assignmet

profileQueen Mabella
Jennifer.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