Hello.

I am trying to figure out a way to forecast how many tech/support people i need. The way I am looking at it is that we have 2 types of accounts we can add. For each account type, I would then need to add 1 of 2 types of tech/support.

Accross row A I have time broken into quarters. In row B & C, I have the two types of accounts and how I anticipate them to grow during the next 5 years of quarters.

What I am having trouble doing is in the next rows for headcount. What i need to do for each accoutn type separately (rows B&C) is say "when we add 2 accoutns, regardless of quarter, hire 1 tech person. When we add 3 accounts, regardless of quarter, hire 1 support person."

So for example if in the first 4 quarters we add 9 accounts, I would need to hire 3 support people and 4 tech people. But i need to find a way to break this out to show which quarter they would be hired in.



This problem has been haunting me for the last few work days on a large, highly visible project I am working on. Any help is GREATLY appreciated. Also let me know if more info/details are needed.