calculo pto equilibrio
DESCRIPTION
finanzasTRANSCRIPT
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