Excel Problem 1. Using the included excel sheet create a vertical analysis (tab 1), horizontal analysis (tab 2), and base year comparison analysis (tab 3). You will fill in all gray cells in the excel workbook. A B E F G . 1 The Elegant bump's Restaurant Income Statement 2. 3 Revenues Percentages 4 Food 5 Beverage Other $1,300,000 $250,000 $ 25,000 6 7 8 Total Revenues $1,575,000 9 10 Cost of Sales 11 Food 12 Beverage 13 Other 14 $435,000 $46,000 $12,000 15 Total Cost of Sales $493,000 16 17 Gross Profit 18 Food 19 Beverage 20 Other $865,000 $204,000 $13,000 21 $1,082,000 22 Total Gross Profit 23 24 Operating (Controllable) Expenses 25 Salaries and Wages 26 Employee Benefits 27 Total Labor Cost 28 Direct Operating Expenses 29 Marketing 30 Utilities 31 Admin and General 32 Repairs and Maintenance 33 Music and Entertainment 34 Total Operating Expenses 35 36 Operating Income 37 38 Other (Noncontrollable) Expenses 39 Rent 40 Depreciation 41 Interest 42 Total NonControllable Expenses 43 $600,000 $125,000 $725,000 $55,000 $65,000 $75,000 $25,000 $35,000 $40,000 $1,020,000 $62,000 $20,000 $5,000 $3,000 $28,000 44 Income Before Income Taxes $34,000 45 16 Tab 1 - Vertical Tab 2 - Horizontal Base Year