I need answer in MS excle and also I wanted see the formula used to solve the pr

Question

I need answer in MS excle and also I wanted see the formula used to solve the problem. You may use solver in Excel if need.

Weekly demand at Hot Pizza are as follows Week Demand Week Demand Week Demand 108 112 102 116 19 118 96 92 124 102 91 Estimate demand for the next 4 weeks using 1 A4-week moving average 2 Simple exponential smoothing using alpha 0.1 3 Holt's Model, alpha 0.05, beta 0.1 4 In each case (ie. 1 3 above), evaluate MAD, MAPE, MSE, BIAS, TS and the standard deviasion of forecast error 5 Which method you prefer? Why? Answers should be provided in tab "Results Comparisons" Note: If any information is missing, make an assumption, solve the problems and submit a solution. sults in tab "Results Comparison" for the metrics listed Provide your solutions in the worksheet name as "Solution" & compare ret

Explanation / Answer

Using 4 week moving average:

Week Demand 1 108 2 116 3 118 4 124 4 week moving average formula for ith week = average(week= i-4,week = i-3,week=i-2,week=i-1) 5 96 6 119 7 96 8 102 9 112 10 102 11 92 12 91 13 99.25 14 96.0625 15 94.57813 16 95.22266

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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