Question: 5 (20 Marks) Study the information provided below and answer the following questions. The Table below shows the number of Cinco 160W solar panels sold

5 (20 Marks) Study the information provided below and answer the following questions. The Table below shows the number of Cinco 160W solar panels sold monthly by Mfeka Enterprises during the 2022 financial year. Table: Monthly Sales Data of Solar Panels Monthly sales (units) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 238 220 195 245 345 380 270 220 280 120 110 85 REQUIRED: Based on the number of the solar panels sold over the 12 months shown above, compute the following: 5.1. The three-month moving average forecasts for the April December 2022 period (Show all calculations). (5 marks) 5.2. The four-month moving average forecasts for the May December 2022 period (Show all calculations). (5 marks) 5.3. By calculating the mean absolute percentage errors (MAPE) of the three-month moving average forecasts and the four-month moving average forecasts, comment of the comparative forecasting accuracies of the two moving average methods (Show all calculations)

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!