Calculate the monthly usage for each month

Assignment Help Operation Management

Reference no: EM13220824

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

Year 1 2 3 4

Jan 1484 1482 1792 1902
Feb 1394 1400 1586 1722
Mar 1552 1548 1770 1876

April 1796 1864 2110 2218
May 2060 2198 2408 2548
June 2214 2446 2652 2844

July 2330 2580 2606 2972
Aug 2432 2698 2872 3110
Sept 2416 2682 2946 3208

Oct 2262 2592 2906 3200
Nov 1942 2132 2340 2806
Dec 1566 1802 2046 2418

a) Calculate the monthly usage 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: EM13220824

Questions Cloud

What is significant consequence of fractional reserve bank : What is one significant consequence of fractional reserve banking Banks are vulnerable to "panics" or "bank runs." Banks can only lend an amount equal to its deposits. Banks hold a portion of their deposits in gold. Banks can serve the withdrawals..

Describe key elements required to provide proper healthcare : Describe key elements required to provide proper healthcare from financial and operative perspectives, while maintaining focus on disbursements of healthcare services.

Calculate the monthly usage for each month : Forecast the seasonally adjusted usage for pallets for each month in year 5

List the types of potential segmenting dimensions : List the types of potential segmenting dimensions and explain which you would try to apply first, second and third in a particular situation. If the nature of the situation would affect your answer, explain how.

How much will the money supply increase : How much will the money supply increase if the required reserve ratio equals 10 percent and all banks initially have zero excess reserves. and the Fed buys $ million in U.s. Government securities

How the continuing mobility of us consumers : Explain how the continuing mobility of US consumers as well as the development of big metropolitan areas should affect marketing strategy planning in the future. Be sure to consider the impact on the 4 P's.

Identify the team players and their roles : In a summary paragraph, provide a conclusion about what you learned from the article.

User Account

All Pages