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

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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