Interv.nejistoty = 8dnu (dod.lhůta=7+perioda obj.=1) 99 =min.objednavka N= 21763 N1= 15963 1=indikace neuspokojene spotreby N2= 4400 2=indikace uskutecnene dodavky N3= 1400 3=indik.dod.cyklu s neuspok.spotr. T = 100 dnu 11 = celkovy počet realizovanych dod.cyklu (za období 100 dnů) = k 2 = z toho: počet vyskytu dodacich cyklu s s neusp. spotr. 2 = počet vyskytu neuspok.spotreby (celkem) = m 2 = % poctu vyskytu neusp.spotr.(z celkoveho poctu 100 proverovanych pripadu) 53.21 = prumerna vyse zasoby (prumer poc.zasoby za 100 dnu) = z -7 = prumerna velikost neuspokojene spotreby (pouze z pripadu kdy nastalo chybeni zasoby) -0.14 = prumerna velikost neuspokojené spotreby (za 100dnů) c1= 3 N1=c1*T*z N1= 15963 c2= 400 N2=c2*k N2= 4400 c3= 700 N3=c3*m N3= 1400 N=N1+N2+N3 --> min N= 21763 Potř. Neusp. Náhod.čísla Posunuté dodávky P.C. P10 P1 S1 P.Z. Pl.do Sk.do Poj.z dodáv spotř. 1 2 3 posun dod. =0 = -1 = +1 1 6 8 8 25 0 0 10 0 0 0 0 0.099909717 -1 0 0 0 2 6 2 2 17 0 0 10 0 0 0 0 0.650514879 0 0 0 0 3 6 6 7 15 20 0 10 0 0 0 0 0.853293933 1 0 0 0 4 6 5 0 8 0 20 10 0 0 1 1 0.241462976 -1 0 0 20 5 6 1 3 28 20 0 10 0 0 0 0 0.765282938 1 0 0 0 6 6 10 15 25 0 20 10 0 0 1 1 0.677161086 1 0 0 20 7 6 12 12 30 0 0 10 0 0 0 0 0.479738471 0 0 0 0 8 6 5 0 18 0 0 10 -15 0 0 0 0 0.095174617 -1 0 0 0 9 6 10 9 18 0 0 10 -5 0 0 0 0 0.322862219 -1 0 0 0 10 6 2 5 9 0 0 10 7 0 0 0 0 0.04950286 -1 0 0 0 11 12 12 13 4 99 0 10 -60 -9 1 0 0 0.690067153 1 0 0 0 12 12 10 8 0 0 99 10 -69 0 0 1 0 0.071901079 -1 0 0 99 13 12 10 14 91 0 0 10 -39 0 0 0 0 0.671592662 1 0 0 0 14 12 14 9 77 0 0 10 -42 0 0 0 0 0.38610055 0 0 0 0 15 12 5 6 68 0 0 10 -32 0 0 0 0 0.686932299 1 0 0 0 16 12 11 10 62 0 0 10 -27 0 0 0 0 0.309229933 -1 0 0 0 17 12 13 5 52 0 0 10 -14 0 0 0 0 0.632378201 0 0 0 0 18 12 13 14 47 0 0 10 -6 0 0 0 0 0.752525674 1 0 0 0 19 12 11 10 33 0 0 10 96 0 0 0 0 0.785971213 1 0 0 0 20 12 2 6 23 99 99 10 -91 0 0 1 0 0.556144547 0 99 0 0 21 5 4 5 116 0 0 10 -81 0 0 0 0 0.448084609 0 0 0 0 22 5 6 6 111 0 0 10 -82 0 0 0 0 0.851138801 1 0 0 0 23 5 7 7 105 0 0 10 -86 0 0 0 0 0.924929768 1 0 0 0 24 5 1 3 98 0 0 10 -83 0 0 0 0 0.701164959 1 0 0 0 25 5 0 0 95 0 0 10 -85 0 0 0 0 0.245684331 -1 0 0 0 26 5 5 4 95 0 0 10 -77 0 0 0 0 0.740356213 1 0 0 0 27 5 3 3 91 0 0 10 -77 0 0 0 0 0.168486007 -1 0 0 0 28 5 8 7 88 0 0 10 -73 0 0 0 0 0.955977253 1 0 0 0 29 5 4 4 81 0 0 10 -67 0 0 0 0 0.786544062 1 0 0 0 30 5 2 2 77 0 0 10 -64 0 0 0 0 0.80451793 1 0 0 0 31 9 8 8 75 0 0 10 -52 0 0 0 0 0.933415949 1 0 0 0 32 9 12 11 67 0 0 10 -42 0 0 0 0 0.157151823 -1 0 0 0 33 9 11 11 56 0 0 10 -36 0 0 0 0 0.857622647 1 0 0 0 34 9 9 10 45 0 0 10 -29 0 0 0 0 0.258941734 -1 0 0 0 35 9 10 12 35 0 0 10 -17 0 0 0 0 0.578777955 0 0 0 0 36 9 12 12 23 0 0 10 -7 0 0 0 0 0.805461955 1 0 0 0 37 9 15 13 11 0 99 10 2 0 0 1 0 0.329945788 -1 0 99 0 38 9 7 7 97 99 0 10 -87 0 0 0 0 0.263231956 -1 0 0 0 39 9 8 8 90 0 0 10 -75 0 0 0 0 0.506777623 0 0 0 0 40 9 8 8 82 0 0 10 -61 0 0 0 0 0.214890023 -1 0 0 0 41 10 8 8 74 0 0 10 -53 0 0 0 0 0.722597816 1 0 0 0 42 10 7 7 66 0 0 10 -43 0 0 0 0 0.769861621 1 0 0 0 43 10 12 11 59 0 0 10 -32 0 0 0 0 0.185821039 -1 0 0 0 44 10 11 12 48 0 0 10 -24 0 0 0 0 0.33817277 0 0 0 0 45 10 10 10 36 0 0 10 -118 0 0 0 0 0.410303252 0 0 0 0 46 10 10 9 26 0 0 10 -7 0 0 0 0 0.126681757 -1 0 0 0 47 10 9 9 17 0 0 10 4 0 0 0 0 0.471024812 0 0 0 0 48 10 8 7 8 99 99 10 -85 0 0 1 0 0.473899556 0 99 0 0 49 10 13 12 100 0 0 10 -75 0 0 0 0 0.319756693 -1 0 0 0 50 10 7 8 88 0 0 10 -66 0 0 0 0 0.41340942 0 0 0 0 51 8 9 10 80 0 0 10 -61 0 0 0 0 0.455461283 0 0 0 0 52 8 7 7 70 0 0 10 -49 0 0 0 0 0.331240441 0 0 0 0 53 8 9 9 63 0 0 10 -44 0 0 0 0 0.700342057 1 0 0 0 54 8 10 10 54 0 0 10 -36 0 0 0 0 0.550236309 0 0 0 0 55 8 6 7 44 0 0 10 -29 0 0 0 0 0.183571216 -1 0 0 0 56 8 8 6 37 0 0 10 -21 0 0 0 0 0.172836956 -1 0 0 0 57 8 9 8 31 0 0 10 -12 0 0 0 0 0.238984517 -1 0 0 0 58 8 8 9 23 0 0 10 -5 0 0 0 0 0.671260476 1 0 0 0 59 8 8 8 14 0 99 10 4 0 0 1 0 0.184437559 -1 0 99 0 60 8 8 7 105 99 0 10 -86 0 0 0 0 0.040242493 -1 0 0 0 61 13 14 14 98 0 0 10 -73 0 0 0 0 0.190078762 -1 0 0 0 62 13 12 13 84 0 0 10 -60 0 0 0 0 0.058270405 -1 0 0 0 63 13 12 12 71 0 0 10 -46 0 0 0 0 0.796991077 1 0 0 0 64 13 13 14 59 0 0 10 -34 0 0 0 0 0.343327933 0 0 0 0 65 13 13 13 45 0 0 10 -23 0 0 0 0 0.911488417 1 0 0 0 66 13 14 13 32 0 0 10 -10 0 0 0 0 0.808435758 1 0 0 0 67 13 13 13 19 0 0 10 -96 0 0 0 0 0.985978962 1 0 0 0 68 13 11 11 6 0 0 10 15 -5 1 0 0 0.768112825 1 0 0 0 69 13 13 15 0 99 99 10 -70 0 0 1 0 0.374761159 0 99 0 0 70 13 12 12 84 0 0 10 -56 0 0 0 0 0.912214109 1 0 0 0 71 11 12 12 72 0 0 10 -47 0 0 0 0 0.483841139 0 0 0 0 72 11 11 10 60 0 0 10 -35 0 0 0 0 0.012837282 -1 0 0 0 73 11 11 10 50 0 0 10 -25 0 0 0 0 0.534439302 0 0 0 0 74 11 10 10 40 0 0 10 -14 0 0 0 0 0.633299986 0 0 0 0 75 11 11 11 30 0 0 10 -3 0 0 0 0 0.034436652 -1 0 0 0 76 11 12 13 19 0 99 10 3 0 0 1 0 0.529675789 0 0 99 0 77 11 11 14 105 99 0 10 -84 0 0 0 0 0.223311997 -1 0 0 0 78 11 11 8 91 0 0 10 -73 0 0 0 0 0.782176297 1 0 0 0 79 11 10 9 83 0 0 10 -61 0 0 0 0 0.884371148 1 0 0 0 80 11 10 9 74 0 0 10 -51 0 0 0 0 0.043455276 -1 0 0 0 81 14 15 13 65 0 0 10 -38 0 0 0 0 0.395634408 0 0 0 0 82 14 15 16 52 0 0 10 -25 0 0 0 0 0.514826617 0 0 0 0 83 14 14 14 36 0 0 10 -12 0 0 0 0 0.716601665 1 0 0 0 84 14 14 15 22 0 0 10 -95 0 0 0 0 0.236654274 -1 0 0 0 85 14 13 12 7 0 99 10 22 0 0 1 0 0.476716514 0 0 99 0 86 14 13 13 94 99 0 10 -66 0 0 0 0 0.034732176 -1 0 0 0 87 14 10 11 81 0 0 10 -53 0 0 0 0 0.818163876 1 0 0 0 88 14 15 14 70 0 0 10 -41 0 0 0 0 0.181459032 -1 0 0 0 89 14 14 14 56 0 0 10 -30 0 0 0 0 0.886660307 1 0 0 0 90 14 14 13 42 0 0 10 -19 0 0 0 0 0.912197511 1 0 0 0 91 9 14 14 29 0 0 10 -9 0 0 0 0 0.44266256 0 0 0 0 92 9 6 7 15 0 0 10 1 0 0 0 0 0.263518967 -1 0 0 0 93 9 9 8 8 99 0 10 -189 0 0 0 0 0.71387515 1 0 0 0 94 9 10 11 0 0 99 10 -76 0 0 1 0 0.125180294 -1 0 0 99 95 9 8 9 88 0 0 10 -69 0 0 0 0 0.266453524 -1 0 0 0 96 9 10 10 79 0 0 10 -61 0 0 0 0 0.741806212 1 0 0 0 97 9 9 9 69 0 0 10 -51 0 0 0 0 0.668795345 0 0 0 0 98 9 9 8 60 0 0 10 -44 0 0 0 0 0.324682346 -1 0 0 0 99 9 9 9 52 0 0 10 -34 0 0 0 0 0.027374847 -1 0 0 0 100 9 8 10 43 0 0 10 -24 0 0 0 0 0.370575089 0 0 0 0 8 6 6 8 8 7 8 7 7 8 5 6 8 9 9 8 8 8 suma 0 1=velikost min.objednavky 2=vypocet pripadu neuspok.spotr.(po vypoctu=0) 3=zaznam poctu pripadu neuspok.spotreby 4=vypocet prum.vyse zasoby (po vypoctu = 0) 5=zaznamy hodnot prumerne vyse zasoby 6=vypočet počtu realizovanych dodacich cyklu 7=zaznamy počtu realizovaných dodacich cyklů 1 2 3 4 5 1 0 31 0 4.65 2 0 31 0 4.65 3 0 31 0 4.65 4 0 0 0 5 0 31 0 4.66 6 0 0 7 0 34 0 4.64 8 0 0 9 0 0 10 0 27 0 5.46 11 0 0 12 0 24 0 6.13 13 0 0 14 0 0 15 0 17 0 5.46 16 0 0 17 0 16 0 9.4 18 0 0 19 0 17 0 9.39 20 0 14 0 10.7 21 0 18 0 11 22 0 14 0 10.2 23 0 17 0 11 24 0 0 25 0 17 0 11.1 26 0 0 27 0 0 28 0 0 29 0 0 30 0 14 0 13.6 31 0 0 32 0 0 33 0 0 34 0 0 35 0 14 0 16.6 36 0 0 37 0 0 38 0 0 39 0 0 40 0 11 0 17.6 41 0 0 42 0 0 43 0 0 44 0 0 45 0 12 0 19.9 46 0 0 47 0 0 48 0 0 49 0 0 50 0 13 0 22.8 51 0 0 52 0 0 53 0 0 54 0 0 55 0 0 56 0 0 57 0 0 58 0 0 59 0 0 60 0 0 61 0 0 62 0 0 63 0 0 64 0 0 65 0 10 0 28.1 66 0 0 67 0 0 68 0 0 69 0 0 70 0 9 0 29.9 71 0 0 72 0 0 73 0 0 74 0 0 75 0 8 0 32.2 76 0 0 77 0 0 78 0 0 79 0 0 80 0 7 0 36 81 0 0 82 0 0 83 0 0 84 0 0 85 0 8 0 38.4 86 0 0 87 0 0 88 0 0 89 0 0 90 0 8 0 39.2 91 0 0 92 0 0 93 0 0 94 0 0 95 0 0 96 0 0 97 0 0 98 0 0 99 2 53.21 100 0 8 0 45 101 0 0 102 0 0 103 0 0 104 0 0 105 0 0 106 0 0 107 0 0 108 0 0 109 0 0 110 0 6 0 46.7 111 0 0 112 0 0 113 0 0 114 0 0 115 0 0 116 0 0 117 0 0 118 0 0 119 0 0 120 0 7 0 48.2 121 0 0 122 0 0 123 0 0 124 0 0 125 0 0 126 0 0 127 0 0 128 0 0 129 0 0 130 0 5 0 53 131 0 0 132 0 0 133 0 0 134 0 0 135 0 0 136 0 0 137 0 0 138 0 0 139 0 0 140 0 6 0 56.7 141 0 0 142 0 0 143 0 0 144 0 0 145 0 0 146 0 0 147 0 0 148 0 0 149 0 0 150 0 6 0 65.1 151 0 0 152 0 0 153 0 0 154 0 0 155 0 0 156 0 0 157 0 0 158 0 0 159 0 0 160 0 6 0 68 161 0 0 162 0 0 163 0 0 164 0 0 165 0 0 166 0 0 167 0 0 168 0 0 169 0 0 170 0 5 0 72.9 171 0 0 172 0 0 173 0 0 174 0 0 175 0 0 176 0 0 177 0 0 178 0 0 179 0 0 180 0 5 0 78.9 181 0 0 182 0 0 183 0 0 184 0 0 185 0 0 186 0 0 187 0 0 188 0 0 189 0 0 190 0 5 0 82.8 191 0 0 192 0 0 193 0 0 194 0 0 195 0 0 196 0 0 197 0 0 198 0 0 199 0 0 200 0 5 0 84.4 ##### Sheet/List 3 ##### Jednopoložkový bilanční model řízení zásob Značení: P10 Poč. Z SD P1 PD PjZ S1 PotD NS 1=indikace neuspokojene spotreby 2=indikace uskutecnene dodavky 3=indik.dod.cyklu s neuspok.spotr. Zadání: Interv.nejistoty = 8 dnů (dod.lhůta=7+perioda obj.=1) T = 100 dnů min.objednavka= 6 c1= 3 c2= 400 c3= 700 Vypočty: = celkovy počet realizovanych dod.cyklu (za období 100 dnů) = k = z toho: počet vyskytu dodacich cyklu s neusp. spotr. = počet vyskytu neuspok.spotreby (celkem) = m = % poctu vyskytu neusp.spotr.(z celkoveho poctu 100 proverovanych pripadu) = prumerna vyse zasoby (prumer poc.zasoby za 100 dnu) = z = prumerna velikost neuspokojene spotreby (pouze z pripadu kdy nastalo chybeni zasoby) = prumerna velikost neuspokojené spotreby (za 100dnů) N1=c1*T*z N1= N2=c2*k N2= N3=c3*m N3= N=N1+N2+N3 --> min N= Posunuté dodávky t P10 P1 S1 Poč.Z PD SD PjZ PotD NS 1 2 3 Náhodná čísla posun dodávek =0 = -1 =+1 1 6 8 8 25 0 10 10 0 2 6 2 2 0 4 3 6 6 7 20 10 4 6 5 0 0 7 5 6 1 3 20 4 6 6 10 15 0 13 7 6 12 12 0 14 8 6 5 0 0 7 9 6 10 9 12 10 6 2 5 3 11 12 12 13 12 12 12 10 8 14 13 12 10 14 11 14 12 14 9 15 15 12 5 6 7 16 12 11 10 12 17 12 13 5 16 18 12 13 14 15 19 12 11 10 12 20 12 2 6 6 21 5 4 5 4 22 5 6 6 9 23 5 7 7 7 24 5 1 3 1 25 5 0 0 4 26 5 5 4 7 27 5 3 3 3 28 5 8 7 8 29 5 4 4 4 30 5 2 2 2 31 9 8 8 8 32 9 12 11 16 33 9 11 11 13 34 9 9 10 13 35 9 10 12 13 36 9 12 12 13 37 9 15 13 15 38 9 7 7 9 39 9 8 8 10 40 9 8 8 12 41 10 8 8 10 42 10 7 7 8 43 10 12 11 12 44 10 11 12 12 45 10 10 10 13 46 10 10 9 14 47 10 9 9 9 48 10 8 7 12 49 10 13 12 15 50 10 7 8 11 51 8 9 10 9 52 8 7 7 8 53 8 9 9 13 54 8 10 10 10 55 8 6 7 8 56 8 8 6 12 57 8 9 8 12 58 8 8 9 11 59 8 8 8 12 60 8 8 7 10 61 13 14 14 16 62 13 12 13 16 63 13 12 12 14 64 13 13 14 13 65 13 13 13 13 66 13 14 13 14 67 13 13 13 13 68 13 11 11 12 69 13 13 15 14 70 13 12 12 12 71 11 12 12 16 72 11 11 10 15 73 11 11 10 12 74 11 10 10 11 75 11 11 11 15 76 11 12 13 12 77 11 11 14 11 78 11 11 8 12 79 11 10 9 10 80 11 10 9 12 81 14 15 13 19 82 14 15 16 19 83 14 14 14 16 84 14 14 15 18 85 14 13 12 13 86 14 13 13 16 87 14 10 11 13 88 14 15 14 15 89 14 14 14 16 90 14 14 13 17 91 9 14 14 15 92 9 6 7 7 93 9 9 8 11 94 9 10 11 12 95 9 8 9 11 96 9 10 10 11 97 9 9 9 10 98 9 9 8 11 99 9 9 9 9 100 9 8 10 12 ##### Sheet/List 4 ##### poj.zásoba min.obj. N 10 1 34011 1 2 36666 2 3 36567 3 4 34753 4 5 37716 5 6 35029 6 7 35809 7 8 32810 8 9 33903 9 10 32479 10 11 31829 11 12 32750 12 13 31596 13 14 30910 14 15 27613 15 16 26970 16 17 29456 17 18 25230 18 19 25762 19 20 27622 20 21 26668 21 22 25454 22 23 24461 23 24 25516 24 25 25785 25 26 22633 26 27 22095 27 28 22859 28 29 23870 29 30 23139 30 31 21278 31 32 22951 32 33 23301 33 34 23927 34 35 21502 35 36 20610 36 37 20742 37 38 22701 38 39 22701 39 40 21596 40 41 21421 41 42 23099 42 43 22195 43 44 21568 44 45 18888 45 46 18405 46 47 20751 47 48 23924 48 49 22165 49 50 22534 50 51 24808 51 52 18431 52 53 21894 53 54 21058 54 55 23089 55 56 18819 56 57 20885 57 58 19282 58 59 20210 59 60 22656 60 61 21484 61 62 20055 62 63 18947 63 64 22690 64 65 22231 65 66 21171 66 67 22738 67 68 24880 68 69 25447 69 70 20602 70 71 25092 71 72 22095 72 73 21559 73 74 19487 74 75 23993 75 76 20825 76 77 26115 77 78 22095 78 79 21250 79 80 25285 80 81 25851 81 82 21511 82 83 22532 83 84 25726 84 85 27963 85 86 24029 86 87 28053 87 88 28304 88 89 24207 89 90 23416 90 91 20712 91 92 27370 92 93 22140 93 94 29150 94 95 23501 95 96 25327 96 97 25325 97 98 21334 98 99 25069 99