Scheduling / MRP database

I am attempting to roll my own MRP system using SQL7. I believe I have most of the tables in place which will be required to store and track data associated with materials & fabricated parts. I am having trouble with the scheduling portion of the task, i.e. man hours available vs man hours required for part manufacture associated to a calendar.



Would I need to create a calendar table to store the hours available and the hours required for each day? Is there a way I can plug into the system calendar to generate the calendar?



Please help ... I really don't know where to start.



Thank You Very Much,

Best Regards,

JK


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories