Sales Ledger

Employee Name Region Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4

Silva Northeast $115,500 $65,500 $84,000 $187,110
Maddox Northeast $113,500 $120,550 $243,760 $197,830
Koval Southwest $104,500 $113,000 $100,700 $110,925
Lindgren South $79,500 $113,500 $88,000 $61,670
Sykes North $125,000 $170,000 $105,000 $192,215
Lee Southwest $120,550 $274,060 $76,000 $142,320
Gilgamos Southwest $128,000 $243,760 $151,500 $92,215
Matthews South $113,000 $292,225 $84,000 $102,270
Anderson North $113,500 $243,240 $184,275 $147,150
Wagner Northeast $119,000 $138,500 $63,000 $88,950
Roberts South $274,130 $296,120 $120,500 $118,335
Avellone Southwest $156,000 $115,500 $88,500 $171,050
Clarke Southwest $251,120 $86,500 $76,000 $136,650
Chen Northeast $77,500 $95,000 $151,500 $172,410
Nguyen South $154,500 $122,000 $84,000 $149,215
Basara Northeast $74,075 $65,500 $57,900 $77,950
Bryant North $122,500 $128,000 $110,000 $194,215
Antonov Northeast $104,500 $113,000 $100,700 $147,330
King South $79,500 $113,500 $88,000 $195,015
Masterson Southwest $125,000 $170,000 $105,000 $137,215
Bailey North $120,550 $274,060 $76,000 $99,700
Huxley Southwest $128,000 $243,760 $151,500 $147,325
Washington North $98,500 $292,225 $84,000 $171,650
Levine Northeast $154,320 $141,650 $97,100 $104,320
Harala South $109,140 $99,320 $132,880 $102,900
Plinkett South $220,605 $201,390 $133,180 $250,580
Gonzalez Northeast $112,000 $132,030 $114,300 $156,340
Langley North $87,340 $253,100 $271,550 $137,880
Smith South $93,990 $191,100 $101,380 $85,620
Carmine North $146,850 $84,955 $184,060 $171,110
Dubois Southwest $129,410 $110,510 $135,540 $99,215
Zhou Northeast $97,775 $106,870 $140,700 $128,480
Romero South $98,130 $170,325 $162,740 $121,150
Johanson Northeast $121,010 $113,680 $106,560 $97,540
Nolan North $109,340 $220,900 $257,430 $168,340
Jacobs Southwest $131,880 $126,400 $183,040 $154,000
Lambert Southwest $258,990 $155,100 $110,330 $118,670
Moore South $134,400 $145,870 $109,350 $126,640
Garcia Northeast $141,710 $94,770 $132,270 $104,190
Saito North $119,500 $89,320 $178,450 $254,100
Ryan South $99,120 $118,500 $161,900 $164,330
Jankowski Northeast $105,650 $260,770 $203,450 $158,910
Minos Southwest $127,380 $140,360 $115,375 $162,880
van Dorn South $122,085 $105,330 $144,785 $120,550
Kim South $83,650 $174,700 $78,115 $103,840
Mendel Northeast $112,880 $207,340 $172,055 $237,460
Henderson Northeast $220,100 $192,960 $92,065 $107,215
Walker Southwest $163,750 $101,850 $95,105 $89,415
Rivera South $134,560 $154,750 $230,550 $94,560
Phillips North $167,500 $281,750 $133,385 $152,200
Sales Ledger

Total Average Highest Lowest Commission

$452,110 $113,027.50 $187,110.00 $65,500.00 $18,084.40
$675,640 $168,910.00 $243,760.00 $113,500.00 $27,025.60
$429,125 $107,281.25 $113,000.00 $100,700.00 $17,165.00
$342,670 $85,667.50 $113,500.00 $61,670.00 $13,706.80
$592,215 $148,053.75 $192,215.00 $105,000.00 $23,688.60
$612,930 $153,232.50 $274,060.00 $76,000.00 $24,517.20
$615,475 $153,868.75 $243,760.00 $92,215.00 $24,619.00
$591,495 $147,873.75 $292,225.00 $84,000.00 $23,659.80
$688,165 $172,041.25 $243,240.00 $113,500.00 $27,526.60
$409,450 $102,362.50 $138,500.00 $63,000.00 $16,378.00
$809,085 $202,271.25 $296,120.00 $118,335.00 $32,363.40
$531,050 $132,762.50 $171,050.00 $88,500.00 $21,242.00
$550,270 $137,567.50 $251,120.00 $76,000.00 $22,010.80
$496,410 $124,102.50 $172,410.00 $77,500.00 $19,856.40
$509,715 $127,428.75 $154,500.00 $84,000.00 $20,388.60
$275,425 $68,856.25 $77,950.00 $57,900.00 $11,017.00
$554,715 $138,678.75 $194,215.00 $110,000.00 $22,188.60
$465,530 $116,382.50 $147,330.00 $100,700.00 $18,621.20
$476,015 $119,003.75 $195,015.00 $79,500.00 $19,040.60
$537,215 $134,303.75 $170,000.00 $105,000.00 $21,488.60
$570,310 $142,577.50 $274,060.00 $76,000.00 $22,812.40
$670,585 $167,646.25 $243,760.00 $128,000.00 $26,823.40
$646,375 $161,593.75 $292,225.00 $84,000.00 $25,855.00
$497,390 $124,347.50 $154,320.00 $97,100.00 $19,895.60
$444,240 $111,060.00 $132,880.00 $99,320.00 $17,769.60
$805,755 $201,438.75 $250,580.00 $133,180.00 $32,230.20
$514,670 $128,667.50 $156,340.00 $112,000.00 $20,586.80
$749,870 $187,467.50 $271,550.00 $87,340.00 $29,994.80
$472,090 $118,022.50 $191,100.00 $85,620.00 $18,883.60
$586,975 $146,743.75 $184,060.00 $84,955.00 $23,479.00
$474,675 $118,668.75 $135,540.00 $99,215.00 $18,987.00
$473,825 $118,456.25 $140,700.00 $97,775.00 $18,953.00
$552,345 $138,086.25 $170,325.00 $98,130.00 $22,093.80
$438,790 $109,697.50 $121,010.00 $97,540.00 $17,551.60
$756,010 $189,002.50 $257,430.00 $109,340.00 $30,240.40
$595,320 $148,830.00 $183,040.00 $126,400.00 $23,812.80
$643,090 $160,772.50 $258,990.00 $110,330.00 $25,723.60
$516,260 $129,065.00 $145,870.00 $109,350.00 $20,650.40
$472,940 $118,235.00 $141,710.00 $94,770.00 $18,917.60
$641,370 $160,342.50 $254,100.00 $89,320.00 $25,654.80
$543,850 $135,962.50 $164,330.00 $99,120.00 $21,754.00
$728,780 $182,195.00 $260,770.00 $105,650.00 $29,151.20
$545,995 $136,498.75 $162,880.00 $115,375.00 $21,839.80
$492,750 $123,187.50 $144,785.00 $105,330.00 $19,710.00
$440,305 $110,076.25 $174,700.00 $78,115.00 $17,612.20
$729,735 $182,433.75 $237,460.00 $112,880.00 $29,189.40
$612,340 $153,085.00 $220,100.00 $92,065.00 $24,493.60
$450,120 $112,530.00 $163,750.00 $89,415.00 $18,004.80
$614,420 $153,605.00 $230,550.00 $94,560.00 $24,576.80
$734,835 $183,708.75 $281,750.00 $133,385.00 $29,393.40
 Commission rate 4%

Total number of employees 50

Employees resigned 1 Click here for additiona
Employee ID
S1001
S1002
S1003
S1004
S1005
S1006
S1007
S1008
S1009
S1011
S1012
S1013
S1014
S1015
S1016
S1017
S1018
S1019
S1020
S1021
S1022
S1023
S1024
S1025
S1026
S1027
S1028
S1029
S1030
S1031
S1032
S1033
S1034
S1035
S1036
S1037
S1038
S1039
S1040
S1041
S1042
S1043
S1044
S1045
S1046
S1047
S1048
S1049
S1050
S1051
ick here for additional sales data