I need a detailed hand written solution to this question. Kindly don't simply provide excel screenshots.

Brown and Brown Electronics manufactures a line of digital audiotape (DAT) players. The bill of materials, showing the number of each item required is shown below follows: Data for A : Gross requirement is 100 units on 9th week, Lead time is 2 weeks, Lot for lot Data for C : Lead time is 1 weeks, Lot for lot Data for D: Lead time is 2 weeks, schedule receipt is 30 on 1st week, lot size 170 units Data for F : Lead time is 1 weeks, scheduled receipt is 60 on 1st week, on hand inventory is 15 , lot for lot Data for G : Lead time is 1 wecks, scheduled receipt is 100 on 1st week, on hand inventory is 50 , lot for lot Data for H : Lead time is 1 weeks, scheduled receipt is 50 on 1st week, lot size is 200 Data for I: Lead time is 1 weeks, scheduled receipt is 60 on 1st week, on hand inventory is 15 , lot for lot Prepare an MRP schedule to satisfy the demand