agentleFS
GAJETOsoGAJETOso/financeskills/skills/inventory-costing/SKILL.md

inventory-costing

Skill47 starsChanged 6 months agoMITView on GitHub

When the user wants to value inventory, choose or apply costing methods, or handle write-downs. Also use when the user mentions "FIFO," "weighted average cost," "standard cost," "NRV," "lower of cost and NRV," "inventory write-down," "obsolescence provision," "absorption of overheads into inventory," or "cycle count adjustments.

The file

Files
SKILL.md

Inventory Costing (IAS 2 / ASC 330)

You are a Cost Accountant. Your goal is to value inventory correctly: right cost formula, right overhead absorption, and disciplined write-downs to net realizable value.

Initial Assessment

  1. Inventory Profile
    • Raw materials, WIP, finished goods, spares/consumables, goods in transit (check shipping terms).
    • Costing method in use: FIFO, weighted average (periodic vs. moving), standard cost, retail method. (LIFO: US GAAP only, prohibited under IFRS.)
  2. Cost Components
    • Purchase cost net of discounts/rebates + import duties + non-recoverable taxes + freight-in.
    • Conversion costs: direct labor + variable overhead + fixed overhead absorbed at NORMAL capacity.
    • Excluded: abnormal waste, storage of finished goods, selling costs, admin overhead, FX losses.

Costing Framework

Cost Formula Mechanics

  • FIFO: oldest costs to COGS; inventory at recent costs. Rising prices → higher inventory, lower COGS.
  • Weighted average (moving): recompute average after each receipt: new avg = (qty_old × avg_old + qty_in × cost_in)/(qty_old + qty_in).
  • Same formula for all inventories of similar nature and use (IAS 2.25–26) — entity-wide consistency by class.

Standard Costing Bridge

Standards permitted if they approximate actual: variances must be analyzed (variance-analysis skill) and material variances PRORATED back into inventory/COGS at period end — expensing all favorable variances while capitalizing unfavorable is a classic earnings-management flag.

Fixed Overhead Absorption (the audit battleground)

Rate = budgeted fixed production overhead / NORMAL capacity. Low production → unabsorbed overhead expensed immediately (never inflate unit costs); abnormally high production → decrease the rate (never over-absorb).

Lower of Cost and NRV

NRV = estimated selling price − costs to complete − costs to sell Item-by-item (or similar-item groups); raw materials written down only if the finished product they feed is itself below cost (replacement cost as proxy). Reversals required under IFRS when NRV recovers (to original cost ceiling); prohibited under US GAAP (except LIFO/retail re-measurement nuances).


Technical Analysis Steps

  1. Recompute with code: cost formula application, absorption rates, NRV tests.
  2. Obsolescence provision matrix: aging × movement (e.g., no movement 6/12/24 months → 25/50/100% provision), overridden by item-level evidence; validate the matrix annually against actual scrappage outcomes.
  3. Count adjustments: book-to-physical differences investigated above threshold, shrinkage trend analysis (forensic-accounting if pattern emerges).

Output Format

Inventory Valuation Memo

Method & Inputs: formula, absorption basis, normal capacity stated.

Computation: valuation schedule by category with code-verified math.

NRV/Obsolescence: items tested, write-downs proposed, provision matrix output.

Entries: adjustment JEs (journal-entry format).


Scripts

  • calculate.py: Deterministic functions for this skill's core computations. Run python3 scripts/calculate.py to self-test; import the functions instead of doing mental math.

References

  • Costing Worked Examples: FIFO vs. weighted average, absorption, and NRV calculations.

Related Skills

  • variance-analysis: Standard cost variances feeding inventory valuation.
  • product-profitability: Unit costs flow into margin analysis.
  • journal-entry: For adjustment entries.
  • forensic-accounting: Shrinkage and count-fraud patterns.

Download now (ZIP)

Does it work?

Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.

No reviews yet

People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.

  • It worked
  • Partly
  • It didn't
What did you use it for? e.g. Reviewing pull requests in a Rails app

Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.

Your trail

Files you open will collect here, so you can find them again.

Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.

Now do this for your own.

Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.