What should we buy, and when should we order it?
Ever had plenty of inventory overall but still ran short on the products customers needed? This tool checks upcoming demand, stock, incoming orders and lead times to suggest what you should buy — and when.
Don't buy just because a fixed reorder point says so.
Start with what customers are likely to need over the coming weeks. Then look at what you have and what is already on order. The tool checks whether that will be enough and tells you where a purchase may be needed.
Demand changes? A supplier delays a shipment? You change an order? The plan updates so you can protect service without buying inventory you don't really need.
Let the tool do the math. You make the call.
The tool suggests when and how much to order. You can accept that suggestion or adjust it based on what you know about suppliers, customers and the business.
See the suggested PO. Then decide what to approve.
The screenshots below are cropped directly from the actual commercial Excel product. No recreated interface is used as product proof.

ORD_Plan — Suggested → Buyer Decision → Final
The original recommendation remains visible while the buyer enters the quantity to approve. Once approved, the final quantity becomes the working plan and the downstream projection recalculates.
Want to know why it suggested that order? Look at the numbers behind it.
DETAIL_Grid exposes the planning logic SKU by SKU, week by week.
DETAIL_Grid — weekly demand, inventory, target and order timing
For each SKU, the grid shows future demand, scheduled supply, target inventory, projected inventory, planned receipts and the release timing generated from lead time. It also makes the frozen zone visible: when a shortage sits inside lead time, a new PO is already too late and the action shifts to expediting or allocation.
See what needs your attention this week.
The planning engine generates the recommendation. The dashboard helps teams prioritize risk, understand what changed and focus on the SKUs that require action.

Priorities Dashboard
Highlights the most relevant issues by severity, value, responsible area and suggested action—turning the weekly review into a clear action agenda.

SKU Detail Dashboard
Drills into the item-level signal with projected inventory, target coverage, scheduled and planned receipts, purchase timing and open-order context.
Start with the products that actually need action.
The companion dashboard turns the plan into a weekly review by exception.
Stockout Risk
Projected inventory falls below zero inside lead time. Expedite, use partial shipments or allocate available stock.
Order Now
A purchase recommendation is due for release in the current week.
Below Target
Forward coverage is below policy, but no order is due this week. Review lead time, MOQ or next release date.
Excess
Coverage is materially above target. Review future buys, demand assumptions, reallocation or promotion options.
What Changed
Compare this week's run with the previous one and separate demand, supply and actual-start drivers.
Supplier Review
Track open POs, delayed ETAs, past-due orders, status setbacks and purchase value by supplier.
Already have a forecast? That's fine — use yours.
The planner accepts any forward-looking monthly forecast, budget or sales plan. If your forecast is arranged as SKUs in rows and months in columns, the included Forecast_Converter.xlsx transforms it into the planner format.
If you already use the MGV76 Demand Planning Kit, its export can be pasted directly into the planner.
The tools work together, but you can use either one on its own.
Demand Planning and Inventory & Purchase Planning work together, but each product can be used independently.
One complete Inventory & Purchase Planning package.
Inventory & Purchase Planning
Forward inventory planning, suggested purchase orders, buyer approval, dynamic replanning and exception dashboard.
One-time payment securely processed by Lemon Squeezy.
Designed for practical SKU-level planning.
Up to 500 SKUs
With up to 50 suppliers and 2,000 open purchase orders.
26-week horizon
Forward weekly inventory and purchasing plan using a 12-month forecast.
SKU policy
Target WOS, lead time, MOQ and order multiple can be defined by SKU.
Consolidated inventory
Multiple locations for the same SKU are added into one consolidated position.
Not MRP
The product does not include BOM explosion, multi-level MRP or plant-capacity constraints.
Planner-controlled
The calculation supports the decision. The buyer remains responsible for the final purchase action.