Question: Solve this exercise by using Excel (insert formula). Revenue Registration Fees Attendees per seminar x Registration fee x Seminars per year Parking Fees (Attendees per
Solve this exercise by using Excel (insert formula).




Revenue Registration Fees Attendees per seminar x Registration fee x Seminars per year Parking Fees (Attendees per seminar /Average number attendees per car) Seminars per year x Parking fee x Expenses Speakers/Fees = Speaker's fee per session x Seminars per year Tech Support Tech Support cost per session x Seminars per year Marketing Marketing cost per seminar x Seminars per year Room Rental Room rental per seminar x Seminars per year What-If Questions After answering each question, be sure to return the variables to their original values shown in Figure 7.26 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 marketing 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 seminar, how much will net profit increase? S. If technical support is included in the room rental per seminar, what is net profit?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
