Coterie Supply Chain Management

Menu
Menu

DATA INTEGRITY IS ESSENTIAL FOR MANUFACTURING ENTITIES

To ensure plans are accurate in support of decision making, data integrity is essential on all information systems in use.

PLANNING PARAMETERS FOR mrp

These parameters include those in the item master such as lead times, pricing, lot sizes, MOQs etc. These parameters determine to a large degree the accuracy of any MRP output generated from your MPS.

The 3 core inputs for MRP:

  1. Master Production Schedule (MPS)
  2. Bills of Materials (BOMs)
  3. Inventory Status File/Current Inventory Levels

Supporting Factors:

  1. Demand Forecasts
  2. Supplier Lead Times
  3. Manufacturing Cycle Times and Routings
  4. Lot Sizing Rules

Companies who are utilising MRP but are not convinced their data is accurate are at risk of ordering too much, too little, or the incorrect items. This not only raises costs, lead times, and workload, it also affects customer OTIF and supplier production plans.

CAPACITY REQUIREMENT PLANNING (CRP)

Capacity requirement planning requires combining data on planned production orders, specific routing steps, work centre limits and available labour or machine hours. 

The core information required includes the following:

  1. Planned orders and production schedules generated by MRP
  2. Bills of Materials
  3.  Routing Files
  4. Work Centre Capacity Data
  5. Labour and Staffing Information
  6. Downtime and Maintenance Schedule

This provides a data driven method to verify whether available resources can handle scheduled workloads. This provides the following benefits to an organisation:

  1. Resource Optimisation
  2. Bottleneck Prevention
  3.  Cost Control
  4. Reliable delivery (OTIF)

PLANNING AND SCHEDULING OPTIMISATION (PSO)

Scheduling Optimisation systems require a much richer source of information to calculate efficient resource allocations.

Available Resources:

  • Staff – Skill sets, certifications, shift patterns, home locations
  • Equipment and Assets – Machine capacity, tools, vehicle types, maintenance downtime
  • Materials and Inventory -Stock levels and availability to ensure job doesn’t start before part availability.
Hard Operating Constraints:
  • Labour Regulations – Legal limits on working hours, rest periods, union rules, overtime restrictions
  • Physical and Access Limits – Travel time between stops, geographic boundaries, facility closing hours
  • Capacity Caps – Maximum throughput for assembly lines, warehouse storage limits
Soft Constaints
  • Employee Preferences – Shift swaps, preferred work days, requested time off
  • Customer Priorities – Service level agreements (SLA), VIP Customer windows, preferred appointment slots

Demand and Workload Data

  • Forecasted workload – Production volume targets
  • Realtime Disruption Feeds – Traffic, cancellations, emergency calls, unannounced staff absences

Business Objectives and Metrics

  • Financial Data – Hourly wage rates, overtime costs, fuel/mileage expenses, material overhead
  • Performance Targets – Minimising empty mileage, reducing idle machine time, lowering labour costs, maximising customer satisfaction scores

 

 

 
 

Get in touch to discuss Data Integrity in your business

Accurate demand forecasts can add massive amounts of profit to your bottom line

Scroll to Top