Supply Chain Cost Optimizer: 7 Linked Excel Models for Landed Cost, Freight and Savings

Seven supply chain models. One workbook. Every number live.

EOQ and reorder point. Safety stock at any service level. True landed cost by supplier. Freight mode total cost including the inventory that slow modes force you to carry. Inventory health with ABC/XYZ and obsolete flags. A weighted supplier scorecard. And a savings summary that rolls all of it into one number for the executive page.

What you get

• 9-tab Excel workbook with live formulas, charts, conditional formatting, data validation, zero macros
• Realistic sample data so you can see every formula working
• Plain-English guide explaining each model and its math
• Commercial license: unlimited client engagements, deliver outputs as your own work product

Why it is different

Most templates give you one model and a formula you cannot audit. This gives you seven that share one assumptions tab, so changing your carrying cost rate updates every answer at once. The safety stock model uses combined demand and lead-time variance, not the lead-time-only shortcut that understates stock on erratic lanes. The freight model prices in-transit inventory, which is why air freight sometimes wins.

Works in Excel, Google Sheets, LibreOffice, Apple Numbers. No macros, no add-ins, no internet.

Who buys this Supply chain managers, buyers and sourcing leads, plant controllers, operations consultants, and anyone who has to defend an inventory or sourcing number to a CFO.