please help

Tujeci vesc puon: Extreme H20 is a company that specializes in water sports. It is considering adding some new experiences for its customers. In a nearby community there is a small river that can be used for tubing. The management is trying to figure out how much usage it might receive and where to set the price in order to make a profit. The company seeks to make sure the project would at least break even the first year after development costs. Management has tasked you with developing a worksheel to analyze the situation Steps to Perform: Step Instructions Points Possible 1 0 2 5 3 5 4 5 UN 5 5 6 10 Start Excel Open the downloaded file named Excel_Ch10_PS2_ Float xlsx Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. The company would like to determine the number of custorners it should book per day in order to break even. They would like to analyze this using a break-even analysis. On the Break Even Analysis worksheet, enter the correct formula to calculate the Gross Revenue in cell 07 Enter the correct formula to calculate the Total Fixed Costs in D13 In cell D17 enter the correct formula to calculate the Total Variable Costs based upon the average number of guests per day and the days of operations per year Enter the correct formula to calculate the Net Income in D18 Management thinks an average of 85 guests a day would be a realistic average Use Goal Seek to find out what the price would need to be to come out exactly even with 85 guests per day and 50 in Net Income 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 columins (range G4 119) using a data table Format the range G4119 as Currency Copy the information in range A3.018 from the Break-Even Analysis worksheet and paste it in tange A4 D19 on the worksheet Price And Guest Keep the source column widths. Create a data table in the range F5 N22 The price (row 6) needs to start at 54 and increase to $11 in 51 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, 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 7 10 8 5 9 5 10 10 11 10 1 A 1 Revenue Net Income 2 3 Revenue 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 Extreme H20 Break-even Analysis for River Float Project Number Expenses 75 Guests 225 50 55 60 65 70 $32,200 75 $3,450 80 $1,400 85 90 95 $275 100 $0.85 105 110 115 120 59 20 21 22 23 24 25 26 27 28 29 Break Even Analysis PriceAndGuest DaysAndPrice Tujeci vesc puon: Extreme H20 is a company that specializes in water sports. It is considering adding some new experiences for its customers. In a nearby community there is a small river that can be used for tubing. The management is trying to figure out how much usage it might receive and where to set the price in order to make a profit. The company seeks to make sure the project would at least break even the first year after development costs. Management has tasked you with developing a worksheel to analyze the situation Steps to Perform: Step Instructions Points Possible 1 0 2 5 3 5 4 5 UN 5 5 6 10 Start Excel Open the downloaded file named Excel_Ch10_PS2_ Float xlsx Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. The company would like to determine the number of custorners it should book per day in order to break even. They would like to analyze this using a break-even analysis. On the Break Even Analysis worksheet, enter the correct formula to calculate the Gross Revenue in cell 07 Enter the correct formula to calculate the Total Fixed Costs in D13 In cell D17 enter the correct formula to calculate the Total Variable Costs based upon the average number of guests per day and the days of operations per year Enter the correct formula to calculate the Net Income in D18 Management thinks an average of 85 guests a day would be a realistic average Use Goal Seek to find out what the price would need to be to come out exactly even with 85 guests per day and 50 in Net Income 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 columins (range G4 119) using a data table Format the range G4119 as Currency Copy the information in range A3.018 from the Break-Even Analysis worksheet and paste it in tange A4 D19 on the worksheet Price And Guest Keep the source column widths. Create a data table in the range F5 N22 The price (row 6) needs to start at 54 and increase to $11 in 51 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, 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 7 10 8 5 9 5 10 10 11 10 1 A 1 Revenue Net Income 2 3 Revenue 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 Extreme H20 Break-even Analysis for River Float Project Number Expenses 75 Guests 225 50 55 60 65 70 $32,200 75 $3,450 80 $1,400 85 90 95 $275 100 $0.85 105 110 115 120 59 20 21 22 23 24 25 26 27 28 29 Break Even Analysis PriceAndGuest DaysAndPrice