Calculate the monthly usage index for each month

Assignment Help Operation Management

Reference no: EM13897034

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.

Reference no: EM13897034

Questions Cloud

Supply recover based on breach of express contract : Comfort Company assumed the operation of a hotel. The previous owner had a contract with Linen Supply. Linen Supply continued to furnish services after Comfort Company assumed ownership. Can Linen Supply recover based on breach of an express contract..

Koto corporation began the month of june : Koto Corporation began the month of June with $ 300,000 of current assets, a current ratio of 2.5:1, and an acid test ratio of 1.4:1.

General equilibrium-contract curve for initial allocation : Bert has an initial endowment of 10 units of food and 10 units of clothing. Ernie’s initial endowment consists of 10 units of food and 20 units of clothing. Represent these initial endowments in an Edge worth Box. Describe the set of allocations that..

Write an essay on judicial activism : Write an essay on (or discuss) judicial activism. Present the arguments on both sides of the question as to whether judges should interpret or simply apply the Constitution. Provide more current examples (the current Supreme Court docket) and predict..

Calculate the monthly usage index for each month : Calculate 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.

Describe digital logic circuit on behavioral and gate level : describe digital logic circuit on behavioral and gate level;

What is the nash equilibrium-equilibria of game : Consider Bertrand competition with homogeneous products. Two firms, 1 and 2, produce an identical product and compete by choosing price. Consumers buy from the firm with the lower price. Write out the best response function of firm 1 for any price th..

Does negotiated rulemaking result in better regulations : Does negotiated rulemaking result in better regulations and is it perceived as more valid by the interested parties? Why is it a better process than regulations generated through traditional notices and comment rulemaking?

Substantial budget deficit : The United States Federal Government has been running a substantial budget deficit since the 1970s and national savings levels have been steadily falling. Given this, can you explain why investment has remained positive and has been growing steadily ..

User Account

All Pages