Reference no: EM131792926
|
|
|
|
|
|
|
|
|
|
|
| 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)<F28,F28*F17,IF((C13+C23)<C20,C13*F17*(1+F29),C13*F17))
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.