Kindly show the complete excel working.

. ... 14.13 Electro Fans has just received an order for one thou- sand 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 electri- cal unit consists of a motor, a switch, and a knob. The following table gives lead times, on-hand inventory, and scheduled receipts. Data Table for Problem 14.13 LEAD ON-HAND LOT SCHEDULED COMPONENT TIME INVENTORY SIZE* RECEIPT 20" Fan 1 100 Housing 1 100 Frame 2 Supports (2) 50 100 Handle 1 400 500 Grills (2) 2 200 500 Fan Assembly 3 150 Hub 1 Blades (5) 2. 100 Electrical Unit 1 Motor 1 Switch 20 12 Knob 1 25 200 knobs in week 2 * lot-for-lot unless otherwise noted 1 NWN 1