Worldwide Sporting Goods
Quarterly  Sales
QTR2 Qtr1 Apr May Jun Qtr2 % Sales Bonus
J. Smith 63,500.00 20,000.00 25,000.00 21,000.00 66,000.00 12.6% 5,280.00
Line Callout 4: =IF(F6>B6,F6*0.08,0)
G. Frankel 57,500.00 15,000.00 22,000.00 18,500.00 55,500.00 10.6% 0.00
J. Hamilton 41,300.00 14,700.00 16,000.00 20,600.00 51,300.00 9.8% 4,104.00
T. Ticknor 67,500.00 12,000.00 30,000.00 35,500.00 77,500.00 14.8% 6,200.00
M. Donder 48,595.00 18,000.00 13,488.00 12,000.00 43,488.00 8.3% 0.00
L. Smith 72,900.00 14,800.00 40,000.00 21,400.00 76,200.00 14.5% 6,096.00
B. Manny 95,000.00 12,500.00 75,000.00 66,500.00 154,000.00 29.4% 12,320.00
Totals 446,295.00 107,000.00 221,488.00 195,500.00 523,988.00 100.0%  
Averages 63,756.43 15,285.71 31,641.14 27,928.57 74,855.43