The Travellers Hotel data for the past 5 years are presented below: Year Occupancy Management provides...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 year 6 Estimated revenues in year 4 Estimated revenues in year 5 Year 6 estimated revenues Year 6 estimated costs Year 6 estimated profit 1 2 3 4 Year 6 estimated occupancy Year 6 estimated revenues Year 6 estimated costs Year 6 estimated profit 90,000 80,000 120,000 100,000 110,000 Smoothing Factor Year 6 estimated revenues 15% 8% $31,000,000 $40,000,000 A in costs A in occupancy Slope "b" Intercept "a" Cost Formula: Revenues $27,000,000 $24,800,000 Required: 1. Compute the estimated profit of year 6 for the Tree Top Hotel using the Naive Model. Item Amount $38,400,000 $34,000,000 $38,500,000 Costs $13,500,000 $15,800,000 $22,800,000 $21,000,000 $25,300,000 2. Compute the estimated occupancy, revenues, costs, and profit for Year 6 using a 2-year moving average. Item Amount Computation 3. Using the exponential smoothing model, compute the forecasted revenues for Year 6. from Amount Computation Computation 4. Use the high-low method to determine the equation that relates to the costs of the hotel and its occupancy. Item Amount Computation Profit $13,500,000 $9,000,000 $15,600,000 $13,000,000 $13,200,000 5. Using the formula obtained in requirement 4, determine the estimated costs if the hotel expects 95,000 guests in Year 6. Amount Item Computation A in costs Occupancy 90,000 80,000 120,000 100,000 $34,000,000 110,000 $38,500,000 $31,000,000 $40,000,000 15% 8% Amount Amount $44,275,000 $38,500,000x (1+15%) 23,276,000 $25,300,000 ×(1-8%) $20.999,000 $44,275,000-$23,276,000 Revenues Costs $27,000,000 $13,500,000 $24,800,000 $15,800,000 $38,400,000 $22,800,000 $21,000,000 $25,300,000 Amount Computation 105,000 (100,000+ 110,000)+2 $36,250,000 ($34,000,000+ 38,500,000)+2 23,150,000 ($21,000,000+ 25,300,000)+2 $13,100,000 $36,250,000-$23,150,000 Computation $1,800,000 2.00 $37,000,000 $40,000,000 +[(2.00 × ($38,500,000-$40,000,000)] Computation ($40,000,000-$31,000,000)+($38,500,000-$34,000,000) Computation Profit Amount $7,000,000 $22,800,000-$15,800,000 40,000 120,000-80,000 $ 175.00 $7,000,000+40,000. $1,800,000 $28,800,000-($175 x 120,000) or $15,800,000-($175 * 80,000) S 175 x Amount $18,425,000 $1,800,000+($175 × 95,000) Computation $13,500,000 $9,000,000 $15,600,000 $13,000,000 $13,200,000 ww ge 10 11 22 13 14 15 ww 17 18 19 32 33 34 36 37 The Travelers Hotel data for the past 5 years are presented below Occrema Year Management provides these additional data Ested increase in revers in year 6 Estimated decrease in cos in year 6 Estimated revenues in year 4 Estimated revenues in year 5 Year 6 estated Yew 6 estimated costs Year 6 estimated profit Yes 5 estimated occupancy Year 6 estimated revenues Yes 6 estimated costs Year 6 estimated peolit Required: 1. Compute the imated profit of year 6 for the Tree Top Hotel wing the Naive Model Item Amount revenues Smoothing Factor Year 6 emated revenues S $ Revemos Coff 90,000 $ 27,000,000 $13,500,000 $1 80,000 $ 120,000 $ 24,800,000 $ 15,800,000 $ 22,800,000 $ 100,000 $ 110,000 $ 2. Compute the estimated occupancy, revenues, costs, and profit for Year 6 using a 2-year moving average frem Amount Computation instructions Ex. 1 15% 8% Ready combing Goods 31,000,000 40,000,000 3. Using the exponential smoothing model, compute the forecasted revenues for Year 6. Item Amount EX2 Ex.3 38,400,000 $ 34,000,000 $ 21,000,000 $ 38,500,000 $ 25,300,000 $ Computation 4. Use the high-low method to determine the equation that relates to the costs of the hotel and its occupancy Irem Amount Computation Ex4 → Computation Profit 13,500,000 9,000,000 15,600,000 13,000,000 13,200,000 JA B C D E F 2. Compute the estimated occupancy, revenues, costs, and profit for Year 6 using a 2-year moving average Item Amount Computation Year 6 estimated occupancy Year 6 estimated revenues Year 6 estimated costs Year 6 estimated profit www 3. Using the exponential smoothing model, compute the forecasted revenues for Year 6. Item Amount Smoothing Factor Year 6 estimated revenues A in costs A in occupancy Slope b Intercept "a" Cost Formula: 4. Use the high-low method to determine the equation that relates to the costs of the hotel and its occupancy.. Item Amount Computation Computation Ain costs y= 5. Using the formula obtained in requirement 4, determine the estimated costs if the hotel expects 95,000 guests in Year 6. Item Amount Computation G H 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 year 6 Estimated revenues in year 4 Estimated revenues in year 5 Year 6 estimated revenues Year 6 estimated costs Year 6 estimated profit 1 2 3 4 Year 6 estimated occupancy Year 6 estimated revenues Year 6 estimated costs Year 6 estimated profit 90,000 80,000 120,000 100,000 110,000 Smoothing Factor Year 6 estimated revenues 15% 8% $31,000,000 $40,000,000 A in costs A in occupancy Slope "b" Intercept "a" Cost Formula: Revenues $27,000,000 $24,800,000 Required: 1. Compute the estimated profit of year 6 for the Tree Top Hotel using the Naive Model. Item Amount $38,400,000 $34,000,000 $38,500,000 Costs $13,500,000 $15,800,000 $22,800,000 $21,000,000 $25,300,000 2. Compute the estimated occupancy, revenues, costs, and profit for Year 6 using a 2-year moving average. Item Amount Computation 3. Using the exponential smoothing model, compute the forecasted revenues for Year 6. from Amount Computation Computation 4. Use the high-low method to determine the equation that relates to the costs of the hotel and its occupancy. Item Amount Computation Profit $13,500,000 $9,000,000 $15,600,000 $13,000,000 $13,200,000 5. Using the formula obtained in requirement 4, determine the estimated costs if the hotel expects 95,000 guests in Year 6. Amount Item Computation A in costs Occupancy 90,000 80,000 120,000 100,000 $34,000,000 110,000 $38,500,000 $31,000,000 $40,000,000 15% 8% Amount Amount $44,275,000 $38,500,000x (1+15%) 23,276,000 $25,300,000 ×(1-8%) $20.999,000 $44,275,000-$23,276,000 Revenues Costs $27,000,000 $13,500,000 $24,800,000 $15,800,000 $38,400,000 $22,800,000 $21,000,000 $25,300,000 Amount Computation 105,000 (100,000+ 110,000)+2 $36,250,000 ($34,000,000+ 38,500,000)+2 23,150,000 ($21,000,000+ 25,300,000)+2 $13,100,000 $36,250,000-$23,150,000 Computation $1,800,000 2.00 $37,000,000 $40,000,000 +[(2.00 × ($38,500,000-$40,000,000)] Computation ($40,000,000-$31,000,000)+($38,500,000-$34,000,000) Computation Profit Amount $7,000,000 $22,800,000-$15,800,000 40,000 120,000-80,000 $ 175.00 $7,000,000+40,000. $1,800,000 $28,800,000-($175 x 120,000) or $15,800,000-($175 * 80,000) S 175 x Amount $18,425,000 $1,800,000+($175 × 95,000) Computation $13,500,000 $9,000,000 $15,600,000 $13,000,000 $13,200,000 ww ge 10 11 22 13 14 15 ww 17 18 19 32 33 34 36 37 The Travelers Hotel data for the past 5 years are presented below Occrema Year Management provides these additional data Ested increase in revers in year 6 Estimated decrease in cos in year 6 Estimated revenues in year 4 Estimated revenues in year 5 Year 6 estated Yew 6 estimated costs Year 6 estimated profit Yes 5 estimated occupancy Year 6 estimated revenues Yes 6 estimated costs Year 6 estimated peolit Required: 1. Compute the imated profit of year 6 for the Tree Top Hotel wing the Naive Model Item Amount revenues Smoothing Factor Year 6 emated revenues S $ Revemos Coff 90,000 $ 27,000,000 $13,500,000 $1 80,000 $ 120,000 $ 24,800,000 $ 15,800,000 $ 22,800,000 $ 100,000 $ 110,000 $ 2. Compute the estimated occupancy, revenues, costs, and profit for Year 6 using a 2-year moving average frem Amount Computation instructions Ex. 1 15% 8% Ready combing Goods 31,000,000 40,000,000 3. Using the exponential smoothing model, compute the forecasted revenues for Year 6. Item Amount EX2 Ex.3 38,400,000 $ 34,000,000 $ 21,000,000 $ 38,500,000 $ 25,300,000 $ Computation 4. Use the high-low method to determine the equation that relates to the costs of the hotel and its occupancy Irem Amount Computation Ex4 → Computation Profit 13,500,000 9,000,000 15,600,000 13,000,000 13,200,000 JA B C D E F 2. Compute the estimated occupancy, revenues, costs, and profit for Year 6 using a 2-year moving average Item Amount Computation Year 6 estimated occupancy Year 6 estimated revenues Year 6 estimated costs Year 6 estimated profit www 3. Using the exponential smoothing model, compute the forecasted revenues for Year 6. Item Amount Smoothing Factor Year 6 estimated revenues A in costs A in occupancy Slope b Intercept "a" Cost Formula: 4. Use the high-low method to determine the equation that relates to the costs of the hotel and its occupancy.. Item Amount Computation Computation Ain costs y= 5. Using the formula obtained in requirement 4, determine the estimated costs if the hotel expects 95,000 guests in Year 6. Item Amount Computation G H
Expert Answer:
Answer rating: 100% (QA)
ANSWER Naive Model The Naive Model assumes that the next years value for a variable will be the same as the current years value Therefore the estimate... View the full answer
Related Book For
Fundamentals of corporate finance
ISBN: 978-0470876442
2nd Edition
Authors: Robert Parrino, David S. Kidwell, Thomas W. Bates
Posted Date:
Students also viewed these accounting questions
-
Ruth Hornsby is looking to invest in a three-year bond that makes semiannual coupon payments at a rate of 5.875 percent. If these bonds have a market price of $981.13, what yield to maturity and...
-
Joe Carter is looking to invest in a four-year bond that pays semi-annual coupons at a coupon rate of 5.6 percent and has a par value of $1,000. If these bonds have a market price of $$1035, what...
-
The Upstart Corporation is looking to invest one of 2 mutually exclusive projects, the cash flows for which are listed below. Their director is really not sure about the hurdle rate that he should...
-
On July 1,the first day of their fiscal year, the City of Denver sold bonds with a face value of $10,000,000 at 102 percent par. The bonds bear annual interest at 6 percent; interest is payable...
-
Random samples of size 5, 20, and 80 are drawn from a population with a mean of = 100 and a standard deviation of = 15. a. Give the mean of the sampling distribution of y for each of the three...
-
Which of the following is the most suitable response for risks that involve high loss severity and low loss frequency? A. Risk avoidance. B. Risk diversification. C. Risk reduction. D. Risk transfer.
-
Can you conclude that the quality varies among shifts? Use the = 0.01 level of significance. Exercises 79 refer to the following data: At an assembly plant for light trucks, routine monitoring of...
-
How might the outcome of this case have been different if Cameron had been merely an aircraft parts supplier, with his only profit to be from the sale of components to Anderson?
-
Tableau Dashboard Activity 4 (Static) Part 1 A financial manager is reviewing three potential portfolios. His goal is to find the best portfolio structure for each of his three new clients: Client...
-
One aspect of the problem that has been ignored to this point is that each approved project must be led by a senior project manager. Julie has identified only eight senior managers who qualify and...
-
Assume that Sigma Group has a market equity capitalisation of $10.8 billion and its enterprise value is $14.4 billion. The company's equity holders require a return of 10% and the debtholders a...
-
Describe briefly the essential assumptions and major features of the Todaro model of rural-urban migration. One of the most significant implications of this model is the paradoxical conclusion that...
-
In the context of development priorities, what are the relative roles of central banks, commercial banks, development banks, informal and unorganized sources of credit, and microfinance such as the...
-
Distinguish carefully between private and social benefits and costs of education. What economic factors give rise to the wide divergence between private and social benefit-to-cost valuations in most...
-
Draw up a balance of payments table similar in format to Table 13. 3 using the most recent data from any developing country (consult the IMFs International Financial Statistics at imfstatistics.org/...
-
What has been proposed to resolve the problem of odius debt? How effective a solution do you think this will be for averting future problems involving developing-country debt?
-
Explain how the Emergency Medical Treatment and Active Labor Act (EMTALA) creates a right to healthcare? Under Medicare pay-for-performance, how might a focus on quality actually result in poor care...
-
Classify each of the following as direct costs or indirect costs of operating the Pediatrics ward for children at the Cleveland Clinic: a. Wi-Fi covering the entire hospital campus b. Net cost of...
-
Why are the variables that affect the value of a put option the same as those that affect the value of a call option?
-
What are some of the drawbacks to setting profit maximization as the main goal of a company?
-
Explain what the SIC codes are, and discuss the pros and cons of using them in financial analysis.
-
An air-conditioning chiller unit weighing \(10 \mathrm{kN}\) is to be supported by four air springs (Fig. 2.50). Design the air springs such that the natural frequency of vibration of the unit lies...
-
The maximum velocity attained by the mass of a simple harmonic oscillator is \(10 \mathrm{~cm} / \mathrm{s}\), and the period of oscillation is \(2 \mathrm{~s}\). If the mass is released with an...
-
A helical spring, when fixed at one end and loaded at the other, requires a force of \(100 \mathrm{~N}\) to produce an elongation of \(10 \mathrm{~mm}\). The ends of the spring are now rigidly fixed,...
Study smarter with the SolutionInn App