Coca-Cola Consolidated Inc. (COKE)
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 | 18.63 | 18.56 | 17.63 | 17.28 | 16.50 | 18.01 | 18.24 | 19.56 | 17.53 | 21.52 | 21.36 | 19.08 | 21.60 | 23.22 | 22.81 | 21.34 | 21.34 | 20.67 | 20.54 | 21.50 | |
DOH | days | 19.60 | 19.67 | 20.70 | 21.13 | 22.12 | 20.26 | 20.01 | 18.66 | 20.83 | 16.96 | 17.09 | 19.13 | 16.90 | 15.72 | 16.00 | 17.10 | 17.10 | 17.66 | 17.77 | 16.97 |
December 31, 2023 calculation
DOH = 365 ÷ Inventory turnover
= 365 ÷ 18.63
= 19.60
Coca-Cola Consolidated Inc's days of inventory on hand (DOH) has shown a fluctuating trend over the past eight quarters. The latest quarter, Q4 2023, reported a DOH of 28.98 days, slightly higher than the previous quarter's 28.95 days. This indicates that the company is holding inventory for approximately 29 days before it is sold.
Looking further back, Q4 2022 had the highest DOH at 32.34 days, while Q1 2022 had the lowest at 27.37 days. This suggests that the company's inventory management has improved since the beginning of 2022.
Overall, the average DOH over these quarters is approximately 29.68 days, indicating that Coca-Cola Consolidated Inc typically holds inventory for around 30 days before it is converted into sales. It would be beneficial for the company to continue monitoring and optimizing its inventory levels to ensure efficient operations and minimize carrying costs.
Peer comparison
Dec 31, 2023