Collegium Pharmaceutical Inc (COLL)

Days of inventory on hand (DOH)

		Dec 31, 2024	Sep 30, 2024	Jun 30, 2024	Mar 31, 2024	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
Inventory turnover		7.15	5.93	7.88	7.25	7.44	7.77	10.65	8.71	5.47	3.14	2.16	1.61	7.26	7.46	6.52	8.05	8.34	8.59	8.67	11.40
DOH	days	51.08	61.54	46.34	50.36	49.05	46.95	34.28	41.90	66.71	116.07	169.10	226.10	50.29	48.91	55.97	45.33	43.78	42.49	42.12	32.01

December 31, 2024 calculation

DOH = 365 ÷ Inventory turnover
= 365 ÷ 7.15
= 51.08

Collegium Pharmaceutical Inc's days of inventory on hand (DOH) has experienced fluctuations over the reported periods. The trend shows an increase in the DOH from March 31, 2020, to June 30, 2020, and a further increase to September 30, 2020. This trend continued with slight variations until June 30, 2021, where the DOH peaked at 55.97 days.

Subsequently, there was a decline in DOH by September 30, 2021, but it increased again on December 31, 2021. A significant spike in DOH was observed on March 31, 2022, reaching 226.10 days, followed by a substantial decrease by June 30, 2022. The DOH continued to decrease until reaching the lowest point on June 30, 2023, at 34.28 days.

From June 30, 2023, there was an increasing trend in the DOH, reaching a peak on September 30, 2024, at 61.54 days. However, there was a subsequent decline by December 31, 2024.

Overall, fluctuations in the DOH suggest variability in Collegium Pharmaceutical Inc's inventory management efficiency over the reporting periods. It is essential for the company to analyze the reasons behind these fluctuations and implement strategies to optimize inventory levels for better operational performance.