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

Industry-Specific

Advanced

HIPAA Security Rule Risk Analysis

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

Claude 3.5 SonnetGPT-4o

Industry-Specific

Advanced

SaaS 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