Material Requirements Planning Overview
Material Requirements Planning Overview
Course Notes
Lecture #2.A
Material Requirements Planning
IE 376
Bilkent University
Manufacturing Planning and Control System
Resource Sales and operations Demand
planning planning management
6-2
Materials Requirements Planning (MRP)
• Computer based information system to handle
ordering and scheduling of dependent demand items
• It has been the most widely implemented large scale
production management system with several thousand
systems implemented in industry around the world.
MRP converts the production plan for final products into
requirements for component items and raw materials:
• What is needed
• When is needed
• How much is needed
When should procurement, fabrication, assembly start
for completing end items on time
Procurement of
Fabrication
raw material D
of part E Subassembly A
Final assembly
Procurement of and inspection
raw material F Procurement of
part C
Procurement of Procurement of
raw material G part H Subassembly B
1 2 3 4 5 6 7 8 9 10 11
Traditional Inventory Control Approaches
Demand
Demand
“Lumpy” demand
Stable demand
Amount on hand
Amount on hand
Time Time
Safety stock
Time Time
Inventory Control MRP System
• Part oriented • Product/component oriented
• Replenish Supply • Actual requirements
• Independent demand • Dependent (derived) demand
• Continuous item demand • Discrete/lumpy item demand
• Random demand pattern • Known lumpy demand pattern
• Continuous lead time
demand • No lead time demand
• Reorder point ordering
signal • Time-phased ordering signal
• Historical demand base
• Forecast all items • Future production base
• Forecast master schedule
• Quantity based system items
• Quantity and time-based
system
Observations
• From control of the level of stock
to discrete control on the flow of material
(MRP orders only what components are required to maintain
manufacturing flow)
• MRP tells user what must be done in order to meet the master schedule, as
opposed to what can be done.
Master Production
Schedule (MPS)
Master Parts Bill of Materials
Database (BOM)
3. Infinite capacity.
Open Orders
Inputs
– Master Production Schedule (MPS): due dates
and quantities for all top level items
– Bills of Material (BOM): for all parent items
– Inventory Status: On Hand Inventory
– Scheduled Receipts (Open orders)
• Open Purchase Orders
• Open Production Orders
– Planned Lead times: for all items
– Lot sizes and lot sizing rules
– Safety stocks and stocking policies
MRP Inputs
1 2 3 4 5 6 7 8
Aggregate
production plan 670 670
for chair family
Bill Of Materials (BOM)
A formal/systematic representation of the product structure and the
assembly steps required for its synthesis from its components and
subassemblies. 100 units
022
115 119
(3) (2)
Back Front
legs legs A
Ladder-back
chair
Bill of Materials
A
Ladder-back
chair
• Inventory on Hand
• Scheduled Receipts
• Open Purchase Orders
• Open Production Orders
• Lead time information
• Lot sizing information (policy and parameters)
• Safety stock information (policy and parameters)
(Production) Lead Times
The expected time interval between the time that the order for
a new production lot is released, and the time that the lot is
available (to be used in the fabrication of its parent component).
022
1 week
115(3) 119(2)
2 weeks 3 weeks
[1] 251
(1)
[2] 115
(3)
[2] 252
[1]
[1] (4) 022
291
(2) [3] 119
(2)
[1]
251
(1)
5 4 3 2 1
Time in weeks
Example: Time-Phased
Production Requirements
Part Week
No. 1 2 3 4 5 6 7 Lead Time
Ord. Rec. 100 1 week
022
Ord. Rel. 100
Ord. Rec. 300 2 weeks
115
Ord. Rel. 300
Ord. Rec. 200 3 weeks
119
Ord. Rel. 200
Ord. Rec. 200 300 1 week
251
Ord. Rel. 200 300
Ord. Rec. 1200 2 weeks
252
Ord. Rel. 1200
Ord. Rec. 400 1 week
291
Ord. Rel. 400
Gross Requirements
The cumulative time-phased demand for a certain part, integrating the part
demand generated from the production plans of its parent items, and also,
additional external demand, arising, for instance, from the need for spare parts,
inter-plant shipments, etc.
A B
Item A
Period 1 2 3 4 5 6 7 8 9 10 11 12
……….
Planned Ord. Rel. 30
Item B
Period 1 2 3 4 5 6 7 8 9 10 11 12
…………
Planned Ord. Rel. 30 75
Item C
Period 1 2 3 4 5 6 7 8 9 10 11 12
Gross Requirements 12 10 90 75
Level
0 Chair
1 Leg Back
Assembly Seat Assembly
3
Example (Chair Assembly)
Week Number 1 2 3 4 5 6
Part: Back Gross Requirements 100
Assembly Scheduled Receipts
LT: 1 Planned Available Balance
Net Requirements 100
Planned Order Releases 100
Week Number 1 2 3 4 5 6
Part: Back Gross Requirements 300
Support Scheduled Receipts 60
LT: 2 Planned Available Balance 20 20 20 0
Net Requirements 220
Planned Order Releases 220
C D F D H
E F E C G E C G
E F E F
Week
1 2 3 4 5 6 7 8
Gross
requirements 150 0 0 120 0 150 120 0
Scheduled
receipts 230 0 0 0 0 0 0 0
Planned
Available 37
Balance
Planned
receipts
Planned order
releases
Inventory Record
Item: C Lot Size: 230 units
Description: Seat subassembly Lead Time: 2 weeks
Week
1 2 3 4 5 6 7 8
Gross
requirements 150 0 0 120 0 150 120 0
Scheduled
receipts 230 0 0 0 0 0 0 0
Planned
Available 37
Balance
Planned
receipts Explanation:
Gross requirements are the total demand for
Planned order
the two chairs. Projected on-hand inventory
releases
in week 1 is 37 + 230 – 150
Inventory Record
Item: C Lot Size: 230 units
Description: Seat subassembly Lead Time: 2 weeks
Week
1 2 3 4 5 6 7 8
Gross
requirements 150 0 0 120 0 150 120 0
Scheduled
receipts 230 0 0 0 0 0 0 0
Planned
Available 37 117
Balance
Planned
receipts Explanation:
Gross requirements are the total demand for
Planned order
the two chairs. Projected on-hand inventory
releases
in week 1 is 37 + 230 – 150 = 117 units.
Inventory Record
Item: C Lot Size: 230 units
Description: Seat subassembly Lead Time: 2 weeks
Week
1 2 3 4 5 6 7 8
Gross
requirements 150 0 0 120 0 150 120 0
Scheduled
receipts 230 0 0 0 0 0 0 0
Planned
Available 37 117
Balance
Planned
receipts Scheduled
Planned available Inventory on Gross
or planned
balance at end of
Planned order = hand at end of + receipts in – requirements
releases week t week t - 1 in week t
week t
Inventory Record
Item: C Lot Size: 230 units
Description: Seat subassembly Lead Time: 2 weeks
Week
1 2 3 4 5 6 7 8
Gross
requirements 150 0 0 120 0 150 120 0
Scheduled
receipts 230 0 0 0 0 0 0 0
Planned
Available 37 117 117 117 –3 –3 –153 –273 –273
Balance
Planned
receipts Scheduled
Planned available Inventory on Gross
or planned
balance at end of
Planned order = hand at end of + receipts in – requirements
releases week t week t - 1 in week t
week t
Planned Orders
Explanation:
Item: C Lot Size: 230 units
Without a newSeat
Description: order in week 4,
subassembly Lead Time: 2 weeks
there will be a shortage of three
Week
units: 117 + 0 + 0 – 120 = – 3
units. 1 2 3 4 5 6 7 8
Gross
requirements 150 0 0 120 0 150 120 0
Scheduled
receipts 230 0 0 0 0 0 0 0
Planned
Available 37 117 117 117 –3 –3 –153 – 273 – 273
Balance
Planned
receipts
Planned order
releases
Planned Orders
Explanation:
Item: C Lot Size: 230 units
Adding the planned
Description: receipt
Seat subassembly Lead Time: 2 weeks
brings the balance to
Week
117 + 0 + 230 – 120 = 227 units.
1 2 3 4 5 6 7 8
Gross
requirements 150 0 0 120 0 150 120 0
Scheduled
receipts 230 0 0 0 0 0 0 0
Planned
Available 37 117 117 117 227
Balance
Planned
230
receipts
Planned order
releases
Planned Orders
Explanation:
Item: C Lot Size: 230 units
Adding the planned
Description: receipt
Seat subassembly Lead Time: 2 weeks
brings the balance to
Week
117 + 0 + 230 – 120 = 227 units.
1 2 3 4 5 6 7 8
Gross
requirements 150 0 0 120 0 150 120 0
Scheduled
receipts 230 0 0 0 0 0 0 0
Planned
Available 37 117 117 117 227
Balance
Planned
230
receipts
Planned order
releases
Planned Orders
Explanation:
Item: C Lot Size: 230 units
Offsetting for Seat
Description: a two-week lead time
subassembly Lead Time: 2 weeks
puts the corresponding planned
Week
order release back to week 2.
1 2 3 4 5 6 7 8
Gross
requirements 150 0 0 120 0 150 120 0
Scheduled
receipts 230 0 0 0 0 0 0 0
Planned
Available 37 117 117 117 227
Balance
Planned
230
receipts
Planned order
230
releases
Planned Orders
Explanation:
Item: C Lot Size: 230 units
Offsetting for Seat
Description: a two-week lead time
subassembly Lead Time: 2 weeks
puts the corresponding planned
Week
order release back to week 2.
1 2 3 4 5 6 7 8
Gross
requirements 150 0 0 120 0 150 120 0
Scheduled
receipts 230 0 0 0 0 0 0 0
Planned
Available 37 117 117 117 227
Balance
Planned
230
receipts
Planned order
230
releases
Planned Orders
Explanation:
Item: C Lot Size: 230 units
TheDescription:
first planned
Seat order lasts
subassembly Lead Time: 2 weeks
until week 7, when projected
Week
inventory would drop to – 43.
1 2 3 4 5 6 7 8
Gross
requirements 150 0 0 120 0 150 120 0
Scheduled
receipts 230 0 0 0 0 0 0 0
Planned
Available 37 117 117 117 227 227 77 –43
Balance
Planned
230
receipts
Planned order
230
releases
Planned Orders
Explanation:
Item: C Lot Size: 230 units
Adding the second
Description: planned
Seat subassembly Lead Time: 2 weeks
receipt brings the balance to
Week
77 + 0 + 230 – 120 = 187.
1 2 3 4 5 6 7 8
Gross
requirements 150 0 0 120 0 150 120 0
Scheduled
receipts 230 0 0 0 0 0 0 0
Planned
Available 37 117 117 117 227 227 77 187
Balance
Planned
230 230
receipts
Planned order
230
releases
Planned Orders
Explanation:
Item: C Lot Size: 230 units
TheDescription:
corresponding planned
Seat subassembly Lead Time: 2 weeks
order release is for week 5.
Week
1 2 3 4 5 6 7 8
Gross
requirements 150 0 0 120 0 150 120 0
Scheduled
receipts 230 0 0 0 0 0 0 0
Planned
Available 37 117 117 117 227 227 77 187
Balance
Planned
230 230
receipts
Planned order
230 230
releases
Planned Orders
Item: C Lot Size: 230 units
Description: Seat subassembly Lead Time: 2 weeks
Week
1 2 3 4 5 6 7 8
Gross
requirements 150 0 0 120 0 150 120 0
Scheduled
receipts 230 0 0 0 0 0 0 0
Planned
Available 37 117 117 117 227 227 77 187 187
Balance
Planned
230 230
receipts
Planned order
230 230
releases
Explosion
Explosion–the process of translating product
requirements into component part requirements
⚫ Considers existing inventories and scheduled
receipts
Calculating the quantities of all components
needed to satisfy requirements for any given
part.
⚫ Continued until all parts have been considered,
leading to exact requirements for all purchased
and/or raw material parts
6-47
The “MRP Explosion” Calculus
mater al requ rements External Demand
plann ng
Level 0
Initial
Inventories
Level 1
Capacity
Planning
Level 2
Scheduled
Receipts
Level N
Planned
Gross Requirements Order Releases
MRP Explosion
Item: Seat subassembly
Lot size: 230 units
Week
Lead
time: 2 weeks 1 2 3 4 5 6 7 8
Gross
requirements 150 0 0 120 0 150 120 0
Scheduled
receipts 230 0 0 0 0 0 0 0
Planned
Available 37 117 117 117 227 227 77 187 187
Balance
Planned
230 230
receipts
Planned order
230 230
releases
MRP Explosion
Item: Seat subassembly
Lot size: 230 units
Week
Lead
time: 2 weeks 1 2 3 4 5 6 7 8
Gross
150 0 0 120 0 150 120 0
requirements
Planned
230 230
receipts
Planned
order 230 230
releases
Week Week
Lead Lead
time: 1 week 1 2 3 4 5 6 7 8 time: 1 week 1 2 3 4 5 6 7 8
Gross Gross
requirements requirements
Scheduled Scheduled
0 300 0 0 0 0 0 0 0 0 0 0 0 0 0 0
receipts receipts
Planned Planned
Available 40 Available 0
Balance Balance
Planned Planned
receipts receipts
Planned Planned
order order
releases releases
MRP Explosion
Item: Seat subassembly
Lot size: 230 units
Week
Lead
time: 2 weeks 1 2 3 4 5 6 7 8
Gross
150 0 0 120 0 150 120 0
requirements
Planned
230 230
receipts
Planned
order 230 230
releases
Week Week
Lead Lead
time: 1 week 1 2 3 4 5 6 7 8 time: 1 week 1 2 3 4 5 6 7 8
Gross Gross
0 230 0 230
requirements requirements
Scheduled Scheduled
0 300 0 0 0 0 0 0 0 0 0 0 0 0 0 0
receipts receipts
Planned Planned
Available 40 Available 0
Balance Balance
Planned Planned
receipts receipts
Planned Planned
order order
releases releases
MRP Explosion Item: Seat subassembly
Lot size: 230 units
Week
Lead
time: 2 weeks 1 2 3 4 5 6 7 8
Gross
150 0 0 120 0 150 120 0
requirements
Planned
230 230
receipts
Planned
order 230 230
releases
Week Week
Lead Lead
time: 1 week 1 2 3 4 5 6 7 8 time: 1 week 1 2 3 4 5 6 7 8
Gross Gross
0 230 0 0 230 0 230 0 0 230
requirements requirements
Scheduled Scheduled
0 300 0 0 0 0 0 0 0 0 0 0 0 0 0 0
receipts receipts
Planned Planned
Available 40 Available 0
Balance Balance
Planned Planned
receipts receipts
Planned Planned
order order
releases releases
MRP Explosion
Item: Seat subassembly
Lot size: 230 units
Week
Lead
time: 2 weeks 1 2 3 4 5 6 7 8
Gross
150 0 0 120 0 150 120 0
requirements
Planned
230 230
receipts
Planned
order 230 230
releases
Week Week
Lead Lead
time: 1 week 1 2 3 4 5 6 7 8 time: 1 week 1 2 3 4 5 6 7 8
Gross Gross
0 230 0 0 230 0 0 0 0 230 0 0 230 0 0 0
requirements requirements
Scheduled Scheduled
0 300 0 0 0 0 0 0 0 0 0 0 0 0 0 0
receipts receipts
Planned Planned
Available 40 40 110 110 110 180 180 180 180 Available 0 0 0 0 0 0 0 0 0
Balance Balance
Planned Planned
300 230 230
receipts receipts
Planned Planned
order 300 order 230 230
releases releases
MRP Explosion
Item: Seat frames Item: Seat cushion
Lot size: 300 units Lot size: L4L
Week Week
Lead Lead
time: 1 week 1 2 3 4 5 6 7 8 time: 1 week 1 2 3 4 5 6 7 8
Gross Gross
0 230 0 0 230 0 0 0 0 230 0 0 230 0 0 0
requirements requirements
Planned Planned
300 230 230
receipts receipts
Planned Planned
order 300 order 230 230
releases releases
Week
Lead
time: 1 week 1 2 3 4 5 6 7 8
Gross
requirements
Scheduled
0 0 0 0 0 0 0 0
receipts
Planned
Available 200
Balance
Planned
receipts
Planned
order
releases
MRP Explosion
Item: Seat frames Item: Seat cushion
Lot size: 300 units Lot size: L4L
Week Week
Lead Lead
time: 1 week 1 2 3 4 5 6 7 8 time: 1 week 1 2 3 4 5 6 7 8
Gross Gross
0 230 0 0 230 0 0 0 0 230 0 0 230 0 0 0
requirements requirements
Planned Planned
300 230 230
receipts receipts
Planned Planned
order 300 order 230 230
releases releases
Usage quantity: 4
Item: Seat-frame boards
Lot size: 1500 units
Week
Lead
time: 1 week 1 2 3 4 5 6 7 8
Gross
0 0 0 1200 0 0 0 0
requirements
Scheduled
0 0 0 0 0 0 0 0
receipts
Planned
Available 200
Balance
Planned
receipts
Planned
order
releases
MRP Explosion
Item: Seat frames Item: Seat cushion
Lot size: 300 units Lot size: L4L
Week Week
Lead Lead
time: 1 week 1 2 3 4 5 6 7 8 time: 1 week 1 2 3 4 5 6 7 8
Gross Gross
0 230 0 0 230 0 0 0 0 230 0 0 230 0 0 0
requirements requirements
Planned Planned
300 230 230
receipts receipts
Planned Planned
order 300 order 230 230
releases releases
Week
Lead
time: 1 week 1 2 3 4 5 6 7 8
Gross
0 0 0 1200 0 0 0 0
requirements
Scheduled
0 0 0 0 0 0 0 0
receipts
Planned
Available 200 200 200 200 500 500 500 500 500
Balance
Planned
1500
receipts
Planned
order 1500
releases
Example: The (complete) MRP
Explosion Calculus
s
algor thm
Item BOM: stra ghtfırıl
Alpha Item Lead Time Current Inv. Pos.
Alpha 1 10
B 2 20
B(1) C(1) C 3 0
D 1 100
E 1 10
F 1 50
D(2) C(2) E(1) F(1)
Item Levels:
MPS
Tested Yoga 4
MPS
Weeks 1 2 3 4 5 6
Dates Feb 14- Feb 21- Feb 28- Mar 07- Mar 14- Mar 21-
Feb 20 Feb 27 Mar 06 Mar 13 Mar 20 Mar 27
Gross Requirements 40 30 40 50 40 50
Inventory Rec ERP Scheduled Receipts 50
Location Item Qty
Projected Available Bal 80 40 10 20 0 0 0
Depot Yoga 4 80
Planned Order Receipts 30 40 50
Planned Order Release 30 40 50
Yoga 4
Testing is Production (Work) Order ERP
done
internally Prod Ord No Work Center Item Quantity Start Date End Date
(“in house”) 87004 Testing Yoga 4 50 Feb 7, 2025 Feb 28, 2025
MRP and Transactions – Production
Weeks 1 2 3 4 5 6
Packaged Yoga 4
MPS Dates Feb 14- Feb 21- Feb 28- Mar 07- Mar 14- Mar 21-
Feb 20 Feb 27 Mar 06 Mar 13 Mar 20 Mar 27
Tested Yoga 4
MRP
Weeks 1 2 3 4 5 6
Dates Feb 14- Feb 21- Feb 28- Mar 07- Mar 14- Mar 21-
Feb 20 Feb 27 Mar 06 Mar 13 Mar 20 Mar 27
Gross Requirements 40 30 40 50 40 50
Scheduled Receipts 50
Projected Available Bal 80 40 10 20 0 0 0
Planned Order Receipts 30 40 50
Planned Order Release 30🗸 40 50
Tested Yoga 4
MRP
Weeks 2 3 4 5 6 7
Dates Feb 21- Feb 28- Mar 07- Mar 14- Mar 21- Mar 28-
Feb 27 Mar 06 Mar 13 Mar 20 Mar 27 Apr 04
Gross Requirements 30 40 50 35 50 60
Inventory Rec ERP Scheduled Receipts 50 30
Location Item Qty
Projected Available Bal 40 10 20 0
Depot Tested 40
Yoga 4 Planned Order Receipts 35 50 60
Planned Order Release 35 50 60
Production (Work) Order ERP
Prod Ord No Work Center Item Quantity Start Date End Date
87004 Testing Yoga 4 50 Feb 7, 2025 Feb 28, 2025
Tested Yoga 4
MRP
Weeks 1 2 3 4 5 6
Dates Feb 14- Feb 21- Feb 28- Mar 07- Mar 14- Mar 21-
Feb 20 Feb 27 Mar 06 Mar 13 Mar 20 Mar 27
Gross Requirements 40 30 40 50 40 50
Inventory Rec ERP Scheduled Receipts 50
Location Item Qty
Projected Available Bal 80 40 10 20 0 0 0
Depot Tested 80
Yoga 4 Planned Order Receipts 30 40 50
Planned Order Release 30 40 50
Yoga 4
Testing is Purchase Order ERP
done by a Purchase Ord No Vendor Item Quantity Start Date End Date
supplier
92012 Lenovo Europe Yoga 4 50 Feb 7, 2025 Feb 28, 2025
MRP and Transactions - Purchasing
Weeks 1 2 3 4 5 6
Packaged Yoga 4
MPS Dates Feb 14- Feb 21- Feb 28- Mar 07- Mar 14- Mar 21-
Feb 20 Feb 27 Mar 06 Mar 13 Mar 20 Mar 27
Tested Yoga 4
MRP
Weeks 1 2 3 4 5 6
Dates Feb 14- Feb 21- Feb 28- Mar 07- Mar 14- Mar 21-
Feb 20 Feb 27 Mar 06 Mar 13 Mar 20 Mar 27
Gross Requirements 40 30 40 50 40 50
Scheduled Receipts 50
Projected Available Bal 80 40 10 20 0 0 0
Planned Order Receipts 30 40 50
Planned Order Release 30🗸 40 50
92013 Lenovo Europe Yoga 4 30 Feb 14, 2025 Mar 07, 2025
Material Requirements Planning
Weeks 2 3 4 5 6 7
Packaged Yoga 4
MPS Dates Feb 21- Feb 28- Mar 07- Mar 14- Mar 21- Mar 28-
Feb 27 Mar 06 Mar 13 Mar 20 Mar 27 Apr 04
Tested Yoga 4
MRP
Weeks 2 3 4 5 6 7
Dates Feb 21- Feb 28- Mar 07- Mar 14- Mar 21- Mar 28-
Feb 27 Mar 06 Mar 13 Mar 20 Mar 27 Apr 04
Gross Requirements 30 40 50 35 50 60
Inventory Rec ERP Scheduled Receipts 50 30
Location Item Qty
Projected Available Bal 40 10 20 0
Depot Tested 40
Yoga 4 Planned Order Receipts 35 50 60
Planned Order Release 35 50 60
Purchase Order ERP
Purchase Ord No Supplier Item Quantity Start Date End Date
92012 Lenovo Europe Yoga 4 50 Feb 7, 2025 Feb 28, 2025
92013 Lenovo Europe Yoga 4 30 Feb 14, 2025 Mar 07, 2025
Scheduled Receipts vs. Planned Order
Releases
• Scheduled receipts represent an actual commitment
(purchase order, production order, etc.)
• Planned orders are only the current plan and can be changed
more easily
• Scheduled receipts for production orders already have
component materials assigned
– Scheduled receipts do not impact gross requirements
• Planned order releases do not have component materials
assigned
– Planned order releases do impact gross requirements
MRP Terminology
• Gross Requirements (GR): anticipated future
usage of an item during each period
• GR(demand) are time phased, which means they
are stated on a unique period-by-period basis,
rather than aggregated or averaged.
• Scheduled Receipts (SR): existing/released orders
for an item due at the beginning of a period
• Planned Receipts (PR): planned orders for an item
due at the beginning of a period
• Projected Available Balance (PAB): projected
inventory status for an item at the end of a period
MRP Terminology
• Planned Order Releases (POR): planned
replenishment orders for an item which are
scheduled to be released at the beginning of a
period
• Net Requirements (NR): net anticipated usage of an
item during each period
• The period of the MRP time-phased record is also
called time bucket
• Number of periods in the record is called planning
horizon
• When a planned order is created for the most
immediate or current period, it is in the action
bucket
Elements of MRP
Inputs Outputs
Service-Parts Inventory
Orders and Transaction Data
Forecasts
Order Changes
Inventory Order
Planned Order
and SRs Schedule
Master MRP
Production System Planning
Schedule Report
Performance
Exception
Bill of
Materials File Reports
IE 376
PRODUCTION INFORMATION SYSTEMS
Course Notes
Lecture # 2.B
The Use of the MRP System
IE 376
Bilkent University
The use of the MRP system
1. Single-level explosion
2. Indented explosion
3. Summary explosion
4. Single-level implosion
5. Indented implosion
6. Summary implosion
Example: Multilevel product structure
A Level 0
Quantity Unit of
Assembly Component Description Required Measure
A 10 5
20 1
30 4
40 1
50 1
(B) (1)
(C) (1)
(D) (2)
4. Single-level implosion BOM for components 10, 20, 30, 40, and 50
Component Assembly
Part number Used on Quantity Description
30 D 1
. B 2
. . A 1
C 2
. A 1
6. Summary implosion BOM for components D, 10, and 30
3300-113-_ _
Mirror
3300-500-_ _
• Effective dates
– Due to engineering changes, components that are used in end items
or subassemblies may change
– These changes are reported through engineering change orders
– The information should be maintained in the bill of materials in the
manufacturing database
– For the assembly of product X,
• Use part Y1 between 01-09-2021 and 01-04-2022
• Use part Y2 between 01-04-2022 and 01-01-2023
• Alternative components, substitution possibilities
– For the assembly of product X,
• Use part Y1 if available
• Otherwise use part Y2
Low-level coding
A Level 0
end items
MPS
options
components
Planning Bill of Materials
• 3 frame options
• 5 gearing options
• 3 handlebar options
• 2 water bottle options (yes or no)
• “Common parts”
Bicycle
--- 12-speed
--- 15-speed
Super Bill!
Bicycle example
Bicycle
• Planned events
• Unplanned events
– New order in MPS
– Order completed late
– Scrap loss
– Engineering changes in BOM
Computational cost
versus
Maintaining the validity of requirements plan
Top-down replanning
Problem
• Scheduled receipt in week 3 is not needed until week 4.
• The due date needs to be changed for this order, otherwise the order may
be worked ahead of another order that is really needed earlier
• The problem will be reported by an MRP exception message ”Reschedule
the receipt currently due in week 3 to week 4”
Bottom-up replanning
1 2 3 4 5 6 7 8 9 10
Top Handle Gross Requirements 20 10 20 5 35 10
Assembly
Scheduled Receipts
Projected Available Balance 25 25 5 5 0 0 0 0 0 0 0
Lead Time =2
Planned Order Receipts 5 20 5 35 10
Planned Order Releases 5 20 5 35 10
Procurement of Fabrication
raw material D of part E Subassembly A
Final assembly
Procurement of and inspection
raw material F Procurement of
part C
Procurement of Procurement of
raw material G part H Subassembly B
1 2 3 4 5 6 7 8 9 10 11
Safety stocks and safety lead times
• Safety stocks:
– generate net requirements to ensure minimum level of
inventory at all times
– used as hedge against quantity uncertainty (e.g., yield
loss)
• Safety lead times:
– inflate production lead times in part record
– used as hedge against timing uncertainty (e.g., delivery
delays)
Safety stocks
Week 1 2 3 4 5 6
Gross Requirements 400 200 800
Scheduled Receipts 500
Planned Available Balance 100 100 20 20 20
Planned Order Receipts 120 800
Planned Order Releases 120 800
4
MRP planner tasks
• Purchase orders
Release • Shop floor (production) orders
Reconcile • Identify errors and inconsistencies and eliminate their root causes
Exception messages
IE 376
PRODUCTION INFORMATION SYSTEMS
Course Notes
Lecture #3
Lot Sizing in MRP
IE 376
Bilkent University
IE 376
Criticisms of EOQ
Week
1 2 3 4 5 6 7 8
Net Requirements 1000 0 1300 800 1200 1300 0 800
It costs $400 to change over the machines for this material in the
affected work center. It costs $0.40 per unit when one unit of this
material must be carried in inventory from one week to the next.
Identify the lot-sizing method that results in the least carrying and
changeover costs for the 8-week schedule.
IE 376
Lot-for-Lot Method
Week
1 2 3 4 5 6 7 8
Net Requirements 1000 0 1300 800 1200 1300 0 800
Beginning Inventory 0 0 0 0 0 0 0 0
Production Lots 1000 0 1300 800 1200 1300 0 800
Ending Inventory 0 0 0 0 0 0 0 0
K = $400.00
2 KD 2(40,000)(400)
EOQ = = = 1265
h 20
IE 376
Week
1 2 3 4 5 6 7 8
Net Requirements 1000 0 1300 800 1200 1300 0 800
Beginning Inventory 0 265 265 230 695 760 725 725
Production Lots 1265 0 1265 1265 1265 1265 0 1265
Ending Inventory 265 265 230 695 760 725 725 1190
= 50/(D/EOQ)
= 50/(40,000/1,265)
= 1.58 or 2 weeks
IE 376
Week
1 2 3 4 5 6 7 8
Net Requirements 1000 0 1300 800 1200 1300 0 800
Beginning Inventory 0 0 0 800 0 1300 0 800
Production Lots 1000 0 2100 0 2500 0 800 0
Ending Inventory 0 0 800 0 1300 0 800 0
t 1 2 3 4 5 6 7 8 9 10
Net Requirements 20 50 10 50 50 10 20 40 20 30
Wagner-Whitin 80 0 0 130 0 0 0 90 0 0
Ending Inventory 60 10 0 80 30 20 0 50 30 0
K = $100.00
ഥ = (300/10) = 30
𝐷
h = $1.00/unit/week
t 1 2 3 4 5 6 7 8 9 10
Net Requirements 20 50 10 50 50 10 20 40 20 30
Lot-for-Lot 20 50 10 50 50 10 20 40 20 30
K = $100.00
ഥ = (300/10) = 30
𝐷
h = $1.00/unit/week
t 1 2 3 4 5 6 7 8 9 10
Net Requirements 20 50 10 50 50 10 20 40 20 30
EOQ 77 0 77 0 77 0 0 77 0 0
Ending Inventory 57 7 74 24 51 41 21 58 38 8
K = $100.00 2 KD 2 100 30
ഥ = (300/10) = 30
𝐷 Q= = = 77
h = $1.00/unit/week h 1
t 1 2 3 4 5 6 7 8 9 10
Net Requirements 20 50 10 50 50 10 20 40 20 30
POQ 80 0 0 110 0 0 80 0 0 30
Ending Inventory 60 10 0 60 10 0 60 20 0 0
K = $100.00
ഥ = (300/10) = 30
𝐷 Time between orders = 77/30
h = $1.00/unit/week approximately 3 weeks
EE
IE 376
Step 2: Tentatively add the next period’s requirements to this lot. Call
this period L.
Step 4: Compare the total carrying cost for this lot to the setup cost.
If the total carrying cost is less than the setup cost, then go to step 2.
t 1 2 3 4 5 6 7 8 9 10 11 12
Net Requirements 124 60 316 183 0 55 43 154 0 0 114 171
K = $100.00
h = $0.21/unit/week
Since 145.32 is closer to 100 than 12.6, the lot size should be 500.
IE 376
K = $100.00
h = $0.21/unit/week
Since 50.19 is closer to 100 than 179.55, the lot size should be 281.
IE 376
t 1 2 3 4 5 6 7 8 9 10 11 12
Net Requirements 124 60 316 183 0 55 43 154 0 0 114 171
PPB 500 0 0 281 0 0 0 268 0 0 0 171
Ending Inventory 376 316 0 98 98 43 0 114 114 114 0 0
K = $100.00
h = $0.21/unit/week
Silver-Meal Heuristic
• Decision criterion:
(Setup cost + Total carrying cost until end of period T)/T
Silver-Meal Heuristic
Step 2: Tentatively add the next period’s requirements to this lot. Call
this period L.
Step 3: Calculate the total carrying cost for the lot size in step 2. Add
the setup cost and divide the resulting cost by (L – T + 1) to find
cost/period. If this cost is less than that obtained by excluding the
requirement of period L, then go to step 2.
Step 4: Lot size for the order arriving in period T is the sum of the
requirements from period T to period (L – 1).
IE 376
t 1 2 3 4 5 6 7 8 9 10 11 12
Net Requirements 124 60 316 183 0 55 43 154 0 0 114 171
K = $100.00
h = $0.21/unit/week
K = $100.00
h = $0.21/unit/week
IE 376
K = $100.00
h = $0.21/unit/week
IE 376
t 1 2 3 4 5 6 7 8 9 10 11 12
Net Requirements 124 60 316 183 0 55 43 154 0 0 114 171
PPB 184 0 597 0 0 0 0 154 0 0 285 0
Ending Inventory 60 0 281 98 98 43 0 0 0 0 171 0
K = $100.00
h = $0.21/unit/week
t 1 2 3 4 5 6 7 8 9 10 11 12
Net Requirements 124 60 316 183 0 55 43 154 0 0 114 171
LUC 500 0 0 238 0 0 197 0 0 0 285 0
Ending Inventory 376 316 0 55 55 0 154 0 0 0 171 0
K = $100.00
h = $0.21/unit/week
t 1 2 3 4 5 6 7 8 9 10 11 12
Net Requirements 124 60 316 183 0 55 43 154 0 0 114 171
Optimal Quantities 184 0 554 0 0 0 197 0 0 0 285 0
Ending Inventory 60 0 238 55 55 0 154 0 0 0 171 0
K = $100.00
h = $0.21/unit/week
Nervousness
Nervousness example
Item A (Leadtime = 2 weeks, Order Interval = 5 weeks)
Week 1 2 3 4 5 6 7 8
Gross Requirements 2 24 3 5 1 3 4 50
Scheduled Receipts
Planned available balance 28 26 2 13 8 7 4 0 0
Planned order receipts 14 50
Planned order releases 14 50
Note: Fixed Order Period (FOP) lot-sizing rule is used. When you need to
order, order enough to cover the net requirements of the next N periods.
IE 376
Nervousness example
Item A (Leadtime = 2 weeks, Order Interval = 5 weeks)
Week 1 2 3 4 5 6 7 8
Gross Requirements 2 23 3 5 1 3 4 50
Scheduled Receipts
Planned available balance 28 26 3 0 58 57 54 50 0
Planned order receipts 63
Planned order releases 63
Reducing nervousness
Course Notes
Lecture #4
Master Production Scheduling
MPS
IE 376
Bilkent University
Dealing with the Problem Complexity
through Decomposition
Corporate Strategy
Aggregate Unit Aggregate Planning
Demand (Plan. Hor.: 1 year, Time Unit: 1 month)
Aggregate
Unit Demand Aggregate
Production
Aggregate Planning Plan
(Sales and Operations Planning)
Aggregate
Unit Availability Required
(Current Inventory Production
Position) Capacity
Engine
Detailed material
planning
Master Production Scheduling (MPS)
Planning Time
Horizon unit
Capacity
Planning
Master Production Scheduling
Process and Techniques
Determine supply and demand
relationships over time (time-
phased record)
On hand 1 2 3 4 5
Forecast 5 5 8 10 15
Chase in MPS 1 2 3 4 5 6 7 8 9 10 11 12
Forecast 5 5 5 5 5 5 15 15 15 15 15 15
Available 20 20 20 20 20 20 20 20 20 20 20 20
MPS 5 5 5 5 5 5 15 15 15 15 15 15
On Hand 20
2 3 4 5 6 7 8 9 10 11 12 13
Forecast 10 10 10 10 10 15 15 15 15 15 15 15
Available 0 -10 10 0 -10 -25 -10 -25 -10 -25 -10 -25
MPS 30 30 30 30
On Hand 10
forecasts
Projected demand
orders
weeks
Available-to-Promise
ATP=20-(5+3+2)
After week 1 2 3 4 5 6 7 8 9 10 11 12 13
Forecast 10 10 10 10 10 15 15 15 15 15 15 15
Orders 5 5 2
Available 30 20 10 30 20 5 20 5 20 5 20 5
ATP 28 30 30 30 30
MPS 30 30 30 30 30
On Hand 10
ATP=(30+10)-(5+5+2)
Master Production Scheduling (MPS)
Time
Fences
Forecasted Demand
or
Available Capacity
Firm Customer
Orders