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. After graduating from your college, you laned a

I need to help to complete this excel spread sheet. Here is the info needed to complete. After graduating from your college, you laned a new job as district manager for burger fl. The vice president of finance knows you took financial class and is aware of your capabilities of conducting breakeven and profitability analysis. You are requested to develop different profit scenarios for potential new store. Based on historical performance at similar locations you are provided with performance

image text in transcribed

= IM 2 Merge & Center $ % 9 Clipboard Conditional Forma Formatting as Tab Font Alignment Number X & fx Styles A B D E G H 1 J K L M BURGERFI Peformance metrics for a new store: Provide answers to the questions below: . 5 7 8 9 10 Average Check: Forecast Food Sales: Forecast Beverage Sales: Forecast Desserts Sales: Forecasted Food Cost: Forecasted Beverage Cost: Forecasted Desserts Cost: Labor Cost (hourly): Labor Cost (salary): Rent (year): Franchise Fee: Depreciation: Marketing Expense: Employee Benefits: $15.99 $5,000,000 $1,750,000 $650,000 30% 25% 22% 35% $1,250,000 $110,000 7% $95,000 1.15% $125,000 Break-even sales in $$: Customers to Break-even: Sales for $150,000 profits: Customers for $150,000 profits: Sales for $300,000 profits: Customers for $300,000 profits: Sales for $450,000 profits: Customers for $450,000 profits: Sales for $600,000 profits: Customers for $600,000 profits: 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 BE (A) = IM 2 Merge & Center $ % 9 Clipboard Conditional Forma Formatting as Tab Font Alignment Number X & fx Styles A B D E G H 1 J K L M BURGERFI Peformance metrics for a new store: Provide answers to the questions below: . 5 7 8 9 10 Average Check: Forecast Food Sales: Forecast Beverage Sales: Forecast Desserts Sales: Forecasted Food Cost: Forecasted Beverage Cost: Forecasted Desserts Cost: Labor Cost (hourly): Labor Cost (salary): Rent (year): Franchise Fee: Depreciation: Marketing Expense: Employee Benefits: $15.99 $5,000,000 $1,750,000 $650,000 30% 25% 22% 35% $1,250,000 $110,000 7% $95,000 1.15% $125,000 Break-even sales in $$: Customers to Break-even: Sales for $150,000 profits: Customers for $150,000 profits: Sales for $300,000 profits: Customers for $300,000 profits: Sales for $450,000 profits: Customers for $450,000 profits: Sales for $600,000 profits: Customers for $600,000 profits: 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 BE (A)

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

Environmental Health And Safety Audits A Compendium Of Thoughts And Trends

Authors: Lawrence B. Cahill

2nd Edition

1598889737, 978-1598889734

More Books

Students also viewed these Accounting questions

Question

L A -r- P[N]

Answered: 1 week ago