Advanced

Inventory reserve framework: obsolescence, shrink, and markdowns

Designs an inventory reserve approach for obsolescence and markdowns with calculation templates and controls. Useful for retail and manufacturing close and audit support.

Create an inventory reserve framework for {company_name} as of {period_end_date}.

Inputs:
- Inventory aging and turns by SKU/category: {inventory_aging_turns}
- Historical write-offs/markdowns: {history}
- Shrink results (cycle counts): {shrink_data}
- Pricing/markdown strategy: {markdown_strategy}
- Policy thresholds: {policy_thresholds}

Output:
1) Reserve methodology by driver (aging, excess, shrink, markdown).
2) Calculation template with assumptions and % rates.
3) Journal entry templates and rollforward schedule.
4) Controls and evidence checklist.

Be transparent and avoid false precision.

Related Prompts

Industry-Specific

Beginner

Nonprofit: Functional Expense Allocation (990)

Allocates expenses between Program, Management, and Fundraising buckets.

GPT-4oGemini 1.5 Pro

Industry-Specific

Advanced

CECL allowance model governance: assumptions, controls, and doc

Designs a CECL model governance and documentation package including assumptions, controls, and validation. Useful for banks and auditors supporting allowance estimates.

GPT-5.2 Thinking; GPT-4.1; o3-mini

Industry-Specific

Intermediate

Revenue cycle analytics: denials, days in AR, and cash acceleration

Analyzes revenue cycle KPIs and identifies actionable levers to reduce denials and improve collections. Useful for hospital/practice management and finance teams.

GPT-5.2 Thinking; GPT-4.1; o3-mini