Finance AI Skill

Inventory Accounting Valuation

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. Us...

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