Forum Discussion
Production Allocation
Arsal715 You describe this as a "very simple problem" but that is because it's very clear in your mind.
If you want help you will need to provide a lot more details, so that those of us who aren't as close to it as you are, can begin to grasp the details. Please give an example written out of how this allocation is done, or at least pointing in that direction.
Ideally, you'd have tried already to create a spreadsheet, and could upload that as a starting point.
It does sound like an interesting problem, I agree, and maybe it will be simple too. But at this point, it's just not clear enough....
You are right, I have attached an excel sheet which explains the problem and what I am trying to do.
That spreadsheet is a good start, but I personally would still need to know a little more. As I said, the scope of this, even the mental procedure is clear in YOUR mind. If I were there with you in person, I'd want you to walk me through a bit of how you solve this now.
But, all that said, it's pretty clear that you would benefit from a specific Excel Add-in called "Solver" Here's an screen image of what comes up if you search in Excel's Help function. It's entirely possible that you could resolve your own situation simply by loading Solver and following its procedures.
And here's a screen grab of the dialog box that opens up when you activate the Solver Add-In. Just looking at it tells me that I'd need to know a bit more, probably experiment with just a few of the production units and machines to make sure I was using the right "engine"...and then too, are we talking getting all of this done in one day, one week? Just as soon as possible?
I am trying to use solver but it is not giving me the right answer. So there are different SKUs listed from GT-1 to GT-36. The number of units with each SKU is written with their numbers. I want to allocate each item to different machines which are written as machine-1 , 2, 3 etc. The only constraint is the capacity of the machines. I want to allocate the production units in a way that capacity of the machines is satisfied.
