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

= 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)