Solver question

[fabiob14]

Hi All,

I am trying to create a file which helps me make the most optimal filling order.
It is most optimal if I minimize the switching time.
When I use the solver add in to fill in the order i won't change anything.

The file that i want to create is something like this table below hwere solver fills in the order number to optimize the total switching time.
There are 3 options for the switching time, if the machine is the same it takes 12minutes, if it is a different machine it takes 3,5 minutes, if it is the same machine and same recipe it takes 0 minutes.

My question: Is solver able to help me with this file or should I choose something else?​

[TABLE="width: 349"]
<tbody>[TR]
[TD]Order[/TD]
[TD]Recipe[/TD]
[TD]Machine[/TD]
[TD]Switch time[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]A[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]B[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]C[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3,5[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]D[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]E[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3,5[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]F[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]G[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3,5[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD]H[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD]I[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3,5[/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance for you time, and if you have any questions about the parameters I used in the solver please don't hesitate to ask.

With kind regards,
fabiob14[TABLE="width: 349"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]