Answered step by step
Verified Expert Solution
Link Copied!

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?

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Crypto Spotlight Series The Graph

Authors: Nott U.r. Keys

1st Edition

979-8854247733

More Books

Students also viewed these Finance questions

Question

Describe the three types of start-up firms.

Answered: 1 week ago