Question: b. Use the Moving Average forecasting technique with 5 months averaged to determine the forecast for January 2018 for the MS-14001 milling set and the

 b. Use the Moving Average forecasting technique with 5 months averaged
to determine the forecast for January 2018 for the MS-14001 milling set
and the RP-14010 set of 10 dual-sided replacement tips. 472&160 401&163 474&148
483&183 c. Use the Exponential Smoothing forecasting technique with an alpha of
0.5 determine the forecast for January 2018 for the MS-14001 milling set
and the RP-14010 set of 10 dual-sided replacement tips using the December
2017 actual demand. Assume the forecast for December 2017 was 472 for
MS-14001 and 148 for RP-14010. Remember: New Forecast =(a)( Latest Demand )+(1a)
Previous Forecast 416&183 474&148 4738163 474&162 d. Use the Exponential Smoothing forecasting
technique with an alpha of 0.9 determine the forecast for January 2018

b. Use the Moving Average forecasting technique with 5 months averaged to determine the forecast for January 2018 for the MS-14001 milling set and the RP-14010 set of 10 dual-sided replacement tips. 472&160 401&163 474&148 483&183 c. Use the Exponential Smoothing forecasting technique with an alpha of 0.5 determine the forecast for January 2018 for the MS-14001 milling set and the RP-14010 set of 10 dual-sided replacement tips using the December 2017 actual demand. Assume the forecast for December 2017 was 472 for MS-14001 and 148 for RP-14010. Remember: New Forecast =(a)( Latest Demand )+(1a) Previous Forecast 416&183 474&148 4738163 474&162 d. Use the Exponential Smoothing forecasting technique with an alpha of 0.9 determine the forecast for January 2018 for the MS-14001 milling set and the RP-14010 set of 10 dual-sided replacement tips using the December 2017 actual demand. Assume the forecast for December 2017 was 472 for MS-14001 and 148 for RP-14010. 4735172 483&175 401:163 4745148 d. Use the Exponential Smoothing forecasting technique with an alpha of 0.9 determine the forecast for January 2018 for the MS-14001 milling set and the RP-14010 set of 10 dual-sided replacement tips using the December 2017 actual demand. Assume the forecast for December 2017 was 472 for MS-14001 and 148 for RP- 14010 . 473&172 483&175 401&163 474&148 e. Compare the four forecasting techniques from parts a. through d. using MAD, and recommend which technique is most appropriate for forecasting the MS-14001 milling set and for forecasting the RP-14010 set of 10 -dual-sided replacement tips. f. The general economic forecast for 2018 suggests continued weak corporate investment in new capital manufacturing equipment nationally while demand levels for consumer goods will hold steady. From a qualitative standpoint, how does this effect the forecasts for MS-14001 and RP. 14010? g. Using a simple 5% increase over each month's sales in 2017. what are the total expected sales of milling sets for each month in 2018? h. Given that 75% of the customers are expected to remain loyal to the MS-14001 set, what is the anticipated month-by-month 2018 demand? L. Given that 25% of the customers are expected to move to the MS:1501X milling set, what is the anticipated month-by-month 2018 demand? j. Generally, what are three possible issues with these forecasts

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 Finance Questions!