I did all of this a while ago when I programmed a large company's manpower planning system. And anybody who thinks that large corporations do not have manpower planning and long term management succession plans doesn't know what they are talking about. And further, anyone who quibbles about 'quotas' hasn't the first notion about how these succession plans are implemented.

I know. I wrote the software.

Company A is located in Community X

Company A has a workforce of 1000.

Company A has decided to implement an Affirmative Action program for blacks only.

Community X is 10% black.

Company X has Exempt, Non-Exempt, and Executive classes of employees. Only those in the Exempt and Non-Exempt classes are required to comply with the (fuzzy) federal regulations on Affirmative Action.

The Exempt employees, (generally salaried, white collar) are divided into 12 grades. Everyone above grade 12 is considered Executive. The non-exempts (largely hourly, blue collar) are divided into 3 grades A through C, C being lowest.

Now Im going offline to work out a spreadsheet.

That's typical, what you see to the right is a simplified model.