Question: How would I use Excel to solve this problem? Given the following data and seasonal index: MONTH SALES YEAR 1 YEAR 2 Jan 8 8

How would I use Excel to solve this problem? "Given the following data and seasonal index:
MONTH SALES YEAR 1 YEAR 2 Jan 88 Feb 79 Mar 56 Apr 1011 May 912 June 1216 July 1520 Aug 2025 Sept 44 Oct 32 Nov 87 Dec 99
a)compute the seasonal index using only year 1 data and b)determine the deseasonalized demand values using year 2 data and year 1's seasonal indices.
I would like more emphasis on the instruction of solving in Excel so that I understand, not just a cut and paste answer. Thank you.
How would I use Excel to solve this problem?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!