Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Month Demand Yearly average Seasonal Index Average SI Deseasonalized Time period 1/1/2019 2422 0.8226 0.7817 3098.40 2/1/2019 2564 0.8708 0.8020 3196.99 W N 3/1/2019 3080

image text in transcribedimage text in transcribedimage text in transcribed
image text in transcribedimage text in transcribedimage text in transcribed
Month Demand Yearly average Seasonal Index Average SI Deseasonalized Time period 1/1/2019 2422 0.8226 0.7817 3098.40 2/1/2019 2564 0.8708 0.8020 3196.99 W N 3/1/2019 3080 1.0460 0.8793 3502.77 4/1/2019 3004 1.0202 0.9846 3050.91 5/1/2019 2595 0.8813 0.9926 2614.41 6/1/2019 3654 1.2410 1.1140 3280.09 7/1/2019 2725 0.9255 0.8306 3280.69 8/1/2019 2383 0.8093 0.8672 2747.87 9/1/2019 2432 0.8260 0.8803 2762.68 9 10/1/2019 2744 0.9319 1.0535 2604.64 10 11/1/2019 3600 1.2227 1.2843 2803.03 11 12/1/2019 4130 2944.42 1.4027 1.5298 2699.63 12 1/1/2020 2634 0.7794 0.7817 3369.60 13 2/1/2020 2508 0.7421 0.8020 3127.17 14 3/1/2020 2653 0.7850 0.8793 3017.16 15 4/1/2020 3270 0.9676 0.9846 3321.06 16 5/1/2020 3770 1.1155 0.9926 3798.21 17 6/1/2020 3588 1.0617 1.1140 3220.85 18 7/1/2020 2658 0.7865 0.8306 3200.03 19 8/1/2020 3065 0.9069 0.8672 3534.30 20 9/1/2020 3095 0.9158 0.8803 3515.82 2110/1/2020 3634 1.0753 1.0535 3449.44 22 11/1/2020 4350 1.2871 1.2843 3387.00 23 12/1/2020 5330 3379.583333 1.5771 1.5298 3484.02 24 1/1/2021 2810 0.7431 0.7817 3594.75 25 2/1/2021 2999 0.7931 0.8020 3739.39 26 3/1/2021 3051 0.8069 0.8793 3469.79 27 4/1/2021 3653 0.9661 0.9846 3710.05 28 5/1/2021 3709 0.9809 0.9926 3736.75 29 6/1/2021 3930 1.0393 1.1140 3527.85 30 7/1/2021 2949 0.7799 0.8306 3550.37 31 8/1/2021 3348 0.8854 0.8672 3860.63 32 9/1/2021 3400 0.8992 0.8803 3862.29 33 10/1/2021 4361 1.1533 1.0535 4139.52 34 11/1/2021 5079 1.3432 1.2843 3954.61 35 12/1/2021 6087 3781.33 1.6097 1.5298 3978.85 36Total 3 year deseasonalized Highest yearly average Highest Average SI demand 3781.33 1.5298 121191.63 Average 3 year deseasonalized Total 3 year demand demand 121264 3366.43 Average 3 year demand 3368.44

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

Recommended Textbook for

Leading and Collaborating in the Competitive World

Authors: Thomas S Bateman, Scott A Snell, Robert Konopaske

13th edition

1259927644, 1259927645, 978-1260194241

Students also viewed these Mathematics questions

Question

Prove that for all complex numbers z1, z2, and z3, z1z2 = z2z1

Answered: 1 week ago

Question

6. How can hidden knowledge guide our actions?

Answered: 1 week ago