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

R.53 fx R.53 fx