What is the method to obtain a running total per month for a given sales data set, and how can the three-month moving average of total sales be calculated?

Question

Accepted Answer

Running total per month can be obtained by summing the sales data for each month. Three-month moving average can be calculated by averaging the total sales for the current month and the two previous months.

To obtain a running total per month, sum the sales data for each month.
To calculate the three-month moving average of total sales, average the total sales for the current month and the two previous months.
Example: Running total for January = Sales in January, Three-month moving average for February = (Sales in February + Sales in January + Sales in December) / 3

Asked in XimKart

What is the method to obtain a running total per month for a given sales data set, and how can the three-month moving average of total sales be calculated?

Interview Questions Asked to Production Analyst at Other Companies