Punto de Equilibrio en Excel

Costos fijos: S/. 3,452,271.00 Precio: S/. 1.63

Costos variables: S/. 0.61 P.E.: 3360201.47946272

Utilidades: S/. -

Unidades Ventas Costos Utilidades1200000 S/. 1,960,800.00 S/. 4,180,191.00 S/. -2,219,391.00 2100000 S/. 3,431,400.00 S/. 4,726,131.00 S/. -1,294,731.00 2700000 S/. 4,411,800.00 S/. 5,090,091.00 S/. -678,291.00 3000000 S/. 4,902,000.00 S/. 5,272,071.00 S/. -370,071.00

3360201.479 S/. 5,490,569.22 S/. 5,490,569.22 S/. -0.00 3800000 S/. 6,209,200.00 S/. 5,757,351.00 S/. 451,849.00 4500000 S/. 7,353,000.00 S/. 6,181,971.00 S/. 1,171,029.00 5000000 S/. 8,170,000.00 S/. 6,485,271.00 S/. 1,684,729.00 5500000 S/. 8,987,000.00 S/. 6,788,571.00 S/. 2,198,429.00 6300000 S/. 10,294,200.00 S/. 7,273,851.00 S/. 3,020,349.00 6800000 S/. 11,111,200.00 S/. 7,577,151.00 S/. 3,534,049.00 7400000 S/. 12,091,600.00 S/. 7,941,111.00 S/. 4,150,489.00 8000000 S/. 13,072,000.00 S/. 8,305,071.00 S/. 4,766,929.00 8500000 S/. 13,889,000.00 S/. 8,608,371.00 S/. 5,280,629.00

1200000 2100000 2700000 3000000 3360201.479 3800000 4500000 5000000 5500000 6300000 6800000 7400000 8000000 8500000

S/. -4,000,000.00

S/. -2,000,000.00

S/. -

S/. 2,000,000.00

S/. 4,000,000.00

S/. 6,000,000.00

S/. 8,000,000.00

S/. 10,000,000.00

S/. 12,000,000.00

S/. 14,000,000.00

S/. 16,000,000.00

Punto de equilibrio

VentasCostosUtilidades

1200000 2100000 2700000 3000000 3360201.479 3800000 4500000 5000000 5500000 6300000 6800000 7400000 8000000 8500000

S/. -4,000,000.00

S/. -2,000,000.00

S/. -

S/. 2,000,000.00

S/. 4,000,000.00

S/. 6,000,000.00

S/. 8,000,000.00

S/. 10,000,000.00

S/. 12,000,000.00

S/. 14,000,000.00

S/. 16,000,000.00

Punto de equilibrio

VentasCostosUtilidades

1200000 2100000 2700000 3000000 3360201.479 3800000 4500000 5000000 5500000 6300000 6800000 7400000 8000000 8500000

S/. -4,000,000.00

S/. -2,000,000.00

S/. -

S/. 2,000,000.00

S/. 4,000,000.00

S/. 6,000,000.00

S/. 8,000,000.00

S/. 10,000,000.00

S/. 12,000,000.00

S/. 14,000,000.00

S/. 16,000,000.00

Punto de equilibrio

VentasCostosUtilidades