How to calculate Royalty Fee and %. Using the already given data.

Pizza by Mario 2015 Franchise Sales Store 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 City State Detroit Michigan Detroit Michigan Flint Michigan Ann Arbor Michigan Ann Arbor Michigan Kalamazoo Michigan Port Huron Michigan Toledo Ohio Toledo Ohio Toledo Ohio Akron Ohio Cincinat Ohio Madison Wisconsin Madison Wisconsin Milwaukee Wisconsin Milwaukee Wisconsin Milwaukee Wisconsin Cedar Rapids Iowa Cedar Rapids Iowa Cedar Rapids Iowa Des Moines Iowa Lansing Michigan Green Bay Wisconsin Columbus Ohio Davenport Iowa Livonia Michigan TOTAL SALES AND ROYALTY FEES Year Est. 2002 2002 2003 2004 2004 2004 2004 2004 2005 2005 2005 2006 2006 2006 2007 2007 2007 2008 2008 2009 2009 2010 2010 2011 2011 2014 Sales 652,458 466,153 324,965 652,146 378,458 528,346 345,892 653,485 354,268 554,213 461,853 512,463 325,496 745,865 451,236 554,168 653,856 541,285 347,856 568,457 641,257 347,865 401,588 504,796 310,496 314,698 12,593,619 Royalty % Royalty Fee Franchise Statistics Section Franchise Royalty Rate Table Royalty payment to head office based on sales 300,000 400,000 500,000 600,000 700,000 800,000 1% 2% 3% 4% 5% 6% Franchisees pay a royalty fee calculated as a percent of sales. The percentage charged is the rate that is closest to the sales value without going over. Example: Gross Sales = 530,000; Royalty is 3% of 530,000