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.

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
Get step-by-step solutions from verified subject matter experts
