Refer a friend and get % off! They'll get % off too.

Analyzing Revenue and Expenses for City Hospital Seminars Figure 7-25 shows the Excel spreadsheet that Bora uses to eval-uate the variables relating to the hospital seminar series. She has asked you to use Excel to create a similar spreadsheet to conduct

 

Analyzing Revenue and Expenses for City Hospital Seminars Figure 7-25 shows the Excel spreadsheet that Bora uses to eval-uate the variables relating to the hospital seminar series. She has asked you to use Excel to create a similar spreadsheet to conduct additional what-if and goal seeking analyses. You will need to use the following formulas: Revenue Registration Fees 5 Attendees per seminar 3 Registration fee × Seminars per year

Parking Fees 5 (Attendees per seminar/Average number attendees per car) 3 Seminars per year 3 Parking fee

Expenses Speakers’ Fees 5 Speaker’s fee per session 3 Seminars per year

Tech Support 5 Tech support cost per session 3 Seminars per year

Marketing 5 Marketing cost per seminar 3 Seminars per year

Room Rental 5 Room rental per seminar 3 Seminars per year What-If Questions

After answering each question, be sure to return the variables to their original values shown in Figure 7-25 before testing the impact of changing another one. 1. What is the impact on net profit if the average attendance per seminar increases to 45?

2. What is the impact on net profit if the average attendance drops to 35?

You will get a DOCX (88KB) file

$ 5.00

$ 5.00

Buy Now

Discount has been applied.

Added to cart
or
Add to Cart
Adding ...