# Planned Order Release Schedule Worksheet

> Source: https://netray.co/tools/planned-order-release-schedule-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Track planned and firm planned orders to convert or release, with quantities, dates and extended cost. Edit rows and export to Excel.

## Category

supply-chain

## Audience

- Production planner
- Buyer
- MRP controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Part number

**Key:** part

**Type:** text

#### Description

**Key:** desc

**Type:** text

#### Order type

**Key:** type

**Type:** select

**Options:**

- Planned
- Firm planned

#### Release action

**Key:** action

**Type:** select

**Options:**

- Convert to PO
- Convert to WO
- Hold
- Reschedule

#### Quantity

**Key:** qty

**Type:** number

#### Unit cost

**Key:** unit_cost

**Type:** number

**Format:** currency

#### Lead time

**Key:** lead

**Type:** number

**Unit:** days

#### Release by

**Key:** release

**Type:** date

#### Extended value

**Key:** ext

**Type:** number

**Expr:** qty * unit_cost

**Format:** currency

**Rows:**

**Part:** PN-48213

**Desc:** Housing, cast

**Type:** Planned

**Action:** Convert to PO

**Qty:** 120

**Unit cost:** 18.4

**Lead:** 35

**Release:** 2026-10-22

**Part:** PN-51002

**Desc:** Shaft, ground

**Type:** Firm planned

**Action:** Convert to WO

**Qty:** 200

**Unit cost:** 6.75

**Lead:** 12

**Release:** 2026-10-26

**Part:** PN-60110

**Desc:** Bracket, formed

**Type:** Planned

**Action:** Convert to PO

**Qty:** 500

**Unit cost:** 2.1

**Lead:** 21

**Release:** 2026-10-27

**Part:** PN-77120

**Desc:** Gear, helical

**Type:** Planned

**Action:** Hold

**Qty:** 80

**Unit cost:** 44

**Lead:** 28

**Release:** 2026-11-02

**Part:** PN-88014

**Desc:** Fastener kit

**Type:** Planned

**Action:** Reschedule

**Qty:** 1000

**Unit cost:** 0.85

**Lead:** 7

**Release:** 2026-11-04

**Totals:**

#### Total quantity

**Key:** qty

**Agg:** sum

**Format:** number

#### Total value

**Key:** ext

**Agg:** sum

**Format:** currency

#### Average lead time

**Key:** lead

**Agg:** avg

**Format:** days

**Summary:**

#### Average value per order

**Key:** avg_line

**Expr:** sum_ext / count

**Format:** currency

**Notes:** 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.

## Content

**Intro:** 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.

**Sections:**

#### How to use the worksheet

**Body:** 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.

**Bullets:**

- 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

**Body:** 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

**Body:** 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.

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

**Faq:**

#### How often should I convert planned orders?

**Answer:** 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?

**Answer:** 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?

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

#### Why show value?

**Answer:** 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.

## Search terms

planned order release schedule excel, planned order conversion worksheet, mrp planned order tracker, firm planned order list template, release schedule planner spreadsheet, planned orders to purchase requisitions, weekly release plan template

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json