proyecto de aula gestión de la producción i
DESCRIPTION
proyecto de aulaTRANSCRIPT
-
PLAN MAESTRO DE PRODUCCIN APLICADO A LA EMPRESA PROMEL LTDA.DANIEL NAVARRO RAMREZJESSICA CUELLO MENDEZ LAURA NATALY GALEANO HENAOLUIS ALBERTO JARAMILLO OROZCOSEBASTIN CHICA LPEZ
DOCENTECarlos Julio Osorio Montoya
ASIGNATURAGestin de Produccin I
MEDELLN2015
-
El presente proyecto de aula, propone el Plan Maestro de Produccin para el proceso productivo de la lnea de camillas de la empresa PROMEL LTDA. El objetivo es brindar soluciones y estrategias eficaces que le apunten a mejorar y mantener el nivel de productividad deseado, mediante las herramientas estadsticas que ofrecen variedad de datos que permiten garantizar claridad frente a diversas situaciones del mercado y el alcance en la produccin.INTRODUCCIN
-
Objetivo general
Conocer la implementacin de conceptos tericos sobre un Plan Maestro de Produccin, mediante la propuesta de un proyecto de aula que recopila la temtica estudiada durante el semestre 2015-1 en la asignatura Control Gestin de la Produccin I.
OBJETIVOS
-
Objetivos especficos
Realizar una visita a la planta productiva para obtener la mayor cantidad de informacin posible.Elaborar un modelo del Plan Maestro de Produccin aplicando los criterios de optimizacin, segn la necesidad y aplicacin.Elaborar un grficos de anlisis estadstico para interpretar los resultados y sugerir soluciones al proceso productivo.
OBJETIVOS
-
PROCESO DE PRODUCCIN
De acuerdo a la visita realizada a las instalaciones de la planta productiva, se obtuvieron los siguientes datos de relevancia:La materia prima se solicita al momento de iniciar cada corrida de produccin, considerando 10 unidades extra como inventario de seguridad, respecto a insumos.Mensualmente la capacidad mxima de produccin es de 60 camillas.La fecha de vencimiento (entrega) para las camillas es de 20 das hbiles.La fecha de vencimiento para productos pequeos (escaleras) es de 5 das hbiles.La fecha de vencimiento para productos especiales (referencias personalizadas) es de 15 das hbilesLa capacidad mxima de productos terminados en stock, es de 30 unidades.Se terceriza el proceso de pintura (duracin de entrega 3 das hbiles).Cuando es necesario, se trabaja todo el turno del sbado y/o medio del domingo.
-
PLAN MAESTRO DE PRODUCCIN
El MPS es una decisin de tipo operativa, respecto a los artculos y cantidades que deben ser fabricados en el siguiente perodo de planificacin. Sus caractersticas son:
Determina qu debe hacerse y cundo Se establece en trminos de productos especficos y no en familias Es una decisin de lo que se va a producir, no un pronstico mas
Se recomienda que ya elaborado el MPS se evale en su viabilidad cada vez que corresponda a un perodo de planificacin.
-
PLAN MAESTRO DE PRODUCCIN
El MPS es una declaracin susceptible de ajustes, por lo tanto es conveniente establecer un criterio de flexibilidad por horizonte, para lo cual se tiene:
Horizonte fijo: Perodo durante el cual no se harn ajustes al MPS
Horizonte medio - fijo: Perodo en el que se pueden hacer cambios a ciertos productos.
Horizonte flexible: Perodo ms alejado, en el que es posible hacer cualquier modificacin al MPS.
-
Datos
PROMEL LTDA.
Actividad econmica: fabricacin y comercializacin de elementos mdicos hospitalariosDescansosDesayuno0.0
Almuerzo60.0
Horario de trabajo:Algo0.0
De Lunes a ViernesInicio:8:00:00 AMFin:5:00:00 PMHoras total turno L a V9.0h Trabaj.8.0descanso1.0
SbadosInicio:8:00:00 AMFin:2:00:00 PMHoras total turno S6.00h Trabaj.5.5descanso0.5
Tiempos improductivosReprocesosRotacion PersonalAusentismosTotal
1%4%2%7%Salario SMMVL 2014SMMVL 2015PrestacionesSalario+PrestTotal
Capacidad Teorica de la planta100%$ 616,00052%$ 936,320$ 936,320.0
Capacidad Real de la planta Lunes a Sabado100% - 7% =93%
Salario SMMVL 2015SMMVL 2014PrestacionesSalario+PrestTotal
REFMQUINASTotal puestos de trabajoIncremento:4.6%$ 644,33652%$ 979,391$ 979,390.7
R1 CAMILLAS110
1TIEMPO EN MINUTOS (SAM) POR UNIDAD
1REFR1: Camilla
1T/min/Und273.0
1
1
1
1
2
Total10
Dias de trabajo por semana6.00
COSTO DE LA MANO DE OBRA DIRECTA% Eficiencia extras80%
opBasicoSalario total empleadoCosto de la EmpresaCosto DiaCosto HoraCosto Minuto
1$ 644,336.0$ 644,336.0$ 977,973.2$ 32,599.11$ 4,074.888$ 67.91
cap Teorica
CAPACIDAD DE PLANTA TEORICA AL 100% 2DO SEM-2014
Enero100%Febrero100%Marzo100%Abril100%Mayo100%Junio100%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
11110011104,800
2104,8002104,800222104,800
3104,8003104,800333104,800
4104,8003104,80044104,8004104,800
5104,8003104,80055104,8005103,300
6103,3004103,3006104,8006104,800610
777104,8007104,8007
888104,8008103,3008
99104,8009104,8009104,80099104,800
1010104,8009104,80010103,3001010104,800
1111104,8009104,8001111104,80011104,800
1212104,8009104,8001212104,80012103,300
13104,80013103,30013103,30013104,80013104,80013
14104,800141414104,80014104,80014
15104,800151515104,80015103,30015104,800
16104,80016104,80016104,80016104,8001616104,800
17103,30017104,80017104,80017103,3001717104,800
1818104,80018104,80018181018104,800
1919104,80019104,8001919104,80019103,300
20104,80020103,30020103,30020104,80020104,80020
21104,800212121104,80021104,80021
22104,800222222104,80022103,30022104,800
23104,80023104,8002323104,8002323104,800
24103,30024104,80024104,80024103,3002424104,800
2525104,80025104,8002525104,80025104,800
261026104,80026102626104,80026103,300
27104,80027103,30027103,30027104,80027104,80027
28104,800282828104,80028104,80028
29104,800292929104,80029103,30029104,800
30104,8003030104,80030104,8003030104,800
31103,30031314,800313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
67,500.090,000.090,000.086,700.085,200.094,800.0
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero67,500.0022,50022,50022,50067,500
Semestre67,500.0022,50022,50022,500067,500
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero90,000.014,40022,50022,500059,400
Semestre90,000.014,40022,50022,5000059,400
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo90,000.08,10022,5008,1001599,60048,459
Semestre90,000.08,10022,5008,1001599,60048,459
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril86,700.012,90017,700090,0900120,690
Semestre506,000.012,90017,700090,0900120,690
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo85,200.019,20000022,50041,700
Semestre558,750.019,20000022,50041,700
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio94,800.000028,80022,50051,300
Semestre94,800.000028,80022,50051,300
cap Real
CAPACIDAD DE PLANTA TEORICA AL 100% 2DO SEM-2014
Enero93%Febrero93%Marzo93%Abril93%Mayo93%Junio93%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
111110011104,464
22104,4642104,464222104,464
33104,4643104,464333104,464
44104,4644104,46444104,4644104,464
55104,4645104,46455104,4645103,069
66103,0696103,0696104,4646104,4646
7777104,4647104,4647
8888104,4648103,0698
99104,4649104,4649104,46499104,464
1010104,46410104,46410103,0691010104,464
1111104,46411104,4641111104,46411104,464
1212104,46412104,4641212104,46412103,069
13104,46413103,06913103,06913104,46413104,46413
14104,464141414104,46414104,46414
15104,464151515104,46415103,06915104,464
16104,46416104,46416104,46416104,4641616104,464
17103,06917104,46417104,46417103,0691717104,464
1818104,46418104,4641818104,46418104,464
1919104,46419104,4641919104,46419103,069
20104,46420103,06920103,06920104,46420104,46420
21104,46421542121104,46421104,46421
22104,464222222104,46422103,06922104,464
23104,46423104,4642323104,4642323104,464
24103,06924104,46424104,46424103,0692424104,464
2525104,46425104,464251025104,46425104,464
261026104,4642610261026104,46426103,069
27104,46427103,06927103,06927104,46427104,4642710
28104,46428102828104,46428104,4642810
29104,4642910291029104,46429103,06929104,464
30104,4643030104,46430104,4643030104,464
31103,0693131104,464313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
62,775.083,700.083,700.080,631.083,700.088,164.0
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero62,775.0020,92520,92520,92562,775
Semestre62,775.0020,92520,92520,925062,775
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero83,700.013,39220,92520,925055,242
Semestre83,700.013,39220,92520,9250055,242
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo83,700.07,53320,9257,533035,991
Semestre83,700.07,53320,9257,5330035,991
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril80,631.011,99716,4610028,458
Semestre80,631.011,99716,46100028,458
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo83,700.017,85600017,856
Semestre83,700.017,856000017,856
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio88,164.000000
Semestre88,164.0000000
ventas
PREVISION DE VENTAS 2do SEMESTRE DE 2014
TipoEneroT/undFebreroT/undMarzoT/undAbrilT/undMayoT/undJunioT/und
Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.
R1: Camilla60273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,38060
TOTAL6016,380606027316,380606016,380606016,380606016,380606016,38060
STOCK SOLICITUD VENTAS 2do SEMESTRE DE 20145%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
STOCK SOLICITUD GERENCIA 2do SEMESTRE DE 20145%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
PREVISION + STOCK GERENCIA + STOCK VENTAS
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla66273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,01866
6618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,01866
resumen
RESUMEN COMPARATIVO DEL PLAN MAESTROPrev. y Capac. Acumulada
MesUnd/Prduc.T/Ven/MinCap/Teo/MinCap/Real/Min% Cump.Desv MinT/Ven/MinCap/Real/MinDesv Min
Enero66.0018,018.0067,500.0062,775.003.4844,75718,018.0062,775.0044,757
febrero66.0018,018.0090,000.0083,700.004.6565,68218,018.0083,700.0065,682
marzo66.0018,018.0086,700.0083,700.004.6565,68218,018.0083,700.0065,682
abril66.0018,018.0085,200.0080,631.004.4862,61318,018.0080,631.0062,613
mayo66.0018,018.0094,800.0083,700.004.6565,68218,018.0083,700.0065,682
junio66.0018,018.0090,000.0088,164.004.8970,14618,018.0088,164.0070,146
Totales396108,108514,200482,670446%374,562
resumen
PREVISION
CAP. REAL
NIVEL EN MINUTOS
Costos
Valor del minuto:$ 67.91
VALORES EN CAPACIDAD MINUTOS$67.9$84.9$135.8$84.9
MEST/normalH-Ex/semH-Ex/domH-Ex/sabTotalMEST/normalH-Ex/semH-Ex/domH-Ex/sabTotal
Enero62,77500062,775Enero$4,263,352$0$0$0$4,263,352
Febrero49,38304,464053,847Febrero$3,353,837$0$606,343$0$3,960,180
Marzo35,99104,46413,39253,847Marzo$2,444,322$0$606,343$1,136,894$4,187,559
Abril35,99104,46413,39253,847Abril$2,444,322$0$606,343$1,136,894$4,187,559
Mayo35,99104,46413,39253,847Mayo$2,444,322$0$606,343$1,136,894$4,187,559
Junio40,17603,06913,39256,637Junio$2,728,545$0$416,861$1,136,894$4,282,300
260,307020,92553,568334,800$17,678,699$0$2,842,235$4,547,575$25,068,509
$25,068,509COSTO TOTAL PLAN MAESTRO
-
Datos
PROMEL LTDA.
Actividad econmica: fabricacin y comercializacin de elementos mdicos hospitalariosDescansosDesayuno0.0
Almuerzo60.0
Horario de trabajo:Algo0.0
De Lunes a ViernesInicio:8:00:00 AMFin:5:00:00 PMHoras total turno L a V9.0h Trabaj.8.0descanso1.0
SbadosInicio:8:00:00 AMFin:2:00:00 PMHoras total turno S6.00h Trabaj.5.5descanso0.5
Tiempos improductivosReprocesosRotacion PersonalAusentismosTotal
1%4%2%7%Salario SMMVL 2014SMMVL 2015PrestacionesSalario+PrestTotal
Capacidad Teorica de la planta100%$ 616,00052%$ 936,320$ 936,320.0
Capacidad Real de la planta Lunes a Sabado100% - 7% =93%
Salario SMMVL 2015SMMVL 2014PrestacionesSalario+PrestTotal
REFMQUINASTotal puestos de trabajoIncremento:4.6%$ 644,33652%$ 979,391$ 979,390.7
R1 CAMILLAS110
1TIEMPO EN MINUTOS (SAM) POR UNIDAD
1REFR1: Camilla
1T/min/Und273.0
1
1
1
1
2
Total10
Dias de trabajo por semana6.00
COSTO DE LA MANO DE OBRA DIRECTA% Eficiencia extras80%
opBasicoSalario total empleadoCosto de la EmpresaCosto DiaCosto HoraCosto Minuto
1$ 644,336.0$ 644,336.0$ 977,973.2$ 32,599.11$ 4,074.888$ 67.91
cap Teorica
CAPACIDAD DE PLANTA TEORICA AL 100% 1ER SEM-2015
Enero100%Febrero100%Marzo100%Abril100%Mayo100%Junio100%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
11110011104,800
2104,8002104,800222104,800
3104,8003104,800333104,800
4104,8003104,80044104,8004104,800
5104,8003104,80055104,8005103,300
6103,3004103,3006104,8006104,800610
777104,8007104,8007
888104,8008103,3008
99104,8009104,8009104,80099104,800
1010104,8009104,80010103,3001010104,800
1111104,8009104,8001111104,80011104,800
1212104,8009104,8001212104,80012103,300
13104,80013103,30013103,30013104,80013104,80013
14104,800141414104,80014104,80014
15104,800151515104,80015103,30015104,800
16104,80016104,80016104,80016104,8001616104,800
17103,30017104,80017104,80017103,3001717104,800
1818104,80018104,80018181018104,800
1919104,80019104,8001919104,80019103,300
20104,80020103,30020103,30020104,80020104,80020
21104,800212121104,80021104,80021
22104,800222222104,80022103,30022104,800
23104,80023104,8002323104,8002323104,800
24103,30024104,80024104,80024103,3002424104,800
2525104,80025104,8002525104,80025104,800
261026104,80026102626104,80026103,300
27104,80027103,30027103,30027104,80027104,80027
28104,800282828104,80028104,80028
29104,800292929104,80029103,30029104,800
30104,8003030104,80030104,8003030104,800
31103,30031314,800313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
67,500.090,000.090,000.086,700.085,200.094,800.0
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero67,500.0022,50022,50022,50067,500
Semestre67,500.0022,50022,50022,500067,500
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero90,000.014,40022,50022,500059,400
Semestre90,000.014,40022,50022,5000059,400
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo90,000.08,10022,5008,1001599,60048,459
Semestre90,000.08,10022,5008,1001599,60048,459
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril86,700.012,90017,700090,0900120,690
Semestre506,000.012,90017,700090,0900120,690
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo85,200.019,20000022,50041,700
Semestre558,750.019,20000022,50041,700
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio94,800.000028,80022,50051,300
Semestre94,800.000028,80022,50051,300
cap Real
CAPACIDAD DE PLANTA TEORICA AL 100% 1ER SEM-2015
Enero93%Febrero93%Marzo93%Abril93%Mayo93%Junio93%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
111110011104,464
22104,4642104,464222104,464
33104,4643104,464333104,464
44104,4644104,46444104,4644104,464
55104,4645104,46455104,4645103,069
66103,0696103,0696104,4646104,4646
7777104,4647104,4647
8888104,4648103,0698
99104,4649104,4649104,46499104,464
1010104,46410104,46410103,0691010104,464
1111104,46411104,4641111104,46411104,464
1212104,46412104,4641212104,46412103,069
13104,46413103,06913103,06913104,46413104,46413
14104,464141414104,46414104,46414
15104,464151515104,46415103,06915104,464
16104,46416104,46416104,46416104,4641616104,464
17103,06917104,46417104,46417103,0691717104,464
1818104,46418104,4641818104,46418104,464
1919104,46419104,4641919104,46419103,069
20104,46420103,06920103,06920104,46420104,46420
21104,46421542121104,46421104,46421
22104,464222222104,46422103,06922104,464
23104,46423104,4642323104,4642323104,464
24103,06924104,46424104,46424103,0692424104,464
2525104,46425104,464251025104,46425104,464
261026104,4642610261026104,46426103,069
27104,46427103,06927103,06927104,46427104,4642710
28104,46428102828104,46428104,4642810
29104,4642910291029104,46429103,06929104,464
30104,4643030104,46430104,4643030104,464
31103,0693131104,464313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
62,775.083,700.083,700.080,631.083,700.088,164.0
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero62,775.0020,92520,92520,92562,775
Semestre62,775.0020,92520,92520,925062,775
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero83,700.013,39220,92520,925055,242
Semestre83,700.013,39220,92520,9250055,242
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo83,700.07,53320,9257,533035,991
Semestre83,700.07,53320,9257,5330035,991
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril80,631.011,99716,4610028,458
Semestre80,631.011,99716,46100028,458
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo83,700.017,85600017,856
Semestre83,700.017,856000017,856
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio88,164.000000
Semestre88,164.0000000
ventas
PREVISION DE VENTAS 2do SEMESTRE DE 2014
TipoEneroT/undFebreroT/undMarzoT/undAbrilT/undMayoT/undJunioT/und
Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.
R1: Camilla60273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,38060
TOTAL6016,380606027316,380606016,380606016,380606016,380606016,38060
STOCK SOLICITUD VENTAS 2do SEMESTRE DE 20145%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
STOCK SOLICITUD GERENCIA 2do SEMESTRE DE 20145%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
PREVISION + STOCK GERENCIA + STOCK VENTAS
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla66273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,01866
6618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,01866
resumen
RESUMEN COMPARATIVO DEL PLAN MAESTROPrev. y Capac. Acumulada
MesUnd/Prduc.T/Ven/MinCap/Teo/MinCap/Real/Min% Cump.Desv MinT/Ven/MinCap/Real/MinDesv Min
Enero66.0018,018.0067,500.0062,775.003.4844,75718,018.0062,775.0044,757
febrero66.0018,018.0090,000.0083,700.004.6565,68218,018.0083,700.0065,682
marzo66.0018,018.0086,700.0083,700.004.6565,68218,018.0083,700.0065,682
abril66.0018,018.0085,200.0080,631.004.4862,61318,018.0080,631.0062,613
mayo66.0018,018.0094,800.0083,700.004.6565,68218,018.0083,700.0065,682
junio66.0018,018.0090,000.0088,164.004.8970,14618,018.0088,164.0070,146
Totales396108,108514,200482,670446%374,562
resumen
PREVISION
CAP. REAL
NIVEL EN MINUTOS
Costos
Valor del minuto:$ 67.91
VALORES EN CAPACIDAD MINUTOS$67.9$84.9$135.8$84.9
MEST/normalH-Ex/semH-Ex/domH-Ex/sabTotalMEST/normalH-Ex/semH-Ex/domH-Ex/sabTotal
Enero62,77500062,775Enero$4,263,352$0$0$0$4,263,352
Febrero49,38304,464053,847Febrero$3,353,837$0$606,343$0$3,960,180
Marzo35,99104,46413,39253,847Marzo$2,444,322$0$606,343$1,136,894$4,187,559
Abril35,99104,46413,39253,847Abril$2,444,322$0$606,343$1,136,894$4,187,559
Mayo35,99104,46413,39253,847Mayo$2,444,322$0$606,343$1,136,894$4,187,559
Junio40,17603,06913,39256,637Junio$2,728,545$0$416,861$1,136,894$4,282,300
260,307020,92553,568334,800$17,678,699$0$2,842,235$4,547,575$25,068,509
$25,068,509COSTO TOTAL PLAN MAESTRO
Datos
PROMEL LTDA.
Actividad econmica: fabricacin y comercializacin de elementos mdicos hospitalariosDescansosDesayuno0.0
Almuerzo60.0
Horario de trabajo:Algo0.0
De Lunes a ViernesInicio:8:00:00 AMFin:5:00:00 PMHoras total turno L a V9.0h Trabaj.8.0descanso1.0
SbadosInicio:8:00:00 AMFin:2:00:00 PMHoras total turno S6.00h Trabaj.5.5descanso0.5
Tiempos improductivosReprocesosRotacion PersonalAusentismosTotal
1%4%2%7%Salario SMMVL 2014SMMVL 2015PrestacionesSalario+PrestTotal
Capacidad Teorica de la planta100%$ 616,00052%$ 936,320$ 936,320.0
Capacidad Real de la planta Lunes a Sabado100% - 7% =93%
Salario SMMVL 2015SMMVL 2014PrestacionesSalario+PrestTotal
REFMQUINASTotal puestos de trabajoIncremento:4.6%$ 644,33652%$ 979,391$ 979,390.7
R1 CAMILLAS110
1TIEMPO EN MINUTOS (SAM) POR UNIDAD
1REFR1: Camilla
1T/min/Und273.0
1
1
1
1
2
Total10
Dias de trabajo por semana6.00
COSTO DE LA MANO DE OBRA DIRECTA% Eficiencia extras80%
opBasicoSalario total empleadoCosto de la EmpresaCosto DiaCosto HoraCosto Minuto
1$ 644,336.0$ 644,336.0$ 977,973.2$ 32,599.11$ 4,074.888$ 67.91
cap Teorica
CAPACIDAD DE PLANTA TEORICA AL 100% 1ER SEM-2015
Enero100%Febrero100%Marzo100%Abril100%Mayo100%Junio100%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
11110011104,800
2104,8002104,800222104,800
3104,8003104,800333104,800
4104,8003104,80044104,8004104,800
5104,8003104,80055104,8005103,300
6103,3004103,3006104,8006104,800610
777104,8007104,8007
888104,8008103,3008
99104,8009104,8009104,80099104,800
1010104,8009104,80010103,3001010104,800
1111104,8009104,8001111104,80011104,800
1212104,8009104,8001212104,80012103,300
13104,80013103,30013103,30013104,80013104,80013
14104,800141414104,80014104,80014
15104,800151515104,80015103,30015104,800
16104,80016104,80016104,80016104,8001616104,800
17103,30017104,80017104,80017103,3001717104,800
1818104,80018104,80018181018104,800
1919104,80019104,8001919104,80019103,300
20104,80020103,30020103,30020104,80020104,80020
21104,800212121104,80021104,80021
22104,800222222104,80022103,30022104,800
23104,80023104,8002323104,8002323104,800
24103,30024104,80024104,80024103,3002424104,800
2525104,80025104,8002525104,80025104,800
261026104,80026102626104,80026103,300
27104,80027103,30027103,30027104,80027104,80027
28104,800282828104,80028104,80028
29104,800292929104,80029103,30029104,800
30104,8003030104,80030104,8003030104,800
31103,30031314,800313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
67,500.090,000.090,000.086,700.085,200.094,800.0
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero67,500.0022,50022,50022,50067,500
Semestre67,500.0022,50022,50022,500067,500
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero90,000.014,40022,50022,500059,400
Semestre90,000.014,40022,50022,5000059,400
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo90,000.08,10022,5008,1001599,60048,459
Semestre90,000.08,10022,5008,1001599,60048,459
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril86,700.012,90017,700090,0900120,690
Semestre506,000.012,90017,700090,0900120,690
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo85,200.019,20000022,50041,700
Semestre558,750.019,20000022,50041,700
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio94,800.000028,80022,50051,300
Semestre94,800.000028,80022,50051,300
cap Real
CAPACIDAD DE PLANTA TEORICA AL 100% 1ER SEM-2015
Enero93%Febrero93%Marzo93%Abril93%Mayo93%Junio93%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
111110011104,464
22104,4642104,464222104,464
33104,4643104,464333104,464
44104,4644104,46444104,4644104,464
55104,4645104,46455104,4645103,069
66103,0696103,0696104,4646104,4646
7777104,4647104,4647
8888104,4648103,0698
99104,4649104,4649104,46499104,464
1010104,46410104,46410103,0691010104,464
1111104,46411104,4641111104,46411104,464
1212104,46412104,4641212104,46412103,069
13104,46413103,06913103,06913104,46413104,46413
14104,464141414104,46414104,46414
15104,464151515104,46415103,06915104,464
16104,46416104,46416104,46416104,4641616104,464
17103,06917104,46417104,46417103,0691717104,464
1818104,46418104,4641818104,46418104,464
1919104,46419104,4641919104,46419103,069
20104,46420103,06920103,06920104,46420104,46420
21104,46421542121104,46421104,46421
22104,464222222104,46422103,06922104,464
23104,46423104,4642323104,4642323104,464
24103,06924104,46424104,46424103,0692424104,464
2525104,46425104,464251025104,46425104,464
261026104,4642610261026104,46426103,069
27104,46427103,06927103,06927104,46427104,4642710
28104,46428102828104,46428104,4642810
29104,4642910291029104,46429103,06929104,464
30104,4643030104,46430104,4643030104,464
31103,0693131104,464313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
62,775.083,700.083,700.080,631.083,700.088,164.0
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero62,775.0020,92520,92520,92562,775
Semestre62,775.0020,92520,92520,925062,775
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero83,700.013,39220,92520,925055,242
Semestre83,700.013,39220,92520,9250055,242
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo83,700.07,53320,9257,533035,991
Semestre83,700.07,53320,9257,5330035,991
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril80,631.011,99716,4610028,458
Semestre80,631.011,99716,46100028,458
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo83,700.017,85600017,856
Semestre83,700.017,856000017,856
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio88,164.000000
Semestre88,164.0000000
ventas
PREVISION DE VENTAS 2do SEMESTRE DE 2014
TipoEneroT/undFebreroT/undMarzoT/undAbrilT/undMayoT/undJunioT/und
Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.
R1: Camilla60273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,38060
TOTAL6016,380606027316,380606016,380606016,380606016,380606016,38060
STOCK SOLICITUD VENTAS 2do SEMESTRE DE 20145%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
STOCK SOLICITUD GERENCIA 2do SEMESTRE DE 20145%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
PREVISION + STOCK GERENCIA + STOCK VENTAS
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla66273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,01866
6618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,01866
resumen
RESUMEN COMPARATIVO DEL PLAN MAESTROPrev. y Capac. Acumulada
MesUnd/Prduc.T/Ven/MinCap/Teo/MinCap/Real/Min% Cump.Desv MinT/Ven/MinCap/Real/MinDesv Min
Enero66.0018,018.0067,500.0062,775.003.4844,75718,018.0062,775.0044,757
febrero66.0018,018.0090,000.0083,700.004.6565,68218,018.0083,700.0065,682
marzo66.0018,018.0086,700.0083,700.004.6565,68218,018.0083,700.0065,682
abril66.0018,018.0085,200.0080,631.004.4862,61318,018.0080,631.0062,613
mayo66.0018,018.0094,800.0083,700.004.6565,68218,018.0083,700.0065,682
junio66.0018,018.0090,000.0088,164.004.8970,14618,018.0088,164.0070,146
Totales396108,108514,200482,670446%374,562
resumen
PREVISION
CAP. REAL
NIVEL EN MINUTOS
Costos
Valor del minuto:$ 67.91
VALORES EN CAPACIDAD MINUTOS$67.9$84.9$135.8$84.9
MEST/normalH-Ex/semH-Ex/domH-Ex/sabTotalMEST/normalH-Ex/semH-Ex/domH-Ex/sabTotal
Enero62,77500062,775Enero$4,263,352$0$0$0$4,263,352
Febrero49,38304,464053,847Febrero$3,353,837$0$606,343$0$3,960,180
Marzo35,99104,46413,39253,847Marzo$2,444,322$0$606,343$1,136,894$4,187,559
Abril35,99104,46413,39253,847Abril$2,444,322$0$606,343$1,136,894$4,187,559
Mayo35,99104,46413,39253,847Mayo$2,444,322$0$606,343$1,136,894$4,187,559
Junio40,17603,06913,39256,637Junio$2,728,545$0$416,861$1,136,894$4,282,300
260,307020,92553,568334,800$17,678,699$0$2,842,235$4,547,575$25,068,509
$25,068,509COSTO TOTAL PLAN MAESTRO
-
Datos
PROMEL LTDA.
Actividad econmica: fabricacin y comercializacin de elementos mdicos hospitalariosDescansosDesayuno0.0
Almuerzo60.0
Horario de trabajo:Algo0.0
De Lunes a ViernesInicio:8:00:00 AMFin:5:00:00 PMHoras total turno L a V9.0h Trabaj.8.0descanso1.0
SbadosInicio:8:00:00 AMFin:2:00:00 PMHoras total turno S6.00h Trabaj.5.5descanso0.5
Tiempos improductivosReprocesosRotacion PersonalAusentismosTotal
1%4%2%7%Salario SMMVL 2014SMMVL 2015PrestacionesSalario+PrestTotal
Capacidad Teorica de la planta100%$ 616,00052%$ 936,320$ 936,320.0
Capacidad Real de la planta Lunes a Sabado100% - 7% =93%
Salario SMMVL 2015SMMVL 2014PrestacionesSalario+PrestTotal
REFMQUINASTotal puestos de trabajoIncremento:4.6%$ 644,33652%$ 979,391$ 979,390.7
R1 CAMILLAS110
1TIEMPO EN MINUTOS (SAM) POR UNIDAD
1REFR1: Camilla
1T/min/Und273.0
1
1
1
1
2
Total10
Dias de trabajo por semana6.00
COSTO DE LA MANO DE OBRA DIRECTA% Eficiencia extras80%
opBasicoSalario total empleadoCosto de la EmpresaCosto DiaCosto HoraCosto Minuto
1$ 644,336.0$ 644,336.0$ 977,973.2$ 32,599.11$ 4,074.888$ 67.91
cap Teorica
CAPACIDAD DE PLANTA TEORICA AL 100% 1ER SEM-2015
Enero100%Febrero100%Marzo100%Abril100%Mayo100%Junio100%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
11110011104,800
2104,8002104,800222104,800
3104,8003104,800333104,800
4104,8003104,80044104,8004104,800
5104,8003104,80055104,8005103,300
6103,3004103,3006104,8006104,800610
777104,8007104,8007
888104,8008103,3008
99104,8009104,8009104,80099104,800
1010104,8009104,80010103,3001010104,800
1111104,8009104,8001111104,80011104,800
1212104,8009104,8001212104,80012103,300
13104,80013103,30013103,30013104,80013104,80013
14104,800141414104,80014104,80014
15104,800151515104,80015103,30015104,800
16104,80016104,80016104,80016104,8001616104,800
17103,30017104,80017104,80017103,3001717104,800
1818104,80018104,80018181018104,800
1919104,80019104,8001919104,80019103,300
20104,80020103,30020103,30020104,80020104,80020
21104,800212121104,80021104,80021
22104,800222222104,80022103,30022104,800
23104,80023104,8002323104,8002323104,800
24103,30024104,80024104,80024103,3002424104,800
2525104,80025104,8002525104,80025104,800
261026104,80026102626104,80026103,300
27104,80027103,30027103,30027104,80027104,80027
28104,800282828104,80028104,80028
29104,800292929104,80029103,30029104,800
30104,8003030104,80030104,8003030104,800
31103,30031314,800313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
67,500.090,000.090,000.086,700.085,200.094,800.0
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero67,500.0022,50022,50022,50067,500
Semestre67,500.0022,50022,50022,500067,500
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero90,000.014,40022,50022,500059,400
Semestre90,000.014,40022,50022,5000059,400
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo90,000.08,10022,5008,1001599,60048,459
Semestre90,000.08,10022,5008,1001599,60048,459
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril86,700.012,90017,700090,0900120,690
Semestre506,000.012,90017,700090,0900120,690
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo85,200.019,20000022,50041,700
Semestre558,750.019,20000022,50041,700
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio94,800.000028,80022,50051,300
Semestre94,800.000028,80022,50051,300
cap Real
CAPACIDAD DE PLANTA REAL AL 93% 1ER SEM-2015
Enero93%Febrero93%Marzo93%Abril93%Mayo93%Junio93%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
111110011104,464
22104,4642104,464222104,464
33104,4643104,464333104,464
44104,4644104,46444104,4644104,464
55104,4645104,46455104,4645103,069
66103,0696103,0696104,4646104,4646
7777104,4647104,4647
8888104,4648103,0698
99104,4649104,4649104,46499104,464
1010104,46410104,46410103,0691010104,464
1111104,46411104,4641111104,46411104,464
1212104,46412104,4641212104,46412103,069
13104,46413103,06913103,06913104,46413104,46413
14104,464141414104,46414104,46414
15104,464151515104,46415103,06915104,464
16104,46416104,46416104,46416104,4641616104,464
17103,06917104,46417104,46417103,0691717104,464
1818104,46418104,4641818104,46418104,464
1919104,46419104,4641919104,46419103,069
20104,46420103,06920103,06920104,46420104,46420
21104,46421542121104,46421104,46421
22104,464222222104,46422103,06922104,464
23104,46423104,4642323104,4642323104,464
24103,06924104,46424104,46424103,0692424104,464
2525104,46425104,464251025104,46425104,464
261026104,4642610261026104,46426103,069
27104,46427103,06927103,06927104,46427104,4642710
28104,46428102828104,46428104,4642810
29104,4642910291029104,46429103,06929104,464
30104,4643030104,46430104,4643030104,464
31103,0693131104,464313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
62,775.083,700.083,700.080,631.083,700.088,164.0
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero62,775.0020,92520,92520,92562,775
Semestre62,775.0020,92520,92520,925062,775
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero83,700.013,39220,92520,925055,242
Semestre83,700.013,39220,92520,9250055,242
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo83,700.07,53320,9257,533035,991
Semestre83,700.07,53320,9257,5330035,991
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril80,631.011,99716,4610028,458
Semestre80,631.011,99716,46100028,458
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo83,700.017,85600017,856
Semestre83,700.017,856000017,856
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio88,164.000000
Semestre88,164.0000000
ventas
PREVISION DE VENTAS 2do SEMESTRE DE 2014
TipoEneroT/undFebreroT/undMarzoT/undAbrilT/undMayoT/undJunioT/und
Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.
R1: Camilla60273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,38060
TOTAL6016,380606027316,380606016,380606016,380606016,380606016,38060
STOCK SOLICITUD VENTAS 2do SEMESTRE DE 20145%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
STOCK SOLICITUD GERENCIA 2do SEMESTRE DE 20145%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
PREVISION + STOCK GERENCIA + STOCK VENTAS
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla66273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,01866
6618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,01866
resumen
RESUMEN COMPARATIVO DEL PLAN MAESTROPrev. y Capac. Acumulada
MesUnd/Prduc.T/Ven/MinCap/Teo/MinCap/Real/Min% Cump.Desv MinT/Ven/MinCap/Real/MinDesv Min
Enero66.0018,018.0067,500.0062,775.003.4844,75718,018.0062,775.0044,757
febrero66.0018,018.0090,000.0083,700.004.6565,68218,018.0083,700.0065,682
marzo66.0018,018.0086,700.0083,700.004.6565,68218,018.0083,700.0065,682
abril66.0018,018.0085,200.0080,631.004.4862,61318,018.0080,631.0062,613
mayo66.0018,018.0094,800.0083,700.004.6565,68218,018.0083,700.0065,682
junio66.0018,018.0090,000.0088,164.004.8970,14618,018.0088,164.0070,146
Totales396108,108514,200482,670446%374,562
resumen
PREVISION
CAP. REAL
NIVEL EN MINUTOS
Costos
Valor del minuto:$ 67.91
VALORES EN CAPACIDAD MINUTOS$67.9$84.9$135.8$84.9
MEST/normalH-Ex/semH-Ex/domH-Ex/sabTotalMEST/normalH-Ex/semH-Ex/domH-Ex/sabTotal
Enero62,77500062,775Enero$4,263,352$0$0$0$4,263,352
Febrero49,38304,464053,847Febrero$3,353,837$0$606,343$0$3,960,180
Marzo35,99104,46413,39253,847Marzo$2,444,322$0$606,343$1,136,894$4,187,559
Abril35,99104,46413,39253,847Abril$2,444,322$0$606,343$1,136,894$4,187,559
Mayo35,99104,46413,39253,847Mayo$2,444,322$0$606,343$1,136,894$4,187,559
Junio40,17603,06913,39256,637Junio$2,728,545$0$416,861$1,136,894$4,282,300
260,307020,92553,568334,800$17,678,699$0$2,842,235$4,547,575$25,068,509
$25,068,509COSTO TOTAL PLAN MAESTRO
Datos
PROMEL LTDA.
Actividad econmica: fabricacin y comercializacin de elementos mdicos hospitalariosDescansosDesayuno0.0
Almuerzo60.0
Horario de trabajo:Algo0.0
De Lunes a ViernesInicio:8:00:00 AMFin:5:00:00 PMHoras total turno L a V9.0h Trabaj.8.0descanso1.0
SbadosInicio:8:00:00 AMFin:2:00:00 PMHoras total turno S6.00h Trabaj.5.5descanso0.5
Tiempos improductivosReprocesosRotacion PersonalAusentismosTotal
1%4%2%7%Salario SMMVL 2014SMMVL 2015PrestacionesSalario+PrestTotal
Capacidad Teorica de la planta100%$ 616,00052%$ 936,320$ 936,320.0
Capacidad Real de la planta Lunes a Sabado100% - 7% =93%
Salario SMMVL 2015SMMVL 2014PrestacionesSalario+PrestTotal
REFMQUINASTotal puestos de trabajoIncremento:4.6%$ 644,33652%$ 979,391$ 979,390.7
R1 CAMILLAS110
1TIEMPO EN MINUTOS (SAM) POR UNIDAD
1REFR1: Camilla
1T/min/Und273.0
1
1
1
1
2
Total10
Dias de trabajo por semana6.00
COSTO DE LA MANO DE OBRA DIRECTA% Eficiencia extras80%
opBasicoSalario total empleadoCosto de la EmpresaCosto DiaCosto HoraCosto Minuto
1$ 644,336.0$ 644,336.0$ 977,973.2$ 32,599.11$ 4,074.888$ 67.91
cap Teorica
CAPACIDAD DE PLANTA TEORICA AL 100% 1ER SEM-2015
Enero100%Febrero100%Marzo100%Abril100%Mayo100%Junio100%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
11110011104,800
2104,8002104,800222104,800
3104,8003104,800333104,800
4104,8003104,80044104,8004104,800
5104,8003104,80055104,8005103,300
6103,3004103,3006104,8006104,800610
777104,8007104,8007
888104,8008103,3008
99104,8009104,8009104,80099104,800
1010104,8009104,80010103,3001010104,800
1111104,8009104,8001111104,80011104,800
1212104,8009104,8001212104,80012103,300
13104,80013103,30013103,30013104,80013104,80013
14104,800141414104,80014104,80014
15104,800151515104,80015103,30015104,800
16104,80016104,80016104,80016104,8001616104,800
17103,30017104,80017104,80017103,3001717104,800
1818104,80018104,80018181018104,800
1919104,80019104,8001919104,80019103,300
20104,80020103,30020103,30020104,80020104,80020
21104,800212121104,80021104,80021
22104,800222222104,80022103,30022104,800
23104,80023104,8002323104,8002323104,800
24103,30024104,80024104,80024103,3002424104,800
2525104,80025104,8002525104,80025104,800
261026104,80026102626104,80026103,300
27104,80027103,30027103,30027104,80027104,80027
28104,800282828104,80028104,80028
29104,800292929104,80029103,30029104,800
30104,8003030104,80030104,8003030104,800
31103,30031314,800313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
67,500.090,000.090,000.086,700.085,200.094,800.0
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero67,500.0022,50022,50022,50067,500
Semestre67,500.0022,50022,50022,500067,500
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero90,000.014,40022,50022,500059,400
Semestre90,000.014,40022,50022,5000059,400
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo90,000.08,10022,5008,1001599,60048,459
Semestre90,000.08,10022,5008,1001599,60048,459
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril86,700.012,90017,700090,0900120,690
Semestre506,000.012,90017,700090,0900120,690
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo85,200.019,20000022,50041,700
Semestre558,750.019,20000022,50041,700
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio94,800.000028,80022,50051,300
Semestre94,800.000028,80022,50051,300
cap Real
CAPACIDAD DE PLANTA TEORICA AL 100% 1ER SEM-2015
Enero93%Febrero93%Marzo93%Abril93%Mayo93%Junio93%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
111110011104,464
22104,4642104,464222104,464
33104,4643104,464333104,464
44104,4644104,46444104,4644104,464
55104,4645104,46455104,4645103,069
66103,0696103,0696104,4646104,4646
7777104,4647104,4647
8888104,4648103,0698
99104,4649104,4649104,46499104,464
1010104,46410104,46410103,0691010104,464
1111104,46411104,4641111104,46411104,464
1212104,46412104,4641212104,46412103,069
13104,46413103,06913103,06913104,46413104,46413
14104,464141414104,46414104,46414
15104,464151515104,46415103,06915104,464
16104,46416104,46416104,46416104,4641616104,464
17103,06917104,46417104,46417103,0691717104,464
1818104,46418104,4641818104,46418104,464
1919104,46419104,4641919104,46419103,069
20104,46420103,06920103,06920104,46420104,46420
21104,46421542121104,46421104,46421
22104,464222222104,46422103,06922104,464
23104,46423104,4642323104,4642323104,464
24103,06924104,46424104,46424103,0692424104,464
2525104,46425104,464251025104,46425104,464
261026104,4642610261026104,46426103,069
27104,46427103,06927103,06927104,46427104,4642710
28104,46428102828104,46428104,4642810
29104,4642910291029104,46429103,06929104,464
30104,4643030104,46430104,4643030104,464
31103,0693131104,464313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
62,775.083,700.083,700.080,631.083,700.088,164.0
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero62,775.0020,92520,92520,92562,775
Semestre62,775.0020,92520,92520,925062,775
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero83,700.013,39220,92520,925055,242
Semestre83,700.013,39220,92520,9250055,242
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo83,700.07,53320,9257,533035,991
Semestre83,700.07,53320,9257,5330035,991
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril80,631.011,99716,4610028,458
Semestre80,631.011,99716,46100028,458
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo83,700.017,85600017,856
Semestre83,700.017,856000017,856
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio88,164.000000
Semestre88,164.0000000
ventas
PREVISION DE VENTAS 2do SEMESTRE DE 2014
TipoEneroT/undFebreroT/undMarzoT/undAbrilT/undMayoT/undJunioT/und
Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.
R1: Camilla60273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,38060
TOTAL6016,380606027316,380606016,380606016,380606016,380606016,38060
STOCK SOLICITUD VENTAS 2do SEMESTRE DE 20145%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
STOCK SOLICITUD GERENCIA 2do SEMESTRE DE 20145%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
PREVISION + STOCK GERENCIA + STOCK VENTAS
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla66273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,01866
6618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,01866
resumen
RESUMEN COMPARATIVO DEL PLAN MAESTROPrev. y Capac. Acumulada
MesUnd/Prduc.T/Ven/MinCap/Teo/MinCap/Real/Min% Cump.Desv MinT/Ven/MinCap/Real/MinDesv Min
Enero66.0018,018.0067,500.0062,775.003.4844,75718,018.0062,775.0044,757
febrero66.0018,018.0090,000.0083,700.004.6565,68218,018.0083,700.0065,682
marzo66.0018,018.0086,700.0083,700.004.6565,68218,018.0083,700.0065,682
abril66.0018,018.0085,200.0080,631.004.4862,61318,018.0080,631.0062,613
mayo66.0018,018.0094,800.0083,700.004.6565,68218,018.0083,700.0065,682
junio66.0018,018.0090,000.0088,164.004.8970,14618,018.0088,164.0070,146
Totales396108,108514,200482,670446%374,562
resumen
PREVISION
CAP. REAL
NIVEL EN MINUTOS
Costos
Valor del minuto:$ 67.91
VALORES EN CAPACIDAD MINUTOS$67.9$84.9$135.8$84.9
MEST/normalH-Ex/semH-Ex/domH-Ex/sabTotalMEST/normalH-Ex/semH-Ex/domH-Ex/sabTotal
Enero62,77500062,775Enero$4,263,352$0$0$0$4,263,352
Febrero49,38304,464053,847Febrero$3,353,837$0$606,343$0$3,960,180
Marzo35,99104,46413,39253,847Marzo$2,444,322$0$606,343$1,136,894$4,187,559
Abril35,99104,46413,39253,847Abril$2,444,322$0$606,343$1,136,894$4,187,559
Mayo35,99104,46413,39253,847Mayo$2,444,322$0$606,343$1,136,894$4,187,559
Junio40,17603,06913,39256,637Junio$2,728,545$0$416,861$1,136,894$4,282,300
260,307020,92553,568334,800$17,678,699$0$2,842,235$4,547,575$25,068,509
$25,068,509COSTO TOTAL PLAN MAESTRO
-
Datos
PROMEL LTDA.
Actividad econmica: fabricacin y comercializacin de elementos mdicos hospitalariosDescansosDesayuno0.0
Almuerzo60.0
Horario de trabajo:Algo0.0
De Lunes a ViernesInicio:8:00:00 AMFin:5:00:00 PMHoras total turno L a V9.0h Trabaj.8.0descanso1.0
SbadosInicio:8:00:00 AMFin:2:00:00 PMHoras total turno S6.00h Trabaj.5.5descanso0.5
Tiempos improductivosReprocesosRotacion PersonalAusentismosTotal
1%4%2%7%Salario SMMVL 2014SMMVL 2015PrestacionesSalario+PrestTotal
Capacidad Teorica de la planta100%$ 616,00052%$ 936,320$ 936,320.0
Capacidad Real de la planta Lunes a Sabado100% - 7% =93%
Salario SMMVL 2015SMMVL 2014PrestacionesSalario+PrestTotal
REFMQUINASTotal puestos de trabajoIncremento:4.6%$ 644,33652%$ 979,391$ 979,390.7
R1 CAMILLAS110
1TIEMPO EN MINUTOS (SAM) POR UNIDAD
1REFR1: Camilla
1T/min/Und273.0
1
1
1
1
2
Total10
Dias de trabajo por semana6.00
COSTO DE LA MANO DE OBRA DIRECTA% Eficiencia extras80%
opBasicoSalario total empleadoCosto de la EmpresaCosto DiaCosto HoraCosto Minuto
1$ 644,336.0$ 644,336.0$ 977,973.2$ 32,599.11$ 4,074.888$ 67.91
cap Teorica
CAPACIDAD DE PLANTA TEORICA AL 100% 1ER SEM-2015
Enero100%Febrero100%Marzo100%Abril100%Mayo100%Junio100%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
11110011104,800
2104,8002104,800222104,800
3104,8003104,800333104,800
4104,8003104,80044104,8004104,800
5104,8003104,80055104,8005103,300
6103,3004103,3006104,8006104,800610
777104,8007104,8007
888104,8008103,3008
99104,8009104,8009104,80099104,800
1010104,8009104,80010103,3001010104,800
1111104,8009104,8001111104,80011104,800
1212104,8009104,8001212104,80012103,300
13104,80013103,30013103,30013104,80013104,80013
14104,800141414104,80014104,80014
15104,800151515104,80015103,30015104,800
16104,80016104,80016104,80016104,8001616104,800
17103,30017104,80017104,80017103,3001717104,800
1818104,80018104,80018181018104,800
1919104,80019104,8001919104,80019103,300
20104,80020103,30020103,30020104,80020104,80020
21104,800212121104,80021104,80021
22104,800222222104,80022103,30022104,800
23104,80023104,8002323104,8002323104,800
24103,30024104,80024104,80024103,3002424104,800
2525104,80025104,8002525104,80025104,800
261026104,80026102626104,80026103,300
27104,80027103,30027103,30027104,80027104,80027
28104,800282828104,80028104,80028
29104,800292929104,80029103,30029104,800
30104,8003030104,80030104,8003030104,800
31103,30031314,800313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
67,500.090,000.090,000.086,700.085,200.094,800.0
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero67,500.0022,50022,50022,50067,500
Semestre67,500.0022,50022,50022,500067,500
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero90,000.014,40022,50022,500059,400
Semestre90,000.014,40022,50022,5000059,400
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo90,000.08,10022,5008,1001599,60048,459
Semestre90,000.08,10022,5008,1001599,60048,459
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril86,700.012,90017,700090,0900120,690
Semestre506,000.012,90017,700090,0900120,690
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo85,200.019,20000022,50041,700
Semestre558,750.019,20000022,50041,700
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio94,800.000028,80022,50051,300
Semestre94,800.000028,80022,50051,300
cap Real
CAPACIDAD DE PLANTA TEORICA AL 100% 1ER SEM-2015
Enero93%Febrero93%Marzo93%Abril93%Mayo93%Junio93%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
111110011104,464
22104,4642104,464222104,464
33104,4643104,464333104,464
44104,4644104,46444104,4644104,464
55104,4645104,46455104,4645103,069
66103,0696103,0696104,4646104,4646
7777104,4647104,4647
8888104,4648103,0698
99104,4649104,4649104,46499104,464
1010104,46410104,46410103,0691010104,464
1111104,46411104,4641111104,46411104,464
1212104,46412104,4641212104,46412103,069
13104,46413103,06913103,06913104,46413104,46413
14104,464141414104,46414104,46414
15104,464151515104,46415103,06915104,464
16104,46416104,46416104,46416104,4641616104,464
17103,06917104,46417104,46417103,0691717104,464
1818104,46418104,4641818104,46418104,464
1919104,46419104,4641919104,46419103,069
20104,46420103,06920103,06920104,46420104,46420
21104,46421542121104,46421104,46421
22104,464222222104,46422103,06922104,464
23104,46423104,4642323104,4642323104,464
24103,06924104,46424104,46424103,0692424104,464
2525104,46425104,464251025104,46425104,464
261026104,4642610261026104,46426103,069
27104,46427103,06927103,06927104,46427104,4642710
28104,46428102828104,46428104,4642810
29104,4642910291029104,46429103,06929104,464
30104,4643030104,46430104,4643030104,464
31103,0693131104,464313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
62,775.083,700.083,700.080,631.083,700.088,164.0
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero62,775.0020,92520,92520,92562,775
Semestre62,775.0020,92520,92520,925062,775
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero83,700.013,39220,92520,925055,242
Semestre83,700.013,39220,92520,9250055,242
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo83,700.07,53320,9257,533035,991
Semestre83,700.07,53320,9257,5330035,991
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril80,631.011,99716,4610028,458
Semestre80,631.011,99716,46100028,458
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo83,700.017,85600017,856
Semestre83,700.017,856000017,856
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio88,164.000000
Semestre88,164.0000000
ventas
PREVISION DE VENTAS 1ER SEMESTRE DE 2015
TipoEneroT/undFebreroT/undMarzoT/undAbrilT/undMayoT/undJunioT/und
Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.
R1: Camilla60273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,38060
TOTAL6016,380606027316,380606016,380606016,380606016,380606016,38060
STOCK SOLICITUD VENTAS 1ER SEMESTRE DE 20155%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
STOCK SOLICITUD GERENCIA 1ER SEMESTRE DE 20155%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
PREVISION + STOCK GERENCIA + STOCK VENTAS
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla66273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,01866
6618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,01866
resumen
RESUMEN COMPARATIVO DEL PLAN MAESTROPrev. y Capac. Acumulada
MesUnd/Prduc.T/Ven/MinCap/Teo/MinCap/Real/Min% Cump.Desv MinT/Ven/MinCap/Real/MinDesv Min
Enero66.0018,018.0067,500.0062,775.003.4844,75718,018.0062,775.0044,757
febrero66.0018,018.0090,000.0083,700.004.6565,68218,018.0083,700.0065,682
marzo66.0018,018.0086,700.0083,700.004.6565,68218,018.0083,700.0065,682
abril66.0018,018.0085,200.0080,631.004.4862,61318,018.0080,631.0062,613
mayo66.0018,018.0094,800.0083,700.004.6565,68218,018.0083,700.0065,682
junio66.0018,018.0090,000.0088,164.004.8970,14618,018.0088,164.0070,146
Totales396108,108514,200482,670446%374,562
resumen
PREVISION
CAP. REAL
NIVEL EN MINUTOS
Costos
Valor del minuto:$ 67.91
VALORES EN CAPACIDAD MINUTOS$67.9$84.9$135.8$84.9
MEST/normalH-Ex/semH-Ex/domH-Ex/sabTotalMEST/normalH-Ex/semH-Ex/domH-Ex/sabTotal
Enero62,77500062,775Enero$4,263,352$0$0$0$4,263,352
Febrero49,38304,464053,847Febrero$3,353,837$0$606,343$0$3,960,180
Marzo35,99104,46413,39253,847Marzo$2,444,322$0$606,343$1,136,894$4,187,559
Abril35,99104,46413,39253,847Abril$2,444,322$0$606,343$1,136,894$4,187,559
Mayo35,99104,46413,39253,847Mayo$2,444,322$0$606,343$1,136,894$4,187,559
Junio40,17603,06913,39256,637Junio$2,728,545$0$416,861$1,136,894$4,282,300
260,307020,92553,568334,800$17,678,699$0$2,842,235$4,547,575$25,068,509
$25,068,509COSTO TOTAL PLAN MAESTRO
-
Datos
PROMEL LTDA.
Actividad econmica: fabricacin y comercializacin de elementos mdicos hospitalariosDescansosDesayuno0.0
Almuerzo60.0
Horario de trabajo:Algo0.0
De Lunes a ViernesInicio:8:00:00 AMFin:5:00:00 PMHoras total turno L a V9.0h Trabaj.8.0descanso1.0
SbadosInicio:8:00:00 AMFin:2:00:00 PMHoras total turno S6.00h Trabaj.5.5descanso0.5
Tiempos improductivosReprocesosRotacion PersonalAusentismosTotal
1%4%2%7%Salario SMMVL 2014SMMVL 2015PrestacionesSalario+PrestTotal
Capacidad Teorica de la planta100%$ 616,00052%$ 936,320$ 936,320.0
Capacidad Real de la planta Lunes a Sabado100% - 7% =93%
Salario SMMVL 2015SMMVL 2014PrestacionesSalario+PrestTotal
REFMQUINASTotal puestos de trabajoIncremento:4.6%$ 644,33652%$ 979,391$ 979,390.7
R1 CAMILLAS110
1TIEMPO EN MINUTOS (SAM) POR UNIDAD
1REFR1: Camilla
1T/min/Und273.0
1
1
1
1
2
Total10
Dias de trabajo por semana6.00
COSTO DE LA MANO DE OBRA DIRECTA% Eficiencia extras80%
opBasicoSalario total empleadoCosto de la EmpresaCosto DiaCosto HoraCosto Minuto
1$ 644,336.0$ 644,336.0$ 977,973.2$ 32,599.11$ 4,074.888$ 67.91
cap Teorica
CAPACIDAD DE PLANTA TEORICA AL 100% 1ER SEM-2015
Enero100%Febrero100%Marzo100%Abril100%Mayo100%Junio100%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
11110011104,800
2104,8002104,800222104,800
3104,8003104,800333104,800
4104,8003104,80044104,8004104,800
5104,8003104,80055104,8005103,300
6103,3004103,3006104,8006104,800610
777104,8007104,8007
888104,8008103,3008
99104,8009104,8009104,80099104,800
1010104,8009104,80010103,3001010104,800
1111104,8009104,8001111104,80011104,800
1212104,8009104,8001212104,80012103,300
13104,80013103,30013103,30013104,80013104,80013
14104,800141414104,80014104,80014
15104,800151515104,80015103,30015104,800
16104,80016104,80016104,80016104,8001616104,800
17103,30017104,80017104,80017103,3001717104,800
1818104,80018104,80018181018104,800
1919104,80019104,8001919104,80019103,300
20104,80020103,30020103,30020104,80020104,80020
21104,800212121104,80021104,80021
22104,800222222104,80022103,30022104,800
23104,80023104,8002323104,8002323104,800
24103,30024104,80024104,80024103,3002424104,800
2525104,80025104,8002525104,80025104,800
261026104,80026102626104,80026103,300
27104,80027103,30027103,30027104,80027104,80027
28104,800282828104,80028104,80028
29104,800292929104,80029103,30029104,800
30104,8003030104,80030104,8003030104,800
31103,30031314,800313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
67,500.090,000.090,000.086,700.085,200.094,800.0
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero67,500.0022,50022,50022,50067,500
Semestre67,500.0022,50022,50022,500067,500
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero90,000.014,40022,50022,500059,400
Semestre90,000.014,40022,50022,5000059,400
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo90,000.08,10022,5008,1001599,60048,459
Semestre90,000.08,10022,5008,1001599,60048,459
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril86,700.012,90017,700090,0900120,690
Semestre506,000.012,90017,700090,0900120,690
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo85,200.019,20000022,50041,700
Semestre558,750.019,20000022,50041,700
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio94,800.000028,80022,50051,300
Semestre94,800.000028,80022,50051,300
cap Real
CAPACIDAD DE PLANTA TEORICA AL 100% 1ER SEM-2015
Enero93%Febrero93%Marzo93%Abril93%Mayo93%Junio93%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
111110011104,464
22104,4642104,464222104,464
33104,4643104,464333104,464
44104,4644104,46444104,4644104,464
55104,4645104,46455104,4645103,069
66103,0696103,0696104,4646104,4646
7777104,4647104,4647
8888104,4648103,0698
99104,4649104,4649104,46499104,464
1010104,46410104,46410103,0691010104,464
1111104,46411104,4641111104,46411104,464
1212104,46412104,4641212104,46412103,069
13104,46413103,06913103,06913104,46413104,46413
14104,464141414104,46414104,46414
15104,464151515104,46415103,06915104,464
16104,46416104,46416104,46416104,4641616104,464
17103,06917104,46417104,46417103,0691717104,464
1818104,46418104,4641818104,46418104,464
1919104,46419104,4641919104,46419103,069
20104,46420103,06920103,06920104,46420104,46420
21104,46421542121104,46421104,46421
22104,464222222104,46422103,06922104,464
23104,46423104,4642323104,4642323104,464
24103,06924104,46424104,46424103,0692424104,464
2525104,46425104,464251025104,46425104,464
261026104,4642610261026104,46426103,069
27104,46427103,06927103,06927104,46427104,4642710
28104,46428102828104,46428104,4642810
29104,4642910291029104,46429103,06929104,464
30104,4643030104,46430104,4643030104,464
31103,0693131104,464313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
62,775.083,700.083,700.080,631.083,700.088,164.0
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero62,775.0020,92520,92520,92562,775
Semestre62,775.0020,92520,92520,925062,775
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero83,700.013,39220,92520,925055,242
Semestre83,700.013,39220,92520,9250055,242
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo83,700.07,53320,9257,533035,991
Semestre83,700.07,53320,9257,5330035,991
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril80,631.011,99716,4610028,458
Semestre80,631.011,99716,46100028,458
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo83,700.017,85600017,856
Semestre83,700.017,856000017,856
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio88,164.000000
Semestre88,164.0000000
ventas
PREVISION DE VENTAS 1ER SEMESTRE DE 2015
TipoEneroT/undFebreroT/undMarzoT/undAbrilT/undMayoT/undJunioT/und
Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.
R1: Camilla60273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,38060
TOTAL6016,380606027316,380606016,380606016,380606016,380606016,38060
STOCK SOLICITUD VENTAS 1ER SEMESTRE DE 20155%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
STOCK SOLICITUD GERENCIA 1ER SEMESTRE DE 20155%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
PREVISION + STOCK GERENCIA + STOCK VENTAS
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla66273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,01866
6618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,01866
resumen
RESUMEN COMPARATIVO DEL PLAN MAESTROPrev. y Capac. Acumulada
MesUnd/Prduc.T/Ven/MinCap/Teo/MinCap/Real/Min% Cump.Desv MinT/Ven/MinCap/Real/MinDesv Min
Enero66.0018,018.0067,500.0062,775.003.4844,75718,018.0062,775.0044,757
febrero66.0018,018.0090,000.0083,700.004.6565,68218,018.0083,700.0065,682
marzo66.0018,018.0086,700.0083,700.004.6565,68218,018.0083,700.0065,682
abril66.0018,018.0085,200.0080,631.004.4862,61318,018.0080,631.0062,613
mayo66.0018,018.0094,800.0083,700.004.6565,68218,018.0083,700.0065,682
junio66.0018,018.0090,000.0088,164.004.8970,14618,018.0088,164.0070,146
Totales396108,108514,200482,670446%374,562
resumen
PREVISION
CAP. REAL
NIVEL EN MINUTOS
Costos
Valor del minuto:$ 67.91
VALORES EN CAPACIDAD MINUTOS$67.9$84.9$135.8$84.9
MEST/normalH-Ex/semH-Ex/domH-Ex/sabTotalMEST/normalH-Ex/semH-Ex/domH-Ex/sabTotal
Enero62,77500062,775Enero$4,263,352$0$0$0$4,263,352
Febrero49,38304,464053,847Febrero$3,353,837$0$606,343$0$3,960,180
Marzo35,99104,46413,39253,847Marzo$2,444,322$0$606,343$1,136,894$4,187,559
Abril35,99104,46413,39253,847Abril$2,444,322$0$606,343$1,136,894$4,187,559
Mayo35,99104,46413,39253,847Mayo$2,444,322$0$606,343$1,136,894$4,187,559
Junio40,17603,06913,39256,637Junio$2,728,545$0$416,861$1,136,894$4,282,300
260,307020,92553,568334,800$17,678,699$0$2,842,235$4,547,575$25,068,509
$25,068,509COSTO TOTAL PLAN MAESTRO
-
Datos
PROMEL LTDA.
Actividad econmica: fabricacin y comercializacin de elementos mdicos hospitalariosDescansosDesayuno0.0
Almuerzo60.0
Horario de trabajo:Algo0.0
De Lunes a ViernesInicio:8:00:00 AMFin:5:00:00 PMHoras total turno L a V9.0h Trabaj.8.0descanso1.0
SbadosInicio:8:00:00 AMFin:2:00:00 PMHoras total turno S6.00h Trabaj.5.5descanso0.5
Tiempos improductivosReprocesosRotacion PersonalAusentismosTotal
1%4%2%7%Salario SMMVL 2014SMMVL 2015PrestacionesSalario+PrestTotal
Capacidad Teorica de la planta100%$ 616,00052%$ 936,320$ 936,320.0
Capacidad Real de la planta Lunes a Sabado100% - 7% =93%
Salario SMMVL 2015SMMVL 2014PrestacionesSalario+PrestTotal
REFMQUINASTotal puestos de trabajoIncremento:4.6%$ 644,33652%$ 979,391$ 979,390.7
R1 CAMILLAS110
1TIEMPO EN MINUTOS (SAM) POR UNIDAD
1REFR1: Camilla
1T/min/Und273.0
1
1
1
1
2
Total10
Dias de trabajo por semana6.00
COSTO DE LA MANO DE OBRA DIRECTA% Eficiencia extras80%
opBasicoSalario total empleadoCosto de la EmpresaCosto DiaCosto HoraCosto Minuto
1$ 644,336.0$ 644,336.0$ 977,973.2$ 32,599.11$ 4,074.888$ 67.91
cap Teorica
CAPACIDAD DE PLANTA TEORICA AL 100% 1ER SEM-2015
Enero100%Febrero100%Marzo100%Abril100%Mayo100%Junio100%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
11110011104,800
2104,8002104,800222104,800
3104,8003104,800333104,800
4104,8003104,80044104,8004104,800
5104,8003104,80055104,8005103,300
6103,3004103,3006104,8006104,800610
777104,8007104,8007
888104,8008103,3008
99104,8009104,8009104,80099104,800
1010104,8009104,80010103,3001010104,800
1111104,8009104,8001111104,80011104,800
1212104,8009104,8001212104,80012103,300
13104,80013103,30013103,30013104,80013104,80013
14104,800141414104,80014104,80014
15104,800151515104,80015103,30015104,800
16104,80016104,80016104,80016104,8001616104,800
17103,30017104,80017104,80017103,3001717104,800
1818104,80018104,80018181018104,800
1919104,80019104,8001919104,80019103,300
20104,80020103,30020103,30020104,80020104,80020
21104,800212121104,80021104,80021
22104,800222222104,80022103,30022104,800
23104,80023104,8002323104,8002323104,800
24103,30024104,80024104,80024103,3002424104,800
2525104,80025104,8002525104,80025104,800
261026104,80026102626104,80026103,300
27104,80027103,30027103,30027104,80027104,80027
28104,800282828104,80028104,80028
29104,800292929104,80029103,30029104,800
30104,8003030104,80030104,8003030104,800
31103,30031314,800313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
67,500.090,000.090,000.086,700.085,200.094,800.0
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero67,500.0022,50022,50022,50067,500
Semestre67,500.0022,50022,50022,500067,500
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero90,000.014,40022,50022,500059,400
Semestre90,000.014,40022,50022,5000059,400
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo90,000.08,10022,5008,1001599,60048,459
Semestre90,000.08,10022,5008,1001599,60048,459
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril86,700.012,90017,700090,0900120,690
Semestre506,000.012,90017,700090,0900120,690
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo85,200.019,20000022,50041,700
Semestre558,750.019,20000022,50041,700
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio94,800.000028,80022,50051,300
Semestre94,800.000028,80022,50051,300
cap Real
CAPACIDAD DE PLANTA TEORICA AL 100% 1ER SEM-2015
Enero93%Febrero93%Marzo93%Abril93%Mayo93%Junio93%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
111110011104,464
22104,4642104,464222104,464
33104,4643104,464333104,464
44104,4644104,46444104,4644104,464
55104,4645104,46455104,4645103,069
66103,0696103,0696104,4646104,4646
7777104,4647104,4647
8888104,4648103,0698
99104,4649104,4649104,46499104,464
1010104,46410104,46410103,0691010104,464
1111104,46411104,4641111104,46411104,464
1212104,46412104,4641212104,46412103,069
13104,46413103,06913103,06913104,46413104,46413
14104,464141414104,46414104,46414
15104,464151515104,46415103,06915104,464
16104,46416104,46416104,46416104,4641616104,464
17103,06917104,46417104,46417103,0691717104,464
1818104,46418104,4641818104,46418104,464
1919104,46419104,4641919104,46419103,069
20104,46420103,06920103,06920104,46420104,46420
21104,46421542121104,46421104,46421
22104,464222222104,46422103,06922104,464
23104,46423104,4642323104,4642323104,464
24103,06924104,46424104,46424103,0692424104,464
2525104,46425104,464251025104,46425104,464
261026104,4642610261026104,46426103,069
27104,46427103,06927103,06927104,46427104,4642710
28104,46428102828104,46428104,4642810
29104,4642910291029104,46429103,06929104,464
30104,4643030104,46430104,4643030104,464
31103,0693131104,464313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
62,775.083,700.083,700.080,631.083,700.088,164.0
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero62,775.0020,92520,92520,92562,775
Semestre62,775.0020,92520,92520,925062,775
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero83,700.013,39220,92520,925055,242
Semestre83,700.013,39220,92520,9250055,242
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo83,700.07,53320,9257,533035,991
Semestre83,700.07,53320,9257,5330035,991
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril80,631.011,99716,4610028,458
Semestre80,631.011,99716,46100028,458
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo83,700.017,85600017,856
Semestre83,700.017,856000017,856
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio88,164.000000
Semestre88,164.0000000
ventas
PREVISION DE VENTAS 1ER SEMESTRE DE 2015
TipoEneroT/undFebreroT/undMarzoT/undAbrilT/undMayoT/undJunioT/und
Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.Prev.mi/umin/tPrev.
R1: Camilla60273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,38060
TOTAL6016,380606027316,380606016,380606016,380606016,380606016,38060
STOCK SOLICITUD VENTAS 1ER SEMESTRE DE 20155%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
STOCK SOLICITUD GERENCIA 1ER SEMESTRE DE 20155%
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193
381938193819381938193819381938193819381938193
PREVISION + STOCK GERENCIA + STOCK VENTAS
TipoEneroT/undT/MinFebreroT/undT/MinMarzoT/undT/MinAbrilT/undT/MinMayoT/undT/MinJunioT/und
Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.Prev.Prev.mi/umin/tPrev.
R1: Camilla66273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,0186618,01866273.018,01866
6618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,0186618,01866
resumen
RESUMEN COMPARATIVO DEL PLAN MAESTROPrev. y Capac. Acumulada
MesUnd/Prduc.T/Ven/MinCap/Teo/MinCap/Real/Min% Cump.Desv MinT/Ven/MinCap/Real/MinDesv Min
Enero66.0018,018.0067,500.0062,775.003.4844,75718,018.0062,775.0044,757
febrero66.0018,018.0090,000.0083,700.004.6565,68218,018.0083,700.0065,682
marzo66.0018,018.0086,700.0083,700.004.6565,68218,018.0083,700.0065,682
abril66.0018,018.0085,200.0080,631.004.4862,61318,018.0080,631.0062,613
mayo66.0018,018.0094,800.0083,700.004.6565,68218,018.0083,700.0065,682
junio66.0018,018.0090,000.0088,164.004.8970,14618,018.0088,164.0070,146
Totales396108,108514,200482,670446%374,562
resumen
PREVISION
CAP. REAL
NIVEL EN MINUTOS
Costos
Valor del minuto:$ 67.91
VALORES EN CAPACIDAD MINUTOS$67.9$84.9$135.8$84.9
MEST/normalH-Ex/semH-Ex/domH-Ex/sabTotalMEST/normalH-Ex/semH-Ex/domH-Ex/sabTotal
Enero62,77500062,775Enero$4,263,352$0$0$0$4,263,352
Febrero49,38304,464053,847Febrero$3,353,837$0$606,343$0$3,960,180
Marzo35,99104,46413,39253,847Marzo$2,444,322$0$606,343$1,136,894$4,187,559
Abril35,99104,46413,39253,847Abril$2,444,322$0$606,343$1,136,894$4,187,559
Mayo35,99104,46413,39253,847Mayo$2,444,322$0$606,343$1,136,894$4,187,559
Junio40,17603,06913,39256,637Junio$2,728,545$0$416,861$1,136,894$4,282,300
260,307020,92553,568334,800$17,678,699$0$2,842,235$4,547,575$25,068,509
$25,068,509COSTO TOTAL PLAN MAESTRO
-
Datos
PROMEL LTDA.
Actividad econmica: fabricacin y comercializacin de elementos mdicos hospitalariosDescansosDesayuno0.0
Almuerzo60.0
Horario de trabajo:Algo0.0
De Lunes a ViernesInicio:8:00:00 AMFin:5:00:00 PMHoras total turno L a V9.0h Trabaj.8.0descanso1.0
SbadosInicio:8:00:00 AMFin:2:00:00 PMHoras total turno S6.00h Trabaj.5.5descanso0.5
Tiempos improductivosReprocesosRotacion PersonalAusentismosTotal
1%4%2%7%Salario SMMVL 2014SMMVL 2015PrestacionesSalario+PrestTotal
Capacidad Teorica de la planta100%$ 616,00052%$ 936,320$ 936,320.0
Capacidad Real de la planta Lunes a Sabado100% - 7% =93%
Salario SMMVL 2015SMMVL 2014PrestacionesSalario+PrestTotal
REFMQUINASTotal puestos de trabajoIncremento:4.6%$ 644,33652%$ 979,391$ 979,390.7
R1 CAMILLAS110
1TIEMPO EN MINUTOS (SAM) POR UNIDAD
1REFR1: Camilla
1T/min/Und273.0
1
1
1
1
2
Total10
Dias de trabajo por semana6.00
COSTO DE LA MANO DE OBRA DIRECTA% Eficiencia extras80%
opBasicoSalario total empleadoCosto de la EmpresaCosto DiaCosto HoraCosto Minuto
1$ 644,336.0$ 644,336.0$ 977,973.2$ 32,599.11$ 4,074.888$ 67.91
cap Teorica
CAPACIDAD DE PLANTA TEORICA AL 100% 1ER SEM-2015
Enero100%Febrero100%Marzo100%Abril100%Mayo100%Junio100%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
11110011104,800
2104,8002104,800222104,800
3104,8003104,800333104,800
4104,8003104,80044104,8004104,800
5104,8003104,80055104,8005103,300
6103,3004103,3006104,8006104,800610
777104,8007104,8007
888104,8008103,3008
99104,8009104,8009104,80099104,800
1010104,8009104,80010103,3001010104,800
1111104,8009104,8001111104,80011104,800
1212104,8009104,8001212104,80012103,300
13104,80013103,30013103,30013104,80013104,80013
14104,800141414104,80014104,80014
15104,800151515104,80015103,30015104,800
16104,80016104,80016104,80016104,8001616104,800
17103,30017104,80017104,80017103,3001717104,800
1818104,80018104,80018181018104,800
1919104,80019104,8001919104,80019103,300
20104,80020103,30020103,30020104,80020104,80020
21104,800212121104,80021104,80021
22104,800222222104,80022103,30022104,800
23104,80023104,8002323104,8002323104,800
24103,30024104,80024104,80024103,3002424104,800
2525104,80025104,8002525104,80025104,800
261026104,80026102626104,80026103,300
27104,80027103,30027103,30027104,80027104,80027
28104,800282828104,80028104,80028
29104,800292929104,80029103,30029104,800
30104,8003030104,80030104,8003030104,800
31103,30031314,800313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
67,500.090,000.090,000.086,700.085,200.094,800.0
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero67,500.0022,50022,50022,50067,500
Semestre67,500.0022,50022,50022,500067,500
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero90,000.014,40022,50022,500059,400
Semestre90,000.014,40022,50022,5000059,400
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo90,000.08,10022,5008,1001599,60048,459
Semestre90,000.08,10022,5008,1001599,60048,459
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Abril86,700.012,90017,700090,0900120,690
Semestre506,000.012,90017,700090,0900120,690
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Mayo85,200.019,20000022,50041,700
Semestre558,750.019,20000022,50041,700
RESUMEN CAPACIDAD TEORICA
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Junio94,800.000028,80022,50051,300
Semestre94,800.000028,80022,50051,300
cap Real
CAPACIDAD DE PLANTA TEORICA AL 100% 1ER SEM-2015
Enero93%Febrero93%Marzo93%Abril93%Mayo93%Junio93%
DiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/diaDiaOpmin/dia
111110011104,464
22104,4642104,464222104,464
33104,4643104,464333104,464
44104,4644104,46444104,4644104,464
55104,4645104,46455104,4645103,069
66103,0696103,0696104,4646104,4646
7777104,4647104,4647
8888104,4648103,0698
99104,4649104,4649104,46499104,464
1010104,46410104,46410103,0691010104,464
1111104,46411104,4641111104,46411104,464
1212104,46412104,4641212104,46412103,069
13104,46413103,06913103,06913104,46413104,46413
14104,464141414104,46414104,46414
15104,464151515104,46415103,06915104,464
16104,46416104,46416104,46416104,4641616104,464
17103,06917104,46417104,46417103,0691717104,464
1818104,46418104,4641818104,46418104,464
1919104,46419104,4641919104,46419103,069
20104,46420103,06920103,06920104,46420104,46420
21104,46421542121104,46421104,46421
22104,464222222104,46422103,06922104,464
23104,46423104,4642323104,4642323104,464
24103,06924104,46424104,46424103,0692424104,464
2525104,46425104,464251025104,46425104,464
261026104,4642610261026104,46426103,069
27104,46427103,06927103,06927104,46427104,4642710
28104,46428102828104,46428104,4642810
29104,4642910291029104,46429103,06929104,464
30104,4643030104,46430104,4643030104,464
31103,0693131104,464313131
Total del MesTotal del MesTotal del MesTotal del MesTotal del MesTotal del Mes
62,775.083,700.083,700.080,631.083,700.088,164.0
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Enero62,775.0020,92520,92520,92562,775
Semestre62,775.0020,92520,92520,925062,775
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Febrero83,700.013,39220,92520,925055,242
Semestre83,700.013,39220,92520,9250055,242
RESUMEN CAPACIDAD REAL
ConceptoMinutosSEM-1SEM-2SEM-3SEM-4SEM-5TOTAL
Marzo83,700.07,53320,9257,533035,991