3-variable Bubble Chart
xoon
03_caulfield_sales_data_mv_plots.xlsxIncome Stmts
| Horizontal Analysis | Vertical Analysis | |||||||
| Income Statement | 2011 | 2010 | 2009 | 2011-10 | 2010-09 | 2011 | 2010 | 2009 |
| Sales (net) | 38,000,000 | 36,300,000 | 35,000,000 | 4.68% | 3.71% | 100.00% | 100.00% | 100.00% |
| Cost of Sales | 30,200,000 | 28,650,000 | 28,800,000 | 5.41% | -0.52% | 79.47% | 78.93% | 82.29% |
| Gross margin | 7,800,000 | 7,650,000 | 6,200,000 | 1.96% | 23.39% | 20.53% | 21.07% | 17.71% |
| Selling & administrative | 6,250,000 | 5,820,000 | 5,800,000 | 7.39% | 0.34% | 16.45% | 16.03% | 16.57% |
| Operating income | 1,550,000 | 1,830,000 | 400,000 | -15.30% | 357.50% | 4.08% | 5.04% | 1.14% |
| Other items | 542,500 | 640,500 | 140,000 | -15.30% | 357.50% | 1.43% | 1.76% | 0.40% |
| Net income | 1,007,500 | 1,189,500 | 260,000 | -15.30% | 357.50% | 2.65% | 3.28% | 0.74% |
Sales History
| Industry | Product # | 2007 | 2008 | 2009 | 2010 | 2011 | 2011 Product Profitability | 2011 Profit Margin | 2-Year CAGR (09-11) |
| Electronics | A297 | $235,600 | $380,000 | $401,812 | $418,950 | $188,527 | 45.00% | 5.00% | |
| Electronics | A387 | 670,000 | 720,672 | 803,346 | -40,167 | -5.00% | 9.50% | ||
| Appliances | B290 | 1,630,800 | 1,812,000 | 2,265,000 | 2,284,000 | 2,219,926 | 887,970 | 40.00% | -1.00% |
| Appliances | B358 | 1,654,350 | 2,017,500 | 2,690,000 | 2,798,122 | 2,853,821 | -114,152 | -4.00% | 3.00% |
| Appliances | B378 | 369,000 | 450,000 | 482,603 | 515,205 | 164,865 | 32.00% | 7.00% | |
| Appliances | B561 | 225,225 | 341,250 | 525,000 | 501,000 | 612,360 | 97,977 | 16.00% | 8.00% |
| Tools | C194 | 243,390 | 324,520 | 427,000 | 485,286 | 516,670 | 232,501 | 45.00% | 10.00% |
| Tools | C206 | 2,071,300 | 2,690,000 | 2,833,377 | 2,965,725 | 682,116 | 23.00% | 5.00% | |
| Tools | C219 | 564,212 | 910,020 | 1,046,000 | 1,057,832 | 1,088,258 | -54,413 | -5.00% | 2.00% |
| Tools | C693 | 140,811 | 165,660 | 251,000 | 290,815 | 343,594 | 171,797 | 50.00% | 17.00% |
| Tools | C903 | 578,500 | 890,000 | 917,368 | 981,225 | 147,183 | 15.00% | 5.00% | |
| Tools | C947 | 271,405 | 437,750 | 515,000 | 536,312 | 611,871 | 110,136 | 18.00% | 9.00% |
| Automotive | D093 | 744,610 | 836,640 | 1,328,000 | 1,308,077 | 1,275,410 | 599,442 | 47.00% | -2.00% |
| Automotive | D102 | 428,000 | 461,775 | 527,339 | 73,827 | 14.00% | 11.00% | ||
| Automotive | D290 | 647,570 | 841,000 | 912,898 | 962,861 | 356,258 | 37.00% | 7.00% | |
| Automotive | D483 | 1,284,725 | 1,976,500 | 2,950,000 | 3,099,609 | 3,377,455 | 1,047,011 | 31.00% | 7.00% |
| Automotive | D780 | 3,045,013 | 4,171,250 | 5,875,000 | 5,951,356 | 6,052,572 | 484,205 | 8.00% | 1.50% |
| Automotive | D917 | 147,628 | 202,230 | 321,000 | 380,447 | 377,889 | -37,789 | -10.00% | 8.50% |
| Heavy Equip | E024 | 156,000 | 685,000 | 1,850,000 | 2,095,703 | 2,341,406 | 23,414 | 1.00% | 12.50% |
| Heavy Equip | E401 | 577,275 | 769,700 | 895,000 | 905,000 | 842,105 | 218,947 | 26.00% | -3.00% |
| Heavy Equip | E407 | 232,720 | 852,000 | 948,998 | 1,107,259 | 177,161 | 16.00% | 14.00% | |
| Heavy Equip | E621 | 391,000 | 371,939 | 352,877 | 91,507 | 25.93% | -5.00% | ||
| Heavy Equip | E792 | 2,750,000 | 3,534,000 | 4,650,000 | 4,755,000 | 4,883,360 | 2,173,566 | 44.51% | 2.50% |
| Heavy Equip | E993 | 612,800 | 1,820,000 | 1,800,000 | 1,968,516 | 118,111 | 6.00% | 4.00% | |
| Various | Lost sales | 21,064,557 | 9,068,490 | ||||||
| $34,500,000 | $32,000,000 | $35,000,000 | $36,300,000 | $38,000,000 | $7,800,000 | 4.20% | |||
