table in excel please

-14.13 Electro Fans has just received an order for one thousand 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 lead times, on-hand inventory, and scheduled receipts. a) Construct a product structure. b) Construct a time-phased product structure. c) Prepare a net material requirements plan. Data Table for Problem 14.13 * Lot-for-lot unless otherwise noted