PRONOSTICO DE VENTAS

MES
1 2 3 4 5 6
Cajas 10,000 13,000 11,000 16,000 20,000 13,000
Pimienta Negra
Frascos 3,000 2,000 2,000 3,500 4,500 3,000
Cajas 12,000 13,000 11,000 16,000 22,000 14,000
Comino Molido
Frascos 3,200 3,000 1,500 2,500 3,500 3,000
Cajas 3,000 3,500 4,200 3,000 3,200 3,200
Canela
Frascos 1,000 800 600 700 600 600
Sazonador Cajas 8,000 9,000 9,500 10,000 10,500 9,500

Inventario de Productos Terminados

Inventario
Cajas 4,000
Pimienta Negra
Frascos 2,000
Cajas 900
Comino Molido
Frascos 300
Cajas 5,000
Canela
Frascos 2,500
Sazonador Cajas 2,000

En base a las especificaciones de inventario mínimo (10% de las ventas del próximo mes), calculamos el inventario mínim
terminados:
INVENTARIO MINIMO REQUERIDO
MES
1 2 3 4 5 6
Cajas 1300 1100 1600 2000 1300 1200
Pimienta Negra
Frascos 200 200 350 450 300 250
Cajas 1300 1100 1600 2200 1400 1300
Comino Molido
Frascos 300 150 250 350 300 180
Cajas 350 420 300 320 320 320
Canela
Frascos 80 60 70 60 60 45
Sazonador Cajas 900 950 1000 1050 950 650

En base al plan de ventas, y los inventarios mínimos a mantener, realizamos el cálculo del plan de producción. Considera
cantidad a vender, más el inventario final, menos el inventario inicial.

PLAN DE PRODUCCIÓN
MES
1 2 3 4 5 6
Pimienta Negra Cajas 7300 12800 11500 16400 19300 12900
Frascos 1200 2000 2150 3600 4350 2950
Comino Molido Cajas 12400 12800 11500 16600 21200 13900
Frascos 3200 2850 1600 2600 3450 2880
Canela Cajas 0 1920 4080 3020 3200 3200
Frascos 0 0 0 660 600 585
Sazonador Cajas 6900 9050 9550 10050 10400 9200

INVENTARIO FINAL DE PRODUCTOS TERMINADOS

MES
1 2 3 4 5 6
Pimienta Negra Cajas 1300 1100 1600 2000 1300 1200
Frascos 200 200 350 450 300 250
Comino Molido Cajas 1300 1100 1600 2200 1400 1300
Frascos 300 150 250 350 300 180
Canela Cajas 2000 420 300 320 320 320
Frascos 1500 700 100 60 60 45
Sazonador Cajas 900 950 1000 1050 950 650
ONOSTICO DE VENTAS
MES
7 8 9 10 11 12
12,000 12,000 11,000 12,000 16,000 20,000
2,500 2,800 3,000 3,500 4,000 5,000
13,000 12,000 11,000 13,000 1,800 2,100
1,800 2,500 3,000 3,200 400 500
3,200 2,500 2,500 2,800 2,900 3,000
450 450 450 500 500 500
6,500 7,500 7,000 8,000 9,500 10,000

), calculamos el inventario mínimo requerido de productos

ARIO MINIMO REQUERIDO

MES
7 8 9 10 11 12
1200 1100 1200 1600 2000 1000
280 300 350 400 500 300
1200 1100 1300 180 210 1200
250 300 320 40 50 320
250 250 280 290 300 300
45 45 50 50 50 100
750 700 800 950 1000 800

el plan de producción. Consideramos la cantidad a producir como la

MES
7 8 9 10 11 12
12000 11900 11100 12400 16400 18,000
2530 2820 3050 3550 4100 4,500
12900 11900 11200 11880 1830 1,890
1870 2550 3020 2920 410 450
3130 2500 2530 2810 2910 2,700
450 450 455 500 500 450
6600 7450 7100 8150 9550 9,000

7 8 9 10 11 12
1200 1100 1200 1600 2000 1000
280 300 350 400 500 300
1200 1100 1300 180 210 1200
250 300 320 40 50 320
250 250 280 290 300 300
45 45 50 50 50 100
750 700 800 950 1000 800
Para determinar el nivel de Compras es que necesitare detemrinar la cantidad de material por producto y luego
proyectarlo.

Material por Producto

Pimineta Negra Sabor de 100 sobres de 1.5 gr Medida Costo Unitario
Celofan Polypack con impresión Pimienta 0.013287 10
Celofan Polypack delgado 64 mm 0.012772 8
Manga SW 19.5 0.0027 9
Carton Pimienta 1.5 gr 1 0.5
Pimienta Negra Molida 0.15 28
Grapa 100 0.0003
TOTAL

Comino Sabor de 100 sobres de 1.5 gr Medida Costo Unitario

Celofan Polypack con impresión Comino 0.013287 10
Celofan Polypack delgado 64 mm 0.012772 8
Manga SW 19.5 0.0027 9
Carton Comino Negra 1.5 gr 1 0.5
Comino Molido 0.15 30
Grapa 100 0.0003
TOTAL

Canela Sabor de 100 sobres de 1.5 gr Medida Costo Unitario

Celofan Polypack con impresión Canela 0.013287 10
Celofan Polypack delgado 64 mm 0.012772 8
Manga SW 19.5 0.0027 9
Carton Canela 1 0.5
Canela Molida 0.15 17
Grapa 100 0.0003
TOTAL

Sazonador Sabor de 80 sobres de 4 gr Medida Costo Unitario

Celofan Polypack con impresión Sazonador 0.011161 10
Celofan Polypack delgado 64 mm 0.010728 8
Manga SW 19.5 0.0026 9
Caja Sazonador 1 0.5
Sazonador 0.4 2.564
Grapa 84 0.0003
TOTAL
Pimineta Negra Sabor 100 frascos de 40 gr Medida Costo Unitario
Envase de 40 gr 1.000000 0.05
Etiqueta Pimienta 1.000000 0.02
Outers 0.020833 0.3
Pimienta Negra Molida 0.041154 28
Dispensador 1.000000 0.02
Insertos 1.000000 0.01
Cinta 0.000202 3
Pegamento 0.030000 2
Silicado 0.000101 3
TOTAL x Frasco
TOTAL x 100 Frascos

Comino Sabor 100 frascos de 40 gr Medida Costo Unitario

Envase de 40 gr 1.000000 0.05
Etiqueta Comino 1.000000 0.02
Outers 0.020833 0.3
Comino Molido 0.039920 30
Dispensador 1.000000 0.02
Insertos 1.000000 0.01
Cinta 0.000202 3
Pegamento 0.030000 2
Silicado 0.000101 3
TOTAL x Frasco
TOTAL x 100 Frascos

Canela Sabor 100 frascos de 40 gr Medida Costo Unitario

Envase de 40 gr 1.000000 0.05
Etiqueta Canela 1.000000 0.02
Outers 0.020833 0.3
Canela 0.039920 17
Dispensador 1.000000 0.02
Insertos 1.000000 0.01
Cinta 0.000202 3
Pegamento 0.030000 2
Silicado 0.000101 3
TOTAL x Frasco
TOTAL x 100 Frascos

SAZONADOR para una Carga de 100kg Medida Costo Unitario

pimienta molida negra 0.400000 28
comino molido 1.200000 30
aceite vegetal 2.000000 4.5
oregano molido 1.200000 5
achiote molido 23.000000 6
aji panca molido 0.400000 3
jenjibre (kion) molido 0.400000 8
semilla de culantro molido 1.400000 2
sal de cocina molida 70.000000 0.7
TOTAL x Frasco
TOTAL x 100 Frascos
l por producto y luego Proyeccion de Materiales por mes

MES
1 2 3 4 5
Subtotal 7300 12800 11500 16400 19300
0.13287 97 170 153 218 256
0.102176 93 163 147 209 246
0.0243 20 35 31 44 52
0.5 7300 12800 11500 16400 19300
4.2 1095 1920 1725 2460 2895
0.03 730000 1280000 1150000 1640000 1930000
4.989346

MES
1 2 3 4 5
Subtotal 12400 12800 11500 16600 21200
0.13287 165 170 153 221 282
0.102176 158 163 147 212 271
0.0243 33 35 31 45 57
0.5 12400 12800 11500 16600 21200
4.5 1860 1920 1725 2490 3180
0.03 1240000 1280000 1150000 1660000 2120000
5.289346

MES
1 2 3 4 5
Subtotal 0 1920 4080 3020 3200
0.13287 0 26 54 40 43
0.102176 0 25 52 39 41
0.0243 0 5 11 8 9
0.5 0 1920 4080 3020 3200
2.55 0 288 612 453 480
0.03 0 192000 408000 302000 320000
3.339346
MES
1 2 3 4 5
Subtotal 6900 9050 9550 10050 10400
0.11161 77 101 107 112 116
0.085824 74 97 102 108 112
0.0234 18 24 25 26 27
0.5 6900 9050 9550 10050 10400
1.0256 2760 3620 3820 4020 4160
0.0252 579600 760200 802200 844200 873600
1.771634
 MES
1 2 3 4 5
Subtotal 1200 2000 2150 3600 4350
0.05 1200 2000 2150 3600 4350
0.02 1200 2000 2150 3600 4350
0.0062499 25 42 45 75 91
1.152312 49 82 88 148 179
0.02 1200 2000 2150 3600 4350
0.01 1200 2000 2150 3600 4350
0.000606 0.24 0.40 0.43 0.73 0.88
0.06 36 60 65 108 131
0.000303 0.12 0.20 0.22 0.36 0.44
1.3194709
131.94709 MES
1 2 3 4 5
Subtotal 3200 2850 1600 2600 3450
0.05 3200 2850 1600 2600 3450
0.02 3200 2850 1600 2600 3450
0.0062499 67 59 33 54 72
1.1976 128 114 64 104 138
0.02 3200 2850 1600 2600 3450
0.01 3200 2850 1600 2600 3450
0.000606 0.65 0.58 0.32 0.53 0.70
0.06 96 86 48 78 104
0.000303 0.32 0.29 0.16 0.26 0.35
1.3647589
136.47589
MES
1 2 3 4 5
Subtotal 0 0 0 660 600
0.05 0 0 0 660 600
0.02 0 0 0 660 600
0.0062499 0 0 0 14 12
0.67864 0 0 0 26 24
0.02 0 0 0 660 600
0.01 0 0 0 660 600
0.000606 0 0 0 0.13 0.12
0.06 0 0 0 20 18
0.000303 0 0 0 0.07 0.06
0.8457989
84.57989

MES
1 2 3 4 5
Subtotal 28 36 38 40 42
11.2 11 14 15 16 17
36 33 43 46 48 50
9 55 72 76 80 83
 6 33 43 46 48 50
138 635 833 879 925 957
1.2 11 14 15 16 17
3.2 11 14 15 16 17
2.8 39 51 53 56 58
49 1932 2534 2674 2814 2912
256.4
25640
 MES
6 7 8 9 10 11 12
12900 12000 11900 11100 12400 16400 18000
171 159 158 147 165 218 239
165 153 152 142 158 209 230
35 32 32 30 33 44 49
12900 12000 11900 11100 12400 16400 18000
1935 1800 1785 1665 1860 2460 2700
1290000 1200000 1190000 1110000 1240000 1640000 1800000

MES
6 7 8 9 10 11 12
13900 12900 11900 11200 11880 1830 1890
185 171 158 149 158 24 25
178 153 152 143 152 23 24
38 32 32 30 32 5 5
13900 12000 11900 11200 11880 1830 1890
2085 1800 1785 1680 1782 275 284
1390000 1200000 1190000 1120000 1188000 183000 189000

MES
6 7 8 9 10 11 12
3200 3130 2500 2530 2810 2910 2700
43 42 33 34 37 39 36
41 40 32 32 36 37 34
9 8 7 7 8 8 7
3200 3130 2500 2530 2810 2910 2700
480 470 375 380 422 437 405
320000 313000 250000 253000 281000 291000 270000

MES
6 7 8 9 10 11 12
9200 6600 7450 7100 8150 9550 9000
103 74 83 79 91 107 100
99 71 80 76 87 102 97
24 17 19 18 21 25 23
9200 6600 7450 7100 8150 9550 9000
3680 2640 2980 2840 3260 3820 3600
772800 554400 625800 596400 684600 802200 756000
 MES
6 7 8 9 10 11 12
2950 2530 2820 3050 3550 4100 4500
2950 2530 2820 3050 3550 4100 4500
2950 2530 2820 3050 3550 4100 4500
61 53 59 64 74 85 94
121 104 116 126 146 169 185
2950 2530 2820 3050 3550 4100 4500
2950 2530 2820 3050 3550 4100 4500
0.60 0.51 0.57 0.62 0.72 0.83 0.91
89 76 85 92 107 123 135
0.30 0.26 0.28 0.31 0.36 0.41 0.45

MES
6 7 8 9 10 11 12
2880 1870 2550 3020 2920 410 450
2880 1870 2550 3020 2920 410 450
2880 2530 2550 3020 2920 410 450
60 53 53 63 61 9 9
115 101 102 121 117 16 18
2880 2530 2550 3020 2920 410 450
2880 2530 2550 3020 2920 410 450
0.58 0.51 0.52 0.61 0.59 0.08 0.09
86 76 77 91 88 12 14
0.29 0.26 0.26 0.31 0.29 0.04 0.05

MES
6 7 8 9 10 11 12
585 450 450 455 500 500 450
585 450 450 455 500 500 450
585 450 450 455 500 500 450
12 9 9 9 10 10 9
23 18 18 18 20 20 18
585 450 450 455 500 500 450
585 450 450 455 500 500 450
0.12 0.09 0.09 0.09 0.10 0.10 0.09
18 14 14 14 15 15 14
0.06 0.05 0.05 0.05 0.05 0.05 0.05

MES
6 7 8 9 10 11 12
37 26 30 28 33 38 36
15 11 12 11 13 15 14
44 32 36 34 39 46 43
74 53 60 57 65 76 72
 44 32 36 34 39 46 43
846 607 685 653 750 879 828
15 11 12 11 13 15 14
15 11 12 11 13 15 14
52 37 42 40 46 53 50
2576 1848 2086 1988 2282 2674 2520
determinamos la cantidad de insumos y materiales necesarios.

Inventario
Material/Insumo Inicial 1
Celofan Polypack con impresión Pimienta 30.00 97.00
Celofan Polypack con impresión Comino 40.00 164.76
Celofan Polypack con impresión Canela 20.00 0.00
Celofan Polypack con impresión Sazonador 50.00 77.01
Celofan Polypack delgado 64 mm 200.00 325.63
Manga SW 19.5 15.00 71.13
Carton Pimienta 1.5 gr 4000.00 7300.00
Carton Comino Negra 1.5 gr 3000.00 12400.00
Carton Canela 500.00 0.00
Caja Sazonador 2500.00 6900.00
Grapa 20.00 394.00
Envase de 40 gr 10000.00 4400.00
Etiqueta Pimienta 4000.00 1200.00
Etiqueta Comino 6000.00 3200.00
Etiqueta Canela 7000.00 0.00
Dispensador 30000.00 4400.00
Insertos 29000.00 4400.00
Cinta 500.00 0.89
Pegamento 100.00 132.00
Silicado 1.00 0.44
Outers 60.00 91.67
Aceite vegetal 300.00 55.20
Orégano molido 5.00 33.12
Achiote molido 10.00 634.80
Ají panca molido 12.00 11.04
Jengibre Molido 7.00 11.04
Semilla de culantro molido 10.00 38.64
Sal de cocina molida 700.00 1932.00
Pimienta negra molida 300 1155.42
Comino molido 400 2020.86
Canela Molida 180 0.00
Sazonador Preparado 800 2760.00

Inventario de Materiales e Insumos proyectado

Inventario
Material/Insumo Inicial 1
Celofan Polypack con impresión Pimienta 30.00 30.613248
Celofan Polypack con impresión Comino 40.00 30.613248
Celofan Polypack con impresión Canela 20.00 20
Celofan Polypack con impresión Sazonador 50.00 18.181269
Celofan Polypack delgado 64 mm 200.00 1
Manga SW 19.5 15.00 11.74008
Carton Pimienta 1.5 gr 4000.00 2304
Carton Comino Negra 1.5 gr 3000.00 2304
Carton Canela 500.00 500
Caja Sazonador 2500.00 1629
Grapa 20.00 66.048
Envase de 40 gr 10000.00 5600.00
Etiqueta Pimienta 4000.00 2800.00
Etiqueta Comino 6000.00 2800.00
Etiqueta Canela 7000.00 7000.00
Dispensador 30000.00 25600.00
Insertos 29000.00 24600.00
Cinta 500.00 499.11
Pegamento 100.00 17.46
Silicado 1.00 0.56
Outers 60.00 12.12
Aceite vegetal 300.00 244.80
Orégano molido 5.00 13.03
Achiote molido 10.00 249.78
Ají panca molido 12.00 4.34
Jengibre Molido 7.00 4.34
Semilla de culantro molido 10.00 15.20
Sal de cocina molida 700.00 760.20
Pimienta negra molida 300 605.04
Comino molido 400 623.16
Canela Molida 180 180.00
Sazonador Preparado 800 1086.00

realizamos el cálculo de insumos y materiales necesarios, considerando asimismo los inventarios mínimos q

Material/Insumo 1 2
Celofan Polypack con impresión Pimienta 97.61 166.96
Celofan Polypack con impresión Comino 155.37 166.96
Celofan Polypack con impresión Canela 0.00 15.27
Celofan Polypack con impresión Sazonador 45.19 102.01
Celofan Polypack delgado 64 mm 126.63 501.37
Manga SW 19.5 67.87 97.85
Carton Pimienta 1.5 gr 5604.00 12566.00
Carton Comino Negra 1.5 gr 11704.00 12566.00
Carton Canela 0.00 2154.40
Caja Sazonador 6029.00 9140.00
Grapa 440.05 549.34
Envase de 40 gr 0.00 0.00
Etiqueta Pimienta 0.00 -512.00
Etiqueta Comino 0.00 554.00
Etiqueta Canela 0.00 0.00
Dispensador 0.00 0.00
Insertos 0.00 0.00
Cinta 0.00 0.00
Pegamento 49.46 141.54
Silicado 0.00 0.00
Outers 43.79 98.29
Aceite vegetal 0.00 0.00
Orégano molido 41.15 44.16
Achiote molido 874.58 846.40
Ají panca molido 3.38 14.72
Jengibre Molido 8.38 14.72
Semilla de culantro molido 43.84 51.52
Sal de cocina molida 1992.20 2576.00
Pimienta negra molida 1460.46 1960.38
Comino molido 2244.03 2004.46
Canela Molida 0.00 291.60
Sazonador Preparado 3046.00 2534.00
 MES
2 3 4 5 6 7
170.07 152.80 217.91 256.44 171.40 159.44
170.07 152.80 220.56 281.68 184.69 171.40
25.51 54.21 40.13 42.52 42.52 41.59
101.01 106.59 112.17 116.07 102.68 73.66
448.57 448.32 567.86 669.71 481.86 417.31
97.83 97.95 123.38 145.03 104.92 90.41
12800.00 11500.00 16400.00 19300.00 12900.00 12000.00
12800.00 11500.00 16600.00 21200.00 13900.00 12000.00
1920.00 4080.00 3020.00 3200.00 3200.00 3130.00
9050.00 9550.00 10050.00 10400.00 9200.00 6600.00
550.40 541.60 720.40 874.00 600.00 542.60
4850.00 3750.00 6860.00 8400.00 6415.00 4850.00
2000.00 2150.00 3600.00 4350.00 2950.00 2530.00
2850.00 1600.00 2600.00 3450.00 2880.00 2530.00
0.00 0.00 660.00 600.00 585.00 450.00
4850.00 3750.00 6860.00 8400.00 6415.00 5510.00
4850.00 3750.00 6860.00 8400.00 6415.00 5510.00
0.98 0.76 1.39 1.70 1.30 1.11
145.50 112.50 205.80 252.00 192.45 165.30
0.49 0.38 0.69 0.85 0.65 0.56
101.04 78.12 142.91 175.00 133.64 114.79
72.40 76.40 80.40 83.20 73.60 52.80
43.44 45.84 48.24 49.92 44.16 31.68
832.60 878.60 924.60 956.80 846.40 607.20
14.48 15.28 16.08 16.64 14.72 10.56
14.48 15.28 16.08 16.64 14.72 10.56
50.68 53.48 56.28 58.24 51.52 36.96
2534.00 2674.00 2814.00 2912.00 2576.00 1848.00
2016.79 1828.76 2624.23 3090.66 2071.12 1914.68
2077.21 1834.71 2642.03 3367.64 2244.13 1932.68
288.00 612.00 479.35 503.95 503.35 487.46
3620.00 3820.00 4020.00 4160.00 3680.00 2640.00

MES
2 3 4 5 6 7
27.50409 39.223224 46.159038 30.852414 28.69992 28.460754
27.50409 39.701556 50.703192 33.244074 30.852414 28.460754
9.7579728 7.2228132 7.653312 7.653312 7.4858958 5.97915
19.185759 20.190249 20.893392 18.482616 13.259268 14.966901
 53.7981792 68.1436608 80.364912 57.822912 51.4564752 49.899264
11.75352 14.80608 17.4036 12.5904 10.84932 10.8456
2070 2952 3474 2322 2160 2142
2070 2988 3816 2502 2160 2142
734.4 543.6 576 576 563.4 450
1719 1809 1872 1656 1188 1341
64.992 86.448 104.88 72 65.112 63.12
750.00 823.20 1008.00 769.80 582.00 698.40
288.00 648.00 783.00 531.00 455.40 507.60
504.00 468.00 621.00 518.40 455.40 459.00
7000.00 7000.00 6340.00 5740.00 5155.00 4705.00
20750.00 17000.00 10140.00 1740.00 661.2 698.4
19750.00 16000.00 9140.00 740.00 769.80 661.20
498.13 497.37 495.99 494.29 493.00 491.88
13.50 24.70 30.24 23.09 19.84 20.95
0.07 0.08 0.10 0.08 0.07 0.07
9.37 17.15 21.00 16.04 13.77 14.55
172.40 96.00 24.96 22.08 15.84 17.88
13.75 14.47 14.98 13.25 9.50 10.73
263.58 277.38 287.04 253.92 182.16 205.62
4.58 4.82 4.99 4.42 3.17 3.58
4.58 4.82 4.99 4.42 3.17 3.58
16.04 16.88 17.47 15.46 11.09 12.52
802.20 844.20 873.60 772.80 554.40 625.80
548.63 787.27 927.20 621.34 574.40 573.89
550.41 792.61 1010.29 673.24 579.80 576.77
183.60 143.80 151.19 151.01 146.24 117.89

do asimismo los inventarios mínimos que se deben de mantener.

MES
3 4 5 6 7 8
164.52 224.84 241.13 169.25 159.20 156.20
165.00 231.57 264.23 182.30 169.01 156.44
51.68 40.56 42.52 42.35 40.08 33.29
107.59 112.87 113.66 97.46 75.37 82.45
462.66 580.09 647.17 475.49 415.75 413.12
101.00 125.98 140.22 103.18 90.41 89.79
12382.00 16922.00 18148.00 12738.00 11982.00 11756.00
12418.00 17428.00 19886.00 13558.00 11982.00 11774.00
3889.20 3052.40 3200.00 3187.40 3016.60 2505.40
9640.00 10113.00 10184.00 8732.00 6753.00 7387.00
563.06 738.83 841.12 593.11 540.61 522.47
3823.20 7044.80 8161.80 6227.20 4966.40 5904.60
2510.00 3735.00 4098.00 2874.40 2582.20 2861.40
1564.00 2753.00 3347.40 2817.00 2533.60 2634.60
 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 5336.20 5547.20 5904.60
0.00 0.00 0.00 6444.80 5401.40 5857.20
0.00 0.00 0.00 0.00 0.00 0.00
123.70 211.34 244.85 189.19 166.42 177.14
0.40 0.71 0.82 0.64 0.56 0.60
85.90 146.76 170.03 131.38 115.56 123.01
0.00 9.36 80.32 67.36 54.84 58.76
46.56 48.74 48.19 40.42 32.90 35.26
892.40 934.26 923.68 774.64 630.66 675.74
15.52 16.25 16.06 13.47 10.97 11.75
15.52 16.25 16.06 13.47 10.97 11.75
54.32 56.87 56.22 47.15 38.39 41.13
2716.00 2843.40 2811.20 2357.60 1919.40 2056.60
2067.40 2764.16 2784.80 2024.19 1914.17 1879.65
2076.91 2859.72 3030.59 2150.69 1929.64 1896.18
572.20 486.73 503.77 498.59 459.11 394.37
3820.00 4020.00 4160.00 3680.00 2640.00 2980.00
 8 9 10 11 12
158.12 147.49 164.76 217.91 239.17
158.12 148.81 157.85 24.32 25.11
33.22 33.62 37.34 38.67 35.87
83.15 79.24 90.96 106.59 100.45
415.83 393.30 433.43 372.45 385.07
90.38 85.50 94.33 81.91 84.39
11900.00 11100.00 12400.00 16400.00 18000.00
11900.00 11200.00 11880.00 1830.00 1890.00
2500.00 2530.00 2810.00 2910.00 2700.00
7450.00 7100.00 8150.00 9550.00 9000.00
526.00 496.60 541.80 422.80 451.80
5820.00 6525.00 6970.00 5010.00 5400.00
2820.00 3050.00 3550.00 4100.00 4500.00
2550.00 3020.00 2920.00 410.00 450.00
450.00 455.00 500.00 500.00 450.00
5820.00 6525.00 6970.00 5010.00 5400.00
5820.00 6525.00 6970.00 5010.00 5400.00
1.18 1.32 1.41 1.01 1.09
174.60 195.75 209.10 150.30 162.00
0.59 0.66 0.70 0.51 0.55
121.25 135.94 145.21 104.37 112.50
59.60 56.80 65.20 76.40 72.00
35.76 34.08 39.12 45.84 43.20
685.40 653.20 749.80 878.60 828.00
11.92 11.36 13.04 15.28 14.40
11.92 11.36 13.04 15.28 14.40
41.72 39.76 45.64 53.48 50.40
2086.00 1988.00 2282.00 2674.00 2520.00
1912.97 1801.88 2019.14 2644.01 2899.59
1922.56 1834.64 1937.69 336.71 344.66
392.96 397.66 441.46 456.46 422.96
2980.00 2840.00 3260.00 3820.00 3600.00

8 9 10 11
26.547426 29.656584 39.223224 43.04988
26.786592 28.4129208 4.3767378 4.5202374
6.0508998 6.7205646 6.9597306 6.457482
14.263758 16.373187 19.185759 18.08082
47.1957072 52.0112016 44.6942976 46.2085776
10.26012 11.31996 9.82896 10.12716
1998 2232 2952 3240
2016 2138.4 329.4 340.2
455.4 505.8 523.8 486
1278 1467 1719 1620
59.592 65.016 50.736 54.216
783.00 836.40 601.20 648.00
549.00 639.00 738.00 810.00
543.60 525.60 73.80 81.00
4255.00 3800.00 3300.00 2800.00
783 836.4 601.2 648
698.40 783.00 836.40 601.20
490.71 489.39 487.98 486.97
23.49 25.09 18.04 19.44
0.08 0.08 0.06 0.07
16.31 17.42 12.52 13.50
17.04 19.56 22.92 21.60
10.22 11.74 13.75 12.96
195.96 224.94 263.58 248.40
3.41 3.91 4.58 4.32
3.41 3.91 4.58 4.32
11.93 13.69 16.04 15.12
596.40 684.60 802.20 756.00
540.56 605.74 793.20 869.88
550.39 581.31 101.01 103.40
119.30 132.44 136.94 126.89

9 10 11 12
150.59 174.33 221.73 196.12
150.44 133.81 24.46 20.59
34.29 37.58 38.16 29.42
81.35 93.77 105.48 82.37
398.11 426.11 373.97 338.86
86.56 92.84 82.21 74.27
11334.00 13120.00 16688.00 14760.00
11322.40 10071.00 1840.80 1549.80
2580.40 2828.00 2872.20 2214.00
7289.00 8402.00 9451.00 7380.00
502.02 527.52 426.28 397.58
6578.40 6734.80 5056.80 4752.00
3140.00 3649.00 4172.00 3690.00
3002.00 2468.20 417.20 369.00
 0.00 0.00 0.00 -2350.00
6578.40 6734.80 5056.80 4752.00
6609.60 7023.40 4774.80 4798.80
0.00 0.00 0.00 -485.88
197.35 202.04 151.70 142.56
0.66 0.68 0.51 0.48
137.05 140.31 105.35 99.00
59.32 68.56 75.08 50.40
35.59 41.14 45.05 30.24
682.18 788.44 863.42 579.60
11.86 13.71 15.02 10.08
11.86 13.71 15.02 10.08
41.52 47.99 52.56 35.28
2076.20 2399.60 2627.80 1764.00
1867.06 2206.60 2720.69 2029.72
1865.55 1457.39 339.09 241.26
410.80 445.96 446.41 296.07
2840.00 3260.00 3820.00 3600.00
Costo de Materiales/Insumos
Materiales
Celofan con impresión "PIMIENTA"
Celofan con impresión "COMINO"
Celofan con impresión "CANELA"
Celofan con impresión "SAZONADOR"
Celofan delgado 64 mm.
Celofan Manga S. W.19,5
Carton Pimienta Negra 1.5 gr
Carton Comino 1.5 gr
Carton Canela 1.5 gr
Carton Sazonador 4 gr
Grapas 26/6
Envase 40 gr
Etiqueta Pimienta Negra 40 gr
Etiqueta Comino 40 gr
Etiqueta Canela 40 gr
Dispensador p/40 gr
Insertos p/40 gr
Cinta Engomada
Pegamento
Silicato sodio neutro
Outer 40 gr
Aceite vegetal
Orégano molido
Achiote molido
Aji panca molido
Jenjibre (Kión) molido
Semilla de Culantro Molido
Sal de cocina molida
Pimienta negra molida
Comino molido
Canela Molida
Sazonador Preparado

cálculo del plan de adquisiciones en importe, utilizando los precios

Material/Insumo
Celofán Polypack con PIMIENTA
Celofán Polypack delgado 64mm
Manga S.W. 19.5
Cartón Pimienta Negra 1.5 gr
Celofán Polypack con COMINO
Cartón Comino 1.5 gr
Celofán Polypack con CANELA
Cartón Canela 1.5 gr
Celofán Polypack con SAZONADOR
Cartón Sazonador 4 gr
Envase para 40 gr
Etiqueta Pimienta Negra 40 gr
Etiqueta Pimienta Comino 40 gr
Etiqueta Pimienta Canela 40 gr
Outers para 40 gr
Pimienta negra molida
Comino Molido
Canela molida
Dispensador para 40 gr TAL
Insertos para 40 gr TAL
Cinta engomada
Pegamento Purycola
Silicato sodio neutro/MGO
Aceite vegetal
Orégano molido
Achiote molido
Ají panca molido
Jengibre Molido
Semilla de culantro molido
Sal de cocina molida
Grapas 26/6
 Cantidad Un.Medida Costo unit
30 kg. 10
40 kg. 10
20 kg. 10
50 kg. 10
200 kg. 8
15 kg. 9
4000 Unidad 0.5
3000 Unidad 0.5
500 Unidad 0.5
2500 Unidad 0.5
20 Cajas x 5000 1.5
10000 Unidad 0.05
4000 Unidad 0.02
6000 Unidad 0.02
7000 Unidad 0.02
30000 Unidad 0.02
29000 Unidad 0.01
500 kg. 3
100 kg. 2
1 kg. 3
60 Unidad 0.3
300 litros 4.5
5 Kg 5
10 Kg 6
12 Kg 3
7 Kg 8
10 Kg 2
700 Kg 0.7
300 Kg 28
400 Kg 30
180 Kg 17
800 Kg 2.564

importe, utilizando los precios brindados en el caso:

MES
1 2 3 4 5 6
976.08 1669.64 1645.20 2248.43 2411.32 1692.50
1553.72 1669.64 1649.98 2315.66 2642.25 1822.98
0.00 152.69 516.76 405.57 425.18 423.51
451.92 1020.12 1075.92 1128.71 1136.64 974.58
1013.05 4010.98 3701.31 4640.68 5177.32 3803.93
610.83 880.63 908.99 1133.83 1261.95 928.61
2802.00 6283.00 6191.00 8461.00 9074.00 6369.00
 5852.00 6283.00 6209.00 8714.00 9943.00 6779.00
0.00 1077.20 1944.60 1526.20 1600.00 1593.70
3014.50 4570.00 4820.00 5056.50 5092.00 4366.00
660.07 824.02 844.58 1108.25 1261.68 889.67
0.00 0.00 191.16 352.24 408.09 311.36
0.00 0.00 50.20 74.70 81.96 57.49
0.00 11.08 31.28 55.06 66.95 56.34
0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00 106.72
0.00 0.00 0.00 0.00 0.00 64.45
0.00 0.00 0.00 0.00 0.00 0.00
98.92 283.08 247.39 422.69 489.71 378.38
0.00 0.00 1.19 2.13 2.47 1.91
13.14 29.49 25.77 44.03 51.01 39.41
0.00 0.00 0.00 42.12 361.44 303.12
205.76 220.80 232.80 243.72 240.96 202.08
5247.48 5078.40 5354.40 5605.56 5542.08 4647.84
10.15 44.16 46.56 48.74 48.19 40.42
67.07 117.76 124.16 129.98 128.51 107.78
87.69 103.04 108.64 113.74 112.45 94.30
1394.54 1803.20 1901.20 1990.38 1967.84 1650.32
40892.91 54890.64 57887.29 77396.54 77974.38 56677.35
67320.83 60133.86 62307.24 85791.47 90917.69 64520.82
0.00 4957.20 9727.47 8274.39 8564.13 8475.97
MES
7 8 9 10 11 12
1592.05 1562.02 1505.95 1743.25 2217.33 1961.16
1690.11 1564.41 1504.41 1338.13 244.59 205.92
400.82 332.89 342.86 375.76 381.63 294.17
753.70 824.46 813.53 937.75 1054.83 823.68
3326.02 3304.99 3184.90 3408.88 2991.73 2710.90
813.67 808.15 779.05 835.58 739.86 668.39
5991.00 5878.00 5667.00 6560.00 8344.00 7380.00
 5991.00 5887.00 5661.20 5035.50 920.40 774.90
1508.30 1252.70 1290.20 1414.00 1436.10 1107.00
3376.50 3693.50 3644.50 4201.00 4725.50 3690.00
810.91 783.71 753.04 791.28 639.42 596.38
248.32 295.23 328.92 336.74 252.84 237.60
51.64 57.23 62.80 72.98 83.44 73.80
50.67 52.69 60.04 49.36 8.34 7.38
0.00 0.00 0.00 0.00 0.00 0.00
110.94 118.09 131.57 134.70 101.14 95.04
54.01 58.57 66.10 70.23 47.75 47.99
0.00 0.00 0.00 0.00 0.00 0.00
332.83 354.28 394.70 404.09 303.41 285.12
1.68 1.79 1.99 2.04 1.53 1.44
34.67 36.90 41.11 42.09 31.60 29.70
246.78 264.42 266.94 308.52 337.86 226.80
164.52 176.28 177.96 205.68 225.24 151.20
3783.96 4054.44 4093.08 4730.64 5180.52 3477.60
32.90 35.26 35.59 41.14 45.05 30.24
87.74 94.02 94.91 109.70 120.13 80.64
76.78 82.26 83.05 95.98 105.11 70.56
1343.58 1439.62 1453.34 1679.72 1839.46 1234.80
53596.70 52630.09 52277.59 61784.78 76179.20 56832.02
57889.23 56885.42 55966.58 43721.78 10172.83 7237.94
7804.94 6704.36 6983.64 7581.32 7588.99 5033.27