Classwork 4 Topic 7. MRP Bracket Bracket Base Springs QI. As the production planner for Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 1 clamp and 2 housings. Each clamp has 1 handle and I casting. Each housing has 2 bearings and I shaft. There is no inventory on hand. The product structure is as follows: Clamp (1) Housinta Clamp Handle Casting Bearingo) Shaft) Handle() Castingen 1) Determine the gross quantities needed of each item if you are to assemble 50 brackets. Base: Spring: Clamp: Housing: Handle: Casting: Bearing: Shaft: 2) Compute the net quantities needed if there are 25 of the base and 100 of the clamp in stock. Base: Spring: Clamp: Housing: Handle: Casting: Bearing: Shaft: Q2. Each unit of A is composed of one unit of B, two units of C, and one unit of D. C is composed of two units of D and three units of E. Items A, C, D, and E have on-hand inventories of 20, 10, 20, and 10 units, respectively. Item B has a scheduled receipt of 10 units in Period 1, and C has a scheduled receipt of 50 units in Period I. Lot-for-lot (L4L) lot sizing is used for Items A and B. Item requires a minimum lot size of 50 units. D and E are required to be purchased in multiples of 100 and 50, respectively. Lead times are one period for Items A, B, and C, and two periods for Items D and E. The gross requirements for A are 30 in Period 2, 30 in Period S, and 40 in Period 8. Please develop an MPS and MRP report. Master Production Schedule Week 1 Beg. Inv. 2 4 5 6 7 8 Item: Beg. Inv. 1 2 3 4 5 7 8 LT- Week Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipt Planned-order release Q- Item: Beg. Inv. 1 2 3 4 5 6 7 8 LT- Week Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipt Planned-order release Q- 1 2 3 4 Item: 5 6 7 8 Beg Inv. LT- Weck Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipt Planned-order release Q 1 2. Bee. Inv. 3 4 5 6 Item: 7 8 LT- Week Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipt Planned-order release Q- 3 2 4 1 5 6 7 8 Item: Beg. Inv LT- Week Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipt Planned-order release O