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
BeginnerNonprofit: Functional Expense Allocation (990)
Allocates expenses between Program, Management, and Fundraising buckets.
GPT-4oGemini 1.5 Pro
0
0
23
Industry-Specific
IntermediateAccounting for Cryptocurrencies (Intangible vs. Fair Value)
Tracks the evolution of crypto accounting rules for corporate balance sheets.
GPT-4oClaude 3.5 Sonnet
0
0
18
Industry-Specific
IntermediateARR/MRR rollforward with churn, expansion, and cohort view
Creates an ARR/MRR rollforward and cohort-based retention view using subscription data. Useful for SaaS metrics reporting and investor updates.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
21