Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 2019

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions