Issue optimizing schedules for employees

Use this forum to post Vensim related questions.
Post Reply
fel-vene
Junior Member
Posts: 10
Joined: Mon Dec 07, 2009 1:36 pm

Issue optimizing schedules for employees

Post by fel-vene »

Hello to everyone,
I sincerely hope that you can help me with some issues that I have trying to use Vensim optimization tool for my employee´s scheduling activity model.

Briefly, the situation is this: I´m doing a simulation model for my thesis about a process done in an invented factory. Here, there are some activities that should be terminated sequentially to finally complete the job. The rate in which the activity can be completed depend in how many employees are assigned to work in it. My purpose is then optimizing the way how the employee´s assignation to each activity should be done, taking into account that there is a limited number of employees for the whole job.

I have two main problems: 1) the total available employees for the job become negative!! (I tried conditionals, built-in range options, and cannot avoid the issue). 2) I cannot minimize the backlogs of all the activities because there are not available parameters to use in the optimization tool.

I attach my simulation model, but since I live in Colombia (South America) and the model is in Spanish, I´d colored the most important variables so I can explain them quickly: The level in red is the total available employees for the whole job. The levels in orange represent the employees that are assigned in each activity. The blue auxiliary variables represent the “backlog” of each activity measured as the percentage of the work needed to be done at the each activity over the total work for that activity (works through a lookup function colored as gray variables). The green variables are the ideal number of employees that are supposed to be working in each activity depending on its percentage of “backlog”. Since the needs change in time there is a gap between the ideal number and the already working employees (called “Brecha”) that determines the flows of assigning workers to activities.

So regarding my 2 issues:

For the first, the level in red becomes negative meaning I have negative available workers!!
For the second, I try to minimize the backlog percentage of each activity (gray variables) trying to change the lookup function that determines the ideal number of workers in each activity.

Please if you have any suggestions for my 2 issues, I will be very grateful :P.

Felipe Venegas
Attachments
Dic 7 Modelo con Optimización.mdl
(31.84 KiB) Downloaded 235 times
Felipe Venegas
bob@vensim.com
Senior Member
Posts: 1107
Joined: Wed Mar 12, 2003 2:46 pm

Post by bob@vensim.com »

The main and obvious problem with your model is that you have a negative sign for all the rates changing "Personal asignado para contratos de pisos en madera" and these should all be positive. (That is when "Asignación/desasignación de personal para adhesión neopreno" is positive, the level will decrease which is the opposite of what you want).

You should also enter units of measure for everything to make sure that the model passes units checking.
fel-vene
Junior Member
Posts: 10
Joined: Mon Dec 07, 2009 1:36 pm

Post by fel-vene »

Thanks Bob for the suggestion.

I think I am not being clear about my model. Basically the model try to simulate how the employees become busy (Level orange) when there is work to be done. On the contrary, if there is not work to be done, they become "not busy" (level red).

So the flows that connected from the level in red (meaning the quantity of empoyees non-busy) and the employees busy in each activity (busy) have negative sign because become busy. I cheked the forum and I have found a solution using the MIN function that allows me to allocate the employees in each activity without having my initial issue.

Thank you very much for all your help!

Felipe
Post Reply