Supply Chain & InventoryFree worksheetPDF, Excel, Word export

Planned Order Release Schedule Worksheet

MRP creates planned orders, but somebody must convert them to purchase requisitions or work orders at the right time. This worksheet is the planner's weekly release list with value, so you can see commitments before you make them.

Download:

Part number	Description	Order type	Release action	Quantity	Unit cost	Lead time (days)	Release by	Extended value
								$2,208
								$1,350
								$1,050
								$3,520
								$850

Total quantity

1,900

Total value

$8,978

Average lead time

21 days

Average value per order

$1,796

Release by date = need date minus lead time. Replace the sample rows with your own. Firm planned orders are not changed by the next MRP run, so review them on a fixed rhythm.

Automate the weekly release list

Optional: discuss a read-only extract of planned orders from your ERP.

Optional. The tool and every export work without this. No spam.

How to use the worksheet

Paste or key in planned orders from your ERP planning screen: part, quantity, lead time and the date by which you must release. Choose the intended action for each row. The sheet calculates extended value so you see how much spend a release run will commit. Sort by release date and work from the top. Export to Excel to share with buyers and finance before the weekly release meeting.

Review release dates every week
Mark orders on hold with a reason in your notes column or in the ERP
Check capacity before converting to work orders
Send purchase conversions to buyers with the date

The logic behind release dates

A planned order has an order date and a due date separated by the item lead time. If today is past the order date, MRP flags a reschedule or an expedite, since the order cannot arrive when needed. The release date in this sheet is the latest safe date to convert, with any safety lead time included. Firm planned orders are frozen against MRP changes, so they should be few and have a documented reason.

Mistakes and ERP notes

Converting too early inflates inventory and breaks flexibility; converting too late creates shortages. In SAP, conversion uses MD04 or MD07 with planned order to PR or production order; in Epicor and SyteLine, you release suggested jobs or requisitions from the planning workbench. Watch for lot size rounding that changes quantity on conversion, and for planned orders created by an old safety stock you have since changed.

Frequently Asked Questions

How often should I convert planned orders?

Many planners release daily for purchased items with short lead times and weekly for stable long lead items. Choose a rhythm that matches your lead time and supplier order cut off.

What is the difference between planned and firm planned?

A planned order is recreated or changed by every MRP run. A firm planned order is fixed by a person, so MRP plans around it rather than changing it.

Does the sheet connect to my ERP?

No. It runs in your browser. Copy rows from your ERP export and use Excel export to share results.

Why show value?

Release batches commit cash. Seeing the total helps finance and buyers approve spend and catch a mis-keyed quantity before it becomes a purchase order.

Netray can help automate a weekly release list from your ERP planning data, with a human approving every conversion.

Talk to an Expert Explore More Free Tools

Related Tools

Discrete Manufacturing

More Supply Chain & Inventory tools

See all

Back to All Tools