QUANTITATIVE BUSINESS ANALYSIS A. Data collected on the yearly demand of fertili

Question

QUANTITATIVE BUSINESS ANALYSIS A. Data collected on the yearly demand of fertilizer are as follow: Demand (in 1,000s of bags) Year 4 4 12 10 15 Required 1. Develop a 3-year moving average to forecast sales 2. Develop a 3-year weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are each given a weight of 1 . 3. Develop trend line for the demand 4. Which one of the 3 methods is the best by using MAD analysis? B. Data for the past 12 weeks: Actual passenger miles (in 1,000s) 17 21 Week 23 4 18

Explanation / Answer

3 yearly moving average yearly demand of fertilizer by 3 yearly moving average year Demand 3 yearly total 3 yearly moving average 1 4 nil nil 2 6 14 4.666666667 3 4 15 5 4 5 19 6.333333333 5 10 23 7.666666667 6 8 25 8.333333333 7 7 24 8 8 9 28 9.333333333 9 12 35 11.66666667 10 14 41 13.66666667 11 15 nil nil

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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