Baixe planilhas testes de planilhas e outras Exercícios em PDF para Matemática, somente na Docsity!
Simulação de Controle de Estoques com Variação Probabilística de Demanda
Demanda Anual (D) Lead time (Tempo de Entrega do Produto) Custo de Uma Ordem de Compra 5330 unidades 21 R$ 138. (10 a 10000) (1 a 90 dias) Desvio padrão da demanda diária Nível de confiabilidade do atendimento Custo unitário de compra do prod 8 unidades 86 % R$ 1. (1 a 20) (50 a 99%) 10 **Dias de trabalho por ano 270 Modelo Q de Esto
20
460 40 R$ 1,212.** Modelo: Demanda constante Time 1212.88087 Ponto de Encomenda Deterministico 0 1192.88087 460 1 1172.88087 460 2 1152.88087 460 3 1132.88087 460 4 1112.88087 460 5 1092.88087 460 6 1072.88087 460 7 1052.88087 460 8 1032.88087 460 9 1012.88087 460 10 992.880868 460 11 972.880868 460 12 952.880868 460 13 932.880868 460 14 912.880868 460 15 892.880868 460 16 872.880868 460 17 852.880868 460 18 832.880868 460 19 812.880868 460 20 792.880868 460 21 772.880868 460 (^0123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899) 100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365 0 200 400 600 800 1000 1200 1400
Ciclo dos Estoques
Modelo: Demanda constante Ponto de Encomenda Deterministico Dias N ív el de Estoques
5330 Demanda Anual (D) R$ 138.00 Custo da Ordem (Co) R$ 1.00 Custo Unitário (Cc) Custo Total EOQ R$ 1,212.88 1213 Q Co (^100) $7,355. 200 $3,677.70 Cc 300 $2,451.80 $ 50. 400 $1,838.85 $ 100. 500 $1,471.08 $ 150. 600 $1,225.90 $ 200. 700 $1,050.77 $ 250.00 TC 800 $919.43 $ 300.00 $7,405. 900 $817.27 $ 350.00 $3,777. 1000 $735.54 $ 400.00 $2,601. 1100 $668.67 $ 450.00 $2,038. 1200 $612.95 $ 500.00 $1,721. 1300 $565.80 $ 550.00 $1,525. 1400 $525.39 $ 600.00 $1,400. 1500 $490.36 $ 650.00 $1,319. 1600 $459.71 $ 700.00 $1,267. 1700 $432.67 $ 750.00 $1,235. 1800 $408.63 $ 800.00 $1,218. 1900 $387.13 $ 850.00 $1,212. 2000 $367.77 $ 900.00 $1,215. 2100 $350.26 $ 950.00 $1,225. 2200 $334.34 $1,000.00 $1,240. 2300 $319.80 $1,050.00 $1,259. 2400 $306.48 $1,100.00 $1,282. 2500 $294.22 $1,150.00 $1,308. 2600 $282.90 $1,200.00 $1,337. 2700 $272.42 $1,250.00 $1,367. 2800 $262.69 $1,300.00 $1,400. 2900 $253.63 $1,350.00 $1,434. 3000 $245.18 $1,400.00 $1,469.
Order Quantity (in hundreds of units)
Total Cost
- 22 752.880868
- 23 732.880868
- 24 712.880868
- 25 692.880868
- 26 672.880868
- 27 652.880868
- 28 632.880868
- 29 612.880868
- 30 592.880868
- 31 572.880868
- 32 552.880868
- 33 532.880868
- 34 512.880868
- 35 492.880868
- 36 472.880868
- 37 452.880868
- 38 432.880868
- 39 412.880868
- 40 392.880868
- 41 372.880868
- 42 352.880868
- 43 332.880868
- 44 312.880868
- 45 292.880868
- 46 272.880868
- 47 252.880868
- 48 232.880868
- 49 212.880868
- 50 192.880868
- 51 172.880868
- 52 152.880868
- 53 132.880868
- 54 112.880868
- 55 92.880868
- 56 72.880868
- 57 52.880868
- 58 32.880868
- 59 12.880868
- 60 1212.88087
- 61 1192.88087
- 62 1172.88087
- 63 1152.88087
- 64 1132.88087
- 65 1112.88087
- 66 1092.88087
- 67 1072.88087
- 68 1052.88087
- 69 1032.88087
- 70 1012.88087
- 71 992.880868
- 72 972.880868
- 73 952.880868
- 74 932.880868
- 75 912.880868
- 76 892.880868
- 77 872.880868
- 78 852.880868
- 79 832.880868
- 80 812.880868
- 81 792.880868
- 82 772.880868
- 83 752.880868
- 84 732.880868
- 85 712.880868
- 86 692.880868
- 87 672.880868
- 88 652.880868
- 89 632.880868
- 90 612.880868
- 91 592.880868
- 92 572.880868
- 93 552.880868
- 94 532.880868
- 95 512.880868
- 96 492.880868
- 97 472.880868
- 98 452.880868
- 99 432.880868
- 100 412.880868
- 101 392.880868
- 102 372.880868
- 103 352.880868
- 104 332.880868
- 105 312.880868
- 106 292.880868
- 107 272.880868
- 108 252.880868
- 109 232.880868
- 110 212.880868
- 111 192.880868
- 112 172.880868
- 113 152.880868
- 114 132.880868
- 115 112.880868
- 116 92.880868
- 117 72.880868
- 118 52.880868
- 119 32.880868
- 120 12.880868
- 121 1212.88087
- 122 1192.88087
- 123 1172.88087
- 124 1152.88087
- 125 1132.88087
- 126 1112.88087
- 127 1092.88087
- 128 1072.88087
- 129 1052.88087
- 130 1032.88087
- 131 1012.88087
- 132 992.880868
- 133 972.880868
- 134 952.880868
- 135 932.880868
- 136 912.880868
- 137 892.880868
- 138 872.880868
- 139 852.880868
- 140 832.880868
- 141 812.880868
- 142 792.880868
- 143 772.880868
- 144 752.880868
- 145 732.880868
- 146 712.880868
- 147 692.880868
- 148 672.880868
- 149 652.880868
- 150 632.880868
- 151 612.880868
- 152 592.880868
- 153 572.880868
- 154 552.880868
- 155 532.880868
- 156 512.880868
- 157 492.880868
- 158 472.880868
- 159 452.880868
- 160 432.880868
- 161 412.880868
- 162 392.880868
- 163 372.880868
- 164 352.880868
- 165 332.880868
- 166 312.880868
- 167 292.880868
- 168 272.880868
- 169 252.880868
- 170 232.880868
- 171 212.880868
- 172 192.880868
- 173 172.880868
- 174 152.880868
- 175 132.880868
- 176 112.880868
- 177 92.880868
- 178 72.880868
- 179 52.880868
- 180 32.880868
- 181 12.880868
- 182 1212.88087
- 183 1192.88087
- 184 1172.88087
- 185 1152.88087
- 186 1132.88087
- 187 1112.88087
- 188 1092.88087
- 189 1072.88087
- 190 1052.88087
- 191 1032.88087
- 192 1012.88087
- 193 992.880868
- 194 972.880868
- 195 952.880868
- 196 932.880868
- 197 912.880868
- 198 892.880868
- 199 872.880868
- 200 852.880868
- 201 832.880868
- 202 812.880868
- 203 792.880868
- 204 772.880868
- 205 752.880868
- 206 732.880868
- 207 712.880868
- 208 692.880868
- 209 672.880868
- 210 652.880868
- 211 632.880868
- 212 612.880868
- 213 592.880868
- 214 572.880868
- 215 552.880868
- 216 532.880868
- 217 512.880868
- 218 492.880868
- 219 472.880868
- 220 452.880868
- 221 432.880868
- 222 412.880868
- 223 392.880868
- 224 372.880868
- 225 352.880868
- 226 332.880868
- 227 312.880868
- 228 292.880868
- 229 272.880868
- 230 252.880868
- 231 232.880868
- 232 212.880868
- 233 192.880868
- 234 172.880868
- 235 152.880868
- 236 132.880868
- 237 112.880868
- 238 92.880868
- 239 72.880868
- 240 52.880868
- 241 32.880868
- 242 12.880868
- 243 1212.88087
- 244 1192.88087
- 245 1172.88087
- 246 1152.88087
- 247 1132.88087
- 248 1112.88087
- 249 1092.88087
- 250 1072.88087
- 251 1052.88087
- 252 1032.88087
- 253 1012.88087
- 254 992.880868
- 255 972.880868
- 256 952.880868
- 257 932.880868
- 258 912.880868
- 259 892.880868
- 260 872.880868
- 261 852.880868
- 262 832.880868
- 263 812.880868
- 264 792.880868
- 265 772.880868
- 266 752.880868
- 267 732.880868
- 268 712.880868
- 269 692.880868
- 270 672.880868
- 271 652.880868
- 272 632.880868
- 273 612.880868
- 274 592.880868
- 275 572.880868
- 276 552.880868
- 277 532.880868
- 278 512.880868
- 279 492.880868
- 280 472.880868
- 281 452.880868
- 282 432.880868
- 283 412.880868
- 284 392.880868
- 285 372.880868
- 286 352.880868
- 287 332.880868
- 288 312.880868
- 289 292.880868
- 290 272.880868
- 291 252.880868
- 292 232.880868
- 293 212.880868
- 294 192.880868
- 295 172.880868
- 296 152.880868
- 297 132.880868
- 298 112.880868
- 299 92.880868
- 300 72.880868
- 301 52.880868
- 302 32.880868
- 303 12.880868
- 304 1212.88087
- 305 1192.88087
- 306 1172.88087
- 307 1152.88087
- 308 1132.88087
- 309 1112.88087
- 310 1092.88087
- 311 1072.88087
- 312 1052.88087
- 313 1032.88087
- 314 1012.88087
- 315 992.880868
- 316 972.880868
- 317 952.880868
- 318 932.880868
- 319 912.880868
- 320 892.880868
- 321 872.880868
- 322 852.880868
- 323 832.880868
- 324 812.880868
- 325 792.880868
- 326 772.880868
- 327 752.880868
- 328 732.880868
- 329 712.880868
- 330 692.880868
- 331 672.880868
- 332 652.880868
- 333 632.880868
- 334 612.880868
- 335 592.880868
- 336 572.880868
- 337 552.880868
- 338 532.880868
- 339 512.880868
- 340 492.880868
- 341 472.880868
- 342 452.880868
- 343 432.880868
- 344 412.880868
- 345 392.880868
- 346 372.880868
- 347 352.880868
- 348 332.880868
- 349 312.880868
- 350 292.880868
- 351 272.880868
- 352 252.880868
- 353 232.880868
- 354 212.880868
- 355 192.880868
- 356 172.880868
- 357 152.880868
- 358 132.880868
- 359 112.880868
- 360 92.880868
- 361 72.880868
- 362 52.880868
- 363 32.880868
- 364 12.880868
- $1,450.00 $1,506.
- $1,500.00 $1,544.
- $1,582.
- $1,622.
- $1,662.
- $1,703.
- $1,745.
