Is there an excel formula that would tell me the optimal answer to a mixture question. For instance, I need to get a stockpile of outputs in the shortest amount of time possible from ingredients that yield various amounts of these outputs.
So, if I need to obtain a stockpile of:
1,000 units of item 1
2,500 units of item 2
300 units of item 3
1,400 units of item 4
The materials I can possibly use to provduce this output are:
Input 1 yields: 100 item 1, 0 item 2, 50 item 3, 75 item 4
Input 2 yields: 250 item 1, 500 item 2, 25 item 3, 0 item 4
Input 3 yields: 500 item 1, 100 item 2, 0 item 3, 200 item 4
What I also need to take into account is the amount of time it takes to obtain the inputs. so:
in 1 hour I can get 1,000 units of input 1, 800 of input 2, 400 of input 3.
What I need is the optimal combination that takes the least amount of time to get the stockpile I need. the formula(s) would tell me the optimal combination and how long it would take to get them.
I'm wracking my brain on this and have run into the limits of my excel knowledge.
Bookmarks