Assignment: EXCEL APPLICATION:
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?
3. What is the impact on net profit if the parking fee is reduced to $3?
4. What is the impact on net profit if the speaker's fee increases to $550 per seminar?
5. What is the impact on net profit of increasing the market-ing expense per seminar to $350, which increases average attendance per seminar to 50?
6. What is the impact on net profit of an increase in room rental per seminar to $300?
7. If Bora can negotiate a room rental fee of $160 per semi-nar, how much will net profit increase?
8. If technical support is included in the room rental per seminar, what is net profit?
Goal Seeking 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?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Excel-and-Access.rar