AGENT SKILL

inventory-costing

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

License 许可
MIT
最近更新
2026-11-01
Stars
★ 47
Forks
14

01 前言 Front Matter

name
inventory-costing
metadata
{ "version": "1.0.0" }
description
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."

02 资源文件 6

03 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


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.

04 同仓库更多 Skills

GAJETOso
GAJETOso/financeskills

working-capital-analysis

When the user wants to analyze or optimize working capital — receivables, payables, inventory, and the cash conversion cycle. Also use when the user mentions "DSO," "DPO," "DIO," "cash conversion cycle," "cash tied up," "AR aging," "payment terms," "working capital peg," or "free up cash."

★ 47
GAJETOso
GAJETOso/financeskills

wacc-computation

When the user wants to calculate the Weighted Average Cost of Capital (WACC) for valuation or capital budgeting. Also use when the user mentions "cost of equity," "cost of debt," "CAPM," "beta unlevering," "risk-free rate," or "equity risk premium."

★ 47
GAJETOso
GAJETOso/financeskills

venture-debt

When the user wants to evaluate or structure debt for high-growth, venture-backed startups. Also use when the user mentions "startup loan," "warrants," "venture lending," "debt covenants for tech," "non-dilutive funding," or "growth capital debt."

★ 47
GAJETOso
GAJETOso/financeskills

variance-analysis

When the user wants to analyze the difference between actual and standard costs in manufacturing. Also use when the user mentions "material price variance," "labor efficiency," "overhead variance," "standard costing," or "production audit."

★ 47
GAJETOso
GAJETOso/financeskills

treasury-management

When the user wants to manage corporate liquidity, investments, or financial risks like FX and interest rates. Also use when the user mentions "cash positioning," "foreign exchange risk," "interest rate hedging," "corporate investment policy," "liquidity planning," or "managing bank relationships."

★ 47
GAJETOso
GAJETOso/financeskills

three-statement-modeling

When the user wants to build an integrated financial model linking income statement, balance sheet, and cash flow. Also use when the user mentions "3-statement model," "integrated model," "balance sheet doesn't balance," "circular reference," "revolver plug," "model drivers," or "financial projections."

★ 47