Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(Just a question) How do I find the average Seasonal Index for each month? Do I take all of the seasonal indexes from each Month-1

(Just a question) How do I find the average Seasonal Index for each month?

Do I take all of the seasonal indexes from each Month-1 from each year and find the average?

image text in transcribed

Time period Month Demand Yearly average Seasonal Index Average SI Deseasonalized 1/1/17 2374 0.803157607 2/1/17 2572.5 0.87031295 3/1/17 2666.5 0.902114473 4/1/17 2978 1.007499307 5/1/17 3443 1.16481535 6/1/17 3325 1.12489429 7/1/17 1177 0.398195663 8/1/17 2519 0.852213147 9/1/17 2990 1.011559075 10/1/17 3536 1.196278559 11/1/17 3398.5 1.149760374 12/1/17 4490.5 2955.8333 1.519199341 1/1/18 2408 2/1/18 2605.5 3/1/18 2698.5 4/1/18 2965 5/1/18 3577 6/1/18 3462 7/1/18 2611 8/1/18 3027.5 9/1/18 3022.5 10/1/18 3782 11/1/18 4252.5 12/1/18 4977.5 1/1/19 2459 2/1/19 3012.5 3/1/19 3028.5 4/1/19 3405 5/1/19 3696 6/1/19 3907 7/1/19 2973 8/1/19 3285.5 9/1/19 3314.5

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

Between The Lines Of The Balance Sheet The Plain Mans Guide To Published Accounts

Authors: Michael Greener

2nd Edition

0080240712, 9780080240718

More Books

Students also viewed these Accounting questions