Scrap & Efficiency

[MacWheel99@xxxxxxx]

Several managers & supervisors are interested in monitoring scrap percentage 
& production efficiency for particular work centers, and for the sub-assembly 
production work that we do that is ultimately for particular customers (scrap 
percentage by customer parts).

We created several Query/400 reports for BPCS 405 CD driven off of 
FLT Labor Detail History
JPH Production Summary History
which total reported quantity produced scrapped etc. by work center then 
figure percentage & cost (reported item linked to CMF CFTLVL plus CFPLVL 
times quantity scrapped for CFCSET 2 standard and CFCBKT 1-5 excluding 2) for 
particular facility & date range.

We never did figure out how to get percentages thru query when doing totals 
only ... averaging the calculated fields does not cut it.

Even though JPH is for a whole year & FLT is for 3 months, shouldn't 
percentage be about the same for a particular department?

Where exactly do these files get their updates? ... I think FLT is from JIT6* 
and SFC6* ... do both approaches capture scrap reporting? ... I do not know 
if JPH is updated at that time or has to wait on JIT900, and if the sequence 
of CST900 makes a difference.

There's also ITH off of JIT6* labor transactions ... is there a field in 
there for labor reported scrap?

We do JIT6* for most production reporting, with SFC6* & INV5* for final 
production that gets shipped, and SFC6* for clean-up of shop orders that get 
closed early ... less production than originally called for.  We have been 
assuming that all labor reported (scrap, quantity good, hours, etc.) go into 
both FLT & JPH irrespective of JIT6* or SFC6* input ... is that a valid 
assumption?

Al Macintyre
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---