Question: Given the following data, forecast period 9 using Exponential Smoothing with a smoothing constant equal to 0.20 and a starting forecast for period 2 of

Given the following data, forecast period 9 using Exponential Smoothing with a smoothing constant equal to 0.20 and a starting forecast for period 2 of 68.

Period	Demand
1	68
2	75
3	70
4	74
5	69
6	72
7	80
8	78

pls write and don't use ms excel. Tnx

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

McCall's Garden Supply has seen the following annual demand for lime bags over the past 11 years. A_ Develop 2-year moving average to forecast the next period demand (1pt) BDevelop a 4-year moving...

A sales manager wants to forecast monthly sales of the machines the company makes using the following monthly sales data. Month Balance 1 $3,803 2 $2,558 3 $3,469 4 $3,442 5 $2,682 6 $3,469 7 $4,442...

Consider the following time series: a. Forecast the demand for Period 9 using exponential smoothing with = 0.1. b. Calculate the MAD for the forecast in part a. c. Forecast the demand for Period 9...

6. Consider the following data table, Forecast demand using exponential smoothing with an alpha of 0.4, and an initial forecast of 28.0 for period 1. In addition, calculate the MAD and MSE; and...

Part B. Consider the following data table. Forecast demand using exponential smoothing with an alpha of 0.4, and an initial forecast of 28.0 for period 1. In addition, calculate the MAD and MSE, and...

A new car dealer has been using exponential smoothing with a smoothing constant equal to 0.2. Actual sales are given below. What will be his forecast for period 7, if the forecast for period 1 was...

To test this backup system, they use the following historical data from a cloud - based system. Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec 1 2 , 0 0 0 1 4 , 0 0 0 1 1 , 0 0 0 1 5 , 0 0 0 1 5 ,...

The following table shows data on the average number of customers processed by several bank service units each day. The hourly wage rate is $20, the overhead rate is 1.1 times labor cost, and...

Help me with my problems kindly Tutorial Question: Moving Average: Exercise Weekly sales of ten-grain bread at the local organic food market are in the table below. Based on this data, forecast week...

Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table 1 2 4 7 8 9 10 11 4.00 6.00 6.00 6.00 10.00 8.00 8.00 10.00 13.00 14.00...

Lion Ltd. has an operating Division X that produces microwave oven which can be sold to retailers directly. Division X is currently producing 3,000 units per month, which uses 60% of the maximum...

Using the Steam turbine described in the previous problem, 4-1-75[BCN], plot how the shaft power (Wsh) varies with input pressure (p1) varying from 1 MPa to 2.5 MPa, all other input parameters...

\ table [ [ 1 , Preliminary taxable income ( loss ) , Additional tax return item ( s ) , Form 1 1 2 0 , line 3 0 , taxable income ( loss ) ] , [ 2 , $ 1 0 0 , 0 0 0 , $ 2 0 , 0 0 0 of charitable...

What is an example of constructive feedback? provide reference