need each and every answer of yellow cell:)

Layout Formulas Data Review View Acrobat Tell me + Share Comments 11 A A 19- Number 27.0 4 $ - %% Conditiona o Ferming Table Styles For Sortida Ft APO 37 E G H Using the numbers provided below complete the Sample Hotel Income Statement and answer the 2 questions located below the income statement. ROOMS REVENUE $1,512,732 FOOD REVENUE $512,650 BEVERAGE REVENUE $265,200 TELE. REVENUE $22,122 OTHER REVENUE $25,088 RENTAL REVENUE $12,000 ADMIN AND GENERAL EXPENSE $187,921 MARKETING EXPENSE $192,326 FRANCHISE FEES $113,455 PROPERTY OPERATIONS AND MAINTENANCE $117.490 UTILITIES $93,992 ROOMS EXPENSE $361,745 FOOD EXPENSE $435,753 BEVERAGE EXPENSE $159,120 TELE EXPENSE $27,653 OTHER REVENUE EXPENSE $11,540 . What Wom wabiny VAR PACE 1991 $ %) Cond Form C31 4Xfx 648797 A D SAMPLE HOTEL INCOME STATEMENT 3 FOR YEAR ENDING DECEMBER 31, 2020 4 5 6 X OF TOT. REV 64.38 21.82 11.29 2 8 9 REVENUES ROOMS REVENUE FOOD REVENUE BEVERAGE REVENUE TELECOMMUNICATIONS OTHER REVENUE RENTAL REVENUE TOTAL REVENUES $$s 15,12,732 512,650 265,200 22.122 25.08 12.000 23.49.292 0.94 1.07 0.51 10 11 12 13 X OF TOT. RTV 36.33 14 15 16 17 18 19 DEPARTMENTAL EXPENSES ROOMS EXPENSE FOOD EXPENSE BEVERAGE EXPENSE TELECOMMUNICATIONS EXPENSE OTHER REVENUE EXPENSE TOTAL DEPARTMENTAL EXPENSES $$$ 361245 35.750 159, 120 27.653 11.540 995,811 43.76 15.58 278 1.16 GROSS OPERATING INCOME 13 53.981 21 22 23 24 25 26 27 25 29 UNDISTRIBUTED OPERATING EXPENSES ADMINISTRATIVE AND GENERAL EXPENSE MARKETING EXPENSE FRANCHISE FEES PROPERTY OPERATIONS AND MAINTENANCE UTILITIES TOTAL UNDISTRIBUTEO OPERATING EXPENSES 555 187,921 192326 113,455 117 490 93,992 705,184 N OF TOT. REV 26.65 2727 16.09 16.66 2333 30 548,792 31 13 33 34 GROSS OPERATING PROFIT Assuming they sell 45 roomsday, how much revenue does each roommake? Assuming 45 roomsday, how much gross operating profit does each room make? MARKS 35