Question: (15 points) Given the following data, develop MRP tables and indicate the Planned order releases for all items. A is an MPS item. A needs
- (15 points) Given the following data, develop MRP tables and indicate the Planned order releases for all items.
A is an MPS item. A needs 3 C's and 2 Fs and one G. Every C needs 6 Fs and every G needs 4 Fs
|
Period | 6 | 7 | 8 | 9 |
|
GR-A | 0 | 0 | 2000 | 1500 |
On hand inventory for all items is 400 and lead time for A is 1 period, LT for F is 1 period and LT for C and G are 2 periods. Use lot-for-lot for A and a lot size of 900 or multiples of 900 for C and lot size of 2000 or multiples of 2000 for F and G.
Draw the Bill of Material Fill up the Low level code Table
|
| Item | Low level code |
| |||||||||
|
| A |
|
| |||||||||
|
| C |
|
| |||||||||
|
| F |
|
| |||||||||
|
| G |
|
| |||||||||
| A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | |||
| GR |
|
|
|
|
|
|
|
|
| |||
| EI |
|
|
|
|
|
|
|
|
| |||
| NR |
|
|
|
|
|
|
|
|
| |||
| PO Receipt |
|
|
|
|
|
|
|
|
| |||
| PO Release |
|
|
|
|
|
|
|
|
| |||
Please use This Chart for A,C,F,G
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
