Mattel Inc (MAT)
Days of inventory on hand (DOH)
| Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Inventory turnover | 9.04 | 6.31 | 5.05 | 5.20 | 5.62 | 4.81 | 4.43 | 5.23 | 6.37 | 5.64 | 5.74 | 7.19 | 8.33 | 6.25 | 5.95 | 7.97 | 9.19 | 5.05 | 4.93 | 6.04 | |
| DOH | days | 40.38 | 57.86 | 72.25 | 70.24 | 64.91 | 75.86 | 82.31 | 69.77 | 57.33 | 64.72 | 63.61 | 50.76 | 43.79 | 58.42 | 61.36 | 45.79 | 39.73 | 72.24 | 74.10 | 60.40 |
December 31, 2023 calculation
DOH = 365 ÷ Inventory turnover
= 365 ÷ 9.04
= 40.38
The days of inventory on hand (DOH) ratio for Mattel Inc has shown fluctuation over the past 20 quarters. This ratio indicates the number of days it takes for the company to sell its inventory. A lower DOH value suggests efficient inventory management, while a higher value may indicate excess inventory or slow sales.
From the data provided, we observe that the DOH ratio ranged from 39.73 days to 82.31 days over the period. There is variability in the ratio, with certain quarters showing a higher number of days of inventory on hand compared to others.
The trend appears to be somewhat cyclical, with fluctuations occurring periodically. It is important to note that a consistent increase or decrease in DOH may warrant further investigation into the company's inventory management practices.
Overall, a thorough analysis of the reasons behind these fluctuations would provide valuable insights into Mattel Inc's inventory control effectiveness and operational efficiency.