La Olla de Oro

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 13

VENTAS 40% 50% 10%

IMPORTE IVA

MAYO 44,000 430 18,920,000 3,027,200


JUNIO 48,000 430 20,640,000 3,302,400
JULIO 50,000 430 21,500,000 3,440,000
AGOSTO 40,000 430 17,200,000 2,752,000
SEPTIEMBRE 35,000 430 15,050,000 2,408,000
OCTUBRE 30,000 430 12,900,000 2,064,000
NOVIEMBRE 32,000 430 13,760,000 2,201,600
DICIEMBRE 50,000 430 21,500,000 3,440,000
ENERO 30,000 430 12,900,000 2,064,000

COMPRAS MAT A

MAYO 44,000 4 176,000 $ 15 2,640,000


JUNIO 48,000 4 192,000 $ 15 2,880,000
JULIO 50,000 4 200,000 $ 15 3,000,000
AGOSTO 40,000 4 160,000 $ 15 2,400,000
SEPTIEMBRE 35,000 4 140,000 $ 15 2,100,000
OCTUBRE 30,000 4 120,000 $ 15 1,800,000
NOVIEMBRE 32,000 4 128,000 $ 15 1,920,000
DICIEMBRE 50,000 4 200,000 $ 15 3,000,000
ENERO 30,000 4 120,000 $ 15 1,800,000

MANO DE OBRA
MAYO JUNIO JULIO AGOSTO
PRODUCCION 44,000 48,000 50,000 40,000
COSTO 140 140 140 140
TOTAL 6,160,000 6,720,000 7,000,000 5,600,000
MOI 616,000 672,000 700,000 560,000
SUELDOS 2,000,000 2,000,000 2,000,000 2,000,000
TOTAL SUELDOS 8,776,000 9,392,000 9,700,000 8,160,000

RET ISPT 4% 351,040 375,680 388,000 326,400


RET IMSS 5% 438,800 469,600 485,000 408,000
7,986,160 8,546,720 8,827,000 7,425,600
IMSS PATRONAL 11% 965,360 1,033,120 1,067,000 897,600
INFONAVIT 5% 438,800 469,600 485,000 408,000
SAR 2% 175,520 187,840 194,000 163,200
NOMINAS 3.0% 263,280 281,760 291,000 244,800

CARGOS INDIRECTOS MAYO


SUBTOTAL IVA TOTAL
MOI 8,776,000 0 8,776,000
RENTA 60,000 9,600 69,600
MANTE 40,000 6,400 46,400
DEPRE 35,000 5,600 40,600
SERVICIOS 24,000 3,840 27,840
DIVERSOS 21,000 3,360 24,360
IMSS 11% 965,360 0 0
INFONAVIT 5% 438,800 0 0
SAR 2% 175,520 0 0
NOMINAS 3% 263,280 0 0
8,935,000 25,440 8,984,800
ISPT 351,040
IMSS 438,800
8,194,960

GASTOS DE OPERACIÓN
SUELDOS 2,000,000 0 2,000,000
RENTA 80,000 12,800 92,800
PUBLICIDAD 480,000 76,800 556,800
COMISIONES 1,200,000 192,000 1,392,000
SERVICIOS 440,000 70,400 510,400
IMSS PATRONAL 11% 220,000 0 0
INFONAVIT 5% 100,000 0 0
SAR 2% 40,000 0 0
NOMINAS 3% 60,000 0 0
4,620,000 352,000 4,552,000
RET ISPT 4% 80,000
RET IMSS 5% 100,000
4,372,000

IVA MENSUAL MAYO JUNIO JULIO AGOSTO


TRASLADADO 1,210,880 2,834,560 3,329,920 3,151,040

COMPRA 304,128 749,952 839,808 793,152


CARGOS IND 25,440 0 25,440 25,440
GASTOS 352,000 352,000 352,000 352,000
TOTAL ACREDITABLE 681,568 1,101,952 1,217,248 1,170,592

POR PAGAR 529,312 1,732,608 2,112,672 1,980,448

IMPUESTOS POR PAGAR


MAYO JUNIO JULIO AGOSTO
IVA 529,312 1,732,608 2,112,672
IMSS 977,600 1,008,400 1,023,800
IMSS PATRONAL 2,150,720 2,218,480 2,252,360
INFONAVIT 1,986,000
SAR 2,429,520
NOMINAS 586,560 605,040 614,280
ISPT 782,080 806,720 819,040
5,026,272 10,786,768 6,822,152

FLUJO DE EFECTIVO
JULIO AGOSTO SEPTIEMBRE OCTUBRE
SALDO INICIAL 1,000,000 -4,091,616 -4,478,472 -11,490,192
COBRANZA 24,141,920 22,845,040 19,453,200 16,709,800
DEUDORES

25,141,920 18,753,424 14,974,728 5,219,608

PAGO A PROVEEDORES 6,088,608 5,750,352 4,823,280 4,165,560


NOMINA 7,986,160 8,546,720 8,827,000 7,425,600
CARGOS IND 0 0 0 0
GASTOS 4,372,000 2,112,672 2,112,672 2,112,672
IMPUESTOS 10,786,768 6,822,152 10,701,968 5,818,660

TOTAL SALIDAS 29,233,536 23,231,896 26,464,920 19,522,492

REMANENTE -4,091,616 -4,478,472 -11,490,192 -14,302,884


TOTAL MAYO JUNIO JULIO AGOSTO SEPTIEMBRE OCTUBRE
0
21,947,200 8,778,880 10,973,600 2,194,720
23,942,400 9,576,960 11,971,200 2,394,240
24,940,000 9,976,000 12,470,000 2,494,000
19,952,000 7,980,800 9,976,000 1,995,200
17,458,000 6,983,200 8,729,000
14,964,000 5,985,600
15,961,600
24,940,000
14,964,000
8,778,880 20,550,560 24,141,920 22,845,040 19,453,200 16,709,800
1,210,880 2,834,560 3,329,920 3,151,040 2,683,200 2,304,800

MAT B 40% 55% 5% IMPORTE IVA

4 176,000 12 2,112,000 4,752,000 760,320


4 192,000 12 2,304,000 5,184,000 829,440
4 200,000 12 2,400,000 5,400,000 864,000
4 160,000 12 1,920,000 4,320,000 691,200
4 140,000 12 1,680,000 3,780,000 604,800
4 120,000 12 1,440,000 3,240,000 518,400
4 128,000 12 1,536,000 3,456,000 552,960
4 200,000 12 2,400,000 5,400,000 864,000
4 120,000 12 1,440,000 3,240,000 518,400

SEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE ENERO


35,000 30,000 32,000 50,000 30,000
140 140 140 140 140
4,900,000 4,200,000 4,480,000 7,000,000 4,200,000
490,000 420,000 448,000 700,000 420,000
2,000,000 2,000,000 2,000,000 2,000,000 2,000,000
7,390,000 6,620,000 6,928,000 9,700,000 6,620,000

295,600 264,800 277,120 388,000 264,800


369,500 331,000 346,400 485,000 331,000
6,724,900 6,024,200 6,304,480 8,827,000 6,024,200
812,900 728,200 762,080 1,067,000 728,200
369,500 331,000 346,400 485,000 331,000
147,800 132,400 138,560 194,000 132,400
221,700 198,600 207,840 291,000 198,600

SEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE ENERO


2,683,200 2,304,800 2,153,440 2,683,200 2,545,600

665,280 574,560 536,544 675,648 710,208


25,440 25,440 25,440 25,440 25,440
352,000 352,000 352,000 352,000 352,000
1,042,720 952,000 913,984 1,053,088 1,087,648

1,640,480 1,352,800 1,239,456 1,630,112 1,457,952

SEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE ENERO


1,980,448 1,640,480 1,352,800 1,239,456 1,630,112
946,800 908,300 869,800 885,200 1,023,800
2,082,960 1,998,260 1,913,560 1,947,440 2,252,360
1,970,600 1,778,100 1,909,000
2,395,640 1,972,140 2,260,120
568,080 544,980 521,880 531,120 614,280
757,440 726,640 695,840 708,160 819,040
10,701,968 5,818,660 9,104,120 5,311,376 10,508,712

NOVIEMBRE DICIEMBRE ENERO


-14,302,884 -20,522,080 -19,415,576
15,612,440 19,453,200 18,455,600

1,309,556 -1,068,880 -959,976

3,889,944 4,898,448 5,149,008


6,724,900 6,024,200 6,304,480
0 0 0
2,112,672 2,112,672 2,112,672
9,104,120 5,311,376 10,508,712

21,831,636 18,346,696 24,074,872

-20,522,080 -19,415,576 -25,034,848


NOVIEMBRE DICIEMBRE ENERO

1,745,800
7,482,000 1,496,400
6,384,640 7,980,800
9,976,000 12,470,000
5,985,600
15,612,440 19,453,200 18,455,600
2,153,440 2,683,200 2,545,600

TOTAL MAYO JUNIO JULIO AGOSTO SEPTIEMBRE OCTUBRE NOVIEMBRE

5,512,320 2,204,928 3,031,776 275,616


6,013,440 2,405,376 3,307,392 300,672
6,264,000 2,505,600 3,445,200 313,200
5,011,200 2,004,480 2,756,160 250,560
4,384,800 1,753,920 2,411,640 219,240
3,758,400 1,503,360 2,067,120
4,008,960 1,603,584
6,264,000
3,758,400
44,975,520 2,204,928 5,437,152 6,088,608 5,750,352 4,823,280 4,165,560 3,889,944
304,128 749,952 839,808 793,152 665,280 574,560 536,544
1,900,800 4,687,200 5,248,800 4,957,200 4,158,000 3,591,000 3,353,400
DICIEMBRE ENERO

187,920
2,204,928 200,448
2,505,600 3,445,200
1,503,360
4,898,448 5,149,008 TOTAL
675,648 710,208 IVA
4,222,800 4,438,800 SUBTOTAL

También podría gustarte