Order Disposition Pipeline (4 Rules in Priority Order)

You're an operations analyst encoding the order-disposition rules from the ops handbook. Four rules apply in strict priority order — first match wins:

1. Cancelled — if status code = "X" OR order age > 90 days (terminal state, trumps everything else)
2. Expedited — if customer tier = "Premium"
3. Backordered — if inventory count < 1 (out of stock, only matters if not expedited)
4. Standard — anything that didn't match above

Columns A–E: Order ID, Status Code (X / OK), Order Age (days), Customer Tier (Premium / Gold / Standard), Inventory Count.

The trickiest cases:

• Premium customer with 0 inventory → Expedited (rule 2 trumps rule 3)
• Cancelled status with Premium tier → Cancelled (rule 1 trumps rule 2)
• Order age 95 days, Premium tier, 50 in inventory → Cancelled (rule 1 fires on age alone)

Your task:

1. In column F (Disposition), write a single formula (LET + IFS recommended) that produces the right disposition for each row by applying rules in priority order.
2. The formula must drag-fill from F2 → F11.

Graded cells: F3 (Cancelled — age 100), F5 (Expedited — Premium with 0 inventory), F6 (Backordered — Standard with 0 inventory).