How does MRP work?
MRP combines three inputs: how much product will be sold or produced, the bill of materials (which materials one product needs) and stock on hand and on order. Current stock is subtracted from gross requirements to find net requirements. Net requirements are dated backwards according to lead time and become purchase requests or production work order suggestions. The system can redo this calculation with every order; in a manually calculated Excel sheet it is easy to forget the update when an order changes.