Distribution of Personnel in a Simulated Corporation

Personnel across grades/bands and functional areas

In this example we develop a visualization of the organizational structure for a simulated corporation. The simulation are based roughly on industry averages for the pharmaceutical and Medicines Industry as reported by the Bureau of Labor Statistics. For instance you will see in the table provided below 30% of the personnel in R&D and 25% in manufacturing. These are based on the 31.4% reported in professional and related occupations and the 27.5% reported in production occupations in 2008 by the Bureau of Labor Statistics. However, we acknowledge that what is true for the industry as a whole may not necessarily be true for individual corporations. Further the cascading of these employees through different levels or salary grade/bands in the organization are based on our estimates. A roughly 4 to 5 fold increase in personnel is assumed when we go down a grade.  A 10,000 employee corporation was simulated. Eight grade levels are assumed starting with the CEO and going down to CEO-7. The distribution to be charted is in the following table.

Grade Logistics Finance R&D Marketing Administrative IT Manufacturing Engg/Maint Row Sum
CEO 0 0 0 1 0 0 0 0 1
CEO-1 0 2 2 1 1 0 2 0 8
CEO-2 0 10 10 4 2 3 3 1 33
CEO-3 1 40 42 10 6 20 8 2 129
CEO-4 4 180 168 44 12 106 33 6 553
CEO-5 18 768 898 316 43 371 140 21 2575
CEO-6 87 0 1880 624 223 0 528 107 3449
CEO-7 390 0 0 0 713 0 1786 363 3252
Column Sum 500 1000 3000 1000 1000 500 2500 500 10000

Tepee for an organizational as a whole

The following is a visualization of the distribution of personnel in this simulated corporation.

Please click on the graphic to see it in better resolution.