Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Show work. No excel The ABC company produces a specific chemical materials needed for painting of car manufacturing. Demand for the ABC products in the
Show work. No excel
The ABC company produces a specific chemical materials needed for painting of car manufacturing. Demand for the ABC products in the last 5 years is shown in table given below, in pounds. Make a forecast for next year using the following demand of last 5 years. Also, provide some information as which method is more accurate, using MAD. 1. Nave model (for quarter I of year 2020), 2. 3-Period moving average (for quarter I of year 2020), 3. 3-period weighted moving average with weight 0.10, 0.25, 0.65, (for quarter I of year 2020), 4. Exponential smoothing with alpha=0.10, (for quarter of year 2020), 5. Using linear regression give forecast for 4 quarters of year 2020, Year 2015 2016 2017 1 Quarter Demand 1 2250.00 II 1737.00 III 2412.00 IV 7269.00 1 3514.00 II 2143.00 III 3459.00 IV 7056.00 4120.00 II 2766.00 2556.00 IV 8253.00 I 5491.00 11 4382.00 4315.00 IV 12035.00 I 5648.00 II 3696.00 4843.00 IV 13097.00 2018 2019 The ABC company produces a specific chemical materials needed for painting of car manufacturing. Demand for the ABC products in the last 5 years is shown in table given below, in pounds. Make a forecast for next year using the following demand of last 5 years. Also, provide some information as which method is more accurate, using MAD. 1. Nave model (for quarter I of year 2020), 2. 3-Period moving average (for quarter I of year 2020), 3. 3-period weighted moving average with weight 0.10, 0.25, 0.65, (for quarter I of year 2020), 4. Exponential smoothing with alpha=0.10, (for quarter of year 2020), 5. Using linear regression give forecast for 4 quarters of year 2020, Year 2015 2016 2017 1 Quarter Demand 1 2250.00 II 1737.00 III 2412.00 IV 7269.00 1 3514.00 II 2143.00 III 3459.00 IV 7056.00 4120.00 II 2766.00 2556.00 IV 8253.00 I 5491.00 11 4382.00 4315.00 IV 12035.00 I 5648.00 II 3696.00 4843.00 IV 13097.00 2018 2019Step 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