ANSWER E PLEASE

Airwaves Inc. has received an order for 1000 20-inch fans due week 7. Each fan consists of a housing assembly, two grills, a fan assembly, and an electrical unit. The housing assembly consists of a frame, two supports, and a handle. The fan assembly consists of a hub and five blades. The electrical unit consists of a motor, a switch, and a knob. The following table gives the lead times, and on-hand inventory. Components Lead Time (in weeks) 20" Fan (A) Housing (B) Frame (C) Supports (D) Handle (E) Grills (F) Fan Assembly (G) Hub (H) Blades (1) Electrical Unit (J) Motor (K) Switch (L) Knob (M) 1 1 2 1 1 2 3 1 2 1 1 1 1 On-Hand Inventory 100 100 b. Draw the time-phased product structure. (5 points) 50 400 200 150 ---- 20 a. Draw the product structure. (Use the letters to indicate components) and determine the number of units of each item required to satisfy the demand for the order of 1000 fans. In other words "Explode" the requirements. (10 points) c. Build the gross requirements plan. (Use spread sheet) (10 points) d. Redraw the product structure and explode the "net requirements". (5 points) e. Fill out the net requirements. (Use spread sheet). (10 points) Item Gross Req. On hand Net Req. Order Receipt Order Release Gross Req. On hand Net Req. Order Receipt Order Release Gross Req. On hand Net Req. Order Receipt Order Release Gross Req. On hand Net Req. Order Receipt Order Release Gross Req. On hand Net Req. Order Receipt Order Release Gross Req. On hand Net Req. Order Receipt Order Release Gross Req. On hand Net Req. Order Receipt Order Release Gross Req. On hand Net Req. Order Receipt Order Release Weeks Lead Times