Beginner

Retail: Shrinkage Reserve & Gross Margin Analysis

Estimates the 'Shrink' (theft/damage) reserve based on sales volume.

Calculate the 'Inventory Shrinkage' reserve for {store_location}. Total sales for the period: {sales}. Based on the last physical count which showed a {shrink_percent}% loss rate, calculate the estimated current shrink. Analyze why the Gross Margin dropped from {prior_margin}% to {current_margin}%.

Related Prompts

Industry-Specific
Advanced

Channel 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
16
Industry-Specific
Intermediate

Loan 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
8
Industry-Specific
Intermediate

ARR/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
8