Purpose of the lesson

Use production material-requirements plans and warehouse stock-order schedules to prepare accurate, complete and consolidated order schedules for each supplier.

Practical outcome

By the end of this lesson, you must be able to:

• Interpret production material-requirements plans.
• Interpret warehouse stock-order schedules.
• Allocate requirements to approved suppliers.
• Calculate appropriate order dates.
• Prepare an order schedule for each supplier.
• Consolidate compatible requirements.
• Identify procurement constraints and exceptions.
• Validate and submit the final procurement schedule.

1. Gather the required information

Obtain:

• Production material-requirements plan
• Warehouse stock-order schedule
• Approved supplier list
• Supplier agreements and catalogues
• Product and material specifications
• Current inventory information
• Open purchase orders
• Supplier lead times
• Minimum order quantities
• Pack sizes
• Agreed prices
• Delivery calendars
• Supplier capacities
• Required delivery dates
• Procurement approval requirements
• Budget information

Confirm that all source documents cover the same planning period and use the correct product or material codes.

2. Review production material requirements

Examine the material-requirements plan for each production line.

Confirm:

• Production-order reference
• Production line
• Material code
• Material description
• Gross requirement
• Available quantity
• Confirmed incoming stock
• Net requirement
• Required-at-production date
• Approved supplier
• Quality or technical specification

Production requirement example

Do not create another order for quantities already covered by an approved open purchase order.

3. Convert material requirements into supplier-order requirements

Allocate each net requirement to an approved supplier.

Consider:

• Supplier authorisation
• Product specification
• Contract allocation
• Supplier capacity
• Agreed lead time
• Minimum order quantity
• Pack size
• Price
• Quality performance
• Delivery reliability
• Required delivery date

Production-to-supplier schedule

Schedule delivery early enough to allow receiving, inspection and internal movement before production begins.

4. Review warehouse stock orders

Examine the stock-order schedule received from each warehouse.

Confirm:

• Warehouse or facility
• SKU
• Required quantity
• Current stock position
• Reorder requirement
• Existing purchase orders
• Required delivery date
• Supplier allocation
• Delivery location

Warehouse requirement example

Verify the calculation and investigate unusual quantities before including them in the procurement schedule.

5. Determine the order date

Work backwards from the required delivery date.

Consider:

• Supplier lead time
• Internal approval time
• Purchase-order processing
• Transport time
• Customs or import requirements
• Receiving and inspection time
• Weekends and public holidays
• Contingency time for critical materials

Use:

Latest order date = Required delivery date − Total procurement lead time

Example:

• Required delivery date: 30 August
• Supplier production time: 7 working days
• Transport time: 3 working days
• Receiving and inspection: 1 working day

Total procurement lead time = 11 working days

Place the order at least 11 working days before the required delivery date.

6. Apply order-quantity rules

Adjust requirements where necessary to comply with:

• Minimum order quantity
• Standard pack size
• Pallet quantity
• Economic order quantity
• Contracted order multiples
• Supplier transport requirements

Example:

• Net requirement: 460 units
• Standard pack size: 50 units

Order 500 units, because 460 cannot be ordered in complete packs of 50.

Record the additional 40 units as expected inventory rather than concealing the difference.

7. Consolidate requirements by supplier

Combine production and warehouse requirements where they relate to:

• The same supplier
• The same product or material
• Compatible delivery dates
• Compatible delivery destinations
• The same contractual conditions

Consolidation example

Use the earliest required date unless separate deliveries provide better operational and cost outcomes.

Consolidation can:

• Reduce administrative work
• Improve transport utilisation
• Meet minimum-order quantities
• Strengthen purchasing leverage
• Reduce duplicated orders

Do not consolidate requirements where this would delay critical materials, exceed storage capacity or create excessive inventory.

8. Prepare the supplier-order schedule

Create a complete schedule for each supplier.

Include:

• Supplier name and code
• Product or material code
• Description and specification
• Consolidated quantity
• Unit of measure
• Order date
• Required delivery date
• Delivery location
• Agreed price
• Purchase-order reference
• Production line or warehouse
• Contract reference
• Order status
• Special instructions

9. Check budget and order value

Calculate:

Order value = Order quantity × Unit price

If 1,200 units cost R50 each:

Order value = 1,200 × R50 = R60,000

Add relevant transport, taxes or other approved costs where applicable.

Compare the value with:

• Available budget
• Contract limits
• Approval thresholds
• Supplier agreement
• Total planned procurement expenditure

Escalate any budget shortfall or unauthorised price difference.

10. Identify procurement constraints

Check for:

• Insufficient supplier capacity
• Lead time longer than available time
• Minimum-order conflicts
• Budget limitations
• Unapproved suppliers
• Incomplete specifications
• Supplier shutdown periods
• Price discrepancies
• Import or transport delays
• Poor supplier performance
• Duplicate orders
• Delivery-date conflicts
• Limited receiving or storage capacity

Procurement constraint register

11. Revise the procurement schedule

Where the initial schedule is not feasible:

1. Verify the constraint.
2. Identify affected production or warehouse requirements.
3. Determine the operational and cost effect.
4. Investigate approved alternatives.
5. Select and authorise the corrective action.
6. Revise the supplier-order schedule.
7. Communicate the change.
8. Monitor the revised order.

Possible actions include:

• Expedite the order.
• Use an approved alternative supplier.
• Split the order between suppliers.
• Negotiate phased deliveries.
• Transfer available stock.
• Adjust the order quantity.
• Use an approved alternative product.
• Revise the production or replenishment schedule.

12. Validate the final order schedules

Before releasing an order schedule:

1. Reconcile it with production and warehouse requirements.
2. Verify all product and material codes.
3. Check quantities and units of measure.
4. Confirm that existing orders have been considered.
5. Verify supplier authorisation.
6. Confirm prices and contract terms.
7. Recalculate order and delivery dates.
8. Check minimum quantities and pack sizes.
9. Confirm budget and approval.
10. Check delivery locations and instructions.
11. Resolve or record outstanding exceptions.
12. Obtain the required authorisation.

The final schedules must be accurate and complete for every supplier.

13. Monitor supplier orders

After placing the orders:

• Obtain supplier acknowledgement.
• Confirm quantities and delivery dates.
• Track production or preparation progress.
• Monitor transport status.
• Record delays or shortages.
• Update production and warehouse teams.
• Expedite critical orders where authorised.
• Confirm delivery and receipt.
• Record supplier performance.
• Close completed orders.

Order-tracking schedule

Practical task

You are provided with a case study containing a stock-replenishment plan and production material requirements.

Complete the following:

1. Review the production material-requirements plan.
2. Translate the production requirements into order requirements by supplier.
3. Review the warehouse stock-order schedule.
4. Translate warehouse requirements into order requirements by supplier.
5. Check existing purchase orders and available stock.
6. Apply lead times, minimum quantities and pack sizes.
7. Consolidate compatible requirements for each supplier.
8. Calculate the value of each planned order.
9. Identify and resolve procurement constraints.
10. Prepare the final order schedule for every supplier.
11. Validate and submit the schedules.

Required evidence

Include the following in your Portfolio of Evidence:

• Source production material-requirements plan
• Source warehouse stock-order schedule
• Supplier and contract information used
• Lead-time and order-date calculations
• Order-quantity calculations
• Initial order requirements
• Consolidated supplier-order schedules
• Order-value and budget checks
• Procurement constraint register
• Revised schedules, where applicable
• Evidence of approval
• Supplier confirmations or tracking records
• Completed observation checklist
• Learner declaration of authenticity

Competence checklist

Lesson Summary

To prepare procurement and supply schedules, translate production material requirements and warehouse stock orders into supplier-specific purchasing requirements. Account for stock, open purchase orders, lead times, minimum quantities, pack sizes, prices and required delivery dates. Consolidate compatible requirements without delaying critical materials or creating unnecessary inventory. Resolve supplier, budget and delivery constraints, validate each schedule and monitor approved orders through to receipt. Retain the calculations, schedules, approvals and tracking records as practical evidence.