$ 498,814.
99 3%
No Cuota Interes Abono Saldo
0 50000 $ 448,815
1 0 $ 13,464 -$ 13,464 $ 462,279
2 0 $ 13,868 -$ 13,868 $ 476,148
3 0 $ 14,284 -$ 14,284 $ 490,432
4 0 $ 14,713 -$ 14,713 $ 505,145
5 200000 $ 15,154 $ 184,846 $ 320,300
6 0 $ 9,609 -$ 9,609 $ 329,909
7 0 $ 9,897 -$ 9,897 $ 339,806
8 350000 $ 10,194 $ 339,806 $ -
9 0 $ - $ - $ -
10 0 $ - $ - $ -
11 0 $ - $ - $ -
12 0 $ - $ - $ -
8.50% $ 100.00
No Cuota Interes Abono
0 $ 25,000.00
1 $ - $ 2,125.00 -$ 2,125.00
2 $ 2,305.63 -$ 2,305.63
3 $ - $ 2,501.60 -$ 2,501.60
4 $ - $ 2,714.24 -$ 2,714.24
5 $ - $ 2,944.95 -$ 2,944.95
6 $ 3,195.27 -$ 3,195.27
7 $ - $ 3,466.87 -$ 3,466.87
8 $ - $ 3,761.55 -$ 3,761.55
9 $ 20,000.00 $ 4,081.28 $ 15,918.72
10 $ 2,728.19 -$ 2,728.19
11 $ - $ 2,960.09 -$ 2,960.09
12 $ 24,894.00 $ 3,211.70 $ 21,682.30
Saldo
$ 25,000.00
$ 27,125.00
$ 29,430.63
$ 31,932.23
$ 34,646.47
$ 37,591.42 $ 40,000,000.00 $ 13,600,000.00
$ 40,786.69
$ 44,253.56
$ 48,015.11
$ 32,096.39 1 1.085 0.9216589861751
$ 34,824.59 2 1.177225 1.6989105735947
$ 37,784.68 4 1.277289125 3.1316323937229
$ 16,102.37 8 1.385858700625 5.7725942741436
11.524796227636 $ 3,470,777.20
$ 341,552.87 2%
No cuota Cuota Interes Abono Saldo
1 0 6831.057461 -6831.05746 348383.9305
2 0 6967.67861 -6967.67861 355351.6091
3 0 7107.032182 -7107.03218 362458.6413
4 0 7249.172826 -7249.17283 369707.8141
5 0 7394.156282 -7394.15628 377101.9704
6 75000 7542.039408 67457.96059 309644.0098
7 0 6192.880196 -6192.8802 315836.89
8 45000 6316.7378 38683.2622 277153.6278
9 0 5543.072556 -5543.07256 282696.7004
10 0 5653.934007 -5653.93401 288350.6344
11 0 5767.012687 -5767.01269 294117.6471
12 300000 5882.352941 294117.6471 0
Parametro Cantidad Cálculos parámetros inventarios
Estad B IS PP
Nivel de
Demanda 2960 Und/año servicio
Costo almacenar (Ca) 0.25 Anual 50% 0.0000 16 49
Costo pedir (Cp) 40 por Und 60% 0.2533 26 58
Costo unitario (Cu) 6000 por Und 70% 0.5244 35 68
LT 25 días 80% 0.8416 47 80
Dias al año 360 días 85% 1.0364 54 87
Desv D 18 Und/día 90% 1.2816 63 95
95% 1.6449 76 109
CALCULO Q Y N° PEDIDOS 97% 1.8808 84 117
Qopt 12.5645 Und 99% 2.3263 100 133
N° Pedidos al año 235.584 ped/año 99.1% 2.3656 102 134
N° Pedidos al mes 19.632 ped/mes 99.2% 2.4089 103 136
99.3% 2.4573 105 138
LT 4 99.4% 2.5121 107 140
CA 0.25 99.5% 2.5758 109 142
CP 40 99.6% 2.6521 112 145
CU 80 99.7% 2.7478 115 148
DESVIACION 18 99.8% 2.8782 120 153
D. PROMEDIO 8.22222 99.9% 3.0902 128 161
Q. OPT 141
Cálculo incrementos nivel de servicio y valor del inventa
Incremento INC entre
Inicial Final NS rangos
50% 60.0% 10.0%
50% 70.0% 20.0% 10.0%
50% 80.0% 30.0% 10.0%
50% 85.0% 35.0% 5.0%
50% 90.0% 40.0% 5.0%
50% 95.0% 45.0% 5.0%
50% 97.0% 47.0% 2.0%
50% 99.0% 49.0% 2.0%
50% 99.1% 49.1% 0.1%
50% 99.2% 49.2% 0.1%
50% 99.3% 49.3% 0.1%
50% 99.4% 49.4% 0.1%
50% 99.5% 49.5% 0.1%
50% 99.6% 49.6% 0.1%
50% 99.7% 49.7% 0.1%
50% 99.8% 49.8% 0.1%
50% 99.9% 49.9% 0.1%
rámetros inventarios Cálculo de
Ind de
Nivel Ind de rotación Duración
Qmax Qpro Valor Qmax N° rotación
de servicio anual inv días
mensual
157 79 $ 6,320 1 50.00% 37.47 3.12 9.61
167 84 $ 6,720 2 60.00% 35.24 2.94 10.22
176 89 $ 7,120 3 70.00% 33.26 2.77 10.82
188 94 $ 7,520 4 80.00% 31.49 2.62 11.43
195 98 $ 7,840 5 85.00% 30.20 2.52 11.92
204 102 $ 8,160 6 90.00% 29.02 2.42 12.41
217 109 $ 8,720 7 95.00% 27.16 2.26 13.26
225 113 $ 9,040 8 97.00% 26.19 2.18 13.74
241 121 $ 9,680 9 99.00% 24.46 2.04 14.72
243 122 $ 9,760 10 99.10% 24.26 2.02 14.84
244 123 $ 9,840 11 99.20% 24.07 2.01 14.96
246 123 $ 9,840 12 99.30% 24.07 2.01 14.96
248 124 $ 9,920 13 99.40% 23.87 1.99 15.08
250 126 $ 10,080 14 99.50% 23.49 1.96 15.32
253 127 $ 10,160 15 99.60% 23.31 1.94 15.45
256 129 $ 10,320 16 99.70% 22.95 1.91 15.69
261 131 $ 10,480 17 99.80% 22.60 1.88 15.93
269 135 $ 10,800 18 99.90% 21.93 1.83 16.42
vel de servicio y valor del inventario
Incremento Incremento
$ Inv ENTRE RANGOS
5.95%
11.24% 5.3%
15.96% 4.7%
19.39% 3.4%
22.55% 3.2%
27.52% 5.0%
30.09% 2.6%
34.71% 4.6%
35.25% 0.5%
35.77% 0.5%
35.77% 0.0%
36.29% 0.5%
37.30% 1.0%
37.80% 0.5%
38.76% 1.0%
39.69% 0.9%
41.48% 1.8%
Cálculo de incremento índices de rotación
Duración N° pedidos Costo Costo Costo
Costo compra
del ciclo NE al año m pedir Alm total
19.15 37 $ 1,480.00 $ 19.75 $ 474,000.00 $ 475,499.75
20.26 35 $ 1,400.00 $ 21.00 $ 504,000.00 $ 505,421.00
21.44 33 $ 1,320.00 $ 22.25 $ 534,000.00 $ 535,342.25
22.83 31 $ 1,240.00 $ 23.50 $ 564,000.00 $ 565,263.50
23.69 30 $ 1,200.00 $ 24.50 $ 588,000.00 $ 589,224.50
24.76 29 $ 1,160.00 $ 25.50 $ 612,000.00 $ 613,185.50
26.35 27 $ 1,080.00 $ 27.25 $ 654,000.00 $ 655,107.25
27.38 26 $ 1,040.00 $ 28.25 $ 678,000.00 $ 679,068.25
29.33 24 $ 960.00 $ 30.25 $ 726,000.00 $ 726,990.25
29.51 24 $ 960.00 $ 30.50 $ 732,000.00 $ 732,990.50
29.70 24 $ 960.00 $ 30.75 $ 738,000.00 $ 738,990.75
29.91 24 $ 960.00 $ 30.75 $ 738,000.00 $ 738,990.75
30.15 24 $ 960.00 $ 31.00 $ 744,000.00 $ 744,991.00
30.43 23 $ 920.00 $ 31.50 $ 756,000.00 $ 756,951.50
30.76 23 $ 920.00 $ 31.75 $ 762,000.00 $ 762,951.75
31.18 23 $ 920.00 $ 32.25 $ 774,000.00 $ 774,952.25
31.75 23 $ 920.00 $ 32.75 $ 786,000.00 $ 786,952.75
32.68 22 $ 880.00 $ 33.75 $ 810,000.00 $ 810,913.75
Inc Inc nivel Posible
Var Abs Costo Total
Valor inv servicio NS
$ 29,921.25 5.9% 10.0%
$ 29,921.25 11.2% 20.0% OK 5.3%
$ 29,921.25 15.9% 30.0% 4.7%
$ 23,961.00 19.3% 35.0% OK 3.4%
$ 23,961.00 22.5% 40.0% OK 3.2%
$ 41,921.75 27.4% 45.0% 5.0%
$ 23,961.00 30.0% 47.0% OK 2.6%
$ 47,922.00 34.6% 49.0% 4.6%
$ 6,000.25 35.1% 49.1% OK 0.5%
$ 6,000.25 35.7% 49.2% 0.5%
$ - 35.7% 49.3% 0.0%
$ 6,000.25 36.2% 49.4% 0.5%
$ 11,960.50 37.2% 49.5% OK 1.0%
$ 6,000.25 37.7% 49.6% 0.5%
$ 12,000.50 38.6% 49.7% OK 1.0%
$ 12,000.50 39.6% 49.8% 0.9%
$ 23,961.00 41.4% 49.9% 1.8%
Parametro Cantidad Cálculos parámetros inventarios
Estad B IS PP Qmax
Nivel de
Demanda 2960 Und/año servicio
Costo almacenar (Ca) 0.25 Anual 50% 0.0000 24 71 165
Costo pedir (Cp) 40 por Und 60% 0.2533 33 80 174
Costo unitario (Cu) 80 por Und 70% 0.5244 43 90 184
LT 20 días 80% 0.8416 54 101 195
Dias al año 250 días 85% 1.0364 61 108 202
Desv D 18 Und/día 90% 1.2816 70 117 211
95% 1.6449 83 130 224
CALCULO Q Y N° PEDIDOS 97% 1.8808 91 139 232
Qopt 108.8118 Und 99% 2.3263 107 155 248
N° Pedidos al año 27.20294 ped/año 99.1% 2.3656 109 156 250
N° Pedidos al mes 2.266912 ped/mes 99.2% 2.4089 110 158 251
99.3% 2.4573 112 160 253
LT 4 99.4% 2.5121 114 161 255
CA 0.25 99.5% 2.5758 116 164 257
CP 40 99.6% 2.6521 119 167 260
CU 80 99.7% 2.7478 123 170 264
DESVIACION 18 99.8% 2.8782 127 175 268
D. PROMEDIO 11.84 99.9% 3.0902 135 182 276
Q. OPT 141
Cálculo incrementos nivel de servicio y valor del inventario
Increment
Incremento INC entre o
Inicial Final NS rangos $ Inv
50% 60.0% 10.0% 4.60%
50% 70.0% 20.0% 10.0% 9.78%
50% 80.0% 30.0% 10.0% 15.31%
50% 85.0% 35.0% 5.0% 17.82%
50% 90.0% 40.0% 5.0% 21.70%
50% 95.0% 45.0% 5.0% 25.89%
50% 97.0% 47.0% 2.0% 29.06%
50% 99.0% 49.0% 2.0% 33.60%
50% 99.1% 49.1% 0.1% 33.60%
50% 99.2% 49.2% 0.1% 34.13%
50% 99.3% 49.3% 0.1% 34.65%
50% 99.4% 49.4% 0.1% 35.16%
50% 99.5% 49.5% 0.1% 35.66%
50% 99.6% 49.6% 0.1% 36.64%
50% 99.7% 49.7% 0.1% 37.12%
50% 99.8% 49.8% 0.1% 38.52%
50% 99.9% 49.9% 0.1% 39.86%
inventarios Cálculo de incremento índices de ro
Ind de
Nivel Ind de rotación Duración Duración
Qpro Valor Qmax N° rotación
de servicio anual inv días del ciclo NE
mensual
83 $ 6,640 1 50.00% 35.66 2.97 10.09 13.91
87 $ 6,960 2 60.00% 34.02 2.84 10.58 14.68
92 $ 7,360 3 70.00% 32.17 2.68 11.19 15.50
98 $ 7,840 4 80.00% 30.20 2.52 11.92 16.47
101 $ 8,080 5 85.00% 29.31 2.44 12.28 17.06
106 $ 8,480 6 90.00% 27.92 2.33 12.89 17.81
112 $ 8,960 7 95.00% 26.43 2.20 13.62 18.91
117 $ 9,360 8 97.00% 25.30 2.11 14.23 19.63
125 $ 10,000 9 99.00% 23.68 1.97 15.20 20.98
125 $ 10,000 10 99.10% 23.68 1.97 15.20 21.10
126 $ 10,080 11 99.20% 23.49 1.96 15.32 21.23
127 $ 10,160 12 99.30% 23.31 1.94 15.45 21.38
128 $ 10,240 13 99.40% 23.13 1.93 15.57 21.55
129 $ 10,320 14 99.50% 22.95 1.91 15.69 21.74
131 $ 10,480 15 99.60% 22.60 1.88 15.93 21.97
132 $ 10,560 16 99.70% 22.42 1.87 16.05 22.26
135 $ 10,800 17 99.80% 21.93 1.83 16.42 22.66
138 $ 11,040 18 99.90% 21.45 1.79 16.78 23.30
io y valor del inventario
Incremento
ENTRE RANGOS
5.2%
5.5%
2.5%
3.9%
4.2%
3.2%
4.5%
0.0%
0.5%
0.5%
0.5%
0.5%
1.0%
0.5%
1.4%
1.3%
culo de incremento índices de rotación
N° pedidos Costo Costo Costo Var Abs Costo Inc
Costo compra
al año m pedir Alm total Total Valor inv
25 $ 1,000.00 $ 20.75 $ 6,640.00 $ 7,660.75
24 $ 960.00 $ 21.75 $ 6,960.00 $ 7,941.75 $ 281.00 3.5%
22 $ 880.00 $ 23.00 $ 7,360.00 $ 8,263.00 $ 321.25 7.3%
21 $ 840.00 $ 24.50 $ 7,840.00 $ 8,704.50 $ 441.50 12.0%
20 $ 800.00 $ 25.25 $ 8,080.00 $ 8,905.25 $ 200.75 14.0%
19 $ 760.00 $ 26.50 $ 8,480.00 $ 9,266.50 $ 361.25 17.3%
18 $ 720.00 $ 28.00 $ 8,960.00 $ 9,708.00 $ 441.50 21.1%
18 $ 720.00 $ 29.25 $ 9,360.00 $ 10,109.25 $ 401.25 24.2%
16 $ 640.00 $ 31.25 $ 10,000.00 $ 10,671.25 $ 562.00 28.2%
16 $ 640.00 $ 31.25 $ 10,000.00 $ 10,671.25 $ - 28.2%
16 $ 640.00 $ 31.50 $ 10,080.00 $ 10,751.50 $ 80.25 28.7%
16 $ 640.00 $ 31.75 $ 10,160.00 $ 10,831.75 $ 80.25 29.3%
16 $ 640.00 $ 32.00 $ 10,240.00 $ 10,912.00 $ 80.25 29.8%
16 $ 640.00 $ 32.25 $ 10,320.00 $ 10,992.25 $ 80.25 30.3%
16 $ 640.00 $ 32.75 $ 10,480.00 $ 11,152.75 $ 160.50 31.3%
16 $ 640.00 $ 33.00 $ 10,560.00 $ 11,233.00 $ 80.25 31.8%
15 $ 600.00 $ 33.75 $ 10,800.00 $ 11,433.75 $ 200.75 33.0%
15 $ 600.00 $ 34.50 $ 11,040.00 $ 11,674.50 $ 240.75 34.4%
Inc nivel Posible
servicio NS
10.0%
20.0% OK 3.8%
30.0% 4.7%
35.0% OK 2.0%
40.0% OK 3.4%
45.0% 3.8%
47.0% OK 3.1%
49.0% 4.0%
49.1% OK 0.0%
49.2% 0.5%
49.3% 0.5%
49.4% 0.5%
49.5% OK 0.5%
49.6% 1.0%
49.7% OK 0.5%
49.8% 1.2%
49.9% 1.4%
Nivel
N° de servicio INC. INV
1 50.00%
2 60.00% 3.5%
3 70.00% 6.4%
4 80.00% 10.2% Chart Title
5 85.00% 12.7% 0.35
6 90.00% 14.7%
0.3
7 95.00% 18.8%
0.25
8 97.00% 20.9%
9 99.00% 24.7% 0.2
10 99.10% 25.2% 0.15
11 99.20% 25.2% 0.1
12 99.30% 25.7% 0.05
13 99.40% 26.2%
0
14 99.50% 26.4% 1 2 3 4 5 6 7 8 9 10 11 12 13
15 99.60% 27.4%
16 99.70% 27.9% INC. INV Nivel
de servicio
17 99.80% 29.1%
18 99.90% 30.8%
1556.2%
Chart Title
120.00%
100.00%
80.00%
60.00%
40.00%
20.00%
0.00%
6 7 8 9 10 11 12 13 14 15 16 17 18
INC. INV Nivel
de servicio
