ASAP please

B E C D F K G M Assume that Product A is made of two units of B and four units of C. B is made of two units of Danc four of E. C is made of four units of F and three units of D. Lead times for purchase or fabrication of each unit to final assembly are: A and Cand E take two weeks; B, and D and F take one week each. Fifty units of A are required in week 8. There are 200 units on hand of item E. There are 150 units of on hand and 10 units of item A. There is a scheduled receipt of 100 units of Fin week 2. Assume th all the order quantities are L4L except for item D, which has a lot size of 250 and item Fwith a lot size 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) Vorksheet 1 2 3 4 5 6 7 8 Week Number Quantity Quantity = LT= Lot Size = On hand = Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Quantity = LT= Lot Size = On hand Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases : Quantity = LT Lot Size = On hand Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases 7: Quantity = LT= Gross requirements Scheduled receipts Projected on hand Net requirements Dlannad ardorracointe Question 2 Question 3 LatSTA Question 1 + Destination and press ENTER or choose Paste Type here to search O ji Quantity LT Atem: Gross requirements Scheduled receipts Quantity Projected on hand LT= Net requirements Lot Size Planned-order receipts 4 On hand Planned-order releases 5 6 Item: Gross requirements 7 Scheduled receipts 28 Quantity Projected on hand 29 Net requirements 30 Lot Size = Planned-order receipts 31 On hand Planned order releases 32 33 Item: Gross requirements 34 Scheduled receipts 35 Quantity Projected on hand ANDE 36 Net requirements 37 Lot Size Planned-order receipts 38 On hand Planned-order releases 39 40 Items Gross requirements 41 Scheduled receipts 42 Quantity Projected on hand 43 Net requirements 44 Lot Size Planned-order receipts 45 On hand Planned-order releases 46 47 Item: Gross requirements 48 Scheduled receipts 49 Quantity Projected on hand 50 LT Net requirements 51 Lot Size Planned order receipts 52 On hand Planned-order releases 53 54 Item: Gross requirements 55 Scheduled receipts 56 Quantity Projected on hand 57 LT Net requirements 58 Lot Size = Planned-order receipts 59 On hand = Planned-order releases 60 2AAAAC Question 1 Question 2 Question 3 Select destination and press ENTER or choose Paste Type here to search O