$ 52,452 $ 5,556,325.00 15/04/07 100% 52,693.
0
$ 456,325 $ 258,852.00 18/04/07 50% 8,541.0
$ 69,874 $ 854,436.00 21/04/07 200% 36,984.0
$ 23,569 $ 669,876.00 23/04/07 10% 524,877.0
$ 159,874 $ 1,988,650.00 25/04/07 4,568,552.0
$ 3,578,965 $ 40,025,874.00 28/04/07 2,269,885.0
42.20 $ 258,963 $ 36,550.00 30/04/07 3,369,855.0
33.76 $ 456,321 $ 48.00 02/05/07 2,247,744.0
64.00 $ 8,624,735 $ 8,756.00 04/05/07 1,133,565.0
38.90 $ 5,632,897 $ 500.00 08/05/07
12.10 $ 52,452 78.41
15.31 $ 456,325
18.64 $ 69,874
25.95 $ 23,569
69.57 $ 159,874
Prom
Codigo
Nombres Y Apellidos Nota Uno Nota1 Nota Dos
10 Diego Fernando Morales 3.60 0.72 5.00
18 Adalberto Bravo Florez 4.40 0.88 4.20
Cristian Marino Cortez 4.20 0.84 5.00
Edward Alejandro Patiño 3.20 0.64 4.70
Julio Cesar Rendón 3.60 0.72 2.80
36 Olga Rocio Suluaga Bravo 3.80 0.76 2.00
45 Jhoan Mauricio Obando Alarcon 2.10 0.42 4.70
39 Oscar Eduardo Tangarife 2.80 0.56 3.60
44 Henry Hernandez 3.30 0.66 3.00
25 Carlos Edinson Colorado 5.00 1.00 2.00
15 Mariela Hernandez 3.00 0.60 4.00
23 Lina Maria Castellanos 4.10 0.82 4.90
31 Armando portocarrero 3.70 0.74 3.10
35 Jose Arled Muñoz 2.90 0.58 2.80
38 Gabriel Cardenas 4.80 0.96 2.00
TOTALES ==================> 54.50 53.80
PROM PROM
Nota2 Nota Tres Nota3 Nota Final
1.50 2.00 1.00 3.22
1.26 2.00 1.00 3.14
1.50 3.30 1.65 3.99
1.41 2.60 1.30 3.35
0.84 4.60 2.30 3.86
0.60 4.00 2.00 3.36
1.41 3.10 1.55 3.38
1.08 4.20 2.10 3.74
0.90 3.80 1.90 3.46
0.60 3.40 1.70 3.30
1.20 2.70 1.35 3.15
1.47 1.80 0.90 3.19
0.93 2.50 1.25 2.92
0.84 5.00 2.50 3.92
0.60 3.00 1.50 3.06
48.00 51.04
ALMACEN EL MAS BARATO
INFORME TRIMESTRAL DE VENTAS AÑO
Año 2007
CODIGO ARTICULO 1 TRIM. 2 TRIM.
12365 ESTUFA A GAS 8,836,579.00 12,436,533.00
23485 SALA PEQUEÑA 2,365,347.00 6,534,292.00
34523 COMEDOR 4 PUESTOS 2,134,654.00 5,234,524.00
87898 COMEDOR 6 PUESTOS 3,267,543.00 7,565,437.00
52841 JUEGO DE ALCOBA CEDRO 2,245,433.00 7,356,478.00
66987 UEGO DE NOCHEROS 1,543,237.00 2,354,604.00
22583 BIBLIOTECA 3 DIVISIONES 1,543,564.00 1,450,003.00
11321 LAVADORA DE 20 LIBRAS 3,565,342.00 5,867,543.00
41174 ELEVISORES 21 PULGADAS 3,876,450.00 7,989,654.00
93226 NEVERAS DE 11 PIES 2,876,543.00 4,898,435.00
25894 VHS 1,676,539.00 6,398,439.00
34567 DVD 1,000,000.00 2,512,433.00
TOTAL $ 34,931,231.00 $ 70,598,375.00
PROMEDIO $ 2,910,935.92 $ 5,883,197.92
EN EL MAS BARATO
STRAL DE VENTAS AÑO 2007
Año 2007
3 TRIM. 4 TRIM. [Link] TOTAL
11,632,985.00 2,430,979.00 8,834,269.00 35,337,076.00
4,534,343.00 1,230,967.00 3,666,237.25 14,664,949.00
6,894,930.00 1,658,273.00 3,980,595.25 15,922,381.00
6,993,839.00 1,542,178.00 4,842,249.25 19,368,997.00
6,965,344.00 1,872,920.00 4,610,043.75 18,440,175.00
1,463,528.00 3,520,902.00 2,220,567.75 8,882,271.00
1,656,434.00 2,810,922.00 1,865,230.75 7,460,923.00
4,678,654.00 3,590,290.00 4,425,457.25 17,701,829.00
6,756,450.00 5,398,822.00 6,005,344.00 24,021,376.00
5,256,549.00 4,509,210.00 4,385,184.25 17,540,737.00
2,538,765.00 2,390,933.00 3,251,169.00 13,004,676.00
1,820,000.00 1,800,000.00 1,783,108.25 7,132,433.00
$ 61,191,821.00 $ 32,756,396.00 $ 49,869,455.75 $ 199,477,823.00
$ 5,099,318.42 $ 2,729,699.67 $ 4,155,787.98 $ 16,623,151.92
Taller N°3
FERRETERIA DEL PUEBLO
INFORME DE VENTAS
PRIMER SEMESTRE DE 2007
CODIGO PRODUCTO ENERO FEBRERO MARZO
54 MARTILLOS 212,334.00 259,837.00 369,823.00
65 PALAS 256,276.00 369,874.00 158,462.00
85 PICAS 213,873.00 198,745.00 200,500.00
47 PICADAS TALADROS 320,923.00 269,847.00 273,832.00
63 CARRETAS 153,890.00 127,838.00 123,456.00
66 PALUSTRES 268,737.00 163,487.00 166,333.00
78 NIVELES 98,354.00 65,930.00 70,000.00
36 PORRAS 85,437.00 25,839.00 35,300.00
41 ALICATES 99,354.00 78,982.00 80,499.00
55 SERRUCHOS 89,345.00 81,983.00 783,993.00
TOTALES $ 1,798,523.00 $ 1,642,362.00 $ 2,262,198.00
PROMEDIO $ 179,852.30 $ 164,236.20 $ 226,219.80
PORCENTAJES $ 503,586.44 $ 427,014.12 $ 542,927.52
UEBLO
TAS
DE 2007
ABRIL MAYO JUNIO
489,838.00 520,938.00 788,734.00
178,877.00 363,343.00 854,922.00
210,989.00 452,343.00 652,893.00
265,988.00 360,903.00 525,878.00
132,676.00 259,840.00 495,903.00
170,000.00 197,837.00 228,893.00
78,900.00 150,930.00 396,872.00
45,500.00 100,000.00 300,000.00
83,620.00 163,090.00 258,982.00
79,334.00 154,272.00 365,090.00
$ 1,735,722.00 $ 2,723,496.00 $ 4,868,167.00
$ 173,572.20 $ 272,349.60 $ 486,816.70
$ 520,716.60 $ 735,343.92 $ 1,509,131.77
HELADERIA CALIDA
PRESUPUESTO AÑO 2007
TRIM 1 TRIM 2 TRIM 3
VENTAS $ 3,000,898.00 $ 5,409,090.00 $ 7,600,909.00
GASTOS DE INSUMOS $ 300,000.00 $ 310,000.00 $ 295,094.00
GASTOS DE VENTAS $ 100,478.00 $ 163,000.00 $ 228,576.00
GASTOS DE MERCADEO $ 38,945.81 $ 50,433.00 $ 70,624.00
GASTOS GENERALES $ 71,892.00 $ 108,839.00 $ 150,788.00
GASTOS TOTALES $ 511,315.81 $ 632,272.00 $ 745,082.00
PROMEDIO DE GASTOS $ 127,828.95 $ 158,068.00 $ 186,270.50
UTILIDAD $ 2,489,582.19 $ 4,776,818.00 $ 6,855,827.00
LIDA
ÑO 2007
TRIM 4 TOTAL PROMEDIO
$ 4,009,898.00 $ 20,020,795.00 $ 8,008,318.00
$ 450,000.00 $ 1,355,094.00 $ 542,037.60
$ 142,700.00 $ 634,754.00 $ 253,901.60
$ 47,090.00 $ 207,092.81 $ 82,837.12
$ 95,909.00 $ 427,428.00 $ 170,971.20
$ 735,699.00 $ 2,624,368.81 $ 1,049,747.52
$ 183,924.75 $ 656,092.20 $ 262,436.88
$ 3,274,199.00 $ 17,396,426.19 $ 6,958,570.48
presupuestos d
porcentaje 1994 1995
ingresos 3%
ventas $ 15,000,000.00 $ 15,450,000.00
egresos
salarios 15% $ 2,250,000.00 $ 2,317,500.00
prestaciones 7% $ 1,050,000.00 $ 1,081,500.00
vacaciones 4% $ 600,000.00 $ 618,000.00
materia prima 20% $ 3,000,000.00 $ 3,090,000.00
publicidad 5% $ 750,000.00 $ 772,500.00
computador 3% $ 450,000.00 $ 463,500.00
papeleria 2% $ 300,000.00 $ 309,000.00
propaganda 3% $ 450,000.00 $ 463,500.00
varios 6% $ 900,000.00 $ 927,000.00
totales egresos $ 9,750,000.00 $ 10,042,500.00
utilidad bruta $ 5,250,000.00 $ 5,407,500.00
impuestos 5% $ 262,500.00 $ 270,375.00
utilidad neta $ 4,987,500.00 $ 5,137,125.00
gasto mayor $ 3,000,000.00 $ 3,090,000.00
gasto menor $ 300,000.00 $ 309,000.00
promedio de gastos $ 1,083,333.33 $ 1,115,833.33
presupuestos de ingresos y egresos
1996 1997 1998 1999 2000
6% 9% 12% 15% 18%
$ 15,900,000.00 $ 16,350,000.00 $ 16,800,000.00 $ 17,250,000.00 $ 17,700,000.00
$ 2,385,000.00 $ 2,452,500.00 $ 2,520,000.00 $ 2,587,500.00 $ 2,655,000.00
$ 1,113,000.00 $ 1,144,500.00 $ 1,176,000.00 $ 1,207,500.00 $ 1,239,000.00
$ 636,000.00 $ 654,000.00 $ 672,000.00 $ 690,000.00 $ 708,000.00
$ 3,180,000.00 $ 3,270,000.00 $ 3,360,000.00 $ 3,450,000.00 $ 3,540,000.00
$ 795,000.00 $ 817,500.00 $ 840,000.00 $ 862,500.00 $ 885,000.00
$ 477,000.00 $ 490,500.00 $ 504,000.00 $ 517,500.00 $ 531,000.00
$ 318,000.00 $ 327,000.00 $ 336,000.00 $ 345,000.00 $ 354,000.00
$ 477,000.00 $ 490,500.00 $ 504,000.00 $ 517,500.00 $ 531,000.00
$ 954,000.00 $ 981,000.00 $ 1,008,000.00 $ 1,035,000.00 $ 1,062,000.00
$ 10,335,000.00 $ 10,627,500.00 $ 10,920,000.00 $ 11,212,500.00 $ 11,505,000.00
$ 5,565,000.00 $ 5,722,500.00 $ 5,880,000.00 $ 6,037,500.00 $ 6,195,000.00
$ 278,250.00 $ 286,125.00 $ 294,000.00 $ 301,875.00 $ 309,750.00
$ 5,286,750.00 $ 5,436,375.00 $ 5,586,000.00 $ 5,735,625.00 $ 5,885,250.00
$ 3,180,000.00 $ 3,270,000.00 $ 3,360,000.00 $ 3,450,000.00 $ 3,540,000.00
$ 318,000.00 $ 327,000.00 $ 336,000.00 $ 345,000.00 $ 354,000.00
$ 1,148,333.33 $ 1,180,833.33 $ 1,213,333.33 $ 1,245,833.33 $ 1,278,333.33
2001 2002
21% 24%
$ 18,150,000.00 $ 18,600,000.00
$ 2,722,500.00 $ 2,790,000.00
$ 1,270,500.00 $ 1,302,000.00
$ 726,000.00 $ 744,000.00
$ 3,630,000.00 $ 3,720,000.00
$ 907,500.00 $ 930,000.00
$ 544,500.00 $ 558,000.00
$ 363,000.00 $ 372,000.00
$ 544,500.00 $ 558,000.00
$ 1,089,000.00 $ 1,116,000.00
$ 11,797,500.00 $ 12,090,000.00
$ 6,352,500.00 $ 6,510,000.00
$ 317,625.00 $ 325,500.00
$ 6,034,875.00 $ 6,184,500.00
$ 3,630,000.00 $ 3,720,000.00
$ 363,000.00 $ 372,000.00
$ 1,310,833.33 $ 1,343,333.33
DISTRIBUCIONES EL TREBOL & CIA LTDA
PRESUPUESTO DE GASTOS PARA EL PERIODO JULIO A DICIEMBRE DE 2003
[Link] [Link]
DETALLE JULIO
5% 7%
ALQUILER 254500 267225 285931
AGENDA CALI
TELEFONO 125900 132195 141449
ELECTRICIDAD 98500 103425 110665
ACUEDUCTO 54900 57645 61680
GASTOS 78560 82488 88262
SALARIOS 750352 787870 843020
PROMEDIOS 227119 238475 255168
[Link] [Link]
DETALLE JULIO
5% 7%
AGENDA PALMIRA
ALQUILER 185965 195263 208932
TELEFONO 95500 100275 107294
ELECTRICIDAD 74200 77910 83364
ACUEDUCTO 45800 48090 51456
GASTOS 75600 79380 84937
SALARIOS 568500 596925 638710
PROMEDIOS 174261 182974 195782
[Link] [Link]
DETALLE JULIO
5% 7%
ALQUILER 150000 157500 168525
AGENDA BUGA
TELEFONO 84600 88830 95048
ELECTRICIDAD 65250 68513 73308
ACUEDUCTO 38900 40845 43704
GASTOS 69800 73290 78420
SALARIOS 538500 565425 605005
PROMEDIOS 157842 165734 177335
[Link] [Link]
DETALLE JULIO
5% 7%
ALQUILER 165200.0 173460 185602
AGENDA TULUA
TELEFONO 95850.0 100643 107687
ELECTRICIDAD 75620.0 79401 84959
ACUEDUCTO 45980.0 48279 51659
GASTOS 72630.0 76262 81600
SALARIOS 650000.0 682500 730275
PROMEDIOS 184213 193424 206964
L TREBOL & CIA LTDA
PERIODO JULIO A DICIEMBRE DE 2003
[Link] [Link] [Link]
TOTAL
4% 3% 7%
297368 306289 327729 1739042.00016
147107 151520 162126 860296.219332
115091 118544 126842 673067.336014
64147 66072 70697 375141.083728
91793 94546 101165 536813.907789
876741 903044 966257 5127283.46917
265375 273336 292469
[Link] [Link] [Link] TOTAL
4% 3% 7%
217289 223808 239474 1270731
111586 114934 122979 652568
86698 89299 95550 507021
53515 55120 58978 312959
88334 90984 97353 516588
664258 684186 732079 3884658
203613 209722 224402
[Link] [Link] [Link] TOTAL
4% 3% 7%
175266 180524 193161 1024976
98850 101816 108943 578086
76241 78528 84025 445864
45452 46816 50093 265810
81557 84004 89884 476955
629205 648081 693447 3679663
184429 189961 203259
[Link] [Link] [Link] TOTAL
4% 3% 7%
193026 198817 212734 1128840
111995 115355 123430 654959
88357 91008 97379 516724
53725 55337 59210 314189
84864 87410 93528 496293
759486 782271 837030 4441561
215242 221699 237218
CREAC
DIAS DEVENGA
SUELDO
COD NOMBRES SALARIO [Link]
BASICO MES
TRAB BASICO DIURNAS
254 PATRICIA GOMEZ $ 350,000.00 15 $ 23,333.33 8
255 AMPARO MORALES $ 750,000.00 10 $ 75,000.00 12
256 BEATRIZ E. PLAZA $ 600,000.00 12 $ 50,000.00 10
257 CARMENZA DELGADO $ 480,000.00 15 $ 32,000.00 5
258 JOSE A. CASTRO $ 820,000.00 14 $ 58,571.43 14
259 JOSE RAUL GIRALDO $ 700,000.00 13 $ 53,846.15 6
260 LUZ M. RODRIGUEZ $ 956,300.00 8 $ 119,537.50 3
261 MARGARITA VAZQUEZ $ 550,000.00 15 $ 36,666.67 4
262 MIGUEL GUTIERREZ $ 630,000.00 15 $ 42,000.00 7
263 MONICA OROZCO $ 650,000.00 15 $ 43,333.33 8
264 WILSON CASTRO $ 660,000.00 14 $ 47,142.86 0
265 PEDRO NEL LOPEZ $ 1,250,000.00 13 $ 96,153.85 0
266 SANDRA P. GARCIA $ 500,000.00 11 $ 45,454.55 0
267 CAROLINA PEREZ $ 820,000.00 10 $ 82,000.00 9
268 LUIS ANGEL RIOS $ 610,000.00 15 $ 40,666.67 1
269 GERMAN FAJARDO $ 1,500,000.00 15 $ 100,000.00 3
270 DIEGO H. LOZANO $ 428,500.00 14 $ 30,607.14 2
271 HUGO A BERMUDEZ $ 865,400.00 15 $ 57,693.33 0
TOTALES 13120200 239 1,034,007 92
PROMEDIOS 728900 13 57445 5
CREACIONES TRAPOS
DEVENGADO DEDUCCIONES
[Link] [Link] [Link] SUBSIDIO TOTAL EPS F.P AHORRO
[Link]
DEVENGADO 12% 3.375% 5%
14583 3 7656 0 395,573 42000 11813 19779
46875 5 27344 32000 899,219 90000 25313 44961
31250 4 17500 0 698,750 72000 20250 34938
12500 6 21000 0 545,500 57600 16200 27275
59792 1 5979 32000 944,342 98400 27675 47217
21875 2 10208 32000 785,929 84000 23625 39296
14942 0 0 32000 1,090,780 114756 32275 54539
11458 4 16042 0 614,167 66000 18563 30708
22969 3 13781 0 708,750 75600 21263 35438
27083 2 9479 0 729,896 78000 21938 36495
0 1 4813 0 711,955 79200 22275 35598
0 0 0 32000 1,346,154 150000 42188 67308
0 5 18229 0 563,684 60000 16875 28184
38438 2 11958 32000 952,396 98400 27675 47620
3177 0 0 0 653,844 73200 20588 32692
23438 4 43750 32000 1,667,188 180000 50625 83359
4464 7 21871 0 485,442 51420 14462 24272
0 0 0 32000 923,093 103848 29207 46155
332843 49 229611 256000 14716661 1574424 442807 735833.05
18491 3 12756 14222 817592 87468 24600 40880
DUCCIONES NETO FIRMA
ABONO TOTAL A DEL
PRESTAMODEDUCIDO PAGAR EMPLEADO
15000 88591 306,982
0 160273 738,945
35000 162188 536,563
0 101075 444,425
35000 208292 736,050
45000 191921 594,008
0 201570 889,210
26000 141271 472,896
0 132300 576,450
65000 201432 528,464
0 137073 574,883
18000 277495 1,068,659
29500 134559 429,125
0 173695 778,701
30000 156480 497,364
58900 372884 1,294,303
0 90154 395,288
60000 239210 683,883
417400 3170464 11546197
23189 176137 641455
Código Artículo Descripción Precio. Unit.
ART1 Camisa 55000
ART2 Pantalones 60000
ART3 Blusas 45000
ART4 Zapatos 65000
Código Destinatario Destinatario Forma Envío Forma Pago Plazo Entrega
T32 Talleres Ramírez Aéreo Al contado 24 hs.
AK7 Mayoristas Centrales Camión Aplazado (30 d./vta) 3 Días
N12 El dedal, SL Tren Al contado 2 días
Lugar Entrega
Fábrica
Almacén
Almacén
Hermanos López
C/Romero, 90
41042 SEVILLA
FECHA:
PEDIDO N°
Cód.
AK7 Destinatario:
Destinatario Mayoristas Centrales
Condiciones
Forma de Envío Camión Plazo entrega 3 Días
Forma de pago Aplazado (30 dLugar entrega Almacén
Cantidad Código Descripción Precio unit. Importe total
Artículo
10 ART1 Camisa 55000 550000
2 ART2 Pantalones 60000 120000
6 #N/A #N/A #N/A
8 #N/A #N/A #N/A
