# Question: The file S12 72 xlsx contains data on a motel chain s revenue

The file S12_72.xlsx contains data on a motel chain’s revenue and advertising.

a. Use these data and multiple regression to make predictions of the motel chain’s revenues during the next four quarters. Assume that advertising during each of the next four quarters is $50,000.

b. Use simple exponential smoothing to make predictions for the motel chain’s revenues during the next four quarters.

c. Use Holt’s method to make forecasts for the motel chain’s revenues during the next four quarters.

d. Use Winters’ method to determine predictions for the motel chain’s revenues during the next four quarters.

e. Which of these forecasting methods would you expect to be the most accurate for these data?

a. Use these data and multiple regression to make predictions of the motel chain’s revenues during the next four quarters. Assume that advertising during each of the next four quarters is $50,000.

b. Use simple exponential smoothing to make predictions for the motel chain’s revenues during the next four quarters.

c. Use Holt’s method to make forecasts for the motel chain’s revenues during the next four quarters.

d. Use Winters’ method to determine predictions for the motel chain’s revenues during the next four quarters.

e. Which of these forecasting methods would you expect to be the most accurate for these data?

**View Solution:**## Answer to relevant Questions

The file S12_73.xlsx contains data on monthly U.S. permits for new housing units (in thousands of houses).a. Using Winters’ method, find values of α, β, and γ that yield an RMSE as small as possible. Does this method ...The file S12_79.xlsx contains data on mass layoff events in all industries in the U.S. There are two versions of the data: non-seasonally adjusted and seasonally adjusted. Presumably, seasonal factors can be found by ...If all of the inputs in PC Tech’s product mix problem are nonnegative, are there any input values such that the resulting model has no feasible solutions? Create a two-way Solver Table for the product mix model, where total profit is the only output and the two inputs are the testing line 1 hours and testing line 2 hours available. Let the former vary from 4000 to 6000 in ...Modify the Pigskin spreadsheet model so that except for month 6, demand need not be met on time. The only requirement is that all demand be met eventually by the end of month 6. How does this change the optimal production ...Post your question