calculo pto equilibrio

16
Precio Unit 100.00 Equilib. Unid. 4,000.00 Costo Varia 60.00 Equilib. C$ 400,000.00 Costos Fijo 160,000.00 Margen C. 40.00 % Margen C. 40.00% Utilidad Es 200,000.00 Comprobación Ingresos Unidades V. 9,000.00 CFT Monto C$ 900,000.00 CVT CT Utilidad 1,000 2,000 3,000 4,000 Ventas 100,000.00 200,000.00 300,000.00 400,000.00 Costo Variable 60,000.00 120,000.00 180,000.00 240,000.00 Margen de contribución 40,000.00 80,000.00 120,000.00 160,000.00 Costos Fijos 160,000.00 160,000.00 160,000.00 160,000.00 Costos Totales 220,000.00 280,000.00 340,000.00 400,000.00 Utilidad (pérdida) ### -80,000.00 -40,000.00 0.00

Upload: johanny-coca

Post on 12-Sep-2015

225 views

Category:

Documents


11 download

DESCRIPTION

finanzas

TRANSCRIPT

Prez 1Precio Unit.100.00Equilib. Unid.4,000.00PE (x) = CFt / Pu - CvuCosto Variab.60.00Equilib. C$400,000.00PE C$ = CFt / %MCCostos Fijos160,000.00Margen C.40.00% Margen C.40.00%Utilidad Esp.200,000.00ComprobacinIngresos900,000.00Unidades V.9,000.00CFT160,000.00Monto C$900,000.00CVT540,000.00CT700,000.00Utilidad200,000.001,0002,0003,0004,0005,000Ventas100,000.00200,000.00300,000.00400,000.00500,000.00Costo Variable60,000.00120,000.00180,000.00240,000.00300,000.00Margen de contribucin40,000.0080,000.00120,000.00160,000.00200,000.00Costos Fijos160,000.00160,000.00160,000.00160,000.00160,000.00Costos Totales220,000.00280,000.00340,000.00400,000.00460,000.00Utilidad (prdida)-120,000.00-80,000.00-40,000.000.0040,000.00

Prez 2Precio Unit.120.00Equilib. Unid.2,666.67PE (x) = CFt / Pu - CvuCosto Variab.60.00Equilib. C$320,000.00PE C$ = CFt / %MCCostos Fijos160,000.00Margen C.60.00% Margen C.50.00%Utilidad Esp.200,000.00ComprobacinIngresos720,000.00Unidades V.6,000.00CFT160,000.00Monto C$720,000.00CVT360,000.00CT520,000.00Utilidad200,000.001,0002,000.002,666.675,0005,000Ventas120,000.00240,000.00320,000.00600,000.00600,000.00Costo Variable60,000.00120,000.00160,000.00300,000.00300,000.00Margen de contribucin60,000.00120,000.00160,000.00300,000.00300,000.00Costos Fijos160,000.00160,000.00160,000.00160,000.00160,000.00Costos Totales220,000.00280,000.00320,000.00460,000.00460,000.00Utilidad (prdida)-100,000.00-40,000.000.00140,000.00140,000.00

vol-utilPrecio Unit.15.00Equilib. Unid.10,000.00PE (x) = CFt / Pu - CvuCosto Variab.5.00Equilib. C$150,000.00PE C$ = CFt / %MCCostos Fijos100,000.00Margen C.10.00% Margen C.66.67%Utilidad Esp.200,000.00ComprobacinIngresos450,000.00Unidades V.30,000.00CFT100,000.00Monto C$450,000.00CVT150,000.00CT250,000.00Utilidad200,000.006,00010,00014,00020,0000Ventas90,000.00150,000.00210,000.00300,000.000.00Costo Variable30,000.0050,000.0070,000.00100,000.000.00Margen de contribucin60,000.00100,000.00140,000.00200,000.000.00Costos Fijos100,000.00100,000.00100,000.00100,000.00100,000.00Costos Totales130,000.00150,000.00170,000.00200,000.00100,000.00Utilidad (prdida)-40,000.000.0040,000.00100,000.00-100,000.00VER EL GRAFICO

VER EL GRAFICO

FINANCIngresos Tot58,837,000.00PE (x) = CFt / Pu - CvuCV Totales33,537,000.00Equilib. C$29,767,335.97PE C$ = CFt / %MCCF Totales12,800,000.00Margen Fcro.25,300,000.00% Margen C.43.00%Utilidad Esp.500,000.00ComprobacinIngresos1,162,786.56Unidades V.0.02CFT12,800,000.00Monto C$1,162,786.56CVT662,786.56CT13,462,786.56Utilidad-12,300,000.0060001000014000200000Ventas353,022,000,000.00588,370,000,000.00823,718,000,000.001,176,740,000,000.000.00Costo Variable201,222,000,000.00335,370,000,000.00469,518,000,000.00670,740,000,000.000.00Margen de contribucin151,800,000,000.00253,000,000,000.00354,200,000,000.00506,000,000,000.000.00Costos Fijos12,800,000.0012,800,000.0012,800,000.0012,800,000.0012,800,000.00Costos Totales201,234,800,000.00335,382,800,000.00469,530,800,000.00670,752,800,000.0012,800,000.00Utilidad (prdida)151,787,200,000.00252,987,200,000.00354,187,200,000.00505,987,200,000.00-12,800,000.00

FINANC (2)Ingresos Tot58,837,000.00PE (x) = CFt / Pu - CvuCV Totales45,087,000.00Equilib. C$62,987,682.91PE C$ = CFt / %MCCF Totales14,720,000.00Margen Fcro.13,750,000.00% Margen C.23.37%Utilidad Esp.500,000.00ComprobacinIngresos2,139,527.27Unidades V.0.04CFT14,720,000.00Monto C$2,139,527.27CVT1,639,527.27CT16,359,527.27Utilidad-14,220,000.0060001000014000200000Ventas353,022,000,000.00588,370,000,000.00823,718,000,000.001,176,740,000,000.000.00Costo Variable270,522,000,000.00450,870,000,000.00631,218,000,000.00901,740,000,000.000.00Margen de contribucin82,500,000,000.00137,500,000,000.00192,500,000,000.00275,000,000,000.000.00Costos Fijos14,720,000.0014,720,000.0014,720,000.0014,720,000.0014,720,000.00Costos Totales270,536,720,000.00450,884,720,000.00631,232,720,000.00901,754,720,000.0014,720,000.00Utilidad (prdida)82,485,280,000.00137,485,280,000.00192,485,280,000.00274,985,280,000.00-14,720,000.00

03Precio Unit.2.00Equilib. Unid.100,000.00PE (x) = CFt / Pu - CvuCosto Variab.1.50Equilib. C$200,000.00PE C$ = CFt / %MCCostos Fijos50,000.00Margen C.0.50% Margen C.25.00%Utilidad Esp.120,000.00ComprobacinIngresos680,000.00Unidades V.340,000.00CFT50,000.00Monto C$680,000.00CVT510,000.00CT560,000.00Utilidad120,000.0060001000014000200000Ventas12,000.0020,000.0028,000.0040,000.000.00Costo Variable9,000.0015,000.0021,000.0030,000.000.00Margen de contribucin3,000.005,000.007,000.0010,000.000.00Costos Fijos50,000.0050,000.0050,000.0050,000.0050,000.00Costos Totales59,000.0065,000.0071,000.0080,000.0050,000.00Utilidad (prdida)-47,000.00-45,000.00-43,000.00-40,000.00-50,000.00

04Precio Unit.2.00Equilib. Unid.62,500.00PE (x) = CFt / Pu - CvuCosto Variab.1.20Equilib. C$125,000.00PE C$ = CFt / %MCCostos Fijos50,000.00Margen C.0.80% Margen C.40.00%Utilidad Esp.0.00ComprobacinIngresos125,000.00Unidades V.62,500.00CFT50,000.00Monto C$125,000.00CVT75,000.00CT125,000.00Utilidad0.0060001000014000200000Ventas12,000.0020,000.0028,000.0040,000.000.00Costo Variable7,200.0012,000.0016,800.0024,000.000.00Margen de contribucin4,800.008,000.0011,200.0016,000.000.00Costos Fijos50,000.0050,000.0050,000.0050,000.0050,000.00Costos Totales57,200.0062,000.0066,800.0074,000.0050,000.00Utilidad (prdida)-45,200.00-42,000.00-38,800.00-34,000.00-50,000.00

Hoja2

Hoja3