Scribd
Upload
6 views2 pages

Demanda y Costos de Inventario

This document simulates an inventory management model over multiple days. It tracks inventory levels, demand, and replenishment orders. Random numbers are generated each day to determine demand. The model tracks inventory levels, calculates costs of maintenance, stockouts, and orders, and totals the costs. Over 18 days of simulation, the total costs amounted to $4,692.

Uploaded by

Fiorella Melisa Vilela Lozada
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
6 views2 pages

Demanda y Costos de Inventario

This document simulates an inventory management model over multiple days. It tracks inventory levels, demand, and replenishment orders. Random numbers are generated each day to determine demand. The model tracks inventory levels, calculates costs of maintenance, stockouts, and orders, and totals the costs. Over 18 days of simulation, the total costs amounted to $4,692.

Uploaded by

Fiorella Melisa Vilela Lozada
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Tiempo de Probabilidad

Demanda Probabilidad Entrega


0 0 - 0.1 1 0 - 0.6 Inventario
1 0.1 - 0.35 2 0.6 - 0.9 Inicial =
2 0.35 - 0.7 3 0.9 - 1 Punto de
3 0.7 - 0.91 Reorden=
4 0.91 - 1

Inventario Inventario Cantidad de


Variable Dia Demanda Pedidos
Inicial Final Faltantes
Aliatoria
0.241011131 1 13 1 12 0
0.28353599 2 12 1 11 0
0.130529745 3 21 1 20 0
0.286407936 4 20 1 19 0
0.954181477 5 19 4 15 0
0.900799387 6 15 3 12 0
0.774242648 7 12 3 9 0 Pedido = 11
0.613150212 8 9 2 7 0
0.181395372 9 7 1 6 0
0.211630777 10 16 1 15 0
0.130355437 11 15 1 14 0
0.829283042 12 14 3 11 0 Pedido = 11
0.655448252 13 11 2 9 0
0.641042813 14 19 2 17 0
0.937172786 15 17 4 13 0
0.687050032 16 13 2 11 0 Pedido = 11
0.025879606 17 11 0 11 0
0.05689064 18 11 0 11 0
TOTAL
$8
13 Costo por Pedido=
Costo de Mant por $2
11 und por dia=
Costo de Esc por $10
unidad=

Variable Tiempo de Costo de Costo de Costo de Costo Total


Aliatoria Entrega Mantenimiento Escaces Pedido

0 $26 0 $0 $26
-1 $48 0 $0 $48
$126 0 $0 $126
$160 0 $0 $160
$190 0 $0 $190
$180 0 $0 $180
0.6822581 2 $168 0 $8 $176
1 $144 0 $0 $144
0 $126 0 $0 $126
$320 0 $0 $320
$330 0 $0 $330
0.15361975 1 $336 0 $8 $344
0 $286 0 $0 $286
$532 0 $0 $532
$510 0 $0 $510
0.80792213 2 $416 0 $8 $424
1 $374 0 $0 $374
0 $396 0 $0 $396
$4,668 $0 $24 $4,692

You might also like