Ch3 Forecasting Excel ExerciseCourse: SCML200 | Weight: 5% | Type: Individual | Due: April 30, 2026 at 11:59 PM
In this exercise, you will apply Excel-based forecasting techniques to a real demand dataset. Using the Excel template provided, you are required to:
- Calculate the 3-month and 5-month Simple Moving Average (SMA) forecasts for periods 612
- Calculate the 3-month Weighted Moving Average (WMA) forecast (weights: 0.2, 0.3, 0.5) for periods 612
- Calculate the 5-month Weighted Moving Average (WMA) forecast (weights: 0.1, 0.1, 0.2, 0.2, 0.4) for periods 612
- Calculate the Linear Regression forecast for periods 612 using Excel’s Analysis ToolPak to determine the trend line equation
- Compute MAD and MAPE for each method and identify the most accurate forecasting method
This is an individual assignment. Late submissions will not be accepted unless prior approval is granted. Submit your completed Excel file (.xlsx) only. Files submitted in any other format will not be graded.
Get this or a similar paper done in as fast as 4 hours, 24/7.
NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions
✔Secure Service ✔ Plagiarism Free ✔On-time Delivery
Leave a Reply
You must be logged in to post a comment.