Start with a business goal · Manufacturing

Which parts should we expedite, reorder or defer?

You lead supply chain planning for a component manufacturer. Choose the business goal and see how the same evidence leads to different actions. All figures are synthetic.

Cover Friday’s confirmed order

Verify that expedited units can arrive on time and check the order margin after freight.

Decision and rationale

Expedite only the 40-unit shortfall if Friday delivery is firm and the margin supports it. Defer Part B’s receipt if supplier terms allow.

Review and reconsider

Track on-time delivery and realized margin. Switch to split delivery if the expedited arrival slips.

What the evidence says

Part A has 60 usable units against a confirmed order for 100 due Friday. Its next receipt is Monday, and expediting 40 units costs ₹12,000. Part B has 240 units against a 60-unit four-week forecast and another 100 due next week.

Confirm supplier capacity, usable stock and whether the customer accepts split delivery. The Part B forecast may change.

What the manager weighs

Expedite the Part A shortage, negotiate split delivery, or reschedule the Part B receipt. Compare service risk, cash tied up and the effect of freight on order margin.

The supply chain lead owns the decision with sales and finance input.

Manufacturing data model · Workbook tabs
TabOne row perFields and use
Customer ordersOrder lineSKU, due date, committed units and customer. Identify delivery exposure.
InventorySKU and locationUsable stock, reservations and ageing. Calculate uncommitted availability.
Purchase ordersPO lineSKU, expected receipt, units and supplier. Check incoming supply.
Demand planSKU and weekForecast units and week. Compare stock cover.
Cost and lead timeSKU and supplierUnit cost, expedite fee and lead time. Compare margin and service trade-offs.

Join by SKU and reconcile location, reservations and units before comparing orders due with available stock and receipts. Flag unconfirmed receipt dates.

Discuss your use case ↗