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
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
15
Industry-Specific
Advanced

HIPAA Security Rule Risk Analysis

Evaluates the technical safeguards for Protected Health Information (PHI).

Claude 3.5 SonnetGPT-4o
0
0
5
Industry-Specific
Advanced

Healthcare patient AR reserve: contractual allowances methodology

Develops a methodology for contractual allowances and bad debt reserves using payer mix and historical collections. Useful for healthcare finance teams and auditors.

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