a. A manufacturing firm manufactures electric motors. The sales during the last four months (starting from the first month) has been: 96, 75, 89, and 68 units. The forecast for the first month was 80 units. Using the exponential smoothing method with a = .70, predict the next month's sales. Calculate the mean absolute percent deviation for this data and comment on the performance of the forecasting method. b. Using the rule lot size=multiple of 50, determine the planned order releases for each week in the following MRP record. The lead time is 2 weeks.

a. A manufacturing firm manufactures electric motors. The sales during the last four months (starting from the first month) has been: 96, 75, 89, and 68 units. The forecast for the first month was 80 units. Using the exponential smoothing method with a = .70, predict the next month's sales. Calculate the mean absolute percent deviation for this data and comment on the performance of the forecasting method. b. Using the rule lot size=multiple of 50, determine the planned order releases for each week in the following MRP record. The lead time is 2 weeks.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Please do not give solution in image format thanku
1. Which of the following is indicative of the season of heaviest demand when seasonality is measured on a quarterly basis? a. Seasonal index = .75 b. Seasonal index = 1.0 c. Seasonal index = 1.25 d. Seasonal index = 3.1 Answer: 2. The forecast calculated at the end of period t for period t+k is always the same for any value of k if the time series has systematic variability. A) True B) False
2. An operation specialist used two forecast methods to forecast demand for a certain word processing software package. Actual demand and his corresponding predictions are shown below: Month Sales Forecast A Forecast B January 60 February 25 60 March 54 50 42 April 36 30 55 May 45 45 35 June 60 20 Which forecast method would you recommend if using MAD as the accuracy measurement? Select one: a. Forecast A b. Forecast B c. No preference.
A. Find the tracking signal for each month. B. Does the model provide acceptable answers!
2)Auto sales over a 4-month period were forecasted as follows: 89, 98, 105, and 97. The actual results over the 4-month period were as follows: 92, 96, 101, and 100. What was the MAD of the 4-month forecast? (use an excel sheet to make all calaculations and show formulas used in excel)
A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives areSR1 = .90, SR2 = .95, SR3 = 1.05, and SR4 = 1.10. The trend equation is: Ft= 10 + 5t. Over thepast nine quarters, demand has been as follows:Period, t 1 2 3 4 5 6 7 8 9Demand 14 20 24 31 31 37 43 48 52Is the forecast performing adequately? Explain.
1. Discuss the differences between Qualitative and Quantitative forecasting models. How do Associative and Time Series techniques differ? 2. What is the Mean Absolute Deviation (MAD)? 3. Use the following set of data to calculate the Mean Absolute Deviation (MAD) for the following set of data. Actual (A:) Forecast (Ft) Forecast Error Absolute (Deviation) Month Forecast Eror January February March 45 45 42 50 34 45 April 48 40 Мay 38 45 MAD =
1
4. The sales (in millions of dollars) for an 18-month period are as follows. Month Sales Month Sales 1 600 600 775 10 775 3 600 11 600 4 650 12 575 700 13 625 800 14 650 550 15 600 8 775 a. Compare a three-month moving average forecast with an exponential smoothing forecast. Use a = 0.1. Which provides the better forecasts based on MSE? b. Find the forecast for the next month using the best forecast method. 2.
The sale of cycles in a shop in three consecutive months are given as 70, 68 and 82 units respectively. Exponential smoothing method with a smoothing constant of 0.4 is used in forecasting. Assume the forecast for the first month is 70 units. The expected number of sales (round off to the nearest whole number) in the 4thmonth is: a. 66 units. b. 71 units. c. 76 units. d. 81 units.
Use exponential smoothing with trend adjustment to forecast demand for period 11. Let α = 0.5, � = 0.3, and let the initial trend value be 12 and the initial forecast be 200
Please do not give solution in image format thanku