Question

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? <Figure A> HOSPITAL SEMINAR SERIES DATA Hospital Seminars Revenues and Expenses Revenue: Registration Fees Parking Fees

Im trying to find the what if questions but i dint know how to do it. I'm stuck in this part

Answer 1

Solution to What if analysis problem is as under:

Scenario Summary
		Current Values:	Average attendence per seminar	Average attendence per seminar increased to	Average Attendence per seminar reduced to	Parking Fees	Parking fees reduced to	Speakers Fee	Speakers fee increased to	Marketing expense per seminar	Marketing expense per seminar increased to	Due to increase in Marketing expense,average attendence per seminar change to	Room rental per seminar	Room rental per seminar increased to
Changing Cells:
	$C$24	40	40	45	35	40	40	40	40	40	40	50	40	40
	$C$27	$66.67	$66.67	$66.67	$66.67	$66.67	$3.00	$66.67	$66.67	$66.67	$66.67	$66.67	$66.67	$66.67
	$C$20	$500	$500	$500	$500	$500	$500	$500	$550	$500	$500	$500	$500	$500
	$C$26	$250	$250	$250	$250	$250	$250	$250	$250	$250	$350	$350	$250	$250
	$C$25	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$250	$300
Result Cells:
	$C$16	$3,800	$3,800	$5,900	$1,700	$3,800	$3,036	$3,800	$3,200	$3,800	$2,600	$6,800	$3,800	$3,200
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.

Hospital Seminars Revenue and Expenses
		(Figures in $)
Revenue:
Registration Fees		$16,800
Parking Fees		$800
Sub-total		$17,600
Expenses:
Speaker's Fee		$6,000
Tech Support		$1,800
Marketing		$3,000
Room Rental		$3,000
Sub-total		$13,800
Net Income / (Loss)		$3,800
Variables:
Speaker's Fee (per session)		$500
Tech Support Cost per Session		$150
Seminars per year		12
Registration Fee (per person)		$35
Attendees per seminar		40
Room rental per seminar		$250
Marketing Expense per seminar		$250
Parking Fee per seminar		$66.67

Solution to Goal Seek Problem is as under:

1) Attendees required to attend the seminar to generate Net Profit of $5500

Hospital Seminars Revenue and Expenses
		(Figures in $)
Revenue:
Registration Fees		$18,500
Parking Fees		$800
Sub-total		$19,300
Expenses:
Speaker's Fee		$6,000
Tech Support		$1,800
Marketing		$3,000
Room Rental		$3,000
Sub-total		$13,800
Net Income / (Loss)		$5,500
Variables:
Speaker's Fee (per session)		$500
Tech Support Cost per Session		$150
Seminars per year		12
Registration Fee (per person)		$35
Attendees per seminar		44
Room rental per seminar		$250
Marketing Expense per seminar		$250
Parking Fee per seminar		$66.67

2) Parking fees required to charge to generate net profit of $ 4150

Hospital Seminars Revenue and Expenses
		(Figures in $)
Revenue:
Registration Fees		$16,800
Parking Fees		$1,150
Sub-total		$17,950
Expenses:
Speaker's Fee		$6,000
Tech Support		$1,800
Marketing		$3,000
Room Rental		$3,000
Sub-total		$13,800
Net Income / (Loss)		$4,150
Variables:
Speaker's Fee (per session)		$500
Tech Support Cost per Session		$150
Seminars per year		12
Registration Fee (per person)		$35
Attendees per seminar		40
Room rental per seminar		$250
Marketing Expense per seminar		$250
Parking Fee per seminar		$95.83

3) Registration fee required to charge from per attendee to generate Net Profit of $ 5750

Hospital Seminars Revenue and Expenses
		(Figures in $)
Revenue:
Registration Fees		$18,750
Parking Fees		$800
Sub-total		$19,550
Expenses:
Speaker's Fee		$6,000
Tech Support		$1,800
Marketing		$3,000
Room Rental		$3,000
Sub-total		$13,800
Net Income / (Loss)		$5,750
Variables:
Speaker's Fee (per session)		$500
Tech Support Cost per Session		$150
Seminars per year		12
Registration Fee (per person)		$39
Attendees per seminar		40
Room rental per seminar		$250
Marketing Expense per seminar		$250
Parking Fee per seminar		$66.67