Forum Discussion

Copper Contributor

Nov 16, 2018

Tracking inventory - raw materials

Hello, I am not sure if what I want to create is possible but any assistance or guidance in the right direction will be very much appreciated. I am trying to create a spreadsheet that will allow m...

inventory

Track and Change

Lorenzo Kim

Bronze Contributor

Nov 17, 2018

I think what you need is MRP (Material Requirements Planning program).

The processes that you mentioned will entail a very complex programming.

try this site ( google other sites as well..)

https://www.webandmacros.net/excel-mrp-macro.htm

Hope that you may find a solution (or someone here can offer you one).

thanks..

Dean967

Copper Contributor

Sep 16, 2020

Hi I am trying to use excel to track raw ingredients we use in a food manufacturing business. And then to track where the product goes after we ship

Thanks

Dean