Exercise 7 Chapter 15 - Part 2
Exercise 7
Chapter 15 - Part 2: Resource Planning
Use the following to answer questions 1-5:
Given the following information, develop a material requirements plan (MRP) that will yield 100 units of product A at the start of week 8.You need to fill out the matrices on the second page to answer the questions.
|
Item |
Inventory On-Hand |
Lead Time |
Order Quantity |
|
A |
20 |
1 |
lot-for-lot |
|
B |
30 |
1 |
lot-for-lot |
|
C |
10 |
1 |
lot-for-lot |
|
D |
15 |
1 |
250 |
|
E |
5 |
2 |
100 |
1. What is the MPS (master production schedule) for the final product A?
2. What is the planned order release for item B?
3. What is the planned order release for item C?
4. What is the planned order release for item D?
5. What is the planned order release for item E?
|
MPS(Master Schedule) Week Number |
Beg. Inv. |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
|
Quantity |
|
|
|
|
|
|
|
|
|
|
Gross requirements (A) |
|
|
|
|
|
|
|
|
|
|
Scheduled receipts |
|
|
|
|
|
|
|
|
|
|
On hand |
|
|
|
|
|
|
|
|
|
|
Net requirements |
|
|
|
|
|
|
|
|
|
|
Planned-order receipts |
|
|
|
|
|
|
|
|
|
|
Planned-order releases |
|
|
|
|
|
|
|
|
|
|
Gross requirements (B) |
|
|
|
|
|
|
|
|
|
|
Scheduled receipts |
|
|
|
|
|
|
|
|
|
|
On hand |
|
|
|
|
|
|
|
|
|
|
Net requirements |
|
|
|
|
|
|
|
|
|
|
Planned-order receipts |
|
|
|
|
|
|
|
|
|
|
Planned-order releases |
|
|
|
|
|
|
|
|
|
|
Gross requirements (C) |
|
|
|
|
|
|
|
|
|
|
Scheduled receipts |
|
|
|
|
|
|
|
|
|
|
On hand |
|
|
|
|
|
|
|
|
|
|
Net requirements |
|
|
|
|
|
|
|
|
|
|
Planned-order receipts |
|
|
|
|
|
|
|
|
|
|
Planned-order releases |
|
|
|
|
|
|
|
|
|
|
Gross requirements (D) |
|
|
|
|
|
|
|
|
|
|
Scheduled receipts |
|
|
|
|
|
|
|
|
|
|
On hand |
|
|
|
|
|
|
|
|
|
|
Net requirements |
|
|
|
|
|
|
|
|
|
|
Planned-order receipts |
|
|
|
|
|
|
|
|
|
|
Planned-order releases |
|
|
|
|
|
|
|
|
|
|
Gross requirements (E) |
|
|
|
|
|
|
|
|
|
|
Scheduled receipts |
|
|
|
|
|
|
|
|
|
|
On hand |
|
|
|
|
|
|
|
|
|
|
Net requirements |
|
|
|
|
|
|
|
|
|
|
Planned-order receipts |
|
|
|
|
|
|
|
|
|
|
Planned-order releases |
|
|
|
|
|
|
|
|
|
-
Rating:
/5
Solution: Exercise 7 Chapter 15 - Part 2