![06 MRP Tables (Excel) [PDF]](https://pdfs.asia/img/200x200/06-mrp-tables-excel.jpg)
7 0 38 KB
MRP exercise:
LEVEL
1
Lot Sizing =
LFL
LT = PERIOD
Gross Requirements Scheduled Receipts Planned Order Receipts Available Balance Planned Order Releases
LEVEL
1
Lot Sizing =
>180
30
2 Weeks
Safety Stock =
2
3
4
5
6
7
0
0
0
160
0
220
0
0
0
0
0
0
0
0
0
0
0
150
0
220
0
30
30
20
20
20
20
150
LT = PERIOD
1
Safety Stock =
2
3
4
5
6
7
0
0
0
160
120
315
0
Planned Order Receipts Available Balance Planned Order Releases
0
0
0
180
180
235
0
0
0
1
Lot Sizing =
40multi.
LT =
PERIOD
Gross Requirements Scheduled Receipts Planned Order Receipts Available Balance Planned Order Releases
20
LEVEL
2
Lot Sizing =
120multi.
Gross Requirements Scheduled Receipts Planned Order Receipts Available Balance Planned Order Releases
LEVEL
20
80
180
235
1
Safety Stock =
2
3
4
5
6
7
0
0
0
360
285
0
40
0
0
0
0
0
0
320
320
60
20
55
320
320
60
60
1
Safety Stock =
2
3
4
5
6
7
0
300
0
1400
960
0
0
-
-
-
-
-
-
-
0
360
0
1320
960
0
0
30
30
110 360
C
1320
8
9
10
ITEM
D
9
10
0
1
50
ITEM 20
0
LT =
PERIOD
0 180
1
60
B
0
1
LEVEL
ITEM
220
Gross Requirements Scheduled Receipts 0
A
20
1
30
ITEM
8
960
2
ITEM
Lot Sizing =
LT = PERIOD
1
Safety Stock = 2
3
4
5
6
7
8
9
Gross Requirements Scheduled Receipts Planned Order Receipts Available Balance Planned Order Releases
LEVEL Lot Sizing =
ITEM LT =
Safety Stock =
10
PERIOD
1
2
3
4
5
6
7
8
9
10
Gross Requirements Scheduled Receipts Planned Order Receipts Available Balance Planned Order Releases
LEVEL
ITEM
Lot Sizing =
LT = PERIOD
Gross Requirements Scheduled Receipts Planned Order Receipts Available Balance Planned Order Releases
1
Safety Stock = 2
3
4
5
6
7
8
9
10
*2P1
*2P1 + 1P2
3*p2
*2A+3*C
