17. Following tables are created in order to generate forecasts using weighted moving average andsimple moving average for the sales amount of a certain product group at an electronics company.a) Show the expression to calculate the missing forecasts from each forecasting technique.(Weighted moving average parameters are n=3 and w+1:0.4, We-2-0.3; W=0.3; smoothingfactor(alfa) for exponential smoothing is 0.3)1 Exponential Smooting TablePeriod12342 Weighted Average ForecastsPeriod1234Actual335246279263MADActual335246279263Forecast193,0205,3229,2?Forecast293,2304,7272,1?Error141,940,649,75?Error41,8-58,76,9?b) Show the expression to calculate mean absolute deviation (MAD) for the forecasting results ofthese two techniques separately.ΣActual - Forecastn

wt-1 = 0.4 wt-2 = 0.3 wt-3 = 0.3 n= 3 alfa = 0.3

Answered: a) Show the expression to calculate the…

Contemporary Marketing

18th Edition

ISBN:9780357033777

Author:Louis E. Boone, David L. Kurtz

Publisher:Louis E. Boone, David L. Kurtz

Chapter14: Pricing Strategies

Section14.2: Forecasting Demand

Problem 1LO

See similar textbooks

Similar questions

Under what conditions might a firm use multiple forecasting methods?
20- Forecasting is very important in predicting the future sales of a company. Can you identify the wrong statement about forecasting from the options below? a. Short range forecasts are less accurate than long range forecasts b. The underlying casual system will remain same in the future c. Forecast for group of items is accurate than individual item d. Forecasts are rarely perfect
a. Using the following, forecast the sales for the months up to January the following year:-i. A simple three month moving average.ii. A three period weighted moving average using weights of 1, 2 and 3. Assign the highest weight to the most recent data. iii. Exponential Smoothing when α= .6 and the forecast for March is 350.iv. Determine which of the three forecasting technique is the most accurate using MAD.
QUESTION 5 Choose the answer with the best match. Elements of a Good Forecast, Meaningful: The benefits should outweigh the costs It should work consistently The degree of accuracy of the forecast should be stated The forecasting horizon must cover the time necessary to implement possible changes so that its results can be used The units measured should be useful to those using the forecast QUESTION 6 There are two main approaches to forecasting. Choose the best two: Quantitative, Consumer Judgmental, Quantitative Sales force, Judgmental Historical, Consumer Expert, Executive QUESTION 7 Describe the following: Andon Maintaining equipment in good condition Maintaining a workplace that is clean System for moving work to the next station as it is completed System of lights used at each workstation to…
Forecasting Forecasting is important relative to capacity requirements planning. What are some of the merits of using judgment methods (i.e., qualitative data) in contrast to quantitative forecasting methods. Which methods are considered to be superior or more accurate, and in what forecast situations would require judgment methods? In what situations would require a quantitative approach to forecasting?
Justify exponential smoothing's superiority to moving averages as a forecasting method.
17. Statistical and observational methods, where adequate data or settings are available in which to apply them, are superior to survey methods of forecasting. Select one O True O False
Give typed answer Question: Use an exponential smoothing model with a =.4 to forecast issues remediated for periods 6-10. (Assume a beginning forecast of 320 for period 5). 1. Forecast Period 6 (August) : ? 2. Forecast Period 7 (September) : ? 3. Forecast Period 8 (October) : ? 4. Forecast Period 9 (November) : ? 5. Forecast Period 10 (December) : ?
Explain the trade-off between responsiveness and stability in a forecasting system that uses time-series data. Who needs to be involved in preparing forecasts? 3. How has technology had an impact on forecasting? What capability would an organization have to have to not need forecasts? Give three examples of unethical conduct involving forecasting and the ethical principle each violates
Daily high temperatures in St. Louis for the lastweek were as follows: 93, 94, 93, 95, 96, 88, 90 (yesterday).a) Forecast the high temperature today, using a 3-day movingaverage.b) Forecast the high temperature today, using a 2-day movingaverage.c) Calculate the mean absolute deviation based on a 2-daymoving average.d) Compute the mean squared error for the 2-day movingaverage.e) Calculate the mean absolute percent error for the 2-daymoving average.
Forecasting is critical in modern times. Business organizations manifested more concern with anticipating the future, and as a consequence, a number of highly successful consulting firms emerged to provide forecasting help for governments and businesses. You are required: iii. Identify the different levels that forecasting of business trends takes place. iv. Give 3 examples where long-range forecasting can be used v. Do you think forecasting is always correct and accurate? Discuss this assertion in detail
ABC Company manufacture passenger cars for Malaysian customers. The sales volume is shown in Table 1. Table 1: The sales volume Period (Month) Sales Volume of Passenger Cars 1 8000 2 9500 3 7000 4 6500 5 8100 6 8600 7 9000 8 7800 9 7600 a) Based on Table 1, calculate forecast volume using and 5 periods-moving average. b) Based on Table 1, calculate forecast volume using exponential smoothing with α = 0.6. c) Evaluate which forecasting method is better between 5 periods- moving average and exponential smoothing with α = 0.6.

SEE MORE QUESTIONS

Recommended textbooks for you

Contemporary Marketing

Marketing

ISBN:

9780357033777

Author:

Louis E. Boone, David L. Kurtz

Publisher:

Cengage Learning

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

Contemporary Marketing

Marketing

ISBN:

9780357033777

Author:

Louis E. Boone, David L. Kurtz

Publisher:

Cengage Learning

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

SEE MORE TEXTBOOKS

a) Show the expression to calculate the missing forecasts from each forecasting technique. ompany. (Weighted moving average parameters are n=3 and W₁1:0.4, We-2-0.3; Wea=0.3; smoothing factor(alfa) for exponential smoothing is 0.3)