please provide explanation for your calculations

B 10 D E G G Period 8 9 10 11 12 Gross requirements for A 50 60 100 Gross requirements for H 120 80 Item On hand Lead time Item On hand Lead time A 1 F 30 1 B 100 1 G 60 2 50 2 H 50 1 D 80 3 J 80 N E 90 K 120 Given the product structure, master production schedule, and inventory status and assuming the requirements for each BOM item is 1: A. (5 points) Develop a gross requirements plan for Item: B. (5 points) Develop a net requirements plan for Item C. C. (10 points) Complete a net material requirements schedule for all items (10 schedules in all), assuming the requirement for each BOM item is 1. D. (10 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. 5 points bonus If you solve the question using Excel OM