Labor Hours by Resource Group, to produce a part

Kinetic ERP
1

Hello,

Is there a tracker/report that shows the total labor hours required (by Resource Group), to produce a part?

Thanks,
Nolan

2

Production details from job tracker after the fact. What are you looking to figure out?

3

I want to know how many labor hours are required, by resource group, to produce 1 of any given part.

Our production manager wants to know how many labor hours are required by our welding department to produce our typical project of carts. I don’t know how to answer this without creating a job for this, then writing a BAQ to sum the labor hours for the welding department.

4

@nstorm PartOpr has the times and PartOprDtl has the RG. We do something like this called Bom Time Check. I stripped out our ud fields so this should not blow up for you and give you some ideas.
BomTimeSample.baq (35.6 KB)

5

This BAQ is good for looking at individual levels of a BOM. However, I’m looking for the total time for a parent BOM.

For example, here is an over-simplified BOM of a cart:

Parent-level Cart
Bottom
Wrapper
Top

I want to know the total time required by our welding department, only by looking at Parent-level Cart.

6

That is going to require a more complex baq with CTE and recursion. There ae examples of doing that with a job or a bom, so maybe you can apply that info to a boo.