Update: The original post contained a data error.
In the interest of digging deeper into the semiconductor oversupply issues, this post continues a series of data gathering on important ratios for companies in the industry. Hopefully the process will provide insight toward the companies better (or worse) positioned to take advantage of the next upturn or weather the downturn.

Yesterday I used Zacks Research Wizard to get the recent Cost of Goods Sold (COGS) and Inventory levels for semiconductor industry participants over the last several quarters. I made some modest limitations on the share volume and market cap, but still ended up with more than 50 names. I used trailing twelve month COGS and the average of the last five quarters (for a beginning, ending and average) of inventory to calculate Days Sales in Inventory.

Higher inventory levels relative to sales indicates a greater likelihood that the company will need to reduce prices, reduce production or take a write-off, all of which would reduce gross profit margin. In this post I compare the current DSI to the DSI in the same quarter one year ago. This should mitigate any seasonal effects, such as ramping inventory ahead of holiday sales, that might distort sequential comparisons.

The companies with the biggest increase in DSI may have the most trouble in the event of an industry downdraft. Even if semiconductor sales remain strong they will need demand to catch up with their current capacity and may not see as much benefit as other manufacturers. The five companies with the largest year/year DSI increase are Silicon Labs SLAB, Applied Micro (AMCC), Zoran (ZRAN), Monolithic Power (MPWR) and Triquint (TQNT).

The companies with the greatest reduction in DSI, by contrast, may be poised for margin expansion as they replenish inventory levels and ramp up production to meet demand. The five companies with the biggest decrease in DSI are Large Cap Watch List (Track at Marketocracy) member MEMC Electronics (WFR), Advanced Micro Devices (AMD - Annual Report), Atheros (ATHR), Conexant (CNXT) and Intersil (ISIL).

The complete list follows.

DSI As Percentage of DSI One Year Ago:

Disclosure: William Trent has a long position in SMH.

Update: The original post contained a data error.
In the interest of digging deeper into the semiconductor oversupply issues, this post will begin a series of data gathering on important ratios for companies in the industry. Hopefully the process will provide insight toward the companies better (or worse) positioned to take advantage of the next upturn or weather the downturn.

Today I used Zacks Research Wizard to get the recent Cost of Goods Sold (COGS) and Inventory levels for semiconductor industry participants over the last several quarters. I made some modest limitations on the share volume and market cap, but still ended up with more than 50 names. I used trailing twelve month COGS and the average of the last five quarters (for a beginning, ending and average) of inventory to calculate Days Sales in Inventory.

The higher the inventory levels, the more likely the company will need to reduce prices, reduce production or take a write-off, all of which would reduce gross profit margin. This first pass looks merely at inventory levels and does not consider strategy or other factors. For example, a fabless company would likely own less inventory than a company that produces chips at its own facilities. In a later post I will consider the trends in inventory (although the historic data I provide below gives some of it away) to determine the companies for which inventory levels are higher than the historic norm for that particular company.

The five companies with the highest levels of inventory relative to their recent sales levels are: Microsemi (MSCC), Lattice (LSCC), Analog Devices (ADI), Micrel (MCRL) and Intersil (ISIL).

The five with the lowest levels of inventory relative to recent sales are: Amkor Tech (AMKR); Smart Modular (SMOD), Large Cap Watch List (Track at Marketocracy) member MEMC Electronics (WFR); Actions (ACTS) and Sirf Technology (SIRF).

The complete list follows.

Disclosure: William Trent has a long position in SMH.