DO NOT GET ANSWER FROM COURSEHERO, SOLVE ON YOUR OWN

Please help with step 7 and beyond

7 8 A data table with conditional formatting will help to better visualize the expenses, revenues, and net income of the business. Fill in the Expenses, Revenue, and Net Income columns (range G4:119) using a data table. Format the range G4:119 as Currency. Copy the information in range A3:D18 from the Break-Even Analysis worksheet and paste it in range A4:D19 on the worksheet PriceAndGuest. Keep the source column widths. Create a data table in the range F5:N22. The price (row 6) needs to start at $4 and increase to $11 in $1 increments, and the number of guests (column F) needs to start at 35 and increase in increments of 5. Be sure to add a reference to cell 019 in cell F6. 9 10 11 Format the data in the data table so any net profit under $5,000 has a light red background and dark red text, data that is above or equal to -$5,000 and below $5,000 will have a light yellow background and dark yellow text, and anything $5,000 or greater will have a light green background and dark green text. 12 Format cell F6 to hide the result of the formula in the cell. Copy the information in range A3:018 from the Break-Even Analysis sheet to the range A3:018 on the sheet DaysAndPrice. Keep the source column widths. 13 G5 X foc A B G H 1 J K L M N 1 2 D E F Extreme H20 Break-even Analysis for River Float Project Number Expenses 75 Guests 225 50 $6.71 $113,269 Revenue Net Income 55 60 65 70 75 3 Revenue 4 Average Number of Guests (per day) 5 Days of Operations per Year 6 Price 7 Gross Revenue 8 Expenses 9 Fixed Costs 10 Site Development 11 Equipment 12 Insurance 13 Total Fixed Costs 14 Variable Costs 15 Labor expense (per day) 16 Transportation (per guest) 17 Total Variable Costs 18 Net Income 80 $32,200 $3,450 $1,400 $37,050 85 90 95 100 105 $275 $0.85 $76,219 SO 110 115 120 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Break-Even Analysis PriceAndGuest DaysAndPrice # M A1 X for Extreme H2O A B D E F G H M N 0 Q 4. 5 6 Two-Variable Data Table Price 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Break-Even Analysis PriceAndGuest DaysAndPrice + A B D E G H L M N O P Q R - 1 Extreme H20 Break-even Analysis for River Float Project 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Break-Even Analysis PriceAndGuest DaysAndPrice + > 7 8 A data table with conditional formatting will help to better visualize the expenses, revenues, and net income of the business. Fill in the Expenses, Revenue, and Net Income columns (range G4:119) using a data table. Format the range G4:119 as Currency. Copy the information in range A3:D18 from the Break-Even Analysis worksheet and paste it in range A4:D19 on the worksheet PriceAndGuest. Keep the source column widths. Create a data table in the range F5:N22. The price (row 6) needs to start at $4 and increase to $11 in $1 increments, and the number of guests (column F) needs to start at 35 and increase in increments of 5. Be sure to add a reference to cell 019 in cell F6. 9 10 11 Format the data in the data table so any net profit under $5,000 has a light red background and dark red text, data that is above or equal to -$5,000 and below $5,000 will have a light yellow background and dark yellow text, and anything $5,000 or greater will have a light green background and dark green text. 12 Format cell F6 to hide the result of the formula in the cell. Copy the information in range A3:018 from the Break-Even Analysis sheet to the range A3:018 on the sheet DaysAndPrice. Keep the source column widths. 13 G5 X foc A B G H 1 J K L M N 1 2 D E F Extreme H20 Break-even Analysis for River Float Project Number Expenses 75 Guests 225 50 $6.71 $113,269 Revenue Net Income 55 60 65 70 75 3 Revenue 4 Average Number of Guests (per day) 5 Days of Operations per Year 6 Price 7 Gross Revenue 8 Expenses 9 Fixed Costs 10 Site Development 11 Equipment 12 Insurance 13 Total Fixed Costs 14 Variable Costs 15 Labor expense (per day) 16 Transportation (per guest) 17 Total Variable Costs 18 Net Income 80 $32,200 $3,450 $1,400 $37,050 85 90 95 100 105 $275 $0.85 $76,219 SO 110 115 120 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Break-Even Analysis PriceAndGuest DaysAndPrice # M A1 X for Extreme H2O A B D E F G H M N 0 Q 4. 5 6 Two-Variable Data Table Price 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Break-Even Analysis PriceAndGuest DaysAndPrice + A B D E G H L M N O P Q R - 1 Extreme H20 Break-even Analysis for River Float Project 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Break-Even Analysis PriceAndGuest DaysAndPrice + >