Assume week 10 actual demand for each product is shown below. Create an exponential smoothing forecasts...
| Assume week 10 actual demand for each product is shown below. Create an exponential smoothing forecasts for week 11 each product. | |||||||
| Product X | Product Y | Product Z | |||||
| Week | Historical Demand | Week | Historical Demand | Week | Historical Demand | ||
| 10 | $ 3,800 | 10 | $ 4,100 | 10 | $ 4,800 | ||
alpha = .7
| Product X | Product Y | Product Z | |||||
| Week | Historical Demand | Week | Historical Demand | Week | Historical Demand | ||
| 1 | 5000 | 1 | $ 7,500 | 1 | $ 5,100 | ||
| 2 | 4800 | 2 | $ 4,800 | 2 | $ 4,700 | ||
| 3 | 3900 | 3 | $ 3,000 | 3 | $ 4,700 | ||
| 4 | 5100 | 4 | $ 8,100 | 4 | $ 4,900 | ||
| 5 | 4600 | 5 | $ 2,800 | 5 | $ 5,100 | ||
| 6 | 4900 | 6 | $ 2,900 | 6 | $ 4,900 | ||
| 7 | 4300 | 7 | $ 8,800 | 7 | $ 5,000 | ||
| 8 | 4000 | 8 | $ 3,200 | 8 | $ 5,100 | ||
| 9 | 4300 | 9 | $ 7,500 | 9 | $ 4,900 | ||
Homework Answers
Add Answer to:
Assume week 10
actual demand for each product is shown below. Create an
exponential smoothing forecasts...
nstructions You are responsible for creating the weekly forecast for Products X, Y, and Z for War Eagle Trading Company...
nstructions You are responsible for creating the weekly forecast for Products X, Y, and Z for War Eagle Trading Company (WETCO). Create and evaluate forecasts as described in questions 1-10 below. Enter your answers in the table provided at the bottom of the assignment. All forecasts should be reported to the nearest whole number. Use the following in creating all forecasts: a7 W.6 n 3 W 3 Wa1 W 01 Demand for weeks 1-9 for each product is shown below....
Two experienced managers at Wilson Boat Inc. are resisting the introduction of a computerized exponential smoothing...
Two experienced managers at Wilson Boat Inc. are resisting the introduction of a computerized exponential smoothing system, claiming that their judgmental forecasts are much better than any computer could do. Their past record of predictions is as follows: Week Actual Demand Manager's Forecast 1 3,800 4,400 2 4,100 4,800 3 4,300 3,700 4 3,100 3,800 5 3,900 3,500 6 4,500 3,500 7 5,700 4,900 8 4,000 4,700 9 4,500 3,500 10 4,900 5,400 How would the manager’s forecast compare to...
The actual demand of a product (in units) in week 1 through week 7 were:
The actual demand of a product (in units) in week 1 through week 7 were: 164, 172, 157, 182, 145, 175, and 179. You want to develop a forecasting model using the exponential smoothing model with alpha 0.33. Assume the forecast for week 1 is 164 units. Use at least 4 decimal places in your calculation and no commas in your answer. The forecasted demand for week 3 is _______ The forecasted demand for week 5 is _______ The forecasted demand for week 8 is _______
A) for the following demand data, use exponential smoothing with alpha = .02 to calculate for...
A) for the following demand data, use exponential smoothing with alpha = .02 to calculate for perieod 7 assume forecast for period #1 was 7.0 B) Calculate the MAD error for periods 1-6 for your forecast period demand 1 10 2 8 3 7 4 10 5 12 6 9
i. Find the forecast for week 13. ii. Now obtain the exponential smoothing forecast for the...
i. Find the forecast for week 13.
ii. Now obtain the exponential smoothing forecast for the
weeks.
A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing (let a =...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34 2 37 3 38 4 37 5 40 6 37 7 42 8 44 9 41 10 42 a. Calculate the single exponential smoothing forecast for these data using an ? of 0.20 and an initial forecast (F1) of 34. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 2 3 4 5 6 7 8 9 10 b....
6.Use Exponential smoothing forecasts with alpha of 0.1, 0.2, ..., 0.9 to predict March 2019 demand....
6.Use Exponential smoothing forecasts with alpha of 0.1, 0.2, ..., 0.9 to predict March 2019 demand. Identify the value of alpha that results in the lowest MAD. 7.Find the monthly seasonal indices for the demand values using Simple Average (SA) method. Find the de-seasonalized demand values by dividing monthly demand by corresponding seasonal indices. 8.Use regression to perform trend analysis on the de-seasonalized demand values. Is trend analysis suitable for this data? Find MAD and explain the Excel Regression output...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 33...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 33 2 29 3 32 4 33 5 35 6 32 7 35 8 42 9 44 10 45 a. Calculate the single exponential smoothing forecast for these data using an α of 0.10 and an initial forecast (F1) of 33. (Round your answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α of 0.10, a...
Prepare weekly forecasts for week 15 for each product using Moving Average forecasting technique using a...
Prepare weekly forecasts for week 15 for each product using Moving Average forecasting technique using a 2 -6 period moving average. Then use error analysis or forecast accuracy techniques for the 2 - 6 period moving averages. Week Product 1 Product 2 1 50 40 2 54 38 3 57 41 4 60 46 5 64 42 6 67 41 7 90 41 8 76 47 9 79 42 10 82 43 11 85 42 12 87 49 13 92...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36 2 38 3 40 4 41 5 43 6 42 7 43 8 45 9 46 10 48 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 36. (Round your intermediate calculations and answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α...
nstructions You are responsible for creating the weekly forecast for Products X, Y, and Z for War Eagle Trading Company (WETCO). Create and evaluate forecasts as described in questions 1-10 below. Enter your answers in the table provided at the bottom of the assignment. All forecasts should be reported to the nearest whole number. Use the following in creating all forecasts: a7 W.6 n 3 W 3 Wa1 W 01 Demand for weeks 1-9 for each product is shown below....
i. Find the forecast for week 13.
ii. Now obtain the exponential smoothing forecast for the
weeks.
A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing (let a =...
Most questions answered within 3 hours.
-
I need to write a research paper and work cited about this
topic: The United States...
asked 21 minutes ago -
Hello! I was wondering if I could have some help?
If the vapor pressure of carvone...
asked 43 minutes ago -
An economist wants to estimate the mean per capita income (in
thousands of dollars) for a...
asked 1 hour ago -
What would be the input/output characteristic of a circuit
obtained by putting two of your 2's-complementers...
asked 1 hour ago -
In Drosophila, the transition from the syncytial blastoderm
stage to the cellular blastoderm stage is a...
asked 1 hour ago -
Project management question:
Name 3 different types of resources (hint: humans are one
type)
asked 1 hour ago -
Consider the following reaction: C 2H 2( g) + 2H 2( g) C 2H 6(
g)...
asked 1 hour ago -
Consider a 1.0 L buffer containing 0.092 mol L-1 HCOOH and 0.100
mol L-1 HCOO-. What...
asked 1 hour ago -
Koch Realty has owned a vacant land with a FMV of
$775,000 and an adjusted basis...
asked 2 hours ago -
It is estimated 29% of all adults in United States invest in
stocks and that 85%...
asked 2 hours ago -
What does a 2-sided p value of 0.04 mean? (I am not asking if it
is...
asked 2 hours ago -
A parallel-plate capacitor is made from two aluminum-foil
sheets, each 7.8 cmcm wide and 5.1 mmlong....
asked 2 hours ago