punto de equilibrio en excel

3
Costos fijos: $1,860,000 Precio: $1,150 Costos variables: $832 P.E.: 5849.0566 Utilidades: $0 stos fijos: Unidades Ventas Costos Utilidades $1,860,000 1000 $1,150,000 $2,692,000 ### $1,860,000 2000 $2,300,000 $3,524,000 ### $1,860,000 3000 $3,450,000 $4,356,000 -$906,000 $1,860,000 4000 $4,600,000 $5,188,000 -$588,000 $1,860,000 5000 $5,750,000 $6,020,000 -$270,000 $1,860,000 6000 $6,900,000 $6,852,000 $48,000 $1,860,000 7000 $8,050,000 $7,684,000 $366,000 $1,860,000 8000 $9,200,000 $8,516,000 $684,000 $1,860,000 9000 ### $9,348,000 $1,002,000 $1,860,000 10000 ### ### $1,320,000 $1,860,000 11000 ### ### $1,638,000 $1,860,000 12000 ### ### $1,956,000 $1,860,000 13000 ### ### $2,274,000 $1,860,000 14000 ### ### $2,592,000 $1,860,000 15000 ### ### $2,910,000 $1,860,000 16000 ### ### $3,228,000 $1,860,000 17000 ### ### $3,546,000 $1,860,000 18000 ### ### $3,864,000 $1,860,000 19000 ### ### $4,182,000 $1,860,000 20000 ### ### $4,500,000 Ax

Upload: any

Post on 15-Dec-2015

1 views

Category:

Documents


0 download

DESCRIPTION

Como obtener el punto de equilibrio en excel.

TRANSCRIPT

Page 1: Punto de Equilibrio en Excel

Costos fijos: $1,860,000Precio: $1,150

Costos variables: $832P.E.: 5849.0566

Utilidades: $0

Costos fijos: Unidades Ventas Costos Utilidades$1,860,000 1000 $1,150,000 $2,692,000 -$1,542,000$1,860,000 2000 $2,300,000 $3,524,000 -$1,224,000$1,860,000 3000 $3,450,000 $4,356,000 -$906,000$1,860,000 4000 $4,600,000 $5,188,000 -$588,000$1,860,000 5000 $5,750,000 $6,020,000 -$270,000$1,860,000 6000 $6,900,000 $6,852,000 $48,000$1,860,000 7000 $8,050,000 $7,684,000 $366,000$1,860,000 8000 $9,200,000 $8,516,000 $684,000$1,860,000 9000 $10,350,000 $9,348,000 $1,002,000$1,860,000 10000 $11,500,000 $10,180,000 $1,320,000$1,860,000 11000 $12,650,000 $11,012,000 $1,638,000$1,860,000 12000 $13,800,000 $11,844,000 $1,956,000$1,860,000 13000 $14,950,000 $12,676,000 $2,274,000$1,860,000 14000 $16,100,000 $13,508,000 $2,592,000$1,860,000 15000 $17,250,000 $14,340,000 $2,910,000$1,860,000 16000 $18,400,000 $15,172,000 $3,228,000$1,860,000 17000 $19,550,000 $16,004,000 $3,546,000$1,860,000 18000 $20,700,000 $16,836,000 $3,864,000$1,860,000 19000 $21,850,000 $17,668,000 $4,182,000$1,860,000 20000 $23,000,000 $18,500,000 $4,500,000

10002000

30004000

50006000

70008000

900010000

1100012000

1300014000

1500016000

1700018000

1900020000

-$5,000,000

$0

$5,000,000

$10,000,000

$15,000,000

$20,000,000

$25,000,000

Punto de equilibrio

VentasCostosUtilidadesCostos fijos:

Axis Title

Axis Title

Page 2: Punto de Equilibrio en Excel

10002000

30004000

50006000

70008000

900010000

1100012000

1300014000

1500016000

1700018000

1900020000

-$5,000,000

$0

$5,000,000

$10,000,000

$15,000,000

$20,000,000

$25,000,000

Punto de equilibrio

VentasCostosUtilidadesCostos fijos:

Axis Title

Axis Title