2. Terry Ray manages a hotel in an urban Midwestern city. He wants to use vertical analysis in order to evaluate his income statement (P&L). Complete the spreadsheet to help him evaluate his effectiveness as a manager Terry's P&L Total Revenue Rooms-Revenue 00 35 3,000,000 535,600 229,450 Payroll and Related Expenses Other Expenses Department Income Food-Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income 1,400,000 386,100 395,200 96,200