punto de equilibrio

2
PRODUCTO PRODU A B C A B PV 75 29.5 50 PE unidades PE $ PE unidades CV 57 22 40 1565.55556 117416.67 1461.06667 CF 28180 10958 35500 MES A B 1 86.25 33.925 57.5 963.418803 72256.41 918.909853 2 99.1875 39.0138 66.125 667.97037 50097.778 644.067299 3 114.066 44.8658 76.0438 493.817425 37036.307 479.230729 4 131.175 51.5957 87.4503 379.909969 28493.248 370.256685 5 150.852 59.335 100.568 300.260659 22519.549 293.504463 6 173.48 68.2353 115.653 241.930864 18144.815 237.005097 CM M0 18 7.5 10 M1 29.25 11.925 17.5 ax bx M2 42.1875 17.0138 26.125 75 57 M3 57.0656 22.8658 36.0438 M4 74.1755 29.5957 47.4503 1000 M5 93.8518 37.335 60.5679 2000 M6 116.48 46.2353 75.653 %CM IT M0 0.24 0.25424 0.2 MIN 75000 M1 0.39 0.40424 0.35 MAX 150000 M2 0.5625 0.57674 0.5225 CT M3 0.76088 0.77511 0.72088 MIN 85180 M4 0.98901 1.00324 0.94901 MAX 142180 M5 1.25136 1.26559 1.21136 M6 1.55306 1.5673 1.51306

Upload: lucio-ayala-oliva

Post on 14-Nov-2015

7 views

Category:

Documents


2 download

DESCRIPTION

hoja de calculo para calcular el punto de equilibrio

TRANSCRIPT

Hoja1

PRODUCTOPRODUCTOABCABCPV7529.550PE unidadesPE $PE unidadesPE $PE unidadesPE $CV5722401565.5555555556117416.6666666671461.066666666743101.46666666673550177500CF281801095835500

MESABC186.2533.92557.5963.418803418872256.4102564103918.909853249527107.84067085952028.5714285714101428.571428571299.187539.0137566.125667.970370370450097.7777777778644.067298508618999.98530600251358.851674641267942.58373205743114.06562544.865812576.04375493.817425113637036.3068835223479.23072928214137.3065138184984.914166811249245.70834055834131.1754687551.59568437587.4503125379.909968550128493.2476412561370.256685439510922.5722204642748.151026402637407.55132013095150.851789062559.3350370312100.567859375300.260658656522519.5493992398293.50446313558658.3816624964586.119442990529305.97214952346173.479557421968.2352925859115.6530382812241.930864296918144.814822271237.00509691026991.6503588499469.247512149123462.3756074569CMM0187.510M129.2511.92517.5axbxcunidadesV117416.666666667M242.187517.0137526.1257557281801565.5555555556CV89236.6666666667M357.06562522.865812536.04375CM28180M474.1754687529.59568437547.45031251000CF28180M593.851789062537.335037031260.5678593752000U0M6116.479557421946.235292585975.6530382812%CMITM00.240.25423728810.2MIN75000M10.390.40423728810.35MAX150000M20.56250.57673728810.5225CTM30.7608750.77511228810.720875MIN85180M40.989006251.00324353810.94900625MAX142180M51.25135718751.26559447561.2113571875M61.55306076561.56729805381.5130607656

Hoja2

Hoja3