Answered step by step
Verified Expert Solution
Question
1 Approved Answer
14 15 Q1 A product has a consistent year round demand. You are the planner and have been tasked with 16 experimenting with some time
14 15 Q1 A product has a consistent year round demand. You are the planner and have been tasked with 16 experimenting with some time series analysis. Using this previous weekly demand, calculate the 17 following forecasts for each period possible. A) Two - Period Simple moving average B) 3 Period 18 Weighted moving average using weights of .6, .3,.1, C) Four-period weighted moving average 19 with weights of .4,.3,.2,.1 and D) Exponential Smoothing forecast using an Alpha of .15 and a 20 Week 1 forecast of 2000 units. Round all forecasts to whole numbers. 21 22 Week Demand SMA WMA WMA EXP Sm .15 23 2240 2 Period .6, .3, .1 .4,.3,.2,.1 2000 24 2 2360 25 3 2208 26 4 2415 27 5 2395 28 6 2155 29 7 2190 30 8 2288 31 9 2390 32 10 2405 33 11 2305 34 12 2210
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started