The Sunrise Hotel data for the past 5 years are presented below: Year Occupancy 1 The...

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

Answer rating: 100% (QA)

The detailed answ... View the full answer