3
Costos fijos: ### Precio: S/. 1.63 ostos variables: S/. 0.61 P.E.: 3360201.47946272 Utilidades: S/. - Unidades Ventas Costos Utilidades 1200000 ### ### ### 2100000 ### ### ### 2700000 ### ### ### 3000000 ### ### ### 3360201.479 ### ### S/. -0.00 3800000 ### ### ### 4500000 ### ### ### 5000000 ### ### ### 5500000 ### ### ### 6300000 ### ### ### 6800000 ### ### ### 7400000 ### ### ### 8000000 ### ### ### 8500000 ### ### ### S/. -4, S/. -2, S/. 2, S/. 4, S/. 6, S/. 8, S/. 10, S/. 12, S/. 14, S/. 16,

Punto de Equilibrio en Excel

Embed Size (px)

DESCRIPTION

pto equilibrio

Citation preview

Page 1: 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

Page 2: Punto de Equilibrio en Excel

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

Page 3: Punto de Equilibrio en Excel

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