Question: Questions to Guide Analysis: 1 . Conduct a comprehensive descriptive analysis of the historical demand data for skim milk, milk 1 % , and milk
Questions to Guide Analysis: Conduct a comprehensive descriptive analysis of the historical demand data for skim milk,milk and milk over the last years using Excel. Implement tools such as pivottables charts, and trend lines to visualize and analyze the data. What key insights andpatterns emerge from this analysis regarding consumer preferences and demandfluctuations Use Excel to apply time series modelling techniques, evaluate each forecasting technique,and develop forecasts based on a proper timeseries model. You should forecast theneeded capacity for shipping Milk Milk and Skim milk products in for Ontario,British Columbia and Quebec Considering Amy's estimation of the capacity needed for each region, recommend whichcarriers DairyFresh Inc. should select for the upcoming year. Justify your choice byevaluating how well each carrier aligns with the forecasted regional demands.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
