Calculate the monthly usage index for each month use simple


Monthly usage data for pallets used in a distribution center are as follows:

Year

1

2

3

4

January

1484

1482

1792

1902

February

1394

1400

1586

1722

March

1552

1548

1770

1876

April

1796

1864

2110

2218

May

2060

2198

2408

2548

June

2214

2446

2652

2844

July

2330

2580

2606

2972

August

2432

2698

2872

3110

September

2416

2682

2946

3208

October

2262

2592

2906

3200

November

1942

2132

2340

2806

December

1566

1802

2046

2418

a. Calculate the monthly usage index for each month.

b. Use simple linear regression to forecast total usage of pallets for year 5.

c. Forecast the seasonally adjusted usage for pallets for each month in year 5.

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Calculate the monthly usage index for each month use simple
Reference No:- TGS01190229

Expected delivery within 24 Hours