McExe is a cabinet manufacturer located in Exeter. The company's one of the popular products is CD cabinet, which consists of one cabinet top, one cabinet bottom, two cabinet doors, two cabinet sides, four shelves, and sixteen shelf supports. Each cabinet bottom consists of four feet. Each cabinet doors consists of one magnet, two hinges, one handle, and eight screws. Each cabinet side has one door catch and two screws. On Hands Short name Lot Rules A A B + C D E F G H 1 K L M B C 120 20 120 L4L FOQ FOQ FOO Table Q3a. Item details. 144 Item CD Cabinet Cabinet Top Cabinet Bottom Cabinet Door Cabinet Side Shelf Shelf Support Foot Magnet Hinge Handle Screw Door Catch FOO M 216 144 216 *L4L lot-for-lot "FOQ fixed-order quantity (a) Draw the bill of material for these products 0 FOQ M 2500 LAL to L4L Lead Time (Week) 1 Table Q3b. On-hand details and lot Rules D E F G H J 0 0 0 12 0 FOO FOO FOO = . 932 200 250 3 4 3 3 2 1 4 2 4 3 1 1 K 50 500 FOQ # 2000 (5.marks) M 0 FOQ # 252 (b) In weeks 4, 7 and 10 the gross requirement of the CD cabinet has been calculated as 100 items from the MPS calculation. Use the Tables Q3a and Q3b, run the MRP processes for CD Cabinet, Cabinet Top, Cabinet Bottom, Cabinet Door, Cabinet Side and Shelf Support. (12 marks) (c) Use the Tables Q3a and Q3b, run the MRP processes for Magnet, Hinge, Screw. and Door Catch, (8 marks)