Question: please answer part a and b. New car sales for a dealer in Cook County, Illinois, for the past year are shown in the following

please answer part a and b. New car sales for a
please answer part a and b. New car sales for a
please answer part a and b. New car sales for a
please answer part a and b.
New car sales for a dealer in Cook County, Illinois, for the past year are shown in the following table, along with monthly Indexes (seasonal relatives), which are supplied to the dealer by the regional distributor. Units Units Month Sold Index Month Sold Index Jan. 648 0.70 Jul. 762 0.90 Feb. 658 0.80 Aug 782 1.10 Mar. 643 0.60 Sept. 1.20 Apr. 743 0.94 Oct. 812 1.20 May 748 0.89 Nov. 822 1.20 Jun. 843 1.ee Dec. 782 1.25 812 -- Click here for the Excel Data File b. Deseasonalize car sales. (Round your answers to the nearest whole number.) Dosonsonalized Deseasonalced Month Jan Fob. Mar. Month Jul Aug Sep. Oct Nov. Apr May Jun. Dec A C D D F F G H H 1 Month 2 Jan. 3 Feb. 4 Mar. 5 Apr. 6 May 7 Jun. 8 9 10 11 B Units Sold 648 658 643 743 748 843 Index 0.70 0.80 0.60 0.94 0.89 1.00 Month Jul. Aug. Sept. Oct. Nov. Dec. E Units Sold 762 782 812 812 822 782 Index 0.90 1.10 1.20 1.20 1.20 1.25 e. What action might management consider based on your findings in part b? Advertising and sales promotions because the deasonalized data displays a downward trend Increase inventory because the deasonalized data displays an upward trend

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!