Note: You can right-click the image then open in a new tab to better see the problem

As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 1 spring, and 4 clamps. The base is assembled from 2 clamps and 1 housing. Each clamp has 1 handle and 1 casting. Each housing has 1 bearing and 2 shafts. There is no inventory on hand. This exercise contains only parts b and c. The product structure is as follows: Bracket Base (1) Spring(1) Clamp (2) Housing (1) Clamp (4) Handle(1) Casting (1) Bearing (1) Shaft(2) Handle (1) Casting (1) b) Determine the gross quantities needed of each item if you are to assemble 150 brackets. Base: 150 units (enter your response as a whole number). Spring: 150 units (enter your response as a whole number). Clamp: 900 units (enter your response as a whole number). Housing: 150 units (enter your response as a whole number). Handle: 900 units (enter your response as a whole number). Casting: 900 units (enter your response as a whole number). Bearing: 150 units (enter your response as a whole number). Shaft: 300 units (enter your response as a whole number). c) Compute the net quantities needed if there are 30 of the base and 100 of the clamp in stock. Base: 120 units (enter your response as a whole number). Spring: 150 units (enter your response as a whole number). Clamp units (enter your response as a whole number). Housing: 120 units (enter your response as a whole number). Handle: units (enter your response as a whole number). Casting: units (enter your response as a whole number). Bearing: 120 units (enter your response as a whole number). Shaft: 240 units (enter your response as a whole number)