11. 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:

12. 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

13. 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

14. 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:

15. 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:

16. The Scheduled Receipt of 150 units in week 12 shown in the Item B MRP table (cell O24) probably originated as a Planned Release in week:

PRODUCT STRUCTURE TREE B (2) C (5) D (3) ) E (2) 18 F (4) 11 12 13 14 15 16 17 18 14 15 16 17 18 19 ITEM A Week: Planned Release ITEM C SCHEDULED RECEIPTS NEXT WEEK Week: 12 13 Planned Release 180 50 Lead Time: 3 Weeks Lotsize: POQ - 2 Weeks 12 13 116 50 Lead Time: 2 Weeks Lotsize: FOQ = 150 12 13 11 14 15 16 17 18 11 14 15 16 17 18 19 135 115 145 140 135 150 140 54 46 58 56 54 60 56 275 150 ITEM C On Hand: Safety Stock: Week: Gross Requirements Scheduled Receipts Projected On Hand Net Requirement Planned Receipt Planned Release ITEM B On Hand: Safety Stock Week: Gross Requirements Scheduled Receipts Projected On Hand Net Requirement Planned Receipt Planned Release 180 45 205 60 185 50 190 50 50 118 5 130 150 265 290 265 290 12 13 14 15 16 17 18 ITEM D GROSS REQUIREMENTS Week: 11 Gross Requirements 12 13 14 15 16 17 18 ITEM E GROSS REQUIREMENTS Week: 11 Gross Requirements