Answer using Excel***

A H B J K 1 D E F G E F E G F G Period 8 9 10 11 12 Gross requirements for A 50 50 150 Gross requirements for H 150 80 Item On hand Lead time Item On hand Lead time . O 1 F 30 1 B 150 1 G 20 2 50 2 H 1 50 1 D 75 3 J 80 2 E 120 N K 100 3 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 C; 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