Question

Given the data provided for product structure, component AC101, and the planned orders of parent AB 500 below, use the matrix for AC101 at the bottom to compute gross requirements, projected on hand, net requirements and planned orders. Suggestion: Start by filling out the MRP matrix for AC101 with the data given. AB500 LT=2 AC101 (2) LT=3 Notes: O signifies usage. FOQ = Fixed order quantity. Item On Hand MPS Scheduled Receipts 600: Week 6 Lot Size / Order Policy FOQ = 600 Lead Time 3 | AC101 | 1300 200, week 4; 0 LLC: LT: 2 1 2 3 210 4 250 Period 5 6 150 250 7 150 8 250 9 150 10 250 Item: AB500 Lot Size: L4L Gross Requirements Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipt Planned Orders Releases 60 150 150 | 150 250 150 250 250 150 250 | 250 | 150 | 250 150 250 150 250 | 150 | 250 150 150 250 250 | | 150 | 250 LLC: 1 LT: 3 Period 5 6 1 3 4 7 8 Item: AC101 Lot Size: FOQ 600 Gross Requirements Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipt Planned Orders Releases 1300

Answer 1

Below is the required MRP schedule -

AB500 LT 2 Q = L4L		On Hand	1	2	3	4	5	6	7	8	9	10
	Gross Requirement		0	0	210	250	150	250	150	250	150	250
	Scheduled Receipts		0	0	0	0	0	0	0	0	0	0
	Projected on Hand	60	60	60	0	0	0	0	0	0	0	0
	Net Requirements		0	0	150	250	150	250	150	250	150	250
	Planned Order Receipts		0	0	150	250	150	250	150	250	150	250
	Planned Order Releases		150	250	150	250	150	250	150	250	0	0
AC101 LT 3 Q = 600	Gross Requirement		300	500	300	500	300	500	300	500	0	0
	Scheduled Receipts		0	0	0	0	0	600	0	0	0	0
	Projected on Hand	1300	1000	500	200	500	200	300	0	100	100	100
	Net Requirements		0	0	0	300	0	0	0	500	0	0
	Planned Order Receipts		0	0	0	800	0	0	0	600	0	0
	Planned Order Releases		600	0	0	0	600	0	0	0	0	0

Below is the screenshot of the MRP schedule -

mos - Excel BS File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do General Cut EL Copy Format Painter Clipboard V9 VAA === - - A- S ab Wrap Text Merge & Center - Paste BIU E $ % , Conditional Format as Cell Formatting Table Styles Styles Font Alignment Number G13 x 2 A J K L M D 1 E 2 On Hand F G 3 4 210250 H 5 150 I 6 250 2 0 0 150 250 150 250 3 O 4 60 Gross Requirement AB500 Scheduled Receipts LT 2 Projected on Hand Q = L4L Net Requirements Planned Order Receipts Planned Order Releases | | | 0 250 250 250 150 150 150 | 250 250 250 150 150 150 150 150 150 250 250 250 150 150 250 250 150 250 300 500 AC101 1300 OOOOOOO 1000 Gross Requirement Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts Planned Order Releases 500 300 500 | 300 500 300 500 0 000600 0 0 0 0 200 500 200 300 0 100 100 100 300 0 0 0 500 0 0 1 800 1 0 1 0 1 600 0 0 0 600 Q = 600 0 600 0 MPS (200)+FOQ(600)