Welcome, Guest. Please Login.
05/10/25 at 15:16:31
News:
Home Help Search Login


Pages: 1
Send Topic Print
job cost report and associated values contained (Read 667 times)
lburns
Member
**




Posts: 75
Gender: female
job cost report and associated values contained
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!
Back to top
 
 

Laurie Burns
Excel Connection USA
dba classic 2004.1/Evo-ERP
is tech build 11/08/2007
pervasive 8.0
Email wigal2000   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: job cost report and associated values containe
Reply #1 - 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?
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
lburns
Member
**




Posts: 75
Gender: female
Re: job cost report and associated values containe
Reply #2 - 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!
Back to top
 
 

Laurie Burns
Excel Connection USA
dba classic 2004.1/Evo-ERP
is tech build 11/08/2007
pervasive 8.0
Email wigal2000   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: job cost report and associated values containe
Reply #3 - 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.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
lburns
Member
**




Posts: 75
Gender: female
Re: job cost report and associated values containe
Reply #4 - 04/28/09 at 15:34:05
 
Cathy -
 
Thanks for your input!  I am so stumped by this one Smiley
 
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!
Back to top
 
 

Laurie Burns
Excel Connection USA
dba classic 2004.1/Evo-ERP
is tech build 11/08/2007
pervasive 8.0
Email wigal2000   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: job cost report and associated values containe
Reply #5 - 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.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Pages: 1
Send Topic Print