Proyecto de Aula Gestión de La Producción I

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



Febrero90,000.014,40022,50022,500059,400

Semestre90,000.014,40022,50022,5000059,400



Marzo90,000.08,10022,5008,1001599,60048,459

Semestre90,000.08,10022,5008,1001599,60048,459



Abril86,700.012,90017,700090,0900120,690

Semestre506,000.012,90017,700090,0900120,690



Mayo85,200.019,20000022,50041,700

Semestre558,750.019,20000022,50041,700



Junio94,800.000028,80022,50051,300

Semestre94,800.000028,80022,50051,300

cap Real

CAPACIDAD DE PLANTA TEORICA AL 100% 2DO SEM-2014



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


62,775.083,700.083,700.080,631.083,700.088,164.0



Enero62,775.0020,92520,92520,92562,775

Semestre62,775.0020,92520,92520,925062,775



Febrero83,700.013,39220,92520,925055,242

Semestre83,700.013,39220,92520,9250055,242



Marzo83,700.07,53320,9257,533035,991

Semestre83,700.07,53320,9257,5330035,991



Abril80,631.011,99716,4610028,458

Semestre80,631.011,99716,46100028,458



Mayo83,700.017,85600017,856

Semestre83,700.017,856000017,856



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%



R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193

381938193819381938193819381938193819381938193

PREVISION + STOCK GERENCIA + STOCK VENTAS



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.


Almuerzo60.0










R1 CAMILLAS110


1REFR1: Camilla

1T/min/Und273.0

1

1

1

1

2

Total10




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



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


67,500.090,000.090,000.086,700.085,200.094,800.0



Enero67,500.0022,50022,50022,50067,500

Semestre67,500.0022,50022,50022,500067,500



Febrero90,000.014,40022,50022,500059,400

Semestre90,000.014,40022,50022,5000059,400



Marzo90,000.08,10022,5008,1001599,60048,459

Semestre90,000.08,10022,5008,1001599,60048,459



Abril86,700.012,90017,700090,0900120,690

Semestre506,000.012,90017,700090,0900120,690



Mayo85,200.019,20000022,50041,700

Semestre558,750.019,20000022,50041,700



Junio94,800.000028,80022,50051,300

Semestre94,800.000028,80022,50051,300

cap Real




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


62,775.083,700.083,700.080,631.083,700.088,164.0

RESUMEN CAPACIDAD REAL


Enero62,775.0020,92520,92520,92562,775

Semestre62,775.0020,92520,92520,925062,775



Febrero83,700.013,39220,92520,925055,242

Semestre83,700.013,39220,92520,9250055,242



Marzo83,700.07,53320,9257,533035,991

Semestre83,700.07,53320,9257,5330035,991



Abril80,631.011,99716,4610028,458

Semestre80,631.011,99716,46100028,458



Mayo83,700.017,85600017,856

Semestre83,700.017,856000017,856



Junio88,164.000000

Semestre88,164.0000000

ventas




R1: Camilla60273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,38060

TOTAL6016,380606027316,380606016,380606016,380606016,380606016,38060




R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193

381938193819381938193819381938193819381938193




R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193

381938193819381938193819381938193819381938193




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



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




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


Datos

PROMEL LTDA.


Almuerzo60.0










R1 CAMILLAS110


1REFR1: Camilla

1T/min/Und273.0

1

1

1

1

2

Total10




1$ 644,336.0$ 644,336.0$ 977,973.2$ 32,599.11$ 4,074.888$ 67.91

cap Teorica




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


67,500.090,000.090,000.086,700.085,200.094,800.0



Enero67,500.0022,50022,50022,50067,500

Semestre67,500.0022,50022,50022,500067,500



Febrero90,000.014,40022,50022,500059,400

Semestre90,000.014,40022,50022,5000059,400



Marzo90,000.08,10022,5008,1001599,60048,459

Semestre90,000.08,10022,5008,1001599,60048,459



Abril86,700.012,90017,700090,0900120,690

Semestre506,000.012,90017,700090,0900120,690



Mayo85,200.019,20000022,50041,700

Semestre558,750.019,20000022,50041,700



Junio94,800.000028,80022,50051,300

Semestre94,800.000028,80022,50051,300

cap Real




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


62,775.083,700.083,700.080,631.083,700.088,164.0



Enero62,775.0020,92520,92520,92562,775

Semestre62,775.0020,92520,92520,925062,775



Febrero83,700.013,39220,92520,925055,242

Semestre83,700.013,39220,92520,9250055,242



Marzo83,700.07,53320,9257,533035,991

Semestre83,700.07,53320,9257,5330035,991



Abril80,631.011,99716,4610028,458

Semestre80,631.011,99716,46100028,458



Mayo83,700.017,85600017,856

Semestre83,700.017,856000017,856



Junio88,164.000000

Semestre88,164.0000000

ventas




R1: Camilla60273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,38060

TOTAL6016,380606027316,380606016,380606016,380606016,380606016,38060




R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193

381938193819381938193819381938193819381938193




R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193

381938193819381938193819381938193819381938193




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



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




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


Datos

PROMEL LTDA.


Almuerzo60.0










R1 CAMILLAS110


1REFR1: Camilla

1T/min/Und273.0

1

1

1

1

2

Total10




1$ 644,336.0$ 644,336.0$ 977,973.2$ 32,599.11$ 4,074.888$ 67.91

cap Teorica




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


67,500.090,000.090,000.086,700.085,200.094,800.0



Enero67,500.0022,50022,50022,50067,500

Semestre67,500.0022,50022,50022,500067,500



Febrero90,000.014,40022,50022,500059,400

Semestre90,000.014,40022,50022,5000059,400



Marzo90,000.08,10022,5008,1001599,60048,459

Semestre90,000.08,10022,5008,1001599,60048,459



Abril86,700.012,90017,700090,0900120,690

Semestre506,000.012,90017,700090,0900120,690



Mayo85,200.019,20000022,50041,700

Semestre558,750.019,20000022,50041,700



Junio94,800.000028,80022,50051,300

Semestre94,800.000028,80022,50051,300

cap Real

CAPACIDAD DE PLANTA REAL AL 93% 1ER SEM-2015



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


62,775.083,700.083,700.080,631.083,700.088,164.0



Enero62,775.0020,92520,92520,92562,775

Semestre62,775.0020,92520,92520,925062,775



Febrero83,700.013,39220,92520,925055,242

Semestre83,700.013,39220,92520,9250055,242



Marzo83,700.07,53320,9257,533035,991

Semestre83,700.07,53320,9257,5330035,991



Abril80,631.011,99716,4610028,458

Semestre80,631.011,99716,46100028,458



Mayo83,700.017,85600017,856

Semestre83,700.017,856000017,856



Junio88,164.000000

Semestre88,164.0000000

ventas




R1: Camilla60273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,38060

TOTAL6016,380606027316,380606016,380606016,380606016,380606016,38060




R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193

381938193819381938193819381938193819381938193




R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193

381938193819381938193819381938193819381938193




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



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




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


Datos

PROMEL LTDA.


Almuerzo60.0










R1 CAMILLAS110


1REFR1: Camilla

1T/min/Und273.0

1

1

1

1

2

Total10




1$ 644,336.0$ 644,336.0$ 977,973.2$ 32,599.11$ 4,074.888$ 67.91

cap Teorica




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


67,500.090,000.090,000.086,700.085,200.094,800.0



Enero67,500.0022,50022,50022,50067,500

Semestre67,500.0022,50022,50022,500067,500



Febrero90,000.014,40022,50022,500059,400

Semestre90,000.014,40022,50022,5000059,400



Marzo90,000.08,10022,5008,1001599,60048,459

Semestre90,000.08,10022,5008,1001599,60048,459



Abril86,700.012,90017,700090,0900120,690

Semestre506,000.012,90017,700090,0900120,690



Mayo85,200.019,20000022,50041,700

Semestre558,750.019,20000022,50041,700



Junio94,800.000028,80022,50051,300

Semestre94,800.000028,80022,50051,300

cap Real




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


62,775.083,700.083,700.080,631.083,700.088,164.0



Enero62,775.0020,92520,92520,92562,775

Semestre62,775.0020,92520,92520,925062,775



Febrero83,700.013,39220,92520,925055,242

Semestre83,700.013,39220,92520,9250055,242



Marzo83,700.07,53320,9257,533035,991

Semestre83,700.07,53320,9257,5330035,991



Abril80,631.011,99716,4610028,458

Semestre80,631.011,99716,46100028,458



Mayo83,700.017,85600017,856

Semestre83,700.017,856000017,856



Junio88,164.000000

Semestre88,164.0000000

ventas




R1: Camilla60273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,3806060273.016,38060

TOTAL6016,380606027316,380606016,380606016,380606016,380606016,38060




R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193

381938193819381938193819381938193819381938193




R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193

381938193819381938193819381938193819381938193




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



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




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


Datos

PROMEL LTDA.


Almuerzo60.0










R1 CAMILLAS110


1REFR1: Camilla

1T/min/Und273.0

1

1

1

1

2

Total10




1$ 644,336.0$ 644,336.0$ 977,973.2$ 32,599.11$ 4,074.888$ 67.91

cap Teorica




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


67,500.090,000.090,000.086,700.085,200.094,800.0



Enero67,500.0022,50022,50022,50067,500

Semestre67,500.0022,50022,50022,500067,500



Febrero90,000.014,40022,50022,500059,400

Semestre90,000.014,40022,50022,5000059,400



Marzo90,000.08,10022,5008,1001599,60048,459

Semestre90,000.08,10022,5008,1001599,60048,459



Abril86,700.012,90017,700090,0900120,690

Semestre506,000.012,90017,700090,0900120,690



Mayo85,200.019,20000022,50041,700

Semestre558,750.019,20000022,50041,700



Junio94,800.000028,80022,50051,300

Semestre94,800.000028,80022,50051,300

cap Real




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


62,775.083,700.083,700.080,631.083,700.088,164.0



Enero62,775.0020,92520,92520,92562,775

Semestre62,775.0020,92520,92520,925062,775



Febrero83,700.013,39220,92520,925055,242

Semestre83,700.013,39220,92520,9250055,242



Marzo83,700.07,53320,9257,533035,991

Semestre83,700.07,53320,9257,5330035,991



Abril80,631.011,99716,4610028,458

Semestre80,631.011,99716,46100028,458



Mayo83,700.017,85600017,856

Semestre83,700.017,856000017,856



Junio88,164.000000

Semestre88,164.0000000

ventas

PREVISION DE VENTAS 1ER SEMESTRE DE 2015



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%



R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193

381938193819381938193819381938193819381938193

STOCK SOLICITUD GERENCIA 1ER SEMESTRE DE 20155%



R1: Camilla3273.081938193273.081938193273.081938193273.081938193273.081938193273.08193

381938193819381938193819381938193819381938193




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



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




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


Datos

PROMEL LTDA.


Almuerzo60.0










R1 CAMILLAS110


1REFR1: Camilla

1T/min/Und273.0

1

1

1

1

2

Total10




1$ 644,336.0$ 644,336.0$ 977,973.2$ 32,599.11$ 4,074.888$ 67.91

cap Teorica




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


67,500.090,000.090,000.086,700.085,200.094,800.0



Enero67,500.0022,50022,50022,50067,500

Semestre67,500.0022,50022,50022,500067,500



Febrero90,000.014,40022,50022,500059,400

Semestre90,000.014,40022,50022,5000059,400



Marzo90,000.08,10022,5008,1001599,60048,459

Semestre90,000.08,10022,5008,1001599,60048,459



Abril86,700.012,90017,700090,0900120,690

Semestre506,000.012,90017,700090,0900120,690



Mayo85,200.019,20000022,50041,700

Semestre558,750.019,20000022,50041,700



Junio94,800.000028,80022,50051,300

Semestre94,800.000028,80022,50051,300

cap Real




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


62,775.083,700.083,700.080,631.083,700.088,164.0



Enero62,775.0020,92520,92520,92562,775

Semestre62,775.0020,92520,92520,925062,775



Febrero83,700.013,39220,92520,925055,242

Semestre83,700.013,39220,92520,9250055,242



Marzo83,700.07,53320,9257,533035,991

Proyecto de Aula Gestión de La Producción I

Documents

Transcript of Proyecto de Aula Gestión de La Producción I