Planilha de MRP

7/23/2019 Planilha de MRP

1/16

Exerccio_Lapiseira

MRP - PLANEJAMENTO DAS NECESSIDADES D

MANA 26 27 28 29 30 31 32 33 34

DIDO CLIENTE

L! " 1 ES!#$%E" 0 $!& " 1

ITEM Lapiseira

'ana 26 27 28 29 30 31 32 33 34essi(a(e )r*+a 0 0 0 0 0 0 0 0 0 1

,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 0 0 0 0 1

ao (e #r(ens 0 0 0 0 0 0 0 0 10000

L! " 1 ES!#$%E" 0 $!& " 1

ITEM Tubo Interno'ana 26 27 28 29 30 31 32 33 34

essi(a(e )r*+a 0 0 0 0 0 0 0 0 10000,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 0 0 0 10000

ao (e #r(ens 0 0 0 0 0 0 0 10000 0

L! " 3 ES!#$%E" 0 $!& " 1

ITEM Tampa Borra!a'ana 26 27 28 29 30 31 32 33 34

essi(a(e )r*+a 0 0 0 0 0 0 0 0 10000

,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 0 0 0 10000

ao (e #r(ens 0 0 0 0 0 10000 0 0 0

L! " 3 ES!#$%E" 0 $!& " 1

ITEM Ponteira'ana 26 27 28 29 30 31 32 33 34

essi(a(e )r*+a 0 0 0 0 0 0 0 0 10000

,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 0 0 0 10000

ao (e #r(ens 0 0 0 0 0 10000 0 0 0

L! " 3 ES!#$%E" 0 $!& " 1

ITEM Presi"!a'ana 26 27 28 29 30 31 32 33 34

essi(a(e )r*+a 0 0 0 0 0 0 0 0 10000

,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 0 0 0 10000

ao (e #r(ens 0 0 0 0 0 10000 0 0 0


2/16

Exerccio_Lapiseira

ITEM Corpo E#terno'ana 26 27 28 29 30 31 32 33 34

essi(a(e )r*+a 0 0 0 0 0 0 0 0 10000

,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 0 0 0 10000

ao (e #r(ens 0 0 0 0 0 10000 0 0 0

$!& " %sa

L! " 3 ES!#$%E" 0 $!& " 4 %sa

ITEM PP'ana 26 27 28 29 30 31 32 33 34

essi(a(e )r*+a 0 0 0 0 0 90000 0 0 0

,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 90000 0 0 0

ao (e #r(ens 0 0 90000 0 0 0 0 0 0

L! " 3 ES!#$%E" 0 $!& " 2

ITEM Corante A$u"'ana 26 27 28 29 30 31 32 33 34

essi(a(e )r*+a 0 0 0 0 0 20000 0 0 0

,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 20000 0 0 0

ao (e #r(ens 0 0 20000 0 0 0 0 0 0

L! " 1 ES!#$%E" 0 $!& " 1ITEM Borra!a

'ana 26 27 28 29 30 31 32 33 34

essi(a(e )r*+a 0 0 0 0 0 0 0 10000 0

,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 0 0 10000 0

ao (e #r(ens 0 0 0 0 0 0 10000 0 0

L! " 2 ES!#$%E" 0 $!& " 1

ITEM Tubo Transparente'ana 26 27 28 29 30 31 32 33 34

essi(a(e )r*+a 0 0 0 0 0 0 0 10000 0

,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 0 0 10000 0

ao (e #r(ens 0 0 0 0 0 10000 0 0 0

L! " 3 ES!#$%E" 0 $!& " 1

ITEM Bu!a

'ana 26 27 28 29 30 31 32 33 34essi(a(e )r*+a 0 0 0 0 0 0 0 10000 0

&i . 0 0 0 0 0 0 0 0 0


3/16

Exerccio_Lapiseira

ao (e #r(ens 0 0 0 0 10000 0 0 0 0

L! " 2 ES!#$%E" 0 $!& " 1

ITEM Corpo Interno'ana 26 27 28 29 30 31 32 33 34

essi(a(e )r*+a 0 0 0 0 0 0 0 10000 0

,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 0 0 10000 0

ao (e #r(ens 0 0 0 0 0 10000 0 0 0

L! " 3 ES!#$%E" 0 $!& " 1

ITEM Mo"a'ana 26 27 28 29 30 31 32 33 34

essi(a(e )r*+a 0 0 0 0 0 0 0 10000 0

,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 0 0 10000 0ao (e #r(ens 0 0 0 0 10000 0 0 0 0

L! " 3 ES!#$%E" 0 $!& " 3

ITEM %arra'ana 26 27 28 29 30 31 32 33 34

essi(a(e )r*+a 0 0 0 0 0 0 0 30000 0

,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 0 0 30000 0

ao (e #r(ens 0 0 0 0 30000 0 0 0 0

L! " 2 ES!#$%E" 0 $!& " 3

ITEM %ra&ite'ana 26 27 28 29 30 31 32 33 34

essi(a(e )r*+a 0 0 0 0 0 0 0 30000 0

,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 0 0 30000 0

ao (e #r(ens 0 0 0 0 0 30000 0 0 0

L! " 2 ES!#$%E" 0 $!& " 1

ITEM 'io Borra!a (mm'ana 26 27 28 29 30 31 32 33 34

essi(a(e )r*+a 0 0 0 0 0 0 10000 0 0

,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 0 10000 0 0

ao (e #r(ens 0 0 0 0 10000 0 0 0 0

L! " 3 ES!#$%E" 0 $!& " 4ITEM PE

'ana 26 27 28 29 30 31 32 33 34


4/16

Exerccio_Lapiseira

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 40000 0 0 0

ao (e #r(ens 0 0 40000 0 0 0 0 0 0

PLANO DE COMPRAS)PROD*+,O

MANA 26 27 28 29 30 31 32 33 34iseira 0 0 0 0 0 0 0 0 10000 o Interno 0 0 0 0 0 0 0 10000 0

mpa Borra!a 0 0 0 0 0 10000 0 0 0 nteira 0 0 0 0 0 10000 0 0 0 si"!a 0 0 0 0 0 10000 0 0 0 po E#terno 0 0 0 0 0 10000 0 0 0

0 0 .0000 0 0 0 0 0 0 ante A$u" 0 0 /0000 0 0 0 0 0 0 ra!a 0 0 0 0 0 0 10000 0 0

o Transparente 0 0 0 0 0 10000 0 0 0 !a 0 0 0 0 10000 0 0 0 0 po Interno 0 0 0 0 0 10000 0 0 0 a 0 0 0 0 10000 0 0 0 0 ra 0 0 0 0 0000 0 0 0 0 &ite 0 0 0 0 0 0000 0 0 0 Borra!a (mm 0 0 0 0 10000 0 0 0 0 0 0 0000 0 0 0 0 0 0

Lapiseira

TampaBorracha

Ponteira PresilhaCorpoExterno

PPCoranteAzul

TIn

Borracha1cm

FioBorracha8mm

TuboTransparen

te

PE

BuchaCIn


5/16

Exerccio_Lapiseira

Pro(*+o Lea( +i'e ,*an+i(a(e *ni(5 M

seira 1 1 p

o n+erno 1 1 p

pa )orraca 3 1 p

+eira 3 1 p

si.a 3 1 p

po Ex+erno 2 1 p

aca 1 1 po +ransp5 2 1 p

a 3 1 p

po n+erno 2 1 p

a 3 1 p

ra 3 3 p

i+e 2 3 p

3 9 gr gr no orpo Ex+erno e 4 gr no

3 4 gr

)orraca 2 1 c'

an+e 3 2 gr


6/16

Exerccio_Lapiseira

TERIAIS

36 37 38 39 40

36 37 38 39 400 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

31 32 33 34 3

0 0 0 0 00 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

31 32 33 34 3

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

31 32 33 34 3

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

31 32 33 34 3

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0


7/16

Exerccio_Lapiseira

31 32 33 34 3

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

po Ex+erno

rpo n+erno

31 32 33 34 3

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

31 32 33 34 3

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

31 32 33 34 3

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

31 32 33 34 3

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

31 32 33 34 30 0 0 0 0

0 0 0 0 0


8/16

Exerccio_Lapiseira

0 0 0 0 0

31 32 33 34 3

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

31 32 33 34 3

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 00 0 0 0 0

31 32 33 34 3

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

31 32 33 34 3

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

31 32 33 34 3

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

31 32 33 34 3


9/16

Exerccio_Lapiseira

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

31 32 33 34 30 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 0

0 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 00 0 0 0 0

Mola Garra Grate


10/16

Exerccio_Lapiseira

no


11/16

Exerccio_2

Pgina 11

MRP - PLANEJAMENTO DAS NECESSIDADES DE

MANA 38 39 40 41 42 43 44 4 46 47

LEN!E 600

L! " 1 ES!#$%E" 0 $!& " 1

ITEM A

ana 38 39 40 41 42 43 44 4 46 47essi(a(e )r*+a 0 0 0 0 0 0 0 0 600

,*e &ispon-e. 0 0 0 0 0 0 0 0 0

ei'en+o Pre-is+os 0 0 0 0 0 0 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 0 0 0 600

ao (e #r(ens 0 0 0 0 0 0 0 600 0

L! " 2 ES!#$%E" 400 $!& " 2

ITEM Bana 38 39 40 41 42 43 44 4 46 47

essi(a(e )r*+a 0 0 0 0 0 0 0 1200 0

,*e &ispon-e. 400

ei'en+o Pre-is+os 0

essi(a(e Li,*i(a 0 0 0 0 0 0 0 800 0

ao (e #r(ens 800 1400

$!& " 4 %sa(o

L! " 1 ES!#$%E" 0 $!& " 2 %sa(o

ITEM Cana 38 39 40 41 42 43 44 4 46 47

essi(a(e )r*+a 3200 1200 600

,*e &ispon-e. 0 0 0ei'en+o Pre-is+os 0 0 0

essi(a(e Li,*i(a 0 0 0 0 0 3200 1200 600

ao (e #r(ens 3200 1200 600 14

L! " 4 ES!#$%E" 00 $!& " 1

ITEM Dana 38 39 40 41 42 43 44 4 46 47

essi(a(e )r*+a 800 1400

,*e &ispon-e. 00 40

ei'en+o Pre-is+os 0 0essi(a(e Li,*i(a 300 90

ao (e #r(ens 70 130 1800

L! " 2 ES!#$%E" 0 $!& " 1

ITEM Eana 38 39 40 41 42 43 44 4 46 47

essi(a(e )r*+a 3200 1200 600 14

,*e &ispon-e. 0 0 0

ei'en+o Pre-is+os 0 0 0


12/16

Exerccio_2

Pgina 12

essi(a(e Li,*i(a 3200 1200 600 14

ao (e #r(ens 3200 1200 600 1400 7200

L! " 1 ES!#$%E" 0 $!& " 1

ITEM 'ana 38 39 40 41 42 43 44 4 46 47

essi(a(e )r*+a 3200 1200 600 14

,*e &ispon-e. 0 0 0

ei'en+o Pre-is+os 0 0 00essi(a(e Li,*i(a 3200 1200 100 14

ao (e #r(ens 3200 1200 100 1400 7200

PLANO DE COMPRAS)PROD*+,OMANA 38 39 40 41 42 43 44 4 46 47

0 0 0 0 0 0 0 200 0 0

0 0 0 0 0 (00 0 0 100 00 0 0 0 /00 0 1/00 3200 0 100 430 0 0 130 0 0 1(00 0 00 0 /00 0 1/00 3200 0 100 4/00 00 0 /00 0 1/00 3100 0 100 4/00 0


13/16

Exerccio_2

Pgina 13


14/16

Exerccio_2

Pgina 14

TERIAIS

48 49 0 1 2

700 900

48 49 0 1 20 700 0 0 900

0 0 0 0 0

0 0 0 0 0

0 700 0 0 900

700 0 0 900 0

48 49 0 1 2

1400 0 0 1800 0

1400 0 0 1800 0

1800

48 49 0 1 2

1400 7200 1800

0 0 00 0 0

1400 7200 1800

7200 1800

ES " 400 L#!E " 10

48 49 0 1 2

1800

400

01400

48 49 0 1 2

7200 1800

0 0

0 0


15/16

Exerccio_2

Pgina 1

7200 1800

1800

48 49 0 1 2

7200 1800

0 0

0 07200 1800

1800

48 49 0 1 2

00 0 0 .00 0

0 1(00 0 0 0/00 0 1(00 0 00 0 0 0 0(00 0 0 0 0(00 0 0 0 0


16/16

Exerccio_2

Planilha de MRP

Text of Planilha de MRP

MRP e MRP II - edisciplinas.usp.br · O sistema MRP II ( aprimoramento do MRP) contempla a integração de todos os aspectos do processo de fabricação, incluindo a relação entre

Unidade II MRP e MRP II - s3.amazonaws.com fileRegistros de Estoque •Os registros de estoque alimentarão o sistema MRP com as informações de movimentação interna do estoque,

Ppcp Aula 04 Mrp e Mrp II

Macro Excel MRP

O Sistema MRP Aula 06. MRP I Pedidos já realizadosPrevisão de demanda

Administração da Produção - Petrônio Garcia Martins e Fernando Piero Laugeni – Editora Saraiva 11 MRP / MRP II –MRP = Material Requirement Planning (planejamento

Apostila MRP Conceitos Básicos

Aula de mrp

MRP na prática - gerenciamento da produção

Mrp Helpsap

PCP, MRP, MRP II E ERP

Fascículo 3 MRP e MRPII - UNIP.br

Bidcash Antiga Mukirana Equipe Mrp

Estoque MRP MRP II ERPInovação Flexibilidade MRP II MRP

Sistemas de Produção1 MRP II Material Resources Planning

Manual Da Qualidade MRP 2

Tgti sig-modulo03-mrp-mrpii

Manual - MRP Suprimentos - 27-Dez-2013

GESTÃO DE OPERAÇÕES MRP E JIT. NOÇÕES BÁSICAS DE MRP MRP = MATERIAL REQUIREMENTS PLANNING ( PLANEJAMENTO DAS NECESSIDADES DE MATERIAIS). MRP II = MANUFACTURE

GESTÃO DA PRODUÇÃO E ESTOQUES - proage.com.br · Aula 02 - MRP - Planejamento de necessidades de materiais Agenda 1. Apresentação MRP 2. Estudo de Caso 3. Apresentação da Planilha

TOTVS ATIVE Manufatura MRP (Linha Protheus)

2º e 3ºaula de pcp, mrp i e mrp-ii (1)

Mat MRP 2007 10 Novo

MRP EXERCICIO.docx

Gestão da Produção Prof. Miguel Antonio Pelizan 10 – MRP/MRP II Planejamento de Recursos de Manufatura

PROGRAMA DE TREINAMENTO EM MRP IIcorrea.com.br/treinamentos/arquivos/Tutorial da... · tem um registro de MRP na planilha do POLITRON, como pode ser visto na Figura 9. Figura 9 -

MRP Consumo

Trabalho MRP

Planejamento das Necessidades de Materiais (MRP) Prof

Trabalho de MRP

Documents

Planilha de MRP

Text of Planilha de MRP