Question
Given an alpha factor of 0.4, a current demand for April of 5,500 units, and a...
Given an alpha factor of 0.4, a current demand for April of 5,500 units, and a March forecast of 4,900 units, calculate the May forecast.
Homework Answers
Answer #1
Not the answer you're looking for?
Similar Questions
A) Consider the following data: Period: Demand: Jan. 20 units Feb 33 units March 28 units...
A) Consider the following data:
Period: Demand:
Jan. 20 units
Feb 33 units
March 28 units
April 35 units
May 37 units
June 25 units
The sales department is planning for July and wants to estimate
the demand. Set up an Exponential Smoothing Forecast Model and then
compute the demand forecast for July.
B) Briefly describe two general forecasting approaches.
Kovarik Company has the following sales forecast for the next quarter: April, 4,000 units; May, 4,800...
Kovarik Company has the following sales forecast for the next
quarter: April, 4,000 units; May, 4,800 units; June, 5,600 units.
Sales totaled 3,200 units in March. The March ending finished goods
inventory was 1,000 units. End-of-month finished goods inventory
levels are planned to be equal to 30 percent of the next month's
planned sales. Calculate the number of units of inventory Kovarik
needs to purchase for April?
Historical demand for a product is as follows: DEMAND April 58 May 54 June...
Historical demand for a product
is as follows:
DEMAND
April
58
May
54
June
74
July
58
August
76
September
73
a.
Using a simple four-month moving average, calculate a forecast
for October. (Round your answer to 2 decimal
places.)
Forecast for
October
b.
Using single exponential smoothing with ? = 0.10 and a
September forecast = 61, calculate a forecast for October.
(Round your answer to 2 decimal places.)
Forecast for
October...
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
PROBLEM: Calculating demand for hot tubs MONTH DEMAND January 4 February 7 March 11 April 7...
PROBLEM: Calculating demand
for hot tubs
MONTH
DEMAND
January
4
February
7
March
11
April
7
May
14
June
15
a.
Using a simple three-month moving average, find the July
forecast.
b. Using a weighted
moving average with weights of .60, .30, and .10, find the July
forecast. (NOTE: In your calculations, apply the highest weight
to the most recent month and so forth, middle weight to the middle
month, and lowest weight to the farthest month back.)
c.
Using...
Tyler Co. Production Budget April, May and June April May June Next month’s budgeted sales (units)...
Tyler Co.
Production Budget
April, May and June
April
May
June
Next month’s budgeted sales
(units)
%
%
%
0
0
0
Units to be produced
0
0
0
Tyler Co. predicts the following unit sales for the next four
months: April, 3,600 units; May, 4,700 units; June, 6,700 units;
and July, 3,000 units. The company’s policy is to maintain finished
goods inventory equal to 20% of the next month’s sales. At the end
of March, the company had 700...
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 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.)
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.
2. Given a demand equation for goods X: ?? = 50 − 0.4?? + 0.02? +...
2. Given a demand equation for goods X:
?? = 50 − 0.4?? + 0.02? + 0.1??
a. How much is the quantity demanded if price of goods x (PX) is
RM50, income (Y) RM6000 and price of goods z (Pz) is RM60?
b. Calculate price elasticity of demand for good x when its price
is RM50. Is the demand for good x sensitive to the change in its
price?
c. Determine the cross elasticity of demand for good x...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 7 minutes ago
asked 9 minutes ago
asked 12 minutes ago
asked 20 minutes ago
asked 20 minutes ago
asked 28 minutes ago
asked 32 minutes ago
asked 56 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago