Y. One unit of component C one unit of either product X or Y. The materials plan
ID: 380008 • Letter: Y
Question
Y. One unit of component C one unit of either product X or Y. The materials planner has Problem 3. (14%) The XYZ Company produces products X and developed the MRP record for component C in the following table. t C 15 30 25 25 1020 Gross Requirements Scheduled Receipts Projected Available Balance Planned Order Release 40 5 30 0 | 15 30 | 20 | 0 40 40 Q=40, LT = 2, ss- During week 1, the following transactions occurred for component C: a. The open order for 40 due to be received in week 1 was received with 10 scrapped. b. 5 units of component C were missing. Thus, an inventory adjustment of -5 was processed. c. 10 units of component C were actually disbursed, instead of 15 units planned. d. The MPS for week 7 include 15 units for product X and 0 units for product Y. e. Manager suggested the gross requirements of 25 units in week 3 be moved to week 2. f. An order for 40 units was released. Given the above information, complete the MRP record below for component C as it would appear at the beginning of week 2. What action(s) would you recommend the materials planner to take at the start of week 2 as a result of transactions occurring during week 1? Com t C 6 Gross Requirements Scheduled Receipts Projected Available Balance Planned Order Release Q-40, LT 2, ss-0Explanation / Answer
Gross requirement of 25 units of week 3 was moved to week 2. So gross requirement of week 2 = 30+25 = 55
gross requirement of week 3 = 25-25 = 0
Gross requirement of 15 units added to week 7
Gross requirement of component C after making the adjustments of tansactions that occurred in week 1 is as follows
Opening inventory in week 2 = 5 units of week 1 - 5 inventory adjustment + 40 scheduled receipts - 10 scrapped - 10 disbursed = 20
MRP starting week 2 is as follows
Planned order release (POR) occurs whenever projected available balance is less than ss (=0)
Scheduled receipt of order released in week 1 is in week 3 after 2 weeks lead time
POR of 40 units occurs in week 2 . this is received 2 weeks later (considering 2 weeks lead time)
Projected available balance (PAB) in any week = previous PAB + scheduled receipts + POR of 2 weeks earlier - gross requirement
2 3 4 5 6 7 Gross requirements 55 0 25 10 20 15Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.