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