Q3- Material Requirement Planning (25 marks): Hinge Global Ltd. supplies hinges and handles to Dybasty Cabinet Inc., a manufacturer of wooden kitchen cabinets. Currently, Hinge Global is seeking to develop an MRP plan to fulfill an order for 100 kitchen cabinets to be completed in week 5, and an additional 50 cabinets to be completed in week 9. (Table 1) a) Create a product structure tree for a single unit of Cabinet Doors (not the whole cabinet) (10 marks) b) Develop MRP for the next SIX WEEKS (15 marks) Table 1 Part Leadtime (Week) Project on Hand Hinge 1 30 at Week 1 Handle 2 25 at Week 5 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Master Production Schedule 100 50 Name: Handle Weeks Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 LT: 2 Gross requirements Q: 2 Scheduled receipts Projected on hand Level: 1 Net requirements Planned-order receipts Planned-order releases Name: Hinge Weeks Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 LT: 1 Gross requirements Q:4 Scheduled receipts Projected on hand Level: 1 Net requirements Planned-order receipts Planned-order releases