Lumen Technologies Inc (LUMN)

Inventory turnover

		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
Cost of revenue (ttm)	US$ in thousands	25,990,000	28,649,000	28,852,000	20,476,000	20,796,000	14,638,000	14,795,000	15,013,000	15,464,000	21,381,000	21,904,000	22,275,000	22,491,000	12,976,000	13,353,000	13,666,000	27,035,000	27,029,000	27,297,000	27,830,000
Inventory	US$ in thousands	209,000	227,000	205,000	223,000	236,000	179,000	151,000	128,000	96,000	103,000	114,000	100,000	105,000	112,000	122,000	119,000	105,000	137,000	151,000	154,000
Inventory turnover		124.35	126.21	140.74	91.82	88.12	81.78	97.98	117.29	161.08	207.58	192.14	222.75	214.20	115.86	109.45	114.84	257.48	197.29	180.77	180.71

December 31, 2023 calculation

Inventory turnover = Cost of revenue (ttm) ÷ Inventory
= $25,990,000K ÷ $209,000K
= 124.35

Lumen Technologies Inc's inventory turnover has shown a fluctuating trend over the past eight quarters. The company's inventory turnover ratio ranged from 31.86 to 65.13 during this period, indicating varying efficiency in managing and selling its inventory. Q2 and Q3 of 2022 demonstrated the highest inventory turnover ratios of 54.83 and 65.13, respectively, reflecting a rapid conversion of inventory into sales, possibly due to effective inventory management practices or strong demand for their products. However, the ratio dropped in subsequent quarters, with Q4 2023 reporting the lowest turnover ratio of 34.18. This decline may suggest challenges in managing inventory levels or slower sales during that period. Overall, monitoring Lumen Technologies Inc's inventory turnover can provide insights into its operational efficiency and effectiveness in utilizing its inventory resources.