Download - Caso Plasticos Del Hogar s (1)
CASO PLASTICOS DEL HOGAR S.A.PLANEACION DE REQUERIMIENTO DE MATERIALESLa empresa Plstico del Hogar S.A. se dedica a la produccin de artculos de uso domstico y adems tiene mltiples lneas de produccin dentro de las que destaca la lnea de contenedores de alimentos con tres productos importantes: lonchera escolares, canasta especial y termo de oficina, para los que estn planeando su produccin.La demanda de los tres productos se ha comportado en los cuatro ltimos aos de la manera que muestra los cuadros siguientes: LONCHERA ESCOLAR:
CANASTA ESPECIAL:
TERMO DE OFICINA:
En el cuadro se muestran el estado actual de los almacenes, as como las condiciones comerciales y polticas de adquisiciones que regulan el abastecimiento de los materiales.La empresa mantiene un intervalo de 1500000 soles y atiende un promedio de 1875 rdenes de compra al ao, el ao anterior ha tenido los siguientes gastos para el abastecimiento:
ESTRUCTURA DE LA LONCHERA ESCOLAR
ESTRUCTURA DE LA CANSATA ESPECIAL
ESTRUCTURA DEL TERMO DE OFICINA
Elaborar un plan de abastecimiento para el prximo trimestre
PLAN DE MATERIALESDiciembreEneroFebreroMarzo
Articulo12345678910111213141516
LoncheraEscolarReq.Bruto2857285728572857292429242924292431553155315531553310331033103310
Inv.0000000000000000
Req.Neto2857285728572857292429242924292431553155315531553310331033103310
Pedido292429242924292431553155315531553310331033103310
CanastaEspecialReq.Bruto641641641641689689689689668668668668614614614614
Inv.0000000000000000
Req.Neto641641641641689689689689668668668668614614614614
Pedido689689689689668668668668614614614614
Termo deOficinaReq.Bruto1798179817981798203320332033203319831983198319831914191419141914
Inv.0000000000000000
Req.Neto1798179817981798203320332033203319831983198319831914191419141914
Pedido203320332033203319831983198319831914191419141914
DiciembreEneroFebreroMarzo
Articulo12345678910111213141516
BaseLoncheraReq.Bruto292429242924292431553155315531553310331033103310
Inv.000000000000
Req.Neto292429242924292431553155315531553310331033103310
Pedido292429242924292431553155315531553310331033103310
TapaLoncheraReq.Bruto292429242924292431553155315531553310331033103310
Inv.000000000000
Req.Neto292429242924292431553155315531553310331033103310
Pedido292429242924292431553155315531553310331033103310
BrocheLoncheraReq.Bruto292429242924292431553155315531553310331033103310
Inv.000000000000
Req.Neto292429242924292431553155315531553310331033103310
Pedido292429242924292431553155315531553310331033103310
AsaLoncheraReq.Bruto292429242924292431553155315531553310331033103310
Inv.000000000000
Req.Neto292429242924292431553155315531553310331033103310
Pedido292429242924292431553155315531553310331033103310
BaseCanasta
Req.Bruto292429242924292431553155315531553310331033103310
Inv.000000000000
Req.Neto292429242924292431553155315531553310331033103310
Pedido292429242924292431553155315531553310331033103310
Tapa de CanastaReq.Bruto689689689689668668668668614614614614
Inv.000000000000
Req.Neto689689689689668668668668614614614614
Pedido689689689689668668668668614614614614
BrocheCanastaReq.Bruto689689689689668668668668614614614614
Inv.000000000000
Req.Neto689689689689668668668668614614614614
Pedido689689689689668668668668614614614614
AsaCanastaReq.Bruto689689689689668668668668614614614614
Inv.000000000000
Req.Neto689689689689668668668668614614614614
Pedido689689689689668668668668614614614614
CuerpoTermoReq.Bruto203320332033203319831983198319831914191419141914
Inv.000000000000
Req.Neto203320332033203319831983198319831914191419141914
Pedido203320332033203319831983198319831914191419141914
InteriorTermoReq.Bruto203320332033203319831983198319831914191419141914
Inv.000000000000
Req.Neto203320332033203319831983198319831914191419141914
Pedido203320332033203319831983198319831914191419141914
TapaInteriorTermoReq.Bruto203320332033203319831983198319831914191419141914
Inv.000000000000
Req.Neto203320332033203319831983198319831914191419141914
Pedido203320332033203319831983198319831914191419141914
TapaExteriorTermoReq.Bruto203320332033203319831983198319831914191419141914
Inv.000000000000
Req.Neto203320332033203319831983198319831914191419141914
Pedido203320332033203319831983198319831914191419141914
DiciembreEnero
Articulo12345678
PPNReq.Bruto788278827882788282938293
Inv.003500000349211834842363475943
Req.Neto788278820000
Pedido78827882000000
PEsReq.Bruto180661806618066180661911419114
Inv.001650000163193416138691594754
Req.Neto18066180660000
Pedido1806618066000000
PEADIReq.Bruto59404.329859404.329859404.329859404.329860327.747160327.7471
Inv.0031500003090595.673031191.342970863.59
Req.Neto59404.329859404.32980000
Pedido59404.329859404.3298000000
PEBDI BASEReq.Bruto65432.740665432.740665432.740665432.740663436.316563436.3165
Inv.001340178.571274745.831209313.091145876.77
Req.Neto65432.740665432.74060000
Pedido65432.740665432.740600000
FebreroMarzo
Articulo910111213141516
PPNReq.Bruto829382938533853385338533
Inv.346765034593563451063344253034339963425463
Req.Neto000000
Pedido0000
PEsReq.Bruto191141911419615196151961519615
Inv.157564015565261537411151779614981811478565
Req.Neto000000
Pedido0000
PEADIReq.Bruto60327.747160327.747160101.434760101.434760101.434760101.4347
Inv.2910535.852850208.12789880.352729778.922669677.482609576.05
Req.Neto000000
Pedido0000
PEBDI BASEReq.Bruto63436.316563436.316558288.503458288.503458288.503458288.5034
Inv.1082440.461019004.14955567.824897279.321838990.817780702.314
Req.Neto000000
Pedido00000
DiciembreEnero
Articulo12345678
PEBDI TAPAReq.Bruto30994.456130994.456130994.456130994.456130048.781530048.7815
Inv.00634821.429634821.429634821.429634821.429
Req.Neto30994.456130994.45610000
Pedido30994.456130994.4561000000
PEADSReq.Bruto50831.952250831.952250831.952250831.952249574.877149574.8771
Inv.0010750001024168.05973336.096923761.218
Req.Neto50831.952250831.95220000
Pedido50831.952250831.9522000000
PPSReq.Bruto36599.005636599.005636599.005636599.005635693.911535693.9115
Inv.0019250001888400.991851801.991816108.08
Req.Neto36599.005636599.00560000
Pedido36599.005636599.0056000000
PUReq.Bruto20332.780920332.780920332.780920332.780919829.9509
Inv.0375000354667.219334334.438314001.657
Req.Neto20332.78090000
Pedido20332.780900000
FebreroMarzo
Articulo910111213141516
PPNReq.Bruto30048.781530048.781527610.343727610.343727610.343727610.3437
Inv.634821.429634821.429634821.429634821.429634821.429634821.429
Req.Neto000000
Pedido0000
PEsReq.Bruto49574.877149574.877147861.391547861.391547861.391547861.3915
Inv.874186.341824611.464775036.587727175.196679313.804631452.413
Req.Neto000000
Pedido0000
PEADIReq.Bruto35693.911535693.911534460.201934460.201934460.201934460.2019
Inv.1780414.171744720.251709026.341674566.141640105.941605645.74
Req.Neto000000
Pedido0000
PEBDI BASEReq.Bruto19829.950919829.950919829.950919144.556619144.556619144.556619144.5566
Inv.294171.707274341.756254511.805234681.854215537.297196392.741177248.184
Req.Neto0000000
Pedido000000