Question

Your college social club holds several fund-raisers throughout the school year and donates proceeds to a local children’s charity. You are in charge of creating projections for this year’s events based on results of the previous years’ fund-raising events, and making suggestions for how to increase the return on these events.

Table Fund-Raiser Projections
	Orientation Silent Auction	Spring Fling	Homecoming Event
Projected Ticket Sales	150	300	500
Price per Ticket	$15	$30	$35
Venue Rental	$125/100 people or part thereof	$125/100 people or part thereof	$125/100 people or part thereof
Refreshments	$6/person	$12/person	$12/person
Security	Requires 1 person per 50 tickets sold, minimum of 5 security personnel at an event. Evening events are charged a flat rate of $200/security person.
Marketing	$300	$500	$1,500
Other Expenses	10% of projected ticket sales	20% of projected ticket sales	22% of projected ticket sales

Please create a worksheet presenting projected revenue, expenses, and net proceeds. Set the worksheet up to allow you to carry out what-if analysis to test various expense and revenue scenarios.

Answer 1