PRESUPUESTO COCA COLA_X (1).xlsx - COCA COLA COMPANY S.A....

This preview shows page 1 - 10 out of 37 pages.

COCA COLA COPRESUPUEAL 31 DE DICORIGINALLCANTIDADVENTASCANTIDADENERO457,646,6086,864,699,120.0018,191,132FEBRERO435,758,1246,536,371,860.0017,321,080MARZO400,884,5226,013,267,830.5015,934,879ABRIL360,546,5085,408,197,620.5014,331,471MAYO350,327,6445,254,914,663.5013,925,278JUNIO340,956,1235,114,341,845.5013,552,767JULIO376,887,8085,653,317,120.5014,981,026AGOSTO371,522,8775,572,843,155.0014,767,774SEPTIEMBRE330,789,4564,961,841,840.0013,148,649OCTUBRE320,532,1654,807,982,475.0012,740,929NOVIEMBRE350,159,7535,252,396,295.0013,918,605DICIEMBRE470,546,5087,058,197,620.5018,703,894TOTAL4,566,558,09668,498,371,446.00181,517,484181,517,484ELABORORENOTA:LA EMPRESA TIENE 3 LÍNEAS DE PRODUCCIÓNPRODUCTOPRECIO DE VENTAORIGINAL15.00LIGHT13.00ZERO12.00
OMPANY S.A. DE C.V.ESTO DE VENTASCIEMBRE DEL 2019LIGHTZEROTOTALVENTASCANTIDADVENTAS236,484,714.7412,593,144151,117,725.317,252,301,560.06225,174,040.0811,990,834143,890,013.246,905,435,913.32207,153,424.0211,031,211132,374,535.346,352,795,789.86186,309,122.839,921,223119,054,674.965,713,561,418.30181,028,618.089,640,029115,680,343.275,551,623,624.85176,185,969.899,382,151112,585,809.325,403,113,624.71194,753,340.7110,370,889124,450,672.755,972,521,133.96191,981,061.4810,223,262122,679,139.525,887,503,356.00170,932,437.339,102,393109,228,713.325,242,002,990.65165,632,075.678,820,141105,841,692.735,079,456,243.40180,941,861.819,635,409115,624,904.555,548,963,061.36243,150,620.5412,948,113155,377,351.667,456,725,592.71125,658,7982,359,727,287.18125,658,798.002,178,209,803.5583,222,375,561.95125,658,798EVISOAUTORIZO
0.1002170366117286.4 14552905.52 10074515.020.095423827888519.68138568649592667.550.0877870320707617.6 12747903.02 8824969.0230.0789537288437206.4 11465176.79 7936978.3310.0767159280262115.4 11140222.65 7712022.8850.0746637272764898.4 10842213.53 7505720.6210.0825321301510246.4 11984820.97 8296711.5170.0813573297218301.6 11814219.17 8178609.3010.0724374264631564.8 10518919.22 7281914.2220.0701912256425732 10192743.12 7056112.8490.0766791280127802.411134883.87708326.970.1030418376437206.4 14963115.11 10358490.11
PRODUCCIÓN EN PROCESO% DE AVANCEORIGINAL4,566,558,09670%3,196,590,6672,283,279,048LIGHT181,517,48470%127,062,23990,758,742ZERO125,658,79870%87,961,15962,829,399COCA COLA COMPANY S.A. DE C.PRESUPUESTO DE PRODUCCIÓNAL 31 DE DICIEMBRE DEL 2019UNIDADES REQUERIDAS PARA LA VENTA(+)INVENTARIO FINAL DE ARTÍCULO TERMINADO=TOTAL DE UNIDADES TERMINADAS REQUERIDAS(-)INVENTARIO INICIAL DE UNIDADES TERMINADAS=UNIDADES TRANSFERIDAS A PRODUCTOS TERMINADOS(+)INVENTARIO FINAL DE PRODUCCIÓN EN PROCESO=SUBTOTAL(-)INVENTARIO INICIAL DE PRODUCIÓN EN PROCESO=PRODUCCIÓN TOTALELABÓROREVISOUNIDADESINICIALESUNIDADESEQUIVALENTESUNIDADESFINALES
ARTÍCULOS TERMINADOS% DE AVANCE40%913,311,6191,826,623,2391,598,295,33440%36,303,49772,606,99363,531,11940%25,131,76050,263,51943,980,579.V.1.3N1.97594.95ORIGINALLIGHTZERO4,566,558,096181,517,484125,658,7981,598,295,33463,531,11943,980,5796,164,853,430245,048,603169,639,3771,826,623,23972,606,99350,263,5194,338,230,192172,441,609119,375,858913,311,61936,303,49725,131,7605,251,541,811208,745,106144,507,6183,196,590,667127,062,23987,961,1592,054,951,14381,682,86856,546,4592,193,180,470AUTORIZOUNIDADESEQUIVALENTESINVENTARIOINICIALINVENTARIOFINAL
0.811.666666670.325
ORIGINALAGUA CARBONATADA0.45ORIGINALAZUCAR0.063ORIGINALCARAMELO0.025ORIGINALACIDO FOSFÓRICO0.02ORIGINALCAFEINA0.01ORIGINAL566,558,096 X 0.6 LITROS924,728,015566,558,096 X 0.05 KILOGRAMOS566,558,096 X 0.05 KILOGRAMOS566,558,096 X 0.04 LITROS566,558,096 X 0.07 KILOGRAMOSCANTIDAD REQUERIDA Y PRECIO DELA MATERIA PRIMAAGUA CARBONATADA(LITROS)CANTIDAD REQUERIDA PARA LAPRODUCCIÓN
LIGHT118,907,255 X 0.6 LITROS49,009,721118,907,255 X 0 KILOGRAMOS118,907,255 X 0 KILOGRAMOS118,907,255 X 0.04 LITROS118,907,255 X 0.07 KILOGRAMOSZERO13,989,089 X 0.6 LITROS33,927,87513,989,089 X 0 KILOGRAMOS13,989,089 X 0 KILOGRAMOS13,989,089 X 0.04 LITROS13,989,089 X 0.07 KILOGRAMOS1,007,665,611PRECIO UNITARIO2.002,015,331,221.12=1,007,665,611(+)318,747,776=1,326,413,386(-)3,300,000,000=-1,973,586,614*COSTO UNITARIO2.00=TOTAL DE COSTO DE LAS COMPRAS-CONSUMO DE MATERIA PRIMAPARA LA PRODUCCIÓNAGUA CARBONATADA(LITROS)UNIDADES NECESARIAS PARA LAPRODUCCIÓNINVENTARIO FINAL DE MATERIAPRIMA DIRECTATOTAL DE UNIDADES DE MATERIALESQUE DEBERÁN PROPORCIONARINVENTARIO INICIAL DE MATERIAPRIMA DIRECTAUNIDADES QUE DEBERÁNCOMPRARSE
ELABÓRO

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 37 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
ChristopherKnight
Tags
Light, Activo, Kilogramo, Litros

Newly Uploaded Documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture