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
52
Industry-Specific
AdvancedCECL 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
0
0
45
Industry-Specific
IntermediateRetail gross margin bridge: markdowns, mix, shrink, freight
Builds a gross margin bridge explaining changes driven by markdowns, mix, shrink, and freight. Useful for merchandising and finance alignment.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
47