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

Construction WIP schedule: percent complete and billings

Builds a construction Work-in-Progress (WIP) schedule including percent complete, revenue recognized, billings, and under/over billings. Useful for contractors and auditors.

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

Industry-Specific

Intermediate

Construction retainage reconciliation and aging action plan

Reconciles retainage receivable/payable, flags aged items, and proposes collection/settlement actions. Useful for improving cash flow and close accuracy.

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

Industry-Specific

Intermediate

Real estate development cost capitalization tracker

Creates a tracker for development costs, capitalization rules, and allocation to projects/units. Useful for developers and real estate accountants managing multi-project portfolios.

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