Skip to content
ToolsOnDuty - free online tools
Business & Marketing

Purchase Order Planner

Convert forecast demand into a minimum-order and case-pack-rounded purchase quantity with an estimated product cost.

Free browser toolRuns in your browserNo sign-up

Purchasing workflow

Purchase Order Planner

Translate a demand plan into a pack-rounded purchase quantity after inventory position, lead time, cover and safety days.

Suggested purchase order

1,368 units

57 full cases after minimum-order and case-pack rules.

Inventory position

975 units

Target stock

2,320 units

Net requirement

1,345 units

Purchase cost

$11,628.00

Planning demand
40.00 units/day
Total coverage window
58.0 days
Rounded case count
57

The entered forecast remains your assumption. The planner does not predict demand or supplier performance and excludes freight, duty, taxes and cash-flow constraints unless included in unit cost.

About the Purchase Order Planner

Purchase Order Planner converts the demand plan you enter into a daily rate and target stock across supplier lead time, review cover and safety days.

It subtracts inventory position, applies minimum order quantity only when replenishment is needed, rounds upward to full case packs and estimates product purchase cost.

The tool does not create a demand forecast or account for supplier capacity, payment terms, freight, duty and cash constraints unless represented in the inputs.

Key features

  • Editable demand-plan period
  • Lead, review and safety coverage
  • Inventory-position adjustment
  • Net requirement
  • MOQ enforcement
  • Case-pack rounding
  • Estimated purchase cost
  • Local TXT export

How to use

  1. 1Enter forecast units and the period they cover.
  2. 2Set supplier lead time, desired review cover and safety days.
  3. 3Add on-hand, on-order and backordered quantities.
  4. 4Enter MOQ, case-pack size and unit cost.
  5. 5Review the rounded PO and confirm budget, freight and supplier capacity.

Examples

Case-pack supplier order
Input: 1,200 units over 30 days, coverage settings, inventory position, MOQ 250 and case pack 24
Output: Net requirement, rounded cases and purchase cost

Frequently asked questions

How is target stock calculated?
Daily planning demand multiplied by lead-time, review-cover and safety days combined.
When is MOQ applied?
Only when net replenishment requirement is above zero.
How does case-pack rounding work?
The MOQ-adjusted requirement is rounded upward to the next whole case pack.
Does purchase cost include freight and duty?
Only when you include those amounts in unit cost; use the Landed Cost Calculator for a detailed import model.

Continue your workflow

Open a related tool to prepare your files or refine the finished result.