3 a Assume that Product A is made of two units of B and four units of C. B is made of two units of D and four of E. C is made of four units of Fand three units of D. Lead times for purchase or fabrication of each unit to final assembly are: A and C and E take two weeks; B, and D and F take one week each. Sixty units of A are required in week 8. There are 200 units on hand of item E. There are 150 units of Fon hand and 10 units of item A. There is a scheduled receipt of 100 units of Fin week 2. Assume that all the order quantities are L4L except for item D, which has a lot size of 250 and item F with a lot size of 100. A) Show the bill of material - put it beside the planning sheet. (2 marks) (B) Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates (10 marks) 2 3 8 4 5 7 IRP Worksheet Week Number Quantity cem: = Quantity = LT = Lot Size = On hand = Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Gross requirements