Welcome, Guest. Please Login.
05/12/25 at 03:47:48
News:
Home Help Search Login


Pages: 1
Send Topic Print
Job cost problem (Read 476 times)
kemkraft.com
Browser
*


I love YaBB 1G -
SP1!

Posts: 8
Job cost problem
08/03/05 at 09:33:44
 
Q: Where does that Last Cost for a part number come from?
 
When I do an inventory inquiry, it shows the last cost as 3 times what we sell the product for.  We have the same sequence number set up for all parts.  We do this for ease of input of the labor.  
 
Q: When we enter this, should the last cost be based upon this?  
Q: Also, is the parent part cost based upon the labor input for that as well as the cost of all child parts?
 
Since we set up the ability to input labor, the cost of all of our products have been incorrect, they are all more than they should be.
Back to top
 
 

Kemkraft Engineering, Inc.
47650 Clipper
Plymouth, MI 48170
Phone (734) 414-6500
Fax (734) 414-6599
Visit Us On The Web: http://www.kemkraft.com
WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: Job cost problem
Reply #1 - 08/04/05 at 03:54:51
 
The last cost for a purchased item, is the Last PO Receipt Cost.
 
The Last cost for a part number manufactured on a work order, is the last Work Order Receipt Entry (finished production entry).
 
If the last cost of a manufactured item looks out of sync, you may want to check the cost that is being used when finished production is entered - not sure if you are using Standard costs or Average costs.  If your labor costs look incorrect, you may want to check your labor rate and loads rate defaults in RO-C.
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
kemkraft.com
Browser
*


I love YaBB 1G -
SP1!

Posts: 8
Re: Job cost problem
Reply #2 - 08/04/05 at 05:53:14
 
Thank you for your response, I did some looking into this.
When I started this, I was refering to manufactured parts, not purchased parts, although there seems to be a problem with those as well.
 
I checked under RO-C and all dollar amounts ar $0.00.
 
When I check a part, I want the last cost to be the value of all the labor and material that went into making that part.  When I check a parent part that contains these child parts, I expect the last cost of the parent part to be the sum of all the child parts as well as labor and material to finalize the parent.
 
When I check the price of some of the purchased parts of this through IN-A, I have a last cost at $55.60, Avg Cost at $0.00 and Std Cost at $57.00.  I am seeing this all over, although the PO for that part shows $55.60 each, the average cost is zero.
Q: How can this be corrected and/or where does this come from?
 
For instance, when I print a BOM at average cost, some of the manufactured parts have $0.00 for both Avg Cost and Extended and some have prices, although IN-A shows a value for the last cost.  It is the same for some of the purchased parts.
Q: How can this be fixed?
 
Q: Is there a help file for DBA that actually works, that can be searched and show an index?  Mine has ???? on each tab.
Back to top
 
 

Kemkraft Engineering, Inc.
47650 Clipper
Plymouth, MI 48170
Phone (734) 414-6500
Fax (734) 414-6599
Visit Us On The Web: http://www.kemkraft.com
WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Job cost problem
Reply #3 - 08/04/05 at 08:00:46
 
The Last Cost will be whatever the cost was the last time they went into stock - typically WO-I receipt was for a manufactured item but could be an Inventory Adjustment.  If you are using FIFO or LIFO costing, then once on-hand is 0 the Average Cost will also be zeroed out.  Otherwise, it should be the average of current on-hand stock and if you are not using FIFO or LIFO, then when the stock level hits 0 the Average Cost should be retained at whatever it was at that point..
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print