Inventory Management

Hello,
Our food industry manufacturing/distributor business is hoping to use NetSuite for all factors in inventory management of raw materials. This includes setting preset re-order points, restock amounts, and other required fields;managing inventory count and alerting when new orders are placed or need to be placed; and having the system consider all variables needed to make this happen.
I am looking for a report, formula, set up...whatever it is that
suits best, that will allow the NetSuite system to automatically track, alert, and re-order materials when they are needed.
The reason that this has not worked yet is because, so far from our activity, NetSuite isn't factoring in future production while also including orders that have already been placed/queued.