i need to analyse a simple database which has the following columns-
1. Name of product
2. Components used in product
3. Quantity of each component
4. Oldest Product required first
5. Priority assigned, if any, to any product
Need to build a priority for which component to manufacture first based on some criteria-
1. Oldest orders above a minimum quantity get top priority
2. Orders which required fewest components get second priority
The database is maintained on XL/google sheets. Our preference is to AI or another too to give a daily task priority
... Show more