Question: 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

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 238 220 195 245 345 380 270
Aug Sep Oct
220 280 120
Nov Dec
110 85
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.2. The four-month moving average forecasts for the May December 2022 period (Show all calculations).
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!