Question: Study the information provided below and answer the following questions. INFORMATION Radasys Digicommerce Inc. ( RDI ) is an e - commerce enterprise specialising in

Study the information provided below and answer the following questions. INFORMATION Radasys Digicommerce Inc. (RDI) is an e-commerce enterprise specialising in consumer electronics. Presently, the sales department at RDI utilises the Three-Quarter-Moving-Average Method (3QMAM) to forecast demand for one of its flagship products, an AI-driven gadget. The newly appointed Chief Demand Planner at RDI, tasked with driving innovation and enhancing forecasting accuracy, suspects that regression modelling may offer a superior alternative. Consequently, he plans to conduct a comparative analysis to assess the relative forecasting accuracy between the 3QMAM and regression analysis methodologies. As an operations analyst at RDI, you have been assigned this task. The following sales data for the gadget is available: Year Quarter Sales (units)2020 Q11800 Q22100 Q31400 Q425002021 Q11300 Q21500 Q31200 Q420002022 Q11600 Q21800 Q31100 Q422002023 Q12000 Q22300 Q31600 Q43000 REQUIRED: 4.1. Using the 3QMAM, calculate the gadgets quarterly sales forecasts for the period 2020Q4 to 2024Q1.(4 marks)4.2. Conduct a simple regression analysis to determine the trend equation of the sales and use it to estimate the number of units of the gadget expected to be sold throughout the fiscal year 2024. Assume that Q1 of 2020 is 1, Q2 of 2020 is 2, etc. Present all details of the calculations. (8 marks)4.3. Evaluate the relative forecasting accuracies of the 3QMAM and the regression analysis for the period from 2020Q4 to 2023Q4 using the Mean Absolute Percentage Error (MAPE) method. (4 marks)4.4. Summarise the findings derived from the assessment conducted in 4.3.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!