• Home
  • Textbooks
  • Integral Logistics Management: Operations and Supply Chain Management Within and Across Companies,
  • Demand and Demand Forecast

Integral Logistics Management: Operations and Supply Chain Management Within and Across Companies,

Paul Schönsleben, Steven R. Schmid, Bo O. Jacobson

Chapter 9

Demand and Demand Forecast - all with Video Answers

Educators


Chapter Questions

Problem 1

Choice of Appropriate Forecasting Techniques

Figure 9.8.1.1 shows historical demand curves for four different products. What forecasting technique for each product do you propose to apply to forecast future demand?
(GRAPH CANT COPY)

Check back soon!
01:16

Problem 2

Moving Average Forecasting Technique

The person in your firm responsible for forecasting has been absent for three months, so your supervisor asks you to forecast the demand of the most important product. The information you get is a table (see Figure 9.8.2.1) showing the historical data on the demand for the product (January to October) and the forecast for the period January to July based on the moving average forecasting technique.
$$
\begin{array}{|l|l|l|l|l|l|l|l|l|l|l|}
\hline & \text { Jan. } & \text { Feb. } & \text { Mar. } & \text { Apr. } & \text { May. } & \text { Jun. } & \text { July. } & \text { Aug. } & \text { Sept. } & \text { Oct. } \\
\hline \text { Demand } & 151 & 135 & 143 & 207 & 199 & 175 & 111 & 95 & 119 & 191 \\
\hline \text { Forecast } & 183 & 195 & 177 & 155 & 159 & 171 & 181 & & & \\
\hline
\end{array}
$$
Moreover, your supervisor asks you to:
a. Forecast the demand just as your colleague does. Therefore, you have to calculate the parameter $\mathrm{n}$ from the historical forecast data.
b. Calculate the forecast for August, September, and October as well as for the following month, November.
c. Compute the standard deviation $\sigma$ of the forecast from January to October and decide if the applied technique fits this product.

Nick Johnson
Nick Johnson
Numerade Educator

Problem 3

First-Order Exponential Smoothing

When you report to your supervisor that the moving average forecasting technique is not suitable for the product, he remembers that your colleague in charge of forecasting had been working on introducing the first-order exponential smoothing technique for this product. Therefore, your supervisor gives you the information in Figure 9.8.3.1, showing the demand for the product (January to October) and the forecast using the first-order exponential smoothing technique with $\alpha=0.3$ of the product (January to July).
$$
\begin{array}{|l|c|c|c|c|c|c|c|c|c|c|}
\hline & \text { Jan. } & \text { Feb. } & \text { Mar. } & \text { Apr. } & \text { May. } & \text { Jun. } & \text { July. } & \text { Aug. } & \text { Sept. } & \text { Oct. } \\
\hline \text { Demand } & 151 & 135 & 143 & 207 & 199 & 175 & 111 & 95 & 119 & 191 \\
\hline \text { Forecast } & 187 & 176 & 164 & 158 & 172 & 180 & 179 & & & \\
\hline
\end{array}
$$
To evaluate your supervisor's suggestion, you execute the following steps:
a. Compute the forecast for August, September, and October and for the following month, November.
b. Calculate the mean absolute deviation (MAD) for November assuming $\operatorname{MAD}(\operatorname{Jan})=18$ and the smoothing parameter $\alpha$.
c. In the preceding exercise, could you have obtained a result comparable to the one for the parameter $\alpha$ calculated above by changing $\mathrm{n}$, that is, the number of observed values?
d. Decide whether the chosen first-order exponential smoothing technique with parameter $\alpha$ calculated above is appropriate for this product.
e. What can you say in general about the choice of $\alpha$ depending on the product life cycle?

Check back soon!
01:01

Problem 4

Moving Average Forecast versus First-Order Exponential Smoothing Forecast

Figure 9.2.2.6 showed the effect of different values of the smoothing constant $\alpha$. Figure 9.5.1.1 shows the necessary relationship between the number of observed values and the smoothing constant $\alpha$. You can view the comparison, implemented with Flash animation, on the Internet at URL:
www.intlogman.lim.ethz.ch/demand_forecasting.html
In the red section at the top of the web page, you can choose different values for the smoothing constant $\alpha$. In the lower, green section you can choose either a different value for the smoothing constant $\alpha$ for comparison with the red curve or choose the number of values for the moving average forecast and compare the results of the technique with exponential smoothing (the red curve). Clicking on the "calculate" icon executes your input choice.

Adriano Chikande
Adriano Chikande
Numerade Educator