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 
 

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