Please note that this is the whole data. if there is more data needed please specify what data needed?

Q1 The Bewdley Company in Shropshire, England, makes automobile components for Ford Motor Company. Two major products are steering wheel assemblies. One of the two models of steering wheel is A-0137. The product structure of this model is that for every unit of A-0137, it needs one(1) unit of B-1365 and one(1) unit of C-1258. One unit of B-1365 needs one(1) unit of D-1865 and one(1) unit of E-4789. For every one(1) unit of C-1258 needs one(1) unit of F-0265 and one(1) unit of G- 1285. There is a one-for-one basis for component requirements. The inventory records file is given in Table Q1-1, and the Gross requirement are given in Table Q1-2. Perform the following: (i) Develop a product tree structure for the BOM of the steering wheel model A-0137; [5] (ii) Develop an MRP for G-1285; [15] Table Q1-1 Reference Minimum lot size Lead time (weeks) 1 Inventory on hand Number A-0137 0 10 B-1365 0 2 100 C-1258 50 2 50 D-1865 0 1 50 E-4789 0 1 600 F-0265 200 2 1,500 G-1285 0 1 75 Table Q1-2 Week No. 1 2 3 4 5 6 A-0137 0 0 0 0 0 150 Week No. 7 8 9 10 11 12 A-0137 150 170 230 40 50 150