Consider the following requirements for a certain product.

Period	1	2	3	4	5	6	7	8
Gross requirements	0	200	200	500	0	400	0	400

Beginning inventory = 500 units

Setup cost = $500 per setup

Lead time = 1 week

Holding cost = $3 per unit per week

a. Develop the lot-for-lot MRP table.

b. Calculate the total relevant costs.

Period		1	2	3	4	5	6	7	8
Gross requirements		0	200	200	500	0	400	0	400
Projected on hand	500
Net Requirement
Planned Reciept
Planned Order

Setup Cost=

Holding Cost=

Total Cost =