Name: 2. Terry Ray manages a large hotel in an urban Midwestern city. He wants to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Name: 2. 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. TOTAL REVENUE 100.0% 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 $2,234,950 $522,500 $345, 500 31,500 5,100,350 3,000,000 m 59% $35,600 11% 229,450 $46.500 4% 44% 27% 1,400,000 386,100 % 395,200 96,200 8% 2% 10% 560,000 11% 81,510 2%. 96,590 % 36,400 1 14,000 30,550 9,750 5,200 105,000 79. 0%. 1% 0% 21,350 2,860 0% -1% 2% 14,300 32,500 1% 11,700 0% 0% 0% Name: Payroll and Related Expenses Other Expenses Department Income UNDISTRIBUTED OPERATING EXPENSES Administrative and General Information Systems Total Operated Department Income Human Resources Security Franchise Fees Transportation Interest GROSS OPERATING PROFIT Rent, Property Taxes, and Insurance Depreciation and Amortization NET OPERATING INCOME Marketing Property Operation and Maintenance Utility Costs Total Undistributed Operating Expenses $1,214,980 (c) 1,910,670 NET INCOME INCOME BEFORE INCOME TAXES Income Taxes $1,700 $3,125,650 8.840 0% 1,950 0%. (b) Total operated department income 0% 245,050 5% 64,350 17 105,300 29 50,050 14. 61% 0 60,450 280,280 10$1,365, 320 $1,228,820 216,125 193,375 0% 317,850 227,500 1% 5% 4% 4% 24% 37% 6% 4% 27% 136,500 % 491,528 24%. (e)$737, 292 (1) Complete Terry's P&L above using vertical analysis (Fill in the gray blanks) and show your work for calculating the: (a-i: 1 point each, chart: 6 points) (a) Room department income 10% 14% $3,000,000-$535,600 + $229,450) = $2,234,950 (c) Gross operating profit (d) Net operating income (e) Net income (f) Room revenue percentage (g) Payroll and related expenses percentage (h) Food cost percentage (i) Beverage cost percentage (2) The owner gave Terry a goal of 65% total for operated department income. Did Terry perform better or worse than this goal? By how much? (3 points) (3) The owner also gave Terry a goal of 22% total undistributed operating expenses. Did Terry perform better or worse than this goal? By how much? (3 points) (4) The owner gave Terry a goal of 20% net income for the year. Did Terry perform better or worse than this goal? By how much? (3 points) (5) If you answered that Terry did not meet his goal in Question (4), what could he do to get his P&L in line with the owner goals? (3 points) Name: 2. 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. TOTAL REVENUE 100.0% 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 $2,234,950 $522,500 $345, 500 31,500 5,100,350 3,000,000 m 59% $35,600 11% 229,450 $46.500 4% 44% 27% 1,400,000 386,100 % 395,200 96,200 8% 2% 10% 560,000 11% 81,510 2%. 96,590 % 36,400 1 14,000 30,550 9,750 5,200 105,000 79. 0%. 1% 0% 21,350 2,860 0% -1% 2% 14,300 32,500 1% 11,700 0% 0% 0% Name: Payroll and Related Expenses Other Expenses Department Income UNDISTRIBUTED OPERATING EXPENSES Administrative and General Information Systems Total Operated Department Income Human Resources Security Franchise Fees Transportation Interest GROSS OPERATING PROFIT Rent, Property Taxes, and Insurance Depreciation and Amortization NET OPERATING INCOME Marketing Property Operation and Maintenance Utility Costs Total Undistributed Operating Expenses $1,214,980 (c) 1,910,670 NET INCOME INCOME BEFORE INCOME TAXES Income Taxes $1,700 $3,125,650 8.840 0% 1,950 0%. (b) Total operated department income 0% 245,050 5% 64,350 17 105,300 29 50,050 14. 61% 0 60,450 280,280 10$1,365, 320 $1,228,820 216,125 193,375 0% 317,850 227,500 1% 5% 4% 4% 24% 37% 6% 4% 27% 136,500 % 491,528 24%. (e)$737, 292 (1) Complete Terry's P&L above using vertical analysis (Fill in the gray blanks) and show your work for calculating the: (a-i: 1 point each, chart: 6 points) (a) Room department income 10% 14% $3,000,000-$535,600 + $229,450) = $2,234,950 (c) Gross operating profit (d) Net operating income (e) Net income (f) Room revenue percentage (g) Payroll and related expenses percentage (h) Food cost percentage (i) Beverage cost percentage (2) The owner gave Terry a goal of 65% total for operated department income. Did Terry perform better or worse than this goal? By how much? (3 points) (3) The owner also gave Terry a goal of 22% total undistributed operating expenses. Did Terry perform better or worse than this goal? By how much? (3 points) (4) The owner gave Terry a goal of 20% net income for the year. Did Terry perform better or worse than this goal? By how much? (3 points) (5) If you answered that Terry did not meet his goal in Question (4), what could he do to get his P&L in line with the owner goals? (3 points)
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
What are the agent of weathering? Explain according to mechanical and chemical phenomenon.
-
Write the Comparison for Legal Factors of China and South Africa
-
May Motz is the editor-in-chief of her schools yearbook. The school has 1,000 students and 60 faculty and staff members. The firm engaged to print copies of the yearbook charges the school $13 per...
-
It is known that 2% of the cheapest memory sticks on the market are defective. a. In a random sample of 400 of these memory sticks, find approximately the probability that at least five but at most...
-
What is platform capitalism, and how has the gig economy impacted society?
-
Using annual, semiannual, and quarterly compounding periods for each of the following, (1) calculate the future value if $5,000 is deposited initially, and (2) determine the effective annual rate...
-
Q2: Forecasting Analysis: Assum that you got the following values of the number of units sold of Sea Ranch Pizza at PRIMO's during the previous ten years: You were asked to conduct a forecasting...
-
Prepare a purchases return (journal) book from the following transactions for April 2017. 2017 April 05 10 17 28 Returned goods to M/s Kartik Traders Goods returned to Sahil Pvt. Ltd. Goods returned...
-
Year 1 2 Consider the following quarterly data for the maintenance load in man-hours for the last 5 years. 3 4 5 Quarter I 215 250 300 350 400 II 120 175 250 275 300 III 150 75 75 100 125 IV 100 150...
-
An electron has a velocity of 4 x 106 m/s in the positive x direction at a point where the magnetic field has the components Bx = 2T, By = 1 T, and B = 1 T. What is the magnitude of the acceleration...
-
discuss the potential challenges and barriers that may hinder employees from engaging in advanced Organizational Citizenship Behavior (OCB), and how can these obstacles be overcome?
-
What strategies can organizations implement to recognize and reward employees who consistently demonstrate advanced levels of Organizational Citizenship Behavior (OCB) ?
-
In 1991, Geoffrey A. Moore, a lecturer and management consultant, wrote an influential book titled Crossing the I Chasm. The book became an instant must-read for managers, entrepreneurs, and...
-
How do interpersonal dynamics and team cohesion influence the prevalence of advanced OCB within diverse workgroups?
-
Given the following information, compute the property tax rate in Center City PA in percentage terms: Total budget expenditures: $109 million Total non-property tax income: $55 million Total assessed...
-
Suppose that the electrical potential at the point (x, y, z) is E(x, y, z) = x + y - 2z. What is the direction of the acceleration at the point (1,3,2)?
-
Mike purchases a heavy-duty truck (5-year class recovery property) for his delivery service on April 30, 2012. The truck is not considered a passenger automobile for purposes of the listed property...
-
If Charles, a 16-year-old child model, earns $50,000 a year and is completely self supporting even though he lives with his parents, can his parents claim him as a dependent? Why or why not?...
-
Mary paid $2,000 of state income taxes in 2012. The total sales tax she paid during 2012 was $5,500, which included $3,000 for the cost of a new car. How should Mary treat the taxes paid on her 2012...
-
Which of the following are boiler mountings ? (a) Economiser (b) Fusible plug (c) Super heater (d) Injector
-
Which out of the following boiler is capable of generating superheated steam without additional accessories ? (a) Cochran (b) Lancashire (c) Locomotive (d) Cornish
-
The economiser of the boiler plant is used mainly to (a) increase steam capacity (b) reduce fuel consumption (c) increase steam pressure (d) increase life of the boiler
Study smarter with the SolutionInn App