Question

Question 35 pts

Calculate the Schedule Receipts and On Hand Inventory for Week 8 in the attached MRP worksheet.

Beginning Inventory = 125

Lead Time = 2 weeks

Lot Size = 50

Period 1 2 3 4 5 6 7 8

Gross Requirements 50 50 150 200 50 25 100 25

Schedule Receipts

On Hand 125

Planned Order Release

Group of answer choices

Schedule Receipt 25, On Hand 0

Schedule Receipt 550, On Hand 50

Schedule Receipt 50, On Hand 25

Schedule receipt 150, On Hand 75

Answer 1

The correct answer is : Schedule Receipt 50, On Hand 25

To calculate the Schedule Receipts and On Hand Inventory for Week 8, we need to consider the beginning inventory, gross requirements, lead time, and lot size.

Given data:

- Beginning Inventory = 125

- Lead Time = 2 weeks

- Lot Size = 50

- Gross Requirements for Week 8 = 25

Let's calculate it step by step:

1. Determine the Planned Order Release for Week 8:

Planned Order Release = Gross Requirements + Safety Stock - On Hand Inventory

Since there's no safety stock mentioned, we can ignore it.

Planned Order Release = 25 + 0 - 125 = -100

2. Calculate the Schedule Receipts for Week 8:

Schedule Receipts = Planned Order Release + Lot Size

Schedule Receipts = -100 + 50 = -50

3. Calculate the On Hand Inventory for Week 8:

On Hand Inventory = Beginning Inventory + Planned Order Release

On Hand Inventory = 125 - 100 = 25

So, the correct answer is:

Schedule Receipt 50, On Hand 25