Given the data below calculate the income statement by inserting the correct formulas into the ALL GREEN boxes After you hoave completed the income statement upload the file to the question box Sales Cross Check Calculations Food $412,453 12.57% Merchandise 10.00% $328,125 $984,375 Catering 30.00% Delivery $557,813 17.00% Beverage $998,540 30.43% Total Sales $3,281.250 100.00% 100% Cost of Sales Food 33.35% 12.00% Merchandise Catering Delivery 22.00% 17.00% Beverage 24.00% Total Cost of Sales Gross Profit 0.00% 14.00% 16.00% Controllable Expenses Payroll - Fixed Payroll - Variable Employee Benefits Direct Operating Expenses Music and Entertainment Advertising and Promotion 4.50% 5.50% 1.25% 2.50% 3.25% 2.50% 1.10% 0.00% Utilities Administration and General Repair and Maintenance Total Controllable Expenses Income Before Occupation Costs Occupational Costs Rent Property Tax Other Tax 0.00% $158,000 $95,000 $72,000 $195,000 $217,500 Property Insurance Interest Depreciation $150,000 Total Occupational Costs 0.00% Restaurant Profit Before Income Taxes 1. Based on the following information, generate an income statement for the entire year: a. Seats: 250 b. Ave Check: $12.50 C. TO: 3.0 d. Catering Sales: 30% of food sales e. Merchandise sales: 10% of food sales f. Occ. %: 82% g. Popularity %: 78% h. Days Open: 350 i. Delivery sales: 17% of food sales j. Beverage sales: $998,540 k. Costs of Sales Percentages: 1. Food: 33.35% 2. Beverage: 24% 3. Merchandise: 12% 4. Catering: 22% 5. Delivery: 17% 1. Fixed Payroll: 14% m. Variable payroll: 16% n. Employee Benefits: 4.50% 0. Direct Op. Exp.: 5.50% p. Music: 1.25% q. Advertising: 2.50% r. Utilities: 3.25% S. Administrative: 2.50% t. Repairs and Main.: 1.10% u. Rent: $ 158,000 V. Interest: $217,500 W. Insurance: $195,000 X. Depreciation: $150,000 y. Property Tax: $95,000 Z. Other Tax: $72,000