What are the 100 largest companies in the world, by revenues, in rank
order of size?  What are the 100 companies in the world, by number of
employees, in rank order of size?

What are the 250 largest companies in EMEA (Europe, Middle East,
Africa), by revenues, in rank order of size?  What are the 250 largest
companies in Asia (incl. Australia and New Zealand), by revenues, in
rank order of size?  What are the 250 largest companies in the US and
Canada, by revenues, in rank order of size?  What are the 250 largest
companies in Latin America (incl. Mexico and S. America), by revenues,
in rank order of size?

Each of these lists is requested in spreadsheet format.  For each
company listed, please indicate annual revenues, headquarters
location, and (where available) number of employees.

---

Clarification of Question by scrh-ga on 27 Oct 2005 06:21 PDT

Please include full citations for all sources.  Many thanks.

---

Request for Question Clarification by pafalafa-ga on 27 Oct 2005 19:20 PDT

scrh-ga,

scrh-ga,

I think I can create the lists you want for companies ranked by revenue size.

The companies by employee-size, though, is a different matter.

Oddly, I've found two sources of information that allow me to create
lists of top-ranked companies by employee size.

HOWEVER, the services don't actually provide the actual data on number
of employees,  Instead, the companies are simply listed
alphabetically.

In other words, I can crank out a list of the 250 largest companies in
the world (by employee size), and I can tell you that the companies
each have more than 25,000 employees, but I can't tell you the
employee size for each company.  Nor can I rank the list, except
alphabetically.

But again, I think I can manage the ranking-by-revenue lists.

Would that meet your needs?  Even given the limits on the employee-size lists?


Let me know what you think.


pafalafa-ga

---

Clarification of Question by scrh-ga on 28 Oct 2005 04:57 PDT

pafalafa-ga,

Thanks for the question.  That constraint isn't ideal, but I
understand the limitations of the data.  As a substitute, do you think
there are any sources which rank the companies by spending on
information technology?

Many thanks for your help.

Also, as a follow on question, I would like to have indicated the
vertical industries of each company on the list.  Since you already
have the list, if you're interested, could we arrange to do that with
payment via a tip?  Or must I post it as a separate question?


Again, many thanks.
Again

---

Request for Question Clarification by pafalafa-ga on 28 Oct 2005 07:21 PDT

scrh-ga,

Thanks for getting back to me.

I've solved one problem, and run into another.

I've been able to access the employee information for companies, so I
can now create a list of the largest companies in the world by
employee size, such as:

1.  Wal Mart -- 1,700,000

2.  McDonalds -   438,000

3.  Petro China - 424,175

and so on.


I can do this globally, as well as for individual regions, such as Asia/Pacific.



I can create lists by revenue, as well.  

But here's where the new problem pops up.  Although all revenues in
the data base are supposedly US dollars, it is clear that some of the
numbers are not properly transcribed from local curreny.

Several companies show up with trillion dollar revenues, which is
absurd.  As far as I can tell, these are original revenues in local
currencies, that were not translated into dollars.

Here's an example, from the top 20 companies listed:

Company Name.................................Total Revenue

Alarko Holding A.S. (Turkey)................$2,565,413,000,000
Coppel S.A. de C.V. (Mexico)................$1,562,806,167,130
Fortis SA/NV (Belgium)......................$1,067,584,927,800
Aldeasa SA (Spain)............................$852,612,003,242
C.A. La Electricidad de Caracas (Venezuela)...$589,680,659,000
Royal Dutch/Shell Group of Cos................$337,522,000,000
Exxon Mobil Corp..............................$293,074,000,000
Wal-Mart Stores Inc...........................$287,989,000,000
BP p.l.c. (United Kingdom)....................$285,059,000,000
Kordsa Sabanci Dupont Endustriyel ............$238,271,168,300
General Motors Corp...........................$193,517,000,000
DaimlerChrysler AG (Germany)..................$192,262,650,600
Akcansa Cimento Sanayi ve Ticaret A.S.........$184,049,681,200
Toyota Motor Corp. (Japan)....................$172,529,191,800
Ford Motor Co. (DE)...........................$171,652,000,000
Total S.A. (New)..............................$166,062,180,000
FinansBank A.S. (Turkey)......................$162,366,400,000
Chevron Corporation...........................$152,718,000,000
General Electric Co. (United States)..........$152,363,000,000


You can see that some of the companies clearly belong on the list,
while some of the figures are wildly erroneous.


Of course, there's always the Fortune 500 list, which is a reliable
and accurate source, but that only gets you a global picture of the
top few hundred companies.

It will not produce lists of 250 companies in most regions of the
world, but can certainly get you around the Top 100 in each region.


So....that's where things stand at the moment:

--I can create a Top 250 list for the world based on employee size

--I can create Top 100 lists for regions, using the Fortune 500 data.  

--Or...I can create regional Top 250 lists based on employee data
rather than revenue

--Or...I can crank out the Top 250 lists by revenue, using the mostly
accurate -- but occasionaly wildly inaccurate -- revenue data.



So, let me know what you think of all this.

pafalafa-ga

---

Clarification of Question by scrh-ga on 28 Oct 2005 08:16 PDT

Thanks for such a clear explanation of the choices.  
As stated in the initial question, I'd like this revenue data AND the
employee-ranked list, too, globally and regionally.

Regarding the apparent anomolies in the revenue data: I can accept the
inaccuracies; if can flag any obvious ones in the list, I'd appreciate
it.  If you can include the Fortune 500 (or 1,000 or whatever is
available) information, too, I can do a sanity check on at least some
of the companies.

Thanks again -- I appreciate your diligence!