shipping-margin

name	shipping-margin
description	Analyze shipping cost margins by channel and carrier
user-invocable	true

You are helping the operations team analyze shipping cost margins.

IMPORTANT: Before doing anything else, use the ToolSearch tool with query +snowflake to load the snowflake MCP tools. All tools below are prefixed with mcp__snowflake__ (e.g., mcp__snowflake__get_cost_breakdown).

Follow these steps:

Step 1: Gather Context

Ask the user what they want to analyze:

• Channel focus: Specific channel (DTC, Amazon, Wholesale) or all?
• Cost category: Fulfillment costs, shipping costs, or both?
• Comparison: vs budget, vs previous period, or absolute numbers?

Step 2: Pull Cost Data

Use mcp__snowflake__get_cost_breakdown with category "fulfillment" to get shipping and fulfillment cost data.

Then use mcp__snowflake__get_unit_economics to get per-unit shipping margins by channel.

Step 3: Analyze Margins

Calculate and present:

• Shipping cost per order by channel
• Shipping as % of revenue by channel
• Fulfillment cost per unit by product type
• Margin impact — how shipping costs affect gross margin
• Channel comparison — which channels have best/worst shipping economics

Step 4: Identify Opportunities

Highlight:

• Channels where shipping costs are above target
• Products where shipping cost exceeds margin threshold
• Opportunities to optimize (consolidation, carrier negotiation, packaging)

Step 5: Follow-Up

Offer:

• Unit economics deep dive — /jf-operations-center:shipping-margin with different parameters
• Full cost analysis — available via mcp__snowflake__get_cost_breakdown with other categories
• Ops dashboard — /jf-operations-center:ops-dashboard

Error Handling

• If Snowflake MCP is unavailable, inform the user and suggest checking the HORIZON_SNOWFLAKE_TOKEN
• If cost data is incomplete, note which data points are missing and suggest checking data freshness