Question: 2. Break-even Analysis for River Float Project 3 Revenue 4 Average Number of Guests (per day) 85 5 Days of Operations per Year 225 6

 2. Break-even Analysis for River Float Project 3 Revenue 4 Average

Number of Guests (per day) 85 5 Days of Operations per Year

2. Break-even Analysis for River Float Project 3 Revenue 4 Average Number of Guests (per day) 85 5 Days of Operations per Year 225 6 Price $6.02 7 Gross Revenue $115,181 8 Expenses 9 Fixed Costs 10 Site Development $32,200 11 Equipment $3,450 12 Insurance $1,400 13 Total Fixed Costs $37,050 14 Variable Costs 15 Labor expense (per day) $275 16 Transportation (per guest) $0.85 17 Total Variable Costs $78,131 18 Net Income $0 19 (Ctrl) - 20 21 22 Break-Even Analysis PriceAndGuest DaysAndPrice + Add a scroll bar to the right of the inserted cells in column F that will change the days of operations per year between the values of 225 and 275 one day at a time. Enter the text Days of Operations in cell F4 and center the text. Add a scroll bar to the right or below of the first scroll bar in column I that will change the price between the values of $4 and $11 by $1 increments. Enter the text Price in cell 14. 2. Break-even Analysis for River Float Project 3 Revenue 4 Average Number of Guests (per day) 85 5 Days of Operations per Year 225 6 Price $6.02 7 Gross Revenue $115,181 8 Expenses 9 Fixed Costs 10 Site Development $32,200 11 Equipment $3,450 12 Insurance $1,400 13 Total Fixed Costs $37,050 14 Variable Costs 15 Labor expense (per day) $275 16 Transportation (per guest) $0.85 17 Total Variable Costs $78,131 18 Net Income $0 19 (Ctrl) - 20 21 22 Break-Even Analysis PriceAndGuest DaysAndPrice + Add a scroll bar to the right of the inserted cells in column F that will change the days of operations per year between the values of 225 and 275 one day at a time. Enter the text Days of Operations in cell F4 and center the text. Add a scroll bar to the right or below of the first scroll bar in column I that will change the price between the values of $4 and $11 by $1 increments. Enter the text Price in cell 14

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!