Inventory Reporting and Analysis Notes
Introduction to Inventory Reporting and Analysis
- Inventory is classified as a current asset on the balance sheet, typically less liquid than cash or receivables.
- Valuation of inventory is done at the lower of cost and market value.
Types of Inventory
- Goods Purchased for Resale: Products bought for the purpose of selling them.
- Raw Materials: Basic materials used to produce goods.
- Work-in-Process: Items that are in various stages of production but are not yet finished.
- Finished Goods: Completed products ready for sale.
- Other Inventory: Any additional types of inventory pertinent to the industry.
Physical Inventory Count
- Regardless of using a periodic or perpetual inventory system, a physical inventory count is necessary at the end of the accounting period.
- This practice helps determine:
- The accuracy of the perpetual inventory system if it is in place.
- Any shrinkage due to theft, spoilage, or other factors.
Determining Ownership of Inventory
- Goods in transit at the end of the reporting period complicate ownership determination.
- FOB (Free on Board) Concepts:
- FOB Shipping Point: The buyer assumes ownership as soon as the goods are shipped.
- FOB Destination: The seller retains ownership until the goods reach the buyer's location.
- Consigned goods belong to the owner and not the holder, and items taken home on approval remain the property of the seller.
Inventory Systems
- Periodic System:
- Uses temporary accounts for purchases, freight, etc.
- Does not track Cost of Goods Sold (COGS) in real-time.
- Ending inventory determined strictly from a physical count.
- Perpetual System:
- Keeps an up-to-date inventory account for all transactions.
- Maintains a continuous balance in the COGS account.
- Adjustments are made based on physical counts, ensuring accuracy throughout the period.
Cost Determination Methods
- After counting inventory, unit costs must be allocated to calculate total inventory costs.
- Cost determination methods include:
- Specific Identification (SI): Used when each inventory item is identifiable (applies mainly in perpetual systems).
- First In First Out (FIFO): Assumes the first items purchased are the first sold; consistent ending inventory across all systems.
- Last In First Out (LIFO): Not permitted under Cdn GAAP standards.
- Average (Weighted Average): Uses a recalculated average cost after each purchase for recording COGS and ending inventory.
Choice of Cost Determination Method
- Choose a method that:
- Best represents the physical flow of goods.
- Reflects ending inventory at recent costs.
- Remain consistent for inventories of similar nature and usage within the company.
Lower of Cost and Net Realizable Value (LCNRV)
- Inventories are written down to their net realizable value when their value declines.
- Net Realizable Value (NRV): The expected selling price minus any costs necessary to prepare the goods for sale.
- This approach deviates from the historical cost principle and should be evaluated on an item-by-item basis.
- Inventory is adjusted by crediting it for the amount of the write-down, debiting the cost of goods sold; reversals are allowed if the value recovers.
Inventory Turnover Ratio & Days in Inventory
- Inventory Turnover Ratio: Indicates how many times inventory is sold each year; a higher ratio is preferred.
- Formula: ext{Inventory Turnover Ratio} = rac{ ext{COGS}}{ ext{Average Inventory}}
- Days in Inventory: Measures the average time taken to sell an item; a lower number is better.
- Formula: ext{Days in Inventory} = rac{365}{ ext{Inventory Turnover Ratio}}