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: 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 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!