ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> job cost report and associated values contained
http://www.istechforum.com/YaBB.pl?num=1240860915

Message started by lburns on 04/27/09 at 12:35:15

Title: job cost report and associated values contained
Post by lburns on 04/27/09 at 12:35:15

Where are values coming from within the Job Cost Report for the “actual per part” cost of raw components?

Looking into the material cost variances listed within the Job Cost Report for specific work orders, I verified via JC-E that no material was issued to scrap, that only the required material for the work order was issued to the work order; I have double checked the pricing of the component (average/last/standard) and the cost associated with the part upon issuing the material and they all match to what the “estimated per part” yet upon running the Job Cost Report, the report reflects a substantial variance. What could be causing this? What am I missing?

Thanks in advance!

Title: Re: job cost report and associated values containe
Post by cathyh on 04/27/09 at 13:09:52

Are you running JC-A in detail, and in the Raw material issues section comparing the estimated and the actual cost, line item by line item, for any differences?

Title: Re: job cost report and associated values containe
Post by lburns on 04/27/09 at 14:20:59

Cathy -

That is how we are noticing it - using JC-A in detail, we can see a component where the estimated per part costs is accurate but the actual per part costs are all off. To check further, I evaluate the material issues to make sure there was no scrap. For example, part 420019 is estimated to cost 5.985 but the actual cost is 10.86 though we only paid 5.985 for part 420019 and it was issued at 5.985 and no scrap was issued against the work order for the part. Therefore I am rather confused as to how DBA is generating the cost of 10.86. Mind you this is not happening on every Job Cost Report, but a handful here and a handful there each day....

Thanks again for your feedback!

Title: Re: job cost report and associated values containe
Post by cathyh on 04/27/09 at 15:17:23

Do you perhaps issue your parts by backflushing?

I seem to remember having some Bills of Materials whose items had a scrap % that affected the cost of those parts being backflushed in a work order sequence. When we took out the % scrap, all was well.

Title: Re: job cost report and associated values containe
Post by lburns on 04/28/09 at 15:34:05

Cathy -

Thanks for your input! I am so stumped by this one :)

We issue at the point of kitting the job, there is no backflushing of material. I have also checked the parts to make sure there was no percentage for scrap and there is not (does not surprise me because we do not use that function), rather if we scrap something we issue it to the job using a scrap code...

I am stumped....

Thanks again!

Title: Re: job cost report and associated values containe
Post by cathyh on 04/29/09 at 07:52:10

I'm stumped too-- did you try running the rebuild costs for the work order(WO-K-H)? The work order needs to be re-opened if you closed it.