# Blanket Purchase Order Release Schedule Worksheet > Source: https://netray.co/tools/blanket-purchase-order-release-schedule-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Track blanket order quantities, releases to date and the next release, with remaining balance and consumed percent calculated. ## Category supply-chain ## Audience - Materials planner - Buyer - Procurement ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Blanket PO **Key:** po **Type:** text #### Part number **Key:** part **Type:** text #### Supplier **Key:** supplier **Type:** text #### Blanket qty **Key:** total_qty **Type:** number #### Released to date **Key:** released **Type:** number #### Remaining **Key:** remaining **Type:** number **Expr:** total_qty - released **Format:** integer #### Consumed **Key:** consumed **Type:** number **Expr:** if(gt(total_qty, 0), released / total_qty * 100, 0) **Format:** percent #### Next release qty **Key:** next_qty **Type:** number #### Unit price **Key:** price **Type:** number **Format:** currency #### Next release value **Key:** next_value **Type:** number **Expr:** next_qty * price **Format:** currency #### Next release date **Key:** next_date **Type:** date #### Blanket expiry **Key:** expiry **Type:** date **Rows:** **Po:** BPO-5101 **Part:** BRK-1001 **Supplier:** Kestrel Fasteners **Total qty:** 12000 **Released:** 7200 **Next qty:** 1200 **Price:** 1.85 **Next date:** 2026-11-02 **Expiry:** 2027-03-31 **Po:** BPO-5102 **Part:** SEAL-0412 **Supplier:** Marlow Rubber **Total qty:** 20000 **Released:** 18500 **Next qty:** 1500 **Price:** 0.62 **Next date:** 2026-10-28 **Expiry:** 2026-12-31 **Po:** BPO-5107 **Part:** CBL-3300 **Supplier:** Tamsin Wire **Total qty:** 6000 **Released:** 1500 **Next qty:** 500 **Price:** 4.1 **Next date:** 2026-11-09 **Expiry:** 2027-06-30 **Po:** BPO-5110 **Part:** PKG-0880 **Supplier:** Corvid Packaging **Total qty:** 30000 **Released:** 9000 **Next qty:** 3000 **Price:** 0.28 **Next date:** 2026-11-16 **Expiry:** 2027-01-31 **Totals:** #### Total remaining units **Key:** remaining **Agg:** sum **Format:** integer #### Total value of next releases **Key:** next_value **Agg:** sum **Format:** currency #### Highest consumed **Key:** consumed **Agg:** max **Format:** percent **Summary:** #### Average percent consumed **Key:** avg_consumed **Expr:** avg_consumed **Format:** percent **Primary:** true **Notes:** Compare each row's remaining quantity against demand until the expiry date. A blanket that will run out before expiry needs an amendment; one that will not be used needs a review. ## Content **Intro:** Blanket orders and scheduling agreements lock in price and capacity, but the release schedule is easy to lose track of. This worksheet shows what is left on each blanket and what the next release will cost. **Sections:** #### How to use the worksheet **Body:** Enter one row per blanket order line. Put the total committed quantity and the quantity released so far; the sheet works out the remaining balance and the percent consumed. Enter the next planned release and its date, and the worksheet computes the release value so you can see the cash impact. Review the list weekly with your planners, not only when a supplier calls. #### What to look for **Body:** A blanket that is nearly consumed well before its expiry date will run dry and force a spot buy at a worse price. A blanket with a low consumed percent near expiry means you committed to more than you used, which may carry a take-or-pay obligation depending on the terms. Read the contract: some blankets let the supplier invoice unused quantity, others simply lapse. **Bullets:** - Over 80 percent consumed: plan the amendment now - Low consumption near expiry: discuss extension or cancellation terms - Check price breaks: releases often carry the blanket price only inside the term #### ERP equivalents **Body:** In SAP the equivalent is a scheduling agreement or contract with releases against it. In Oracle EBS it is a blanket purchase agreement with releases, in NetSuite a blanket purchase order, and in Dynamics 365 a purchase agreement. Each system tracks released quantity, so use the ERP as the source and this worksheet as the planner's review view. #### Common mistakes **Body:** Releasing against the wrong blanket when two exist for the same part, forgetting the expiry date, and letting releases run above the committed quantity without an amendment are the usual failures. Another is releasing in lumps that do not match the supplier's ship pattern, which inflates inventory and the supplier's cost. **Cta:** If you manage hundreds of blankets and releases, we can build alerts from your ERP data for near-expiry and near-exhaustion blankets. **Faq:** #### What is the difference between a blanket order and a scheduling agreement? **Answer:** A blanket order commits to a total quantity or value over a period with releases called as needed. A scheduling agreement, common in SAP, also carries a delivery schedule the supplier follows. Both fix price and terms for repeated purchases. #### Can releases exceed the blanket quantity? **Answer:** Only with an amendment or a new agreement. Most ERPs warn or block over-release, but some do not, so check the remaining balance before releasing and confirm tolerance with the supplier. #### How often should releases be reviewed? **Answer:** Weekly for fast-moving parts and monthly for slow ones. Review against the MRP forecast so the release quantity matches expected need, not just the supplier's preferred batch. #### Do blankets reduce lead time? **Answer:** They can, because the supplier plans capacity against a known commitment. The benefit depends on terms, so record the agreed release lead time in your item master after negotiation. ## Search terms blanket purchase order tracking excel, blanket po release schedule, blanket order template, scheduling agreement release tracker, blanket po balance, blanket order remaining quantity --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json