Case: Redstone Foods M&M Wholesale Case Study

Sales Forecasting

This exercise provides you the opportunity to apply several concepts you have learned in Module #$3$ in addition to Excel skills practice.

Learning Objectives:

$$ Identify trends and patterns by analyzing data in an Excel line graph

$$ Compare and contrast the performance and accuracy of five sales forecasting models through forecast accuracy analysis

$$ Develop conclusions and a forecasting recommendation for a case study issue

$$ Compute the labor productivity impact due to a demand shock significantly lowering demand below the forecast and make a recommendation on how to address

$$ Create a chart in Excel and insert the chart in a Word document

$$ Create a well$-$written, professional, grammatically correct leadership report

Required Materials:

$$ Redstone Foods M&M Wholesale Case Study $($Word document$)$

$$ Redstone Foods M&M Wholesale Data File $($Excel document$)$

$$ Microsoft Excel