### Calculate seasonal factors and estimate the forecast

Assignment Help Supply Chain Management
##### Reference no: EM13224959

Consider monthly demand for the ABC Corporation as shown in the table below. With these demand values, estimate a static (non adaptive) linear regression to identify static values of level, trend, and seasonality. To do this you will need to follow these steps we went through in class: de-seasonalize demand, calculate and run the linear regression for the de-seasonalized demand, calculate the seasonal factors, and estimate the forecast that incorporates these seasonal factors into the de-seasonalized regression.

Based on the level, trend, and seasonality values that you calculated and the changes that demand has experienced over time, what would be the simplest adaptive (dynamic) forecasting approach would you suggest ABC should follow to predict future demand as accurately as possible? Please answer this question after presenting your results' table below. Please justify this part of your answer conceptually. You do not need to perform any calculations.

 Monthly Demand for ABC Corporation Sales Year1 Year 2 Year 3 Year 4 Year 5 January 2,000 3,000 2,000 5,000 5,000 February 3,000 4,000 5,000 4,000 2,000 March 3,000 3,000 5,000 4,000 3,000 April 3,000 5,000 3,000 2,000 2,000 May 4,000 5,000 4,000 5,000 7,000 June 6,000 8,000 6,000 7,000 6,000 July 7,000 3,000 7,000 10,000 8,000 August 6,000 8,000 10,000 14,000 10,000 September 10,000 12,000 15,000 16,000 20,000 October 12,000 12,000 15,000 16,000 20,000 November 14,000 16,000 18,000 20,000 22,000 December 8,000 10,000 8,000 12,000 8,000 Total 78,000 89,000 98,000 115,000 113,000

#### Calculate the costs

If each truck trip still costs \$1,000, how does this decision impact total annual costs (TAC) at BMW in relation to the TAC in question 1? As part of your answer, please mak

#### How much safety inventory of cell should retailer carry

The retailer is targeting a CSL of 95 percent and monitors its inventory continuously. How much safety inventory of cell phones should the retailer carry? What should its re

#### Write a paper on the walmart supply chain

Write a paper on the WalMart Supply Chain. You can email it to me when you are done. WalMart has one of the best supply chains in the world and it is one of the main reasons

#### Develop a master production schedule for the breadmaker

Develop a master production schedule for the breadmaker. What do the projected ending inventory and available-to-promise numbers look like? Has Realco "overpromised"? In you

What are the advantages and disadvantages of a manufacturing company owning and operating its own outbound warehouse compared to having a logistics service provider (LSP) pr

#### What disparate treatment means and disparate impact

Please define sexual harrassment. In addition what was discussed in the discussion section of this class related to sexual harrassment and define for the instructor what disp

#### Implementation of the first phase of outsourcing to dhl

What were the key learnings / surprises realized during the implementation of the first phase of outsourcing to DHL and how is the current situation? What roadblocks emerged

#### What does ethics have to do with recruiting

What does ethics have to do with recruiting and please define ethics and what is your opinin on selection processes around the world - what bias do you think you might have an