punto de equilibrio en excel
DESCRIPTION
Como obtener el punto de equilibrio en excel.TRANSCRIPT
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
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