Unlike the method in the lecture, in the methods below you will find different estimation

methods that do not take into account the stochasticity in demand forecasting. The tables in the

Case article $($Canyon Bicycles.pdf$)$ will also help you in your solutions.

$1.$ What would be the demand forecast, total demand forecast and net profit for each

cycling model using the Judgmental Forecasting method?

Note: You can find the demand forecasts of the experts for $2014$ in Table $2$ in the article

$($FC$1$ in the table shows the demand forecast of Mr Arnold, the CEO of the company$).$

$2013$ demand forecasts and realisations are given in Table $1.$

$2.$ If the average of the demand forecasts of the whole group was used as the forecast for

the next year $($Means $($Average$)$ Forecasting$),$ what would be the demand forecast and

total demand forecast and net profit for each cycling model?

$3.$ The average growth rate of the company for the last $4$ years is $23\%.$ What would be the

demand forecast, total demand forecast and net profit for each cycling model when

demand forecasting is done with Means $($Average$)$ Forecasting $+$ Growth Rate approach?

$4.$ What would be the demand forecasts and net profit if the growth rate of $2013,$ which is

$17\%,$ was used as the growth rate in Question$-3?$

$5.$ The proportions of the models in the total demand in $2013$ are given in the table below.

What would be the total demand, the demand forecast for each bicycle model and the

net profit if the total demand forecast was made for each bicycle model considering the

ratios of the previous year, using a Top$-$Down approach for demand forecasting? You can

use your forecast in Question$-3$ as the total demand forecast for $2014.$

Grand Canyon $\%5\mathrm{.}4$

Nerve $\%15\mathrm{.}2$

Yellowstone $\%23\mathrm{.}4$

Strive $\%16\mathrm{.}6$

Speedmax $\%5\mathrm{.}1$

Roadlite $\%10\mathrm{.}3$

Ultimate $\%5\mathrm{.}1$

Endurance $\%19\mathrm{.}1$

$2$

$6.$ What would be the demand forecast, total demand forecast and net profit for each

cycling model if demand forecasting was performed with the Adjusted Mean Forecasting

$($L$0)$ demand approach using the A$/$F ratio of the group's average demand at Level$-0$

$($Note: A$/$F ratio at Level$-0=1\mathrm{.}162)?$

$7.$ What would be the demand forecast, total demand forecast and net profit for each

cycling model if demand forecasting was performed with the Adjusted Mean Forecasting

$($L$1)$ demand approach using the A$/$F ratios of the average demand of the group at Level$-$

$1($Note: A$/$F ratio at Level$-1,$ MTB $=1\mathrm{.}162$ and RB $=1\mathrm{.}079)?$

$8.$ What would be the demand forecast, total demand forecast and net profit for each

cycling model if the group's average demand was forecasted with the Adjusted Mean

Forecasting $($L$2)$ demand approach using the A$/$F ratios at Level$-2($Note: A$/$F ratios at

Level$-2,$ MTB$\_$AL $=1\mathrm{.}324,$ MTB$\_$CF $=1\mathrm{.}165,$ RB$\_$AL $=1\mathrm{.}277,$ and RB$\_$CF $=0\mathrm{.}880)?$

$9.$ You can find the tables and results of the methods that take into account the stochasticity of the

forecasts proposed in the Case in the APPENDICES. $($Figure$-2$ gives the details of the calculations

made in the class using the A$/$F ratio at Level$-0,$ while Figure$-3$ and Figure$-4$ give the summary

results of all the approaches we have made in the class that take into account the stochasticity$).$

If you compare the results of the methods you used above with the methods that take into

account the randomness proposed in Case based on $2014$ realisations, you can see that the

methods

$($consider total demand, realised demand, stockout cost and net profit$).$

Note: When we forecast demand with the above methods, our order quantity for production

will be equal to our demand forecast. Since we do not use the "Newsboy Model" as in the

method we discussed in class $($since we do not consider randomness in the forecast$),$ the order

quantity is equal to the demand forecast.