Knowee
Questions
Features
Study Tools

A manufacturing company has the monthly demand for its product as shown below.Month DemandFebruary 520March 490April 550May 580June 600July 420August 510September 610Calculate the 3-month weighted moving average forecast for the month of July with weights of 0.5, 0.3 and 0.2 for the most recent demand values, in that order. (answer in whole number)

Question

A manufacturing company has the monthly demand for its product as shown below.Month DemandFebruary 520March 490April 550May 580June 600July 420August 510September 610Calculate the 3-month weighted moving average forecast for the month of July with weights of 0.5, 0.3 and 0.2 for the most recent demand values, in that order. (answer in whole number)

🧐 Not the exact question you are looking for?Go ask a question

Solution

To calculate the 3-month weighted moving average forecast for the month of July, we need to take the demand values for the three most recent months (April, May, and June) and apply the given weights.

Here are the steps:

  1. Multiply the demand for June (600) by its weight (0.5): 600 * 0.5 = 300
  2. Multiply the demand for May (580) by its weight (0.3): 580 * 0.3 = 174
  3. Multiply the demand for April (550) by its weight (0.2): 550 * 0.2 = 110

Now, add these weighted values together:

300 + 174 + 110 = 584

So, the 3-month weighted moving average forecast for the month of July is 584 (rounded to the nearest whole number).

This problem has been solved

Similar Questions

A company wants to forecast demand using the weighted moving average. If the company uses three prior yearly sales values (i.e., year 2015 = 230, year 2016 = 220, and year 2017 = 250), and we want to weight year 2015 at 30 percent, year 2016 at 30 percent, and year 2017 at 40 percent, which of the following is the weighted moving average forecast for year 2018?Group of answer choices253233.3320235233

asked to calculate 3 months moving average, Is it same as the forecast example:3 month moving average for April = (jan + feb + mar)/3

Predicted demand of a product for the current month = 4,064 unitsActual demand of the product for the current month = 4,806 unitsSmoothing constant = 0.2Required: Forecast the demand of the product (in units) for the next month?

A computer software firm has experienced the demand for their software package as shown below.Month Demand (D)1 562 613 554 705 666 65Using 𝛂 = 0.4, what is the exponential smoothing forecast for month 3? (Assume F1 = 56) (answer in whole number)

demand forecasting

1/3

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.