Chan Yoit Uictor
Long
Name:_____________________________ SIL 621 O
Student ID: _________________ Class: Lul
____ SCM2001
Lesson 8 Materials Requirements Planning (MRP)
(Class Exercise 5)
Problem
Product K is made according to the bill of materials (BOM) diagram shown below. 100
products K are needed in week 4, 200 in week 5, and 100 in week 8. Product K has a lead-
time of one week and no on-hand inventory. Lot-for-lot (L4L) approach is used.
A (2) B (5)
B (1) C (3) D (2)
The table below shows additional data for the items A, B, C, and D.
A B C D
Lead-time (week) 1 1 1 1
Beginning inventory (unit) 100 120 50 100
Task: Based on the given data, complete the following MRP worksheet.
MPS Data Product: K, Lead time: 1 week, On-hand inventory: 0
Week number 1 2 3 4 5 6 7 8
Required date 100 200 100
Order release date 100 200 100
Item: A Lot size: L4L units
Minimum order quantity: 250 units Lead time: 1 week
Immediate Parent(s): Safety stock: 50 units
Week number 1 2 3 4 5 6 7 8
Gross Requirements 0 0 IO0 400 0 0 IwO 0
Scheduled Receipts 0 0 0 0 0 0 0 0
Projected on hand 10 O l 00 (wo ( 50 50 50 50100 100
Net Requirements 0 0 150 300 00 200 0
0 0250
Planned order receipts 300
0 0250
0
Planned order releases 0 150200 0 0 50
L 0 0
Item: B Lot size: 300 units
Minimum order quantity: 600 units Lead time: 1 week
Immediate Parent(s): Safety stock: 0 units
Week number 1 2 3 4 5 6 7 8
Gross Requirements 0 250 分001000 0 L50 5v 。
Scheduled Receipts 0 0 0 0 0 Δ 0
0
Projected on hand 120 120 470 ⽉70 0 130 5 L0 2
⼀ 此
Net Requirements O ☆ 30 30 0 80 0
0
O
Planned order receipts 600 600 400 0
600 0 0
Planned order releases 600000 900 0 G 00 000
Item: C Lot size: L4L units
Minimum order quantity: 800 units Lead time: 1 week
Immediate Parent(s): Safety stock: 50 units
Week number 1 2 3 4 5 6 7 8
Gross Requirements 0 150 doO σ 0 750 0
0
Scheduled Receipts 0 0 0 0 0
0 0 0
Projected on hand 50 50 0
tw
s0 s0 30 10010w 150
Net Requirements 0 750850 0 0 350 0
。
Planned order receipts 0800 850 ⼼ 80
. … 0 50
Planned order releases 800 约5000500 0 50 0
Item: D Lot size: 400 units
Minimum order quantity: 400 units Lead time: 1 week
Immediate Parent(s): Safety stock: 0 units
Week number 1 2 3 4 5 6 7 8
Gross Requirements 0500600 δ 0 300 0 0
0
Scheduled Receipts 0 0 0 00 0 0
Projected on hand 100 100 0 300 200 I 0 lo 1o
0
100
Net Requirements 0 400 600 0 0 300 0
Planned order receipts 0 400 800 0 40
w 0 0
Planned order releases 400800 0 400 0 0
