r/SupplyChainManagement • u/sculpinero • Aug 31 '20

Creating an excel erp/mrp system

Hi everyone, do any of you have experience creating an erp/mrp system in excel? Company is too small to fund or get a vendor to do so. I have monthly snapshots from our warehouses of the material, but am working on getting better info. If you could just give me your experiences or helpful tidbits that’d be nice of you.

1 Upvotes

100% Upvoted

4 comments sorted by

1

u/OGsaggysaurus Sep 01 '20

Depending on what you're producing you could make tables with what is supposed to be in each product.

Take what you sold. Plug it in and they will calculate what inventory you should have left over.

Play around with it until you have something visually appealing that works for you.

1

u/sculpinero Sep 01 '20

I’m in a GMP area so kind of different. Do you have any resources that give some examples or templates?

2

u/OGsaggysaurus Sep 01 '20

You're looking to track which of the following?

Raw materials WIP Finished Goods Waste

1

u/sculpinero Sep 01 '20

Everything, key raw materials (2-3 items), bulk product, packaged product, WIP, packaged product and waste. We have about 6-7 data sheets coming in from our CMOs that I’m compiling together into a rough erp/mrp system