Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Excel Basics - Student The Accounting Club wants to have a party for its members. The cost of renting a space and the cost of
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? ?
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? | ? | ||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started