Costos, Ingresos, Punto Equilibrio

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

utilidades 5000000

costos 4500
ingresos
Costos fijos unidades vendidas ingresos/costos
descsripcion importe - $ 5,000,000.00
renta $ 2,000,000.00 50 $ 5,240,000.00
servicios $ 500,000.00 100 $ 5,480,000.00
nomina $ 2,500,000.00 150 $ 5,720,000.00
Total $ 5,000,000.00 200 $ 5,960,000.00
250 $ 6,200,000.00
costos variables unitarios 300 $ 6,440,000.00
descripción importe 350 $ 6,680,000.00
materia prima $ 2,400.00 400 $ 6,920,000.00
gastos generales $ 2,400.00 450 $ 7,160,000.00
total $ 4,800.00 500 $ 7,400,000.00
550 $ 7,640,000.00
precio ven uni $ 10,000.00 600 $ 7,880,000.00
650 $ 8,120,000.00
Cantidad de Equilibrio $ 962 700 $ 8,360,000.00
750 $ 8,600,000.00
Ingreso de Equilibrio $ 9,615,385 800 $ 8,840,000.00
850 $ 9,080,000.00
900 $ 9,320,000.00
COSTOS FIJOS $ 5,000,000.00 950 $ 9,560,000.00
COSTOS VARIABLES $ 4,800.00 962 $ 9,617,600.00
PRECIO UNIDAD $ 10,000.00 1,000 $ 9,800,000.00
VENTA MENSUAL 1,500 1,100 $ 10,280,000.00
1,200 $ 10,760,000.00
1,300 $ 11,240,000.00
1,400 $ 11,720,000.00
1,500 $ 12,200,000.00
1,600 $ 12,680,000.00
1,700 $ 13,160,000.00
1,800 $ 13,640,000.00
1,900 $ 14,120,000.00
2,000 $ 14,600,000.00
2,100 $ 15,080,000.00
2,200 $ 15,560,000.00
2,300 $ 16,040,000.00
2,400 $ 16,520,000.00
2,500 $ 17,000,000.00
2,600 $ 17,480,000.00
2,700 $ 17,960,000.00
2,800 $ 18,440,000.00
2,900 $ 18,920,000.00
3,000 $ 19,400,000.00
3,100 $ 19,880,000.00
3,200 $ 20,360,000.00
3,300 $ 20,840,000.00
3,400 $ 21,320,000.00
3,500 $ 21,800,000.00
3,600 $ 22,280,000.00
3,700 $ 22,760,000.00
3,800 $ 23,240,000.00
3,900 $ 23,720,000.00
4,000 $ 24,200,000.00
4,100 $ 24,680,000.00
4,200 $ 25,160,000.00
4,300 $ 25,640,000.00
4,400 $ 26,120,000.00
4,500 $ 26,600,000.00
4,600 $ 27,080,000.00
4,700 $ 27,560,000.00
4,800 $ 28,040,000.00
4,900 $ 28,520,000.00
5,000 $ 29,000,000.00
5,100 $ 29,480,000.00
5,200 $ 29,960,000.00
5,300 $ 30,440,000.00
5,400 $ 30,920,000.00
5,500 $ 31,400,000.00
5,600 $ 31,880,000.00
5,700 $ 32,360,000.00
5,800 $ 32,840,000.00
5,900 $ 33,320,000.00
6,000 $ 33,800,000.00
6,100 $ 34,280,000.00
6,200 $ 34,760,000.00
6,300 $ 35,240,000.00
6,400 $ 35,720,000.00
6,500 $ 36,200,000.00
6,600 $ 36,680,000.00
6,700 $ 37,160,000.00
6,800 $ 37,640,000.00
6,900 $ 38,120,000.00
7,000 $ 38,600,000.00
7,100 $ 39,080,000.00
7,200 $ 39,560,000.00
7,300 $ 40,040,000.00
7,400 $ 40,520,000.00
7,500 $ 41,000,000.00
7,600 $ 41,480,000.00
7,700 $ 41,960,000.00
7,800 $ 42,440,000.00
7,900 $ 42,920,000.00
8,000 $ 43,400,000.00
8,100 $ 43,880,000.00
8,200 $ 44,360,000.00
8,300 $ 44,840,000.00
8,400 $ 45,320,000.00
8,500 $ 45,800,000.00
8,600 $ 46,280,000.00
8,700 $ 46,760,000.00
8,800 $ 47,240,000.00
8,900 $ 47,720,000.00
9,000 $ 48,200,000.00
9,100 $ 48,680,000.00
9,200 $ 49,160,000.00
9,300 $ 49,640,000.00
9,400 $ 50,120,000.00
9,500 $ 50,600,000.00
9,600 $ 51,080,000.00
9,700 $ 51,560,000.00
9,800 $ 52,040,000.00
9,900 $ 52,520,000.00
10,000 $ 53,000,000.00
10,100 $ 53,480,000.00
10,200 $ 53,960,000.00
punto de equilibrio utilidades
$ - -$ 5,000,000.00 COSTOS vs INGRESOS
$ 500,000.00 -$ 4,740,000.00 PUNTO DE EQUILIBRIO
$ 1,000,000.00 -$ 4,480,000.00
$ 1,500,000.00 -$ 4,220,000.00 $120,000,000.00

$ 2,000,000.00 -$ 3,960,000.00
$100,000,000.00
$ 2,500,000.00 -$ 3,700,000.00
$ 3,000,000.00 -$ 3,440,000.00 $80,000,000.00
$ 3,500,000.00 -$ 3,180,000.00

Ingresos/Costos
$ 4,000,000.00 -$ 2,920,000.00 $60,000,000.00
$ 4,500,000.00 -$ 2,660,000.00
$ 5,000,000.00 -$ 2,400,000.00 $40,000,000.00
$ 5,500,000.00 -$ 2,140,000.00
$ 6,000,000.00 -$ 1,880,000.00 $20,000,000.00
$ 6,500,000.00 -$ 1,620,000.00
$-
$ 7,000,000.00 -$ 1,360,000.00 - 2,000 4,000 6,000 8,000 10,000 1
$ 7,500,000.00 -$ 1,100,000.00 $(20,000,000.00)
$ 8,000,000.00 -$ 840,000.00
Unidades
$ 8,500,000.00 -$ 580,000.00
$ 9,000,000.00 -$ 320,000.00
$ 9,500,000.00 -$ 60,000.00
$ 9,620,000.00 $ 2,400.00 5,200.00
$ 10,000,000.00 $ 200,000.00 961.54
$ 11,000,000.00 $ 720,000.00
$ 12,000,000.00 $ 1,240,000.00
$ 13,000,000.00 $ 1,760,000.00
$ 14,000,000.00 $ 2,280,000.00
$ 15,000,000.00 $ 2,800,000.00
$ 16,000,000.00 $ 3,320,000.00
$ 17,000,000.00 $ 3,840,000.00
$ 18,000,000.00 $ 4,360,000.00
$ 19,000,000.00 $ 4,880,000.00
$ 20,000,000.00 $ 5,400,000.00
$ 21,000,000.00 $ 5,920,000.00
$ 22,000,000.00 $ 6,440,000.00
$ 23,000,000.00 $ 6,960,000.00
$ 24,000,000.00 $ 7,480,000.00
$ 25,000,000.00 $ 8,000,000.00
$ 26,000,000.00 $ 8,520,000.00
$ 27,000,000.00 $ 9,040,000.00
$ 28,000,000.00 $ 9,560,000.00
$ 29,000,000.00 $ 10,080,000.00
$ 30,000,000.00 $ 10,600,000.00
$ 31,000,000.00 $ 11,120,000.00
$ 32,000,000.00 $ 11,640,000.00
$ 33,000,000.00 $ 12,160,000.00
$ 34,000,000.00 $ 12,680,000.00
$ 35,000,000.00 $ 13,200,000.00
$ 36,000,000.00 $ 13,720,000.00
$ 37,000,000.00 $ 14,240,000.00
$ 38,000,000.00 $ 14,760,000.00
$ 39,000,000.00 $ 15,280,000.00
$ 40,000,000.00 $ 15,800,000.00
$ 41,000,000.00 $ 16,320,000.00
$ 42,000,000.00 $ 16,840,000.00
$ 43,000,000.00 $ 17,360,000.00
$ 44,000,000.00 $ 17,880,000.00
$ 45,000,000.00 $ 18,400,000.00
$ 46,000,000.00 $ 18,920,000.00
$ 47,000,000.00 $ 19,440,000.00
$ 48,000,000.00 $ 19,960,000.00
$ 49,000,000.00 $ 20,480,000.00
$ 50,000,000.00 $ 21,000,000.00
$ 51,000,000.00 $ 21,520,000.00
$ 52,000,000.00 $ 22,040,000.00
$ 53,000,000.00 $ 22,560,000.00
$ 54,000,000.00 $ 23,080,000.00
$ 55,000,000.00 $ 23,600,000.00
$ 56,000,000.00 $ 24,120,000.00
$ 57,000,000.00 $ 24,640,000.00
$ 58,000,000.00 $ 25,160,000.00
$ 59,000,000.00 $ 25,680,000.00
$ 60,000,000.00 $ 26,200,000.00
$ 61,000,000.00 $ 26,720,000.00
$ 62,000,000.00 $ 27,240,000.00
$ 63,000,000.00 $ 27,760,000.00
$ 64,000,000.00 $ 28,280,000.00
$ 65,000,000.00 $ 28,800,000.00
$ 66,000,000.00 $ 29,320,000.00
$ 67,000,000.00 $ 29,840,000.00
$ 68,000,000.00 $ 30,360,000.00
$ 69,000,000.00 $ 30,880,000.00
$ 70,000,000.00 $ 31,400,000.00
$ 71,000,000.00 $ 31,920,000.00
$ 72,000,000.00 $ 32,440,000.00
$ 73,000,000.00 $ 32,960,000.00
$ 74,000,000.00 $ 33,480,000.00
$ 75,000,000.00 $ 34,000,000.00
$ 76,000,000.00 $ 34,520,000.00
$ 77,000,000.00 $ 35,040,000.00
$ 78,000,000.00 $ 35,560,000.00
$ 79,000,000.00 $ 36,080,000.00
$ 80,000,000.00 $ 36,600,000.00
$ 81,000,000.00 $ 37,120,000.00
$ 82,000,000.00 $ 37,640,000.00
$ 83,000,000.00 $ 38,160,000.00
$ 84,000,000.00 $ 38,680,000.00
$ 85,000,000.00 $ 39,200,000.00
$ 86,000,000.00 $ 39,720,000.00
$ 87,000,000.00 $ 40,240,000.00
$ 88,000,000.00 $ 40,760,000.00
$ 89,000,000.00 $ 41,280,000.00
$ 90,000,000.00 $ 41,800,000.00
$ 91,000,000.00 $ 42,320,000.00
$ 92,000,000.00 $ 42,840,000.00
$ 93,000,000.00 $ 43,360,000.00
$ 94,000,000.00 $ 43,880,000.00
$ 95,000,000.00 $ 44,400,000.00
$ 96,000,000.00 $ 44,920,000.00
$ 97,000,000.00 $ 45,440,000.00
$ 98,000,000.00 $ 45,960,000.00
$ 99,000,000.00 $ 46,480,000.00
$ 100,000,000.00 $ 47,000,000.00
$ 101,000,000.00 $ 47,520,000.00
$ 102,000,000.00 $ 48,040,000.00
TOS vs INGRESOS
O DE EQUILIBRIO

ingresos/costos
punto de equilibrio
utilidades

6,000 8,000 10,000 12,000

des

También podría gustarte