Problem 12-2 The folloWing table lists the components needed to assemble an end
ID: 339954 • Letter: P
Question
Problem 12-2 The folloWing table lists the components needed to assemble an end Item, lead times, and quantities on hand. Item LT (wk) Amount on hand End B 7 12 22 8 29 0 End Item B (2) D (3) a. If 21 units of the end item are to be assembled, how many additional units of E are needed? (Hint You don't need to develop an MRP plan to determine thls.) Additional units b. An order for the end ltem is scheduled to be shlpped at the start of week 15. What is the latest week that the order can be started and still be ready to shlp on time? (Hint You don't need to develop an MRP plan for this part elther.) The latest weekExplanation / Answer
a) For 1 unit of End item assembled, below is the number of unist required for each components and subcomponents -
B - 2*1 = 2 => E = 2*2 = 4; F = 2*3 = 6
C - 1*1 = 1 => G = 2*1 = 2; E = 2*1 = 2
D - 3*1 = 3 => H = 4*3 = 12; E = 2*3 = 6
For 21 units, B = Number of units required - = 35
E(from B) = 37*2-8 = 66
For 21 units, C = Number of units required - = 9
E(from C) = 9*2 = 18
For 21 units, D = Number of units required - = 44
E(from D) = 44*2 = 88
Total additional units of E required = 66+18+88 = 172
b) End item scheduled week = 15
Scheduled week of B = 15-3 = 12
Scheduled week of C = 15-1 = 14
Scheduled week of D = 15-1 = 14
Scheduled week of E = 12-1 = 11 for B
Scheduled week of E = 14-1 = 13 for C
Scheduled week of E = 14-1 = 13 for D
Scheduled week of F = 12-2 =10 for B
Scheduled week of G = 14-1 = 13 for C
Scheduled week of H = 14-1= 13 for D
Hencem the Latest week that the order can be started is 10th week to be ready to ship on time.