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 D E F G H 1 J 1 2 3 % The Elegant Dump's Restaurant Income Statement Base Year Revenues 20x0 Food $ 1,200,000 Beverage $ 350,000 Other $ 27,000 4 20X1 % $1,300,000 $250,000 $25,000 20X2 % $1,500,000 $300,000 $30,000 5 6 7 8 Total Revenues $1,577,000 $1,575,000 $1,830,000 9 $ $ $ 450,000 52,000 10,000 $435,000 $46,000 $12,000 $475,000 $52,000 $14,000 $512,000 $493,000 $541,000 $ $ $ 750,000 199,000 11,000 $865,000 $204,000 $13,000 $1,025,000 $248,000 $16,000 $960,000 $1,082,000 $1,289,000 $ $ 10 Cost of Sales 11 Food 12 Beverage 13 Other 14 15 Total Cost of Sales 16 17 Gross Profit 18 Food 19 Beverage 20 Other 21 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 44 Income Before Income Taxes 45 16 Tab 1 - Vertical $ $ $ $ $ $ 559,000 121,000 $680,000 50,000 62,000 77,000 27,000 36,000 36,000 $600,000 $125,000 $725,000 $55,000 $65,000 $75,000 $25,000 $35,000 $40,000 $1,020,000 $750,000 $175,000 $925,000 $65,000 $75,000 $85,000 $35,000 $15,000 $10,000 $1,210,000 $968,000 -$8,000 $62,000 $ 79,000 $ $ $ 18,000 5,000 3,000 $26,000 $20,000 $5,000 $3,000 $28,000 $22,000 $8,000 $4,000 $34,000 $ 34,000 $34,000 $45,000 Tab 2 - Horizontal Base Year Screenshot