Simple linear regression to forecast total usage of pallets

Assignment Help Operation Management

Reference no: EM131232337

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: EM131232337

Questions Cloud

Distinguish between a member-managed limited liability : Distinguish between a member-managed limited liability company and a manager-managed limited liability company. Create a table listing the differences between a limited partnership and a limited liability company.

What might be the downside of making decisions : What might be the downside of making decisions based off of cost optimization and branch probabilities? Can you think of an example? (Hint: think VW emissions issues, the Ford Pinto, etc.).

Agreement to alleviate global environmental issues : What is the effectiveness of such global treaties as The Kyoto Agreement to alleviate global environmental issues (global warming, acid rain, and many more)? Should the United States take a more active role in these agreements?

Socialization is typically used in larger corporations : Socialization is typically used in larger corporations. Let’s say you’ve been hired by a smaller company that doesn’t see the value of socializing employees. What would you say to this employer about the value of socializing, no matter what industry ..

Simple linear regression to forecast total usage of pallets : Monthly usage data for pallets used in a distribution center are as follows: Calculate the monthly usage for each month. Use simple linear regression to forecast total usage of pallets for year 5

Many relationship in the entity relationship model : A one to many relationship in the Entity Relationship model is implemented as a __________ in the relational model. Which type of file organization is most efficient with multiple key searches or retrievals?

Marketing-products was in the product life cycle : Marketing - Imagine that you're a product analyst working in a consulting firm. Your job is to evaluate where various products are on the product life cycle curve. Determine where each product is today in its product life cycle. Explain the elements ..

Planning social media research study : ick a brand you are familiar with. This can be a store you shop at often, a product you frequently buy, or a company you trust. Imagine that you are a marketing research assistant for this company and that you are planning a social media research stu..

Medical waste recycling-promotion traditional : What are the products and/or services offered by your Medical Waste Recycling Company and How does your company compare to its Competitor A , Competitior B, and Competitor C by Creating a table for Prices, Buyer Persona, Location, Promotion Tradition..

User Account

All Pages