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 1 clamp and 2 housings. Each clamp has 1 handle and 2 castings. Each housing has 2 bearings 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 Spring (1) Housing(2) Clampol) Clamp (4) Handlec) Castingo Bearing 2) Shaftzy Handle(1) Casting(2) b) Determine the gross quantities needed of each item if you are to assemble 75 brackets. Base: units (enter your response as a whole number) Spring: units (enter your response as a whole number) Clamp: units (enter your response as a whole number) Housing 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 units (enter your response as a whole number) Shaft: 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 units (enter your response as a whole number) Spring: units (enter your response as a whole number) Clamp units (enter your response as a whole number) Housing units (enter your response as a whole number) Handle units (enter vour response as a whole number