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
AdvancedChannel rebates and returns accrual model (consumer goods)
Designs an accrual model for rebates, returns, and allowances common in consumer goods, with rollforward schedules. Useful for close and audit support.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
15
Industry-Specific
AdvancedHIPAA Security Rule Risk Analysis
Evaluates the technical safeguards for Protected Health Information (PHI).
Claude 3.5 SonnetGPT-4o
0
0
7
Industry-Specific
AdvancedSaaS revenue waterfall: bookings โ billings โ revenue โ cash
Builds a SaaS revenue waterfall reconciling bookings, billings, deferred revenue, and revenue recognition. Useful for FP&A and accounting alignment and board reporting.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
7