RESULTADOS A REFERENCIAMODELO AMODELO BSKU185WW1R,SSKU033WW1R,SSKU021WW1R,SSKU163WW1R,SSKU050WW1EOQSKU226WW1EOQSKU171WW1R,SSKU129WW1EOQSKU162WW1EOQSKU236WW1R,SSKU227WW1EOQSKU156WW1EOQSKU025WW1R,S,SKU105WW1R,SSKU111WW1EOQR,S853.33%EOQ746.67%

ReferenciaPrecio Promedio20022003200420052006200720082009201020112012totalSKU185$ 21,580.04129512671214122912681218119412311169117111751221SKU033$ 15,272.43125411921225120912131249125012251162120012111217.2727272727SKU021$ 20,352.25115511931201127412791175118912711221121512081216.4545454546SKU163$ 29,489.44118012261179117112241286119312191167124212651213.8181818182SKU050$ 27,192.54118611951236127511421191126412351238117511951212SKU226$ 27,054.66121612231174119512061198120712361212122612241210.6363636364SKU171$ 17,080.22119512351230121811931239122812151178117312051209.9090909091SKU129$ 30,871.47117512291182121712211261120712561180120111761209.5454545454SKU162$ 28,133.73120512291217117511701206124912231262120911581209.3636363636SKU236$ 22,400.54118211991208124111331253125011781224115912661208.4545454546SKU227$ 29,776.85121511741256121512101191121611721210123811941208.2727272727SKU156$ 39,651.84119112381189118411821242121812251221119211971207.1818181818SKU025$ 24,750.62117111841240117812511217123912141205119411551204.3636363636SKU105$ 32,744.44129411951196119412021196120911391203120212171204.2727272727SKU111$ 27,136.69122611941187122211761242122711751206119311931203.7272727273SKU123$ 21,393.55116112081163124411691228121112421237115412081202.2727272727SKU122$ 27,540.23117711571219114612061190118312691163122012161195.0909090909SKU140$ 35,304.54122111981222118411711198118011751180120512111195SKU176$ 21,339.78116812161183119711831130121412531199117012091192.9090909091SKU084$ 28,797.22117811361209123811481222119111811242120111641191.8181818182SKU092$ 30,612.92117412351184118211611198115311791154117912051182.1818181818SKU085$ 11,013.731174108910541080989920107711791019103610081056.8181818182SKU239$ 20,480.431093111095710801079109499091799611469231035SKU190$ 20,663.479729969881216100810091129103110139679501025.3636363636SKU024$ 15,766.7811361069100510989781148103010239328679821024.3636363636SKU029$ 27,274.879059231096111692310941106979101811258431011.6363636364SKU108$ 16,769.56101493699311369521245972987100210168671010.9090909091SKU002$ 19,329.09939108794811821048830113698599410289411010.7272727273SKU109$ 18,928.709241076101310728741062114397791010709821009.3636363636SKU016$ 22,437.5583510051144118010601100108087010099578221005.6363636364SKU200$ 20,918.888849211096911109510481080103997310109981005SKU099$ 24,065.7197610571078851114480586910881004109810641003.0909090909SKU071$ 18,914.137721039962100911039451078106811919149501002.8181818182SKU047$ 23,275.8391194795897510699549301117106111419671002.7272727273SKU044$ 25,269.709001051947102394811731036110810468958831000.9090909091SKU167$ 19,065.901063108491489410101061908109510331019890997.3636363636SKU009$ 20,467.10106394610039489811123103211239401189620997.0909090909SKU114$ 12,855.028381063967103510701018108391011271021820995.6363636364SKU072$ 22,975.3810138769499501043961100493712428921084995.5454545455SKU152$ 22,222.7997210269691056110110791026963878914962995.0909090909SKU100$ 15,139.0010351064122789183810099438338361268948990.1818181818SKU183$ 21,121.57887105496181310691041105590911598871056990.0909090909SKU054$ 16,429.09983102410031025887111894089410811037896989.8181818182SKU249$ 27,168.50102291494511007881105967108410411096826989.8181818182SKU010$ 15,004.6988910368989801027968981103010728891117989.7272727273SKU057$ 25,737.089541055106479896210729859419539731129989.6363636364SKU017$ 13,889.771064972107891311381041897985965929902989.4545454545SKU245$ 10,246.82922929105310931051909921105511191044787989.3636363636SKU188$ 21,754.78113810201006100110069731052898941860954986.2727272727SKU214$ 19,480.98101288611311051972103987910208811004973986.1818181818SKU128$ 15,313.859261074962100598188293010559599721079984.0909090909SKU035$ 28,538.65115110111111103197989686381892810271007983.8181818182SKU181$ 15,894.13110910168791060894110090286410971011889983.7272727273SKU087$ 18,385.751035108985899896392998410029301142887983.3636363636SKU248$ 22,776.8811388219791000983906109010479398791033983.1818181818SKU120$ 14,695.27108388210427401051993949101810141088947982.4545454545SKU215$ 17,801.9899892697710579151141982980966989874982.2727272727SKU160$ 13,231.321007912102791798291898411608479441103981.9090909091SKU013$ 16,032.6987393011279701175904101080793310371030981.4545454545SKU216$ 22,141.57104193397999793411081110932791981968979.4545454545SKU222$ 20,071.4994510361045102993310998239871128881865979.1818181818SKU023$ 8,953.20111393910281067849971882100410388611019979.1818181818SKU069$ 20,609.871011105987711719791021926994890971858977.9090909091SKU113$ 12,596.798769179468291074108090910619559951109977.3636363636SKU131$ 20,001.63868996967954108684490911669559461060977.3636363636SKU112$ 12,740.781176925834105093390410628189301182936977.2727272727SKU082$ 26,480.649261088961113088392710069698459971016977.0909090909SKU232$ 21,707.11894106293310131018963962956982962988975.7272727273SKU186$ 16,406.4193887810339411087100092810599938031066975.0909090909SKU097$ 17,882.6311641074845861852905102410379769471034974.4545454545SKU165$ 26,563.9788281810508457851158113991610931045979973.6363636364SKU031$ 12,083.10103987094190110449468649541266988893973.2727272727SKU086$ 17,097.0887694394610221032856107310181005961974973.2727272727SKU206$ 19,371.74113295994991884410279891049927948957972.6363636364SKU161$ 24,184.169809201077968103997095310088971067814972.0909090909SKU093$ 17,929.1099976897311289929679129939031069985971.7272727273SKU043$ 14,045.55875855109711211062100210508401059795932971.6363636364SKU133$ 13,966.9995395710178989298491056708107410621183971.4545454545SKU240$ 21,885.598809428971148919868106586584511241130971.1818181818SKU028$ 22,371.961050897101193610261110908937925955927971.0909090909SKU118$ 20,957.6187010251052710100597997311931005998871971SKU012$ 20,915.62932862105311199509741069993943930852970.6363636364SKU187$ 21,493.1893210198309958381030103610219621062940969.5454545455SKU056$ 13,663.3010691154903995104281310528139278501036968.5454545455SKU049$ 13,696.1095011078919769989559898341013936997967.8181818182SKU209$ 25,953.027759431116105611069789048929527921126967.2727272727SKU142$ 16,225.9310209961017948101694390087685410311033966.7272727273SKU091$ 22,131.918608751151873101676191596598210821144965.8181818182SKU107$ 13,382.3179995492098486710521020103710218551107965.0909090909SKU139$ 22,860.67965113210889601202845944774738966987963.7272727273SKU229$ 17,065.801006971910937845987101492211151056836963.5454545455SKU177$ 25,457.10858102010159059849711057920955940974963.5454545455SKU045$ 23,198.0989699110097738409769181107100510791004963.4545454545SKU154$ 11,240.9291493298496899210348839379301070946962.7272727273SKU182$ 18,694.31102896110441001108379288183510071032916961.8181818182SKU244$ 9,862.968538409711228106778810079549501058863961.7272727273SKU004$ 21,919.117919251160963964102197579275610021223961.0909090909SKU126$ 18,702.541026929860104194310939849277659741028960.9090909091SKU003$ 17,366.79999954947105493285585510908889821012960.7272727273SKU136$ 16,637.021012103911799688271045873911827885994960SKU104$ 23,876.9810191076117587510058371045902793968861959.6363636364SKU027$ 17,024.1195310331033803112692994010178531000867959.4545454545SKU212$ 15,981.0199310048581107100990690494579810071018959SKU205$ 21,937.6092486590599999011259209718821012940957.5454545455SKU005$ 20,676.03913108698690488110239788518979681045957.4545454545SKU037$ 27,980.2997176092810189379481006103010281102799957SKU231$ 15,474.1110671048103511109297208369481019999803955.8181818182SKU199$ 18,257.011123117286290082378810268489791129863955.7272727273SKU081$ 24,149.789807518999551021869111292910508811065955.6363636364SKU048$ 18,803.371139100186288093910081000831982946899953.3636363636SKU083$ 14,148.0410207901008930101510289649348281194773953.0909090909SKU224$ 16,402.96940941100510509411016884998936894879953.0909090909SKU158$ 22,932.76839927988105111138801059921976892837953SKU034$ 18,278.551022109278094982292010028849799551062951.5454545455SKU053$ 17,509.821050970111777283193610148149201051990951.3636363636SKU019$ 27,961.0610278099369018871075989972976937953951.0909090909SKU051$ 20,239.5280610861011882939889101910587991063910951.0909090909SKU217$ 19,964.4389210669849819118931016989841997871949.1818181818SKU094$ 19,217.36980902754111891589710559669051027910948.0909090909SKU141$ 20,854.49961108780510009481046741958933961977947SKU078$ 19,952.67932958101910758939948281038818910951946.9090909091SKU220$ 13,543.4683693690898395511748429849008761022946.9090909091SKU153$ 10,410.14105496199110198459261038937899875866946.4545454545SKU145$ 21,546.1595011029518649919598931059874964796945.7272727273SKU198$ 18,652.798741054934107074610219618711007914939944.6363636364SKU076$ 22,861.499001015109087285099392910458897701029943.8181818182SKU164$ 23,957.29999843104298310399808029421055801854940SKU144$ 27,409.028809569578271060947850101663210471166939.8181818182SKU063$ 12,352.8689910178529478561144942814998922943939.4545454545SKU088$ 20,682.76918855988932894106693510191008864823936.5454545455SKU203$ 21,781.59907940104395084810158849828821023827936.4545454545SKU207$ 24,373.401047107381593492587384810751000818886935.8181818182SKU066$ 26,509.41109694390493581795710211038988832762935.7272727273SKU052$ 18,746.951046889836745103879110199839151103921935.0909090909SKU079$ 21,798.189749321044951756101599110238571015726934.9090909091SKU137$ 17,813.9787410238699619628819631039927858920934.2727272727SKU062$ 20,181.039209389319799279318081079858968927933.2727272727SKU238$ 20,382.541084989110574190074910249148001050892931.6363636364SKU219$ 18,269.97107285010368619507409971137942774888931.5454545455SKU147$ 20,341.40962884100398310809638808308441016798931.1818181818SKU237$ 17,083.249759959028498999489108327919931105927.1818181818SKU102$ 24,889.77898812105082610479627798799271117837921.2727272727SKU151$ 18,603.7499286080087611127439919458031037957919.6363636364SKU038$ 8,396.00103479070589210139099359668201096903914.8181818182SKU041$ 16,866.4380981791892393672610458941119975887913.5454545455SKU179$ 20,470.0886577787710001035917828976890917961913SKU157$ 18,766.35864878737914793999101993981810311020910.1818181818SKU228$ 21,181.64860909736949775831106883410491056883904.5454545455SKU211$ 16,310.51844819102990196279710427837688951085902.2727272727SKU146$ 13,154.848227979249278751014891874903813868882.5454545455SKU008$ 17,512.33803945872935670897943978957857823880SKU007$ 14,544.41665572704705749679763548756625649674.0909090909SKU039$ 18,602.99846787692489706632649633638677596667.7272727273SKU070$ 15,140.17598643590609635591584729829635828661SKU106$ 10,463.09721610843461629771557819679569592659.1818181818SKU166$ 14,625.74743663575616506677714597714813576654SKU077$ 9,167.98646746540663524634760695746617621653.8181818182SKU127$ 20,533.60430640668647608714454650723716887648.8181818182SKU067$ 11,039.67686651558786411577672626656648857648SKU233$ 17,848.39629746602429598707744615642648713643SKU218$ 12,479.38638721659491652705629555672627720642.6363636364SKU169$ 13,249.84750663731605593612484658644654661641.3636363636SKU223$ 11,527.48715595600688643723683610623693479641.0909090909SKU064$ 11,184.10465679578596664625705830638609655640.3636363636SKU138$ 8,816.77620799521684735618591675583647552638.6363636364SKU022$ 13,875.55675491684758677628615607651639598638.4545454545SKU250$ 21,624.22595748633808681636503527589688610638SKU235$ 14,660.51720532628725656521519620753636689636.2727272727SKU184$ 15,919.52504596672644630611769717601611643636.1818181818SKU191$ 17,412.09669655643679469619669758707551544633SKU089$ 15,353.00629511613682829625542599698604630632.9090909091SKU170$ 16,579.34754527664780659602524637493754553631.5454545455SKU020$ 18,322.96625629763520561439868538786667545631SKU036$ 11,446.07518584699643510653696508863597667630.7272727273SKU175$ 12,683.36576603676568560838704590601480738630.3636363636SKU121$ 14,616.50507601655548568741629645875542620630.0909090909SKU095$ 10,727.84542614537703659766648652661536587627.7272727273SKU060$ 15,021.84568540581659603636639657702632686627.5454545455SKU130$ 13,738.81682594777570729520553559521686711627.4545454545SKU189$ 16,426.86678543612559713684643521784468696627.3636363636SKU125$ 12,013.91761500712593621628698588562572661626.9090909091SKU115$ 13,167.68703711764663716467632577604556497626.3636363636SKU173$ 15,521.04727741559597649622625560562545673623.6363636364SKU040$ 13,589.81679593586737544545592634622608717623.3636363636SKU204$ 10,651.10698711647686533543538707469695629623.2727272727SKU080$ 8,502.90632463506635552618809570677755630622.4545454545SKU168$ 15,407.14596586644557735506589681720724506622.1818181818SKU246$ 15,208.78624657745461707682697539599560541619.2727272727SKU055$ 15,693.69597767555705513744605647472494707618.7272727273SKU042$ 13,619.31483679703585722804517587547537626617.2727272727SKU178$ 22,494.55559666448746766588559615652564618616.4545454545SKU195$ 9,481.80617549553503483800628597619792634615.9090909091SKU221$ 8,262.64556672514652668706618461655560713615.9090909091SKU201$ 11,826.40685609605632635601591631651602532615.8181818182SKU174$ 16,506.04536624505636708677613663694610506615.6363636364SKU132$ 16,846.11444515553850658578504820494746607615.3636363636SKU073$ 11,479.33721560713565648637601533511666603614.3636363636SKU134$ 10,546.49517616621751712647540584488690588614SKU242$ 15,761.69683578589568638614629615648641545613.4545454545SKU103$ 16,675.73621712512531609661601445717657677613SKU059$ 17,353.67739560485521760632531550686642618611.2727272727SKU046$ 11,231.83489730517692704687502690531555607609.4545454545SKU194$ 18,935.53573602693551675569550640632622596609.3636363636SKU241$ 11,663.51513741584580771518598599554553685608.7272727273SKU150$ 14,765.91583553737720638632556507526624612608SKU210$ 11,783.48577558524542746658562584604671656607.4545454545SKU068$ 14,473.69680518525629751616692485546598641607.3636363636SKU001$ 14,992.12707621542552630545608631536651653606.9090909091SKU230$ 13,403.06563573526529569641570641629736696606.6363636364SKU155$ 15,379.54724622500716496709574495539708580605.7272727273SKU117$ 20,869.00527545588619588579664590634605723605.6363636364SKU197$ 19,798.86606654424608612656736631679555496605.1818181818SKU124$ 15,741.54573491578690634769530666483673544602.8181818182SKU015$ 13,236.55518585765403640626699457621645671602.7272727273SKU101$ 15,280.07612704583499542566695660602515651602.6363636364SKU247$ 21,285.64529678643587543606747591552507642602.2727272727SKU213$ 15,196.82604398610689558656602613581689622602SKU116$ 15,441.22619556634611464615557771515648624601.2727272727SKU030$ 15,108.53575542633762611422524707690651487600.3636363636SKU243$ 22,735.74663582521610561625571526622630687599.8181818182SKU143$ 17,884.70588643528526520556584579616717741599.8181818182SKU225$ 20,009.73540618603567491474631726741603592598.7272727273SKU018$ 13,320.78710709521628462649629589698523451597.1818181818SKU180$ 15,427.82499682688651578547594535556651575596SKU234$ 18,852.54583534561683643509592616657680493595.5454545455SKU011$ 11,550.41595614642509476646623603617604620595.3636363636SKU172$ 11,318.69482620590583647727551598658645431593.8181818182SKU159$ 24,901.47750571714585551370514586622724544593.7272727273SKU135$ 8,289.75586651619557578617670528438720561593.1818181818SKU148$ 14,924.55608521571547583452602656686598695592.6363636364SKU006$ 12,942.33729600542662524614667621448519581591.5454545455SKU096$ 16,680.93605739641594573379637668501757411591.3636363636SKU149$ 18,070.32590537602482515620623558704652618591SKU192$ 17,744.90650683452573570512704569546514693587.8181818182SKU193$ 15,300.91772356683591553599722533533627495587.6363636364SKU026$ 12,800.27508668735658449599541602539569584586.5454545455SKU014$ 14,705.09676454651656580658736321594435681585.6363636364SKU110$ 17,146.59750610591549541475619640567716353582.8181818182SKU196$ 16,022.04589562489539519620609748471611646582.0909090909SKU074$ 9,490.91578427445609734658518622722644415579.2727272727SKU058$ 11,356.93471417554666540589581651646842381576.1818181818SKU090$ 17,181.28650657511506491634613639675434505574.0909090909SKU098$ 13,580.46547674629627425500533565685520602573.3636363636SKU119$ 12,869.20489685552645543618521414603673533570.5454545455SKU208$ 14,037.18497541604580591525594459641624582567.0909090909SKU065$ 16,081.08566448570556539686721627489476529564.2727272727SKU202$ 13,427.87667623580545429509566562502546658562.4545454545SKU075$ 18,898.37497661677491600457495490578717495559.8181818182SKU061$ 12,469.80548499703469639509394482675577540548.6363636364SKU032$ 20,554.07665552590516723458440523413487652547.1818181818

sku 185valor producto$ 21,580.04FILA A ANALIZARcosto x ordenar$ 3,000,000.00129512671214122912681218119412311169117111751221costo de mantener inv unid/ao4316.008EOQ% del costo de mantener en inv unid/ao20%del valor productos,QR,SWW1WW2WW3WW4WW5WW6WW7WW8WW9WW10WW11ANALISIS EOQEOQ(# entero)1302Calculo del EOQ1302.8437582396

Demanda12951267121412291268121811941231116911711175Inventario7.0042.00130.00203.00237.00321.00429.00500.00633.00764.00891.00Pedido13021302130213021302130213021302130213021302Costo (A)30000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.00Costo (r*V)30212.056181272.336561081.04876149.6241022893.8961385438.5681851567.43221580042732033.0643297430.1123845563.128$ 17,941,645.26Total costos$ 50,941,645.26

MODELO (s,Q)Pedido3000Punto de reorden1554invCalculo de reorden1554pedido

Demanda12951267121412291268121811941231116911711175Inventario17054382224995272715093315208491527441569Pedido03000030000300000300000Costo (A)03000000030000000300000000300000000$ 12,000,000.00Costo (r*V)7358793.641890411.5049598801.7924294427.9611769753.8166512856.07214307566.528994560.6723949147.3211843125.9526771816.552$ 87,291,261.80Total costos$ 99,291,261.80modelo R,SPunto de reorden1554Calculo de reorden1554inv

Demanda12951267121412291268121811941231116911711175Inventario259287340325286336360323385383379Pedido12951267121412291268121811941231116911711175Costo (A)30000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.00Costo (r*V)1117846.0721238694.2961467442.721402702.61234378.2881450178.6881553762.881394070.5841661663.081653031.0641635767.032$ 15,809,537.30Total costos$ 48,809,537.30ALGORITMO112951267121412291268121811941231116911711175000000000001295126712141229126812181194123111691171117530000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.0000000000000$ 0.00Total costos$ 33,000,000.00

2256202443024860242502340011751267012290121801231011710030000000300000003000000030000000300000000$ 15,000,000.0011057612.496010544007.544010729595.888010466319.4010099458.7205071309.4$ 57,968,303.45Total costos$ 72,968,303.45

3248112140248612180240011690117503776003715003594002346030000000030000000030000000030000000$ 12,000,000.0010708015.8485239633.712010729595.8885256897.744010358419.25045413.35205071309.40$ 52,409,285.14Total costos$ 64,409,285.14

4371024431229036432425123102346117505005000491100035150030000000003000000000300000000$ 9,000,000.0016012389.6810544007.5445304373.832015723217.14410466319.45313005.848010125354.7685071309.40$ 78,559,977.62Total costos$ 87,559,977.625497837112497126804765357123401171006273000059830000117530000000000300000000003000000$ 9,000,000.0021485087.82416016705.68810777071.9765472698.144020565778.1215412464.56810099458.725054045.36800$ 104,883,310.41Total costos$ 113,883,310.416619649293715248612180474635152346117507491000005940000030000000000030000000000$ 6,000,000.0026741985.56821273603.43216033969.7210729595.8885256897.744020483773.96815170768.1210125354.7685071309.40$ 130,887,258.61Total costos$ 136,887,258.617739061234909368024121194035152346117508685000000474600030000000000003000000000$ 6,000,000.0031895299.1226426916.98421187283.27215882909.4410410211.2965153313.552015170768.1210125354.7685071309.40$ 141,323,365.95Total costos$ 147,323,365.958862173546140491136432425123102346117509916000000035150030000000000000300000000$ 6,000,000.0037208304.96831739922.83226500289.1221195915.28815723217.14410466319.45313005.848010125354.7685071309.40$ 163,343,638.77Total costos$ 169,343,638.7799790852373096080481235942400116901175011085000000002346030000000000000030000000$ 6,000,000.0042253718.3236785336.18431545702.47226241328.6420768630.49615511732.75210358419.25045413.35205071309.40$ 193,581,590.82Total costos$ 199,581,590.821010961969484807251598347653571234011710012256000000000117530000000000000003000000$ 6,000,000.0047307763.68841839381.55236599747.8431295374.00825822675.86420565778.1215412464.56810099458.725054045.36800$ 233,996,689.73Total costos$ 239,996,689.7311121361086996558426715859404746351523461175013431000000000030000000000000000$ 3,000,000.0052379073.08846910690.95241671057.2436366683.40830893985.26425637087.5220483773.96815170768.1210125354.7685071309.40$ 284,709,783.73Total costos$ 287,709,783.73

sku 033valor producto$ 15,272.43FILA A ANALIZARcosto x ordenar$ 3,000,000.00125411921225120912131249125012251162120012111217.2727272727costo de mantener inv unid/ao3054.486EOQ% del costo de mantener en inv unid/ao20%del valor productos,QR,SWW1WW2WW3WW4WW5WW6WW7WW8WW9WW10WW11ANALISIS EOQEOQ(# entero)1546Calculo del EOQ1546.3240184304

Demanda12541192122512091213124912501225116212001211Inventario292.00646.00967.001304.0091.00388.00684.001005.001389.00189.00524.00Pedido15461546154615460154615461546154601546Costo (A)30000003000000300000030000000300000030000003000000300000003000000$ 27,000,000.00Costo (r*V)891909.9121973197.9562953687.9623983049.744277958.2261185140.5682089268.4243069758.434242681.054577297.8541600550.664$ 22,844,500.79Total costos$ 49,844,500.79

MODELO (s,Q)Pedido3000Punto de reorden1504invCalculo de reorden1504.8pedido

Demanda12541192122512091213124912501225116212001211Inventario174655423291120290716584082183102128211610Pedido03000030000030000300000Costo (A)03000000030000000030000000300000000$ 12,000,000.00Costo (r*V)5333132.5561692185.2447113897.8943421024.328879390.8025064337.7881246230.2886667942.9383118630.2068616705.0064917722.46$ 56,071,199.50Total costos$ 68,071,199.50modelo R,SPunto de reorden1504Calculo de reorden1504.8inv

Demanda12541192122512091213124912501225116212001211Inventario250312279295291255254279342304293Pedido12541192122512091213124912501225116212001211Costo (A)30000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.00Costo (r*V)763621.5952999.632852201.594901073.37888855.426778893.93775839.444852201.5941044634.212928563.744894964.398$ 9,633,848.84Total costos$ 42,633,848.84ALGORITMO112541192122512091213124912501225116212001211000000000001254119212251209121312491250122511621200121130000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.0000000000000$ 0.00Total costos$ 33,000,000.00

2244602434024620247502362012111192012090124901225012000030000000300000003000000030000000300000000$ 15,000,000.007471272.75607434618.92407520144.53207559852.8507214695.93203698982.546$ 40,899,567.54Total costos$ 55,899,567.54

3241712250246212490238711620121103671003671003637002411030000000030000000030000000030000000$ 12,000,000.007382692.6623741745.3507520144.5323815053.01407291058.0823549312.73203698982.5460$ 36,998,988.92Total costos$ 48,998,988.92

4362624341209037242475122502411121104880000493700035730030000000003000000000300000000$ 9,000,000.0011075566.2367434618.9243692873.574011374905.8647559852.853741745.3507364365.7463698982.5460$ 55,942,911.09Total costos$ 64,942,911.095483936472422121304837358723621200006093000060860000121130000000000300000000003000000$ 9,000,000.0014780657.75411139710.4427397965.0923705091.518014774548.78210956441.2827214695.9323665383.200$ 73,634,494.00Total costos$ 82,634,494.006608848963671246212490479835732411121107342000006048000030000000000030000000000$ 6,000,000.0018595710.76814954763.45611213018.1067520144.5323815053.014014655423.82810913678.4787364365.7463698982.5460$ 92,731,140.47Total costos$ 98,731,140.477733861464921371224991250035732411121108592000000479800030000000000003000000000$ 6,000,000.0022413818.26818772870.95615031125.60611338252.0327633160.5143818107.5010913678.4787364365.7463698982.5460$ 100,984,361.65Total costos$ 106,984,361.658856373716146493737242475122502411121109817000000035730030000000000000300000000$ 6,000,000.0026155563.61822514616.30618772870.95615079997.38211374905.8647559852.853741745.3507364365.7463698982.5460$ 116,262,900.62Total costos$ 122,262,900.6299725853373086099488636372387116201211010979000000002411030000000000000030000000$ 6,000,000.0029704876.3526063929.03822322183.68818629310.11414924218.59611109165.5827291058.0823549312.73203698982.5460$ 137,293,036.73Total costos$ 143,293,036.731010925973385087299608648373587236212000012179000000000121130000000000000003000000$ 6,000,000.0033370259.5529729312.23825987566.88822294693.31418589601.79614774548.78210956441.2827214695.9323665383.200$ 166,582,502.98Total costos$ 172,582,502.9811121361094497198510729760484798357324111211013390000000000030000000000000000$ 3,000,000.0037069242.09633428294.78429686549.43425993675.8622288584.34218473531.32814655423.82810913678.4787364365.7463698982.5460$ 203,572,328.44Total costos$ 206,572,328.44

sku 021valor producto$ 20,352.25FILA A ANALIZARcosto x ordenar$ 3,000,000.00115511931201127412791175118912711221121512081216.4545454546costo de mantener inv unid/ao4070.45EOQ% del costo de mantener en inv unid/ao20%del valor productos,QR,SWW1WW2WW3WW4WW5WW6WW7WW8WW9WW10WW11ANALISIS EOQEOQ(# entero)1339Calculo del EOQ1339.0671491067

Demanda11551193120112741279117511891271122112151208Inventario184.00330.00468.00533.00593.00757.00907.00975.001093.001217.009.00Pedido13391339133913391339133913391339133913390Costo (A)30000003000000300000030000003000000300000030000003000000300000030000000$ 30,000,000.00Costo (r*V)748962.81343248.51904970.62169549.852413776.853081330.653691898.153968688.754449001.854953737.6536634.05$ 28,761,799.70Total costos$ 58,761,799.70

MODELO (s,Q)Pedido3000Punto de reorden1534invCalculo de reorden1534.8pedido

Demanda11551193120112741279117511891271122112151208Inventario184565224511177289817235342263104228271619Pedido03000030000030000300000Costo (A)03000000030000000030000000300000000$ 12,000,000.00Costo (r*V)7509980.252653933.49976672.954790919.6511796164.17013385.352173620.39211428.354241408.911507162.156590058.55$ 77,464,733.95Total costos$ 89,464,733.95modelo R,SPunto de reorden1534Calculo de reorden1534.8inv

Demanda11551193120112741279117511891271122112151208Inventario379341333260255359345263313319326Pedido11551193120112741279117511891271122112151208Costo (A)30000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.00Costo (r*V)1542700.551388023.451355459.8510583171037964.751461291.551404305.251070528.351274050.851298473.551326966.7$ 14,218,081.85Total costos$ 47,218,081.85ALGORITMO111551193120112741279117511891271122112151208000000000001155119312011274127911751189127112211215120830000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.0000000000000$ 0.00Total costos$ 33,000,000.00

2234802475024540246002436012081193012740117501271012150030000000300000003000000030000000300000000$ 15,000,000.009557416.6010074363.7509988884.301001330709915616.204917103.6$ 54,466,691.45Total costos$ 69,466,691.45

3239412010245411750249212210120803549003728003681002423030000000030000000030000000030000000$ 12,000,000.009744657.34888610.4509988884.34782778.75010143561.44970019.4504917103.60$ 49,435,615.25Total costos$ 61,435,615.25

4366824751274036352460127102423120804823000491400036440030000000003000000000300000000$ 9,000,000.0014930410.610074363.755185753.3014796085.75100133075173541.9509862700.354917103.60$ 74,953,266.30Total costos$ 83,953,266.305494737542553127904896370724361215006102000060710000120830000000000300000000003000000$ 9,000,000.0020136516.1515280469.310391858.855206105.55019928923.215089158.159915616.24945596.7500$ 100,894,244.15Total costos$ 109,894,244.156612249293728245411750491536442423120807277000006104000030000000000030000000000$ 6,000,000.0024919294.920063248.0515174637.69988884.34782778.75020006261.7514832719.89862700.354917103.60$ 124,547,629.10Total costos$ 130,547,629.107731161184917364323641189036442423120808466000000491500030000000000003000000000$ 6,000,000.0029759059.9524903013.120014402.6514828649.359622543.84839765.05014832719.89862700.354917103.60$ 133,579,957.65Total costos$ 139,579,957.658858273896188491436352460127102423120809737000000036440030000000000000300000000$ 6,000,000.0034932601.930076555.0525187944.620002191.314796085.75100133075173541.9509862700.354917103.60$ 154,962,031.50Total costos$ 160,962,031.5099803861074096135485636812492122101208010958000000002423030000000000000030000000$ 6,000,000.0039902621.3535046574.530157964.0524972210.7519766105.214983326.4510143561.44970019.4504917103.60$ 184,859,486.75Total costos$ 190,859,486.751011018982586247350607148963707243612150012173000000000120830000000000000003000000$ 6,000,000.0044848218.139992171.2535103560.829917807.524711701.9519928923.215089158.159915616.24945596.7500$ 224,452,753.90Total costos$ 230,452,753.9011122261103398328558727961044915364424231208013381000000000030000000000000000$ 3,000,000.0049765321.744909274.8540020664.434834911.129628805.5524846026.820006261.7514832719.89862700.354917103.60$ 273,623,789.90Total costos$ 276,623,789.90

sku 163valor producto$ 21,580.04FILA A ANALIZARcosto x ordenar$ 3,000,000.00118012261179117112241286119312191167124212651213.8181818182costo de mantener inv unid/ao4316.008EOQ% del costo de mantener en inv unid/ao20%del valor productos,QR,SWW1WW2WW3WW4WW5WW6WW7WW8WW9WW10WW11ANALISIS EOQEOQ(# entero)1299Calculo del EOQ1299.0064992055

Demanda11801226117911711224128611931219116712421265Inventario119.00192.00312.00440.00515.00528.00634.00714.00846.00903.00937.00Pedido12991299129912991299129912991299129912991299Costo (A)30000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.00Costo (r*V)513604.952828673.5361346594.4961899043.522222744.122278852.2242736349.0723081629.7123651342.7683897355.2244044099.496$ 26,500,289.12Total costos$ 59,500,289.12

MODELO (s,Q)Pedido3000Punto de reorden1543invCalculo de reorden1543.2pedido

Demanda11801226117911711224128611931219116712421265Inventario182059424151244302017345412322115529131648Pedido03000030000030000300000Costo (A)03000000030000000030000000300000000$ 12,000,000.00Costo (r*V)7855134.562563708.75210423159.325369113.95213034344.167483957.8722334960.32810021770.5764984989.2412572531.3047112781.184$ 83,756,451.25Total costos$ 95,756,451.25modelo R,SPunto de reorden1543Calculo de reorden1543.2inv

Demanda11801226117911711224128611931219116712421265Inventario363317364372319257350324376301278Pedido11801226117911711224128611931219116712421265Costo (A)30000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.00Costo (r*V)1566710.9041368174.5361571026.9121605554.9761376806.5521109214.0561510602.81398386.5921622819.0081299118.4081199850.224$ 15,628,264.97Total costos$ 48,628,264.97ALGORITMO111801226117911711224128611931219116712421265000000000001180122611791171122412861193121911671242126530000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.0000000000000$ 0.00Total costos$ 33,000,000.00

2240602350025100241202409012651226011710128601219012420030000000300000003000000030000000300000000$ 15,000,000.0010384315.248010142618.8010833180.08010410211.296010397263.27205459750.12$ 57,627,338.82Total costos$ 72,627,338.82

3240511790251012860238611670126503585003681003579002507030000000030000000030000000030000000$ 12,000,000.0010379999.245088573.432010833180.085550386.288010297995.0885036781.33605459750.120$ 52,646,665.58Total costos$ 64,646,665.58

4357623501171036982412121902507126504756000492200036740030000000003000000000300000000$ 9,000,000.0015434044.60810142618.85054045.368015960597.58410410211.2965261213.752010820232.0565459750.120$ 78,542,713.58Total costos$ 87,542,713.585480035742395122404821362824091242005980000061070000126530000000000300000000003000000$ 9,000,000.0020716838.415425412.59210336839.165282793.792020807474.56815658477.02410397263.2725360481.93600$ 103,985,580.74Total costos$ 112,985,580.746608648603681251012860489336742507126507266000006086000030000000000030000000000$ 6,000,000.0026267224.68820975798.8815887225.44810833180.085550386.288021118227.14415857013.39210820232.0565459750.120$ 132,769,038.10Total costos$ 138,769,038.107727960534874370324791193036742507126508459000000489300030000000000003000000000$ 6,000,000.0031416222.23226124796.42421036222.99215982177.62410699383.8325148997.544015857013.39210820232.0565459750.120$ 142,544,796.22Total costos$ 148,544,796.228849872726093492236982412121902507126509678000000036740030000000000000300000000$ 6,000,000.0036677435.98431386010.17626297436.74421243391.37615960597.58410410211.2965261213.752010820232.0565459750.120$ 163,516,279.09Total costos$ 169,516,279.0999665843972606089486535792386116701265010845000000002507030000000000000030000000$ 6,000,000.0041714217.3236422791.51231334218.0826280172.71220997378.9215446992.63210297995.0885036781.33605459750.120$ 192,990,297.72Total costos$ 198,990,297.721010907968185027331610748213628240912420012087000000000126530000000000000003000000$ 6,000,000.0047074699.25641783273.44836694700.01631640654.64826357860.85620807474.56815658477.02410397263.2725360481.93600$ 235,774,885.02Total costos$ 241,774,885.0211121721094697678596737260864893367425071265013352000000000030000000000000000$ 3,000,000.0052534449.37647243023.56842154450.13637100404.76831817610.97626267224.68821118227.14415857013.39210820232.0565459750.120$ 290,372,386.22Total costos$ 293,372,386.22

sku 050valor producto$ 27,192.54FILA A ANALIZARcosto x ordenar$ 3,500,000.00118611951236127511421191126412351238117511951212costo de mantener inv unid/ao5438.508EOQ% del costo de mantener en inv unid/ao20%del valor productos,QR,SWW1WW2WW3WW4WW5WW6WW7WW8WW9WW10WW11ANALISIS EOQEOQ(# entero)1248Calculo del EOQ1248.9942645246

Demanda11861195123612751142119112641235123811751195Inventario62.00115.00127.00100.00206.00263.00247.00260.00270.00343.00396.00Pedido12481248124812481248124812481248124812481248Costo (A)35000003500000350000035000003500000350000035000003500000350000035000003500000$ 38,500,000.00Costo (r*V)337187.496625428.42690690.516543850.81120332.6481430327.6041343311.4761414012.081468397.161865408.2442153649.168$ 12,992,595.61Total costos$ 51,492,595.61

MODELO (s,Q)Pedido3000Punto de reorden1530invCalculo de reorden1530pedido

Demanda11861195123612751142119112641235123811751195Inventario181461923831108296617755112276103828631668Pedido03000030000030000300000Costo (A)03500000035000000035000000350000000$ 14,000,000.00Costo (r*V)9865453.5123366436.45212959964.5646025866.86416130614.7289653351.72779077.58812378044.2085645171.30415570448.4049071431.344$ 103,445,860.67Total costos$ 117,445,860.67modelo R,SPunto de reorden1530Calculo de reorden1530inv

Demanda11861195123612751142119112641235123811751195Inventario344335294255388339266295292355335Pedido11861195123612751142119112641235123811751195Costo (A)35000003500000350000035000003500000350000035000003500000350000035000003500000$ 38,500,000.00Costo (r*V)1870846.7521821900.181598921.3521386819.542110141.1041843654.2121446643.1281604359.861588044.3361930670.341821900.18$ 19,023,900.98Total costos$ 57,523,900.98ALGORITMO111861195123612751142119112641235123811751195000000000001186119512361275114211911264123512381175119535000003500000350000035000003500000350000035000003500000350000035000003500000$ 38,500,000.0000000000000$ 0.00Total costos$ 38,500,000.00

2238102511023330249902413011951195012750119101235011750035000000350000003500000035000000350000000$ 17,500,000.0012949087.548013656093.588012688039.164013590831.492013123119.80406499017.06$ 72,506,188.66Total costos$ 90,006,188.66

3243112360233311910247312380119503617003608003737002370035000000035000000035000000035000000$ 14,000,000.0013221012.9486721995.888012688039.1646477263.028013449430.2846732872.90406499017.060$ 65,789,631.28Total costos$ 79,789,631.28

4370625111275036902499123502370119504892000483200036080035000000003500000000350000000$ 10,500,000.0020155110.64813656093.5886934097.7020068094.5213590831.4926716557.38012889263.966499017.060$ 100,509,066.35Total costos$ 111,009,066.355484836532417114204912364824131175006034000061030000119535000000000350000000003500000$ 10,500,000.0026365886.78419866869.72413144873.8366210776.136026713951.29619839677.18413123119.8046390246.900$ 131,655,401.66Total costos$ 142,155,401.666603948443608233311910484336082370119507225000006107000035000000000035000000000$ 7,000,000.0032843149.81226344132.75219622136.86412688039.1646477263.028026338694.24419622136.86412889263.966499017.060$ 163,323,833.75Total costos$ 170,323,833.757730361084872359724551264036082370119508489000000484300035000000000003500000000$ 7,000,000.0039717423.92433218406.86426496410.97619562313.27613351537.146874274.112019622136.86412889263.966499017.060$ 178,230,784.18Total costos$ 185,230,784.188853873436107483236902499123502370119509724000000036080035000000000000350000000$ 7,000,000.0046433981.30439934964.24433212968.35626278870.65620068094.5213590831.4926716557.38012889263.966499017.060$ 205,624,548.97Total costos$ 212,624,548.9799776858173456070492837372473123801195010962000000002370035000000000000035000000$ 7,000,000.0053166854.20846667837.14839945841.2633011743.5626800967.42420323704.39613449430.2846732872.90406499017.060$ 246,598,268.24Total costos$ 253,598,268.241010951975685207245610349123648241311750012137000000000119535000000000000003500000$ 7,000,000.0059557101.10853058084.04846336088.1639401990.4633191214.32426713951.29619839677.18413123119.8046390246.900$ 297,611,473.28Total costos$ 304,611,473.2811121461095197158440729861074843360823701195013332000000000035000000000000000$ 3,500,000.0066056118.16859557101.10852835105.2245901007.5239690231.38433212968.35626338694.24419622136.86412889263.966499017.060$ 362,601,643.88Total costos$ 366,101,643.88

sku 226valor producto$ 27,054.66FILA A ANALIZARcosto x ordenar$ 3,500,000.00121612231174119512061198120712361212122612241210.6363636364costo de mantener inv unid/ao5410.932EOQ% del costo de mantener en inv unid/ao20%del valor productos,QR,SWW1WW2WW3WW4WW5WW6WW7WW8WW9WW10WW11ANALISIS EOQEOQ(# entero)1251Calculo del EOQ1251.4682594898

Demanda12161223117411951206119812071236121212261224Inventario35.0063.00140.00196.00241.00294.00338.00353.00392.00417.00444.00Pedido12511251125112511251125112511251125112511251Costo (A)35000003500000350000035000003500000350000035000003500000350000035000003500000$ 38,500,000.00Costo (r*V)189382.62340888.716757530.481060542.6721304034.6121590814.0081828895.0161910058.9962121085.3442256358.6442402453.808$ 15,762,044.92Total costos$ 54,262,044.92

MODELO (s,Q)Pedido3000Punto de reorden1483invCalculo de reorden1483.2pedido

Demanda12161223117411951206119812071236121212261224Inventario178456123871192298617885812345113329071683Pedido03000030000030000300000Costo (A)03500000035000000035000000350000000$ 14,000,000.00Costo (r*V)9653102.6883035532.85212915894.6846449830.94416157042.9529674746.4163143751.49212688635.546130585.95615729579.3249106598.556$ 104,685,301.40Total costos$ 118,685,301.40modelo R,SPunto de reorden1483Calculo de reorden1483.2inv

Demanda12161223117411951206119812071236121212261224Inventario267260309288277285276247271257259Pedido12161223117411951206119812071236121212261224Costo (A)35000003500000350000035000003500000350000035000003500000350000035000003500000$ 38,500,000.00Costo (r*V)1444718.8441406842.321671977.9881558348.4161498828.1641542115.621493417.2321336500.2041466362.5721390609.5241401431.388$ 16,211,152.27Total costos$ 54,711,152.27ALGORITMO112161223117411951206119812071236121212261224000000000001216122311741195120611981207123612121226122435000003500000350000035000003500000350000035000003500000350000035000003500000$ 38,500,000.0000000000000$ 0.00Total costos$ 38,500,000.00

2243902369024040244302438012241223011950119801236012260035000000350000003500000035000000350000000$ 17,500,000.0013197263.148012818497.908013007880.528013218906.876013191852.21606622980.768$ 72,057,381.44Total costos$ 89,557,381.44

3239711740240411980244812120122403613003599003655002450035000000035000000035000000035000000$ 14,000,000.0012970004.0046352434.168013007880.5286482296.536013245961.5366558049.58406622980.7680$ 65,239,607.12Total costos$ 79,239,607.12

4359223691195036412443123602450122404808000484700036620035000000003500000000350000000$ 10,500,000.0019436067.74412818497.9086466063.74019701203.41213218906.8766687911.952013256783.46622980.7680$ 98,208,415.80Total costos$ 108,708,415.805479835752401120604881367424381226006014000060790000122435000000000350000000003500000$ 10,500,000.0025961651.73619344081.912991647.7326525583.992026410759.09219879764.16813191852.2166633802.63200$ 130,939,143.47Total costos$ 141,439,143.476599647733599240411980489836622450122407212000006105000035000000000035000000000$ 7,000,000.0032443948.27225826378.43619473944.26813007880.5286482296.536026502744.93619814832.98413256783.46622980.7680$ 163,431,790.13Total costos$ 170,431,790.137720359804806361124051207036622450122408419000000489800035000000000003500000000$ 7,000,000.0038974943.19632357373.3626004939.19219538875.45213013291.466530994.924019814832.98413256783.46622980.7680$ 176,115,014.74Total costos$ 183,115,014.748843972166042484736412443123602450122409655000000036620035000000000000350000000$ 7,000,000.0045662855.14839045285.31232692851.14426226787.40419701203.41213218906.8766687911.952013256783.46622980.7680$ 203,115,565.42Total costos$ 210,115,565.4299651842872546059485336552448121201224010867000000002450035000000000000035000000$ 7,000,000.0052220904.73245603334.89639250900.72832784836.98826259252.99619776956.4613245961.5366558049.58406622980.7680$ 242,323,178.69Total costos$ 249,323,178.691010877965484807285607948813674243812260012093000000000122435000000000000003500000$ 7,000,000.0058854707.36452237137.52845884703.3639418639.6232893055.62826410759.09219879764.16813191852.2166633802.63200$ 295,404,421.61Total costos$ 302,404,421.6111121011087897048509730361054898366224501224013317000000000035000000000000000$ 3,500,000.0065477688.13258860118.29652507684.12846041620.38839516036.39633033739.8626502744.93619814832.98413256783.46622980.7680$ 361,634,229.29Total costos$ 365,134,229.29

sku 171valor producto$ 17,080.22FILA A ANALIZARcosto x ordenar$ 3,000,000.00119512351230121811931239122812151178117312051209.9090909091costo de mantener inv unid/ao3416.044EOQ% del costo de mantener en inv unid/ao20%del valor productos,QR,SWW1WW2WW3WW4WW5WW6WW7WW8WW9WW10WW11ANALISIS EOQEOQ(# entero)1457Calculo del EOQ1457.7742250094

Demanda11951235123012181193123912281215117811731205Inventario262.00484.00711.00950.001214.001432.00204.00446.00725.001009.001261.00Pedido14571457145714571457145701457145714571457Costo (A)30000003000000300000030000003000000300000003000000300000030000003000000$ 30,000,000.00Costo (r*V)895003.5281653365.2962428807.2843245241.84147077.4164891775.008696872.9761523555.6242476631.93446788.3964307631.484$ 29,712,750.71Total costos$ 59,712,750.71

MODELO (s,Q)Pedido3000Punto de reorden1486invCalculo de reorden1486.8pedido

Demanda11951235123012181193123912281215117811731205Inventario180557023401122292916904622247106928961691Pedido03000030000030000300000Costo (A)03000000030000000030000000300000000$ 12,000,000.00Costo (r*V)6165959.421947145.087993542.963832801.36810005592.8765773114.361578212.3287675850.8683651751.0369892863.4245776530.404$ 64,293,364.12Total costos$ 76,293,364.12modelo R,SPunto de reorden1486Calculo de reorden1486.8inv

Demanda11951235123012181193123912281215117811731205Inventario291251256268293247258271308313281Pedido11951235123012181193123912281215117811731205Costo (A)30000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.00Costo (r*V)994068.804857427.044874507.264915499.7921000900.892843762.868881339.352925747.9241052141.5521069221.772959908.364$ 10,374,525.63Total costos$ 43,374,525.63ALGORITMO111951235123012181193123912281215117811731205000000000001195123512301218119312391228121511781173120530000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.0000000000000$ 0.00Total costos$ 33,000,000.00

2243002448024320244302351012051235012180123901215011730030000000300000003000000030000000300000000$ 15,000,000.008300986.9208362475.71208307819.00808345395.49208031119.44404116333.02$ 45,464,129.60Total costos$ 60,464,129.60

3246512300243212390239311780120503660003650003621002378030000000030000000030000000030000000$ 12,000,000.008420548.464201734.1208307819.0084232478.51608174593.2924024099.83204116333.020$ 41,477,606.25Total costos$ 53,477,606.25

4368324481218036822443121502378120504878000487500035560030000000003000000000300000000$ 9,000,000.0012581290.0528362475.7124160741.592012577874.0088345395.4924150493.4608123352.6324116333.020$ 62,417,955.97Total costos$ 71,417,955.975487636412411119304794356623511173006071000060330000120530000000000300000000003000000$ 9,000,000.0016656630.54412437816.2048236082.0844075340.492016376514.93612181612.9048031119.4444007019.61200$ 82,002,136.22Total costos$ 91,002,136.226611548803650243212390477135562378120507310000005999000030000000000030000000000$ 6,000,000.0020889109.0616670294.7212468560.68307819.0084232478.516016297945.92412147452.4648123352.6324116333.020$ 103,253,345.94Total costos$ 109,253,345.947734361084878366024671228035562378120508538000000477100030000000000003000000000$ 6,000,000.0025084011.09220865196.75216663462.63212502721.048427380.5484194902.032012147452.4648123352.6324116333.020$ 112,124,812.21Total costos$ 118,124,812.218855873236093487536822443121502378120509753000000035560030000000000000300000000$ 6,000,000.0029234504.55225015690.21220813956.09216653214.512577874.0088345395.4924150493.4608123352.6324116333.020$ 129,030,813.97Total costos$ 135,030,813.9799736850172716053486036212393117801205010931000000002378030000000000000030000000$ 6,000,000.0033258604.38429039790.04424838055.92420677314.33216601973.8412369495.3248174593.2924024099.83204116333.020$ 153,100,259.99Total costos$ 159,100,259.991010909967484447226603347943566235111730012104000000000120530000000000000003000000$ 6,000,000.0037265623.99633046809.65628845075.53624684333.94420608993.45216376514.93612181612.9048031119.4444007019.61200$ 185,047,103.48Total costos$ 191,047,103.4811121141087996498431723859994771355623781205013309000000000030000000000000000$ 3,000,000.0041381957.01637163142.67632961408.55628800666.96424725326.47220492847.95616297945.92412147452.4648123352.6324116333.020$ 226,210,433.68Total costos$ 229,210,433.68

sku 129valor producto$ 30,871.47FILA A ANALIZARcosto x ordenar$ 3,000,000.00117512291182121712211261120712561180120111761209.5454545454costo de mantener inv unid/ao6174.294EOQ% del costo de mantener en inv unid/ao20%del valor productos,QR,SWW1WW2WW3WW4WW5WW6WW7WW8WW9WW10WW11ANALISIS EOQEOQ(# entero)1084Calculo del EOQ1084.159224643

Demanda11751229118212171221126112071256118012011176Inventario-91.00-236.00-334.00-467.00-604.00-781.00-904.00-1076.00-1172.00-1289.00-1381.00Pedido10841084108410841084108410841084108410841084Costo (A)30000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.00Costo (r*V)00000000000$ 0.00Total costos$ 33,000,000.00

MODELO (s,Q)Pedido3000Punto de reorden1513invCalculo de reorden1513.2pedido

Demanda11751229118212171221126112071256118012011176Inventario182559624141197297617155082252107228711695Pedido03000030000030000300000Costo (A)03000000030000000030000000300000000$ 12,000,000.00Costo (r*V)11268086.553679879.22414904745.7167390629.91818374698.94410588914.213136541.35213904510.0886618843.16817726398.07410465428.33$ 118,058,675.57Total costos$ 130,058,675.57modelo R,SPunto de reorden1513Calculo de reorden1513.2inv

Demanda11751229118212171221126112071256118012011176Inventario338284331296292252306257333312337Pedido11751229118212171221126112071256118012011176Costo (A)30000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.00Costo (r*V)2086911.3721753499.4962043691.3141827591.0241802893.8481555922.0881889333.9641586793.5582056039.9021926379.7282080737.078$ 20,609,793.37Total costos$ 53,609,793.37ALGORITMO111751229118212171221126112071256118012011176000000000001175122911821217122112611207125611801201117630000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.0000000000000$ 0.00Total costos$ 33,000,000.00

2240402399024820246302381011761229012170126101256012010030000000300000003000000030000000300000000$ 15,000,000.0014843002.776014812131.306015324597.708015207286.122014700994.01407260969.744$ 82,148,981.67Total costos$ 97,148,981.67

3241111820248212610243611800117603586003699003643002377030000000030000000030000000030000000$ 12,000,000.0014886222.8347298015.508015324597.7087785784.734015040580.1847285666.9207260969.7440$ 74,881,837.63Total costos$ 86,881,837.63

4362823991217037242463125602377117604803000494500035570030000000003000000000300000000$ 9,000,000.0022400338.63214812131.3067514115.798022993070.85615207286.1227754913.264014676296.8387260969.7440$ 112,619,122.56Total costos$ 121,619,122.565484936202438122104844363723811201006024000061050000117630000000000300000000003000000$ 9,000,000.0029939151.60622350944.2815052928.7727538812.974029908280.13622455907.27814700994.0147415327.09400$ 149,362,346.15Total costos$ 158,362,346.156611048813699248212610481335572377117607285000006020000030000000000030000000000$ 6,000,000.0037724936.3430136729.01422838713.50615324597.7087785784.734029716877.02221961963.75814676296.8387260969.7440$ 187,426,868.66Total costos$ 193,426,868.667731760884906368924681207035572377117608492000000481300030000000000003000000000$ 6,000,000.0045177309.19837589101.87230291086.36422776970.56615238157.5927452372.858021961963.75814676296.8387260969.7440$ 202,424,228.79Total costos$ 208,424,228.798857373446162494537242463125602377117609748000000035570030000000000000300000000$ 6,000,000.0052932222.46245344015.13638045999.62830531883.8322993070.85615207286.1227754913.264014676296.8387260969.7440$ 234,746,657.88Total costos$ 240,746,657.8899753852473426125490436432436118001176010928000000002377030000000000000030000000$ 6,000,000.0060217889.38252629682.05645331666.54837817550.7530278737.77622492953.04215040580.1847285666.9207260969.7440$ 278,355,696.40Total costos$ 284,355,696.401010954972585437326610548443637238112010012129000000000117630000000000000003000000$ 6,000,000.0067633216.47660045009.1552746993.64245232877.84437694064.8729908280.13622455907.27814700994.0147415327.09400$ 337,832,670.50Total costos$ 343,832,670.5011121301090197198502728160204813355723771176013305000000000030000000000000000$ 3,000,000.0074894186.2267305978.89460007963.38652493847.58844955034.61437169249.8829716877.02221961963.75814676296.8387260969.7440$ 410,442,367.94Total costos$ 413,442,367.94

sku 162valor producto$ 28,133.73FILA A ANALIZARcosto x ordenar$ 3,500,000.00120512291217117511701206124912231262120911581209.3636363636costo de mantener inv unid/ao5626.746EOQ% del costo de mantener en inv unid/ao20%del valor productos,QR,SWW1WW2WW3WW4WW5WW6WW7WW8WW9WW10WW11ANALISIS EOQEOQ(# entero)1226Calculo del EOQ1226.588299281

Demanda12051229121711751170120612491223126212091158Inventario21.0018.0027.0078.00134.00154.00131.00134.0098.00115.00183.00Pedido12261226122612261226122612261226122612261226Costo (A)35000003500000350000035000003500000350000035000003500000350000035000003500000$ 38,500,000.00Costo (r*V)118161.666101281.428151922.142438886.188753983.964866518.884737103.726753983.964551421.108647075.791029694.518$ 6,150,033.38Total costos$ 44,650,033.38

MODELO (s,Q)Pedido3000Punto de reorden1514invCalculo de reorden1514.4pedido

Demanda12051229121711751170120612491223126212091158Inventario179556623491174300417985492326106428551697Pedido03000030000030000300000Costo (A)03500000035000000035000000350000000$ 14,000,000.00Costo (r*V)10100009.073184738.23613217226.3546605799.80416902744.98410116889.3083089083.55413087811.1965986857.74416064359.839548587.962$ 107,904,108.04Total costos$ 121,904,108.04modelo R,SPunto de reorden1514Calculo de reorden1514.4inv

Demanda12051229121711751170120612491223126212091158Inventario309285297339344308265291252305356Pedido12051229121711751170120612491223126212091158Costo (A)35000003500000350000035000003500000350000035000003500000350000035000003500000$ 38,500,000.00Costo (r*V)1738664.5141603622.611671143.5621907466.8941935600.6241733037.7681491087.691637383.0861417939.9921716157.532003121.576$ 18,855,225.85Total costos$ 57,355,225.85ALGORITMO112051229121711751170120612491223126212091158000000000001205122912171175117012061249122312621209115835000003500000350000035000003500000350000035000003500000350000035000003500000$ 38,500,000.0000000000000$ 0.00Total costos$ 38,500,000.00

2243402392023760247202471011581229011750120601223012090035000000350000003500000035000000350000000$ 17,500,000.0013695499.764013459176.432013369148.496013909316.112013903689.36606515771.868$ 74,852,602.04Total costos$ 92,352,602.04

3244612170237612060248512620115803651003551003734002367035000000035000000035000000035000000$ 14,000,000.0013763020.7166847749.882013369148.4966785855.676013982463.817100953.45206515771.8680$ 68,364,963.90Total costos$ 82,364,963.90

4362123921175036782472122302367115804826000484800036290035000000003500000000350000000$ 10,500,000.0020374447.26613459176.4326611426.55020695171.78813909316.1126881510.358013318507.7826515771.8680$ 101,765,328.16Total costos$ 112,265,328.165479135622345117004943369424711209005996000061490000115835000000000350000000003500000$ 10,500,000.0026957740.08620042469.25213194719.376583292.82027813005.47820785199.72413903689.3666802735.91400$ 136,082,852.01Total costos$ 146,582,852.016599747683551237612060485236292367115807202000006101000035000000000035000000000$ 7,000,000.0033743595.76226828324.92819980575.04613369148.4966785855.676027300971.59220419461.23413318507.7826515771.8680$ 168,262,212.38Total costos$ 175,262,212.387724660174800362524551249036292367115808451000000485200035000000000003500000000$ 7,000,000.0040771401.51633856130.68227008380.820396954.2513813661.437027805.754020419461.23413318507.7826515771.8680$ 183,128,075.32Total costos$ 190,128,075.328846972406023484836782472122302367115809674000000036290035000000000000350000000$ 7,000,000.0047652911.87440737641.0433889891.15827278464.60820695171.78813909316.1126881510.358013318507.7826515771.8680$ 210,879,186.59Total costos$ 217,879,186.5999731850272856110494037342485126201158010936000000002367035000000000000035000000$ 7,000,000.0054753865.32647838594.49240990844.6134379418.0627796125.2421010269.56413982463.817100953.45206515771.8680$ 254,368,306.42Total costos$ 261,368,306.421010940971184947319614949433694247112090012145000000000115835000000000000003500000$ 7,000,000.0061556601.2454641330.40647793580.52441182153.97434598861.15427813005.47820785199.72413903689.3666802735.91400$ 309,077,157.78Total costos$ 316,077,157.7811120981086996528477730761014852362923671158013303000000000035000000000000000$ 3,500,000.0068072373.10861157102.27454309352.39247697925.84241114633.02234328777.34627300971.59220419461.23413318507.7826515771.8680$ 374,234,876.46Total costos$ 377,734,876.46

sku 236valor producto$ 22,400.54FILA A ANALIZARcosto x ordenar$ 3,000,000.00118211991208124111331253125011781224115912661208.4545454546costo de mantener inv unid/ao4480.108EOQ% del costo de mantener en inv unid/ao20%del valor productos,QR,SWW1WW2WW3WW4WW5WW6WW7WW8WW9WW10WW11ANALISIS EOQEOQ(# entero)1272Calculo del EOQ1272.1740814223

Demanda11821199120812411133125312501178122411591266Inventario90.00163.00227.00258.00397.00416.00438.00532.00580.00693.00699.00Pedido12721272127212721272127212721272127212721272Costo (A)30000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.00Costo (r*V)403209.72730257.6041016984.5161155867.8641778602.8761863724.9281962287.3042383417.4562598462.643104714.8443131595.492$ 20,129,125.24Total costos$ 53,129,125.24

MODELO (s,Q)Pedido3000Punto de reorden1519invCalculo de reorden1519.2pedido

Demanda11821199120812411133125312501178122411591266Inventario181861924111170303717845342356113229731707Pedido03000030000030000300000Costo (A)03000000030000000030000000300000000$ 12,000,000.00Costo (r*V)8144836.3442773186.85210801540.3885241726.3613606087.9967992512.6722392377.67210555134.4485071482.25613319361.0847647544.356$ 87,545,790.43Total costos$ 99,545,790.43modelo R,SPunto de reorden1519Calculo de reorden1519.2inv

Demanda11821199120812411133125312501178122411591266Inventario337320311278386266269341295360253Pedido11821199120812411133125312501178122411591266Costo (A)30000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.00Costo (r*V)1509796.3961433634.561393313.5881245470.0241729321.6881191708.7281205149.0521527716.8281321631.861612838.881133467.324$ 15,304,048.93Total costos$ 48,304,048.93ALGORITMO111821199120812411133125312501178122411591266000000000001182119912081241113312531250117812241159126630000003000000300000030000003000000300000030000003000000300000030000003000000$ 33,000,000.0000000000000$ 0.00Total costos$ 33,000,000.00

2238102449023860242802383012661199012410125301178011590030000000300000003000000030000000300000000$ 15,000,000.0010667137.148010971784.492010689537.688010877702.224010676097.36405671816.728$ 59,554,075.64Total costos$ 74,554,075.64

3240712080238612530240212240126603589003627003652002425030000000030000000030000000030000000$ 12,000,000.0010783619.9565411970.464010689537.6885613575.324010761219.4165483652.19205671816.7280$ 54,415,391.77Total costos$ 66,415,391.77

4364824491241036812428117802425126604830000481400036490030000000003000000000300000000$ 9,000,000.0016343433.98410971784.4925559814.028016491277.54810877702.2245277567.224010864261.95671816.7280$ 82,057,658.13Total costos$ 91,057,658.135478135822374113304811356123831159005963000060640000126630000000000300000000003000000$ 9,000,000.0021419396.34816047746.85610635776.3925075962.364021553799.58815953664.58810676097.3645192445.17200$ 106,554,888.67Total costos$ 115,554,888.676603448353627238612530482736492425126607216000006077000030000000000030000000000$ 6,000,000.0027032971.67221661322.1816249351.71610689537.6885613575.324021625481.31616347914.09210864261.95671816.7280$ 135,756,232.62Total costos$ 141,756,232.627728460854877363625031250036492425126608466000000482700030000000000003000000000$ 6,000,000.0032633106.67227261457.1821849486.71616289672.68811213710.3245600135016347914.09210864261.95671816.7280$ 147,731,561.30Total costos$ 153,731,561.308846272636055481436812428117802425126609644000000036490030000000000000300000000$ 6,000,000.0037910673.89632539024.40427127053.9421567239.91216491277.54810877702.2245277567.224010864261.95671816.7280$ 168,326,617.78Total costos$ 174,326,617.7899686848772796038490536522402122401266010868000000002425030000000000000030000000$ 6,000,000.0043394326.08838022676.59632610706.13227050892.10421974929.7416361354.41610761219.4165483652.19205671816.7280$ 201,331,573.41Total costos$ 207,331,573.411010845964684387197606448113561238311590012027000000000126630000000000000003000000$ 6,000,000.0048586771.2643215121.76837803151.30432243337.27627167374.91221553799.58815953664.58810676097.3645192445.17200$ 242,391,763.23Total costos$ 248,391,763.2311121111091297048463733060774827364924251266013293000000000030000000000000000$ 3,000,000.0054258587.98848886938.49643474968.03237915154.00432839191.6427225616.31621625481.31616347914.09210864261.95671816.7280$ 299,109,930.51Total costos$ 302,109,930.51

sku 227valor producto$ 29,776.85FILA A ANALIZARcosto x ordenar$ 3,700,000.00121511741256121512101191121611721210123811941208.2727272727costo de mantener inv unid/ao5955.37EOQ% del costo de mantener en inv unid/ao20%del valor productos,QR,SWW1WW2WW3WW4WW5WW6WW7WW8WW9WW10WW11ANALISIS EOQEOQ(# entero)1225Calculo del EOQ1225.3043402443

Demanda12151174125612151210119112161172121012381194Inventario10.0061.0030.0040.0055.0089.0098.00151.00166.00153.00184.00Pedido12251225122512251225122512251225122512251225Costo (A)37000003700000370000037000003700000370000037000003700000370000037000003700000$ 40,700,000.00Costo (r*V)59553.7363277.57178661.1238214.8327545.35530027.93583626.26899260.87988591.42911171.611095788.08$ 6,175,718.69Total costos$ 46,875,718.69

MODELO (s,Q)Pedido3000Punto de reorden1507invCalculo de reorden1507.2pedido

Demanda12151174125612151210119112161172121012381194Inventario178561123551140293017395232351114129031709Pedido03000030000030000300000Costo (A)03700000037000000037000000370000000$ 14,800,000.00Costo (r*V)10630335.453638731.0714024896.356789121.817449234.110356388.433114658.5114001074.876795077.1717288439.1110177727.33$ 114,265,684.19Total costos$ 129,065,684.19modelo R,SPunto de reorden1507Calculo de reorden1507.2inv

Demanda12151174125612151210119112161172121012381194Inventario292333251292297316291335297269313Pedido12151174125612151210119112161172121012381194Costo (A)37000003700000370000037000003700000370000037000003700000370000037000003700000$ 40,700,000.00Costo (r*V)1738968.041983138.211494797.871738968.041768744.891881896.921733012.671995048.951768744.891601994.531864030.81$ 19,569,345.82Total costos$ 60,269,345.82ALGORITMO112151174125612151210119112161172121012381194000000000001215117412561215121011911216117212101238119437000003700000370000037000003700000370000037000003700000370000037000003700000$ 40,700,000.0000000000000$ 0.00Total costos$ 40,700,000.00

2238902471024010238802448011941174012150119101172012380037000000370000003700000037000000370000000$ 18,500,000.0014227378.93014715719.27014298843.37014221423.56014578745.7607110711.78$ 79,152,822.67Total costos$ 97,652,822.67

3243012560240111910238212100119403645003616003598002432037000000037000000037000000037000000$ 14,800,000.0014471549.17479944.72014298843.377092845.67014185691.347205997.707110711.780$ 71,845,583.68Total costos$ 86,645,583.68

4364524711215035792388117202432119404860000478900036420037000000003700000000370000000$ 11,100,000.0021707323.6514715719.277235774.55021314269.2314221423.566979693.64014483459.847110711.780$ 107,768,375.52Total costos$ 118,868,375.525485536812425121004836362024481238006070000060270000119437000000000370000000003700000$ 11,100,000.0028913321.3521921716.9714441772.257205997.7028800169.3221558439.414578745.767372748.0600$ 144,792,910.81Total costos$ 155,892,910.816604648723616240111910481436422432119407261000006030000037000000000037000000000$ 7,400,000.0036006167.0229014562.6421534617.9214298843.377092845.67028669151.1821689457.5414483459.847110711.780$ 179,899,816.96Total costos$ 187,299,816.967726260884832361724071216036422432119408477000000481400037000000000003700000000$ 7,400,000.0043247896.9436256292.5628776347.8421540573.2914334575.597241729.92021689457.5414483459.847110711.780$ 194,681,045.30Total costos$ 202,081,045.308843472606004478935792388117202432119409649000000036420037000000000000370000000$ 7,400,000.0050227590.5843235986.235756041.4828520266.9321314269.2314221423.566979693.64014483459.847110711.780$ 221,849,443.24Total costos$ 229,249,443.2499644847072145999478935982382121001194010859000000002432037000000000000037000000$ 7,400,000.0057433588.2850441983.942962039.1835726264.6328520266.9321427421.2614185691.347205997.707110711.780$ 265,013,965.00Total costos$ 272,413,965.001010882970884527237602748363620244812380012097000000000119437000000000000003700000$ 7,400,000.0064806336.3457814731.9650334787.2443099012.6935893014.9928800169.3221558439.414578745.767372748.0600$ 324,257,985.76Total costos$ 331,657,985.7611120761090296468431722160304814364224321194013291000000000037000000000000000$ 3,700,000.0071917048.1264925443.7457445499.0250209724.4743003726.7735910881.128669151.1821689457.5414483459.847110711.780$ 395,365,103.56Total costos$ 399,065,103.56

sku 156valor producto$ 39,651.84FILA A ANALIZARcosto x ordenar$ 5,000,000.00119112381189118411821242121812251221119211971207.1818181818costo de mantener inv unid/ao7930.368EOQ% del costo de mantener en inv unid/ao20%del valor productos,QR,SWW1WW2WW3WW4WW5WW6WW7WW8WW9WW10WW11ANALISIS EOQEOQ(# entero)1233Calculo del EOQ1233.7855300748

Demanda11911238118911841182124212181225122111921197Inventario42.0037.0081.00130.00181.00172.00187.00195.00207.00248.00284.00Pedido12331233123312331233123312331233123312331233Costo (A)50000005000000500000050000005000000500000050000005000000500000050000005000000$ 55,000,000.00Costo (r*V)333075.456293423.616642359.8081030947.841435396.6081364023.2961482978.8161546421.761641586.1761966731.2642252224.512$ 13,989,169.15Total costos$ 68,989,169.15

MODELO (s,Q)Pedido3000Punto de reorden1490invCalculo de reorden1490.4pedido

Demanda11911238118911841182124212181225122111921197Inventario180957123821198301617745562331111029181721Pedido03000030000030000300000Costo (A)05000000050000000050000000500000000$ 20,000,000.00Costo (r*V)14346035.7124528240.12818890136.5769500580.86423917989.88814068472.8324409284.60818485687.8088802708.4823140813.82413648163.328$ 153,738,114.05Total costos$ 173,738,114.05modelo R,SPunto de reorden1490Calculo de reorden1490.4inv

Demanda11911238118911841182124212181225122111921197Inventario299252301306308248272265269298293Pedido11911238118911841182124212181225122111921197Costo (A)50000005000000500000050000005000000500000050000005000000500000050000005000000$ 55,000,000.00Costo (r*V)2371180.0321998452.7362387040.7682426692.6082442553.3441966731.2642157060.0962101547.522133268.9922363249.6642323597.824$ 24,671,374.85Total costos$ 79,671,374.85ALGORITMO111911238118911841182124212181225122111921197000000000001191123811891184118212421218122512211192119750000005000000500000050000005000000500000050000005000000500000050000005000000$ 55,000,000.0000000000000$ 0.00Total costos$ 55,000,000.00

2242902373024240244302413011971238011840124201225011920050000000500000005000000050000000500000000$ 25,000,000.0019262863.872018818763.264019223212.032019373889.024019135977.98409492650.496$ 105,307,356.67Total costos$ 130,307,356.67

3242711890242412420244612210119703618003608003664002389050000000050000000050000000050000000$ 20,000,000.0019247003.1369429207.552019223212.0329849517.056019397680.1289682979.32809492650.4960$ 96,322,249.73Total costos$ 116,322,249.73

4361123731184036852443122502389119704802000486700036100050000000005000000000500000000$ 15,000,000.0028636558.84818818763.2649389555.712029223406.0819373889.0249714700.8018945649.1529492650.4960$ 143,595,173.38Total costos$ 158,595,173.385479335552366118204856363824131192005984000060980000119750000000000500000000005000000$ 15,000,000.0038010253.82428192458.2418763250.6889373694.976038509867.00828850678.78419135977.9849452998.65600$ 190,289,180.16Total costos$ 205,289,180.166603547973608242412420483536102389119707226000006053000050000000000050000000000$ 10,000,000.0047859770.8838041975.29628612767.74419223212.0329849517.056038343329.2828628628.4818945649.1529492650.4960$ 238,997,500.42Total costos$ 248,997,500.427725360154826364224601218036102389119708444000000483500050000000000005000000000$ 10,000,000.0057518959.10447701163.5238271955.96828882400.25619508705.289659188.224028628628.4818945649.1529492650.4960$ 258,609,300.48Total costos$ 268,609,300.488847872406051486736852443122502389119709669000000036100050000000000000500000000$ 10,000,000.0067233659.90457415864.3247986656.76838597101.05629223406.0819373889.0249714700.8018945649.1529492650.4960$ 297,983,577.60Total costos$ 307,983,577.6099699846172726088490636642446122101197010890000000002389050000000000000050000000$ 10,000,000.0076916639.23267098843.64857669636.09648280080.38438906385.40829056868.35219397680.1289682979.32809492650.4960$ 356,501,763.07Total costos$ 366,501,763.071010891965384647280609848563638241311920012082000000000119750000000000000005000000$ 10,000,000.0086369637.88876551842.30467122634.75257733079.0448359384.06438509867.00828850678.78419135977.9849452998.65600$ 432,086,100.48Total costos$ 442,086,100.4811120881085096618477729560534835361023891197013279000000000050000000000000000$ 5,000,000.0095862288.38486044492.876615285.24867225729.53657852034.5648002517.50438343329.2828628628.4818945649.1529492650.4960$ 527,012,605.44Total costos$ 532,012,605.44

sku 025valor producto$ 24,750.62FILA A ANALIZARcosto x ordenar$ 3,500,000.00117111841240117812511217123912141205119411551204.3636363636costo de mantener inv unid/ao4950.124EOQ% del costo de mantener en inv unid/ao20%del valor productos,QR,SWW1WW2WW3WW4WW5WW6WW7WW8WW9WW10WW11ANALISIS EOQEOQ(# entero)1305Calculo del EOQ1305.0279048384

Demanda11711184124011781251121712391214120511941155Inventario134.00255.00320.00447.00501.00589.00655.00746.00846.00957.001107.00Pedido13051305130513051305130513051305130513051305Costo (A)35000003500000350000035000003500000350000035000003500000350000035000003500000$ 38,500,000.00Costo (r*V)663316.6161262281.621584039.682212705.4282480012.1242915623.0363242331.223692792.5044187804.9044737268.6685479787.268$ 32,457,963.07Total costos$ 70,957,963.07

MODELO (s,Q)Pedido3000Punto de reorden1501invCalculo de reorden1501.2pedido

Demanda11711184124011781251121712391214120511941155Inventario182964524051227297617595202306110129071752Pedido03000030000030000300000Costo (A)03500000035000000035000000350000000$ 14,000,000.00Costo (r*V)9053776.7963192829.9811905048.226073802.14814731569.0248707268.1162574064.4811414985.9445450086.52414390010.4688672617.248$ 96,166,058.95Total costos$ 110,166,058.95modelo R,SPunto de reorden1501Calculo de reorden1501.2inv

Demanda11711184124011781251121712391214120511941155Inventario330317261323250284262287296307346Pedido11711184124011781251121712391214120511941155Costo (A)35000003500000350000035000003500000350000035000003500000350000035000003500000$ 38,500,000.00Costo (r*V)1633540.921569189.3081291982.3641598890.05212375311405835.2161296932.4881420685.5881465236.7041519688.0681712742.904$ 16,152,254.61Total costos$ 54,652,254.61ALGORITMO111711184124011781251121712391214120511941155000000000001171118412401178125112171239121412051194115535000003500000350000035000003500000350000035000003500000350000035000003500000$ 38,500,000.0000000000000$ 0.00Total costos$ 38,500,000.00

2235502418024680245302399011551184011780121701214011940035000000350000003500000035000000350000000$ 17,500,000.0011657542.02011969399.832012216906.032012142654.172011875347.47605717393.22$ 65,579,242.75Total costos$ 83,079,242.75

3242412400246812170241912050115503595003646003658002349035000000035000000035000000035000000$ 14,000,000.0011999100.5766138153.76012216906.0326024300.908011974349.9565964899.4205717393.220$ 60,035,103.87Total costos$ 74,035,103.87

4360224181178036702453121402349115504773000492100035540035000000003500000000350000000$ 10,500,000.0017830346.64811969399.8325831246.072018166955.0812142654.1726009450.536011627841.2765717393.220$ 89,295,286.84Total costos$ 99,795,286.845485336692429125104852361323991194006024000060690000115535000000000350000000003500000$ 10,500,000.0024022951.77218162004.95612023851.1966192605.124024018001.64817884798.01211875347.4765910448.05600$ 120,090,008.24Total costos$ 130,590,008.246607048863646246812170476835542349115507241000006007000035000000000035000000000$ 7,000,000.0030047252.6824186305.86418048152.10412216906.0326024300.908023602191.23217592740.69611627841.2765717393.220$ 149,063,084.01Total costos$ 156,063,084.017730961254885370724561239035542349115508480000000476800035000000000003500000000$ 7,000,000.0036180456.31630319509.524181355.7418350109.66812157504.5446133203.636017592740.69611627841.2765717393.220$ 162,260,114.60Total costos$ 169,260,114.608852373396099492136702453121402349115509694000000035540035000000000000350000000$ 7,000,000.0042189906.85236328960.03630190806.27624359560.20418166955.0812142654.1726009450.536011627841.2765717393.220$ 186,733,527.65Total costos$ 193,733,527.6599728854473046126487536582419120501155010899000000002349035000000000000035000000$ 7,000,000.0048154806.27242293859.45636155705.69630324459.62424131854.518107553.59211974349.9565964899.4205717393.220$ 222,824,881.74Total costos$ 229,824,881.741010922973884987320606948523613239911940012093000000000115535000000000000003500000$ 7,000,000.0054065254.32848204307.51242066153.75236234907.6830042302.55624018001.64817884798.01211875347.4765910448.05600$ 270,301,521.02Total costos$ 277,301,521.0211120771089396538475722460074768355423491155013248000000000035000000000000000$ 3,500,000.0059782647.54853921700.73247783546.97241952300.935759695.77629735394.86823602191.23217592740.69611627841.2765717393.220$ 327,475,453.22Total costos$ 330,975,453.22

sku 105valor producto$ 32,744.44FILA A ANALIZARcosto x ordenar$ 4,500,000.00129411951196119412021196120911391203120212171204.2727272727costo de mantener inv unid/ao6548.888EOQ% del costo de mantener en inv unid/ao20%del valor productos,QR,SWW1WW2WW3WW4WW5WW6WW7WW8WW9WW10WW11ANALISIS EOQEOQ(# entero)1286Calculo del EOQ1286.4706980568

Demanda12941195119611941202119612091139120312021217Inventario-8.0083.00173.00265.00349.00439.00516.00663.00746.00830.00899.00Pedido12861286128612861286128612861286128612861286Costo (A)45000004500000450000045000004500000450000045000004500000450000045000004500000$ 49,500,000.00Costo (r*V)0543557.7041132957.6241735455.322285561.9122874961.8323379226.2084341912.7444885470.4485435577.045887450.312$ 32,502,131.14Total costos$ 82,002,131.14

MODELO (s,Q)Pedido3000Punto de reorden1552invCalculo de reorden1552.8pedido

Demanda12941195119611941202119612091139120312021217Inventario170651123151121291917235142375117229701753Pedido03000030000030000300000Costo (A)04500000045000000045000000450000000$ 18,000,000.00Costo (r*V)11172402.9283346481.76815160675.727341303.44819116204.07211283734.0243366128.432155536097675296.73619450197.3611480200.664$ 124,946,234.15Total costos$ 142,946,234.15modelo R,SPunto de reorden1552Calculo de reorden1552.8inv

Demanda12941195119611941202119612091139120312021217Inventario258357356358350356343413349350335Pedido12941195119611941202119612091139120312021217Costo (A)45000004500000450000045000004500000450000045000004500000450000045000004500000$ 49,500,000.00Costo (r*V)1689613.1042337953.0162331404.1282344501.9042292110.82331404.1282246268.5842704690.7442285561.9122292110.82193877.48$ 25,049,496.60Total costos$ 74,549,496.60ALGORITMO112941195119611941202119612091139120312021217000000000001294119511961194120211961209113912031202121745000004500000450000045000004500000450000045000004500000450000045000004500000$ 49,500,000.0000000000000$ 0.00Total costos$ 49,500,000.00

2248902390023980234802405012171195011940119601139012020045000000450000004500000045000000450000000$ 22,500,000.0016300182.232015651842.32015704233.424015376789.024015750075.6407969996.696$ 86,753,119.34Total costos$ 109,253,119.34

3239111960239811960234212030121703685003592003551002419045000000045000000045000000045000000$ 18,000,000.0015658391.2087832470.048015704233.4247832470.048015337495.6967878312.26407969996.6960$ 78,213,369.38Total costos$ 96,213,369.38

4358523901194035442348113902419121704879000474600036220045000000004500000000450000000$ 13,500,000.0023477763.4815651842.327819372.272023209259.07215376789.0247459183.432015841760.0727969996.6960$ 116,805,966.37Total costos$ 130,305,966.375478735922396120204753354424051202006081000059490000121745000000000450000000004500000$ 13,500,000.0031349526.85623523605.69615691135.6487871763.376031126864.66423209259.07215750075.647871763.37600$ 156,393,994.33Total costos$ 169,893,994.336598347883592239811960476136222419121707277000005970000045000000000045000000000$ 9,000,000.0039181996.90431356075.74423523605.69615704233.4247832470.048031179255.76823720072.33615841760.0727969996.6960$ 196,309,466.69Total costos$ 205,309,466.697719259974801360724051209036222419121708486000000476100045000000000004500000000$ 9,000,000.0047099602.49639273681.33631441211.28823621839.01615750075.647917605.592023720072.33615841760.0727969996.6960$ 212,635,844.47Total costos$ 221,635,844.478833171365940474635442348113902419121709625000000036220045000000000000450000000$ 9,000,000.0054558785.92846732864.76838900394.7231081022.44823209259.07215376789.0247459183.432015841760.0727969996.6960$ 241,130,056.16Total costos$ 250,130,056.1699534833971435949474735512342120301217010828000000002419045000000000000045000000$ 9,000,000.0062437098.19254611177.03246778706.98438959334.71231087571.33623255101.28815337495.6967878312.26407969996.6960$ 288,314,794.20Total costos$ 297,314,794.201010736954183457151594947533544240512020012030000000000121745000000000000004500000$ 9,000,000.0070308861.56862482940.40854650470.3646831098.08838959334.71231126864.66423209259.07215750075.647871763.37600$ 351,190,667.89Total costos$ 360,190,667.8911119531075895628368716659704761362224191217013247000000000045000000000000000$ 4,500,000.0078278858.26470452937.10462620467.05654801094.78446929331.40839096861.3631179255.76823720072.33615841760.0727969996.6960$ 430,890,634.85Total costos$ 435,390,634.85

sku 111valor producto$ 27,136.69FILA A ANALIZARcosto x ordenar$ 3,500,000.00122611941187122211761242122711751206119311931203.7272727273costo de mantener inv unid/ao5427.338EOQ% del costo de mantener en inv unid/ao20%del valor productos,QR,SWW1WW2WW3WW4WW5WW6WW7WW8WW9WW10WW11ANALISIS EOQEOQ(# entero)1246Calculo del EOQ1246.0045713055

Demanda12261194118712221176124212271175120611931193Inventario20.0072.00131.00155.00225.00229.00248.00319.00359.00412.00465.00Pedido12461246124612461246124612461246124612461246Costo (A)35000003500000350000035000003500000350000035000003500000350000035000003500000$ 38,500,000.00Costo (r*V)108546.76390768.336710981.278841237.391221151.051242860.4021345979.8241731320.8221948414.3422236063.2562523712.17$ 14,301,035.63Total costos$ 52,801,035.63

MODELO (s,Q)Pedido3000Punto de reorden1490invCalculo de reorden1490.4pedido

Demanda12261194118712221176124212271175120611931193Inventario177458023931171299517535262351114529521759Pedido03000030000030000300000Costo (A)03500000035000000035000000350000000$ 14,000,000.00Costo (r*V)9628097.6123147856.0412987619.8346355412.79816254877.319514123.5142854779.78812759671.6386214302.0116021501.7769546687.542$ 105,284,929.86Total costos$ 119,284,929.86modelo R,SPunto de reorden1490Calculo de reorden1490.4inv

Demanda12261194118712221176124212271175120611931193Inventario264296303268314248263315284297297Pedido12261194118712221176124212271175120611931193Costo (A)35000003500000350000035000003500000350000035000003500000350000035000003500000$ 38,500,000.00Costo (r*V)1432817.2321606492.0481644483.4141454526.5841704184.1321345979.8241427389.8941709611.471541363.9921611919.3861611919.386$ 17,090,687.36Total costos$ 55,590,687.36ALGORITMO112261194118712221176124212271175120611931193000000000001226119411871222117612421227117512061193119335000003500000350000035000003500000350000035000003500000350000035000003500000$ 38,500,000.0000000000000$ 0.00Total costos$ 38,500,000.00

2242002409024180240202399011931194012220124201175011930035000000350000003500000035000000350000000$ 17,500,000.0013134157.96013074457.242013123303.284013036465.876013020183.86206474814.234$ 71,863,382.46Total costos$ 89,363,382.46

3238111870241812420238112060119303607003640003608002386035000000035000000035000000035000000$ 14,000,000.0012922491.7786442250.206013123303.2846740753.796012922491.7786545369.62806474814.2340$ 65,171,474.70Total costos$ 79,171,474.70

4360324091222036442402117502386119304829000482000035920035000000003500000000350000000$ 10,500,000.0019554698.81413074457.2426632207.036019777219.67213036465.8766377122.15012949628.4686474814.2340$ 97,876,613.49Total costos$ 108,376,613.495477935852398117604801357423991193006005000060430000119335000000000350000000003500000$ 10,500,000.0025937248.30219457006.7313014756.5246382549.488026056649.73819397306.01213020183.8626474814.23400$ 129,740,514.89Total costos$ 140,240,514.896602148273640241812420476735922386119307247000005994000035000000000035000000000$ 7,000,000.0032678002.09826197760.52619755510.3213123303.2846740753.796025872120.24619494998.09612949628.4686474814.2340$ 163,286,891.07Total costos$ 170,286,891.077724860544867364524691227035922386119308474000000476700035000000000003500000000$ 7,000,000.0039337345.82432857104.25226414854.04619782647.0113400097.5226659343.726019494998.09612949628.4686474814.2340$ 177,370,833.18Total costos$ 184,370,833.188842372296042482036442402117502386119309649000000035920035000000000000350000000$ 7,000,000.0045714467.97439234226.40232791976.19626159769.1619777219.67213036465.8766377122.15012949628.4686474814.2340$ 202,515,690.13Total costos$ 209,515,690.1399629843572486026485036082381120601193010855000000002386035000000000000035000000$ 7,000,000.0052259837.60245779596.0339337345.82432705138.78826322589.319581835.50412922491.7786545369.62806474814.2340$ 241,929,018.69Total costos$ 248,929,018.691010822962884417219604348013574239911930012048000000000119335000000000000003500000$ 7,000,000.0058734651.83652254410.26445812160.05839179953.02232797403.53426056649.73819397306.01213020183.8626474814.23400$ 293,727,532.56Total costos$ 300,727,532.5611120151082196348412723659944767359223861193013241000000000035000000000000000$ 3,500,000.0065209466.0758729224.49852286974.29245654767.25639272217.76832531463.97225872120.24619494998.09612949628.4686474814.2340$ 358,475,674.90Total costos$ 361,975,674.90