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
IntermediateStandard costing variance dashboard (PPV, labor, overhead)
Creates a variance dashboard structure and investigation playbook for standard costing variances. Useful for plant controllers and operations reviews.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
77
Industry-Specific
IntermediateNonprofit: Restricted vs. Unrestricted Funds
Manages the release of assets from donor restrictions.
GPT-4oClaude 3.5 Sonnet
0
0
73
Industry-Specific
AdvancedInventory 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
0
0
111