pieza margen de contribucion excel

3
PVU 134 CVU 82 CFT 121200 Q* 2330.769231 Q CVT CFT CT IT 0 0 121200 121200 0 466.1538462 38224.6154 121200 159424.615 62464.6154 932.3076923 76449.2308 121200 197649.231 124929.231 1398.461538 114673.846 121200 235873.846 187393.846 1864.615385 152898.462 121200 274098.462 249858.462 174000 2330.769231 191123.077 121200 312323.077 312323.077 2796.923077 229347.692 121200 350547.692 374787.692 3263.076923 267572.308 121200 388772.308 437252.308 3729.230769 305796.923 121200 426996.923 499716.923 4195.384615 344021.538 121200 465221.538 562181.538 ESTADO DE GANANCIA Y PERDIDAS VENTAS 312323 - COSTOS VARIABLES 191123 = MARGEN DE CONTRIBUCION - COSTOS FIJOS = UTILIDAD OPERATIVA 0 100000 200000 300000 400000 500000 600000

Upload: ricardo-miguel-espinoza-policarpo

Post on 05-Nov-2015

216 views

Category:

Documents


2 download

TRANSCRIPT

Hoja1PVU134CVU82CFT121200Q*2330.7692307692QCVTCFTCTITUTILIDADES001212001212000466.153846153838224.6153846154121200159424.61538461562464.6153846154932.307692307776449.2307692308121200197649.230769231124929.230769231PUNTO DE EQUILIBRIO1398.4615384615114673.846153846121200235873.846153846187393.8461538461864.6153846154152898.461538462121200274098.461538462249858.4615384621740002330.7692307692191123.076923077121200312323.076923077312323.0769230772796.9230769231229347.692307692121200350547.692307692374787.6923076923263.0769230769267572.307692308121200388772.307692308437252.3076923083729.2307692308305796.923076923121200426996.923076923499716.9230769234195.3846153846344021.538461538121200465221.538461538562181.538461539

PERDIDA 75000ESTADO DE GANANCIA Y PERDIDASVENTAS312323.076923077 - COSTOS VARIABLES191123.076923077 = MARGEN DE CONTRIBUCION121200 - COSTOS FIJOS 121200 = UTILIDAD OPERATIVA0

Hoja2

Hoja3