Using this data: https://www.mediafire.com/file/e9pa1asoo9vtx5f/Performance_Lawn_Equipment_Database_%25281%2529.xlsx/fileAnswer the following questions. An important part of planning manufacturing cap

• Using this data: https://www.mediafire.com/file/e9pa1asoo9vtx5f/Performance_Lawn_Equipment_Database_%25281%2529.xlsx/file
• Answer the following questions.
• An important part of planning manufacturing capacity is having a good forecast of sales. Elizabeth Burke is interested in forecasting sales of mowers and tractors in each marketing region as well as industry sales to assess future changes in market share.

• She also wants to forecast future increases in production costs. Develop forecasting models for these data and prepare a report of your results with appropriate charts and output from Excel.·
• For each graph that is needed to answer the assignment, follow this format

      5.1 Assignment(s) 1 – Statement

o   Identify Business Problem -  

“Define Problem statement [aka Case Analysis Assignment]”

o   Analytics Tools and Models used and results

o   Interpretation, Discussion, and Analysis of Findings and Results – 

Interpretation, Discussion, and Analysis of outcomes and results of Analytics Tools and Models used

§  Tip: Support your Interpretation, Discussion, and Analysis of Results with the numbers you developed in your:

·       Analytics Tools and Models used results

·       Business Analytics Case Analysis EXCEL model(s) and outcomes and results

o   Recommendations

Checklist of documents:

- Word Document with graphs and analysis

- Excel with the graphs that were used on the analysis.