ACCT group project

profileestelle0112
case.xlsx

Sheet1

Buffalo Wild Wings
2007 2008 2009 2010 2011 2012 2013 2014
Number of Stores
Company-owned: 161 197 232 259 319 381 434 491
Franchised: 332 363 420 473 498 510 559 591
Company-owned store sales: $379,000,000  $488,700,000  $555,200,000  $717,400,000  $964,000,000  $1,185,400,000  $1,423,000,000 
Franchise fees: $42,700,000  $502,000  $58,100,000  $67,100,000  $76,600,000  $81,400,000  $93,200,000 
Total $422,400,000  $538,900,000  $613,300,000  $784,500,000  $1,040,600,000  $1,266,800,000  $1,516,200,000 
Average # of Owned Stores 179 215 246 289 350 408 463
Sales Revenue per Owned Stores 2,117,318.44  2,278,321.68  2,261,507.13  2,482,352.94  2,754,285.71  2,908,957.06  3,076,756.76 
Average # of Franchise Stores 348  392  447 486 504 535 575
Sales Revenue per Franchise  122,877.70  1,282.25  130,123.18  138,208.03  151,984.13  152,291.86  162,086.96 
McDonald's
2007 2008 2009 2010 2011 2012 2013 2014
Number of Stores
Company-owned: 6906 6502 6262 6399 6435 6598 6738 6714
Franchised: 24471 25465 26216 26338 27075 27882 28691 29544
Company-owned store sales: $16,560,900,000  $15,458,500,000  $16,233,300,000  $18,292,800,000  $18,602,500,000  $18,874,200,000  $18,169,300,000 
Franchise fees: $6,961,500,000  $7,286,200,000  $7,841,300,000  $8,713,200,000  $8,964,500,000  $9,231,500,000  $9,272,000,000 
Total $23,522,400,000  $22,744,700,000  $24,074,600,000  $27,006,000,000  $27,567,000,000  $28,105,700,000  $27,441,300,000 
Average # of Owned Stores 6704 6382 6331 6417 6517 6668 6726
Sales Revenue per Owned Stores 2,470,301.31  2,422,203.07  2,564,299.82  2,850,677.89  2,854,676.59  2,830,563.89  2,701,352.96 
Average # of Franchise Stores 24968 25841 26277 26707 27479 28287 29118
Sales Revenue per Franchise  278,816.89  281,968.23  298,409.26  326,257.65  326,236.88  326,357.10  318,433.93