Week	1	2	3	4	5	6	7	8
Forecast	80	80	80	80	100	100	100	100
Committed Customer Orders	65	35	30	20	0	0	0	0
Projected On-hand Ending Inventory	70	190	110	30	130	30	130	30
Net Inventory Before MPS	70	-10	110	30	-70	30	-70	30
MPS Receipt	0	200	0	0	200	0	200	0
MPS Start	200	0	0	200	0	200	0	/
Available-To-Promise Inventory (Uncommitted)	90	135	/	/	180	/	200	/

Table 1: MPS table for end product 'W' in Question1

1. Use your master production schedule (i.e., MPS Start) in Table 1 to develop a material requirement plan (MRP) for the subassembly L using the lot-for-lot policy. [4 marks]

Week	1	2	3	4	5	6	7	8
MPS Start for 'W'
L	Lead Time = 1 week; On-hand inventory = 400 units;
	Scheduled Receipt in Week 1 = 350 Units
Gross Requirement
Scheduled Receipts
Projected on Hand Ending Inventory
Net Requirement
PO Receipts
PO Releases