1.Consider the following historical data gathered by a retail store: Month: Mar

Question

1.Consider the following historical data gathered by a retail store:

                        Month:            Mar      Apr      May     Jun       Jul        Aug

                        Demand:         18       16       16       14       12       14

Use a simple moving average with n = 4 to forecast demand for November.

14.0

15.33

15.6

18.4

2.

Consider the following historical data gathered by a retail store:

                        Month:            Mar      Apr      May     Jun       Jul        Aug

                        Demand:         19       15       17       15       13       12

Use linear regression (assuming b0 = 21.92, b1 = -1.23, and January is month one) to forecast demand for September.

7.16

12.12

13.64

10.85

14.0

15.33

15.6

18.4

Explanation / Answer

1)forecaast for november =(16+14+12+14)/4= 14

2) as for september month number is 9

forecast demand for September =21.92-1.23*9= 10.85

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.