Determine plunkett hotel occupancy rate per day

Assignment Help Managerial Accounting
Reference no: EM132468140

Acrux Group is a multidivisional business established in Hong Kong since the 1980s. The firm has two major subsidiaries: Plunkett Hotels and Resorts, and Honshu Properties.

  • Plunkett Hotels and Resorts is a five-star resort with presence in major tourist destinations across Asia-Pacific and Australia. Guests pay an all-inclusive flat rate to enjoy all the services offered by the resort, which includes accommodation, food and beverages, spa and sauna, and a variety of sport activities organized by the fitness club. Each service is organized as a department for management purposes. Due to its excellence services, Plunkett has received numerous awards in the past and it has been expanded from a single resort hotel to 15 resort hotels.
  • The General Manager in each Plunkett's resort is treated as a profit centre, and their annual bonuses is determined based on the difference between actual as compared to the budgeted profit at year end. In the past, Plunkett's annual budget is based on the projected occupancy rate and expected costs. The annual budget will then be divided into monthly budgets based on the number of days in the month and seasonal demand fluctuations.
  • During the middle of 2017, Plunkett has changed it's CFO and she felt that the old budgeting approach does consider the dynamic nature of the tourism market (The peak season for most of the Plunkett's resort hotels are in the months of January, July, August and December). To ensure the budget reflects the most updated demand and cost information, she adopts the rolling budget approach starting from 2018 fiscal year.
  • Before the fiscal year begins, the head office sets the target, for each resort, the variable cost per room occupied for each department (i.e. accommodation, food and beverage, spa, and fitness club), along with the fixed costs target on these departments for the entire year. Each department's annual fixed cost target will then be divided into monthly targets based on the number of days.
  • Under the new budgeting approach, the General Manager of Plunkett's resort is evaluated using the flexible budget. Bonuses are determined based on the difference between budgeted and actual expenditures.

The following illustrates the new budget model for Plunkett to be adopted in 2018 for its Penang resort:

Number of rooms                                         500

Average daily occupancy rate                       75%

Expected daily occupancy                            375

Revenue per day per room                        $1,700

Budgeted revenue / day                        $ 637,500

Daily variable costs per room

Accommodation                                          $ 70

Food and beverage                                   $ 300

Spa                                                        $ 200

Fitness club                                               $ 30

Total daily variable costs / room                     $ 600

Total variable costs on average

occupancy                                           $ 225,000

Annual fixed costs

Accommodation                                   $ 88,000,000

Food and beverage                                $ 18,000,000

Spa                                                      $ 1,600,000

Fitness club                                            $ 2,300,000

Maintenance                                           $ 1,700,000

Administration                                        $ 14,000,000

Total annual fixed costs                         $ 125,600,000

Da ily fixed costs (365 days, rounded)          $ 344,110

Daily profit                                                $ 68,390

The actual resort for the Penang resort in August is as follows:

Total number of guest

days                                                      10,540

Revenue per guest day                           $ 1,700

Variable costs

Accommodation                                    $ 685,100

Food and beverage                             $ 3,035,520

Spa                                                 $ 2,002,600

Fitness club                                         $ 305,660

Fixed costs

Accommodation                                 $ 7,175,013

Food and beverage                              $ 1,421,753

Spa                                                     $ 119,584

Fitness club                                          $ 175,808

Maintenance                                         $ 135,721

Administration                                        $ 1,212,822

  • After the adoption of the new budgeting system, occupancy rate for Penang resort from January to August are 80%, 75%, 77%, 70%, 67%, 64%, 67%, 70% respectively.
  • Another subsidiary of Acrux Group is Honshu Properties. Honshu operates as a property development business. It mainly owns and operates service apartments in the Asia Pacific region. Unlike Plunkett Hotels and Resorts, the General Manager of Honshu Properties is evaluated as an investment centre. Specifically, the general manager of Honshu is rewarded based on its pre-tax return on assets (ROA). Thus, the higher its pretax ROA, the more bonus the general manager will enjoy.

Currently, Honshu is considering acquiring a new apartment complex in Thailand known as Havana Peak with the following information:

Expected revenue                                   $16.6 million

Expected operating expenses                    $12.59 million

Asset value                                                $20 million

The following are the latest financial information for Honshu in 2018:

Sales                                                           $86.5 million

Operating expenses                                       $69.7 million

Total assets                                                  $64 million

Acrux estimated that Honshu's minimum rate of return is 15%.

Questions Required:

Question a. Determine Plunkett Hotel and Resorts breakeven occupancy rate per day.

Question b. Using the old budgeting system, prepare the August, 2018 budget to determine the budgeted profit for the Penang resort (Hint: follow the daily budget illustration for the Penang budget).

Question c. Prepare a report to evaluate Penang resort's performance under the new budgeting system for August 2018. Briefly comment on the General Manager's of Penang resort's performance.

Question d. After the adoption of the new budgeting system, almost all other hotels in the Plunkett Hotel and Resorts exhibit occupancy rates trend like the Penang resort. In fact, they share similar performance trend as in part (c). Discuss possible explanations for such observation.

Question e. Determine Honshu's ROA in 2018.

Question f. Based on the information given, will the General Manager of Honshu Properties acquire Havana Peak? Explain with supporting computations.

Question g. If the CFO of Acrux Group had the same information as the General Manager of Honshu, would the CFO of Acrux willing to invest in Havana Peak? Explain with supporting computations.

Question h. What is your recommendation to the CFO of Acrux Group as to the performance measurement and incentive system of Honshu Properties?

Reference no: EM132468140

Questions Cloud

What is the yield to maturity : If the bonds have 20 years to maturity and the bonds are quoted at 102.25% of the par value, what is the yield to maturity? Assume semi-annual compounding.
How the old testament figure of david is represented : Please write a 1750+ word paper tracing how the Old Testament figure of David is represented in Renaissance art. Begin your paper with a brief overview.
What is the current yield : The par value of the bond is $1,000. The bond has a maturity of 23 years. If today's price of the bond is $928.53, what is the current yield?
Compute the number of equivalent units : Required - Compute the number of equivalent units with respect to materials for November using the weighted-average method
Determine plunkett hotel occupancy rate per day : If the CFO of Acrux Group had the same information as the General Manager of Honshu, would the CFO of Acrux willing to invest in Havana Peak?
How did world war ii represent new technology : How did World War II represent new technology? How did this technology affect the outcome of the war? Did World War II truly represent a world war that.
What is the project initial outlay : The project would require an initial investment in net working capital of $6,584 which would be recouped at the end of the project.
Determine the amount of the adjustment entry : Determine a) the amount of the adjustment entry for the debt expense; b) the adjusted balances of Accounts Receivable, Allowance for Doubtful Accounts
Explain how the revolution in france is similar : Suppose you are an American living in France during the French Revolution. Write an "email" to a friend or family member in the United States describing events.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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