A Balanced Workforce Model


A More Sophisticated Model

Now I will explain how I came to understand the mechanics of Affirmative Action. If you are turned off by math, you may not care for the ensuing text.

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.

 

MajM

MajM

MajF

MajF

MinM

MinM

MinF

MinF

 

Total

Total %

 

#

%

#

%

#

%

#

%

     
                       

Exec

4

80%

1

20%

0

0%

0

0%

 

5

1%

Sr. Mgmt

7

78%

1

11%

1

11%

0

0%

 

9

2%

Directors

7

88%

1

13%

0

0%

0

0%

 

8

1%

Middle Mgmt

20

74%

3

11%

3

11%

1

4%

 

27

5%

White Collar

43

46%

34

37%

12

13%

4

4%

 

93

16%

Entry Level

43

48%

5

6%

12

13%

30

33%

 

90

16%

Non Sal Staff

3

10%

6

21%

8

28%

12

41%

 

29

5%

Supervisory

12

27%

1

2%

30

67%

2

4%

 

45

8%

Skilled Labor

98

66%

12

8%

30

20%

8

5%

 

148

26%

Unskilled Labor

55

46%

3

3%

55

46%

6

5%

 

119

21%

Total

292

51%

67

12%

151

26%

63

11%

 

573