By completing the analysis exercise in this case study, students will

Develop proficiency in performing detailed descriptive analysis of historical demand data ning Exce

Matter to use Excel to apply time series forecasting methods

Learn to extract strategic insights from the demand analysis and forecasting results

Case Background

Dairyfresh inc. was established in the early $1980$s in Ontario, Canada, born from a small family run dairy farm. The company initially focused on producing high$-$quality milk and cheese, serving local communities. Their commitment to freshness and quality quickly rapidly attracted a loyal customer base in the $1990$s$,$ DairyFresh inc. began expanding its operations. They diversified their product line to include a wider range of dairy products like yogurt, butter, and cream. This period and marked their first steps outside Ontario, as they started distributing to neighboring provinces Recognizing the need to modermae in early $2000.$ DairyFresh Inc invested in technology to improve their production and supply chain processes. This included advanced refrigeration tentems for better product freshness and a computerized supply chain management system to enance atribution afficiency. The $2010$ saw DairyFresh inc. shifting towards sustainable practices. They adopted eco$-$friendly packaging and waste reduction techniques. The company alestated colaborating with local farmers to source ethically produced milk, stigning with growing comeness and demand for sustainability in recent years, DairyFresh inc has broadened manet each me Western Canada, establishing a strong presence in British in Onsane and Quebec. Currently, DairyFresh's market share $10\%$ Ontario, in Quebec and in British Columbia. They are expecting to these share in Oncane and Quebec in $2025$ and increase their share in BC to $6\%$

$2021$ now and Amy as the Supply Chain Analyst for the Milk category at Dairyfresh