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
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...
Related questions
Question
Do not give handwriting solution.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
Knowledge Booster
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.Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning