Programa Ma

Jabonería el Pacífico, para su línea de productos jabón uso doméstico requiere elaborar el P

Proyección de venta
SKU Ene Feb Mar
Jabón (toneladas) 2,640 2,950 3,150
gr/pieza
Presentación Unidad pzas /caja peso (gr)
Jabón Trome 95 g caja 24 95.000
Jabón Trome 180 g caja 18 180.000
Jabón Trome 250 g caja 12 250.000
Jabón Jumbo 250 g caja 12 250.000
Jabón Jumbo 500 g caja 10 500.000
Jabón Bolivar 250 g caja 12 250.000
Jabón Bolivar 500 g caja 10 500.000
Jabón Marsella 250 g caja 12 250.000
Jabón Marsella 500 g caja 10 500.000

Pronóstico de Enero 2027

Presentación Unidad Cant (cajas)

Jabón Trome 95 g caja 55,400
Jabón Trome 180 g caja 35,000
Jabón Trome 250 g caja 55,000
Jabón Jumbo 250 g caja 67,000
Jabón Jumbo 500 g caja 71,000
Jabón Bolivar 250 g caja 85,000
Jabón Bolivar 500 g caja 91,400
Jabón Marsella 250 g caja 114,000
Jabón Marsella 500 g caja 85,000

Capacidad de planta

Capacidad de planta 3,300.00 toneladas/mes

Lote Minimo 3,500 cajas/corrida
Cambios de producción 2.00 productos/dia

Fórmula (componentes)
Producto (Presentación) Kilos/fórmula
Jabón Trome 8.52
Jabón Jumbo 8.00
Jabón Bolivar 8.00
Jabón Marsella 8.00
 Horas - Hombre por tonelada
Presentación H-H / TM
Jabón Trome 95 g 28.00
Jabón Trome 180 g 30.00
Jabón Trome 250 g 18.00
Jabón Jumbo 250 g 18.00
Jabón Jumbo 500 g 14.00
Jabón Bolivar 250 g 18.00
Jabón Bolivar 500 g 14.00
Jabón Marsella 250 g 18.00
Jabón Marsella 500 g 14.00

Programas de Despachos

La demanda de los depachos programados para el Febrero, Marzo 3 y Abril 4 se da de la siguiente manera, au
, disminucion del 4.5% y aumento de 7.6% de todos los SKUs con respecto al cuadro de la semana 1

ENERO
Presentación 1 2 3
Jabón Trome 95 g 35% 0% 35%
Jabón Trome 180 g 30% 35% 0%
Jabón Trome 250 g 25% 25% 25%
Jabón Jumbo 250 g 25% 20% 25%
Jabón Jumbo 500 g 20% 25% 30%
Jabón Bolivar 250 g 25% 25% 25%
Jabón Bolivar 500 g 0% 30% 40%
Jabón Marsella 250 g 30% 30% 30%
Jabón Marsella 500 g 15% 20% 30%

2.- Niveles de Inventario y politicas de seguridad

(Cajas)
Presentación Stock (cajas) SS
Jabón Trome 95 g 2,500 4,796
Jabón Trome 180 g 1,800 3,030
Jabón Trome 250 g 2,400 4,761
Jabón Jumbo 250 g 1,600 5,800
Jabón Jumbo 500 g 2,460 6,146
Jabón Bolivar 250 g 3,700 7,358
Jabón Bolivar 500 g 4,500 7,912
Jabón Marsella 250 g 3,800 9,869
Jabón Marsella 500 g 2,600 7,358

Elaborar el PMP por SKU por todos los componente a nivel de semana y dias

Solucion:
CAJAS

Producto (Presentación) Demanda SS S Inicial

Jabón Trome 95 g 55,400 4,796.00 2,500.00
Jabón Trome 180 g 35,000 3,030.00 1,800.00
Jabón Trome 250 g 55,000 4,761.00 2,400.00
Jabón Jumbo 250 g 67,000 5,800.00 1,600.00
Jabón Jumbo 500 g 71,000 6,146.00 2,460.00
Jabón Bolivar 250 g 85,000 7,358.00 3,700.00
Jabón Bolivar 500 g 91,400 7,912.00 4,500.00
Jabón Marsella 250 g 114,000 9,869.00 3,800.00
Jabón Marsella 500 g 85,000 7,358.00 2,600.00

Programa mensual por presentaciones (cajas)

Producto (Presentación) 1 2 3
Jabón Trome 95 g 14,424.00 14,424.00 14,424.00
Jabón Trome 180 g 9,057.50 9,057.50 9,057.50
Jabón Trome 250 g 14,340.25 14,340.25 14,340.25
Jabón Jumbo 250 g 17,800.00 17,800.00 17,800.00
Jabón Jumbo 500 g 18,671.50 18,671.50 18,671.50
Jabón Bolivar 250 g 22,164.50 22,164.50 22,164.50
Jabón Bolivar 500 g 23,703.00 23,703.00 23,703.00
Jabón Marsella 250 g 30,017.25 30,017.25 30,017.25
Jabón Marsella 500 g 22,439.50 22,439.50 22,439.50
Total TM 639.27 639.27 639.27

Producto (Presentación) 1 2 3
Jabón Trome 95 g 16,890.00 11,958.00 14,424.00
Jabón Trome 180 g 9,057.50 11,892.50 6,222.50
Jabón Trome 250 g 14,340.25 14,340.25 14,340.25
Jabón Jumbo 250 g 17,800.00 17,800.00 17,800.00
Jabón Jumbo 500 g 18,671.50 18,671.50 18,671.50
Jabón Bolivar 250 g 22,164.50 22,164.50 22,164.50
Jabón Bolivar 500 g 23,703.00 23,703.00 23,703.00
Jabón Marsella 250 g 30,400.00 34,200.25 34,200.25
Jabón Marsella 500 g 22,439.50 22,439.50 22,439.50
Total TM 646.04 655.38 642.63
 -6.77 -16.11 -3.36
toneladas
Producto (Presentación) 1 2 3
Jabón Trome 95 g 16,890.00 11,958.00 14,424.00
Jabón Trome 180 g 9,057.50 11,892.50 6,222.50
Jabón Trome 250 g 14,340.25 14,340.25 14,340.25
Jabón Jumbo 250 g 17,800.00 17,800.00 17,800.00
Jabón Jumbo 500 g 18,671.50 18,671.50 18,671.50
Jabón Bolivar 250 g 22,164.50 22,164.50 22,164.50
Jabón Bolivar 500 g 22,348.85 20,480.62 23,030.28
Jabón Marsella 250 g 30,400.00 34,200.25 34,200.25
Jabón Marsella 500 g 22,439.50 22,439.50 22,439.50
Total TM 639.27 639.27 639.27
0.0000 0.0000 0.0000
0.0000 0.0000 0.0000

Presentación L M M
Jabón Trome 95 g 5630.00 5630.00
Jabón Trome 180 g 5706.36 331.97
Jabón Trome 250 g 4780.08 4780.08
Jabón Jumbo 250 g 5,933.33 5,933.33
Jabón Jumbo 500 g 8,615.91 4,189.13
Jabón Bolivar 250 g 7,388.17
Jabón Bolivar 500 g 11,225.62
Jabón Marsella 250 g 10,133.33
Jabón Marsella 500 g 7,479.83
Total TM 106.545 106.545 106.545
106.545 106.545 106.545
0.000000 0.000000 0.000000
0.000000 0.000000 0.000000

Producto (Presentación) L M M
Jabón Trome 5,359.77 0.00 3,315.99
Jabón Jumbo 7,609.95 4,843.21 0.00
Jabón Bolivar 0.00 0.00 9,786.58
Jabón Marsella 0.00 8,474.90 0.00
 Programa Maestro de la Producción
oméstico requiere elaborar el PMP a partir de la siguiente información que se detallan a continuación:

Proyección de ventas para el año 2027 por SKU (toneladas)

Abr May Jun Jul
3,050 3,085 2,970 3,170

peso/caja (gr) peso/caja (kg)

2,280.00 2.28
3,240.00 3.24
3,000.00 3.00
3,000.00 3.00
5,000.00 5.00
3,000.00 3.00
5,000.00 5.00
3,000.00 3.00
5,000.00 5.00

LA PROGRAMACION POR DIA QUEDA AL CRIT

Turnos de trabajo
Turnos (orden) Periodo L
1.00 07 - 03 p.m
2.00 03 - 11 p.m
3.00 11 - 07 a.m
ril 4 se da de la siguiente manera, aumento de 2%
to al cuadro de la semana 1

NERO
4 Total Presentación
30% 100% Jabón Trome 95 g
35% 100% Jabón Trome 180 g
25% 100% Jabón Trome 250 g
30% 100% Jabón Jumbo 250 g
25% 100% Jabón Jumbo 500 g
25% 100% Jabón Bolivar 250 g
30% 100% Jabón Bolivar 500 g
10% 100% Jabón Marsella 250 g
35% 100% Jabón Marsella 500 g
vel de semana y dias

CAJAS

Produccion Prod (kg) Kg/Formula Formula

57,696 131,546.88 8.52 15,439.77
36,230 117,385.20 8.52 13,777.61
57,361 172,083.00 8.52 20,197.54
71,200 213,600.00 8.00 26,700.00
74,686 373,430.00 8.00 46,678.75
88,658 265,974.00 8.00 33,246.75
94,812 474,060.00 8.00 59,257.50
120,069 360,207.00 8.00 45,025.88
89,758 448,790.00 8.00 56,098.75

4 Total 1
14,424.00 57,696 -2,466.00
9,057.50 36,230 357.50
14,340.25 57,361 2,990.25
17,800.00 71,200 2,650.00
18,671.50 74,686 6,931.50
22,164.50 88,658 4,614.50
23,703.00 94,812 28,203.00
30,017.25 120,069 -382.75
22,439.50 89,758 12,289.50
639.27 2,557.08

4 Total 1
14,424.00 57,696 0.00
9,057.50 36,230 357.50
14,340.25 57,361 2,990.25
17,800.00 71,200 2,650.00
18,671.50 74,686 6,931.50
22,164.50 88,658 4,614.50
23,703.00 94,812 28,203.00
21,268.50 120,069 0.00
22,439.50 89,758 12,289.50
613.02 2,557.08
 26.25

4 Total 1
14,424.00 57,696 0.00000 0.00
9,057.50 36,230 0.00000 357.50
14,340.25 57,361 0.00000 2,990.25
17,800.00 71,200 0.00000 2,650.00
18,671.50 74,686 0.00000 6,931.50
22,164.50 88,658 0.00000 4,614.50
28,952.25 94,812 0.00000 26,848.85
21,268.50 120,069 0.00000 0.00
22,439.50 89,758 0.00000 12,289.50
639.27 2,557.08
0.0000
0.0000
Capacidad de planta 3,300.00
Lote Minimo 3,500
Cambios de producci 2.00

J V S Total
5630.00 16890.00
3019.17 9057.50
4780.08 14340.25
5,933.33 17800.00
5,866.45 18671.50
7,388.17 7,388.17 22164.50
3,673.62 7,449.62 22348.86
9,537.69 10,728.97 30400.00
7,479.83 7,479.83 22439.50
106.545 106.545 106.545 639.27
106.545 106.545 106.545 639.27
0.000000 0.000000 0.000000
0.000000 0.000000 0.000000

J V S Total
0.00 0.00 4,337.88 13,013.64
0.00 5,891.53 0.00 18,344.69
5,066.57 7,426.57 0.00 22,279.72
8,251.53 0.00 8,698.26 25,424.69
ción 2010-1 UPN EF

ue se detallan a continuación:

SKU (toneladas)
Ago Sep Oct Nov Dic
2,960 2,780 2,710 2,640 2,935

AMACION POR DIA QUEDA AL CRITERIO DE CADA GRUPO

L L L L L
1 2 3 4 Total
19,390.00 0.00 19,390.00 16,620.00 55,400.00
10,500.00 12,250.00 0.00 12,250.00 35,000.00
13,750.00 13,750.00 13,750.00 13,750.00 55,000.00
16,750.00 13,400.00 16,750.00 20,100.00 67,000.00
14,200.00 17,750.00 21,300.00 17,750.00 71,000.00
21,250.00 21,250.00 21,250.00 21,250.00 85,000.00
0.00 27,420.00 36,560.00 27,420.00 91,400.00
34,200.00 34,200.00 34,200.00 11,400.00 114,000.00
12,750.00 17,000.00 25,500.00 29,750.00 85,000.00
2 3 4
11,958.00 6,992.00 4,796
-2,835.00 6,222.50 3,030
3,580.50 4,170.75 4,761
7,050.00 8,100.00 5,800
7,853.00 5,224.50 6,146
5,529.00 6,443.50 7,358
24,486.00 11,629.00 7,912
-4,565.50 -8,748.25 9,869
17,729.00 14,668.50 7,358

2 3 4
11,958.00 6,992.00 4,796.00
0.00 6,222.50 3,030.00
3,580.50 4,170.75 4,761.00
7,050.00 8,100.00 5,800.00
7,853.00 5,224.50 6,146.00
5,529.00 6,443.50 7,358.00
24,486.00 11,629.00 7,912.00
0.25 0.50 9,869.00
17,729.00 14,668.50 7,358.00
 2 3 4 S inicial
11,958.00 6,992.00 4,796.00 4,796.00
0.00 6,222.50 3,030.00 3,030.00
3,580.50 4,170.75 4,761.00 4,761.00
7,050.00 8,100.00 5,800.00 5,800.00
7,853.00 5,224.50 6,146.00 6,146.00
5,529.00 6,443.50 7,358.00 7,358.00
19,909.47 6,379.75 7,912.00 7,912.00
0.25 0.50 9,869.00 9,869.00
17,729.00 14,668.50 7,358.00 7,358.00

toneladas/mes 825.00 toneladas/sem 137.50 toneladas/día

cajas/corrida
productos/dia

0.00 5,630.00
0.00 3,019.17
0.00 4,780.08
0.00 5,933.33
0.00 6,223.83
0.00 7,388.17
0.00 7,449.62
0.00 10,133.33
0.00 7,479.83
0.00
010-1 UPN EF
ENERO f m a
55,400 56,508.00 52,907.0 59,610.40
35,000 35,700.00 33,425.0 37,660.00
55,000 56,100.00 52,525.0 59,180.00
67,000 68,340.00 63,985.0 72,092.00
71,000 72,420.00 67,805.0 76,396.00
85,000 86,700.00 81,175.0 91,460.00
91,400 93,228.00 87,287.0 98,346.40
114,000 116,280.00 108,870.0 122,664.00
85,000 86,700.00 81,175.0 91,460.00
neladas/día
 Programa Ma
Jabonería el Pacífico, para su línea de productos jabón uso doméstico requiere elaborar el P

Proyección de venta
SKU Ene Feb Mar
Jabón (toneladas) 2,640 2,950 3,150
gr/pieza
Presentación Unidad pzas /caja peso (gr)
Jabón Trome 95 g caja 24 95.000
Jabón Trome 180 g caja 18 180.000
Jabón Trome 250 g caja 12 250.000
Jabón Jumbo 250 g caja 12 250.000
Jabón Jumbo 500 g caja 10 500.000
Jabón Bolivar 250 g caja 12 250.000
Jabón Bolivar 500 g caja 10 500.000
Jabón Marsella 250 g caja 12 250.000
Jabón Marsella 500 g caja 10 500.000

Pronóstico de Enero 2027

Presentación Unidad Cant (cajas)

Jabón Trome 95 g caja 55,400
Jabón Trome 180 g caja 35,000
Jabón Trome 250 g caja 55,000
Jabón Jumbo 250 g caja 67,000
Jabón Jumbo 500 g caja 71,000
Jabón Bolivar 250 g caja 85,000
Jabón Bolivar 500 g caja 91,400
Jabón Marsella 250 g caja 114,000
Jabón Marsella 500 g caja 85,000

Capacidad de planta

Capacidad de planta 3,300.00 toneladas/mes

Lote Minimo 3,500 cajas/corrida
Cambios de producción 2.00 productos/dia

Fórmula (componentes)
Producto (Presentación) Kilos/fórmula
Jabón Trome 8.52
Jabón Jumbo 8.00
Jabón Bolivar 8.00
Jabón Marsella 8.00
 Horas - Hombre por tonelada
Presentación H-H / TM
Jabón Trome 95 g 28.00
Jabón Trome 180 g 30.00
Jabón Trome 250 g 18.00
Jabón Jumbo 250 g 18.00
Jabón Jumbo 500 g 14.00
Jabón Bolivar 250 g 18.00
Jabón Bolivar 500 g 14.00
Jabón Marsella 250 g 18.00
Jabón Marsella 500 g 14.00

Programas de Despachos

La demanda de los depachos programados para el Febrero, Marzo 3 y Abril 4 se da de la siguiente manera, au
, disminucion del 4.5% y aumento de 7.6% de todos los SKUs con respecto al cuadro de la semana 1

ENERO
Presentación 1 2 3
Jabón Trome 95 g 35% 0% 35%
Jabón Trome 180 g 30% 35% 0%
Jabón Trome 250 g 25% 25% 25%
Jabón Jumbo 250 g 25% 20% 25%
Jabón Jumbo 500 g 20% 25% 30%
Jabón Bolivar 250 g 25% 25% 25%
Jabón Bolivar 500 g 0% 30% 40%
Jabón Marsella 250 g 30% 30% 30%
Jabón Marsella 500 g 15% 20% 30%

2.- Niveles de Inventario y politicas de seguridad

(Cajas)
Presentación Stock (cajas) SS
Jabón Trome 95 g 2,500 4,796
Jabón Trome 180 g 1,800 3,030
Jabón Trome 250 g 2,400 4,761
Jabón Jumbo 250 g 1,600 5,800
Jabón Jumbo 500 g 2,460 6,146
Jabón Bolivar 250 g 3,700 7,358
Jabón Bolivar 500 g 4,500 7,912
Jabón Marsella 250 g 3,800 9,869
Jabón Marsella 500 g 2,600 7,358

Elaborar el PMP por SKU por todos los componente a nivel de semana y dias

Solucion:
CAJAS

Producto (Presentación) Demanda SS S Inicial

Jabón Trome 95 g 56,508 6,300.64 4,796.00
Jabón Trome 180 g 35,700 3,980.55 3,030.00
Jabón Trome 250 g 56,100 6,255.15 4,761.00
Jabón Jumbo 250 g 68,340 7,619.91 5,800.00
Jabón Jumbo 500 g 72,420 8,074.83 6,146.00
Jabón Bolivar 250 g 86,700 9,667.05 7,358.00
Jabón Bolivar 500 g 93,228 10,394.92 7,912.00
Jabón Marsella 250 g 116,280 12,965.22 9,869.00
Jabón Marsella 500 g 86,700 9,667.05 7,358.00

Programa mensual por presentaciones (cajas)

Producto (Presentación) 1 2 3
Jabón Trome 95 g 14,503.16 14,503.16 14,503.16
Jabón Trome 180 g 9,162.64 9,162.64 9,162.64
Jabón Trome 250 g 14,398.54 14,398.54 14,398.54
Jabón Jumbo 250 g 17,539.98 17,539.98 17,539.98
Jabón Jumbo 500 g 18,587.21 18,587.21 18,587.21
Jabón Bolivar 250 g 22,252.26 22,252.26 22,252.26
Jabón Bolivar 500 g 23,927.73 23,927.73 23,927.73
Jabón Marsella 250 g 29,844.06 29,844.06 29,844.06
Jabón Marsella 500 g 22,252.26 22,252.26 22,252.26
Total TM 638.69 638.69 638.69

Producto (Presentación) 1 2 3
Jabón Trome 95 g 14,981.80 14,503.16 14,503.16
Jabón Trome 180 g 9,162.64 11,012.36 9,162.64
Jabón Trome 250 g 14,398.54 14,398.54 14,398.54
Jabón Jumbo 250 g 17,539.98 17,539.98 17,539.98
Jabón Jumbo 500 g 18,587.21 18,587.21 18,587.21
Jabón Bolivar 250 g 22,252.26 22,252.26 22,252.26
Jabón Bolivar 500 g 23,927.73 23,927.73 23,927.73
Jabón Marsella 250 g 29,844.06 30,054.95 34,884.01
Jabón Marsella 500 g 22,252.26 22,252.26 22,252.26
Total TM 639.79 645.32 653.81
 -1.09 -6.63 -15.12
toneladas
Producto (Presentación) 1 2 3
Jabón Trome 95 g 14,981.80 14,503.16 14,503.16
Jabón Trome 180 g 9,162.64 11,012.36 9,162.64
Jabón Trome 250 g 14,398.54 14,398.54 14,398.54
Jabón Jumbo 250 g 17,539.98 17,539.98 17,539.98
Jabón Jumbo 500 g 18,587.21 18,587.21 18,587.21
Jabón Bolivar 250 g 22,252.26 22,252.26 17,212.31
Jabón Bolivar 500 g 23,709.47 22,602.57 23,927.73
Jabón Marsella 250 g 29,844.06 30,054.95 34,884.01
Jabón Marsella 500 g 22,252.26 22,252.26 22,252.26
Total TM 638.69 638.69 638.69
0.0000 0.0000 0.0000
0.000000 0.000000 0.000000

137.50

Presentación L M M
Jabón Trome 95 g 4993.93 4993.93
Jabón Trome 180 g 4238.66 3054.21
Jabón Trome 250 g 4799.51 4799.51
Jabón Jumbo 250 g 5846.66
Jabón Jumbo 500 g 6195.74
Jabón Bolivar 250 g 7417.42
Jabón Bolivar 500 g 9703.30
Jabón Marsella 250 g 9948.02 6947.78
Jabón Marsella 500 g 7417.42 7417.42
Total TM 106.449 106.449 106.449
106.449 106.449 106.449
0.000000 0.000000 0.000000
0.000000 0.000000 0.000000

Presentación L M M
Jabón Trome 95 g 4994.00 0.00 4994.00
Jabón Trome 180 g 4239.00 0.00 3054.00
Jabón Trome 250 g 4800.00 0.00 4800.00
Jabón Jumbo 250 g 0.00 5847.00 0.00
Jabón Jumbo 500 g 0.00 6196.00 0.00
Jabón Bolivar 250 g 0.00 0.00 7418.00
Jabón Bolivar 500 g 0.00 0.00 9703.00
Jabón Marsella 250 g 9948.00 6948.00 0.00
Jabón Marsella 500 g 7417.00 7417.00 0.00
Total TM 106.450 106.450 106.450
 Presentación L M M
Jabón Trome 95 g 4834.39 4834.39
Jabón Trome 180 g 4285.84 3670.79
Jabón Trome 250 g 4799.51 4799.51
Jabón Jumbo 250 g 5846.66
Jabón Jumbo 500 g 6195.74
Jabón Bolivar 250 g 7417.42
Jabón Bolivar 500 g 9376.51
Jabón Marsella 250 g 10018.32 6947.78
Jabón Marsella 500 g 7417.42 7417.42
Total TM 106.449 106.449 106.449
106.449 106.449 106.449
0.00 0.00 0.00
0.00000 0.00000 0.00000

Presentación L M M
Jabón Trome 95 g 4835.00 0.00 4835.00
Jabón Trome 180 g 4286.00 0.00 3670.00
Jabón Trome 250 g 4800.00 0.00 4800.00
Jabón Jumbo 250 g 0.00 5847.00 0.00
Jabón Jumbo 500 g 0.00 6196.00 0.00
Jabón Bolivar 250 g 0.00 0.00 7418.00
Jabón Bolivar 500 g 0.00 0.00 9376.00
Jabón Marsella 250 g 10018.00 6948.00 0.00
Jabón Marsella 500 g 7417.00 7417.00 0.00
Total TM 106.449 106.450 106.449

Presentación L M M
Jabón Trome 95 g 4834.39 4834.39
Jabón Trome 180 g 2795.39 3054.21
Jabón Trome 250 g 4799.51 4799.51
Jabón Jumbo 250 g 5846.66
Jabón Jumbo 500 g 6195.74
Jabón Bolivar 250 g 5737.44
Jabón Bolivar 500 g 10784.04
Jabón Marsella 250 g 11628.00 6947.78
Jabón Marsella 500 g 7417.42 7417.42
Total TM 106.449 106.449 106.449
106.449 106.449 106.449
0.00 0.00 0.00
0.00000 0.00000 0.00000
 Presentación L M M
Jabón Trome 95 g 4835.00 0.00 4835.00
Jabón Trome 180 g 2796.00 0.00 3054.00
Jabón Trome 250 g 4800.00 0.00 4800.00
Jabón Jumbo 250 g 0.00 5847.00 0.00
Jabón Jumbo 500 g 0.00 6196.00 0.00
Jabón Bolivar 250 g 0.00 0.00 5738.00
Jabón Bolivar 500 g 0.00 0.00 10784.00
Jabón Marsella 250 g 11628.00 6948.00 0.00
Jabón Marsella 500 g 7417.00 7417.00 0.00
Total TM 106.452 106.450 106.453

Presentación L M M
Jabón Trome 95 g 4674.84 4674.84
Jabón Trome 180 g 4683.83 2437.64
Jabón Trome 250 g 4799.51 4799.51
Jabón Jumbo 250 g 5846.66
Jabón Jumbo 500 g 6195.74
Jabón Bolivar 250 g 9097.40
Jabón Bolivar 500 g 9240.36
Jabón Marsella 250 g 9709.74 6947.78
Jabón Marsella 500 g 7417.42 7417.42
Total TM 106.449 106.449 106.449
106.449 106.449 106.449
0.00 0.00 0.00
0.00000 0.00000 0.00000

Presentación L M M
Jabón Trome 95 g 4675.00 0.00 4675.00
Jabón Trome 180 g 4684.00 0.00 2437.00
Jabón Trome 250 g 4800.00 0.00 4800.00
Jabón Jumbo 250 g 0.00 5847.00 0.00
Jabón Jumbo 500 g 0.00 6196.00 0.00
Jabón Bolivar 250 g 0.00 0.00 9098.00
Jabón Bolivar 500 g 0.00 0.00 9240.00
Jabón Marsella 250 g 9709.00 6948.00 0.00
Jabón Marsella 500 g 7417.00 7417.00 0.00
Total TM 106.447 106.450 106.449
 Programa Maestro de la Producción
oméstico requiere elaborar el PMP a partir de la siguiente información que se detallan a continuación:

Proyección de ventas para el año 2027 por SKU (toneladas)

Abr May Jun Jul
3,050 3,085 2,970 3,170

peso/caja (gr) peso/caja (kg)

2,280.00 2.28
3,240.00 3.24
3,000.00 3.00
3,000.00 3.00
5,000.00 5.00
3,000.00 3.00
5,000.00 5.00
3,000.00 3.00
5,000.00 5.00

LA PROGRAMACION POR DIA QUEDA AL CRIT

Turnos de trabajo
Turnos (orden) Periodo L
1.00 07 - 03 p.m
2.00 03 - 11 p.m
3.00 11 - 07 a.m
ril 4 se da de la siguiente manera, aumento de 2%
to al cuadro de la semana 1

NERO
4 Total Presentación
30% 100% Jabón Trome 95 g
35% 100% Jabón Trome 180 g
25% 100% Jabón Trome 250 g
30% 100% Jabón Jumbo 250 g
25% 100% Jabón Jumbo 500 g
25% 100% Jabón Bolivar 250 g
30% 100% Jabón Bolivar 500 g
10% 100% Jabón Marsella 250 g
35% 100% Jabón Marsella 500 g
vel de semana y dias

CAJAS

Produccion Prod (kg) Kg/Formula Formula

58,012.64 132,268.82 8.52 15,524.51
36,650.55 118,747.78 8.52 13,937.53
57,594.15 172,782.45 8.52 20,279.63
70,159.91 210,479.73 8.00 26,309.97
74,348.83 371,744.15 8.00 46,468.02
89,009.05 267,027.15 8.00 33,378.39
95,710.92 478,554.61 8.00 59,819.33
119,376.22 358,128.66 8.00 44,766.08
89,009.05 445,045.25 8.00 55,630.66

4 Total 1
14,503.16 58,012.64 -478.64
9,162.64 36,650.55 1,482.64
14,398.54 57,594.15 5,134.54
17,539.98 70,159.91 6,254.98
18,587.21 74,348.83 10,249.21
22,252.26 89,009.05 7,935.26
23,927.73 95,710.92 31,839.73
29,844.06 119,376.22 4,829.06
22,252.26 89,009.05 16,605.26
638.69 2,554.78

4 Total 1
14,024.52 58,012.64 0.000 0.00
7,312.91 36,650.55 0.000 1,482.64
14,398.54 57,594.15 0.000 5,134.54
17,539.98 70,159.91 0.000 6,254.98
18,587.21 74,348.83 0.000 10,249.21
22,252.26 89,009.05 0.000 7,935.26
23,927.73 95,710.92 0.000 31,839.73
24,593.22 119,376.22 0.000 4,829.06
22,252.26 89,009.05 0.000 16,605.26
615.86 2,554.78
 22.84

4 Total 1
14,024.52 58,012.64 0.00000 0.00
7,312.91 36,650.55 0.00000 1,482.64
14,398.54 57,594.15 0.00000 5,134.54
17,539.98 70,159.91 0.00000 6,254.98
18,587.21 74,348.83 0.00000 10,249.21
27,292.21 89,009.05 0.00000 7,935.26
25,471.15 95,710.92 0.00000 31,621.47
24,593.22 119,376.22 0.00000 4,829.06
22,252.26 89,009.05 0.00000 16,605.26
638.69 2,554.78
0.0000
0.000000
Capacidad de planta 3,300.00
Lote Minimo 3,500
Cambios de producci 2.00

J V S Total
4993.93 14981.80
1869.77 9162.64
4799.51 14398.54
0.00 11693.32 17539.98
4486.19 7905.28 18587.21
11833.42 3001.42 22252.26
9703.58 4302.60 23709.47
12948.25 29844.05
7417.42 22252.26
106.449 106.449 106.449 638.69
106.449 106.449 106.449 638.69
0.000000 0.000000 0.000000
0.000000 0.000000 0.000000

J V S Total
0.00 0.00 4994.00 14982.00
0.00 0.00 1870.00 9163.00
0.00 0.00 4800.00 14400.00
0.00 0.00 11693.00 17540.00
4486.00 0.00 7905.00 18587.00
11833.00 3002.00 0.00 22253.00
9704.00 4303.00 0.00 23710.00
0.00 12949.00 0.00 29845.00
0.00 7418.00 0.00 22252.00
106.449 106.458 106.449 638.71
 J V S Total
4834.39 14503.16
3055.74 11012.36
4799.51 14398.54
1675.59 10017.72 17539.98
4176.59 8214.88 18587.21
12289.47 2545.37 22252.26
8734.19 4491.87 22602.57
13088.85 30054.94
7417.42 22252.26
106.449 106.449 106.449 638.69
106.449 106.449 106.449
0.00 0.00 0.00
0.00000 0.00000 0.00000

J V S Total
0.00 0.00 4835.00 14505.00
0.00 0.00 3056.00 11012.00
0.00 0.00 4800.00 14400.00
1676.00 0.00 10017.00 17540.00
4176.00 0.00 8214.00 18586.00
12289.00 2546.00 0.00 22253.00
8735.00 4492.00 0.00 22603.00
0.00 13089.00 0.00 30055.00
0.00 7418.00 0.00 22252.00
106.450 106.455 106.446 638.70

J V S Total
4834.39 14503.16
3313.04 9162.64
4799.51 14398.54
1588.23 10105.08 17539.98
4395.74 7995.74 18587.21
10275.39 1199.48 17212.31
9775.91 3367.78 23927.73
16308.22 34884.01
7417.42 22252.26
106.449 106.449 106.449 638.69
106.449 106.449 106.449
0.00 0.00 0.00
0.00000 0.00000 0.00000
 J V S Total
0.00 0.00 4835.00 14505.00
0.00 0.00 3314.00 9164.00
0.00 0.00 4800.00 14400.00
1589.00 0.00 10105.00 17541.00
4395.00 0.00 7995.00 18586.00
10275.00 1200.00 0.00 17213.00
9776.00 3368.00 0.00 23928.00
0.00 16309.00 0.00 34885.00
0.00 7418.00 0.00 22252.00
106.447 106.457 106.451 638.71

J V S Total
4674.84 14024.52
191.44 7312.91
4799.51 14398.54
95.66 11597.66 17539.98
3195.74 9195.74 18587.21
13910.52 4284.29 27292.21
9690.38 6383.18 25471.15
8197.74 24593.22
7417.42 22252.26
106.449 106.449 106.449 638.69
106.449 106.449 106.449
0.00 0.00 0.00
0.00000 0.00000 0.00000

J V S Total
0.00 0.00 4675.00 14025.00
0.00 0.00 192.00 7313.00
0.00 0.00 4800.00 14400.00
96.00 0.00 11597.00 17540.00
3195.00 0.00 9195.00 18586.00
13910.00 4285.00 0.00 27293.00
9691.00 6384.00 0.00 25315.00
0.00 8198.00 0.00 24855.00
0.00 7418.00 0.00 22252.00
106.448 106.459 106.447 638.70
ción 2010-1 UPN EF

ue se detallan a continuación:

SKU (toneladas)
Ago Sep Oct Nov Dic
2,960 2,780 2,710 2,640 2,935

AMACION POR DIA QUEDA AL CRITERIO DE CADA GRUPO

L L L L L
1 2 3 4 Total
19,777.80 0.00 19,777.80 16,952.40 56,508.00
10,710.00 12,495.00 0.00 12,495.00 35,700.00
14,025.00 14,025.00 14,025.00 14,025.00 56,100.00
17,085.00 13,668.00 17,085.00 20,502.00 68,340.00
14,484.00 18,105.00 21,726.00 18,105.00 72,420.00
21,675.00 21,675.00 21,675.00 21,675.00 86,700.00
0.00 27,968.40 37,291.20 27,968.40 93,228.00
34,884.00 34,884.00 34,884.00 11,628.00 116,280.00
13,005.00 17,340.00 26,010.00 30,345.00 86,700.00
 Colocar redondear más a la
formula de SS

2 3 4
14,024.52 8,749.88 6,301
-1,849.72 7,312.91 3,981
5,508.07 5,881.61 6,255
10,126.96 10,581.93 7,620
10,731.42 7,592.62 8,075
8,512.53 9,089.79 9,667
27,799.06 14,435.59 10,395
-210.89 -5,250.83 12,965
21,517.53 17,759.79 9,667

2 3 4
14,503.16 9,228.52 6,300.64
0.00 9,162.64 3,980.55
5,508.07 5,881.61 6,255.15
10,126.96 10,581.93 7,619.91
10,731.42 7,592.62 8,074.83
8,512.53 9,089.79 9,667.05
27,799.06 14,435.59 10,394.92
0.00 0.00 12,965.22
21,517.53 17,759.79 9,667.05
 2 3 4 S inicial
14,503.16 9,228.52 6,300.64 6,300.00
0.00 9,162.64 3,980.55 3,980.00
5,508.07 5,881.61 6,255.15 6,255.00
10,126.96 10,581.93 7,619.91 7,619.00
10,731.42 7,592.62 8,074.83 8,074.00
8,512.53 4,049.84 9,667.05 9,667.00
26,255.65 12,892.18 10,394.92 10,394.00
0.00 0.00 12,965.22 12,965.00
21,517.53 17,759.79 9,667.05 9,667.00

toneladas/mes 825.00 toneladas/sem 137.50 toneladas/día

cajas/corrida
productos/dia

0.00000 4,993.93
0.00000 3,054.21
0.00000 4,799.51
0.00000 5,846.66
0.00000 6,195.74
0.00000 7,417.42
0.00000 7,903.16
0.00000 9,948.02
0.00000 7,417.42
0.00000

-0.20
-0.36
-1.46
-0.02
0.21
-0.74
-0.53
-0.95
0.26
0.0000
0.0000
0.0000
0.0000
0.0000
0.0000
0.0000
0.0000
0.0000
0.0000

-1.84
0.36
-1.46
-0.02
1.21
-0.74
-0.43
-0.06
0.26

0.0000
0.0000
0.0000
0.0000
0.0000
0.0000
0.0000
0.0000
0.0000
0.0000
 -1.84
-1.36
-1.46
-1.02
1.21
-0.69
-0.27
-1.00
0.26

0.0000
0.0000
0.0000
0.0000
0.0000
0.0000
0.0000
0.0000
0.0000
0.0000

-0.48
-0.09
-1.46
-0.02
1.21
-0.79
156.15
-261.78
0.26
010-1 UPN EF
FEBRERO m a
56,508 53,965.1 60,802.61
35,700 34,093.5 38,413.20
56,100 53,575.5 60,363.60
68,340 65,264.7 73,533.84
72,420 69,161.1 77,923.92
86,700 82,798.5 93,289.20
93,228 89,032.7 100,313.33
116,280 111,047.4 125,117.28
86,700 82,798.5 93,289.20
neladas/día
 Programa Ma
Jabonería el Pacífico, para su línea de productos jabón uso doméstico requiere elaborar el P

Proyección de venta
SKU Ene Feb Mar
Jabón (toneladas) 2,640 2,950 3,150
gr/pieza
Presentación Unidad pzas /caja peso (gr)
Jabón Trome 95 g caja 24 95.000
Jabón Trome 180 g caja 18 180.000
Jabón Trome 250 g caja 12 250.000
Jabón Jumbo 250 g caja 12 250.000
Jabón Jumbo 500 g caja 10 500.000
Jabón Bolivar 250 g caja 12 250.000
Jabón Bolivar 500 g caja 10 500.000
Jabón Marsella 250 g caja 12 250.000
Jabón Marsella 500 g caja 10 500.000

Pronóstico de Enero 2027

Presentación Unidad Cant (cajas)

Jabón Trome 95 g caja 55,400
Jabón Trome 180 g caja 35,000
Jabón Trome 250 g caja 55,000
Jabón Jumbo 250 g caja 67,000
Jabón Jumbo 500 g caja 71,000
Jabón Bolivar 250 g caja 85,000
Jabón Bolivar 500 g caja 91,400
Jabón Marsella 250 g caja 114,000
Jabón Marsella 500 g caja 85,000

Capacidad de planta

Capacidad de planta 3,300.00 toneladas/mes

Lote Minimo 3,500 cajas/corrida
Cambios de producción 2.00 productos/dia

Fórmula (componentes)
Producto (Presentación) Kilos/fórmula
Jabón Trome 8.52
Jabón Jumbo 8.00
Jabón Bolivar 8.00
Jabón Marsella 8.00
 Horas - Hombre por tonelada
Presentación H-H / TM
Jabón Trome 95 g 28.00
Jabón Trome 180 g 30.00
Jabón Trome 250 g 18.00
Jabón Jumbo 250 g 18.00
Jabón Jumbo 500 g 14.00
Jabón Bolivar 250 g 18.00
Jabón Bolivar 500 g 14.00
Jabón Marsella 250 g 18.00
Jabón Marsella 500 g 14.00

Programas de Despachos

La demanda de los depachos programados para el Febrero, Marzo 3 y Abril 4 se da de la siguiente manera, au
, disminucion del 4.5% y aumento de 7.6% de todos los SKUs con respecto al cuadro de la semana 1

ENERO
Presentación 1 2 3
Jabón Trome 95 g 35% 0% 35%
Jabón Trome 180 g 30% 35% 0%
Jabón Trome 250 g 25% 25% 25%
Jabón Jumbo 250 g 25% 20% 25%
Jabón Jumbo 500 g 20% 25% 30%
Jabón Bolivar 250 g 25% 25% 25%
Jabón Bolivar 500 g 0% 30% 40%
Jabón Marsella 250 g 30% 30% 30%
Jabón Marsella 500 g 15% 20% 30%

2.- Niveles de Inventario y politicas de seguridad

(Cajas)
Presentación Stock (cajas) SS
Jabón Trome 95 g 2,500 4,796
Jabón Trome 180 g 1,800 3,030
Jabón Trome 250 g 2,400 4,761
Jabón Jumbo 250 g 1,600 5,800
Jabón Jumbo 500 g 2,460 6,146
Jabón Bolivar 250 g 3,700 7,358
Jabón Bolivar 500 g 4,500 7,912
Jabón Marsella 250 g 3,800 9,869
Jabón Marsella 500 g 2,600 7,358

Elaborar el PMP por SKU por todos los componente a nivel de semana y dias

Solucion:
CAJAS

Producto (Presentación) Demanda SS S Inicial

Jabón Trome 95 g 59,610 6,646.56 3,474.00
Jabón Trome 180 g 37,660 4,199.09 2,194.00
Jabón Trome 250 g 59,180 6,598.57 3,449.00
Jabón Jumbo 250 g 72,092 8,038.26 4,201.00
Jabón Jumbo 500 g 76,396 8,518.15 4,452.00
Jabón Bolivar 250 g 91,460 10,197.79 5,330.00
Jabón Bolivar 500 g 98,346 10,965.62 5,731.00
Jabón Marsella 250 g 122,664 13,677.04 7,149.00
Jabón Marsella 500 g 91,460 10,197.79 5,330.00

Programa mensual por presentaciones (cajas)

Producto (Presentación) 1 2 3
Jabón Trome 95 g 15,695.74 15,695.74 15,695.74
Jabón Trome 180 g 9,916.27 9,916.27 9,916.27
Jabón Trome 250 g 15,582.39 15,582.39 15,582.39
Jabón Jumbo 250 g 18,982.31 18,982.31 18,982.31
Jabón Jumbo 500 g 20,115.54 20,115.54 20,115.54
Jabón Bolivar 250 g 24,081.95 24,081.95 24,081.95
Jabón Bolivar 500 g 25,895.26 25,895.26 25,895.26
Jabón Marsella 250 g 32,298.01 32,298.01 32,298.01
Jabón Marsella 500 g 24,081.95 24,081.95 24,081.95
Total TM 691.21 691.21 691.21

Producto (Presentación) 1 2 3
Jabón Trome 95 g 17,389.64 15,695.74 15,695.74
Jabón Trome 180 g 9,916.27 12,368.73 9,916.27
Jabón Trome 250 g 15,582.39 15,582.39 15,582.39
Jabón Jumbo 250 g 18,982.31 18,982.31 18,982.31
Jabón Jumbo 500 g 20,115.54 20,115.54 20,115.54
Jabón Bolivar 250 g 24,081.95 24,081.95 24,081.95
Jabón Bolivar 500 g 25,895.26 25,895.26 25,895.26
Jabón Marsella 250 g 32,298.01 34,151.39 36,799.20
Jabón Marsella 500 g 24,081.95 24,081.95 24,081.95
Total TM 695.07 704.72 704.72
 -3.86 -13.51 -13.50

toneladas
Producto (Presentación) 1 2 3
Jabón Trome 95 g 17,389.64 15,695.74 15,695.74
Jabón Trome 180 g 9,916.27 12,368.73 9,916.27
Jabón Trome 250 g 15,582.39 15,582.39 15,582.39
Jabón Jumbo 250 g 18,982.31 18,982.31 18,982.31
Jabón Jumbo 500 g 20,115.54 20,115.54 20,115.54
Jabón Bolivar 250 g 24,081.95 24,081.95 24,081.95
Jabón Bolivar 500 g 25,122.84 23,194.03 23,194.54
Jabón Marsella 250 g 32,298.01 34,151.39 36,799.20
Jabón Marsella 500 g 24,081.95 24,081.95 24,081.95
Total TM 691.21 691.21 691.21
0.0000 0.0000 0.0000
0.000000 0.000000 0.000000

137.50
SEMANA 01
Presentación L M M
Jabón Trome 95 g 5796.55 4993.93
Jabón Trome 180 g 3305.42 3054.21
Jabón Trome 250 g 5194.13 4799.51
Jabón Jumbo 250 g 6327.44
Jabón Jumbo 500 g 6705.18
Jabón Bolivar 250 g 7417.42
Jabón Bolivar 500 g 9703.30
Jabón Marsella 250 g 10766.00
Jabón Marsella 500 g 8027.32
Total TM 111.943 52.508 106.449
106.449 106.449 106.449
5.493573 -53.940897 0.000000
1695.547135 -17980.298858 0.000000

SEMANA 02
Presentación L M M
Jabón Trome 95 g 4993.93 4993.93
Jabón Trome 180 g 3054.21 3054.21
Jabón Trome 250 g 4799.51 4799.51
Jabón Jumbo 250 g 5846.66
Jabón Jumbo 500 g 6195.74
Jabón Bolivar 250 g 7417.42
Jabón Bolivar 500 g 9703.30
Jabón Marsella 250 g 9948.02 6947.78
Jabón Marsella 500 g 7417.42 7417.42
 Total TM 102.612 106.449 106.449

SEMANA 03
Presentación L M M
Jabón Trome 95 g 4993.93 4993.93
Jabón Trome 180 g 3054.21 3054.21
Jabón Trome 250 g 4799.51 4799.51
Jabón Jumbo 250 g 5846.66
Jabón Jumbo 500 g 6195.74
Jabón Bolivar 250 g 7417.42
Jabón Bolivar 500 g 9703.30
Jabón Marsella 250 g 9948.02 6947.78
Jabón Marsella 500 g 7417.42 7417.42
Total TM 102.612 106.449 106.449

SEMANA 04
Presentación
L M M
Jabón Trome 95 g 4993.93 4993.93
Jabón Trome 180 g 3054.21 3054.21
Jabón Trome 250 g 4799.51 4799.51
Jabón Jumbo 250 g 5846.66
Jabón Jumbo 500 g 6195.74
Jabón Bolivar 250 g 7417.42
Jabón Bolivar 500 g 9703.30
Jabón Marsella 250 g 9948.02 6947.78
Jabón Marsella 500 g 7417.42 7417.42
Total TM 102.612 106.449 106.449

Producto (Presentación) L M M
Jabón Trome 4,637.10 0.00 4,187.84
Jabón Jumbo 0.00 6,563.53 0.00
Jabón Bolivar 0.00 8,846.09 #VALUE!
Jabón Marsella 9,054.32 8,244.17 0.00
 Programa Maestro de la Producción
oméstico requiere elaborar el PMP a partir de la siguiente información que se detallan a continuación:

Proyección de ventas para el año 2027 por SKU (toneladas)

Abr May Jun Jul
3,050 3,085 2,970 3,170

peso/caja (gr) peso/caja (kg)

2,280.00 2.28
3,240.00 3.24
3,000.00 3.00
3,000.00 3.00
5,000.00 5.00
3,000.00 3.00
5,000.00 5.00
3,000.00 3.00
5,000.00 5.00

LA PROGRAMACION POR DIA QUEDA AL CRIT

Turnos de trabajo
Turnos (orden) Periodo L
1.00 07 - 03 p.m
2.00 03 - 11 p.m
3.00 11 - 07 a.m
ril 4 se da de la siguiente manera, aumento de 2%
to al cuadro de la semana 1

NERO
4 Total Presentación
30% 100% Jabón Trome 95 g
35% 100% Jabón Trome 180 g
25% 100% Jabón Trome 250 g
30% 100% Jabón Jumbo 250 g
25% 100% Jabón Jumbo 500 g
25% 100% Jabón Bolivar 250 g
30% 100% Jabón Bolivar 500 g
10% 100% Jabón Marsella 250 g
35% 100% Jabón Marsella 500 g
vel de semana y dias

CAJAS

Produccion Prod (kg) Kg/Formula Formula

62,782.96 143,145.15 8.52 16,801.07
39,665.09 128,514.89 8.52 15,083.91
62,329.57 186,988.71 8.52 21,947.03
75,929.26 227,787.77 8.00 28,473.47
80,462.15 402,310.77 8.00 50,288.85
96,327.79 288,983.37 8.00 36,122.92
103,581.02 517,905.12 8.00 64,738.14
129,192.04 387,576.11 8.00 48,447.01
96,327.79 481,638.95 8.00 60,204.87

4 Total 1
15,695.74 62,782.96 -1,693.90
9,916.27 39,665.09 812.27
15,582.39 62,329.57 4,236.39
18,982.31 75,929.26 5,160.31
20,115.54 80,462.15 9,288.34
24,081.95 96,327.79 6,546.95
25,895.26 103,581.02 31,626.26
32,298.01 129,192.04 2,647.81
24,081.95 96,327.79 15,692.95
691.21 2,764.85

4 Total 1
14,001.84 62,782.96 0.000 0.00
7,463.81 39,665.09 0.000 812.27
15,582.39 62,329.57 0.000 4,236.39
18,982.31 75,929.26 0.000 5,160.31
20,115.54 80,462.15 0.000 9,288.34
24,081.95 96,327.79 0.000 6,546.95
25,895.26 103,581.02 0.000 31,626.26
25,943.44 129,192.04 0.000 2,647.81
24,081.95 96,327.79 0.000 15,692.95
660.34 2,764.85
 30.87

4 Total 1
14,001.84 62,782.96 0.00000 0.00
7,463.81 39,665.09 0.00000 812.27
15,582.39 62,329.57 0.00000 4,236.39
18,982.31 75,929.26 0.00000 5,160.31
20,115.54 80,462.15 0.00000 9,288.34
24,081.95 96,327.79 0.00000 6,546.95
32,069.61 103,581.02 0.00000 30,853.84
25,943.44 129,192.04 0.00000 2,647.81
24,081.95 96,327.79 0.00000 15,692.95
691.21 2,764.85
0.0000
0.000000
Capacidad de planta 3,300.00
Lote Minimo 3,500
Cambios de producci 2.00

J V S Total
4993.93 17389.64
1869.77 9916.27
4799.51 15582.39
0.00 11693.32 18982.31
4486.19 7905.28 20115.54
8027.32 3001.42 24081.95
8374.28 4302.60 25122.84
12948.25 32298.01
7417.42 24081.95
88.384 106.449 106.449 572.18
106.449 106.449 106.449 638.69
-18.064801 0.000000 0.000000
-3612.960225 0.000000 0.000000

J V S Total
4993.93 15695.74
1869.77 12368.73
4799.51 15582.39
0.00 11693.32 18982.31
4486.19 7905.28 20115.54
11833.42 3001.42 24081.95
9703.58 4302.60 23194.03
12948.25 34151.39
7417.42 24081.95
 106.449 106.449 106.449 634.86

J V S Total
4993.93 15695.74
1869.77 9916.27
4799.51 15582.39
0.00 11693.32 18982.31
4486.19 7905.28 20115.54
11833.42 3001.42 24081.95
9703.58 4302.60 23194.54
12948.25 36799.20
7417.42 24081.95
106.449 106.449 106.449 634.86

J V S Total
4993.93 14001.84
1869.77 7463.81
4799.51 15582.39
0.00 11693.32 18982.31
4486.19 7905.28 20115.54
11833.42 3001.42 24081.95
9703.58 4302.60 32069.61
12948.25 25943.44
7417.42 24081.95
106.449 106.449 106.449 634.86

J V S Total
0.00 0.00 3,737.41 13,911.30
2,803.87 0.00 9,325.79 19,690.58
3,814.66 0.00 24,732.50 0.00
0.00 9,491.48 0.00 27,162.97
ción 2010-1 UPN EF

ue se detallan a continuación:

SKU (toneladas)
Ago Sep Oct Nov Dic
2,960 2,780 2,710 2,640 2,935

AMACION POR DIA QUEDA AL CRITERIO DE CADA GRUPO

M M J V S
1 2 3 4 Total
20,863.64 0.00 20,863.64 17,883.12 59,610.40
11,298.00 13,181.00 0.00 13,181.00 37,660.00
14,795.00 14,795.00 14,795.00 14,795.00 59,180.00
18,023.00 14,418.40 18,023.00 21,627.60 72,092.00
15,279.20 19,099.00 22,918.80 19,099.00 76,396.00
22,865.00 22,865.00 22,865.00 22,865.00 91,460.00
0.00 29,503.92 39,338.56 29,503.92 98,346.40
36,799.20 36,799.20 36,799.20 12,266.40 122,664.00
13,719.00 18,292.00 27,438.00 32,011.00 91,460.00
 Colocar redondear más a la
formula de SS

2 3 4
14,001.84 8,833.94 6,647
-2,452.46 7,463.82 4,199
5,023.79 5,811.18 6,599
9,724.23 10,683.54 8,038
10,304.88 7,501.62 8,518
7,763.90 8,980.84 10,198
28,017.59 14,574.29 10,966
-1,853.38 -6,354.57 13,677
21,482.90 18,126.84 10,198

2 3 4
15,695.74 10,527.84 6,646.56
0.00 9,916.28 4,199.09
5,023.79 5,811.18 6,598.57
9,724.23 10,683.54 8,038.26
10,304.88 7,501.62 8,518.15
7,763.90 8,980.84 10,197.79
28,017.59 14,574.29 10,965.62
0.00 0.00 13,677.04
21,482.90 18,126.84 10,197.79
 2 3 4 S inicial
15,695.74 10,527.84 6,646.56 6,646.56
0.00 9,916.28 4,199.09 4,199.09
5,023.79 5,811.18 6,598.57 6,598.57
9,724.23 10,683.54 8,038.26 8,038.26
10,304.88 7,501.62 8,518.15 8,518.15
7,763.90 8,980.84 10,197.79 10,197.79
24,543.95 8,399.93 10,965.62 10,965.62
0.00 0.00 13,677.04 13,677.04
21,482.90 18,126.84 10,197.79 10,197.79

toneladas/mes 825.00 toneladas/sem 137.50 toneladas/día

cajas/corrida
productos/dia

0.00000 5,796.55
0.00000 3,305.42
0.00000 5,194.13
0.00000 6,327.44
0.00000 6,705.18
0.00000 8,027.32
0.00000 8,374.28
0.00000 10,766.00
0.00000 8,027.32
119.03018

15,695.74 5,231.91
12,368.73 4,122.91
15,582.39 5,194.13
18,982.31 6,327.44
20,115.54 6,705.18
24,081.95 8,027.32
23,194.03 7,731.34
34,151.39 11,383.80
24,081.95 8,027.32
15,695.74 5,231.91
9,916.27 3,305.42
15,582.39 5,194.13
18,982.31 6,327.44
20,115.54 6,705.18
24,081.95 8,027.32
23,194.54 7,731.51
36,799.20 12,266.40
24,081.95 8,027.32

14,001.84 4,667.28
7,463.81 2,487.94
15,582.39 5,194.13
18,982.31 6,327.44
20,115.54 6,705.18
24,081.95 8,027.32
32,069.61 10,689.87
25,943.44 8,647.81
24,081.95 8,027.32
010-1 UPN EF
ABRIL m a
59,610 56,927.9 64,140.79
37,660 35,965.3 40,522.16
59,180 56,516.9 63,677.68
72,092 68,847.9 77,570.99
76,396 72,958.2 82,202.10
91,460 87,344.3 98,410.96
98,346 93,920.8 105,820.73
122,664 117,144.1 131,986.46
91,460 87,344.3 98,410.96
neladas/día
 Programa Ma
Jabonería el Pacífico, para su línea de productos jabón uso doméstico requiere elaborar el P

Proyección de venta
SKU Ene Feb Mar
Jabón (toneladas) 2,640 2,950 3,150
gr/pieza
Presentación Unidad pzas /caja peso (gr)
Jabón Trome 95 g caja 24 95.000
Jabón Trome 180 g caja 18 180.000
Jabón Trome 250 g caja 12 250.000
Jabón Jumbo 250 g caja 12 250.000
Jabón Jumbo 500 g caja 10 500.000
Jabón Bolivar 250 g caja 12 250.000
Jabón Bolivar 500 g caja 10 500.000
Jabón Marsella 250 g caja 12 250.000
Jabón Marsella 500 g caja 10 500.000

Pronóstico de Enero 2027

Presentación Unidad Cant (cajas)

Jabón Trome 95 g caja 55,400
Jabón Trome 180 g caja 35,000
Jabón Trome 250 g caja 55,000
Jabón Jumbo 250 g caja 67,000
Jabón Jumbo 500 g caja 71,000
Jabón Bolivar 250 g caja 85,000
Jabón Bolivar 500 g caja 91,400
Jabón Marsella 250 g caja 114,000
Jabón Marsella 500 g caja 85,000

Capacidad de planta

Capacidad de planta 3,300.00 toneladas/mes

Lote Minimo 3,500 cajas/corrida
Cambios de producción 2.00 productos/dia

Fórmula (componentes)
Producto (Presentación) Kilos/fórmula
Jabón Trome 8.52
Jabón Jumbo 8.00
Jabón Bolivar 8.00
Jabón Marsella 8.00
 Horas - Hombre por tonelada
Presentación H-H / TM
Jabón Trome 95 g 28.00
Jabón Trome 180 g 30.00
Jabón Trome 250 g 18.00
Jabón Jumbo 250 g 18.00
Jabón Jumbo 500 g 14.00
Jabón Bolivar 250 g 18.00
Jabón Bolivar 500 g 14.00
Jabón Marsella 250 g 18.00
Jabón Marsella 500 g 14.00

Programas de Despachos

La demanda de los depachos programados para el Febrero, Marzo 3 y Abril 4 se da de la siguiente manera, au
, disminucion del 4.5% y aumento de 7.6% de todos los SKUs con respecto al cuadro de la semana 1

ENERO
Presentación 1 2 3
Jabón Trome 95 g 35% 0% 35%
Jabón Trome 180 g 30% 35% 0%
Jabón Trome 250 g 25% 25% 25%
Jabón Jumbo 250 g 25% 20% 25%
Jabón Jumbo 500 g 20% 25% 30%
Jabón Bolivar 250 g 25% 25% 25%
Jabón Bolivar 500 g 0% 30% 40%
Jabón Marsella 250 g 30% 30% 30%
Jabón Marsella 500 g 15% 20% 30%

2.- Niveles de Inventario y politicas de seguridad

(Cajas)
Presentación Stock (cajas) SS
Jabón Trome 95 g 2,500 4,796
Jabón Trome 180 g 1,800 3,030
Jabón Trome 250 g 2,400 4,761
Jabón Jumbo 250 g 1,600 5,800
Jabón Jumbo 500 g 2,460 6,146
Jabón Bolivar 250 g 3,700 7,358
Jabón Bolivar 500 g 4,500 7,912
Jabón Marsella 250 g 3,800 9,869
Jabón Marsella 500 g 2,600 7,358

Elaborar el PMP por SKU por todos los componente a nivel de semana y dias

Solucion:
CAJAS

Producto (Presentación) Demanda SS S Inicial

Jabón Trome 95 g 60,940 6,794.81 6,646.56
Jabón Trome 180 g 38,500 4,292.75 4,199.09
Jabón Trome 250 g 60,500 6,745.75 6,598.57
Jabón Jumbo 250 g 73,700 8,217.55 8,038.26
Jabón Jumbo 500 g 78,100 8,708.15 8,518.15
Jabón Bolivar 250 g 93,500 10,425.25 10,197.79
Jabón Bolivar 500 g 100,540 11,210.21 10,965.62
Jabón Marsella 250 g 125,400 13,982.10 13,677.04
Jabón Marsella 500 g 93,500 10,425.25 10,197.79

Programa mensual por presentaciones (cajas)

Producto (Presentación) 1 2 3
Jabón Trome 95 g 15,235.00 15,235.00 15,235.00
Jabón Trome 180 g 9,625.00 9,625.00 9,625.00
Jabón Trome 250 g 15,125.00 15,125.00 15,125.00
Jabón Jumbo 250 g 18,425.00 18,425.00 18,425.00
Jabón Jumbo 500 g 19,525.00 19,525.00 19,525.00
Jabón Bolivar 250 g 23,375.00 23,375.00 23,375.00
Jabón Bolivar 500 g 25,135.00 25,135.00 25,135.00
Jabón Marsella 250 g 31,350.00 31,350.00 31,350.00
Jabón Marsella 500 g 23,375.00 23,375.00 23,375.00
Total TM 670.92 670.92 670.92

Producto (Presentación) 1 2 3
Jabón Trome 95 g 17,389.64 15,695.74 15,695.74
Jabón Trome 180 g 9,916.27 12,368.73 9,916.27
Jabón Trome 250 g 15,582.39 15,582.39 15,582.39
Jabón Jumbo 250 g 18,982.31 18,982.31 18,982.31
Jabón Jumbo 500 g 20,115.54 20,115.54 20,115.54
Jabón Bolivar 250 g 24,081.95 24,081.95 24,081.95
Jabón Bolivar 500 g 25,895.26 25,895.26 25,895.26
Jabón Marsella 250 g 32,298.01 34,151.39 36,799.20
Jabón Marsella 500 g 24,081.95 24,081.95 24,081.95
Total TM 695.07 704.72 704.72
 -24.15 -33.80 -33.80
toneladas
Producto (Presentación) 1 2 3
Jabón Trome 95 g 17,389.64 15,695.74 15,695.74
Jabón Trome 180 g 9,916.27 12,368.73 9,916.27
Jabón Trome 250 g 15,582.39 15,582.39 15,582.39
Jabón Jumbo 250 g 18,982.31 18,982.31 18,982.31
Jabón Jumbo 500 g 20,115.54 20,115.54 20,115.54
Jabón Bolivar 250 g 24,081.95 24,081.95 24,081.95
Jabón Bolivar 500 g 25,122.84 23,194.03 23,194.54
Jabón Marsella 250 g 32,298.01 34,151.39 36,799.20
Jabón Marsella 500 g 24,081.95 24,081.95 24,081.95
Total TM 691.21 691.21 691.21
-20.2919 -20.2919 -20.2919
-4,058.381974 -4,058.381974 -4,058.381974

137.50

Presentación L M M
Jabón Trome 95 g 4993.93 4993.93
Jabón Trome 180 g 3054.21 3054.21
Jabón Trome 250 g 4799.51 4799.51
Jabón Jumbo 250 g 5846.66
Jabón Jumbo 500 g 6195.74
Jabón Bolivar 250 g 7417.42
Jabón Bolivar 500 g 9703.30
Jabón Marsella 250 g 9948.02 6947.78
Jabón Marsella 500 g 7417.42 7417.42
Total TM 102.612 106.449 106.449
106.449 106.449 106.449
-3.837595 0.000000 0.000000
-1184.442909 0.000000 0.000000

Producto (Presentación) L M M
Jabón Trome 4,187.84 0.00 4,187.84
Jabón Jumbo 0.00 6,064.83 0.00
Jabón Bolivar 0.00 8,846.09 10,502.27
Jabón Marsella 8,366.39 7,241.31 0.00
 Programa Maestro de la Producción
oméstico requiere elaborar el PMP a partir de la siguiente información que se detallan a continuación:

Proyección de ventas para el año 2027 por SKU (toneladas)

Abr May Jun Jul
3,050 3,085 2,970 3,170

peso/caja (gr) peso/caja (kg)

2,280.00 2.28
3,240.00 3.24
3,000.00 3.00
3,000.00 3.00
5,000.00 5.00
3,000.00 3.00
5,000.00 5.00
3,000.00 3.00
5,000.00 5.00

LA PROGRAMACION POR DIA QUEDA AL CRIT

Turnos de trabajo
Turnos (orden) Periodo L
1.00 07 - 03 p.m
2.00 03 - 11 p.m
3.00 11 - 07 a.m
ril 4 se da de la siguiente manera, aumento de 2%
to al cuadro de la semana 1

NERO
4 Total Presentación
30% 100% Jabón Trome 95 g
35% 100% Jabón Trome 180 g
25% 100% Jabón Trome 250 g
30% 100% Jabón Jumbo 250 g
25% 100% Jabón Jumbo 500 g
25% 100% Jabón Bolivar 250 g
30% 100% Jabón Bolivar 500 g
10% 100% Jabón Marsella 250 g
35% 100% Jabón Marsella 500 g
vel de semana y dias

CAJAS

Produccion Prod (kg) Kg/Formula Formula

61,088.25 139,281.21 8.52 16,347.56
38,593.66 125,043.46 8.52 14,676.46
60,647.18 181,941.54 8.52 21,354.64
73,879.29 221,637.88 8.00 27,704.73
78,290.00 391,449.98 8.00 48,931.25
93,727.46 281,182.38 8.00 35,147.80
100,784.59 503,922.93 8.00 62,990.37
125,705.06 377,115.19 8.00 47,139.40
93,727.46 468,637.30 8.00 58,579.66

4 Total 1
15,235.00 60,940.00 552.56
9,625.00 38,500.00 2,274.09
15,125.00 60,500.00 6,598.57
18,425.00 73,700.00 8,038.26
19,525.00 78,100.00 12,423.15
23,375.00 93,500.00 10,197.79
25,135.00 100,540.00 36,100.62
31,350.00 125,400.00 7,407.04
23,375.00 93,500.00 19,547.79
670.92 2,683.68

4 Total 1
14,001.84 62,782.96 -1,842.960 2,707.20
7,463.81 39,665.09 -1,165.090 2,565.36
15,582.39 62,329.57 -1,829.570 7,055.96
18,982.31 75,929.26 -2,229.258 8,595.57
20,115.54 80,462.15 -2,362.154 13,013.69
24,081.95 96,327.79 -2,827.790 10,904.74
25,895.26 103,581.02 -3,041.024 36,860.88
25,943.44 129,192.04 -3,792.036 8,355.04
24,081.95 96,327.79 -2,827.790 20,254.74
660.34 2,764.85
 10.58

4 Total 1
14,001.84 62,782.96 -1,842.95960 2,707.20
7,463.81 39,665.09 -1,165.09000 2,565.36
15,582.39 62,329.57 -1,829.57000 7,055.96
18,982.31 75,929.26 -2,229.25800 8,595.57
20,115.54 80,462.15 -2,362.15400 13,013.69
24,081.95 96,327.79 -2,827.79000 10,904.74
32,069.61 103,581.02 -3,041.02360 36,088.46
25,943.44 129,192.04 -3,792.03600 8,355.04
24,081.95 96,327.79 -2,827.79000 20,254.74
691.21 2,764.85
-20.2919
-4,058.381974
Capacidad de planta 3,300.00
Lote Minimo 3,500
Cambios de producci 2.00

J V S Total
4993.93 14981.80
1869.77 7978.19
4799.51 14398.54
0.00 11693.32 17539.98
4486.19 7905.28 18587.21
11833.42 3001.42 22252.26
9703.58 4302.60 23709.47
12948.25 29844.05
7417.42 22252.26
106.449 106.449 106.449 634.86
106.449 106.449 106.449 638.69
0.000000 0.000000 0.000000
0.000000 0.000000 0.000000

J V S Total
0.00 0.00 3,737.41 12,113.08
2,803.87 0.00 9,325.79 18,194.50
3,814.66 0.00 23,163.02 1,569.49
0.00 9,491.48 0.00 25,099.18
ción 2010-1 UPN EF

ue se detallan a continuación:

SKU (toneladas)
Ago Sep Oct Nov Dic
2,960 2,780 2,710 2,640 2,935

AMACION POR DIA QUEDA AL CRITERIO DE CADA GRUPO

L L L L L
1 2 3 4 Total
21,329.00 0.00 21,329.00 18,282.00 60,940.00
11,550.00 13,475.00 0.00 13,475.00 38,500.00
15,125.00 15,125.00 15,125.00 15,125.00 60,500.00
18,425.00 14,740.00 18,425.00 22,110.00 73,700.00
15,620.00 19,525.00 23,430.00 19,525.00 78,100.00
23,375.00 23,375.00 23,375.00 23,375.00 93,500.00
0.00 30,162.00 40,216.00 30,162.00 100,540.00
37,620.00 37,620.00 37,620.00 12,540.00 125,400.00
14,025.00 18,700.00 28,050.00 32,725.00 93,500.00
 Colocar redondear más a la
formula de SS

2 3 4
15,787.56 9,693.56 6,647
-1,575.91 8,049.09 4,199
6,598.57 6,598.57 6,599
11,723.26 11,723.26 8,038
12,423.15 8,518.15 8,518
10,197.79 10,197.79 10,198
31,073.62 15,992.62 10,966
1,137.04 -5,132.96 13,677
24,222.79 19,547.79 10,198

2 3 4
18,402.94 12,769.68 8,489.52
1,459.09 11,375.37 5,364.18
7,513.36 7,970.75 8,428.14
12,837.89 13,395.20 10,267.52
13,604.23 10,289.77 10,880.31
11,611.69 12,318.63 13,025.58
32,594.14 18,273.39 14,006.65
4,886.43 4,065.63 17,469.07
25,636.69 21,668.63 13,025.58
 2 3 4 S inicial
18,402.94 12,769.68 8,489.52 6,646.56
1,459.09 11,375.37 5,364.18 4,199.09
7,513.36 7,970.75 8,428.14 6,598.57
12,837.89 13,395.20 10,267.52 8,038.26
13,604.23 10,289.77 10,880.31 8,518.15
11,611.69 12,318.63 13,025.58 10,197.79
29,120.49 12,099.04 14,006.65 10,965.62
4,886.43 4,065.63 17,469.07 13,677.04
25,636.69 21,668.63 13,025.58 10,197.79

toneladas/mes 825.00 toneladas/sem 137.50 toneladas/día

cajas/corrida
productos/dia

2,407.83940 5,796.55
1,938.07791 3,305.42
1,183.85500 5,194.13
1,442.33700 6,327.44
1,528.33100 6,705.18
1,829.68500 8,027.32
1,413.36684 8,374.28
2,453.95400 10,766.00
1,829.68500 8,027.32
56.35565
010-1 UPN EF
ABRIL m a
60,940 58,197.7 65,571.44
38,500 36,767.5 41,426.00
60,500 57,777.5 65,098.00
73,700 70,383.5 79,301.20
78,100 74,585.5 84,035.60
93,500 89,292.5 100,606.00
100,540 96,015.7 108,181.04
125,400 119,757.0 134,930.40
93,500 89,292.5 100,606.00
neladas/día