Please use Excel sheet ..

1.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, two springs, and four clamps. The base is assembled from one clamp and two housings. Each clamp has one handle and one casting. Each housing has two bearings and one shaft. There is no inventory on hand. a) Design a product structure noting the quantities for each item and show the low-level coding. b) Determine the gross quantities needed of each item if you are to assemble 50 brackets. c) Compute the net quantities needed if there are 25 of the base and 100 of the clamp in stock. PX

2.Your boss at Xiangling Hu Products, Inc., has just provided you with the schedule and lead times for the bracket in Problem 14.3. The unit is to be prepared in week 10. The lead times for the components are bracket (1 week), base (1 week), spring (1 week), clamp (1 week), housing (2 weeks), handle (1 week), casting (3 weeks), bearing (1 week), and shaft (1 week). a) Prepare the time-phased product structure for the bracket. b) In what week do you need to start the castings? PX