Juan Chic Hero Sept 2013
5
tiempo entre tiempo de Demanda Existencia Aleatorio 1 Aleatorio 2 Aleatorio 3 llegadas llegada (vasos) 120 0.39072899 0.89893987 2.477460482 2.47746048 3 117 0.21930146 0.35805931 0.09046692 1.237830958 3.71529144 1 116 0.06253593 0.85302759 0.322884224 4.03817566 3 113 0.80834328 0.60372626 8.260246993 12.2984227 2 111 0.62384837 0.20812691 4.888814668 17.1872373 1 110 0.91791185 0.66462038 12.49980802 29.6870453 2 108 0.31981439 0.38944112 1.926947838 31.6139932 1 107 0.84739401 0.1902084 9.399479484 41.0134727 1 106 0.02293252 0.36328607 0.11599782 41.1294705 1 105 0.34706447 0.75248505 2.13138441 43.2608549 2 103 0.75336418 0.02779984 6.999212123 50.260067 1 102 0.34538869 0.76001251 2.118568231 52.3786353 2 100 0.74607207 0.90804274 6.853524004 59.2321593 3 97 0.25249949 0.33075949 1.455101477 60.6872607 1 96 0.26425806 0.00139156 1.534379253 62.22164 1 95 0.30556297 0.74020093 1.823268968 64.044909 2 93 0.55946193 0.79813115 4.09879206 68.143701 2 91 0.44507287 0.60552927 2.944592341 71.0882934 2 89 0.55539873 0.25436269 4.052887056 75.1411804 1 88 0.45289319 0.92181966 3.015556169 78.1567366 3 85 0.19345764 0.18955924 1.074994323 79.2317309 1 84 0.71851682 0.47712981 6.338412871 85.5701438 1 83 0.96319722 0.38515914 16.51090914 102.081053 1 82 0.75703814 0.52965194 7.074253951 109.155307 2 80 0.7902341 0.60403572 7.808815703 116.964123 2 78 0.52404984 0.07761469 3.712210697 120.676333 1 77 0.13003536 0.07230444 0.696513545 121.372847 1 76 0.81755782 0.69281047 8.506609991 129.879457 2 74 0.42748101 0.37034486 2.788546898 132.668004 1 73 0.95878502 0.48543088 15.94476733 148.612771 1 72 0.3561542 0.8492429 2.201480118 150.814251 3 69 0.14321834 0.80430453 0.77286085 151.587112 3 66 0.22004081 0.2006389 1.242568431 152.82968 1 65 0.67651597 0.98490854 5.643027589 158.472708 3 62 0.56801653 0.59629585 4.196839767 162.669548 2 60 0.06952043 0.87752127 0.360275802 163.029824 3 57 0.85061606 0.93622961 9.506177675 172.536001 3 54 0.87059406 0.41594248 10.22400481 182.760006 1 53 0.60824911 0.15793368 4.685645609 187.445652 1 52 0.32362766 0.40455391 1.955057807 189.400709 1 51 0.05365587 0.79626143 0.275744998 189.676454 2 49 0.88625182 0.56826336 10.86884112 200.545296 2 47 0.72121543 0.824644 6.386579679 206.931875 3 44
-
Upload
michael-brian-diaz-barrios -
Category
Documents
-
view
217 -
download
4
description
ejercicio de excel de simulación
Transcript of Juan Chic Hero Sept 2013
Hoja1tiempo entretiempo deDemandaExistencia (vasos)Tiempo delAleatorio 1Aleatorio 2Aleatorio 3llegadasllegada (vasos)120Motorizado0.81235344620.17148212578.3659755928.3659755921119Tria(13;15;17)0.07418319850.47527257610.28122153840.38539451218.7513701042111814.49992410040.8935264140.134856662511.199291717919.950661822111170.6042983380.03943398944.635473652624.586135474711160.91122301490.093972762412.10813919936.694274673711150.15420577390.81401706960.837395902837.531670576531120.1451887920.94577487940.78437321938.316043795431090.03414835820.69422836350.173725182638.48976897821070.33369204090.64297191332.030016571640.519785549621050.90938703880.498244642112.005790085352.525575634911040.62055295690.62088089964.845201179257.370776814221020.99469917310.479597504826.199462284283.570239098411010.84432689080.63513388739.299984620892.87022371922990.39747397360.10126835342.533122086495.40334580561980.72825447760.29253900946.5144461504101.9177919561970.33239042420.21877917162.0202587186103.93805067461960.29047895780.96148533981.7158256252105.65387629983930.46116632360.49462118143.0917416687108.74561796851920.96992888810.934032021917.5209515243126.26656949283890.23446370940.29320686931.3358932865127.60246277921880.74772432520.56419930386.8861642091134.48862698832860.3154858360.37503975841.89522971136.38385669831850.57639194830.17331860394.2947332882140.67858998651840.83656449750.08717082279.0566842316149.73527421811830.72780289060.0577369656.506144041156.24141825921820.29836274040.61993166171.7716936633158.01311192242800.7225690280.76555040426.4109156321164.42402755452780.96931673210.802352603417.4201889599181.84421651443750.41026336730.25118665842.6403961347184.48461264911740.02666641950.19772864420.1351420925184.61975474161730.55973981720.32673276734.1019470115188.72170175311720.45658974050.44877377613.0494535099191.7711552631710.17779191690.38338084590.9788088673192.74996413031700.45280891470.20613199273.0147860215195.76475015191690.62621346580.48118464524.9203520432200.68510219511680.36425420810.06126117072.2647824687202.94988466381670.01442475430.54795513910.0726490124203.02253367622650.77436007920.84881091517.4440741066210.46660778283620.75635841370.90546331997.0602852109217.52689299373590.35014839810.5932770032.1550562345219.68194922832570.68174447990.4570440355.724503482225.40645271031560.58887046850.11896827464.4442347623229.85068747261550.96364202940.254622498916.571709132246.42239660461540.22258958480.80836798461.2589343161247.68133092073510.94640615580.319443407914.6316053248262.31293624551500.88107385390.942477656310.6462629976272.95919924313470.42190004710.74174897982.7400424822275.69924172542450.76131269520.07404282087.1630046595282.86224638491440.03024153750.09922600110.1535412313283.01578761621430.60992203730.60113000484.7070432771287.72283089332410.82547660390.1432961668.7284823569296.45131325021400.17248512280.10471319340.9466409668297.3979542171390.51878862210.73326351913.6572432511301.0551974682370.710425050.39770491956.1967056045307.25190307251360.27717304510.94432822271.6229271432308.87483021573330.12730585470.60518411310.6808506678309.55568088352310.61911515580.62496898124.826290979314.38197186252290.58518595070.34317860784.3996246655318.7815965281280.93954330020.995110180314.0291393768332.81073590483250.1859406710.45093170341.0286101492333.8393460541240.86271635160.93837569989.9285303353343.76787638943210.14884552870.76520242860.8058082476344.5736846372190.5443653960.15885160813.9303204885348.50400512541180.71933107910.87690227336.3528976079354.85690273333150.81950056120.53080034448.5601380509363.41704078432130.34935822710.2409969452.1489803015365.56602108571120.30159844250.03975413431.7948052218367.36082630751110.82844538040.13187614968.8142679061376.17509421361100.57589482010.41257696244.2888689441380.4639631577190.02628712620.09569672530.1331940477380.5971572054180.32121562880.33911292671.9372588499382.5344160553170.6250731910.19390296734.905122241387.4395382962160.44318801080.13762172452.9276381893390.3671764856150.83825842740.74342843989.1087772406399.4759537262230.76032051660.42939987877.1422636704406.6182173966120.2699747020.91784985891.5733804533408.19159784993-10.3912235040.38781966152.4815204012410.67311825111-20.22851123830.77801225411.2971658704411.97028412152-40.57231852290.75919146724.2468828644416.21716698592-60.42392209250.92025548142.7575618566418.97472884253-90.05156957330.03935789920.2647342157419.23946305821-100.2441413050.37464455361.399504158420.63896721621-110.43695938470.65769893322.8720175629423.51098477922-130.07599786180.2259015380.3952044665423.90618924561-140.97019426660.013918554517.5652725411441.47146178671-150.57527500030.05576935884.2815668951445.75302868181-160.33989243770.13009824612.0767624204447.82979110221-170.68657022430.53718411335.8008997253453.63069082752-190.06973410480.78301914640.3614241245453.9921149522-210.68747743570.08389626675.815393033459.8075079851-220.10598497090.51884874590.5601634642460.36767144922-240.07384577950.80262301850.3835725667460.75124401593-270.79416537610.30279218927.9034111449468.65465516081-280.0177560340.19238001860.0895778181468.74423297891-290.19683643480.31909232361.0959844655469.84021744441-300.59404148970.16243764454.5075215798474.34773902421-310.2905603470.92733816651.7163992082476.06413823243-340.95582064860.761974595315.5974888107491.66162704312-360.83370491410.72992197538.9699572137500.63158425682-380.00321350730.12153476880.0160934085500.64767766531-390.99876404250.701943819833.4795465204534.12722418572-410.86657777840.791654021510.0711829049544.19840709062-430.80614451750.36672390828.2032116647552.40161875541-440.06058975540.40408191050.3125150001552.71413375541-450.17848322060.24913185340.983014582553.69714833751-460.55343005420.35645361954.0307961865557.7279445241-470.82475157720.52141345978.7077537647566.43569828872-490.16179345490.30568873220.8824536752567.31815196381-500.92085942480.297277037112.6826478739580.00079983771-510.18384281070.28447679861.0157415429581.01654138061-520.4477268360.21065645462.9685624641583.98510384471-530.41240407730.92297086012.6585788681586.64368271283-560.96297640310.725601542716.4809990831603.12468179592-580.16280785470.94337854780.8885083531604.0131901493-610.59687271370.41416693814.5425145999608.55570474891-620.79207935630.65890520997.8529939644616.40869871332-640.41503911920.20698976092.6810515223619.08975023561-650.82473351720.17438041338.7072385223627.79698875791-660.9700545670.794616674917.541892266645.3388810242-680.30053292540.80083242931.7871827791647.12606380313-710.54766040360.11239285643.9666103093651.09267411251-720.52773092290.26615167113.7510318858654.84370599831-730.30415912190.15015079161.8131713408656.6568773391-740.11038218420.64010186310.5848166449657.2416939842-760.35883315760.04901615682.2223278569659.46402184091-770.40553870720.62256657662.6004983692662.06452021012-790.85509459840.04498181319.6583707616671.72289097181-800.80793177010.60432608378.2495230301679.97241400192-820.40176272690.60506762082.56883913682.54125313192-840.98892335690.597946081222.5145830573705.05583618922-860.89905389530.515904873511.4658426051716.52167879422-880.02965555120.9789618820.1505208434716.67219963763-910.22637167730.42959014341.2833186199717.95551825751-920.11558022630.4498112780.6141173594718.5696356171-930.97986852970.907508778319.5273550133738.09699063023-960.68002700490.88120044745.6975933856743.79458401583-990.37618764870.11138983872.3595283744746.15411239021-1000.53449762110.36388297043.8231903594749.97730274961-1010.85204450720.78941538219.5542188732759.53152162282-1030.27913101960.81310236821.6364893871761.16801100993-1060.15215949080.63752336250.825313698761.99332470792-1080.26613085580.69891409961.5471227193763.54044742722-1100.0295705620.1997146290.1500829293763.69053035651-1110.42160672910.00606426062.7375062113766.42803656781-1120.25135585670.60264099461.4474575873767.87549415512-1140.50774102370.53166716433.5437516323771.41924578742-1160.35567601270.70702386612.1977679677773.61701375512-1180.18154565270.27109007551.0016882991774.61870205421-1190.47264269980.526921753.1993848559777.81808691012-1210.57086254450.42444358884.229890012782.0479769221-122
Hoja2
Hoja3
