Given the product structure, master production schedule, and inventory status and assuming the requirements for each BOM item is 1. Given the product structure, master production schedule, and inventory status and assuming the requirements for each BOM item is 1 : A. (4 points) Develop a gross requirements plan for item C : B. (4 points) Develop a net requirements plan for ltem C. C. (4 points) Complete a net material requirements schedule for all items (10 schedules in all), assuming the requirement for each BOM item is 1. D. (4 points) Complete a net material requirements schedule for all 10 items, assuming the requirement for all items is 1 , except B, C, and F, which require 2 each. E 4 points bonus if you solve the question using Excel OM