Question: 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?

 I need to help to complete this excel spread sheet. Here

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!