90.2K

Verified Solution

Link Copied!

Insert Mi Duyexlsx - Protected Page Layout PROTECTED VIEW Formulas Data Be careful--files from the Internet can contain viruses. Unless you need to Review View H H9 --NM Income Statement D Percent 3 Sales 4 Food 5 Beverage 6 Total Sales 7 Cost of Sales 8 Food Cost 9 Beverage Cost 10 Cost of Goods Sold 11 Gross Profit Dollars 1,013,600 386,400 1,400,000 72.4% 27.6% 100.0% 331,447 85,394 416,841 32.7% 22.1% 29.8% 70.2% 12 403,200 96,600 499,800 916,641 28.8% 6.996 35.7 65.5% 13 Labour 14 Salaries & Wages 15 Employee Benefits 16 Total Labour Costs 17 Prime Cost 18 Controllable Expenses 19 Direct Operating Expenses 20 Music & Entertainment 21 Marketing 22 Utilities 23 General & Administrative 24 Repairs & Maintenance 25 Total Controllable Expenses 26 Income Before Fixed Costs 27 28 Fixed Costs 29 Occupancy Costs 30 Interest 31 Depreciation 32 Total Fixed Costs 33 Earnings Before Interest and Tax (EBIT) 70,000 11,200 32,200 63,000 37,800 7,000 5.0% 0.8% 2.3% 4.5% 2.2% 0.5 15.8% 18.7% 221,200 262.159 140,000 65,000 21,000 10.0% 4.6% 1.5% 16.1% 266 226.000 for your info AutoSave OOH E xO2 Income Statement Budget.xlsx . Protected View - Excel File Home Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit it's safer to st AI fr Income Statement Income Sement Out of 5 points 225 for each You own a restaurant that had the following results in the past year. The restaurankis located in downtown Vancouver and there has been a major economic slowdown whereby 100 000 jobs newly we going to be eliminated What do you do on your restaurant budget? Instructions 4 Name of your Restaurant 8 Sales Dollars Percent MGMT Goals Dollars this? What actions will you take i.e. Do a food giveaway promo, cut heat, hire a bandl but we are going to look at capturing more sales from residents. Although we will decline will not be as bad pace as lots of our beverage sales are to be people who live 1.000.000 724% 670% 206400 TULED 27.6% 33.0% 100.0%Secline 112% 10 Beverage 11 Total Sales Cost of Sales 13 Food Cost 14 Beverage Cost 15 Cost of Goods Sold 18 Gross Profit 331447 05294 32094 2003 467041 >21 23 70.2% 403.200 23 % 10 Labour 13 Series & Wapes 20 Emplovee Benefits 21 Total Labour Costs 22 Prime Cost 23 Controllable Expenses 24 Direct Operating Expenses 25 Music & Entertainment 69% 357% 655 70.000 11.200 50% 094 27 Dites 28 General & Administrative 2 Pepers & Maintenance 30 Total Controllable Expenses 31 Income Before Fixed Coats 187% 34 Fixed Costs Occupancy Couts 100% 37 Total Fixed Costs Budget with increase Budget with Decrease for your info Ready TULLILU VICEV - Excel File Home Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay E30 Income Statement Budget You own a restaurant that had the following results in the past year. The economy is growing at a rate of 5% The local Colleges and hospitals are growing We are expecting a long dry summer next vear. Please Name your restaurant stale some brief outlines on its concept. You can assume the one in class. Then fill out the grey areas on the budget On the grey areas of the budget, you need to fill out what you think the budget would be and what your numbers and percent totals would be in relation to that variable 3 Instructions 4 Name of your Restaurant 5 Concept 7 8 Sales MGMT Goals % Dollars this? What actions will you take i.e. Do a food giveaway prome, cut heal hire a band) Keep our strong focus on food but grow beverage so it outpaces revenue growth on beverages Need to grow beverages so we can increase our gross margin 9 Food 1013.600 72.4% 710% 27.6% 100.0% 29.0% Grow 5% 320% 200 32.7% 22 29.8% 702% 10 Beverage 399 400 11 Total Sales 12 Cost of Sales 13 Food Cost 331447 14 Beverage Cost 85.394 15 Cost of Goods Sold 15 Gross Profit 17 18 Labour 13 Salaries & Wages 203 200 20 Emplouse Benefits 21 Total Labour Costs 22 Prime Cost 23 Controllable Expenses 24 Direct Operating Expense 70 000 25 Music & Entertainment 11200 28 Marketing 323200 27 Uhilities 63000 28 General & Administrative 37 800 29 Repairs & Maintenance 30 Total Controllable Expenses 31 Income Before Fixed Costs 915750 28.8% 6.9% 36.72 65.5% 50X 0.8% 452 27% 0.5% 7000 1584 1874 33 Fixed Costs 34 Occupancy Costs 35 Interest 37 Total Fixed Costs 38 Net Income 140.000 65.000 21000 100% 4.6% 15 2654 Budget with increase Budget with Decrease For your info Ready

Answer & Explanation Solved by verified expert

See Answer