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
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
173
Industry-Specific
IntermediateLoan accounting: nonaccrual, troubled debt, and interest income checks
Builds a checklist and analytics for loan nonaccrual status, modifications, and interest income recognition. Useful for bank controllers and auditors.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
127
Industry-Specific
IntermediateRevenue 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
0
0
165