Grfico1

Hoja1SemanaDemandaSemanaDemandaIndiceDemanda estacionariapronosticoAprox pronsticoErrorcuadrado erroralfa10.039744071611200PromediosIndice estacional112000.850168350214111450alfa20.0394718155218501262.50.8501683502218501.254208754214751448.4605991967144826.5394008033704.3397949993alfa30.1487732303313501862.51.2542087542313500.917508417514711452.4089515833145218.5910484167345.6270812323alfa40.1158741367415001362.50.9175084175415000.978114478115341454.5631732696145579.43682673046310.2094410014ECM4616.1212367847513201452.50.9781144781513200.850168350215531457.7203161962145895.27968380389078.218145757861950Promedio total1485619501.254208754215551461.4811782933146193.51882170678745.770013411171400714000.917508417515261475.3942754885147550.60572451152560.939353334281300813000.978114478113291481.25817013011481-152.258170130123182.55037135991280912800.850168350215061475.2068105198147530.7931894802948.22051836291018001018001.254208754214351476.42227361271476-41.42227361271715.80475124521114001114000.917508417515261470.2597481627147055.74025183733106.97567488381215201215200.978114478115541476.7186017257147777.28139827435972.41451922961312501312500.850168350214701479.79007914951480-9.790079149595.84564975341418501418501.254208754214751479.40364695191479-4.403646951919.39210647671513001513000.917508417514171478.74850216991479-61.74850216993812.87752022971614901614900.978114478115231471.5934477864147251.40655221362642.63361049391473.636553476512531473.622557729318481479.241366615613571477.55013764661445

Hoja2PASO 1Obtencin de la InformacinProveedoresCOCASECNAOTE11856.57.4128507.67.422907.55.81369567.433107.67.41287075.642456.57113857.66.453257.557112357.67.662356.856.2125856.66.2

3422542.2554.7616512250057.7654.768410056.2533.641875530253654.769610057.7654.761656369004931.366002542.254912961822557.7640.9610562557.00254912622522557.7657.765522546.922538.4415838222543.5638.44435300302.435279.6932538100301.84278.04N(Co)659.772688128317.390658411916.721243972930537.486799014717.373543104416.6745314777

PASO 2Normalizacin de la Informacin

COCASECNAOTE10.28039960330.37376388210.44255080610.42079428750.43744675190.443790580320.4395453240.43126601780.34686414540.44846519590.34535269890.4437905803N(U)30.46985879470.43701623140.44255080610.42144922030.4029114820.335841520240.37134001510.37376388210.4186291410.37282046410.43744675190.383818880250.49259389760.43414112460.4186291410.36790846850.43744675190.455784920360.35618327980.39388962960.37078581060.41211642870.37988796880.3718245402

PASO 3Ponderacin de los Criterios NormalizadosMINMAXMAXMINMAXMAXCOCASECNAOTECriterioPonderacin Criterios0.04262073970.06413788220.07594171830.06396073170.07506586260.0805036113CO0.1520.06681088930.07400524870.05952188730.06816670980.05926252310.0805036113CA0.17160.07141853680.07499198530.07594171830.06406028150.06913961030.0609216518SE0.17160.05644368230.06413788220.07183676060.05666871050.07506586260.0696247449CN0.1520.07487427240.0744986170.07183676060.05592208720.07506586260.0826793845AO0.17160.05413985850.06759146040.06362684510.06264169720.06518877540.0674489716TE0.1814PASO 4Indice de Valoracin de los ProveedoresSUMA MAXSUMA MINVALORACIONESP10.29564907440.10658147140.189067603P20.27329327040.1349775990.1383156713P30.28099496570.13547881830.1455161474P40.28066525030.11311239280.1675528574P50.30408062470.13079635970.1732842651P60.26385605260.11678155570.1470744969AHORA ORDENAMOS LOS PROVEEDORESP10.189067603P50.1732842651P40.1675528574P60.1470744969P30.1455161474P20.1383156713

Hoja30.66380566435703.349282296675.5205222592tB50.1309504430.027097811119.5793946598