ejercicio problemas en clase

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