Chapter 7 Inventories 133
LECTURE AID—Financial Ratios Related to Inventories
Inventory turnover measures efficiency in managing inventories by comparing a company’s average
inventory to the total inventory sold. The formula is as follows:
Inventory Cost of Merchandise Sold
Turnover = Average Inventory
In effect, this ratio measures how many times during a year a company purchased and sold its average
inventory balance. For example, if a company usually carries an average of $100 in inventory and its sales
were $800 during a year, that company sold (or turned over) its average inventory eight times.
The ratio uses average inventory instead of the ending balance in the inventory account in order to smooth
out any seasonal fluctuations in inventory balances. In determining this average, it is ideal to average
inventory balances at the end of each month for a year. However, in many cases, monthly data are not
available, so the beginning and end of the year inventory amounts are averaged.
Average Beginning Inventory + Ending Inventory
Inventory = 2
The number of days’ sales in inventory estimates the time (in days) it takes to acquire, sell, and replace
inventory. The formula for the number of days’ sales in inventory is as follows:
Number of Days’ Sales Inventory, end of year
in Inventory = Average Daily Cost of Merchandise Sold
where:
Average Daily Cost of Cost of Merchandise Sold
Merchandise Sold = 365
Point out that businesses generally work to reduce the amount of inventory they carry. Holding inventory
creates many costs, such as costs to store, insure, and move inventory items. These costs can be
dramatically reduced by lowering inventory levels. Therefore, increases in the inventory turnover ratio
and decreases in the number of days’ sales in inventory are usually viewed as favorable trends.
DEMONSTRATION PROBLEM—Inventory Ratios
Use the following data to calculate inventory turnover and number of days’ sales in inventory:
Cost of Merchandise Sold $456,250
Inventory, Beginning of Year 65,000
Inventory, End of Year 67,500