Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need to help to complete this excel spread sheet. Here is the info needed to complete. The vp of corporate relations reached out to
I need to help to complete this excel spread sheet.
Here is the info needed to complete.
The vp of corporate relations reached out to you and ask for help with burger fl case fundraising event. This year the company wants to donate more money to charity. For this to happen, the vp wants to know how many people need to participate in the event
They need your expertise to calculate the # of people needed to achieve the fundraising goals.
After meeting with event planer, he provided you with the budget for the event.
- Food cost per person
- Beverage cost per person
- Labor cost per person
- Suggested ticket price for event
- Fixed cost for the event
- How many people are needed to breakeven?
- How many people are needed to generate more profits for the charity?
AutoSave OFF Exam #1 Q4-C (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v AI v 11 ab Wrap Text v . Accounting Hv Insert DX Delete Paste B CA Merge & Center $ % 9 68 69 Ideas Conditional Format Cell Formatting as Table Styles Styles Sort & Filter Find & Select Sensitivity Format Cells Font Alignment Number Editing Ideas Sensitivity Clipboard D9 . X fx 150 A B D E F G H 1 J O BURGEREI 5 6 7 8 9 10 11 BURGERFI CARES Fundraising Event Budget Food Cost Per Person: $ 19.50 Beverage Cost Per Person: $ 8.25 Labor Cost Per Person: $ 5.75 Suggested Ticket Price for Event: $ 150.00 Fixed Costs for the Event: $ 25,000.00 12 13 14 Sales needed to Break-even: Customers needed to Break-even: Sales needed for $15,000 profit: Customers needed for $15,000 profit: Sales needed for $20,000 profit: Customers needed for $20,000 profit: 15 16 17 18 19 20 21 22 23 Event BE (C) + 175%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started