Practicando.Puntodequilibrio.xlsx - Punto de equilibrio...

Info icon This preview shows pages 1–6. Sign up to view the full content.

Parámetros 250.0000 Las unidades empiezan en 0 Punto equilibrio $ 500000.0000 Incremento por unidad 50 precio por unidad $2,000 Costo variable por unidad $1,200 Costos fijos $200,000 Unidades 0 50 100 150 200 Ventas $0 $100,000 $200,000 $300,000 $400,000 Costos Variables $0 $60,000 $120,000 $180,000 $240,000 Margen de Contribución $0 $40,000 $80,000 $120,000 $160,000 Costos Fijos $200,000 $200,000 $200,000 $200,000 $200,000 Costos Totales $200,000 $260,000 $320,000 $380,000 $440,000 Utilidad (MC-CF) ($200,000) ($160,000) ($120,000) ($80,000) ($40,000) Utilidad (Ventas-Costos Totales) ($200,000) ($160,000) ($120,000) ($80,000) ($40,000) Punto de equilibrio Unidades 0 50 100 150 200 250 300 350 $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 7; $501,200 Punto de Equilibrio Ventas Costos Fijos Costos Totales Unidades
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

250 251 300 350 400 $500,000 $502,000 $600,000 $700,000 $800,000 $300,000 $301,200 $360,000 $420,000 $480,000 $200,000 $200,800 $240,000 $280,000 $320,000 $200,000 $200,000 $200,000 $200,000 $200,000 $500,000 $501,200 $560,000 $620,000 $680,000 $0 $800 $40,000 $80,000 $120,000 $0 $800 $40,000 $80,000 $120,000 400 450
Image of page 2
Parámetros 250 Las unidades empiezan en 0 Punto equilibrio $ $750,000 Incremento por unidad 50 precio por unidad $3,000 Costo variable por unidad $1,800 Costos fijos
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Image of page 4
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern