8
Departamento Proyecto 2010 2011 Compras Proy1 30,000 33,000 Contabilidad Proy1 500 500 CRM Proy1 10,000 12,000 Producción Proy1 50,000 70,000 Proyectos Proy1 ### 95,000 RRHH Proy1 ### ### Tesorería Proy1 1,000 900 Ventas Proy1 40,000 43,000 Compras Proy2 33,000 31,350 Contabilidad Proy2 550 605 CRM Proy2 11,000 13,200 Producción Proy2 55,000 60,500 Proyectos Proy2 ### ### RRHH Proy2 ### ### Tesorería Proy2 1,100 1,100 Ventas Proy2 44,000 44,000 Compras Proy3 36,300 41,745 Contabilidad Proy3 605 726 CRM Proy3 12,100 14,520 Producción Proy3 60,500 57,475 Proyectos Proy3 ### ### RRHH Proy3 ### ### Tesorería Proy3 1,210 1,452 Ventas Proy3 48,400 55,660 Compras Proy4 39,930 37,934 Contabilidad Proy4 666 666 CRM Proy4 13,310 12,645 Producción Proy4 66,550 66,550 Proyectos Proy4 ### ### RRHH Proy4 ### ### Tesorería Proy4 1,331 1,531 Ventas Proy4 53,240 63,888

Td Campo Calcula Do

Embed Size (px)

DESCRIPTION

Excel

Citation preview

Hoja1DepartamentoProyecto20102011ComprasProy130,00033,000ContabilidadProy1500500CRMProy110,00012,000ProduccinProy150,00070,000ProyectosProy1100,00095,000RRHHProy1200,000210,000TesoreraProy11,000900VentasProy140,00043,000ComprasProy233,00031,350ContabilidadProy2550605CRMProy211,00013,200ProduccinProy255,00060,500ProyectosProy2110,000110,000RRHHProy2220,000209,000TesoreraProy21,1001,100VentasProy244,00044,000ComprasProy336,30041,745ContabilidadProy3605726CRMProy312,10014,520ProduccinProy360,50057,475ProyectosProy3121,000121,000RRHHProy3242,000278,300TesoreraProy31,2101,452VentasProy348,40055,660ComprasProy439,93037,934ContabilidadProy4666666CRMProy413,31012,645ProduccinProy466,55066,550ProyectosProy4133,100159,720RRHHProy4266,200319,440TesoreraProy41,3311,531VentasProy453,24063,888

Hoja2Proyecto(Todas)ValoresRtulos de filaCoste 2010Previsto 2011Var. %Compras139,230146,7515.40%Contabilidad2,3212377.9752.48%CRM46,4105187511.78%Produccin232,05027025516.46%Proyectos464,1004712001.53%RRHH928,2009490902.25%Tesorera4,6414705.451.39%Ventas185,64020542610.66%Total general2,002,5922,101,6804.95%

Hoja3FechaArtculoFacturacinUnidades3/21/10Art589,465874/6/10Art517,509203/24/10Art169,848556/24/10Art381,366836/3/10Art212,778465/23/10Art160,803703/5/10Art456,179525/3/10Art471,992705/1/10Art550,151803/2/10Art558,849452/23/10Art182,126224/28/10Art562,124844/21/10Art524,260724/7/10Art415,457515/26/10Art599,600266/10/10Art416,041191/14/10Art168,759532/2/10Art245,800802/22/10Art427,437625/19/10Art147,446504/18/10Art165,298382/7/10Art398,845383/6/10Art189,449534/5/10Art186,648754/25/10Art555,287542/16/10Art527,093116/22/10Art173,220923/20/10Art143,074881/26/10Art560,266251/8/10Art491,940502/24/10Art490,124405/16/10Art453,644255/27/10Art250,931451/3/10Art346,338521/1/10Art244,026304/7/10Art591,040484/1/10Art259,049551/7/10Art512,709542/14/10Art542,925464/15/10Art154,904326/28/10Art532,083275/14/10Art224,829805/26/10Art583,678182/23/10Art586,693722/18/10Art513,091591/19/10Art148,904152/19/10Art421,780896/17/10Art517,419222/28/10Art137,725322/27/10Art110,015314/14/10Art148,761381/21/10Art367,914491/18/10Art399,726375/22/10Art468,780251/19/10Art354,727564/4/10Art480,712483/29/10Art179,326734/9/10Art131,916155/6/10Art268,409565/27/10Art353,682296/15/10Art419,175915/16/10Art318,937246/4/10Art131,354673/25/10Art463,788176/29/10Art479,874433/12/10Art553,153131/27/10Art311,564861/29/10Art589,705112/25/10Art568,512951/18/10Art192,125386/12/10Art333,693296/18/10Art227,080145/9/10Art494,146635/3/10Art129,004873/11/10Art567,108884/16/10Art334,039724/30/10Art318,315776/7/10Art113,042836/13/10Art498,457124/14/10Art538,200744/8/10Art196,881905/3/10Art441,624343/14/10Art244,143346/1/10Art249,969293/17/10Art360,183815/6/10Art289,189433/30/10Art421,655166/7/10Art148,906354/3/10Art185,246301/27/10Art438,227384/4/10Art587,446635/20/10Art422,722605/28/10Art179,167364/9/10Art331,545394/8/10Art276,823573/22/10Art126,346373/17/10Art417,430104/20/10Art449,242346/26/10Art342,378104/9/10Art161,950931/18/10Art519,710736/27/10Art584,422954/13/10Art437,099795/21/10Art430,873803/16/10Art462,599676/4/10Art582,720214/5/10Art224,075511/29/10Art419,032154/11/10Art315,494811/30/10Art520,342833/7/10Art240,144735/1/10Art475,122513/7/10Art326,294716/29/10Art378,765861/13/10Art435,742574/24/10Art187,420186/26/10Art534,883615/21/10Art473,331453/19/10Art553,441883/27/10Art545,691542/6/10Art239,502625/10/10Art258,301401/4/10Art351,114726/7/10Art141,922221/10/10Art224,999993/29/10Art387,404593/18/10Art436,475783/18/10Art111,583881/2/10Art479,410752/23/10Art126,316952/28/10Art498,673903/26/10Art347,829595/24/10Art133,063463/27/10Art558,223346/30/10Art571,063936/19/10Art246,552965/2/10Art379,396195/24/10Art293,544421/29/10Art582,557322/28/10Art383,724123/12/10Art518,441945/4/10Art252,302216/21/10Art372,948912/25/10Art591,547911/1/10Art267,248382/15/10Art142,691212/27/10Art248,179411/17/10Art224,995652/3/10Art319,119974/1/10Art165,045442/8/10Art229,900255/10/10Art576,827794/8/10Art255,822533/19/10Art424,170502/28/10Art348,298482/6/10Art313,274166/27/10Art483,077176/6/10Art593,930473/6/10Art557,008596/19/10Art479,270786/7/10Art118,860985/29/10Art444,821994/28/10Art281,691513/13/10Art326,881462/21/10Art281,133474/27/10Art278,662906/27/10Art282,705731/20/10Art255,143693/7/10Art497,720216/10/10Art286,560464/1/10Art389,730361/12/10Art540,897631/5/10Art330,888844/30/10Art499,579376/15/10Art193,731614/1/10Art197,940972/26/10Art564,106542/12/10Art556,663653/12/10Art299,010293/9/10Art525,257905/6/10Art537,153641/2/10Art463,098273/20/10Art186,613694/4/10Art575,622224/3/10Art499,603422/16/10Art473,707955/30/10Art352,403362/15/10Art149,108145/12/10Art194,190886/2/10Art237,473994/24/10Art548,684904/12/10Art281,324221/19/10Art367,937866/13/10Art217,752335/18/10Art162,928542/25/10Art357,550974/24/10Art564,136612/26/10Art288,303565/27/10Art186,329602/18/10Art534,47040

Hoja4Artculo(Todas)FacturadoUdsP. medioTrim.1ene1,518,5551,676906.06feb1,450,12514061,031.38mar2,279,1062618870.55Trim.2abr1,583,4861695934.21may1,942,0932195884.78jun1,762,41816441,072.03Total general10,535,78311234937.85