Table MRP_Data Consider the following MPS, BOM, and inventory data. Blank MRP re
ID: 3395012 • Letter: T
Question
Table MRP_Data
Consider the following MPS, BOM, and inventory data. Blank MRP records are provided below so you can show your explosion calculations.
Master Production Schedule: the following table shows the MPS start quantities.
(MPS start quantities are the same as Planned Order Releases for end-products A & B).
Bill of Material
-End item A uses 1 each of component C and 1 each of subassembly D.
-Subassembly D uses 2 each of component E and 2 each of component F.
-End item B uses 1 each of component C and 2 each of component F.
Selected Inventory Data (assume zero safety stock for all items)
Item
Data Category
C
D
E
F
Lot-sizing rule
L4L
L4L
FOQ-250 units
POQ or FOP (P = 2)
Lead time (wks)
3
1
3
1
Beginning (on hand) inventory
50
80
90
30
Scheduled receipts
80 (week 1)
None
250 (week 3)
205 (week 1)
Use the information in Table MRP_DATA. Which one of the following statements about item F is TRUE?
a. The first planned order release is for 205 units in week 3.
b. Its first planned receipt is for 215 units in week 4.
c. There will be exactly one action notice, which calls for the release of a new order.
d. There will be exactly one action notice, which calls for the delay of the scheduled receipt until week 2.
e. None of the above. (Show your MRP Explosion Calculation Table).
Item
Data Category
C
D
E
F
Lot-sizing rule
L4L
L4L
FOQ-250 units
POQ or FOP (P = 2)
Lead time (wks)
3
1
3
1
Beginning (on hand) inventory
50
80
90
30
Scheduled receipts
80 (week 1)
None
250 (week 3)
205 (week 1)
Explanation / Answer
e) None of the above.
Since, Its 100-unit scheduled receipt in week 1 could be delayed to week 2 without delaying the planned order release for product B
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.