4. Select J4 on the Fleet worksheet, and create a formula to calculate a 5%_increase for the data in the "4 Hr. Rate" column using the range name assigned on the Data worksheet.

   1. Type =

   2. Select F4 and type *.

   3. Press function Key F3 to open the Paste Name dialog box.

   4. Select 5%_lncrease and click OK.

6. Similarly, create formulas for K4:O4 and copy the formulas to row 5 up to row 18.

A B D E F G H 1 J K L M N O 1 2 3 Boat ID 5% Galley w Stove 5% Increase 10% Increase 15% Increase Full Dry Rate 10% 1596 Increase Increase 4 1010 1015 1146 S Model Year 2002 2003 2006 Length Seats Sleeps 28'4" 6 2824 6 336" 10 6 J. 6 7 1150 6 4 2007 2007 8 9 24'89 6 4 1152 1164 6 4 2008 2009 10 11 10 Boat Type Catalina 220 Catalina 220 Hunter 33 Cavi MK Capri 22 Mku Capri Mk Hunter 33 Beneteau 40 Beneteau 373 Hunter 16 Beneteau 371 Beneteau 373 Beneteau 40 Hunter 36 Catalina 20 6 1168 1175 1180 1185 1190 336 3910 36'ir 4 Hr Full Day Rate Rate $129.00 $179.00 $139.00 $179.00 $299.00 $349.00 S65.00 $89.00 S65.00 $89.00 $65.00 $89.00 $299.00 $349.00 $489.00 5529.00 $369.00 $400.00 $349.00 S389.00 $369.00 5409.00 $369.00 S409.00 $49.00 S529.00 $349.00 $389.00 SI319.00 $129.00 12 10 6 6 2010 2011 - 12 13 10 6 2011 14 35'6" 361 10 6 2012 15 1200 3811 10 6 2012 16 17 39*10. 12 2014 1205 1225 3596 10 2014 2014 18 1230 X 6 A B D E F G H 1 J K L M N O 1 2 3 Boat ID 5% Galley w Stove 5% Increase 10% Increase 15% Increase Full Dry Rate 10% 1596 Increase Increase 4 1010 1015 1146 S Model Year 2002 2003 2006 Length Seats Sleeps 28'4" 6 2824 6 336" 10 6 J. 6 7 1150 6 4 2007 2007 8 9 24'89 6 4 1152 1164 6 4 2008 2009 10 11 10 Boat Type Catalina 220 Catalina 220 Hunter 33 Cavi MK Capri 22 Mku Capri Mk Hunter 33 Beneteau 40 Beneteau 373 Hunter 16 Beneteau 371 Beneteau 373 Beneteau 40 Hunter 36 Catalina 20 6 1168 1175 1180 1185 1190 336 3910 36'ir 4 Hr Full Day Rate Rate $129.00 $179.00 $139.00 $179.00 $299.00 $349.00 S65.00 $89.00 S65.00 $89.00 $65.00 $89.00 $299.00 $349.00 $489.00 5529.00 $369.00 $400.00 $349.00 S389.00 $369.00 5409.00 $369.00 S409.00 $49.00 S529.00 $349.00 $389.00 SI319.00 $129.00 12 10 6 6 2010 2011 - 12 13 10 6 2011 14 35'6" 361 10 6 2012 15 1200 3811 10 6 2012 16 17 39*10. 12 2014 1205 1225 3596 10 2014 2014 18 1230 X 6