Identify optimal weights in weighted moving average model

Reference no: EM131929869

Question: 1. Explain how Solver can be used to identify the optimal weights in the weighted moving average model.

2. McCall's Garden Supply has seen the following annual demand for lime bags over the past 11 years:

(a) Develop 2-year, 3-year, and 4-year moving averages to forecast demand in year 12.

(b) Forecast demand with a 3-year weighted moving average in which demand in the most recent year is given a weight of 2 and demands in the other two years are each given a weight of 1.

(c) Forecast demand by using exponential smoothing with a smoothing constant of 0.4. Assume that the forecast for year 1 is 6,000 bags to begin the procedure.

(d) Which of the methods analyzed here would you use? Explain your answer.

Reference no: EM131929869

Questions Cloud

Define your work breakdwn structure : Your task is to start from scratch. Tear it all down and build it back up with new everything.

What effect does the value have on the weight : What effect does the value of the smoothing constant have on the weight given to the past forecast and the past observed value?

Manufacturing outside the united states : human resource management third edition influence Levi's decision to move its manufacturing outside the United States?

Should a marketing research study be undertaken to provide : The shampoo market is valued at around SR 1 million. Sunsilk, Pantene, Dove and Garnier are some of the established brands in the market.

Identify optimal weights in weighted moving average model : Explain how Solver can be used to identify the optimal weights in the weighted moving average model. McCall's Garden Supply has seen the following annual demand

Trade war between the us and china : For example steel and aluminum tariffs that US has imposed as well as impending tariffs/trade war between the US and China.

Report research suggests that majority of criminals : Report research suggests that majority of criminals who were sent to prison would commit crimes when they are set free.

What is the actual apr that jack is being charged : They are charging him a $35 fee to borrow the money for 22 days until he receives his first paycheck. What is the actual APR that Jack is being charged?

Explain the need to align an organizations logistic : Describe different way in which an organization may choose a supply chain and logistics management to compete in the marketplace?

User Account

All Pages