Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please find the price for cell D6, the Gross Revenue, Total Variable Costs, and Net Income. Include Excel Formulas. D Extreme H20 Break-even Analysis for

Please find the price for cell D6, the Gross Revenue, Total Variable Costs, and Net Income. Include Excel Formulas. image text in transcribed
image text in transcribed
D Extreme H20 Break-even Analysis for River Float Project Number Expenses 75 Guests 225 3 Revenue Average Number of Guests (per day) Days of Operations per Year Price Gross Revenue 8 Expenses Fixed Costs Site Development Equipment Insurance 13 Total Fixed Costs Variable Costs Labor expense (per day) Transportation (per guest) 17 Total Variable costs 18 Net Income $32,200 $3,450 $1,400 $37,050 $275 $0.85 The company would like to determine the number of customers 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 D7. 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 $0 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 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. 10 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 D19 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. Format cell F6 to hide the result of the formula in the cell. 13 Copy the information in range A3 D18 from the Break-Even Analysis sheet to the range A3: D18 on the sheet DaysAndPrice. Keep the source column widths

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Water Audits And Loss Control Programs Manual Of Water Supply Practices M36

Authors: AWWA Staff

3rd Edition

1583216316, 978-1583216316

More Books

Students also viewed these Accounting questions