informe de ventas

14
nombre vendedor identificacion ener ventas Carolina Perez 1072650120 $ 6,000,000 andrea ramirez 1018411353 $ 4,896,754 susana santana 1072665323 $ 3,000,500 luisa silva 1054590801.66667 $ 5,899,000 andres calderon 1054598403.16667 $ 5,436,781 nicolas tenjo 1054606004.66667 $ 9,876,543 juan pablo calderon 1054613606.16667 $ 5,678,456 maria paula arizabaleta 1054621207.66667 $ 3,000,000 viviana perez 1054628809.16667 $ 5,000,000 Cristian Galves 1054636410.66667 $ 7,000,000 santiago chaves 1054644012.16667 $ 6,578,904 sebastian socha 1054651613.66667 $ 9,999,999 daniel rodriguez 1054659215.16667 $ 7,898,898 samuel rodriguez 1054666816.66667 $ 5,678,987 fabian espitia 1054674418.16667 $ 3,245,987 camilo torres 1054682019.66667 $ 2,567,890 jaime garzon 1054689621.16667 $ 3,456,789 raul zaragoza 1054697222.66667 $ 3,456,789 david cardenas 1054704824.16667 $ 9,564,876 laura rojas 1054712425.66667 $ 2,345,678 Total ventas mes ### total comisiones venta maxima $ 9,999,999 venta minima $ 2,345,678 comisiones Carolina Perez 1.80% andrea ramirez 1.70% susana santana 1.60% luisa silva 1.40% andres calderon 1.30% nicolas tenjo 1.20% juan pablo calderon 1.50% maria paula arizabaleta 1.90% viviana perez 1.70% Cristian Galves 1.60% santiago chaves 1.50% sebastian socha 1.80% daniel rodriguez 2%

Upload: paola-ramirez

Post on 03-Oct-2015

13 views

Category:

Documents


1 download

DESCRIPTION

Informe de Ventas

TRANSCRIPT

datosnombre vendedoridentificacionenerofebreromarzoabrilmayojuniojulioagostoseptiembreoctubrenoviembrediciembretotal ventas vendedor totalventas comisionventasComision ventas Comision ventas Comision ventas Comision ventas Comision ventas Comision ventas Comision ventas Comision ventas Comision ventas Comision ventas Comision ventas Comision Carolina Perez1072650120$ 6,000,000$ 108,000$ 2,346,789$ 42,242$ 2,000,000$ 36,000$ 8,400,000$ 151,200$ 6,200,000$ 111,600$ 3,900,000$ 70,200$ 1,234,568$ 22,222$ 6,000,000$ 108,000$ 8,400,000$ 151,200$ 7,500,000$ 135,000$ 1,234,568$ 22,222$ 3,100,000$ 55,800$ 56,315,925$ 1,013,687andrea ramirez1018411353$ 4,896,754$ 83,245$ 5,678,904$ 96,541$ 3,000,000$ 51,000$ 8,300,000$ 141,100$ 6,100,000$ 103,700$ 3,800,000$ 64,600$ 1,083,457$ 18,419$ 4,896,754$ 83,245$ 8,300,000$ 141,100$ 7,400,000$ 125,800$ 1,083,457$ 18,419$ 3,000,000$ 51,000$ 57,539,326$ 978,169susana santana1072665323$ 3,000,500$ 48,008$ 9,876,543$ 158,025$ 4,000,000$ 64,000$ 8,200,000$ 131,200$ 5,900,000$ 94,400$ 3,700,000$ 59,200$ 1,234,568$ 19,753$ 3,000,500$ 48,008$ 8,200,000$ 131,200$ 7,300,000$ 116,800$ 1,234,568$ 19,753$ 4,567,234$ 73,076$ 60,213,913$ 963,423luisa silva1054590801.66667$ 5,899,000$ 82,586$ 2,345,678$ 32,839$ 5,000,000$ 70,000$ 8,100,000$ 113,400$ 5,800,000$ 81,200$ 3,600,000$ 50,400$ 3,214,579$ 45,004$ 5,899,000$ 82,586$ 8,100,000$ 113,400$ 7,200,000$ 100,800$ 3,214,579$ 45,004$ 5,678,904$ 79,505$ 64,051,740$ 896,724andres calderon1054598403.16667$ 5,436,781$ 70,678$ 5,467,890$ 71,083$ 6,000,000$ 78,000$ 7,800,000$ 101,400$ 5,700,000$ 74,100$ 3,500,000$ 45,500$ 4,568,089$ 59,385$ 5,436,781$ 70,678$ 7,800,000$ 101,400$ 7,100,000$ 92,300$ 4,568,089$ 59,385$ 2,345,678$ 30,494$ 65,723,308$ 854,403nicolas tenjo1054606004.66667$ 9,876,543$ 118,519$ 5,678,904$ 68,147$ 7,000,000$ 84,000$ 7,700,000$ 92,400$ 5,600,000$ 67,200$ 3,400,000$ 40,800$ 1,234,679$ 14,816$ 9,876,543$ 118,519$ 7,700,000$ 92,400$ 6,000,000$ 72,000$ 1,234,679$ 14,816$ 9,874,329$ 118,492$ 75,175,677$ 902,108juan pablo calderon1054613606.16667$ 5,678,456$ 85,177$ 3,567,890$ 53,518$ 8,000,000$ 120,000$ 7,600,000$ 114,000$ 5,500,000$ 82,500$ 3,300,000$ 49,500$ 7,654,328$ 114,815$ 5,678,456$ 85,177$ 7,600,000$ 114,000$ 6,900,000$ 103,500$ 7,654,328$ 114,815$ 1,234,567$ 18,519$ 70,368,025$ 1,055,520maria paula arizabaleta1054621207.66667$ 3,000,000$ 57,000$ 2,654,987$ 50,445$ 9,000,000$ 171,000$ 7,500,000$ 142,500$ 5,400,000$ 102,600$ 3,200,000$ 60,800$ 9,700,000$ 184,300$ 3,000,000$ 57,000$ 7,500,000$ 142,500$ 6,800,000$ 129,200$ 9,700,000$ 184,300$ 9,876,534$ 187,654$ 77,331,521$ 1,469,299viviana perez1054628809.16667$ 5,000,000$ 85,000$ 5,678,904$ 96,541$ 9,800,000$ 166,600$ 7,400,000$ 125,800$ 5,300,000$ 90,100$ 3,100,000$ 52,700$ 9,600,000$ 163,200$ 5,000,000$ 85,000$ 1,234,568$ 20,988$ 6,700,000$ 113,900$ 9,600,000$ 163,200$ 1,245,679$ 21,177$ 69,659,151$ 1,184,206Cristian Galves1054636410.66667$ 7,000,000$ 112,000$ 2,345,678$ 37,531$ 9,700,000$ 155,200$ 7,300,000$ 116,800$ 5,200,000$ 83,200$ 3,000,000$ 48,000$ 9,500,000$ 152,000$ 5,678,904$ 90,862$ 1,083,457$ 17,335$ 6,600,000$ 105,600$ 9,500,000$ 152,000$ 8,762,094$ 140,194$ 75,670,133$ 1,210,722santiago chaves1054644012.16667$ 6,578,904$ 98,684$ 7,890,765$ 118,361$ 9,600,000$ 144,000$ 7,200,000$ 108,000$ 5,100,000$ 76,500$ 4,567,234$ 68,509$ 9,400,000$ 141,000$ 3,567,890$ 53,518$ 1,234,568$ 18,519$ 6,500,000$ 97,500$ 5,899,000$ 88,485$ 7,905,643$ 118,585$ 75,444,004$ 1,131,660sebastian socha 1054651613.66667$ 9,999,999$ 180,000$ 3,456,098$ 62,210$ 9,500,000$ 171,000$ 7,100,000$ 127,800$ 4,900,000$ 88,200$ 5,678,904$ 102,220$ 9,300,000$ 167,400$ 2,654,987$ 47,790$ 3,214,579$ 57,862$ 6,400,000$ 115,200$ 5,436,781$ 97,862$ 9,876,234$ 177,772$ 77,517,582$ 1,395,316daniel rodriguez1054659215.16667$ 7,898,898$ 157,978$ 9,087,654$ 181,753$ 9,400,000$ 188,000$ 6,000,000$ 120,000$ 4,800,000$ 96,000$ 2,345,678$ 46,914$ 3,000,500$ 60,010$ 5,678,904$ 113,578$ 4,568,089$ 91,362$ 6,300,000$ 126,000$ 9,876,543$ 197,531$ 5,678,456$ 113,569$ 74,634,722$ 1,492,694samuel rodriguez1054666816.66667$ 5,678,987$ 90,864$ 9,087,654$ 145,402$ 9,300,000$ 148,800$ 6,900,000$ 110,400$ 4,700,000$ 75,200$ 9,874,329$ 157,989$ 5,899,000$ 94,384$ 2,345,678$ 37,531$ 1,234,679$ 19,755$ 5,436,781$ 86,988$ 5,678,456$ 90,855$ 3,000,000$ 48,000$ 69,135,564$ 1,106,169fabian espitia1054674418.16667$ 3,245,987$ 55,182$ 3,458,762$ 58,799$ 9,200,000$ 156,400$ 6,800,000$ 115,600$ 4,600,000$ 78,200$ 1,234,567$ 20,988$ 5,436,781$ 92,425$ 7,890,765$ 134,143$ 7,654,328$ 130,124$ 9,876,543$ 167,901$ 3,000,000$ 51,000$ 5,000,000$ 85,000$ 67,397,733$ 1,145,761camilo torres1054682019.66667$ 2,567,890$ 38,518$ 4,567,908$ 68,519$ 9,100,000$ 136,500$ 6,700,000$ 100,500$ 4,500,000$ 67,500$ 9,876,534$ 148,148$ 9,876,543$ 148,148$ 5,467,890$ 82,018$ 9,700,000$ 145,500$ 5,678,456$ 85,177$ 5,000,000$ 75,000$ 7,000,000$ 105,000$ 80,035,221$ 1,200,528jaime garzon1054689621.16667$ 3,456,789$ 48,395$ 3,456,098$ 48,385$ 8,900,000$ 124,600$ 6,600,000$ 92,400$ 4,400,000$ 61,600$ 1,245,679$ 17,440$ 5,678,456$ 79,498$ 5,678,904$ 79,505$ 9,600,000$ 134,400$ 3,000,000$ 42,000$ 5,678,904$ 79,505$ 6,578,904$ 92,105$ 64,273,734$ 899,832raul zaragoza 1054697222.66667$ 3,456,789$ 69,136$ 7,890,654$ 157,813$ 8,800,000$ 176,000$ 6,500,000$ 130,000$ 4,300,000$ 86,000$ 8,762,094$ 175,242$ 3,000,000$ 60,000$ 3,567,890$ 71,358$ 3,000,500$ 60,010$ 5,000,000$ 100,000$ 3,567,890$ 71,358$ 9,999,999$ 200,000$ 67,845,816$ 1,356,916david cardenas1054704824.16667$ 9,564,876$ 181,733$ 4,567,890$ 86,790$ 8,700,000$ 165,300$ 6,400,000$ 121,600$ 4,200,000$ 79,800$ 7,905,643$ 150,207$ 4,000,000$ 76,000$ 2,654,987$ 50,445$ 5,899,000$ 112,081$ 5,678,904$ 107,899$ 3,000,000$ 57,000$ 5,678,904$ 107,899$ 68,250,204$ 1,296,754laura rojas1054712425.66667$ 2,345,678$ 42,222$ 5,678,901$ 102,220$ 8,600,000$ 154,800$ 6,300,000$ 113,400$ 4,100,000$ 73,800$ 9,876,234$ 177,772$ 5,000,000$ 90,000$ 876,543$ 15,778$ 5,436,781$ 97,862$ 3,567,890$ 64,222$ 5,000,000$ 90,000$ 1,083,457$ 19,502$ 57,865,484$ 1,041,579

Total ventas mes$ 110,582,831$ 104,784,551$ 154,600,000$ 144,800,000$ 102,300,000$ 95,866,896$ 109,615,548$ 94,851,376$ 117,460,549$ 126,938,574$ 101,161,842$ 111,486,616total comisiones$ 1,812,923$ 1,737,165$ 2,561,200$ 2,369,500$ 1,673,400$ 1,607,128$ 1,802,780$ 1,514,738$ 1,892,997$ 2,087,788$ 1,692,510$ 1,843,341venta maxima$ 9,999,999$ 9,876,543$ 9,800,000$ 8,400,000$ 6,200,000$ 9,876,534$ 9,876,543$ 9,876,543$ 9,700,000$ 9,876,543$ 9,876,543$ 9,999,999venta minima$ 2,345,678$ 2,345,678$ 2,000,000$ 6,000,000$ 4,100,000$ 1,234,567$ 1,083,457$ 876,543$ 1,083,457$ 3,000,000$ 1,083,457$ 1,083,457comisiones Carolina Perez1.80%andrea ramirez1.70%susana santana1.60%luisa silva1.40%andres calderon1.30%nicolas tenjo1.20%juan pablo calderon1.50%maria paula arizabaleta1.90%viviana perez1.70%Cristian Galves1.60%santiago chaves1.50%sebastian socha 1.80%daniel rodriguez2%samuel rodriguez1.60%fabian espitia1.70%camilo torres1.50%jaime garzon1.40%raul zaragoza 2%david cardenas1.90%laura rojas1.80%

grafica 1mesestotal ventastotal comisionesenero$110,582,831$1,812,923febrero$104,784,551$1,737,165marzo$154,600,000$2,561,200abril$144,800,000$2,369,500mayo$102,300,000$1,673,400junio$95,866,896$1,607,128julio$109,615,548$1,802,780agosto$94,851,376$1,514,738septiembre$117,460,549$1,892,997octubre$126,938,574$2,087,788noviembre$101,161,842$1,692,510diciembre$111,486,616$1,843,341mesesventa maxima venta minimaenero$9,999,999$2,345,678febrero$9,876,543$2,345,678marzo$9,800,000$2,000,000abril$8,400,000$6,000,000mayo$6,200,000$4,100,000junio$9,876,534$1,234,567julio$9,876,543$1,083,457agosto$9,876,543$876,543septiembre$9,700,000$1,083,457octubre$9,876,543$3,000,000noviembre$9,876,543$1,083,457diciembre$9,999,999$2,166,914

grafica 2vendedorestotal ventas total comisionesCarolina Perez$56,315,925$1,013,687andrea ramirez$57,539,326$978,169susana santana$60,213,913$963,423luisa silva$64,051,740$896,724andres calderon$65,723,308$854,403nicolas tenjo$75,175,677$902,108juan pablo calderon$70,368,025$1,055,520maria paula arizabaleta$77,331,521$1,469,299viviana perez$69,659,151$1,184,206Cristian Galves$75,670,133$1,210,722santiago chaves$75,444,004$1,131,660sebastian socha $77,517,582$1,395,316daniel rodriguez$74,634,722$1,492,694samuel rodriguez$69,135,564$1,106,169fabian espitia$67,397,733$1,145,761camilo torres$80,035,221$1,200,528jaime garzon$64,273,734$899,832raul zaragoza $67,845,816$1,356,916david cardenas$68,250,204$1,296,754laura rojas$57,865,484$1,041,579