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
- 参考文档evals/evals.json3.7 KB
- 资产文件evals/files/oversold_ledger.csv104 B
- 资产文件evals/files/purchases_sales.csv134 B
- 参考文档EXAMPLE.md1.0 KB
- 参考文档references/costing-examples.md2.0 KB
- 脚本scripts/calculate.py1.9 KB
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
-
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.)
-
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
- Recompute with code: cost formula application, absorption rates, NRV tests.
- 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.
- 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.pyto 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.
04 同仓库更多 Skills
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."
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."
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."
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."
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."
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."