Excel Basics - Student
The Accounting Club wants to have a party for its members. The cost of renting a space and the cost of refreshments per person are given in the table below. The rental company will provide discounts on the rental space and refreshments if they have a larger group attend.
	# of People Attending	Cost for Refreshments per Person
	0 - 100 people	$15
	101 - 200 people	$14
	201 - 300 people	$12
	301+ people	$10
	# of People Attending	Total Rental Cost
	0 - 300 people	$1,500
	301+ people	$1,250
	Other Data
	# of Members	325
	Party Budget	$7,500
Required
The Accounting Club wants to determine the cost of the party if 80% of the members attend and if all members attend
the party. Determine the Total Cost and the Average Cost for the two attendance levels below.
	# of Members Attending	Total Cost	Average Cost per Person
	260	people (80% of members)	?	?
	325	people (all members)	?	?
If all members attend, the Accounting Club wants to determine if they can afford to invite all of the members' spouses.
Using an IF statement, determine if the Accounting Club can invite the spouses and stay within their budget.
	Party Budget	$7,500
	# of People Attending	650
	Total Cost	?
	Who should be invited?	?