PLEASE SHOW CALCULATIONS IN EXCEL

Assignment #6 MGMT 3020 Complete the MRP tables as shown for the items shown in the bills of material below. The tables are given, with all necessary lot size and inventory information, in the accompanying spreadsheet. Wid Wad B A B C(4) F A Dx2) C(4) C C2), (D(2) A (4) A3) D2); 2. E 2) E 2)) C (2), C Widgets L4L On Hand Lead Time 0 2 1 3 6 12 4 50 5 50 7 40 8 75 9 30 10 20 11 50 2 20 20 0 0 0 -100 -315 Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipt Planned Order Release -50 50 50 -100 50 50 401 -140 40 40 301 -215 75 75 201 -245 30 30 50 -265 20 20 -315 50 50 50 50 75 Wadgets L4L On Hand Lead Time 6 8 12 0 1 1 30 30 0 21 60 3 30 4 40 5 40 7 60 91 60 101 80 11 20 -170 -230 -390 Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipt Planned Order Release -601 60 60 30 -90 301 30 40 -130 401 40 40 -170 40 40 -230 60 60 -290 60 60 80 -370 80 80 20 -390 20 20 601 60 60 L4L On Hand Lead Time 350 1 1 2 3 5 8 91 101 11 12 2001 Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipt Planned Order Release B B FOQx On Hand Lead Time 80 70 2 1 2 3 41 51 6 7 8 9 101 11 12 80 Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipt Planned Order Release FPO On Hand Lead Time 2 1200 2 3 6 8 10 11 12 Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipt| Planned Order Release D D FOQ+ On Hand Lead Time 200 220 1 1 2 3 9 101 11 12 2001 Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipt Planned Order Release E FOQ+ On Hand Lead Time 300 400 3 31 10 11 12 600 Gross Requirements Scheduled Receipts! On Hand Net Requirements Planned Order Receipt Planned Order Release F FPO On Hand Lead Time 3 60 1 10 11 12 Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipt Planned Order Release