Question

12. (25 points) Complete the MRP calculations for the simple product shown below. Numbers next to each item identify the usage rates. For example, the usage rate for item A is 2. A2 C3 C2 B1 Item X L4L On Hand 80 Lead Time 4 70 120 85 50 70 100 Gross Requirements Scheduled Receipts On Hand Net Requirements) Planned Order Receipt Planned Order Release Styles Paragraph tem A 150 FOQ+ 30 On Hand Lead Time 8 5 2 Gross Requirements Scheduled Receipts200 On Hand Net Requirements Planned Order Receipt Planned Order Release tem B FPO 2 On Hand 320 Lead Time 6 Gross Requirements Scheduled Receipts On Hand Net Requirements Planned Order Receipt Planned Order Release FOQX On Hand 250 tem C Lead Time 2 4 Gross Requirements Scheduled Receipts 650 660 On Hand Net Requirements Planned Order Receipt Planned Order Release

Answer 1

L4L		Item X
On Hand	80
Lead Time	1
	1	2	3	4	5	6	7	8
Gross Requirements	70	100	120	50	85	100	110	70
Scheduled Receipts	0	0	0	0	0	0	0	0
On Hand	10	0	0	0	0	0	0	0
Net Requirements	0	90	120	50	85	100	110	70
Planned Order Receipts	0	90	120	50	85	100	110	70
Planned Order Releases	90	120	50	85	100	110	70	0
FOQ+	150	Item A
On Hand	30
Lead Time	1
	1	2	3	4	5	6	7	8
Gross Requirements	180	240	100	170	200	220	140	0
Scheduled Receipts	200	0	0	0	0	0	0	0
On Hand	50	0	50	30	0	0	10	10
Net Requirements	0	190	100	120	170	220	140	0
Planned Order Receipts	0	190	150	150	170	220	150	0
Planned Order Releases	190	150	150	170	220	150	0	0
FPO	2	Item B
On Hand	320
Lead Time	1
	1	2	3	4	5	6	7	8
Gross Requirements	190	150	150	170	220	150	0	0
Scheduled Receipts	0	0	0	0	0	0	0	0
On Hand	130	150	0	220	0	0	0	0
Net Requirements	0	20	0	170	0	150	0	0
Planned Order Receipts	0	170	0	390	0	150	0	0
Planned Order Releases	170	0	390	0	150	0	0	0
FOQx	250	Item C
On Hand	0
Lead Time	2
	1	2	3	4	5	6	7	8
Gross Requirements	650	660	450	595	740	630	210	0
Scheduled Receipts	650	660	0	0	0	0	0	0
On Hand	0	0	50	205	215	85	125	125
Net Requirements	0	0	450	545	535	415	125	0
Planned Order Receipts	0	0	500	750	750	500	250	0
Planned Order Releases	500	750	750	500	250	0	0	0