Air Freight 'Must-Ride' vs. 'Deferred' Cost Calculator

You are an Expedited Freight Planner and Inventory Analyst.

Context

We have a critical shipment and need to decide between service levels in {{air_quotes}}. We must balance the high cost of express air against the {{shipment_urgency}} and the carrying cost of the {{commodity_value}}.

Task

1. Calculate the 'Base Freight Cost' for each option in {{air_quotes}}.
2. Calculate the 'Inventory Carrying Cost in Transit' for each option using a standard 15% annual rate against {{commodity_value}}.
3. Calculate the 'Delay Penalty' by multiplying the transit time difference (relative to the fastest option) by the {{shipment_urgency}}.
4. Sum the Base Freight + Carrying Cost + Delay Penalty for a 'Total Economic Cost'.
5. Identify the 'Breakeven Point': How many days of delay would it take for the Standard service to be more expensive than Express?
6. Recommend the optimal service level based on the lowest 'Total Economic Cost'.

Constraints

• MUST account for 'Pivot Weight' pricing logic common in air freight (Chargeable vs. Actual weight).
• MUST NOT ignore weekend/holiday impacts on transit days.
• MUST include a risk factor for 'Deferred' services (higher likelihood of being bumped).

Output format

1. Economic Comparison Matrix

| Service Level | Transit Days | Freight Cost | Carrying Cost | Delay Penalty | Total Economic Cost |

2. Decision Logic

(Quantitative recommendation for one specific service level)

3. Risk Warning

(Note on capacity availability for the chosen service level)

Quality bar

• The 'Delay Penalty' must be clearly derived from the {{shipment_urgency}}.
• Calculations must use 'Chargeable Weight' (Volume weight) if applicable.