MRP System

G

gatarossi

Dear all,

I need to do a MRP system in access, but I don't have idea how to do
it... I known that I have a item that is composed by others itens...

final_code level_1 level_2 level_3 level_4 level_5 level_6 ...
quantity
xxx01
xx001
100

x0001 90

x0002 100

xx002
80

x0003 80

x0004 80

x0005 80

xx003
50

x0006 50

x0007 100

Then the item xxx01 is composed by the itens: xx001, xx002, xx003 and
x007.
The item xx001 is composed by the itens: x0001 and x002...

How can I did it... In the system there are 10 levels... I can't see
how can I calculate the production/consume of the components and how
can I will put values in the subgroup itens...

Is anybody have an example, please?


Thanks a lot!!!

André.
 
G

Guest

It looks like you are just starting, and are looking for a BOM.

http://www.mvps.org/access/modules/mdl0027.htm

Of course, a PLANNING system will be much more than a
Bill of Materials -- are you sure you want to do this? Everything
they say about BOM design is even more true about MRP:

http://www.buyplm.com/land-access-01.htm.aspx

(david)


Dear all,

I need to do a MRP system in access, but I don't have idea how to do
it... I known that I have a item that is composed by others itens...

final_code level_1 level_2 level_3 level_4 level_5 level_6 ...
quantity
xxx01
xx001
100

x0001 90

x0002 100

xx002
80

x0003 80

x0004 80

x0005 80

xx003
50

x0006 50

x0007 100

Then the item xxx01 is composed by the itens: xx001, xx002, xx003 and
x007.
The item xx001 is composed by the itens: x0001 and x002...

How can I did it... In the system there are 10 levels... I can't see
how can I calculate the production/consume of the components and how
can I will put values in the subgroup itens...

Is anybody have an example, please?


Thanks a lot!!!

André.
 
Top