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 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? Use Excel to apply time series modelling techniques, evaluate each forecasting technique, and develop forecasts based on a proper timeseries model. You should forecast the needed 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 which carriers DairyFresh Inc. should select for the upcoming year. Justify your choice by evaluating 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
