Hey All, I got a forecasting project dropped on me at work and need some help.

So right now my work uses a threshold function to try to pinpoint problem areas for staffing. The problem is that there is no logic behind it and we have different classifications for our field workers. So, say we have 50 technicians on our roster and we only have 20 people available for a given day, the forecast says that we are going to have staffing issues but it doesn't know to just pull some guys from another grouping. We would actually go up to our supervisors pool and take a few of those guys to make up the difference. Is there any way to get that logic into the threshold formula? Right now we just manually try to spot check everything. Sorry if I'm not being very clear. It's just because I don't even know what to try to do to make it work
PM's=10
Supervisors=40 BUT 40 Sup+ 10 PM=50 Sup available if needed
Technicians=50 BUT 50 Tech+ 40 Sup+ 10 PM = 100 Tech available if needed