How to Track Inventory Trends in Excel. Tracking inventory trends helps you determine a quantity that's vital to your business's success: the amount to order for each of your products.

For example, let’s compare the inventory turnover ratios for Ford (F) and General Motors (GM) using Excel. For the fiscal period ending Dec. 31, 2020, Ford had an inventory of $9.99 billion and ...

When the current inventory dips below (or is equal to) the reorder amount, Excel highlights that cell. With a quick glance, you can determine which items to order.