Question
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.)
Homework Answers
Answer #1
Not the answer you're looking for?
Similar Questions
Sales of quit covers at at Jim's departmental store in Australia over the last 12 months...
Sales of quit covers at at Jim's departmental store in Australia
over the last 12 months 2017 are shown below
Period: Actual Demand:
Jan. -20
Feb -21
March -15
April -14
May - 13
June - 16
July - 17
August. - 18
Sep - 20
October. -20
November. - 21
December. -24
Calculate:
I. Use a 3- month and 4-month average on all the data and plot
averages and the actual demand.
II. Using MAD techniques determine which is...
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...
Actual sales for January through April are shown below: Observation Month Actual Sales (A) Forecasted Sales...
Actual sales for January through April are shown below:
Observation
Month
Actual Sales (A)
Forecasted Sales (F)
1
January
18
2
February
23
3
March
20
4
April
16
5
May
a. Use exponential smoothing with α = 0.2 to calculate
smoothed averages and forecast sales for May from the above data.
Assume the forecast for the initial period (January) is 18.
b. Calculate MSE, and MAPE.
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
Suppose a company has the following sales for the last six months (January – June): Month...
Suppose a company has the following sales for the last six
months (January – June):
Month
Period
Sales
January
1
16
February
2
25
March
3
20
April
4
20
May
5
31
June
6
35
July
7
26
August
8
(a)
Use this information to answer the following 7
questions:
ques 1 given the information above
1.Use exponential smoothing (a= 0.10) to forecast the sales for
August (to 2 decimals). What is the value?
2. Compute the MSE for...
The Prince Albert Corporation has forecast the following sales for the first seven months of the...
The Prince Albert Corporation has forecast the following sales
for the first seven months of the year.
January
$28,000
May
28,000
February
30,000
June
34,000
March
32,000
July
36,000
April
38,000
Monthly material purchases are set equal to 30 percent of
forecasted sales for the next month. Of the total material costs,
40 percent are paid in the month of purchase and 60 percent are
paid in the following month. Labour costs will run $5,800 per
month, and fixed overhead...
The following time series shows the number of units of a particular product sold over the...
The following time series shows the number of units of a
particular product sold over the past six months.
Month
Units Sold
1
9
2
4
3
5
4
6
5
13
6
11
a. Compute the three-month moving average forecast for month
4.
b. Compute the three-month moving average forecast for month
5.
c. Compute the three-month moving average forecast for month
6.
d. Compute the mean squared error (MSE) for the three-month
moving average forecasts.
e. Use α...
Suppose a company has the following sales for the last six months (January – June): Month...
Suppose a company has the following sales for the last six
months (January – June):
Month
Period
Sales
January
1
16
February
2
25
March
3
20
April
4
20
May
5
31
June
6
35
July
7
26
August
8
(a)
Use this information to answer the following 7
questions:
6.Using January through July values, develop a linear trend
equation for this time series (to 4 decimals). Please write the
equation in the proper form.
7.Using your answer from...
The following data is given: August trend forecast = 600 units Actual sales in August &nb
The following data is given:
August trend
forecast =
600 units
Actual sales in
August =
370 units
Actual sales in
September =
700 units
Actual sales in
October =
665 units
Seasonal index for
August =
0.9
Seasonal index for
Septemeber =
1.2
Seasonal index for
October =
1.1
Seasonal index for
Novermber =
0.8
Smoothing Constant,
α =
0.2
Use simple exponential smoothing to find the forecast
(seasonalized) for November.
Shown below are the budgeted sales for ABC Company for the next six months: Sales for...
Shown below are the budgeted sales for ABC Company for the next six months:
Sales for Cash Sales on Account
January $15,000 $ 70,000
February $18,000 $ 80,000
March $14,000 $160,000
April $26,000 $120,000
May $18,000 $170,000
June $24,000 $105,000
On average, 35% of the sales on account are collected in the month of sale,
40% are collected in the month following sale, 10% are collected in the
second month following sale, and the remaining 15% is collected three months...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 5 minutes ago
asked 22 minutes ago
asked 27 minutes ago
asked 29 minutes ago
asked 45 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago