ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> General DBA Topics >> std labor vs avg. labor...
http://www.istechforum.com/YaBB.pl?num=1119013142

Message started by penz on 06/17/05 at 04:59:02

Title: std labor vs avg. labor...
Post by penz on 06/17/05 at 04:59:02

Hi,
What tables would I use to bset create a report of Standard labor hours vs. Average labor hours for an item?

Thanks

Jim P.

Title: Re: std labor vs avg. labor...
Post by David Waldmann on 06/17/05 at 07:57:51

MTICMSTR - MTIC.PROD.RCOST [4] Labor Cost - This level
MTICMSTR - MTIC.PROD.RCOST [10] Rolled up Labor Cost - All Levels
BKICMSTR - BKIC.PROD.AVLAB - Average labor cost

Title: Re: std labor vs avg. labor...
Post by penz on 06/17/05 at 09:52:12

...I did that unfortunitly there isn't any data in the AVLABOR or AVMAT.

Title: Re: std labor vs avg. labor...
Post by cathyh on 06/17/05 at 10:34:11

I don't know if this is what you are looking for, but we do a report in Access using WOROUT, WORKORD and WORECV to collect the number of hours for estimated(standard) and actual per work order and average them by part number. The WOROUT has actual and estimated hours per sequence, and the WORKORD file has actual labor and estimated labor totals.
WORECV filters by receipt date. We can do this by sequence or by total. I think even if you are only interested in labor dollars you would have to use work order files, and average the labor over a given date range (could be all date ranges).