Question

Use exponential smoothing, with alpha=0.2, to calculate the forecasts for percent utilization below. June's forecast was...

Use exponential smoothing, with alpha=0.2, to calculate the forecasts for percent utilization below. June's forecast was 90% utilization and actual usage was 94% utilization.

   

a.

Calculate the forecast of percent utilization for July. (Round your final answer to 2 decimal places.)

   

  Forecast for July ______percent of utilization  

   

b.

If usage in July was 98 percent, calculate the forecast of percent utilization for August. (Round your answer to 2 decimal places.)

   

  Forecast for August _____percent of capacity  

Homework Answers

Answer #1

a)

The forecast for month of July is obtained using the formula,

Where,

is forecast for month of July

is the forecast for month of June

is the actual percent of utilization for month of June

is the smoothing factor

b)

Now, the actual usage for July is 98%, the forecast for month of August is

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Using ? = 0.5 and the following data, compute exponential smoothing forecasts for periods 2 through...
Using ? = 0.5 and the following data, compute exponential smoothing forecasts for periods 2 through 8. (Round your intermediate calculations and final answers to 2 decimal places.) Period: 1 2 3 4 5 6 7 Forecast: 10 Actual demand: 12 15 11 13 11 11 10
Create the following forecasts: a 4-period moving average forecast, an exponential smoothing forecast with alpha=0.2, and...
Create the following forecasts: a 4-period moving average forecast, an exponential smoothing forecast with alpha=0.2, and a linear trend forecast for your data. Calculate the MSE and MAPE for each. Plot the original series, and each of the forecasts. Create forecasts for 2017 Q1, 2017 Q2, 2017 Q3 and 2017 Q4 using each of these three techniques. If you had to choose one of these, which would you choose and why? Given your data, and this time period, would you...
Use a simple exponential smoothing model (SES) with alpha of .4. The forecast for period 8...
Use a simple exponential smoothing model (SES) with alpha of .4. The forecast for period 8 is? period Y 1 50 2 85 3 65 4 90 5 88 6 90 7 110 8 Forecast period 8 =
(b) Develop the three-week moving average forecasts for this time series. (Round your answers to two...
(b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 16 2 11 3 13 4 10 5 14 6 12 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (c) Use α = 0.2 to compute the exponential smoothing forecasts for the time series. Week Time Series Value Forecast 1 16 2 11 3 13 4...
Use exponential smoothing with ? = 0.4 to forecast donut sales for May. Assume that the...
Use exponential smoothing with ? = 0.4 to forecast donut sales for May. Assume that the forecast for January was for 28 donuts. Month Donut Sales January 32 February 33 March 28 April 39 Use Excel Quiz 5, Exponential Smoothing, round to two decimal places
Use the first 9 months to forecast for October 2019 using the following than calculate  Exponential smoothing...
Use the first 9 months to forecast for October 2019 using the following than calculate  Exponential smoothing with αlpha=0.2 2019 Monthly Demand = [1,058,895] [1,098,476] [1,714,796] [1,469,545] [2,141,204] [940,652] [1,471,479] [1,557,795] [1,873,287]
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12 16 11 18 13 (b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 19 2 12 3 16 4 11 5 18 6 13 Compute MSE. (Round your answer to two decimal places.) MSE =   What is the forecast for week 7? (c) Use α = 0.2 to compute...
The table below shows the actual demand and the forecasted amounts (where available). Use this table...
The table below shows the actual demand and the forecasted amounts (where available). Use this table to answer questions. Actual Forecast 1 100 - 2 95 - 3 102 - 4 100 105 5 110 111 6 120 115 7 112 115 8 130 125 9 130 128 What is the mean absolute deviation for the forecast? 3.5 2.33 3.89 2.86 What is the mean squared error for the forecast (round to two decimal point)? 89.12 9.94 14.83 4.72 The...
The following tabulations are actual sales of units for six months and a starting forecast in...
The following tabulations are actual sales of units for six months and a starting forecast in January. ACTUAL FORECAST January 116 96 February 112 March 115 April 88 May 82 June 112 a. Calculate forecasts for the remaining five months using simple exponential smoothing with α = 0.3. b. Calculate the MAD for all the forecasts, including January's. (Round your answer to 1 decimal place.)
Use trial and error to find a value of the exponential smoothing coefficient α that results...
Use trial and error to find a value of the exponential smoothing coefficient α that results in the smaller MSE than what you calculated for α = 0.2. If required, round your answer to two decimal places. α =