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:

17. The Project Scheduling Problem tab of the Question Parameters workbook displays the Activity-On-Node (AON) diagram for a project network. Activity times (in weeks) are shown in the table to the left of the AON diagram. You should:

• Enter the "Immediate Predecessors" information into cells B4-B11
• Compute and enter the ES, EF, LS, LF, and Slack times for each activity into columns D through H as indicated
• Answer the following
  • How long will the project take? (Enter value)
  • What is the critical path?

18. For the project from the question above, what is the impact on total project duration if Activity C is delayed by 1 period? Explain

19. For the project from the question above, what is the impact on total project duration if Activity D is shortened by 1 period? Explain

PRODUCT STRUCTURE TREE B (2) C (5) D 3 D (3) E (2) F (4) 11 12 13 14 15 18 17 18 14 15 16 17 ITEM A Week: Planned Release 19 ITEM C SCHEDULED RECEIPTS NEXT WEEK Week: 12 13 Planned Release 18 155 50 Lead Time: 3 Weeks Lotsize: POQ - 2 Weeks 12 13 14 106 50 11 15 16 17 18 11 Lead Time: 2 Weeks Lotsize: FOQ = 150 12 13 54 52 14 15 16 17 18 110 135 130 105 135 145 150 44 42 54 58 60 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 155 45 185 55 185 50 200 50 50 106 5 100 145 235 295 235 295 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 Wook: 11 Gross Requirements