Determine the forecast for month 13

Assignment Help Civil Engineering

Reference no: EM131408696

Joe Kool has decided to use 3-month weighted moving average method for one of his company's products. Last year's monthly sales data are given in Table 2.19. Joe is trying to decide the appropriate weights to select for his forecasting method that will minimize the sum of the absolute errors between the forecasts and the actual values. Show that the determination of the optimal weights can be formulated as an LP problem. Solve the linear program using any optimization software and determine the forecast for month 13.

Reference no: EM131408696

Questions Cloud

Geno-type of the mother : Assume the gene for freckles is dominate (F). A woman with freckles has a sone that does not. What would have be the geno-type of the mother?

Compute their forecasting errors using mad and bias : Consider the various forecasting methods in Exercise 2.6. Compute their forecasting errors using MAD and BIAS. Based on the forecast errors, which method would you recommend and why?

Which independent variables are statistically significant : Which independent variables are statistically significant? How do you know this? c) What is the marginal propensity to save (MPS)? Consume (MPC)?

Fermentation to make atp : What other hypotheses can you suggest concerning yeast's ability to use fermentation to make ATP?

Determine the forecast for month 13 : Show that the determination of the optimal weights can be formulated as an LP problem. Solve the linear program using any optimization software and determine the forecast for month 13.

Develop a strategy for periodically testing your inventory : Assume that you are employed by Sahara, Inc. Sahara Inc is an up-and-coming on-line reseller of books, video games, and small household appliances. Projections for 2016 sales are looking up, and expected to be in the $750,000,000 dollar range, wit..

Structure and arrangement of alveoli : 1. Explain how the structure and arrangement of alveoli make them well suited for their role in gas exchange.

How much would your stakeholders suffer : How much would your stakeholders suffer if they lost you?- How much do you currently contribute to society and what would society lose if you were not here?

Why do some people in the us not have health coverage : Does this mean the healthcare is better? Why do some people in the United States not have health coverage or enjoy the benefits of healthcare equally?

User Account

All Pages