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 Week Sales (cases) 1 17 2 21 3 27 4 32 5 19 6 18 7 22 8 25 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 to accomplish the objective? Please put the different locations in a graph and show the exact calculated location of the studio. Cellezs Map Ceordinatcfs y) Load (2,10) (4,9) (9,5) (3,2) (2,6) Av. Btanc 53, 1202 Geneva, Switzerland T: +41 22 906 9494 E: info@gbsge.eom FSEP, AGEP, CEEMAN Bachelors | Masters | Doctorates Accredited by IACBE, ECBE, EDUQUA Member of FEDE www.mygbs.org Geneva | Barcelona I Moscow L Asto

Explanation / Answer

Answer 1:-

Week Sales 3-period moving avg 4-moving average Actual Deviation for F1 Actual Deviation for F2 1 17 2 21 3 27 4 32 5 19 6 18 78 24.75 -60 -6.75 7 22 69 24 -47 -2 8 25 59 22.75 -34 2.25 3 period moving average = For 6th week = (27+32+19)/3=78 For 7th week = (32+19+18)/3=69 For 8th week = (19+18+22)/3=59 4 period moving average = For 6th week = (21+27+32+19)/4=24.75 For 7th week = (27+32+19+18)/4=24 For 8th week = (32+19+18+22)/4=22.75 MAD = Sum(A-F)/n MAD for first forecast = 141/3 47 MAD for second forecast = 6.5/3 2.17 The second forecast will be preferred due to lower MAD

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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