Question: I need help please. Screenshot is attached. Management thinks an average of 75 guests a day would be a realistic average. Use Goal Seek to

I need help please. Screenshot is attached.

Management thinks an average of 75 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 75 guests per day and $0 in Net Income.

Fill in the Expenses, Revenue, and Net Income columns (range G4:I19) using a data table.

I need help please. Screenshot is attached. Management thinks an average of

Hott_e05ch10_grader_a1_Float (1) - Excel - X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW DEVELOPER Samantha Hott Calibri - 11 - A" A" General Conditional Formatting Insert E * % " y Format as Table X Delete - AY H Paste Cell Styles - Format Sort & Find & Filter * Select* Clipboard Font Alignment Number G Styles Cells Editing A B C D F G H Extreme H20 N Break-even Analysis for River Float Project Revenue Number Expenses Revenue Net Income Average Number of Guests (per day) 75 Guests $80,306.25 $80,306.25 $0.00 Days of Operations per Year 200 30 Price $5.35 35 Gross Revenue $80,306 40 8 Expenses 45 Fixed Costs 50 ite Development $28,000 55 Equipment $3,000 60 12 Insurance $1,250 65 13 Total Fixed Costs $32,250 70 14 Variable Costs 75 15 Labor expense (per day) $240 80 16 Transportation (per guest) $0.75 85 17 Total Variable Costs $48,056 90 18 Net Income SO 95 19 100 20 21 22 23 25 26 Break-Even Analysis PriceAndGuest DaysAndPrice + READY J -- + 90%

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!