ejercicio problemas en clase

3
codigo demanda valor art valor total porcentaje 10 1300 28 36400 8.07901454 20 1200 18 21600 4.79414049 30 3000 15 45000 9.9877927 40 2800 17 47600 10.5648652 50 1500 13 19500 4.3280435 60 1350 23 31050 6.89157696 70 3000 14 42000 9.32193985 80 1900 12 22800 5.06048163 90 4000 10 40000 8.87803795 100 1100 22 24200 5.37121296 110 3500 20 70000 15.5365664 120 4200 12 50400 11.1863278 Codigo articulo consumo mensual costo unitario Valor total 1 Resina 10000 20 200000 2 Metano 8000 8 64000 3 Polietileno 7500 15 112500 4 Poliuretano 9500 30 285000 5 PVC 6000 25 150000 6 Acidos 9300 20 186000 7 Blipropileno 9000 10 90000 8 ABS 7500 12 90000 9 Acrilico 8500 12 102000 10 Butano 9300 28 260400 11 Liga 8300 22 182600 12 Poliestireno 7300 37 270100 1992600 Un fabricante de productos para plasticos, desea elaborar una clasificac de control de inventar

Upload: giohp1494

Post on 29-Sep-2015

216 views

Category:

Documents


2 download

DESCRIPTION

ao

TRANSCRIPT

Hoja1codigodemandavalor artvalor totalporcentajecodigovalor total% v Total% Acumulado 10130028364008.07901453781107000015.536566418815.536566418880.446121407220120018216004.7941404951205040011.186327821626.722894240430300015450009.9877926978404760010.564865164837.2877594052402800174760010.564865164830450009.987792697847.275552103A50150013195004.328043502470420009.321939851356.597491954360135023310506.891576961590400008.878037953665.475529907970300014420009.321939851310364008.079014537873.554544445780190012228005.060481633660310506.891576961580.446121407290400010400008.8780379536100242005.371212961985.817334369115.2258350904100110022242005.371212961980228005.060481633690.8778160027B1103500207000015.536566418820216004.79414049595.67195649761204200125040011.186327821650195004.32804350241004.3280435024CUn fabricante de productos para plasticos, desea elaborar una clasificacion A B C por valor, para establecer un sistema de contol de inventarios, dispone un sistema de control de inventarios dispone de la siguiente informacion

Codigoarticuloconsumo mensualcosto unitarioValor total% Valor totalCodigoValor total% del valor total% Acumulado1Resina100002020000010.0371374084428500014.30292080714.3029208072Metano80008640003.21188397071227010013.555154070127.8580748773Polietileno7500151125005.64588979221026040013.068352905840.9264277828A4Poliuretano95003028500014.302920807120000010.037137408450.96356519125PVC6000251500007.527853056361860009.334537789860.2981029816Acidos9300201860009.3345377898111826009.163906453969.46200943497Blipropileno900010900004.516711833851500007.527853056376.98986249128ABS750012900004.516711833831125005.645889792282.63575228349Acrilico8500121020005.118940078391020005.118940078387.7546923617B10Butano93002826040013.06835290587900004.516711833892.271404195511Liga8300221826009.16390645398900004.516711833896.788116029312Poliestireno73003727010013.55515407012640003.2118839707100C1992600100