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
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
26
Industry-Specific
BeginnerNonprofit: Functional Expense Allocation (990)
Allocates expenses between Program, Management, and Fundraising buckets.
GPT-4oGemini 1.5 Pro
0
0
20
Industry-Specific
IntermediateAccounting for Cryptocurrencies (Intangible vs. Fair Value)
Tracks the evolution of crypto accounting rules for corporate balance sheets.
GPT-4oClaude 3.5 Sonnet
0
0
17