Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. 2. 3. 4. The following is a set of operational information about a local motel during the past years. The motel has 200 rooms
1.
The following is a set of operational information about a local motel during the past years. The motel has 200 rooms in its property. It operates 365 days every year. (lgnore the leap year in calculation process.) Please be advised that the Year "n" is the most recent year Year Occupancy Rate ADR 70% 72% 69% 70% 68% 72% $120 $130 $170 $168 $174 $180 n +1 n+ 2 Using the method of 3-Year Moving Average. project the annual rooms revenues (S) of the motel above for the next year (Years "n +1). The number of days of operations, and the number of rooms available for sales will remain the same (200) for the next few years. Again, ignore the leap year. All years have 365 operating days. Please provide just the number with NO "$" or " for your answer in the nearest dollar (with no cents). For example, if your answer is $123,456.49; then put just 123456 The following is the same set of operational information about a local motel used in the previous question. The motel has 200 rooms in its property. It operates 365 days every year. (lgnore the leap year in calculation process.) Please be advised that the Year "n" is the most recent year Year Occupancy Rate ADR 70% 72% 69% 70% 68% 72% $120 $130 $170 $168 $174 $180 n+ 1 n +2 Based on your finding on the previous question; using the method of 3-Year Moving Average. project the annual rooms revenues ($) of the motel above for the second year ("n + 2") from the current year ("n"). The number of days of operations, and the number of rooms available for sales will remain the same (200) for the next few years. Again, ignore the leap year All years have 365 operating days. Please provide just the number with NO"$" or" for your answer in the nearest dollar (with no cents). For example, if your answer is $123,456.49; then put just 123456. You are forecasting the beverage sales for an outdoor event that serves a large crowd. The crowd will be a mix of adults and kids together. Soda will be served for kids, while beer will be served for adults. The average price of soda is $2.50: and the average price of beer is $4.50. You have found that the beverage sales are reliably correlated with the weather of the day of the event. When you conducted a regression analysis connecting the weather and beverage sales data, the following results were obtained: Weather impact on soda sales: Slope: 3.50 Y-intercept: 1,200 Weather impact on beer sales: Slope: 2.50 Y-intercept: 800 Using the result of the regression analysis presented above, answer the following questions: Project (forecast) the sales amount ($) of soda when the temperature is expected to be 88 degrees F. Please provide just the number with NO "$" or"" for your answer in the nearest dollar (with no cents). For example, if your answer is $123,456.49; then put just 123456 The following is the same scenario that you used in the previous question You are forecasting the beverage sales for an outdoor event that serves a large crowd. The crowd will be a mix of adults and kids together. Soda will be served for kids, while beer will be served for adults. The average price of soda is $2.50: and the average price of beer is $4.50. You have found that the beverage sales are reliably correlated with the weather of the day of the event. When you conducted a regression analysis connecting the weather and beverage sales data, the following results were obtained: Weather impact on soda sales: Slope: 3.50 Y-intercept: 1,200 Weather impact on beer sales: Slope: 2.50 Y-intercept: 800 Using the result of the regression analysis presented above, answer the following questions: Project (forecast) the sales amount ($) of beer when the temperature is expected to be 88 degrees F. Please provide just the number with NO "$" or "" for your answer in the nearest dollar (with no cents). For example, if your answer is 123,456.49; then put just 123456 2.
3.
4.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started