Labor cost

Yahoo Archive
1
I would use the Sales/Gross Margin report (access it from the AR module).
You can sort by Product Group and it gives you Cost of Sales broken down by
its elements (Material, Labor, etc.).

Jim O'Donnell
Camcraft
jodonnell@...


In order to accurately determine labor cost is to be able to separate labor
by product groups. This is necessary due to the fact that different product
groups incur different proportions of the same type of labor (work center or
department), i.e. assembly, grinding, milling, etc. for dies versus molds.

Currently, the only way I see to come up with this type of reporting is to
manually go through the labor edit report and determine which jobs fall
under each product group and manually add them all up.
2
I have a question from our controller:

In order to accurately determine labor cost is to be able to separate labor by product groups. This is necessary due to the fact that different product groups incur different proportions of the same type of labor (work center or department), i.e. assembly, grinding, milling, etc. for dies versus molds.

Currently, the only way I see to come up with this type of reporting is to manually go through the labor edit report and determine which jobs fall under each product group and manually add them all up.

Does anyone else have any suggestions? If not, we would like to submit this suggestion to Epicor for Vantage.

Rob McColgan
Controller
Schmald Tool & Die, Inc.
(810) 743-1600 ext.336


[Non-text portions of this message have been removed]
3
"Currently, the only way I see to come up with this type of reporting is to
manually go through the labor edit report and determine which jobs fall
under each product group and manually add them all up."


Wendy,

I'm not exactly sure what you are trying to get, in terms of a report. On
the job Header there is a 'Product Group' field. So, couldn't you just
specify on the job what type of product the job is for using this field and
then write reports based on the labor detail to get what you need? Maybe
I'm missing what you need?

Sarah
4
We have a WIP Labor GL account for each Product Group. This way Vantage
keeps track of this for us by way of GL account postings. Unless you have
only a few employees and/or jobs any manual calculations are going to become
very time consuming.

-----Original Message-----
From: Wendy Pursche [mailto:wpursche@...]
I have a question from our controller:

In order to accurately determine labor cost is to be able to separate labor
by product groups. This is necessary due to the fact that different product
groups incur different proportions of the same type of labor (work center or
department), i.e. assembly, grinding, milling, etc. for dies versus molds.

Currently, the only way I see to come up with this type of reporting is to
manually go through the labor edit report and determine which jobs fall
under each product group and manually add them all up.

Does anyone else have any suggestions? If not, we would like to submit this
suggestion to Epicor for Vantage.
5
I would use the export feature. Reference the InvoiceDtl table and pull
Labor costs for whatever type of costs your using Last, Average, or Standard
and select Product Group. This will give you the total costs applied for
each individual Product group Pivot the information using EXCEL.
Works great for me .
I have a query written - Email if you want to try it?

Don Kollmann
Wisconsin EPS
DONK@...

We have a WIP Labor GL account for each Product Group. This way Vantage
keeps track of this for us by way of GL account postings. Unless you have
only a few employees and/or jobs any manual calculations are going to become
very time consuming.

-----Original Message-----
From: Wendy Pursche [mailto:wpursche@...]
I have a question from our controller:

In order to accurately determine labor cost is to be able to separate labor
by product groups. This is necessary due to the fact that different product
groups incur different proportions of the same type of labor (work center or
department), i.e. assembly, grinding, milling, etc. for dies versus molds.

Currently, the only way I see to come up with this type of reporting is to
manually go through the labor edit report and determine which jobs fall
under each product group and manually add them all up.

Does anyone else have any suggestions? If not, we would like to submit this
suggestion to Epicor for Vantage.



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)