Principles of Financial Accounting: Inventory - Inventory Turnover, Ratio and Days in Inventory

What It Is

The Inventory Turnover Ratio and Days in Inventory are key performance indicators (KPIs) used to evaluate a company's inventory management efficiency. The Inventory Turnover Ratio measures how many times a company sells and replaces its inventory within a given period, while Days in Inventory calculates the average number of days it takes to sell and replace inventory. If a company buys $10,000 of inventory and sells $15,000 worth of products within a year, its Inventory Turnover Ratio would be 1.5, indicating that it sells and replaces its inventory 1.5 times within a year.

Key Concepts & Formulas

• Inventory Turnover Ratio (ITR): Measures the number of times inventory is sold and replaced within a given period. ITR = Cost of Goods Sold (COGS) / Average Inventory. Example: If COGS is $100,000 and Average Inventory is $50,000, ITR = $100,000 / $50,000 = 2.
• Days in Inventory (DII): Calculates the average number of days it takes to sell and replace inventory. DII = 365 / ITR. Example: If ITR is 2, DII = 365 / 2 = 182.5 days.
• Cost of Goods Sold (COGS): The direct cost of producing or purchasing inventory. COGS = Beginning Inventory + Purchases - Ending Inventory. Example: If Beginning Inventory is $20,000, Purchases are $80,000, and Ending Inventory is $30,000, COGS = $20,000 + $80,000 - $30,000 = $70,000.
• Average Inventory: The average value of inventory held during a given period. Average Inventory = (Beginning Inventory + Ending Inventory) / 2. Example: If Beginning Inventory is $20,000 and Ending Inventory is $30,000, Average Inventory = ($20,000 + $30,000) / 2 = $25,000.
• Gross Profit: The difference between Sales and COGS. Gross Profit = Sales - COGS. Example: If Sales are $100,000 and COGS is $70,000, Gross Profit = $100,000 - $70,000 = $30,000.
• Inventory Valuation: The process of assigning a monetary value to inventory. Inventory Valuation = Cost of Goods Sold + Beginning Inventory - Ending Inventory. Example: If COGS is $70,000, Beginning Inventory is $20,000, and Ending Inventory is $30,000, Inventory Valuation = $70,000 + $20,000 - $30,000 = $60,000.

Journal Entry Examples

1. Purchasing Inventory: Dr. Inventory $10,000 Cr. Accounts Payable $10,000 Explanation: Debit Inventory to increase its value, and credit Accounts Payable to record the purchase.
2. Selling Inventory: Dr. Cost of Goods Sold $5,000 Cr. Inventory $5,000 Explanation: Debit Cost of Goods Sold to record the expense, and credit Inventory to decrease its value.
3. Inventory Obsolescence: Dr. Cost of Goods Sold $2,000 Cr. Inventory $2,000 Explanation: Debit Cost of Goods Sold to record the expense, and credit Inventory to decrease its value.

Common Mistakes

1. Mistake: Confusing debits and credits for expense accounts. Correction: Remember that debits increase assets and expenses, while credits increase liabilities and equity.
2. Mistake: Not considering the normal balance of an account when making journal entries. Correction: Use the mnemonic "ADE" (Assets, Drawings, Expenses) to remember that debits increase assets and expenses, while credits increase liabilities and equity.
3. Mistake: Not adjusting for inventory obsolescence. Correction: Record the obsolescence as a debit to Cost of Goods Sold and a credit to Inventory.

Exam Tips

1. Tip: Be careful when using the Inventory Turnover Ratio, as it can be affected by changes in inventory valuation methods.
2. Tip: Remember that Days in Inventory is calculated using the Inventory Turnover Ratio, so be sure to calculate ITR correctly.
3. Tip: When journalizing inventory transactions, be sure to consider the normal balance of each account.

Quick Practice

1. Problem: A company has Beginning Inventory of $20,000, Purchases of $80,000, and Ending Inventory of $30,000. What is the Cost of Goods Sold? Answer: $70,000 (COGS = Beginning Inventory + Purchases - Ending Inventory) Explanation: Calculate COGS using the formula.
2. Problem: A company has an Inventory Turnover Ratio of 2 and a Cost of Goods Sold of $100,000. What is the Average Inventory? Answer: $50,000 (Average Inventory = COGS / ITR) Explanation: Calculate Average Inventory using the formula.
3. Problem: A company has Beginning Inventory of $20,000, Purchases of $80,000, and Ending Inventory of $30,000. What is the Inventory Valuation? Answer: $60,000 (Inventory Valuation = COGS + Beginning Inventory - Ending Inventory) Explanation: Calculate Inventory Valuation using the formula.

Last-Minute Cram Sheet

1. Inventory Turnover Ratio (ITR) = Cost of Goods Sold (COGS) / Average Inventory.
2. Days in Inventory (DII) = 365 / ITR.
3. Cost of Goods Sold (COGS) = Beginning Inventory + Purchases - Ending Inventory.
4. Average Inventory = (Beginning Inventory + Ending Inventory) / 2.
5. Gross Profit = Sales - COGS.
6. Inventory Valuation = COGS + Beginning Inventory - Ending Inventory.
7. Dividends are NOT an expense – they go directly to retained earnings.
8. Inventory obsolescence is recorded as a debit to Cost of Goods Sold and a credit to Inventory.
9. The normal balance of an account affects journal entries – remember "ADE" (Assets, Drawings, Expenses).
10. Be careful when using the Inventory Turnover Ratio, as it can be affected by changes in inventory valuation methods.