Do you think Airtable can be used for advanced planning & scheduling for a manufacturing company? More specifically, there are several machines and work stations with manual labour wheareas some workflow steps are necessary and some are not depending on the sales order. I want to calculate the optimal order when the material has to be placed at a certain machine or work station to manufacture the product. It is a relatively low volume, but high variety production.
We use Microsoft SQL Server/Navision which is the basis for our production data. There are scanners at each work station to track where the object to be produced is. Based on this, could Airtable be used to calculate the optimal order as described above and display when which object should be placed at a certain machine or work station? The calculation should consider the delivery deadline, capacity usage, production time and other factors.