This means a Q1 report with reference date 31 March 2024 counts backwards from 1 March 2024, as shown in the diagram above. Therefore the amount that must be entered in I 06.08 at month t-3 is the COH on 1 December 2023, etc. However, the values that must be entered on I 06.07 at month t (March 2024) are the weighted averages, taking into account the number of working days in the months for which the moving average is calculated.
Example calculation with figures
Below is a specific example for the K-COH for March 2024. The following fictitious data are relevant:
- I 06.08 (COH, on 1 December 2023): €20,000
- I 06.08 (COH, on 1 November 2023): €30,000
- I 06.08 (COH, on 2 October 2023): €40,000
These months had the following number of working days:
- 19 working days in December 2023 (31 calendar days)
- 22 working days in November 2023 (30 calendar days)
- 22 working days in October 2023 (31 calendar days)
The weighted moving average for month t (March 2024) is calculated as follows: