Question: 1. Under the 3-month weighted moving average method, what is the forecast for the fourth month? 2. Under the 3-month weighted moving average method, what

1. Under the 3-month weighted moving average method, what is the forecast for the

fourth month?

2. Under the 3-month weighted moving average method, what is the forecast for the

fifth month?

3. Under the exponential smoothing method, What is the forecast for the third month?

4. Under the exponential smoothing method, what is the forecast for the fourth month?

5. Under the exponential smoothing method, what is the forecast for the fifth month?

The number of items sold over a four-month period are: month 1 2 3 4 sales 5100 5500 5400 5600 Calculate the forecasts for the 4th and 5th months using 3-month weighted moving average method with weights of 0.6 for the most recent month and 0.3 for the next to the most recent month. Further, suppose that the exponential smoothing constant a=0.5. Then calculate the forecasts for 3rd, 4th and 5th months, using exponential smoothing method

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Question Completion Status: QUESTION 37 Under the 3-month weighted moving average method, what is the forecast for QUESTION 38 Under the exponential smoothing method, What is the forecast for the...

BA357 HW3 Forecasting A sales manager wants to forecast monthly sales of the machines the company makes using the following monthly sales data. Month 1 2 3 4 5 6 7 Balance $3,803 $2,558 $3,469 $3,442...

The Universal Computer Company wants to forecast the monthly sales of their newly introduced tablet computer using the following historical sales data: Month Sales (units) 1 8,000 2 10,000 3 12.500 4...

A sales manager wants to forecast monthly sales of the machines the company makes using the following monthly sales data. Month Balance 1 3728 2 4442 3 3469 4 3728 5 2682 6 3442 7 2558 8 3803 Use the...

Use the information in the table to the right A sales manager wants to forecast monthly sales of the machines the company makes using the following monthly sales data. Use the 3-month weighted moving...

Use the information in the table to the right. Use the 3-month weighted moving - average method to calculate the forecast for month 9. The weights are 0.60, 0.30, and 0.10, where 0.60 refers to the...

A sales manager wants to forecast monthly sales of the machines the company makes using the following monthly sales data. Month Sales 1 230 2 - 209 3 243 4 301 5 256 6 297 Use the 3-month weighted...

A sales manager wants to forecast monthly sales of the machines the company makes using the following monthly sales data. Month Sales 1 230 2 209 3 243 4 301 5 278 297 256 No Use the 3-month weighted...

A sales manager wants to forecast monthly sales for the company's products using the following monthly sales data. month 1 2 3 4 5 6 7 8 Sales $3,803 $2.558 $3,469 $3,442 $2,682 $2798 $3081 $3443 Use...

Use the information in the table to the right Use the 3-month weighted moving average method to calculate the forecast for month The weight 0.80 0.30 and 0.10, where 060 refers to the most recent...

(a) Jose Ramirez believes that the analysis of financial statements is directed at two characteristics of a company: liquidity and profitability. Is Jose correct? Explain. (b) Are short-term...

Air flows through a nozzle in an isentropic manner from p = 400 kPa, T = 25oC at the inlet to p = 100 KPa at the exit. Determine the temperature at the exit (T2), modeling air as a perfect gas.

3. (i) Express y = - x ^ 2 - 6x - 9 in the form y = - (x + p) ^ 2 + q (ii) Hence, sketch the graph of y = - x ^ 2 - 6x - 9

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...