GAAP Inventory Standard-Cost Variance, LCNRV Reserve & UNICAP Absorption Schedule — Calculator, Excel Workpaper & API (BI-04)
Evaluates FASB ASC 330-10 Normal-Capacity Fixed Overhead Allocation & Idle-Plant Period Expense; Lower of Cost and Net Realizable Value (LCNRV) / Obsolete & Excess SKU Reserve; Standard-to-Actual Purchase Price, Material Usage & Labor Efficiency Variance Tie-Out; IRC Sec. 263A Simplified Production Absorption Ratio & Ending Inventory Tax Add-On. Submit: Normal Capacity Hours, Actual Production Hours, Fixed Production Overhead (USD), Abnormal Spoilage And Rework (USD). Excel Tabs: Exec Margin Dashboard, Kaplan TDABC Cost Pools, ASC330 UNICAP Allocation, Lerner Price Elasticity. Calibrated across all 57 US States, Washington, D.C., US Territories, and Federal IRC § 11 baselines in sub-millisecond deterministic Python & NumPy CPU execution.
Official Statutory & Regulatory Workpaper Title: FASB ASC 330 Normal-Capacity Overhead, Obsolete Inventory LCNRV & IRC Sec. 263A Absorption Workpaper
Official Agency Form / Workpaper Standard: FASB ASC 330-10 / IRC Sec. 263A Simplified Production Schedule
Governing Accounting, Tax & Statutory Authorities: IMA Statement on Management Accounting (SMA): Activity-Based Costing; FASB ASC 330 (Inventory Overhead Allocation)
Common Practitioner & Search Aliases: ASC 330 Inventory Costing, Idle Plant Capacity Variance, Excess and Obsolete LCNRV Reserve, Standard Cost Variance Tie-Out, UNICAP Inventory Capitalization
Interactive GAAP Inventory Standard-Cost Variance, LCNRV Reserve & UNICAP Absorption Schedule Calculator (BI-04)
Enter your trial-balance, schedule, or contract numbers below to verify headline statutory outputs in real time across 57 US jurisdictions (zero data stored).
Optional: Paste Advanced Custom Schedule / Array Overrides (JSON)
Computed Headline Statutory & Financial KPIs
Download 5-Tab Formula-Linked Excel Workpaper (.xlsx) — $19.00
Includes 5 formatted CPA/analyst tabs compiled from your exact inputs: 01_Executive_Summary, 02_Statutory_Rules (4 rules), 03_Workpaper_Schedule (5 rows + =SUM/=AVERAGE formulas), 04_Scenario_Sensitivity (=C-B variance formulas), and 05_Compliance_Audit_Flags (3 threshold gates).
1. Deterministic Statutory & Regulatory Laws Executed
Unlike prompt-only LLM skills that approximate multi-period schedules in token space, BI-04 executes exact pure-Python and NumPy statutory rules in volatile container RAM:
- (1) FASB ASC 330-10 Normal-Capacity Fixed Overhead Allocation & Idle-Plant Period Expense [FASB ASC 330-10-30-3 through 30-7 (Inventory — Unallocated Fixed Overhead & Abnormal Spoilage)]
- (2) Lower of Cost and Net Realizable Value (LCNRV) / Obsolete & Excess SKU Reserve [FASB ASC 330-10-35-1B (Subsequent Measurement of FIFO/Average-Cost Inventory at LCNRV)]
- (3) Standard-to-Actual Purchase Price, Material Usage & Labor Efficiency Variance Tie-Out [FASB ASC 330-10-30-12 Standard Costing & Period Variance Proration Rules]
- (4) IRC Sec. 263A Simplified Production Absorption Ratio & Ending Inventory Tax Add-On [IRC Sec. 263A, Treas. Reg. Sec. 1.263A-2(b) (Simplified Production Method) & IRS Form 1125-A]
2. Input Schema & Workpaper Output Schedules
Structured Input Datasets (structured_inputs)
| Input Slot | Dataset / Trial-Balance Schedule | Accepted Format |
|---|---|---|
FILE-1 | 24-Month Revenue & Gross-Margin Transaction Ledger by SKU, Service Line & Customer ID | Structured JSON object/array or CSV text |
FILE-2 | Employee Timekeeping, Project Labor-Hour Allocation & Payroll Cost Register | Structured JSON object/array or CSV text |
FILE-3 | Departmental Overhead Trial Balance & Facility/IT/Support Cost-Driver Schedule | Structured JSON object/array or CSV text |
FILE-4 | Standard Bill of Materials (BoM), Service Rate Cards & Customer Discount/Rebate Agreements | Structured JSON object/array or CSV text |
Deterministic Output Workpaper Schedules
| Workpaper Schedule | Computed Output Schedule & Tie-Out |
|---|---|
| Schedule 1 | 00 Exec Margin Dashboard |
| Schedule 2 | 01 Kaplan TDABC Cost Pools |
| Schedule 3 | 02 ASC330 UNICAP Allocation |
| Schedule 4 | 03 Lerner Price Elasticity |
| Schedule 5 | 04 Pareto Whale Curve |
| Schedule 6 | 05 SKU Action Queue |
3. Quick Integration — REST API (cURL) & AI Agent MCP
A. Direct HTTP / REST API Call
curl -X POST "https://quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com/v1/suites/BI-04/compute" \
-H "Content-Type: application/json" \
-H "X-RapidAPI-Key: YOUR_RAPIDAPI_KEY" \
-H "X-RapidAPI-Host: quantledger-73-engine-financial-and-statutory-api.p.rapidapi.com" \
-d '{
"jurisdiction": "NY",
"naics_or_sic": "541211",
"structured_inputs": {}
}'
B. Model Context Protocol (MCP) Tool Call
// Tool call inside Claude Desktop, Cursor, VS Code Copilot, LangGraph, or CrewAI:
execute_institutional_math_engine({
"engine_code": "BI-04",
"jurisdiction": "DE",
"naics_or_sic": "541211",
"structured_inputs": {}
})