Consider the following requirements for a certain productperiod：12345678Gross requirement：020020050004000400Beginning inventory = 500 units Setup cost = $500 per setupLead time = 1 weekHolding cost =

a. Lot-for-lot MRP table:

Period | Gross Req. | Projected On Hand | Net Req. | Planned Receipts | Planned Order Release | Holding Cost | Order Cost | Total Relevant Cost -------|-----------|------------------|----------|-----------------|----------------------|--------------|------------|-------------------- 1 | 0 | 500 | 0 | 0 | 0 | $0 | $0 | $0 2 | 200 | 300 | 200 | 200 | 200 | $900 | $500 | $1,400 3 | 200 | 0 | 200 | 200 | 200 | $600 | $0 | $600 4 | 500 | 300 | 500 | 500 | 500 | $1,800 | $500 | $2,300 5 | 0 | 200 | 200 | 0 | 0 | $600 | $0 | $600 6 | 400 | 600 | 200 | 400 | 400 | $1,800 | $500 | $2,300 7 | 0 | 200 | 200 | 0 | 0 | $600 | $0 | $600 8 | 400 | 600 | 200 | 400 | 400 | $1,800 | $500 | $2,300

Total Relevant Cost = $9,300

b. FOQ MRP table:

Period | Gross Req. | Projected On Hand | Net Req. | Planned Receipts | Planned Order Release | Holding Cost | Order Cost | Total Relevant Cost -------|-----------|------------------|----------|-----------------|----------------------|--------------|------------|-------------------- 1 | 0 | 500 | 0 | 0 | 0 | $0 | $0 | $0 2 | 200 | 0 | 200 | 600 | 600 | $1,800 | $500 | $2,300 3 | 200 | 400 | 0 | 0 | 0 | $1,200 | $0 | $1,200 4 | 500 | 0 | 500 | 1,100 | 1,100 | $3,300 | $500 | $3,800 5 | 0 | 600 | 0 | 0 | 0 | $1,800 | $0 | $1,800 6 | 400 | 200 | 400 | 1,000 | 1,000 | $3,000 | $500 | $3,500 7 | 0 | 800 | 0 | 0 | 0 | $2,400 | $0 | $2,400 8 | 400 | 400 | 0 | 0 | 0 | $1,200 | $0 | $1,200

Total Relevant Cost = $16,50