Tutorial Solutions Home Insert Page Layout Formules Data Review View Aspen Properties Asp Arial Narrow 11 AA Wrap Test mat Paint 1 / U - Merge & Center - and Font Alignment 045 $C$264 Levet capacity strategy Month Demand forecast lleginning Manary 1.500 March February 2.000 3.000 April 40 352 Production output required langwerpersonnel her hours available internal.hr Production supu internal units! Production to beata unibal 3,583 20 4200 1371 2,212 3,583 30 4800 1371 2212 30 4300 1371 2207 137 2.21 Inventory 4157 Beginning units Ending luni! Average unit Stockouts 500 5001 2,583 1542 o 2583 4957 3315 479 43 4790 14 0 Costs Production cost materialoverhead subcontracting Labor cost 19 200 1920 1920 19.00 Stockouts Cow Inventory cost Total (OMR Grand 12+ 176414 0 77000 191,00 Tuto Beginning January February Tutorial 91 Apie Type here to search SA # $ % 3 r lla page 1 of 5 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: (0) Develop a product tree structure for the BOM of the steering wheel model A-0137: = (ii) Develop an MRP for G-1285; [15] Reference Table 01-1 Minimum lot Lead time size (weeks) 0 1 Inventory on hand Number A-0137 10 B-1365 0 2 100 50 2 50 0 1 50 C-1258 D-1865 E-4789 F-0265 181118 1 600 200 2 1,500 G-1285 0 75 Table Q1-2 Week No. 1 2 3 5 6 A-0137 0 0 0 0 0 180 Week No. 7 8 9 10 11 12 A-0137 150 160 240 40 40 150 [Total marks 20) Tutorial Solutions Home Insert Page Layout Formules Data Review View Aspen Properties Asp Arial Narrow 11 AA Wrap Test mat Paint 1 / U - Merge & Center - and Font Alignment 045 $C$264 Levet capacity strategy Month Demand forecast lleginning Manary 1.500 March February 2.000 3.000 April 40 352 Production output required langwerpersonnel her hours available internal.hr Production supu internal units! Production to beata unibal 3,583 20 4200 1371 2,212 3,583 30 4800 1371 2212 30 4300 1371 2207 137 2.21 Inventory 4157 Beginning units Ending luni! Average unit Stockouts 500 5001 2,583 1542 o 2583 4957 3315 479 43 4790 14 0 Costs Production cost materialoverhead subcontracting Labor cost 19 200 1920 1920 19.00 Stockouts Cow Inventory cost Total (OMR Grand 12+ 176414 0 77000 191,00 Tuto Beginning January February Tutorial 91 Apie Type here to search SA # $ % 3 r lla page 1 of 5 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: (0) Develop a product tree structure for the BOM of the steering wheel model A-0137: = (ii) Develop an MRP for G-1285; [15] Reference Table 01-1 Minimum lot Lead time size (weeks) 0 1 Inventory on hand Number A-0137 10 B-1365 0 2 100 50 2 50 0 1 50 C-1258 D-1865 E-4789 F-0265 181118 1 600 200 2 1,500 G-1285 0 75 Table Q1-2 Week No. 1 2 3 5 6 A-0137 0 0 0 0 0 180 Week No. 7 8 9 10 11 12 A-0137 150 160 240 40 40 150 [Total marks 20)