Lesson 5: Accounting for Merchandising Operations and Inventory

Welcome back to your financial accounting journey! In this fifth lesson, we’ll delve deeply into the accounting practices specific to merchandising operations, focusing on inventory management and the calculation of the cost of goods sold (COGS). We’ll cover:

Understanding Merchandising Operations
Inventory Systems: Perpetual vs. Periodic
Recording Purchases and Sales of Inventory
Cost of Goods Sold and Gross Profit Calculations
Inventory Valuation Methods: FIFO, LIFO, Weighted Average
Detailed Examples, Diagrams, Equations, and Anecdotes

Understanding Merchandising Operations

What are Merchandising Operations?

Merchandising companies are businesses that purchase finished goods (merchandise) for the purpose of reselling them to customers at a profit. They act as intermediaries between producers (manufacturers or wholesalers) and consumers.

Examples of Merchandising Companies:

Retailers: Supermarkets, clothing stores, electronics shops.
Wholesalers: Companies that sell goods in bulk to retailers.

Anecdote:

Imagine you’re running a bookstore. You buy books from publishers or distributors and sell them to readers. Your primary activities involve managing inventory (books), purchasing new stock, and selling to customers.

Key Concepts in Merchandising Operations

Inventory: The goods available for sale to customers.
Cost of Goods Sold (COGS): The direct costs of the merchandise sold during a period.
Gross Profit: The profit a company makes after deducting COGS from net sales.
Operating Expenses: Costs incurred in the process of earning sales revenue, excluding COGS.
Net Income: The profit after all expenses have been deducted from revenues.

Equations:

Gross Profit:

[ \text{Gross Profit} = \text{Net Sales} - \text{Cost of Goods Sold} ]

Net Income:

[ \text{Net Income} = \text{Gross Profit} - \text{Operating Expenses} ]

Inventory Systems: Perpetual vs. Periodic

Perpetual Inventory System

Definition:

A system that maintains continuous, real-time records of inventory quantities and costs. The inventory account is updated after each purchase and sale.

Characteristics:

Inventory Records: Detailed records for each inventory item.
COGS Calculation: Updated with each sale transaction.
Technology Usage: Often requires computerized systems with barcode scanners.

Advantages:

Accurate Inventory Levels: Real-time tracking helps prevent stockouts and overstocking.
Improved Decision-Making: Timely data aids in managing inventory effectively.
Theft Detection: Discrepancies can indicate theft or errors.

Disadvantages:

Costly Implementation: Requires investment in technology and systems.
Complexity: More sophisticated accounting knowledge is needed.

Periodic Inventory System

Definition:

An inventory system where updates to the inventory and COGS accounts are made at the end of an accounting period based on a physical count.

Characteristics:

Inventory Records: No detailed continuous records.
COGS Calculation: Determined at period-end using the COGS formula.
Physical Counts: Necessary to determine ending inventory.

Advantages:

Simplicity: Easier to implement and maintain.
Lower Costs: Less need for advanced technology.

Disadvantages:

Less Accurate: Cannot detect inventory shrinkage during the period.
Delayed Information: Inventory data is only accurate at period-end.

Comparison Table

Aspect Perpetual System Periodic System

Inventory Updates Continuous At period-end

COGS Updates After each sale At period-end

Inventory Account Continuously updated Updated at period-end

Technology High Low Requirement

Accuracy High during period Low during period

Cost Higher Lower

Recording Purchases and Sales of Inventory

Under the Perpetual Inventory System

Recording Purchases

When inventory is purchased, the Inventory account is increased.

Example 1: Purchase of Inventory for Cash

Transaction: Purchase $5,000 of inventory with cash.

Journal Entry:

Date Account Debit ($) Credit ($) Titles

[Date] Inventory 5,000

                Cash                                5,000

Recording Sales

Each sale transaction involves two entries:

Recording the Revenue:
- Debit: Cash or Accounts Receivable (if sold on credit)
- Credit: Sales Revenue
Recording the COGS and Reducing Inventory:
- Debit: Cost of Goods Sold
- Credit: Inventory

Example 2: Sale of Inventory for Cash

Transaction: Sold inventory costing $3,000 for $4,500 cash.

Journal Entries:

Record the Revenue:

Date Account Debit ($) Credit ($) Titles

[Date] Cash 4,500

                Sales Revenue                       4,500

Record the COGS and Reduce Inventory:

Date Account Debit ($) Credit ($) Titles

[Date] Cost of Goods 3,000
Sold

                Inventory                           3,000

Mermaid Diagram of Perpetual Inventory Flow:

graph TD

A[Purchase Inventory] —>|Debit| B[Inventory Account]

C[Sell Inventory] —>|Credit| B

C —>|Debit| D[COGS]

Under the Periodic Inventory System

Recording Purchases

Purchases are recorded in a Purchases account, not directly in Inventory.

Example 3: Purchase of Inventory on Account

Transaction: Purchase $5,000 of inventory on account.

Journal Entry:

Date Account Debit ($) Credit ($) Titles

[Date] Purchases 5,000

                Accounts Payable                    5,000

Recording Sales

Only the revenue side is recorded at the time of sale.

Example 4: Sale of Inventory on Credit

Transaction: Sold inventory for $4,500 on account.

Journal Entry:

Date Account Debit ($) Credit ($) Titles

[Date] Accounts 4,500
Receivable

                Sales Revenue                       4,500

At Period-End

Calculating COGS and Updating Inventory:

Perform a Physical Inventory Count to determine ending inventory.
Calculate COGS using the formula.
Adjust Inventory and Purchases Accounts.

Cost of Goods Sold and Gross Profit Calculations

Cost of Goods Sold Calculation

Formula:

\text{Cost of Goods Sold} = \text{Beginning Inventory} + \text{Purchases} - \text{Ending Inventory}

Additional Components:

Purchase Returns and Allowances: Deductions from purchases for returned goods or allowances.
Purchase Discounts: Reductions in purchase cost due to early payment.
Freight-In (Transportation-In): Costs paid to bring inventory to the business.

Adjusted Formula:

\text{Net Purchases} = \text{Purchases} - \text{Purchase Returns and Allowances} - \text{Purchase Discounts} + \text{Freight-In}

\text{COGS} = \text{Beginning Inventory} + \text{Net Purchases} - \text{Ending Inventory}

Example 5: Detailed COGS Calculation

Beginning Inventory: $10,000
Purchases: $25,000
Purchase Returns and Allowances: $2,000
Purchase Discounts: $500
Freight-In: $1,000
Ending Inventory: $8,000

Calculations:

Net Purchases:

\text{Net Purchases} = \$25,000 - \$2,000 - \$500 + \$1,000 = \$23,500

COGS:

\text{COGS} = \$10,000 + \$23,500 - \$8,000 = \$25,500

Gross Profit Calculation

\text{Gross Profit} = \text{Net Sales} - \text{Cost of Goods Sold} ] **Example:** - **Net Sales:** \$40,000 - **COGS:** \$25,500 **Calculation:** [ \text{Gross Profit} = \$40,000 - \$25,500 = \$14,500

Net Income Calculation

\text{Net Income} = \text{Gross Profit} - \text{Operating Expenses}

Assuming Operating Expenses: $7,000

Calculation:

\text{Net Income} = \$14,500 - \$7,000 = \$7,500

Inventory Valuation Methods

The method chosen for inventory valuation can significantly impact financial statements and tax liabilities.

1. First-In, First-Out (FIFO)

Assumption:

The earliest goods purchased are the first ones sold.

Impact:

COGS: Based on older, potentially lower costs.
Ending Inventory: Reflects recent, higher costs.
Net Income: Higher during periods of rising prices.

Advantages:

Ending inventory approximates current replacement costs.
Matches actual physical flow for many businesses.

Disadvantages:

Higher taxes due to higher reported net income during inflation.

2. Last-In, First-Out (LIFO)

Assumption:

The latest goods purchased are the first ones sold.

Impact:

COGS: Based on recent, potentially higher costs.
Ending Inventory: Reflects older, lower costs.
Net Income: Lower during periods of rising prices.

Advantages:

Lower taxes due to lower reported net income during inflation.
Matches current costs with current revenues.

Disadvantages:

Ending inventory may be undervalued.
Not allowed under IFRS (International Financial Reporting Standards).

3. Weighted Average Cost

Assumption:

Inventory and COGS are valued at the average cost of all units available.

Impact:

Smooths out price fluctuations.
COGS and ending inventory values fall between FIFO and LIFO.

Advantages:

Simple to calculate.
Reduces the effect of price volatility.

Disadvantages:

May not match actual physical flow.
Less precise during periods of significant price changes.

Detailed Example to Illustrate Valuation Methods

Inventory Purchases and Sales Data:

Date Units Cost per Unit Total Cost Purchased ($) ($)

Jan 1 100 10 1,000

Jan 15 150 12 1,800

Jan 30 200 14 2,800

Total Units 450 5,600 Purchased

Units Sold: 300 units

Applying FIFO Method

COGS Calculation:

First 100 units at $10: $1,000
Next 150 units at $12: $1,800
Next 50 units at $14: 50 units * $14 = $700
Total COGS: $1,000 + $1,800 + $700 = $3,500

Ending Inventory:

Units Remaining: 150 units (200 units purchased on Jan 30 - 50 units sold)
Cost of Remaining Units: 150 units * $14 = $2,100

Applying LIFO Method

COGS Calculation:

First 200 units at $14: $2,800
Next 100 units at $12: $1,200
Total COGS: $2,800 + $1,200 = $4,000

Ending Inventory:

Units Remaining:
- 50 units at $12 (150 units purchased on Jan 15 - 100 units sold)
- 100 units at $10
Cost of Remaining Units:
- (50 units * $12) + (100 units * $10) = $600 + $1,000 = $1,600

Applying Weighted Average Cost Method

Calculations:

Total Units Available: 450 units
Total Cost of Goods Available for Sale: $5,600
Average Cost per Unit:

\text{Average Cost per Unit} = \frac{\$5,600}{450} \approx \$12.44 ] 4. **COGS:** [ \text{COGS} = 300 \text{ units} \times \$12.44 \approx \$3,732

Ending Inventory:

\text{Ending Inventory} = 150 \text{ units} \times \$12.44 \approx \$1,866

Comparative Summary

Method COGS ($) Ending Gross Profit Inventory ($) ($)*

FIFO 3,500 2,100 $6,500

LIFO 4,000 1,600 $6,000

Weighted 3,732 1,866 $6,268 Average

*Assuming Net Sales of $10,000.

Impact Analysis:

FIFO reports the highest gross profit and ending inventory during rising prices.
LIFO reports the lowest gross profit, which can result in tax savings.
Weighted Average provides results between FIFO and LIFO.

Recording Inventory Transactions Under Different Methods

Perpetual System with FIFO

Example:

Jan 1 Purchase: 100 units at $10
Jan 5 Sale: 80 units
Jan 10 Purchase: 150 units at $12
Jan 15 Sale: 70 units

Journal Entries:

Jan 1 Purchase:
- Debit: Inventory $1,000
- Credit: Cash/Accounts Payable $1,000
Jan 5 Sale:
- Debit: Cash/Accounts Receivable (Sales Price)
- Credit: Sales Revenue
- Debit: COGS (80 units * $10) = $800
- Credit: Inventory $800

Inventory Remaining:

20 units at $10

Jan 10 Purchase:
- Debit: Inventory $1,800
- Credit: Cash/Accounts Payable $1,800
Jan 15 Sale:
- Debit: Cash/Accounts Receivable (Sales Price)
- Credit: Sales Revenue
- COGS Calculation:
  - Sell remaining 20 units at $10: $200
  - Sell 50 units at $12: $600
  - Total COGS: $200 + $600 = $800
- Debit: COGS $800
- Credit: Inventory $800

Perpetual System with LIFO

COGS Calculations change as the latest costs are used:

Jan 5 Sale:
- COGS: 80 units * $10 = $800
Jan 15 Sale:
- COGS: 70 units * $12 = $840

An Anecdote to Illustrate Inventory Methods

Consider a clothing store that stocks jeans. Under FIFO, the store sells the oldest jeans first, ensuring that older styles are sold before they go out of fashion. Under LIFO, it’s as if the store pushes new arrivals to the front and sells them first, leaving older stock unsold. With the Weighted Average method, the store considers all jeans to be of equal cost, blending the cost of old and new inventory.

Mathematical Perspective

The LIFO Reserve

Definition:

The LIFO Reserve is the difference between the inventory reported under LIFO and FIFO. It allows companies to compare inventory and COGS under both methods.

Formula:

\text{LIFO Reserve} = \text{FIFO Inventory Value} - \text{LIFO Inventory Value}

Importance:

Provides transparency for analysts.
Helps in adjusting financial statements for comparison.

Example:

FIFO Ending Inventory: $2,100
LIFO Ending Inventory: $1,600

Calculation:

\text{LIFO Reserve} = \$2,100 - \$1,600 = \$500

Impact on Financial Ratios

Inventory valuation methods affect financial ratios:

Current Ratio (Liquidity):

[ \text{Current Ratio} = \frac{\text{Current Assets}}{\text{Current Liabilities}} ]

Gross Profit Margin:

[ \text{Gross Profit Margin} = \left( \frac{\text{Gross Profit}}{\text{Net Sales}} \right) \times 100% ]

Inventory Turnover Ratio:

[ \text{Inventory Turnover} = \frac{\text{COGS}}{\text{Average Inventory}} ]

Practice Exercises

Exercise 1: Applying FIFO and LIFO Under Perpetual System

Inventory Transactions:

March 1 Purchase: 60 units at $15
March 5 Sale: 40 units
March 10 Purchase: 80 units at $18
March 15 Sale: 50 units

Assuming Sales Price per Unit: $25

Requirement:

Record journal entries under both FIFO and LIFO methods.
Calculate ending inventory.

Solution Outline:

FIFO COGS Calculations:
- March 5 Sale: 40 units at $15 = $600
- March 15 Sale: 20 units at $15 = $300 (remaining from March 1)
  - 30 units at $18 = $540
  - Total COGS for March 15 Sale: $300 + $540 = $840
LIFO COGS Calculations:
- March 5 Sale: 40 units at $15 = $600
- March 15 Sale: 50 units at $18 = $900
Ending Inventory:
- FIFO: Remaining units after sales.
  - From March 10 Purchase: 50 units at $18
  - Ending Inventory: 50 units * $18 = $900
- LIFO: Remaining units after sales.
  - From March 1 Purchase: 20 units at $15
  - From March 10 Purchase: 30 units at $18
  - Ending Inventory: (20 units * $15) + (30 units * $18) = $300 + $540 = $840

Exercise 2: Calculating Gross Profit Under Different Methods

Using the data from Exercise 1 and total sales revenue calculated as follows:

Total Units Sold: 40 units + 50 units = 90 units
Sales Revenue: 90 units * $25 = $2,250

Requirement:

Calculate Gross Profit under FIFO and LIFO.

Solution:

FIFO COGS:
- March 5 Sale: $600
- March 15 Sale: $840
- Total COGS: $600 + $840 = $1,440
FIFO Gross Profit:

[ \text{Gross Profit} = $2,250 - $1,440 = $810 ]

LIFO COGS:
- March 5 Sale: $600
- March 15 Sale: $900
- Total COGS: $600 + $900 = $1,500
LIFO Gross Profit:

[ \text{Gross Profit} = $2,250 - $1,500 = $750 ]

Observation:

FIFO reports higher gross profit due to lower COGS.
LIFO reports lower gross profit due to higher COGS.

Common Mistakes and How to Avoid Them

Misapplying Inventory Valuation Methods:
- Solution: Carefully track the sequence of purchases and sales. Use timelines or charts if necessary.
Ignoring the Impact of Discounts, Returns, and Freight:
- Solution: Always adjust purchases for returns, discounts, and freight-in to determine net purchases.
Confusing Perpetual and Periodic Systems:
- Solution: Remember that in the perpetual system, inventory and COGS are updated continuously, while in the periodic system, adjustments are made at period-end.
Overlooking Tax Implications:
- Solution: Be aware that the choice of inventory method affects taxable income. Companies may prefer LIFO during inflation to reduce taxes.
Incorrectly Calculating Average Cost:
- Solution: Ensure that you include all units and costs in the calculation of the weighted average.

Conclusion

In this lesson, we’ve:

Explored Merchandising Operations, understanding the role of inventory in businesses that sell goods.
Compared Perpetual and Periodic Inventory Systems, learning the differences in recording and tracking inventory.
Practiced Recording Purchases and Sales of Inventory, applying journal entries under both systems.
Calculated Cost of Goods Sold and Gross Profit, using detailed formulas and recognizing their importance in financial statements.
Examined Inventory Valuation Methods (FIFO, LIFO, Weighted Average), analyzing how each method affects COGS, net income, taxes, and inventory valuation.
Engaged with Comprehensive Examples and Exercises, reinforcing our understanding through practical application.

What’s Next?

In the next lesson, we’ll:

Delve into Internal Controls and Managing Cash
- Understanding the Importance of Internal Controls
- Cash Management and Bank Reconciliations
Explore Receivables Accounting
- Accounting for Uncollectible Accounts
- Methods for Estimating Bad Debts
Learn about Notes Receivable and Interest Calculations
Use Examples and Exercises to solidify our understanding

Feel free to review this material, and when you’re ready, just say “Next” to proceed to the sixth lesson!