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.
| 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 |
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.
Related Tools
Planned Order Offset and Start Date Calculator
Add setup, run, queue, move and safety time to get the lead time offset MRP should use to back schedule a made-in-house order.
Supply Chain & InventoryItem Planning Parameter Review Worksheet
Audit lot sizing, lead time and safety stock per item and see safety stock in days of cover. Edit rows and export to Excel.
Supply Chain & InventoryMRP Planner Workload Calculator
Estimate planner hours and headcount from active items, exception rate and time per action. See load percent and a what-if chart.
Supply Chain & InventorySupplier Expedite Request Template
A clear expedite request to send a supplier: PO line, quantity, required date, reason and what you need back. Free PDF and Word export.
More Supply Chain & Inventory tools
See all- Oracle Fusion Inventory Turns and Carrying Cost Calculator
- Distribution ERP Fill Rate Calculator
- Distributor Rebate Tracking Worksheet
- Branch Transfer Planning Worksheet
- Distributor Slow-Moving Inventory Review Worksheet
- Distributor Vendor Performance Scorecard Worksheet
- Distributor GMROI Calculator
- Distributor Backorder Cost and Fill Rate Calculator
- EOQ with Vendor Minimum Order Calculator
Keep exploring
Free tools
- Planned Order Release Lead Time CalculatorAdd setup, run, queue, safety and inspection time to find how many calendar days before the need date an order must be released.
- MRP Planned Order Release Date CalculatorBack-schedule a planned order from its need date using lead time, safety lead time, receiving and transit, and see whether the release date is already past.
- Blanket Purchase Order Release Schedule WorksheetTrack blanket order quantities, releases to date and the next release, with remaining balance and consumed percent calculated.
ERP fixes and how-tos
- How Sales Schedules Work in Infor LN: Releases and Cumulative QuantitiesHow sales schedules work in Infor LN: releases, firm versus planned quantities, cumulative received and shipped, and how to fix a schedule that does not match.
- How to Use the MRP Planner Workbench in SyteLineHow planners review SyteLine MRP output in the planner workbench: read exception messages, firm and release planned orders, and reschedule supply safely.
- How to Run Requirements Planning (MRP) in SYSPRORun SYSPRO Requirements Planning end to end: set planning parameters, run a regenerative or net change calculation, review action messages, and release orders.
Guides
- How to Create Production Orders in Infor SyteLineStep-by-step guide to creating and managing production orders in Infor SyteLine CloudSuite Industrial, including job orders, planned orders, and firming workflows.
- When SyteLine MRP Is Not Generating Planned OrdersSyteLine MRP not generating planned orders? Work through item planning flags, horizon and cutoff dates, order policy, existing supply, and failed planning runs.
- Infor LN Freeze/Unfreeze Planning: Frozen Zones and Time Fences ExplainedHow Infor LN freeze and unfreeze planning works: frozen zones, time fences, firm planned orders, and Enterprise Planning settings that stop MRP nervousness.