Megatronics manufactures components for use

Reference no: EM131137200

Megatronics manufactures components for use in small electronic products such as computers, CD players, and radios at plants in Belgium, Germany and France. The parts are transported by truck to Hamburg, where they are shipped overseas to customers in Mexico, South America, the United States and the Pacific Rim. The company has to reserve space on ships months and sometimes years in advance. This requires an accurate forecasting model. Following are number of cubic feet of container space the company has used in each of the past 18 months. Develop a linear trend forecast, an exponential forecast (alpha=.40), and a 3 month weighted moving average (with most recent month weighted by 0.4, the next closest month weighted by 0.35 and the final month weighted by 0.25). Indicate which one you believe is the most accurate forecast model and the forecast for month 19 using MAD as the metric for accuracy. You need to complete the problem using manual calculations (not excel add-in or a different software)

Month	Space (1000s ft³)
1	10.6
2	12.7
3	9.8
4	11.3
5	13.6
6	14.4
7	14.2
8	15.4
9	17.6
10	19.2
11	16.3
12	14.7
13	18.2
14	19.6
15	21.4
16	22.8
17	20.6
18	18.7

Reference no: EM131137200

Questions Cloud

What is the future value five years from now of sixty 100 : What is the future value, five years from now, of sixty $100 cash flows using a periodic interest rate of 0.7% compounded monthly? The cash flows are made at the end of each month.

Determine the undrained shear strength and friction angle : Plot the deviatoric stress against axial strain and excess pore water pressure against axial strain.

Correlation matrix of the four independent variables : (c) Find the correlation matrix of the four independent variables. Is there evidence of multi collinearity? (d) Standardize each of the three independent variables x1, x2, and x3, and create a new variable that is the product of the standardized va..

What is the future value ten years from now of ten 1000 : What is the future value, ten years from now, of ten $1,000 cash flows using a periodic interest rate of 8% compounded annually? The cash flows are made at the end of each year.

Megatronics manufactures components for use : Megatronics manufactures components for use in small electronic products such as computers, CD players, and radios at plants in Belgium, Germany and France. The parts are transported by truck to Hamburg, where they are shipped overseas to customer..

What are the most important causes of child death globally : What are the most important causes of child death globally? - Which do YOU think is the absolute most important and why?

Determine the friction angle for each test : If the sand were to be subjected to a vertical effective stress of 300 kPa, what magnitude of horizontal effective stress would cause failure?

Brand of motorcycle purchased : In a survey of 100 people who had recently pur- chased motorcycles, data on the following variables was recorded: Gender of purchaser

What was the impact on subsequent civilizations : Why did the relationship between men and women change after the Agricultural Revolution? What was the impact on subsequent civilizations

User Account

All Pages