Using MS Excel, build a Material Requirements Planning $($MRP$)$ record based on the following Master Production Schedule and Inventory Records File.

MPS: Master Production Schedule

Finished Product: Rocking Chair

Date

April $5$ April $12$ April $19$ April $26$ May $3$ May $10$

Required Demand $75,75,75,100,100,125$

Inventory Records File $($IRF$)$

Scheduled Receipts

SR $200$ on April $12$

Initial Stock Balance $($Beginning Inventory$)$ BI $100$

Lead Time

LT $2$ weeks

Safety Stock

SS $10$

Lot Size Discipline

Qd LFL