trabajo cata

2
año 2010 INGRESOS TOTAL INGRESOS VENTAS INVERSIONES SALARIO ENERO $250,000,000 $150,000,000 $400,000,000 $25,000,000 FEBRERO $285,500,000 $171,300,000 $456,800,000 $25,000,000 MARZO $245,000,000 $147,000,000 $392,000,000 $25,500,000 ABRIL $268,000,000 $160,800,000 $428,800,000 $25,500,000 MAYO $275,000,000 $165,000,000 $440,000,000 $25,500,000 JUNIO $312,000,000 $187,200,000 $499,200,000 $25,500,000 JULIO $220,000,000 $132,000,000 $352,000,000 $26,000,000 AGOSTO $190,000,000 $114,000,000 $304,000,000 $26,000,000 SEPTIEMBRE $250,000,000 $150,000,000 $400,000,000 $26,000,000 OCTUBRE $290,000,000 $174,000,000 $464,000,000 $26,000,000 NOVIEMBRE $350,000,000 $210,000,000 $560,000,000 $28,000,000 DICIEMBRE $856,000,000 $513,600,000 $1,369,600,000 $56,000,000 TOTAL ### ### $6,066,400,000 ### ENERO FEBRE RO MARZO ABRIL MAY O JUNIO JUL I O AGOSTO SEPTI EM BRE OCTUBRE NOV I E MB RE DICIE MBRE $0 $1,000,000,000 $2,000,000,000 $3,000,000,000 $4,000,000,000 $5,000,000,000 $6,000,000,000 $7,000,000,000 Chart Title

Upload: leonardo-valderrama

Post on 21-Dec-2015

212 views

Category:

Documents


0 download

DESCRIPTION

EXCEL

TRANSCRIPT

Page 1: Trabajo Cata

año 2010INGRESOS

TOTAL INGRESOSGASTOS

VENTAS INVERSIONES SALARIOENERO $250,000,000 $150,000,000 $400,000,000 $25,000,000FEBRERO $285,500,000 $171,300,000 $456,800,000 $25,000,000MARZO $245,000,000 $147,000,000 $392,000,000 $25,500,000ABRIL $268,000,000 $160,800,000 $428,800,000 $25,500,000MAYO $275,000,000 $165,000,000 $440,000,000 $25,500,000JUNIO $312,000,000 $187,200,000 $499,200,000 $25,500,000JULIO $220,000,000 $132,000,000 $352,000,000 $26,000,000AGOSTO $190,000,000 $114,000,000 $304,000,000 $26,000,000SEPTIEMBRE $250,000,000 $150,000,000 $400,000,000 $26,000,000OCTUBRE $290,000,000 $174,000,000 $464,000,000 $26,000,000NOVIEMBRE $350,000,000 $210,000,000 $560,000,000 $28,000,000DICIEMBRE $856,000,000 $513,600,000 $1,369,600,000 $56,000,000TOTAL $3,791,500,000 $2,274,900,000 $6,066,400,000 $340,000,000

ENERO

FEBRERO

MARZOABRIL

MAYO

JUNIO

JULIO

AGOSTO

SEPTIEMBRE

OCTUBRE

NOVIEMBRE

DICIEMBRE

TOTAL$0

$1,000,000,000

$2,000,000,000

$3,000,000,000

$4,000,000,000

$5,000,000,000

$6,000,000,000

$7,000,000,000

Chart Title

Page 2: Trabajo Cata

GASTOSTOTAL GASTOS TOTAL BENEFICIOSADMINISTRATIVO OTROS

$13,750,000 $11,000,000 $49,750,000 $350,250,000$13,750,000 $11,000,000 $49,750,000 $407,050,000$14,025,000 $11,220,000 $50,745,000 $341,255,000$14,025,000 $11,220,000 $50,745,000 $378,055,000$14,025,000 $11,220,000 $50,745,000 $389,255,000$14,025,000 $11,220,000 $50,745,000 $448,455,000$14,300,000 $11,440,000 $51,740,000 $300,260,000$14,300,000 $11,440,000 $51,740,000 $252,260,000$14,300,000 $11,440,000 $51,740,000 $348,260,000$14,300,000 $11,440,000 $51,740,000 $412,260,000$15,400,000 $12,320,000 $55,720,000 $504,280,000$30,800,000 $24,640,000 $111,440,000 $1,258,160,000

$187,000,000 $149,600,000 $676,600,000 $5,389,800,000

ENERO

FEBRERO

MARZOABRIL

MAYO

JUNIO

JULIO

AGOSTO

SEPTIEMBRE

OCTUBRE

NOVIEMBRE

DICIEMBRE

TOTAL$0

$1,000,000,000

$2,000,000,000

$3,000,000,000

$4,000,000,000

$5,000,000,000

$6,000,000,000

$7,000,000,000

Chart Title