Please show me how to solve without excel. I will give a thumbs up.Please and thanks.

Problem 9-9 Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 134 units. The following is the BOM in indented form ITEM A D E C F G DESCRIPTION Bracket assembly Wall board Hanger subassembly Hanger casting Ceramic knob Rivet head screw Metal tong Plastic cap USAGE 1 3 2 3 1 4 4 1 Below is a table indicating current inventory levels. . 65 Item Inventory o 21 F 1.280 192 172 100 12 21 b. What are the net requirements for each item? (Leave no cells blank - be certain to enter "0" wherever required.) Item Net Requirements 113 36 % X (0 SS D Rivet head screw F G Metal tong Plastic cap 4 4 Below is a table indicating current inventory levels: Item Inventory 21 A 12 B 65 C 21 D 192 F 1,280 172 G 100 b. What are the net requirements for each item? (Leave no cells blank - be certain to enter "0" wherever required.) Item Net Requirements 113 36 x A B C D E F G