Formula for Inventory Turnover in Excel

Average inventory is used instead of ending inventory because many companies’ merchandise fluctuates greatly throughout the year. For instance, a company might purchase a large quantity of merchandise January 1 and sell that for the rest of the year. Sales have to match inventory purchases otherwise the inventory will not turn effectively. That’s why the … Leer más