Homework Help is Here – Start Your Trial Now!
Business
Accounting
4. Terry Ray manages a large hotel in an urban Midwestern city. He wants to use vertical analysis and a slightly modified version of the USALI income statement (P&L) for his property to assess its financial performance last year. Complete the spreadsheet to help him evaluate his effectiveness as a manager. Terry's P&L TOTAL REVENUE Rooms-Revenue Payroll and Related Expenses Other Expenses Department Income Food-Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Beverage Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Telecommunications-Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Other Operated Departments-Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Rentals and Other Income Revenue Cost of Sales $ % 5,100,350 100.00 3,000,000 535,600 229,450 1,400,000 386,100 395,200 96,200 560,000 81,510 96,590 36,400 14,000 30,550 9,750 5,200 105,000 14,300 32,500 11,700 21,350 2,860

4. Terry Ray manages a large hotel in an urban Midwestern city. He wants to use vertical analysis and a slightly modified version of the USALI income statement (P&L) for his property to assess its financial performance last year. Complete the spreadsheet to help him evaluate his effectiveness as a manager. Terry's P&L TOTAL REVENUE Rooms-Revenue Payroll and Related Expenses Other Expenses Department Income Food-Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Beverage Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Telecommunications-Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Other Operated Departments-Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Rentals and Other Income Revenue Cost of Sales $ % 5,100,350 100.00 3,000,000 535,600 229,450 1,400,000 386,100 395,200 96,200 560,000 81,510 96,590 36,400 14,000 30,550 9,750 5,200 105,000 14,300 32,500 11,700 21,350 2,860

Principles of Accounting Volume 2
Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter9: Responsibility Accounting And Decentralization
Section: Chapter Questions
Problem 5PA: Financial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an...
See similar textbooks
icon
Related questions
Question

Do not give handwriting solution.

4. Terry Ray manages a large hotel in an urban Midwestern city. He wants to use vertical analysis and a slightly modified version of the USALI income statement (P&L) for his property to assess its financial performance last year. Complete the spreadsheet to help him evaluate his effectiveness as a manager. Terry's P&L TOTAL REVENUE Rooms-Revenue Payroll and Related Expenses Other Expenses Department Income Food-Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Beverage Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Telecommunications-Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Other Operated Departments-Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Rentals and Other Income Revenue Cost of Sales $ % 5,100,350 100.00 3,000,000 535,600 229,450 1,400,000 386,100 395,200 96,200 560,000 81,510 96,590 36,400 14,000 30,550 9,750 5,200 105,000 14,300 32,500 11,700 21,350 2,860 106 /4
Transcribed Image Text:4. Terry Ray manages a large hotel in an urban Midwestern city. He wants to use vertical analysis and a slightly modified version of the USALI income statement (P&L) for his property to assess its financial performance last year. Complete the spreadsheet to help him evaluate his effectiveness as a manager. Terry's P&L TOTAL REVENUE Rooms-Revenue Payroll and Related Expenses Other Expenses Department Income Food-Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Beverage Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Telecommunications-Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Other Operated Departments-Revenue Cost of Sales Payroll and Related Expenses Other Expenses Department Income Rentals and Other Income Revenue Cost of Sales $ % 5,100,350 100.00 3,000,000 535,600 229,450 1,400,000 386,100 395,200 96,200 560,000 81,510 96,590 36,400 14,000 30,550 9,750 5,200 105,000 14,300 32,500 11,700 21,350 2,860 106 /4
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Cost classification
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
SEE MORE TEXTBOOKS