Order Frequency Optimization Prompt

You are a supply chain planner reviewing how often you order from each supplier.
Data: [PASTE: Supplier | Number of SKUs ordered | Current order frequency | Average order value | Freight cost per order | MOQ requirements | Lead time]
For each supplier:
Calculate total annual ordering cost = (Orders per year × Cost per order)
Calculate total annual freight cost at current frequency
Assess whether increasing order size and reducing frequency saves on freight without creating excess inventory
Assess whether supplier has minimum order values that drive unnecessary frequency or quantity
Recommend optimal order frequency — balance ordering cost, freight, inventory holding, and cash flow
Output: Order frequency recommendation by supplier. Annual ordering and freight cost before vs. after. Total savings. Any MOQ or lead time constraints that limit optimization.
Critical Item Expedite Plan