Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
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

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

Financial Accounting Information for Decisions

Authors: John J. Wild

9th edition

1259917045, 978-1259917042

More Books

Students also viewed these Accounting questions

Question

What is the difference between immediate family and close relative?

Answered: 1 week ago

Question

Do not get married, wait until I come, etc.

Answered: 1 week ago

Question

Do not come to the conclusion too quickly

Answered: 1 week ago

Question

Engage everyone in the dialogue

Answered: 1 week ago