Problem 12-3 The following table lists the components needed to assemble an end
ID: 456514 • Letter: P
Question
Problem 12-3
The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand.
If 43 units of the end item are to be assembled, how many additional units of B are needed? (Hint: You don’t need to develop an MRP plan.)
An order for the end item is scheduled to be shipped at the start of week 9. What is the latest week that the order can be started and still be ready to ship on time? (Hint: You don’t need to develop an MRP plan.)
The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand.
Explanation / Answer
End Units 43 hence L=2*43 = 86 C=1*43 = 43 K=3*43 = 129 for L=86-available in hand=86-10=76 B=2*76- available in hand = 152-30 = 122 J=3*76- available in hand = 221-30 = 191 for C=43-available in hand=43-15=28 G=2*28-available in hand = 56-5 = 51 B=2*28- available in hand = 56-0 = 56 for K=129-available in hand = 129-20 = 109 H=4*109-available in hand = 436-0 = 436 B=2*109-available in hand = 218-0 = 218 a) total additional units of B=122+56+218= 396 b) the lastest week for end product time = max lead time (L,C,K)+lead time for end product for latest week of L=Max lead time (B,J) lead time L=max(2,3)+2= 5 weeks for latest week of C= Max lead time(B,G)+lead time C=max(2,3)+3= 6 weeks for latest week of K=max lead time(H,B)+lead time K=max(2,2)+3= 5 weeks hence the lastest week for end product time = max lead time (L,C,K)+lead time for end product max(5,6,5)+1=7 weeks