Section-B (15 marks- part (a)-6 and (b)9 marks) a) A Weekly sale of gadgets are

Question

Section-B (15 marks- part (a)-6 and (b)9 marks) a) A Weekly sale of gadgets are in the table below Compute a three-period moving average and a four-period moving average for weeks 6, 7, and 8 Compute MAD for each forecast. Which model is more accurate? Forecast week 9 with the more accurate method. WeekSales (cases) 21 27 32 19 18 b) A telecommunications firm is planning to lay fiber optic cable from several community college distance learning sites to a central studio, in such a way that the miles of cable are minimized. Some locations require more than one set of cables (these are the loads). Where should the studio be located Please put the different locations in a graph and show the exact calculated location of the studio. to accomplish the objective? College Map Coordinate (. Load (2,10) (6,8) (9,5) (3,2) (2,6)

Explanation / Answer

A-1

3 period moving average for week 6 = (sales for week 3 + sales for week 4 + sales for week 5)/3

4 period moving average for week 6 =( sales for week 2+ sales for week 3 + sales for week 4 + sales for week 5)/4

A-2

MAD for 3 period moving average = (8+1+5.33)/3 = 4.78

MAD for 4 period moving average = (6.75+2+2.25)/3 = 3.67

A-3

4-Period moving average is more accurate due to the relatively lower value of MAD that is 3.67.

A-4

Week-9 forecast by 4-Period moving average = (19+18+22+25)/4 = 21

Pl. repost other unanswered questions for the proper answers!

Week Sales 3 period moving average 4 period moving average 1 17 2 21 3 27 4 32 5 19 6 18 26 24.75 7 22 23 24 8 25 19.67 22.75

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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