Question
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.
Homework Answers
Answer #1
Not the answer you're looking for?
Similar Questions
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.)
Osage, Inc., has actual sales for May and June and forecast sales for July, August, September,...
Osage, Inc., has actual sales for May and June and forecast
sales for July, August, September, and October as follows:
Actual:
May
5,930
units
June
6,240
units
Forecast:
July
5,910
units
August
6,890
units
September
5,630
units
October
5,210
units
Required:
a.
The firm’s policy is to have finished goods inventory on hand at
the end of the month that is equal to 70% of the next month’s
sales. It is currently estimated that there will be 4,137 units on...
IV. The following are monthly actual and forecast demand levels for July thru December for units...
IV. The following are monthly actual and forecast demand levels
for July thru December for units of a
product manufactured by the N.
Tamimi Pharmaceutical Company:
Month Actual
Demand Forecast Demand
July
71
78
August
80
75
September
101
83
October
84
84
November
60
88
December
73
85
Compute a tracking signal and determine whether the forecasts
are in control.
For the data given below, forecast period 17 using following methods and suggest the best forecasting...
For the data given below, forecast period 17 using following
methods and suggest the best forecasting model
1. Simple Moving Average (Three Period)
2. Weighted Average (50% on t-1, 30% on t-2, 20% on t-3)
3. Exponential Smoothing (α=.1), F1= y intercept from
regression)
4. Exponential Smoothing (α=.3), F1= y intercept from
regression)
5. Exponential Smoothing with trend (α=.3) and (δ=.3), F1= y
intercept from regression)**
5. Exponential Smoothing with trend (α=.1) and (δ=.3), F1= y
intercept from regression)**
6....
The following are monthly actual and forecast demand levels for May through December for units of...
The following are monthly actual and forecast demand levels for
May through December for units of a product manufactured by the D.
Bishop Company in Des Moines:
Month
Actual Demand
Forecast Demand
May
108
104
June
80
100
July
112
99
August
112
101
September
105
100
October
106
106
November
125
102
December
115
111
For the given forecast, the tracking signal = ___ MADs (round
your response to two decimal places).
The monthly sales for Yazici Batteries, Inc., were as follows: MONTH SALES January 20 February 21...
The monthly sales for Yazici Batteries, Inc., were as
follows:
MONTH
SALES
January
20
February
21
March
15
April
14
May
13
June
16
July
17
August
18
September
20
October
20
November
21
December
23
Plot the monthly sales data.
Forecast January sales using each of the following:
Naive method.
A 3-month moving average.
A 6-month weighted average using .1, .1, .1, .2, .2, and .3,
with the heaviest weights applied to the most recent months.
Exponential smoothing using...
Suppose ten weeks of data on the Commodity Futures Index are 7.34, 7.39, 7.54, 7.56, 7.61,...
Suppose ten weeks of data on the Commodity Futures Index are
7.34, 7.39, 7.54, 7.56, 7.61, 7.52, 7.51, 7.71, 7.63, and 7.55.
(a) What type of pattern exists in the
data?
The data appear to follow a seasonal pattern.
The data appear to follow a cyclical
pattern.
The data appear to follow a trend pattern.
The data appear to follow a horizontal pattern.
(b)Compute the exponential smoothing forecasts for α =
0.2. (Round your answers to two decimal
places.)
Week...
The LaPann Company has obtained the following sales forecast data: July August September October Cash Sales...
The LaPann Company has obtained the
following sales forecast data:
July
August
September
October
Cash Sales
$80,000
$70,000
$50,000
$60,000
Credit Sales
$240,000
$220,000
$180,000
$200,000
The regular pattern of collection of credit sales is 30% in the
month of sale and 70% in the month following the month of
sale. There are no bad debts.
The budgeted accounts
receivable balance on September
30th is:
$126,000
$154,000
$161,000
$186,000
National Scan Inc. sells radio frequency inventory tags. Monthly sales for a seven-month period were as...
National Scan Inc. sells radio frequency inventory tags. Monthly
sales for a seven-month period were as follows: Month Sales (000)
Units
Feb 19
Mar 15
Apr 12
May 28
Jun 17
Jul 24
Aug 28
b. Forecast September sales volume using each of the
following:
SHOW WORKS!!!!
(1) The naive approach.
(2) A five month moving average.
(3) A weighted average using .60 for August, .10 for July, and
.30 for June.
(4) Exponential smoothing with a smoothing constant equal...
V had actual sales and purchases for July and August 2020 as given in the Excel...
V had actual sales and purchases for July and August 2020 as
given in the Excel spreadsheet, along with its forecast sales and
purchases for the period September 2020 through February 2021.
The firm makes 30% of all sales for cash and collects 35% of its
sales in each of the two months following the sale. Other cash
inflows are expected to be $22,000 in September and February,
$25,000 in November and January, and $37,000 in December. The firm
pays...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 9 minutes ago
asked 12 minutes ago
asked 58 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
asked 1 hour ago
asked 2 hours ago