Present your answers as a $3-$page $($maximum$)$ report explaining what you did and why. Your answer can be in the following format $($it is not necessary that you stick to this format. There are no marks on a specific format$)$:

a$)$ Section $1$: A summary of the problem.

b$)$ Section $2$: Your approach to solving the problem.

a$.$ Example: For Question a$)$ we$..........$

For Question b$)$ we $.........$

c$)$ Section $3$: The steps you did and the results you found.

In this section write the answers to the questions.

d$)$ Section $4$: Conclusion

$$ You must include the excel file that you worked on as a separate attachment. Thus, your submission should have two files $$ a word file with the report and the excel file that you worked on$.$

$$ The case study will be graded out of $100.$ I will use the following criteria for marking.

$1)$ Correctness of approach.

$2)$ Clarity of writing and your explanation.

$3)$ Correctness of the answers.

$$ Do not forget to attach a cover page with your team members names. This page is outside the $3-$page limit$.$

$$ You may attach an appendix if you want. This is not counted in the $3-$page limit$.$

$$ Do not hesitate to ask me for any clarifications.

Case Study

ABC corporation located near Toronto manufacturers a specific souvenir item $($product X$)$ for tourists and sells it to different shops located at tourist destinations in Ontario. Off late, they are having issues with erroneous forecasting. The management needs to decide on the forecast of the item for $2024.$ The demand for the product for every month since January $2018$ to December $2023$ are given. Examine the data and choose an appropriate method of forecasting the demand for $2024$ from the following:

$$ Trend adjusted exponential smoothing $($alpha $=0\mathrm{.}3$; beta$=\mathrm{.}4)$

$$ Seasonal forecasting using seasonal relatives $($Assume that annual demand in $2024$ will be $10\%$ more than that of $2023)$

Note: Trend adjusted exponential smoothing is a $$one$-$step$-$ahead$$ forecast.

a$)$ Using the appropriate method from the above, forecast the demand of the product for all months of the year $2024.$ Explain which method you chose and why.

b$)1\%$ error in forecasting costs ABC corporation $$500.$ How much do you think your forecast is expected to cost them in $2024($this might be approximate and not exact$)?$

c$)$ Each unit of the product X for ABC corporation needs $1$ unit of a specific raw material from a supplier. Over the years since $2018,$ they have followed an ordering policy of equal amount of order every quarter $($assume that they predicted yearly demand accurately$).$ Given the following information about setup and holding costs, find how much they could have saved by ordering the EOQ every year from $2018$ till $2023$:

a$.$ Setup costs $($S$)=$ $$200$ per order in $2018$ and increased by $5\%$ on $1$st January every year

b$.$ Holding costs $($H$)=$ $$5$ per item in $2018$ and increased by $10\%$ on $1$st January every year.

d$)$ In $2023,$ ABC Corporation introduced two new products $$ Y and Z$.$ Assuming expected demand for Y and Z were $2000$ and $3000$ and the unit profit margins for products X$,$ Y$,$ Z are $$12,$ $$14$ and $$15$ respectively, what was the optimal number of each product $($X$,$ Y and Z$)$ that ABC corporation produced? They did not want to produce more than the demand and the budget for producing all the products was $$19000.$ Production cost for each unit of X$,$ Y and Z were $$2,$ $$3$ and $$1$ respectively.