Solve the following problem ( No hand writing please, only excel or word tables). An like will be given if the problem is solved proparly.

Black & White is one of the biggest manufacturers of toys. Operation managers at Black Eagles are currently working on production scheduling and inventory control in order to have a smooth production with reduced costs. The company produces two types of toys: Car and Truck. The company needs to assemble 15 Cars and 10 Trucks for Weeks 4, 5, 6, 7 and 8. The product structure trees for car and truck are as follows: Car Truck w F F M K(2) 1 W(2) Q The information regarding lead times, projected on hand inventory and lot-sizing rules are as follows: Item Lead Time (weeks) Projected Lot-sizing On Hand Rule Car 5 Lot-for-lot Truck 2 Lot-for-lot 5 25 W 2 weeks for orders up to 35 2 12 3 weeks for orders more than 35 F 10 30 K 3 Lot-for-lot Q 1 15 30 M 1 Lot-for-lot 0 Beg. Inv. 1 2 3 4 S 6 7 8 The scheduled receipts are as follows: 20 Cars and 18 Ws in Week 1, and 20 Trucks and 15 Fs week 2. As an operation manager at Black & White, develop material requirements plan. Part: Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release