Complete the MRP records for each of the components (A,B,C,D,E) for 8 weeks

LX =51,  LB =98, LC =510, LD =124, OX =465, OA =72, OB =84, OC =3116, OD =168 ,OE =112

TABLE

Gross Requirements
Scheduled receipt
Projected Available Balance
Net Requirements
Planned Order Receipts
Planned Order Releases 
 

Transcribed Image Text:

Product X has the product structure given below. For 1 unit of X, 1 unit of A and 2 units of B are required. 1 unit of A is composed of 1 unit of C and 1 unit of D. For 1 unit of B, 3 units of C are required. For 1 unit of C, 1 unit of E is required. X A B (2) C (3) C E E Suppose that the batch size for the assembly of X is LX units. The assembly is done as multiples of this batch size. Currently, we have OX units of X on hand. The company does not keep safety stock for X. The planning horizon is 8 weeks ahead. Assume that there is no lead time for X. In addition, relevant details for each component are in the table below. Component с A D B EOQ=LB units E Lot-for-lot Lot size policy Lot-for-lot EOQ=LC units At least LD units On-hand inventory OA units OB units OC units OD units OE units Lead time 1 2 1 2 1 (in weeks) Safety stock None 50 None 70 100 (to be Scheduled 100 500 (to be received at the beginning of Week3) None None None received at the beginning of Week2) receipts Product X has the product structure given below. For 1 unit of X, 1 unit of A and 2 units of B are required. 1 unit of A is composed of 1 unit of C and 1 unit of D. For 1 unit of B, 3 units of C are required. For 1 unit of C, 1 unit of E is required. X A B (2) C (3) C E E Suppose that the batch size for the assembly of X is LX units. The assembly is done as multiples of this batch size. Currently, we have OX units of X on hand. The company does not keep safety stock for X. The planning horizon is 8 weeks ahead. Assume that there is no lead time for X. In addition, relevant details for each component are in the table below. Component с A D B EOQ=LB units E Lot-for-lot Lot size policy Lot-for-lot EOQ=LC units At least LD units On-hand inventory OA units OB units OC units OD units OE units Lead time 1 2 1 2 1 (in weeks) Safety stock None 50 None 70 100 (to be Scheduled 100 500 (to be received at the beginning of Week3) None None None received at the beginning of Week2) receipts

Answer rating: 100% (QA)

a First compute the Projected available balance PAB and Net requirement NR as fo... View the full answer