A hotel demand for Quarter one is 21,900, Quarter two 14,700, Quarter three 13,600 and Quarter four 19,800.  Compute the season average, seasonal index, deaseasonalized demand, smoothed demand and re-seasonalized demand.  Smoothing parameter is 0.20 and initial forecast is 17,000.

Assume Sandra's forecasted ADR for the night is $1600.99. What would be her estimated total room revenue for this day? ADR = Total room revenue / Number of rooms sold

The demand data for Double T Computer Services appears below.  The company wants you to forecast the demand for period 4.  What is your forecast using the least squares method? Period Demand 1 37 2 40 3 40

Given an actual demand this period of 90, a forecast for this period of 58, and an alpha of 0.2, what would the forecast for the next period be using exponential smoothing?

Given: Year     Demand 1             7 2             9 3             5 4             9 5 Predict the value for Year 5: 2 year moving average What is MSE for 2 year moving average? 2 year moving average using 0.6 (weight for the oldest period) and 0.4(weight for most recent period Exponential smoothing, =0.2 and forecast for Year 1 = 5 Linear trend Which forecast method has the least amount of error using MAD? What is the coefficient?

Use simple exponential smoothing with a=0.6 to forecast chargers sales for February through May. Assume that the forecast for January was 24 chargers. *** Month January Charger Sales 42 February 33 March 28 April 59 May ? a) What will be the forecast for May? b) Calculate the MSE.

In August a tractor dealer pridicted september demand for 201 tractors , actual demand was 259 tractors. Now using a smoothing constant chosen by the organisation of alpha 0.21, the dealer wants to forecast October demand using the exponential smoothing model ?

The department manager is using a combination of methods to forecast sales of toasters at a local department store. The demands are shown in the table below. Use two decimals in your answer. Week Actual Demand 24 2 30 3 32 4 35 40 6 43 Using weights of 0.50, 0.30, 0.20, Calculate the weighted three-week moving average for week 6 29.80 O 33.10 36.90 O 40.50

The number of cans of soft drinks sold in a machine each week is recorded below. Develop forecasts for the period indicated and error calculations. 155, 145, 155, 162, 180, 165, 172, 149, 170, 172 Exponential smoothing.  Use Excel Solver to determine the optimum alpha value to minimize MSE and answer: What is the Mean Absolute Percentage Error (MAPE)?

A ski resort has recorded its recent sales as follows (in $$).   Season 2 years ago Last year This year Spring 700 950 900 Summer 450 500 400 Fall 1,150 1,100 1,350 Winter 1,400 1,500 1,600   The resort estimated that the annual demand for the next year will be 4,800. What would be the forecast for next Fall?   Answer: _______