Question
As a demand planner at grootegeluk mine,you want to determine the monthly sales forecast of coal(in tonnes).table 1.below, depicts the volume of coal sold by
As a demand planner at grootegeluk mine,you want to determine the monthly sales forecast of coal(in tonnes).table 1.below, depicts the volume of coal sold by the mine for each of the 12 months of 2022 january 21 feb 23 marc 34 april37 may 40 jun 51 july 54 august50 sep 48 oct 36 nov 39 dec 42 Using the data provided in table 1 answer the following questions 5.1 using the three months month weighted average method,calculate the monthly forecast for april 2022 to January 2023 by assigning weights of 0.1,0,3 and 0,6 (the oldest data to the most recent data,respectively 5.2 calculate the mean absolute deviation (MAD) of the forecast for april 2022 to December 2022 5.3 calculate the mean absolute percentage error(MAPE)of the forecast for april 2022 to December 2022
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started