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

Home Insert Page Calibri (Body) 11 ' = ab Wrap Text Currency X LO Paste BIU a. Av $ % 9 v Merge & Center 00 0 Cond Forn Font Clipboard Alignment Number H6 fx =D5+D6+D7 A B H 1 K IDNCL 1 2 Peformance metrics for a new store: Provide answers to the questions below: 3 4 5 6 $7,250,000) 7 8 9 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: 10 11 $14.99 $4,975,000 $1,650,000 $625,000 30% 25% 22% 35% $1,150,000 $110,000 7% $95,000 1.15% $125,000 Break-even sales in $$: Break-even sales in customers: 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: 12 13 14 15 16 17 18 19 20 21 21 22 23 24 25 26 27 20 20 29 30 31 31 32 33 34 35 24 BE (B) + esc o F1 Bo F2 F3 ODO F4 * 4 F5 11 F6 F7 Fe ! A 1 # 3 2 $ 4 % 5 6 & 7 8 Q W tab E R T Y