Jan$-23$ Quebec Milk $2\%29472$

Jan$-23$ Quebec Skim milk $1990$

Jan$-23$ Quebec Milk $1\%7965$

Jan$-23$ Ontario Milk $2\%42512$

Jan$-23$ Ontario Skim milk $3100$

Jan$-23$ Ontario Milk $1\%11216$

Jan$-23$ British Columbia Milk $2\%13646$

Jan$-23$ British Columbia Skim milk $1395$

Jan$-23$ British Columbia Milk $1\%3623$

Feb$-23$ Quebec Milk $2\%26722$

Feb$-23$ Quebec Skim milk $2100$

Feb$-23$ Quebec Milk $1\%8150$

Feb$-23$ Ontario Milk $2\%38216$

Feb$-23$ Ontario Skim milk $2556$

Feb$-23$ Ontario Milk $1\%9138$

Feb$-23$ British Columbia Milk $2\%11147$

Feb$-23$ British Columbia Skim milk $1149$

Feb$-23$ British Columbia Milk $1\%2898$

Mar$-23$ Quebec Milk $2\%26044$

Mar$-23$ Quebec Skim milk $1966$

Mar$-23$ Quebec Milk $1\%7857$

Mar$-23$ Ontario Milk $2\%40909$

Mar$-23$ Ontario Skim milk $2892$

Mar$-23$ Ontario Milk $1\%10449$

Mar$-23$ British Columbia Milk $2\%10966$

Mar$-23$ British Columbia Skim milk $1127$

Mar$-23$ British Columbia Milk $1\%2845$

Apr$-23$ Quebec Milk $2\%25854$

Apr$-23$ Quebec Skim milk $2529$

Apr$-23$ Quebec Milk $1\%7862$

Apr$-23$ Ontario Milk $2\%40036$

Apr$-23$ Ontario Skim milk $2691$

Apr$-23$ Ontario Milk $1\%10083$

Apr$-23$ British Columbia Milk $2\%13840$

Apr$-23$ British Columbia Skim milk $1399$

Apr$-23$ British Columbia Milk $1\%3599$

May$-23$ Quebec Milk $2\%25798$

May$-23$ Quebec Skim milk $1874$

May$-23$ Quebec Milk $1\%7333$

May$-23$ Ontario Milk $2\%38412$

May$-23$ Ontario Skim milk $2764$

May$-23$ Ontario Milk $1\%9729$

May$-23$ British Columbia Milk $2\%10805$

May$-23$ British Columbia Skim milk $1113$

May$-23$ British Columbia Milk $1\%2790$

Jun$-23$ Quebec Milk $2\%26335$

Jun$-23$ Quebec Skim milk $1831$

Jun$-23$ Quebec Milk $1\%7286$

Jun$-23$ Ontario Milk $2\%36674$

Jun$-23$ Ontario Skim milk $2543$

Jun$-23$ Ontario Milk $1\%9218$

Jun$-23$ British Columbia Milk $2\%11188$

Jun$-23$ British Columbia Skim milk $1151$

Jun$-23$ British Columbia Milk $1\%2831$

Jul$-23$ Quebec Milk $2\%27586$

Jul$-23$ Quebec Skim milk $1892$

Jul$-23$ Quebec Milk $1\%7488$

Jul$-23$ Ontario Milk $2\%39749$

Jul$-23$ Ontario Skim milk $2698$

Jul$-23$ Ontario Milk $1\%9661$

Jul$-23$ British Columbia Milk $2\%13527$

Jul$-23$ British Columbia Skim milk $1348$

Jul$-23$ British Columbia Milk $1\%3426$

Aug$-23$ Quebec Milk $2\%25632$

Aug$-23$ Quebec Skim milk $1732$

Aug$-23$ Quebec Milk $1\%6927$

Aug$-23$ Ontario Milk $2\%36962$

Aug$-23$ Ontario Skim milk $2534$

Aug$-23$ Ontario Milk $1\%9602$

Aug$-23$ British Columbia Milk $2\%10878$

Aug$-23$ British Columbia Skim milk $1062$

Aug$-23$ British Columbia Milk $1\%2750$

Sep$-23$ Quebec Milk $2\%26141$

Sep$-23$ Quebec Skim milk $1907$

Sep$-23$ Quebec Milk $1\%7229$

Sep$-23$ Ontario Milk $2\%38902$

Sep$-23$ Ontario Skim milk $2518$

Sep$-23$ Ontario Milk $1\%9398$

Sep$-23$ British Columbia Milk $2\%11285$

Sep$-23$ British Columbia Skim milk $1099$

Sep$-23$ British Columbia Milk $1\%2778$

$1.$ Conduct a comprehensive descriptive analysis of the historical demand data for skim milk,

milk $1\%,$ and milk $2\%$ over the last $10$ years using Excel. Implement tools such as pivot

tables, charts, and trend lines to visualize and analyze the data. What key insights and

patterns emerge from this analysis regarding consumer preferences and demand

fluctuations?

$2.$ Use Excel to apply time series modelling techniques, evaluate each forecasting technique,

and develop forecasts based on a proper time$-$series model. $($You should forecast the

needed capacity for shipping Milk $1\%,$ Milk $2\%$ and Skim milk products in $2023$ for Ontario,

British Columbia and Quebec$)$

$3.$ Considering Amy's estimation of the capacity needed for each region, recommend which

carrier$($s$)$ DairyFresh Inc. should select for the upcoming year. Justify your choice

evaluating how well each carrier aligns with the forecasted regional demands.

Carrier Name Capacity$$in Ontario$($kL$)$Guaranteed$$Capacity for Amy$$in Ontario $($kL$)$Capacity$$in BC$($kL$)$Guaranteed$$Capacity for Amy$$in BC $($kL$)$Capacity in$$Quebec$($kL$)$Guaranteed$$Capacity for Amy$$in Quebec $($kL$)$Northern Transit $60003000120060026001300$Maple Logistics $58002900110055025001250$Quick Dairy Move $200010009004501500750$Eco Carrier$$Solutions$35001750110055020001000$Fresh Milk$$Transport$300015008004001800900$