Perform a goal seek calculation establishing a break even

Question

ORCHARD Conference Model
Number of Delegates	400
INCOME
Entry Fees	Fee	Proportion		Discounts	Fee Reduction	Take up
Members	£          200.00	70%		Second Conference	10%	15%
Non-Members	£          300.00	25%		Early Bird	20%	10%
Students	£          100.00	5%
		Number		Supplement		Number
Press	£            50.00	10		Late Booking	10%	25
Total Attendees		440
EXPENDITURE
Per Conference	Amount			Per Delegate		Number		£100.00 per attendee.
Conference Hall =< 500 attendees	£      3,000.00			Conference Dinner	£            30.00
Conference Hall cancellation	£      1,000.00			Other Meals	£            20.00
Conference Hall >500 attendees	£      5,000.00	Hall Limit		Accommodation	£            75.00
		500		Additional >500	£            50.00
		Number		Rebate > 500	£            20.00
Speakers	£          200.00	30		Publishing =< 350	£               8.50
Celeb Guest	£      1,000.00	1		Publishing >350	£               5.00	350
Publishing Setup	£      2,000.00
Ad Hoc Expenses	£      4,500.00
Attendance Variations	Amount	Capacity		Expenditure Effect
Coach	250	60		Attendees <299	300
				300 < Attendees <500	10%	plus
INTERMEDIATE RESULTS
Income				Income from Delegates
Members	£    56,000.00			Delegates Total	£    88,000.00
Non-Members	£    30,000.00
Students	£      2,000.00
Press	£          500.00
Late Booking	£          550.00
Total Income	£    89,050.00
Expenditure
Conference Hall	£      3,000.00
Publishing	£      5,425.00
Speakers	£      6,000.00
Celebrity	£      1,000.00
Ad Hoc Expenses	£      4,500.00
Second Conference Discount	£      1,320.00
Early Booking Discount	£      1,760.00
Rebates	£                   -	0	How many attendees in excess of the limit?
Transport	£                   -	0	How many coaches required?
Conference Dinner	£    14,520.00
Other Meals	£      9,680.00
Accommodation	£    33,000.00
Total Expenditure	£    80,205.00
RESULTS SUMMARY
Number of delegates	400
Total Income	£    89,050.00
Total Expenditure	£    80,205.00
Net Profit	£      8,845.00

Question 1 In the Conference Model cell B41, explain what happens in the formula =B24+IF(C13>G23,G23*F22+F23*(C13-G23),C13*F22)

Question 2 In the Conference Model cell B46, explain what happens in the formula=F32*F8*G8

Question 3 In the Conference Model cell C47, explain what happens in the formula=IF(C13>C20,C13-C20,0)

Question 4 In the Conference Model cell C48, explain what happens in the formula=IF(C47>0,IF(INT(C47/C28)=(C47/C28),C47/C28,INT(C47/C28+1)),0)

Question 5 In the Conference Model cell F32, explain what is wrong with the formula=SUM(B32+B33+B34)

Question 6 In the Conference Model cell B49, explain what happens in the formula=IF((C13+C23)

Question 7 In the Conference Model cell B48, explain what happens in the formula=IF(C13>C20,C48*B28,0)

Question 8 In the Conference Model cell B36, explain what happens in the formula=G11/B4*F32*F11

Question 9 Set the number of delegates as 400. Perform a Goal Seek calculation establishing a break even figure so that the total profit is zero by adjusting the number of delegates. What is that number, to the next highest whole number

Question 10 Set the number of delegates to 334. In cells B32 to B34 the income does not reflect a whole number of delegates of each type. Explain this.