Question: Forecasting Exercise: Using the attached excel template (above ) with actual profits included, you will assume the role of operations manager for the XYZ Manufacturing


Forecasting Exercise: Using the attached excel template (above ) with actual profits included, you will assume the role of operations manager for the XYZ Manufacturing Company. Use the moving average method to forecast/calculate the quarterly average profit and to analyze future cost for the company for the next three years. Once your forecasts are complete, in a memorandum for senior management, detail the following: Describe your naive method approach to forecasting and explain how moving averages are valid. o Describe what your forecasts for the next three years for the XYZ Manufacturing Company show. Include your forecast calculations in an appendix at the end of your memorandum
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
