The Sunrise Hotel data for the past 5 years are presented below: Year Occupancy 1 The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Sunrise Hotel data for the past 5 years are presented below: Year Occupancy 1 The management team for the Sunrise Hotel estimates the following for year 6: Increase in revenues 8% Increase in costs 10% Year 6 estimated revenues Year 6 estimated costs Year 6 estimated profit Required: Compute the estimated profit of year 6 for the Sunrise Hotel using the Naive Model Item Amount Year 6 estimated occupancy Year 6 estimated revenues Year 6 estimated costs Year 6 estimated profit Required: The Sunrise Hotel provides these additional data Estimated revenues in year 4 Estimated revenues in year 5 2 3 4 Required: Compute the Sunrise Hotel estimated occupancy, revenues, costs, and profit for Year 6 using a 4-year moving average Item Amount Computation Smoothing Factor Year 6 estimated revenues Reveries Costs 27,500 $3,200,000 $1,650,000 $ 42,000 $5,200,000 $2,200,000 $ 48,750 $6,900,000 $3,200,000 $ 61,300 $8,450,000 $2,625,000 $ 68,050 $9,200,000 $3,100,000 $ Using the exponential smoothing model, compute the forecasted revemaes for Year 6 Item Amount A in costs A in occupancy Slope b Intercept "a Cost Formula y= in costs $ 7,200,000 $8,750,000 Computation Required: 1. Use the high-low method to determine the equation that relates to the costs of the hotel and its occupancy Them Amount Computation 2. Determine the estimated costs if the Sunrise Hotel expects 55,000 guests in Year 6. Item Amount Computation Profit 1,550,000 3,000,000 3,700,000 5,825,000 6,100,000 Computation a 6.100.000 The Sunrise Hotel data for the past 5 years are presented below: Year Occupancy 1 The management team for the Sunrise Hotel estimates the following for year 6: Increase in revenues 8% Increase in costs 10% Year 6 estimated revenues Year 6 estimated costs Year 6 estimated profit Required: Compute the estimated profit of year 6 for the Sunrise Hotel using the Naive Model Item Amount Year 6 estimated occupancy Year 6 estimated revenues Year 6 estimated costs Year 6 estimated profit Required: The Sunrise Hotel provides these additional data Estimated revenues in year 4 Estimated revenues in year 5 2 3 4 Required: Compute the Sunrise Hotel estimated occupancy, revenues, costs, and profit for Year 6 using a 4-year moving average Item Amount Computation Smoothing Factor Year 6 estimated revenues Reveries Costs 27,500 $3,200,000 $1,650,000 $ 42,000 $5,200,000 $2,200,000 $ 48,750 $6,900,000 $3,200,000 $ 61,300 $8,450,000 $2,625,000 $ 68,050 $9,200,000 $3,100,000 $ Using the exponential smoothing model, compute the forecasted revemaes for Year 6 Item Amount A in costs A in occupancy Slope b Intercept "a Cost Formula y= in costs $ 7,200,000 $8,750,000 Computation Required: 1. Use the high-low method to determine the equation that relates to the costs of the hotel and its occupancy Them Amount Computation 2. Determine the estimated costs if the Sunrise Hotel expects 55,000 guests in Year 6. Item Amount Computation Profit 1,550,000 3,000,000 3,700,000 5,825,000 6,100,000 Computation a 6.100.000
Expert Answer:
Related Book For
Operations Management
ISBN: 978-0132687584
1st Canadian Edition
Authors: Jay Heizer, Barry Render, Paul Griffin
Posted Date:
Students also viewed these accounting questions
-
The Travellers Hotel data for the past 5 years are presented below: Year Occupancy Management provides these additional data: Estimated increase in revenues in year 6 Estimated decrease in costs in...
-
The Sunrise Hotel has 200 rooms. Each room rents at $110 per night and variable costs total $16 per room per night of occupancy. Fixed costs total $84,000 per month. If the hotel spends an additional...
-
Compute estimated profit in 1 year if Telco buys paylater calls as follows (the net premium may not be exactly zero): a. Sell one 0.975-strike call and buy two 1.034-strike calls. b. Sell two...
-
A school district comprises 24 schools. The numbers of students in each of the schools are as follows: The district wants to implement an experimental teaching and learning model for approximately...
-
The recent success of Southwestern University's football program is causing SWU's president, Joel Wisner, more problems than he faced during the team's losing era in the early 1990s. For one thing,...
-
The CAE is required to present the internal audit plan to senior management and the board for approval. What specific information should be communicated to senior management and the board?
-
What strategies or programs could Meda utilize to improve employee well-being?
-
As reported in The Wall Street Journal (September 11, 1989), MiniScribe, Inc., inflated its reported profits and inventory through a number of schemes designed to fool the auditors. At that time,...
-
How did the United States shift from a nation of agrarian farmers to an industrial powerhouse during the late 19th and early 20th centuries?
-
Determine the maximum power delivered to the variable resistor R shown in the circuit of Fig. 4.136. 2 Vx 10 (4 20 20 : 10 . www
-
Give the n assets portfolio characteristics. Explain what contributes to the risk of the portfolio. How the risk on the portfolio behaves when there is an infinite number of assets?
-
Are investors in the money market best characterized as having a strong appetite for risk or being highly risk averse? What evidence would you use to support your answer?
-
What is the duration of a threeyear Treasury note with a coupon rate of 3 percent if the note is selling for par? What is its duration if the current yield to maturity is 10 percent? (Assume only one...
-
In what respect does a privately placed bond resemble a loan made by a commercial bank? Why do firms with access to the public bond market sometimes issue privately placed bonds under Rule 144a?
-
Describe the steps by which a change in the central banks policy interest rate affect the array of short-term interest rates.
-
Look for recent stories in the financial press about private equity funds or hedge funds. Explain the transactions that are being discussed and how this relates to the basic objective of the fund.
-
Bingl is one the provinces in Turkey with a very high earthquake risk, since the city center is located on the fault and is very close to the East Anatolian Fault Zone, which is also one of the most...
-
The graph of the sequence whose general term is an = n - 1 is which of the following? [8.1] A. B. TITTT 3-2-1 23.45 2.3.4
-
Some provinces in Canada have discouraged the outsourcing of certain functions on the part of the provincial government to firms in other countries. Yet others have been more open to the idea as a...
-
Attendance at Victoria's newest theme park has been as follows Compute seasonal indices using all of the data. PX Guests (in thousands) 124 52 89 146 205 98 Guests Quarter(in thousands) Winter '11...
-
The monthly Toronto Maple Leafs fan magazines are printed 1 week prior to the start of sales for each monthly issue during the season. Attendance averages 90 000 screaming and loyal Leafs fans during...
-
Consider the control system in Example 10.2. Build a Simulink block diagram to simulate reference tracking control, in which the signal \(R(s)\) is a sine wave with a magnitude of \(0.1 \mathrm{~m}\)...
-
A control system is represented using the block diagram shown in Figure 10.60, in which the parameter \(a\) is subjected to variations. Sketch the root locus with respect to the parameter \(a\)....
-
A Figure 10.61 shows the root locus of a unity negative feedback control system, where \(K\) is the proportional control gain. a. Determine the transfer function of the plant. Use MATLAB to plot the...
Study smarter with the SolutionInn App