9 Question 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. Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Space (1000s ft3) 10.6 12.7 9.8 11.3 13.6 14.4 14.2 15.4 17.6 19.2 16.3 14.7 18.2 19.6 21.4 22.8 20.6 18.7 Instruction 1: Forecasting as indicated in the announcement I posted on Module 2 is from your required text book (Introduction to Management Science), the one we used when discussing module 1 topics featuring Linear Programming. Instruction 2: You need to complete the problem using manual calculations (not excel add-in or a different software) employing formulas shown in text and solved examples provided to you this week