Question: Forecasting method: Weighted moving average with N=3. Using this method, please forecast weekly auto sales from week 6 to 8. Week Demand (D) Average(A) Forecast

Forecasting method: Weighted moving average with N=3. Using this method, please forecast weekly auto sales from week 6 to 8.

Week Demand (D) Average(A) Forecast (F)

1 100

2 150

3 130 A3=0.5 *130+0.3*150+0.2*100=130

4 140 A4=0.5*140+0.3*130+0.2*150=139 F4=130

5 120 F4=139

6 110

7 100

8

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!

Q:

Forecasting Method: Weighted Moving Average with N = 3 . Using this method, please forecast weekly auto sales from week 6 to 8 . \ table [ [ Week , Demand ( D ) , Average ( A ) , Forecast ( F ) ] , [...

Q:

Forecasting Method: (Simple) Exponential Smoothing with a=0.3. Using this method, please forecast weekly auto sales from week 5 to 8. Week Demand(D) Average(A) Forecast(F) 1 100 A 1...

Q:

please help me and show the steps clearly Would be preferable under the circumstances. (Before solving the question, select an integer value from the given interval (except wi, W2, W3, a.), fill in...

Q:

Suppose that you work as an engineer in the planning department of a company. You consider to forecast the demand for an item which exhibits a steady demand pattern. Based on your research, you find...

Q:

Suppose that you work as an engineer in the planning department of a company. You consider to forecast the demand for an item which exhibits a steady demand pattern. Based on your research, you find...

Q:

. (40 points) Suppose that you work as an engineer in the planning department of a company. You consider to forecast the demand for an item which exhibits a steady demand pattern. Based on your...

Q:

Refer to Solved Problem 4.1 on page 144. Using smoothing constants of 6 and .9, develop forecasts for the sales of VW Beetles. What effect did the smoothing constant have on the forecast? Use MAD to...

Q:

1/3 SCM 352 Operations Management Session 15: Demand Forecasting Part I Lee auto sales wishes to analyze weekly sales of automobiles. Weekly data for the number of autos sold for the past 7 weeks...

Q:

Learning Outcome + Describe the concept of operations fonctions, supply chain strategy, process selection, forecasting, capacity planning, production forecast methods and schedule operations...

Q:

The demand for a product in each of the last four weeks is shown below. Week Demand of the product 1 23 2 27 3 34 4 40 (a) What demand of the product would you predict for week 5, using a weighted...

Q:

Repeat Problem 951, but replace the isentropic expansion process by polytropic expansion process with the polytropic exponent n = 1.35.

Q:

Explain how parallel simulation works.

Q:

Regarding the profit margin ratio, which of the following statements is incorrect? Select one A . The higher the profit margin ratio, the more sales dollars end up as profit. 8 . The profit margin...

Q:

Create a C# application named SalesTransactionDemo that declares several SalesTransaction objects and displays their values and their sum. The SalesTransaction class contains the following fields:...