Question: A linear equation for the trend in demand data was found to be Yr = 1,524 + 5.2X, where X is the number of the

A linear equation for the trend in demand data was found to be Yr = 1,524 + 5.2X, where X is the number of the month as designated in the table that follows.

MONTH MONTH NUMBER Year I Year 2 ACTUAL MONTH ACTUAL DEMAND NUMBER

a. Project the trend values for each month and determine the multiplicative index for each of the 24 months.

b. Determine the additive index for each of the 24 months.

c. Is it obvious whether an additive or multiplicative model is more appropriate?

MONTH MONTH NUMBER Year I Year 2 ACTUAL MONTH ACTUAL DEMAND NUMBER DEMAND January 1 1,419 13 1,495 February 2 1,341 14 1,390 March 3 1,275 15 1,319 April 4 1,353 16 1,420 May 5 1,438 17 1,506 June 6 1,547 18 1,627 July 7 1,688 19 1,719 August 8 1,755 20 1,802 September 9 1,862 21 1,921 October 10 1,782 22 1,851 November 11 1,670 23 1,736 December 12 1,576 24 1,659

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 Operations Management 6th Questions!