Question: 2 . Develop a seasonally adjusted forecast model for these order data. Forecast demand for each quarter for year 6 ( using a linear trend

2.
Develop a seasonally adjusted forecast model for these order data. Forecast demand for each quarter for year 6(using a linear trend line forecast estimate for orders in year 6).
a. Develop a separate linear trend line forecast for each of the four seasons and forecast each season for year 6.
b. Which of the two approaches used in (a) and (b) appears to be the more accurate? Use MAD to verify your selection.
3.
Bell Inc. is a computer company that gets most of its component parts from suppliers in Southeast Asia, who ship to small warehouses called revolvers(for revolving inventory) near Bells main assembly plants near Fort Worth, Texas. Bell withdraws inventory for these warehouses every few hours, and most of Bells suppliers deliver to their revolvers every 3 or 4 days. One particular sup- plier provides most of the workings for the Bell Intrepid laptop, including the screen and keyboard, and the hard drive and mother board plus a few other parts are added at the assembly plant. These revolvers allow Bell to carry little of its own inventory by pushing it down to its suppliers. However, the supplier also wants to minimize its inventory, and one way it can do that is to develop an accurate demand forecast. Following is the suppliers demand data (units) from Bell for the past 24 months:
Closely observe the demand data and develop a forecast model for year 3 that you believe will be accurate.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!