Welcome, Guest. Please Login.
04/25/24 at 20:31:18
News:
Home Help Search Login


Pages: 1
Send Topic Print
Inventory Costs (Read 1712 times)
TwinOaks
Member
**


I Love EvoERP!

Posts: 83
Gender: female
Inventory Costs
11/08/12 at 15:19:50
 
Where do the last, average, and standard costs come from when you look up an item in inventory inquiry? -Hali
Back to top
 
 

Camille
Twin Oaks Industries
4+Yr User of EVO 2013.4 Latest Update
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Inventory Costs
Reply #1 - 11/10/12 at 08:34:29
 
The Last cost is the unit cost of the last transaction that added to on hand inventory which is typically a PO Receipt or Work Order receipt but could be adjustment or reversal of a transaction type that normally pulls from on-hand.
 
Average is the average of on-hand stock and is recalculated when items are received in as a weighted average of current stock at old average cost and the new receipt at its cost.  When on-hand goes to 0, the next receipt begins a new average unaffected by prior history.
 
Standard cost is the value that you give it for purchased parts and does not change unless you deliberately change it in IN-B, IN-L-A or IN-L-E.  Assemblies and Finished goods get their standard cost from a rollup of the BOM component and routing standards in IN-B, IN-L-A or BM-G.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Laura Oliver
Active Member
*****




Posts: 984
Gender: female
Re: Inventory Costs
Reply #2 - 03/14/17 at 08:46:13
 
Definitions / comments for future reference ....understanding and keeping costs straight in my mind.  
LAST COSTS
Quote from Lynn_Pantic on 11/10/12 at 08:34:29:
The Last cost is the unit cost of the last transaction that added to on hand inventory which is typically a PO Receipt or Work Order receipt but could be adjustment or reversal of a transaction type that normally pulls from on-hand. .

 
Quote from Lynn_Pantic on 07/20/16 at 11:30:36:
Last Cost is a reference only and is the cost associated with the last transaction adding to stock, from any source including the reversal of a transaction that would normally consume stock.  .

 
Quote from Lynn_Pantic on 09/30/16 at 09:40:42:
Last cost is the Last time a part was received to stock from any source so it could be a PO or WO receipt, an adjustment, or a reversal of something that would normally take it out of stock.

 
 
AVERAGE COSTS
Quote from Lynn_Pantic on 07/20/16 at 11:30:36:
Average Cost is the weighted average of existing on-hand stock.  New Average Cost is calculated when items are put into stock by averaging with what is there.  If there is 0 on hand, a new average will begin.  Transactions coming out of stock (including COGS of shipments take place at Average Cost. .

 
Quote from Lynn_Pantic on 11/10/12 at 08:34:29:
Average is the average of on-hand stock and is recalculated when items are received in as a weighted average of current stock at old average cost and the new receipt at its cost.  When on-hand goes to 0, the next receipt begins a new average unaffected by prior history.

 
Quote from Lynn_Pantic on 03/11/13 at 20:27:27:
…When a new item is entered, by definition the UOH and Average and Last cost are 0 and will be updated the first time the item is transacted.  Base price is what you want to sell it for and Standard cost (if a purchased item) is what you manually select it to be.  

 
 
STANDARD COSTS
 Quote from Lynn_Pantic on 11/10/12 at 08:34:29:
Standard cost is the value that you give it for purchased parts and does not change unless you deliberately change it in IN-B, IN-L-A or IN-L-E.  Assemblies and Finished goods get their standard cost from a rollup of the BOM component and routing standards in IN-B, IN-L-A or BM-G.

 
Quote from Lynn_Pantic on 07/20/16 at 11:30:36:
Standard Cost is a benchmark and never changes until you deliberately change it.  Standard Cost for purchased items is entered and then the standard cost of assemblies is rolled up based on the bill of materials, purchased component standard cost and, if applicable, labor and overhead based on time standards on routings and work center rates. .

 
Quote from Lynn_Pantic on 09/30/16 at 09:40:42:
….Standard costs are only updated when you want to update them, not every PO receipt.  Most people only update standards once or twice a year.

 
Quote from Lynn_Pantic on 03/11/13 at 20:27:27:
…Standard cost (if a purchased item) is what you manually select it to be.  

 
Quote from Lynn_Pantic on 06/17/13 at 17:32:29:
Standard Cost is not changed by UT-K-F.  It is used by UT-K-F and copied to the Average and Last Cost fields.

 
Quote from Lynn_Pantic on 07/16/13 at 17:28:25:
….Standard is a benchmark and should be updated as frequently as you deem necessary.  Some people update standards quarterly, some annually.   It depends what you use it for.

 
Quote from David Waldmann on 10/19/16 at 07:49:48:
If you are set up to use Standard Costs, then the PO will be received AT standard cost (as manually entered) regardless what you pay for the items. If you are using Average, LIFO or FIFO, then Standard Cost is just a reference. I believe the only thing it's actually used for in DBA/Evo is in the Estimating module (and there CAN be separate costs entered to be used only in Estimates).

 
Quote from shadowcaster on 09/17/13 at 19:03:17:
Standard cost is the sum of all costs for that item.
Depending on item type, the cost will be dependent on the sum of the costs associated with that item type.

A type R item is cost plus freight

A type A item is the cost of the bom components plus routing cost ect.

What I usually find is if we make it it costs too much !

Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Pages: 1
Send Topic Print