Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Im trying to find the what if questions but i dint know how to do it. I'm stuck in this part Computer project 5-1 What

image text in transcribed
image text in transcribed
Im trying to find the what if questions but i dint know how to do it. I'm stuck in this part
image text in transcribed
Computer project 5-1 What If Questions 1. What would be the impact on net profit if the average attendance per seminar increased to 457 2. What would be the impact on net profit if the average attendance dropped to 357 3. What would be the impact on net profit if the parking fee is reduced to $3? 4. What would be the impact on net profit if the speaker's fee increased to $550 per seminar? 5. What would be the impact on net profit of increasing the marketing expense per seminar to $350, resulting in an increase in average attendance per seminar to 507 6. What would be the impact on net profit of an increase in room rental per seminar to $3007 Goal-Seek Questions 1. Given the expenses and variables presented in the figure, how many attendees per seminar are required to generate a net profit of $5,500? 2. What parking fee results in a net profit of $4,150? 3. What registration fee per attendee results in a net profit of $5,750?
HOSPITAL SEMINAR SERIES DATA Hospital Seminars Revenues and Expenses Revenue: Registration Fees Parking Fees Get External Data Geography Refresh All Stocks A Data Tools Outline S What If Analysis | Sort Filter x v fx =E18*E20 A B C D E Hospital Seminars Revenue and Expenses F 1 3 Revenue: 4 Registration Fees 5 Parking Fees 6 Subtotal $16,800.00 $800.00 $17,600.00 8 Expenses: 9 Speakers' Fee 10 Tech support 11 Marketing 12 Room Rental 13 Subtotal $6,000.00 $1,800.00 $3,000.00 $3,000.00 $13,800.00 $3,800.00 15 Net Income/Loss 16 17 Variables: 18 Speaker's Fee (per session) 19 Tech Support cost per session 20 Seminars per year 21 Registration Fee (per person) 22 attendees per seminar 23 Room Rental per seminar Sheet1 $150 $35 40 $250 Ready + 150% MacBook Pro esc_ BIUDA * ABF_350_2_ Sort Filter Data Tools What if Analysis Outline Formula Bar Seek D d Expenses Set cell: E9 puter To value: By changing cell: $16,800.00 $800.00 $17,600.00 Cancel OK Upload your finished Using the What If and - Click Data, click Wha - You must first calculat - You may write all you - Show how you comput What If Ouestions 1. What would be the imp 452 2. What would be the imp 3. What would be the impa 4. What would be the impa 5. What would be the impa $350, resulting in an ince 6. What would be the impa $6,000.00 $1,800.00 $3,000.00 $3,000.00 $13,800.00 $3,800.00 $500 $150 12 $35 Goal Seck Questions 1. Given the expenses and vari are required to generate a ne 2. What parking fee results in a 3. What registration fee per atte $250

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

Environmental Auditing Fundamentals And Techniques

Authors: J. Ladd Greeno

2nd Edition

091509410X, 978-0915094103

More Books

Students also viewed these Accounting questions

Question

5. Prepare for the role of interviewee

Answered: 1 week ago

Question

6. Secure job interviews and manage them with confidence

Answered: 1 week ago