Motion Map Chart -- Our first Data Assignment was to create a MotionMap using information.
This is a chart representing data from Ford Motor and General Motors from 1996 until 2010. It includes data taken from CNN's Fortune 500 Listings, including Employees, Revenues, Profits, Assets, U.S. Fortune 500 Ranking, and Stockholder's Equity.
Source: CNN's Fortune 500
There are quite a few trends that can be witnessed from the various options displayed in this motion map. First let's take a look at the Line chart with Employees as the Y axis. This immediately displays that GM has been firing employees since 1994... In 1994, they had over 650, 000 employees...and now in 2010, they are at the 200,000 mark. As for Ford, they were at about 350,000 employees and kept that number steady until approximately 2006 when they also started to drastically reduce their number of employees.
Using the bubble motion chart option, with Revenue on the X axis, and Profits on the Y axis, it can be seen that it wasn't until 2002 that Ford experienced their first negative profits. Infact, it can be judged that based on the random variations of the bubble movements that Revenues and Profits are in no way correlated for Ford, as it is seemingly random. However, if you change the X axis to Assets, and keeping Profits on the Y axis, and looking at GM, it can be noticed that generally until 2005, GM was remaining profitable while assets were growing, all the way up to $479 billion in assets in 2005. It was in 2006 that GM realized a loss of $10.6 billion, possibly causing them to sell off assets(reducing to $186 billion in 2007). However, things didn't seem to get any better for GM, experiencing a loss of $38.7 billion in 2008. Continuing to reduce their assets in 2009, and experiencing another loss of $30.9 billion, this is approximately the time that the U.S. government bailed GM out. "On June 8, 2009, GM was reorganizing by bankrupty protection under the provisions of Chapter 11, Title 11, United States Code." (Source: Wikipedia ) In 2010, the chart shows that profits for GM go back to 0, however, this is slightly due to a lack of projecting any profits at all, as the company was reformed and profit numbers were skewed due to Net income not being included because it emerged from bankrupty, which apparently included forgiveness of debt, and that distorted results. ( Source: Fortune 500)
No comments:
Post a Comment