Hello, we are experiencing fast growth due to the pandemic for our machines to help build testing equipment & vaccines. We have simplified our offerings and are adding standard machines to Sales Orders as special work order assemblies. The hope is that as orders are put up the work orders are created in a planned stage and it will let us forecast what items we will be out of stock on so we can get alerts on what items we will need to order.
Example:
Machine "Ultra S3 120vac" is added to the sales order and it automatically creates a work order in the planned stage for the below items needed to make the Ultra S3 120vac:
1 x 600-0002 "120 vac Ultra Boxes"
1 x 600-0032 "Base & Column"
2 x 600-0022 " S3 Actuators"
Then we get an order for 12 of the Ultra S3 120vacs, another for 3, another for 4... We would like to know how many of the 600 series items we need in the coming weeks/months to meet supply so our purchasing people and engineers can be ready. Also we need to know if the 600-0002s have enough supply to build those. ex: we need PLCs to build the 600-0002s and want to make sure we have enough supply.
We desperately need help predicting this, we are at 4x our usual back log. Hoping the power of Netsuite can solve this!