Question: QUESTION 4 ( 2 0 Marks ) Based on the information provided below, answer the following questions. The demand planner at Radasys Enterprises ( RE
QUESTION Marks Based on the information provided below, answer the following questions. The demand planner at Radasys Enterprises RE is dedicated to enhancing forecasting precision to better align inventory management with market demand. To this end, he is undertaking a comparative analysis of two candidate forecasting techniques: the Simple Exponential Smoothing method and the Moving Average method. This evaluation aims to determine which method delivers superior accuracy, thereby supporting improved inventory management, optimising resource allocation, and enhancing overall operational efficiency. The sales data presented in the table below was extracted from REs database for the evaluation exercise. Year Quarter Sales, R Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q REQUIRED: Discuss any three strategic importance of demand forecasting in supply chain and operations management. MarksUsing the quarterly sales data extracted by the demand planner, prepare the quarter movingaverage QMA forecast for each of the fourteen quarters spanning from Q to Q Ensure that your calculations are clearly presented in a table, with all forecast values displayed. MarksUsing the quarterly sales data extracted by the demand planner, prepare the simple exponential smoothing SES forecast for each of the sixteen quarters spanning from Q to Q Assume that the forecast for Q is R and use a smoothing constant a of Ensure that your calculations are clearly presented in a table, with all forecast values displayed. MarksCalculate the Mean Absolute Percentage Error MAPE for both the QMA and SES forecasts over the thirteen quarters from Q to Q Show the detailed calculations for obtaining the MAPE values and round off answers to two decimal places. MarksBased on the results obtained in question which of the candidate forecasting methods should be selected by the demand planner?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
