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

Documents

Planilha de MRP