Question: Monthly usage data for pallets used in a distribution center are as follows:Problem 12.12 Year Month Monthly Usage (in pallets) 1: January 1484 February 1394
Monthly usage data for pallets used in a distribution center are as follows:Problem 12.12 Year Month Monthly Usage (in pallets) 1: January 1484 February 1394 March 1552 April 1796 May 2060 June 2214 July 2330 August 2432 September 2416 October 2262 November 1942 December 1566 2: January 1482 February 1400 March 1548 April 1864 May 2198 June 2446 July 2580 August 2698 September 2682 October 2592 November 2132 December 1802 3: January 1792 February 1586 March 1770 April 2110 May 2408 June 2652 July 2606 August 2872 September 2946 October 2906 November 2340 December 20464 January 1902 February 1722 March 1876 April 2218 May 2548 June 2844 July 2972 August 3110 September 3208 October 3200 November 2806 December 2418Calculate the monthly usage index for each month.Use simple linear regression to forecast total usage of pallets for year 5.Forecast the seasonally adjusted usage for pallets for each month in year 5.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
