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

  Would you characterize the favorable material

Would you characterize the favorable material price variance as indicative of a good decision by the purchasing department?

  What are the major benefits of budgeting

Why is budgeted performance better than past performance as a basis for judging actual results and what are the major benefits of budgeting?

  What type of information you can find there

What type of information you can find there, take a look at the brief article below. What insights do you find most intriguing - For more great insights on what

  Describe what nmc should do to improve its position

Compare your results to the industry ratios and describe what NMC should do to improve its position in the market.

  Discuss the effectiveness of management accountancy as tool

In a digital world, the focus of the finance function is shifting from being based on costs to being based on organisational value.

  Determine the present value of each plan

Juanita Martinez desires a return of 8 percent. Determine the present value of each plan and select the best

  The completion of units in process and their transfer

The completion of units in process and their transfer to finished goods.

  Advise the management about the right choice

Advise the management about the right choice of an alternative so as to maximize profits - The machines for both the products are common. However, cream is produced on a special purpose machine.

  What is the book value per share of common stock

What is the acid-test ratio for the current year? What is the inventory turnover for the current year? What is days' sales in receivables for the current year? What is the book value per share of common stock for the current year?

  What is the ebit breakeven point

Plan B would consist of $65 million debt at an interest rate of 7.25%, and $85 million equity (2 million shares). If the firm's tax rate is 32%,

  Calculate arithmetic returns and risk-premium of stocks

Managerial Finance and Accounting Assignment. Calculate arithmetic returns and risk-premium of stocks. Describe the stock market behavior

  Comment on why the break-even points are different

Show the analysis in a table format. Write one paragraph interpretation of the information - Comment on why the break-even points are different

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