Prepare a budgeted income statement for year two

Assignment Help Accounting Basics
Reference no: EM133078361

Question - HomeSuites is a chain of all-suite, extended-stay hotel properties. The chain has 15 properties with an average of 200 rooms in each property. In year 1, the occupancy rate (the number of rooms filled divided by the number of rooms available) was 70 percent, based on a 365-day year. The average room rate was $180 for a night. The basic unit of operation is the "night," which is one room occupied for one night.

The operating income for year 1 is as follows.

HomeSuites Operating Income Year 1

Sales revenue

Lodging $137,970,000

Food & beverage 19,162,500

Miscellaneous 7,665,000

Total revenues $164,797,500

Costs

Labor $44,325,000

Food & beverage 13,797,000

Miscellaneous 9,198,000

Management 2,500,000

Utilities, etc. 37,500,000

Depreciation 10,500,000

Marketing 25,000,000

Other costs 8,000,000

Total costs $150,820,000

Operating profit $13,977,500

In year 1, the average fixed labor cost was $400,000 per property. The remaining labor cost was variable with respect to the number of nights. Food and beverage cost and miscellaneous cost are all variable with respect to the number of nights. Utilities and depreciation are fixed for each property. The remaining costs (management, marketing, and other costs) are fixed for the firm.

At the beginning of year 2, HomeSuites will open three new properties with no change in the average number of rooms per property. The occupancy rate is expected to remain at 70 percent. Management has made the following additional assumptions for year 2.

The average room rate will increase by 5 percent.

Food and beverage revenues per night are expected to decline by 20 percent with no change in the cost.

The labor cost (both the fixed per property and variable portion) is not expected to change.

The miscellaneous cost for the room is expected to increase by 25 percent, with no change in the miscellaneous revenues per room.

Utilities and depreciation costs (per property) are forecast to remain unchanged.

Management costs will increase by 8 percent, and marketing costs will increase by 10 percent.

Other costs are not expected to change.

The managers of HomeSuites are considering different pricing strategies for year 2. Under the first strategy ("High Price"), they will work to maintain an average price of $210 per night. They realize that this will reduce demand and estimate that the occupancy rate will fall to 60 percent with this strategy. Under the alternative strategy ("High Occupancy"), they will work to increase the occupancy rate by lowering the average price. They estimate that with an average nightly rate of $170, they can achieve an occupancy rate of 80 percent. The current estimated profit is $22,092,800.

Required -

a. Prepare a budgeted income statement for year 2 if the "High Price" strategy is adopted.

b. Prepare a budgeted income statement for year 2 if the "High Occupancy" strategy is adopted.

c. Which is the correct pricing strategy for year 2?

Reference no: EM133078361

Questions Cloud

Country production possibility frontier : There is a hypothetical country with 100 labor hours available and with two industries, X and Y. In the X industry, it takes 2 hours to produce one unit of good
Prepare a statement of owner equity for the year ended : Hannah's Pool Service Company reported a net income of $69,050. Prepare a statement of owner's equity for the year ended December 31
General relations among total-average-marginal quantities : In terms of the general relations among total, average, and marginal quantities, which of the following statements are necessarily true, and which are not?
What should the year two price be : Assuming the volume and other costs are unchanged, what should the Year 2 price be if Thor is to make the same $200,000 profit before income taxes
Prepare a budgeted income statement for year two : In year 1, the average fixed labor cost was $400,000 per property. Prepare a budgeted income statement for year 2 if the "High Price" strategy is adopted
What is the margin that each company will have to earn : What is the margin that each company (Company P and Company Q, respectively) will have to earn in order to generate a return on investment of 20%
What is the balance in ALPHA Investment in BETA Ltd account : ALPHA uses the equity method to account for its investment in BETA. What is the balance in ALPHA'S "Investment in BETA Ltd." account at December 31, 2019
What amount should be reported for total income tax expense : The enacted tax rate for 2021 is 25%. In Wildhorse's 2021 income statement, what amount should be reported for total income tax expense
Commercial insurance range : Commercial insurance ranges from individual health coverage to automobile liability coverage.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Necessary adjustments for changes in fair value.

1.On January 1, 2013, S&S Corporation invested in LLB Industries  negotiable two year, 10% notes, with interest receivable quarterly.

  Heritage insurance co is a regional insurance company that

heritage insurance co. is a regional insurance company that began operations on january 12012. the following

  Prepare a multi-step income statement

Pono Paint Company has the following income statement items for the year ended December 31, 2014 ($ in 000s): Prepare a multi-step income statement for 2014

  How much interest do the borrowers pay

Determine the monthly payment for a thirty-year real estate loan with an annual percentage rate of 8.5% and an initial principal of $200,000.

  Purpose of this article

1. What is the purpose of this article? Why is the article written? 2. Why is this topic important? Who is affected by this information?

  What are the markup percentages for total variable costs

If management desires a 12 percent rate of return on total assets, what are the markup percentages for total variable costs

  Estimate the spot FX rates

Estimate the spot FX rates which will obtain for the next five years. That is, estimate S1(£/$), S2(£/$), S3(£/$), S4(£/$), and S5(£/$)

  Determine planning materialityfor the ahg finacial statement

Determine overall (or planning materiality) for the AHG finacial statement .Ensure to include calculations as well explain why you chose threshold

  What is the operating cash flow of year for the company

The discount rate (interest rate) for the project is 10% and the company's tax rate is 35%. What is the operating cash flow of year 1 for the company

  Prepare the adjusting entry that would be recorded on monday

Prepare the adjusting entry that would be recorded on Monday, December 31, 2015 and Friday, January 4, 2016.

  Method of computing depreciation

Is it necessary for a business to use the same method of computing depreciation (a) for all classes of depreciable assets, (b) in the financial statements and in determining income taxes? Explain your answer.

  Should the US Federal Reserve do the same

Beginning in 2014 several European central banks cut key interest rates below 0%. Should the U.S. Federal Reserve do the same?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd