ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Running MRP
http://www.istechforum.com/YaBB.pl?num=1149798337

Message started by gtladmin on 06/08/06 at 12:25:37

Title: Running MRP
Post by gtladmin on 06/08/06 at 12:25:37

Our Purchasing manager wants to know if there's a way to schedule MRP generation for Buy, Expedite, and Delay for purchased parts only? I can't seem to find any info on if we can do this or not.

Anybody?

TIA

Val

Title: Re: Running MRP
Post by Lynn Pantic on 06/08/06 at 16:33:02

Generation has to run for everything but reports can be filtered for R only

Title: Re: Running MRP
Post by gtladmin on 06/09/06 at 05:31:29

Thanks, Lynn. I'll pass that along.

Val

Title: Re: Running MRP
Post by shadowcaster on 06/13/06 at 07:07:14

The report filters are the key to getting useful stuff from the mrp.

using MR-H with Just B or M selected gives a nice picture of what you should be doing

J Dub

Title: Re: Running MRP
Post by gtladmin on 06/15/06 at 12:30:47

Thanks for that info, he was in fact already doing that.
What he really wants to know is how can he schedule it to run at a specified time and then send the report to a printer? Ideally he wants to have the MRP run and be ready for him when he arrives at the office. Is this something I can do via a batch job of some type? When he runs it now, it really only takes a few minutes to run, but he'd like to "automate" it.

Val

Title: Re: Running MRP
Post by shadowcaster on 06/16/06 at 07:27:02

You should have all mfg items cleaned up 1st

I run the report to the screen for M types
copy it from the screen to excel
convert data to colums in excel

then I copy and paste each item back to dba IN-A

do a quick look at the situation for that item

make changes I need to make in IN-B Min Level, reorder amount ect if required.

rerun the mrp

make a mfg run

rerun the MRP

make sure M types are clean (no requirments)

run for B types
get the list into excel
same things clean up items using IN-A to review
IN-B to make changes (check levels, usage, standard packs, ect)

rerun the mrp
do a BUY run generating the PO's I need by week
usually setting due date a week before I need them

when theres nothing left on the MR-H (B) report

Im Done
NO PAPER
Save your Brain
work from excel cut and paste
Crtl C and shift Insert

j Dub

Title: Re: Running MRP
Post by cmsk on 10/12/06 at 10:19:01

Hey again,

I see here, and in the other posts I've had questions on, that you use Excel for adjustments, tweaking, or whatever... I guess I'm not really clear as to what you are actually useing Excel for. What "changes" must you make in a spreadsheet that you can't do in DBA? Extra work, no?

Title: Re: Running MRP
Post by shadowcaster on 10/17/06 at 06:34:53

for me its very efficent
copy the printouts into excel
convert to collums so the part number is in its own cell

This gives you a nice scratch pad to work from and you dont need to retype part numbers like you would from a paper printout

use alt-tab between excel and DBA
use Ctrl C to copy Shift Ins to Paste
hands dont leave the Keyboard

now you can copy and paste from the list back into DBA IN-A and IN-B to see whats up with each item why you need it, how many to make, or buy ect. as my items parameters have been refined I do much less checking

I use the background color tool to mark the ones Ive checked as I go.

I make adjustments on items that require it.

rerun the mrp

when all is well I run workorders
rerun MRP
check items the system wants to buy the same as I check the items it wanted to make
make changes
rerun mrp
do a buy run
generate PO's I try to schedual po's by due date
so I do po runs in 7-15 day increments and schedual things in a week or 2 before the w/o due date.

I save the spreadsheets by date for reference in case I need to review something (never Have needed them though)

J Dub

Title: Re: Running MRP
Post by cmsk on 10/17/06 at 09:09:00

???

Sorry, I guess I'm just failing to see what you are actually using Excel for. The process of what you are doing is clear, but I don't see exactly what you are accomplishing by it.

I'm also a bit confused on how you copy ANYthing into IN-A. The only field that can be changed is the item number and first description line.

In any event, my main hurdle right now is getting lead times, reorder amounts, and levels into ALL of the many existing items that have zeros in those fields.

Dizzying.... :'(

Title: Re: Running MRP
Post by shadowcaster on 11/02/06 at 08:14:03

usually if something comes up on my mrp buy or make list I check why in IN-A
and then adjust of fix it in if-b if it needs that.

since I have the list in excel I just use cut and paste of the part numbers rather than use a printout on paper.
This saves lots of typing and paper

the issue you have now is that your data is not initialized/complete for the MRP.

there are many ways to deal with this to make things happen quickly

lead times don’t have to be exact so set them all to some reasonable setting. 1-2 weeks 4 weeks something like that. if you have known long lead items then set those appropriately but most items come in within a month

Of course you will need routings I generated all mine in a spread sheet and did an import to get started. In our old system we had labor/process info in the bom so I separated it out and use that as the basis for generating my routings. if I had nothing I would either add them manually copy and paste from another item or just add a generic routing to get started.

You can generate lead times for manufactured items once purchased items are done and you have some routings.

Re-order levels
you need to run some reports that can tell you usage rates (like how many you use in a year) from these you can calculate how many to stock and when to reorder based on the number of inventory turns you want I use 4-6 turns.

6 is replenishing every 2 months and that seems to work for me.

If I use 1200 a year and I want 6 turns that’s 200 at a turn so I buy 200 at a time if the lead time is a week then I set the reorder level to 1 weeks worth of usage 200/8. So they arrive JIT. You can also add some margin in there too JIC (Just in Case)

You don’t want to do these 1 at a time though that why you get all the data into a spreadsheet or access database calculate the values and then use export import or something like Wintask to automate the data entry into DBA.

Sometimes I use access when I have to merge data from different data tables to get all the info I want into 1 table that I can then use wintask to do the data entry from.

I have a spreadsheet that I used to calculate stock levels based on usage, turns, ect I could send it to you if you want to look at it.

how many items are you working with ?

J Dub

Title: Re: Running MRP
Post by CCKEITH on 11/02/06 at 09:00:03

"I have a spreadsheet that I used to calculate stock levels based on usage, turns, ect I could send it to you if you want to look at it. "

I would be interested in this spreadsheet. Could you please email it to me?

Title: Re: Running MRP
Post by shadowcaster on 11/04/06 at 16:48:10

Charlene

I put it in your e-mail

J Dub

Title: Re: Running MRP
Post by cmsk on 11/06/06 at 08:12:15

Yeah, I'd like to take a look too, at least.

Title: Re: Running MRP
Post by cmsk on 11/06/06 at 09:49:50

shadowcaster wrote:

how many items are you working with ?

About 2000 here,

Title: Running MRP :  More issues
Post by cmsk on 01/03/07 at 10:29:30

We're still trying to get our heads / hands / whatever around this MRP thing. I think our lead times should be pretty well set, but I have some other concerns that I need clarified.

I ran the MR-H for Buy parts and I noticed several (well, quite a few) items that came up on the report with a BUY action (obviously) pegged to PO's with Start, Due, and Req Dates from back to anywhere from a few months to almost a year!!!

These PO's have long since been received, paid, and closed so how are they showing up on this MR-H report?

Similarly, running MR-G for R parts lists "tons" of items that have LONG since been bought.

Obviously my "clean up" is going to go much farther than BOM's, leadtimes, and reorder points. How do I go about getting rid of all these nonsensical items that are showing up on these reports?

Title: Re: Running MRP
Post by Lynn_Pantic on 01/05/07 at 16:23:34

Did you regen the MRP (MR-F) first? All the MRP reports are only as recent as the MR-F run.

Title: Re: Running MRP
Post by cmsk on 01/07/07 at 06:47:29

Lynn_Pantic wrote:

Did you regen the MRP (MR-F) first? All the MRP reports are only as recent as the MR-F run.

Oh yeah, it's been run MANY times, and I last ran it the beginning of last week.

Title: Re: Running MRP :  More issues
Post by cmsk on 01/10/07 at 10:05:06

cmsk wrote:

Any ideas on this?

Title: Re: Running MRP
Post by cmsk on 01/16/07 at 04:24:50

Thoughts on why this information is still showing up? I don't see how I can progress with the MRP when these items are still there.