20) Given the following gasoline data: Quarter Year 1 Year 2 1 150 156 2 140 148

Question

20) Given the following gasoline data: Quarter Year 1 Year 2 1 150 156 2 140 148 3 185 201 4 160 174 (a) Compute the seasonal index for each quarter. (b) Suppose we expect year 3 to have annual demand of 800. What is the forecast value for each quarter in year 3? 20) Given the following gasoline data: Quarter Year 1 Year 2 1 150 156 2 140 148 3 185 201 4 160 174 (a) Compute the seasonal index for each quarter. (b) Suppose we expect year 3 to have annual demand of 800. What is the forecast value for each quarter in year 3? 20) Given the following gasoline data: Quarter Year 1 Year 2 1 150 156 2 140 148 3 185 201 4 160 174 (a) Compute the seasonal index for each quarter. (b) Suppose we expect year 3 to have annual demand of 800. What is the forecast value for each quarter in year 3?

Explanation / Answer

so i have calculate the seasonal index here in the last column

(b) Here in year 3 annual demand is 800 so forecast value for each quarter

Quarter I = (800/400) * 93.15 = 186.30

Quarter II = (800/400) * 87.67 = 175.35

Quarter III = (800/400) * 117.50 = 235.00

Quarter IV = (800/400) * 101.67= 203.35

Year 1 Year2 Average Quarter Quarter Index Q1 150 156 153 93.15 Q2 140 148 144 87.67 Q3 185 201 193 117.50 Q4 160 174 167 101.67 Average Year 158.75 169.75 average for all year 164.25

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

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