In a manufactuing company, we have X products and their parts that are becoming obsolete. Before they become obsolete, we need to use as much of the current inventory as possible. We are allowed to buy new parts to use up current inventory as long as it doesn't exceed the $ amount that it will allow us to use up (for example you could buy wheels even if they are becoming obsolete because it will allow you to use up some motors).
I think the best way to solve this would be to use Excel's solver but I'm not sure how to do it.. Anyone have a pointer?
please find attached an example (the real data will have about 50 possible products that can be built out of about 300 parts and they don't necessarily use all parts). forum.ozgrid.com/index.php?attachment/33839/