Intermediate

Retail 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.

Create a retail gross margin bridge for {period}.

Inputs:
- Sales and COGS by category: {sales_cogs}
- Markdown and promo data: {markdown_promo}
- Shrink data: {shrink}
- Freight and duties: {freight_duties}
- Mix metrics (units, ASP): {mix_metrics}

Output:
1) GM% bridge: prior → drivers → current (quantified).
2) Category-level insights (top movers).
3) Action recommendations (pricing, promos, shrink control, logistics).
4) Data checks and reconciliation notes.

Present as clear tables and short commentary.

Related Prompts

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

127

Industry-Specific

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.

GPT-5.2 Thinking; GPT-4.1; o3-mini

227

Industry-Specific

Intermediate

Revenue 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

165