--- name: inventory-accounting-valuation description: Manage inventory accounting including valuation methods (FIFO, LIFO, weighted average, standard cost), lower of cost or market (LCM) / net realizable value assessments, inventory obsolescence reserves, cycle counting, and inventory roll-forward analysis. Use when setting up inventory accounting policies, performing inventory valuations, calculating obsolescence reserves, conducting inventory reconciliations, analyzing inventory turns, or preparing inventory disclosures. Triggers on phrases like "inventory accounting", "inventory valuation", "FIFO", "LIFO", "weighted average cost", "standard costing", "lower of cost or market", "LCM", "net realizable value", "NRV", "inventory reserve", "obsolescence reserve", "inventory turns", "cycle count". --- # Inventory Accounting & Valuation Manage inventory valuation, costing methods, and write-down assessments to ensure accurate inventory balances and compliance with ASC 330 / IAS 2. ## Workflow ### 1. Inventory Valuation Method Selection ``` INVENTORY VALUATION METHODS ═══════════════════════════════════════ SELECT METHOD BASED ON: → Nature of inventory (perishable, commodity, manufactured) → Industry norms → Tax implications (LIFO conformity rule in US) → Financial statement presentation preferences → System capability and data requirements COMPARISON OF METHODS: ═══════════════════════════════════════ FIFO LIFO Weighted Avg Standard Cost ───────────────────────────────────────────────────────────────────────── Rising prices Higher Lower Moderate N/A (variance) inventory inventory Lower COGS Higher COGS Higher Lower earnings earnings Tax impact Higher Lower* Moderate N/A taxes taxes* Matching to Older costs Recent Blended Budgeted current costs (less match) costs costs costs Complexity Moderate Moderate Simple Higher System needs Moderate Moderate Low Robust *LIFO tax benefit in inflationary environment (US only; IRS requires LIFO for tax if used for financial reporting — LIFO conformity rule) RECOMMENDATION FRAMEWORK: → Retail/CPG with stable SKUs: Weighted Average or Standard Cost → Manufacturing with BOMs: Standard Cost with variance analysis → Commodities/energy: LIFO (if US, tax benefit desired) → Perishable goods: FIFO (most natural flow) → Technology/hardware: Standard Cost or FIFO ``` ### 2. Standard Costing System ``` STANDARD COST CALCULATION ═══════════════════════════════════════ For each SKU/product, establish standard cost: DIRECT MATERIALS: Component Qty Std Price Std Cost ────────────────────────────────────────────────── Circuit Board 1 $12.50 $12.50 Housing 1 $3.20 $3.20 Battery Pack 2 $4.50 $9.00 Connector Kit 1 $1.80 $1.80 Packaging 1 $0.75 $0.75 Total Materials: $27.25 DIRECT LABOR: Assembly: 0.25 hours × $25/hr = $6.25 Testing: 0.10 hours × $30/hr = $3.00 Total Labor: $9.25 MANUFACTURING OVERHEAD: Applied rate: $18.00 per direct labor hour DL hours: 0.25 + 0.10 = 0.35 hours Overhead: 0.35 × $18.00 = $6.30 TOTAL STANDARD COST PER UNIT: $42.80 VARIANCE ANALYSIS (Monthly): ═══════════════════════════════════════ MATERIAL COST VARIANCE: = (Actual Price - Standard Price) × Actual Quantity Example: Circuit boards purchased at $13.00 vs $12.50 std = ($13.00 - $12.50) × 10,000 units = $5,000 UNFAVORABLE MATERIAL USAGE VARIANCE: = (Actual Qty - Standard Qty) × Standard Price Example: Used 10,500 boards for 10,000 units (should be 1:1) = (10,500 - 10,000) × $12.50 = $6,250 UNFAVORABLE Root cause: Scrap rate increased from 1% to 5% LABOR RATE VARIANCE: = (Actual Rate - Standard Rate) × Actual Hours Example: Paid $27/hr vs $25/hr std = ($27 - $25) × 2,500 hours = $5,000 UNFAVORABLE LABOR EFFICIENCY VARIANCE: = (Actual Hours - Standard Hours) × Standard Rate Example: Used 2,800 hours for work requiring 2,500 std hours = (2,800 - 2,500) × $25 = $7,500 UNFAVORABLE OVERHEAD VARIANCE: = Actual Overhead - Applied Overhead = (Actual DLH × Actual OH Rate) - (Actual DLH × Std OH Rate) + Volume variance (capacity utilization) TOTAL VARIANCE: $24,250 UNFAVORABLE → If immaterial (<2% of COGS): Write off to COGS → If material: Prorate between COGS and ending inventory ``` ### 3. Inventory Roll-Forward & Reconciliation ``` INVENTORY ROLLFORWARD ═══════════════════════════════════════ Raw Materials WIP Finished Goods TOTAL Beginning Balance $2,500,000 $800K $3,200,000 $6,500,000 Purchases/Transfers In +$1,800,000 — — +$1,800,000 Production Transfers — +$1,200K — +$1,200,000 Finished Goods Transfers — ($900K) +$900,000 $0 COGS/Shipments — — ($2,100,000) ($2,100,000) Adjustments: Scrap/Write-offs ($50,000) — ($30,000) ($80,000) Standard Cost Variance — — ($15,000) ($15,000) Cycle Count Adjustments +$8,000 ($3,000) +$5,000 +$10,000 Ending Balance $4,258,000 $1,097K $1,960,000 $7,315,000 RECONCILIATION TO GL: Inventory per sub-ledger: $7,315,000 Inventory per GL (account 13000): $7,320,000 Difference: $5,000 Resolution: Timing — 3 transfers in transit; JE posted but sub-ledger not updated. Will clear next day. Documenting. ``` ### 4. Lower of Cost or Market / Net Realizable Value ``` LOWER OF COST OR NET REALIZABLE VALUE (LCM/NRV) TEST ═══════════════════════════════════════ Per ASC 330 (US GAAP): Inventory stated at lower of cost or market Per IAS 2 (IFRS): Inventory stated at lower of cost or net realizable value TEST PROCEDURE (per SKU or category): ═══════════════════════════════════════ STEP 1: Determine Cost → Standard cost or actual cost (FIFO/LIFO/weighted avg) STEP 2: Determine Net Realizable Value (NRV) = Estimated selling price - Costs to complete - Costs to sell STEP 3: Compare and Write Down (if needed) → If Cost > NRV: Write down to NRV → If Cost ≤ NRV: No write-down needed EXAMPLE — SKU Analysis: ═══════════════════════════════════════ SKU Qty Cost/Unit NRV/Unit Total Cost Total NRV Write-Down ───────────────────────────────────────────────────────────────────────────── A-100 500 $50.00 $55.00 $25,000 $27,500 $0 A-200 300 $45.00 $48.00 $13,500 $14,400 $0 B-100 200 $60.00 $52.00 $12,000 $10,400 $1,600 ⚠ B-200 50 $80.00 $65.00 $4,000 $3,250 $750 ⚠ C-100 100 $120.00 $110.00 $12,000 $11,000 $1,000 ⚠ D-100 75 $35.00 $20.00 $2,625 $1,500 $1,125 ⚠ ───────────────────────────────────────────────────────────────────────────── Total: $69,125 $68,050 $4,475 NRV CALCULATIONS: B-100: Selling price $65 - selling costs ($13) = NRV $52 < Cost $60 → Reason: Newer model B-101 replaced; price discounting old model B-200: Selling price $80 - selling costs ($15) = NRV $65 < Cost $80 → Reason: Discontinued product; clearance pricing C-100: Selling price $130 - completion costs $15 - selling $5 = NRV $110 → Reason: Market price decline in raw material D-100: Selling price $30 - selling costs ($10) = NRV $20 < Cost $35 → Reason: Obsolete — technology replaced; minimal salvage value JOURNAL ENTRY: Dr COGS — Inventory Write-Down $4,475 Cr Inventory Reserve / Inventory $4,475 ``` ### 5. Obsolescence Reserve Calculation ``` INVENTORY OBSOLESCENCE RESERVE ═══════════════════════════════════════ AGING-BASED RESERVE METHODOLOGY: ═══════════════════════════════════════ Age Bracket Reserve % Inventory $ Reserve $ ────────────────────────────────────────────────────────── 0-90 days (current) 0% $4,200,000 $0 91-180 days (aging) 25% $800,000 $200,000 181-365 days (stale) 50% $350,000 $175,000 >365 days (obsolete) 100% $150,000 $150,000 ────────────────────────────────────────────────────────── Total Reserves: $6,500,000 $525,000 RESERVE ROLLFORWARD: ═══════════════════════════════════════ Beginning Reserve: $480,000 Additions (provision this period): +$120,000 Write-offs (inventory disposed): ($65,000) Reversals (inventory sold at NRV): ($10,000) Ending Reserve: $525,000 OBSOLESCENCE ANALYSIS BY CATEGORY: ═══════════════════════════════════════ Category Inventory $ Reserve $ Reserve % Action ───────────────────────────────────────────────────────────────── Finished Goods $3,200,000 $280,000 8.8% Monitor Raw Materials $2,100,000 $180,000 8.6% Review purchases WIP $700,000 $40,000 5.7% Normal Packaging/MRO $500,000 $25,000 5.0% Normal Total $6,500,000 $525,000 8.1% — KEY METRICS: Inventory Turns = COGS / Average Inventory = $24M / $6.75M = 3.56x Days Inventory Outstanding = 365 / 3.56 = 103 days Obsolescence Rate = Reserve / Inventory = 8.1% (target: <5%) ⚠ Action needed: Obsolescence rate above target; review purchasing plans ``` ### 6. Cycle Counting Program ``` CYCLE COUNTING PROGRAM ═══════════════════════════════════════ ABC CLASSIFICATION: ═══════════════════════════════════════ Class Criteria Count Frequency % of SKUs % of Value ───────────────────────────────────────────────────────────────────────────── A Top 20% by value Monthly 15% 70% B Next 30% by value Quarterly 30% 20% C Bottom 50% by value Semi-annually 55% 10% CYCLE COUNT PROCEDURES: 1. Generate count list (system pulls quantities) 2. Counters blind-count (do NOT see system quantity) 3. First count by counter A 4. Second count by counter B (if variance > tolerance) 5. Supervisor review for variances 6. Investigate root cause (shipping error, receiving error, theft, damage) 7. Post adjustment with supporting documentation 8. Update system quantities VARIANCE THRESHOLDS: → Unit variance: >3 units or >5% of on-hand (whichever triggers first) → Dollar variance: >$500 or >1% of category value → Variances within threshold: Auto-adjust → Variances above threshold: Investigation required MONTHLY CYCLE COUNT RESULTS: ═══════════════════════════════════════ SKUs Scheduled: 450 SKUs Counted: 450 (100%) Variances found: 23 (5.1%) Within tolerance: 18 (auto-adjusted) Above tolerance: 5 (under investigation) Dollar Value of Variances: Favorable (found more): +$2,800 Unfavorable (found less): ($4,200) Net variance: ($1,400) Net / Inventory value: -0.02% (within annual target of <0.1%) TOP VARIANCE ITEMS: 1. SKU D-100: Short 25 units ($875) — misplaced in warehouse (relocated) 2. SKU C-200: Short 10 units ($1,200) — shipped without picking ticket → Root cause: Picking process bypassed; retraining required ``` ## Edge Cases - **LIFO liquidation**: When LIFO inventory layers are depleted, older (cheaper) costs flow to COGS, inflating earnings; disclose LIFO liquidation separately - **Consignment inventory**: Inventory owned by supplier but held by company; track separately; not on balance sheet - **Work-in-progress valuation**: Estimate % completion; apply partial material and labor costs; use engineering estimates - **Inventory at off-site locations**: Customer sites, third-party warehouses; coordinate counts; track ownership clearly - **Perishable inventory**: Frequent NRV testing; short aging brackets; high reserve percentages for near-expiry items ## Integration Points - **ERP Inventory Module**: SAP MM, Oracle INV, NetSuite (inventory transactions, valuations) - **WMS**: Manhattan, Blue Yonder, Fishbowl (warehouse operations, cycle counts) - **MRP/ERP**: Production planning, BOM management - **Costing systems**: Standard cost maintenance, variance analysis - **BI tools**: Inventory aging reports, turns analysis, obsolescence dashboards ## Output ### Inventory Valuation Summary ``` INVENTORY VALUATION SUMMARY — March 2024 ═══════════════════════════════════════ GROSS INVENTORY (at standard cost): $7,315,000 Less: Inventory Reserve (LCM/NRV): ($4,475) Less: Obsolescence Reserve: ($525,000) NET INVENTORY (per balance sheet): $6,785,525 KEY METRICS: Inventory turns: 3.56x (target: 4.0x) ⚠ Days inventory: 103 days (target: 91) ⚠ Obsolescence rate: 8.1% (target: <5%) ⚠ Cycle count accuracy: 99.98% ✓ Variance to GL: $0 (reconciled) ✓ ACTION ITEMS: 1. Review purchasing plans for slow-moving SKUs 2. Promote/clear B-200 and D-100 obsolete inventory 3. Implement vendor-managed inventory for C materials 4. Retrain warehouse on picking process compliance ```