145 C D $ F G H M N P 5 T PRODUCT STRUCTURE TREE 8(2) DOL C (2) F14) SITEMA 15 W 11 1 13 14 15 16 ITEM C SCHEDULED RECEPTS NEXT WEEK Week 12 14 14 17 18 Plained 16 Hase 1 ITEM C 20 On Hand 155 23ify Stock 50 Lead Time 3 Weeks Le 100-2 Weeks ITEM B On 100 LT2W 50 Love Fog-150 22 Www 11 12 13 14 15 16 17 18 Wesk " 13 15 14 15 16 17 18 110 120 140 110 110 105 145 44 " 50 44 48 4 Reguments Scheduled 275 Projected M 25 On Hand 200 60. Scheduled 150 50 195 50 00 Projected On Hand 100 100 105 2 Parned 27 Planned MARE 215 ITEM D GROSS REQUIREMENTS G 32 s 33 34 TEME GROSS REQUIREMENTS 15 Cross 3 210 250 250 12 13 34 15 SE 17 " 12 12 14 15 16 37 Regemen Plained Receipt Panad Question 11 2 pts Based on the information provided, what are the current Planned Releases for Product A for weeks 11-18. Enter these into cells C16-J16 on the MRP Problem tab of your workbook. In addition to filling in the complete row in the Excel spreadsheet, enter the two values requested below: Planned Releases for Item A in week 11: Planned Releases for Item A in week 12: Question 12 2 pts Based on the information provided, what are the current Gross Requirements for Item D for weeks 11-18. Enter these into cells C32-J32 on the MRP Problem tab of your workbook. In addition to filling in the complete row in the Excel spreadsheet, enter the two values requested below: Item D Gross Requirements for Week 11 Item D Gross Requirements for Week 12 D Question 13 2 pts Based on the information provided, what are the current Gross Requirements for Item E for weeks 11-18. Enter these into cells C36-J36 on the MRP Problem tab of your workbook. In addition to filling in the complete row in the Excel spreadsheet, enter the two values requested below: Item E Gross Requirements for Week 11 Item E Gross Requirements for Week 12 D Question 14 2 pts Based on the information provided, what will we be seeing next week in the Scheduled Receipt row, when we come back and complete the Item C MRP table covering weeks 12-19. Enter these into the cells N16-U16 on the MRP Problem tab of your workbook. In addition to filling in the complete row in the Excel spreadsheet, enter the two values requested below: Item C Scheduled Receipts for week 12, in the week 12-19 MRP table: Item C Scheduled Receipts for week 13, in the week 12-19 MRP table: Question 15 6 pts Complete the ITEM B MRP table for weeks 11-18 in the Excel spreadsheet. Item B uses a fixed order quantity (FOQ = 150) lot sizing rule. In addition to filling out the table in the Excel spreadsheet, enter the two values requested below: Item B Projected On Hand at the end of week 11: Item B Projected On Hand at the end of week 12