Rockwell Automation Inc (ROK)
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 | 5.24 | 5.40 | 4.92 | 5.15 | 5.17 | 6.15 | 6.39 | 6.69 | 7.01 | 7.29 | 7.57 | 7.70 | 8.04 | 8.97 | 7.94 | 8.66 | 8.71 | 9.29 | 7.50 | 6.88 | |
| DOH | days | 69.60 | 67.60 | 74.22 | 70.88 | 70.59 | 59.31 | 57.11 | 54.52 | 52.06 | 50.09 | 48.24 | 47.39 | 45.40 | 40.68 | 45.95 | 42.15 | 41.91 | 39.30 | 48.68 | 53.05 |
December 31, 2023 calculation
DOH = 365 ÷ Inventory turnover
= 365 ÷ 5.24
= 69.60
To analyze Rockwell Automation Inc's days of inventory on hand (DOH), we calculate the average DOH over the eight quarters provided. The average DOH for the period is 92.43 days.
The DOH has shown some variability over the period, with a noticeable uptrend in the most recent quarters. This suggests that Rockwell Automation Inc may be carrying more inventory on hand in recent quarters compared to earlier periods.
A high DOH can indicate either inefficient inventory management or potential difficulties in selling products. It would be important to further investigate the reasons behind the increase in DOH, as well as to assess its impact on working capital and overall operational efficiency.
Peer comparison
Dec 31, 2023