I have specific problem which is best described by a picture.
There are products which fall into category of a products A, B and C. Next to it you can find quantities of which they are produced. f you want to rebuild machine from cat. A to B etc. it will cost you time (ruling is described next to it).
I need to find a way how to determine time of rebuild. I did it manually and you can see it column C. However, I wish Excel would do it automatically. Later I am using data in solver.
Does anyone know solution to my problem? Thanks in advance.
Aucun commentaire:
Enregistrer un commentaire