punto de equilibro promediado

Upload: mariu-ochoa

Post on 04-Mar-2016

215 views

Category:

Documents


0 download

DESCRIPTION

Punto de equilibrio promediado

TRANSCRIPT

  • A B C D ECANTIDAD 2500 3200 1750 1420 1810PVU 35 48 40 25 35CVU 20 18 30 12 20CM 15 30 10 13 15CM% 0.14563107 0.29126214 0.09708738 0.12621359 0.14563107CMP 2.18446602 8.73786408 0.97087379 1.6407767 2.18446602

    PUNTO DE EQUILIBRIO 6121.8425

    VentasA 891.530461 35 31203.5661B 1783.06092 48 85586.9242C 594.35364 40 23774.1456D 772.659733 25 19316.4933E 891.530461 35 31203.5661F 1188.70728 70 83209.5097

    total 274294.205

    costosA 891.530461 20 17830.6092B 1783.06092 18 32095.0966C 594.35364 30 17830.6092D 772.659733 12 9271.91679E 891.530461 20 17830.6092F 1188.70728 50 59435.364

    total 154294.205

    costos FijosA 0.14563107 17475.7282B 0.29126214 34951.4563C 0.09708738 11650.4854D 0.12621359 15145.6311E 0.14563107 17475.7282F 0.19417476 23300.9709

    total 120000utilidad 0

    CF 120000

    120000

  • F1900

    705020 103

    0.19417476 13.88349515 19.6019417

    120000

    Hoja1