Defining the Hierarchy of Costs

 

Expand/Collapse all Show/Hide All

Auto Reorder Selection, Auto Generate from Sales Orders, Purchase Order Entry, Receipt of Goods Entry, Return of Goods Entry, and Material Requisition Issue Entry use a hierarchy to define how cost types are used.

Note For standard and average cost items in Purchase Order Entry, Receipt of Goods Entry, Return of Goods Entry (no purchase order specified), the cost hierarchy for each valuation method is followed. In Material Requisition Issue Entry (one-step) and material requisitions entered in Purchase Order Entry, the cost hierarchy for each valuation method is followed.

Hierarchy of Costs for Purchase Order Entry, Receipt of Goods Entry, Return of Goods Entry (one-step), Material Requisition Issue Entry (with a Purchase Order number assigned), and Auto Reorder Selection:

Hierarchy of Costs for Auto Generate from Sales Orders:

 

Expand/Collapse item  Valuation Methods

 

Expand or collapse item Standard Valuation

The standard cost from the Item file is used. If the standard cost is zero, the unit cost defaults to the last cost. If the last cost is zero, the unit cost defaults to the warehouse average cost. If the warehouse average cost is zero, the unit cost defaults to the item average cost.

Standard cost is the simplest inventory valuation method. When this method is used, the cost is determined by the value assigned for the item in the Standard Cost field in Item Maintenance. The standard cost does not change unless you manually enter a new cost for the item. The total inventory value of each item equals the quantity on hand multiplied by the standard cost. As items are sold, the standard cost is used to determine the cost of goods sold, unless the standard cost value is zero, then the cost hierarchy is used.

This method is appropriate only if you do not track changes in cost as you purchase additional units, and if the standard cost for each item does not change frequently.

When the standard cost value for an item is changed in Item Maintenance, no automatic general ledger postings are made to reflect the change in the total inventory value. These adjustments must be made manually using General Journal Entry.

When items are received into inventory using Transaction Entry or the Purchase Order module, the difference between the cost received and the standard cost is posted to the adjustment account.

Expand/Collapse item  Average Valuation

The warehouse average cost from the Item file is used. If the warehouse average cost is zero, the unit cost defaults to the item average cost. If the item average cost is zero, the unit cost defaults to the last cost. If the last cost is zero, the unit cost defaults to the standard cost.

Note For average cost items, if the quantity on hand is negative, the average cost will be an estimate because the actual cost is not yet known. If an item's quantity is expected to perpetually remain negative, use the FIFO, LIFO, or standard cost valuation method instead.

Average cost is the most commonly used method of costing inventory. Each time new units of an item are purchased (received), a new average cost is calculated. The total inventory value of an item is the quantity on hand multiplied by the average cost. The cost of items shipped (issued or sold) equals the quantity multiplied by the average cost. As items are sold, the warehouse cost is used to determine the cost of goods sold.

The calculation performed during a receipt update is:

(Total cost of the warehouse quantity on hand + total cost of the quantity to be received) / (Total warehouse quantity on hand + total quantity to be received)

The following table illustrates how the average cost changes as receipts and issued are entered.

Transactions

Qty on Hand

Total Cost $

Avg Cost $

Opening Inventory

   0

     0.00

0.00

Receive 100 @ $5.00 each

100

  500.00

5.00

Receive 200 @ $6.50 each

300

1800.00

6.00

Issue 50 @ $6.00 each

250

1500.00

6.00

Receive 250 @ $7.00 each

500

3250.00

6.50

Issue 100 @ $6.50 each

400

2600.00

 

 

Expand or collapse item  LIFO/Lot/Serial Valuation

The last cost from the Item file is used. If the last cost is zero, the unit cost defaults to the standard cost. If the standard cost is zero, the unit cost defaults to the warehouse average cost. If the warehouse average cost is zero, the unit cost defaults to the item average cost.

Like the FIFO method, the actual cost associated with each unit received into inventory is recorded for each item. The receipt date, quantity received, and unit cost are recorded as a cost tier for the item. As items are sold, the most recent cost tier (with the latest receipt date) is used to determine the cost of goods sold, thereby matching the most current cost to the current revenue.

When all units associated with the most recent cost tier are sold, the next most recent cost tier is used. During period-end processing, all cost tiers with a zero balance are removed. There are no limits to the number of cost tiers that can be maintained for an item.

Using this method for items with low turnover rates (the quantity on hand is high compared to the quantity sold) results in an inventory valuation that differs significantly from the current purchase costs.

The quantity and cost associated with each lot is retained for each item. In addition, a lot identification number must be used whenever units are received or issued (sold) out of inventory. If more than one lot is involved in a receipt or issue, each lot number and quantity of the transaction must be entered.

Because the lot number is specified when units are sold, the cost of goods sold matches exactly the purchase cost of the items in the lot.

If the Sales Order module is installed, a detailed sales history of lot numbers can be produced if the Lot Items or Both Lot & Serial is selected in the Retain Lot/Serial Item Sales History field in Sales Order Options. This report includes the invoice number, invoice date, customer, and quantity sold.

Serial number costing differs from lot number costing in that only a single unit can be assigned to each serial number. If the Sales Order module is installed, a detailed sales history by serial number can be produced if Serial Items or Both Lot & Serial is selected in the Retain Lot/Serial Item Sales History field is selected in Sales Order Options. This report includes the invoice number, invoice date, customer, and quantity sold.  

Expand or collapse item  FIFO Valuation

The last cost from the Item file is used. If the last cost is zero, the unit cost defaults to the standard cost. If the standard cost is zero, the unit cost defaults to the warehouse average cost. If the warehouse average cost is zero, the unit cost defaults to the item average cost.

The First-In, First-Out method assumes the first units purchased (first in) are the first units issued (first out). This method is appropriate for businesses that value inventory based on the most recent purchases.

Unlike the Average Cost method, the FIFO method retains the actual cost associated with each unit received into inventory. The cost information for each receipt consists of the receipt date, quantity received, and unit cost, and is recorded as a cost tier for the item. As items are sold, the oldest cost tier (the cost tier with the oldest receipt date) is used to determine the cost of goods sold, thereby matching the oldest cost to the current revenue.

When all units in the oldest cost tier are sold, the next oldest cost tier is used. During period-end processing, all cost tiers with a zero balance are removed. There are no limits to the number of cost tiers that can be maintained for an item.

The Simple Moving Average method is used to calculate average cost and average cost per warehouse. Utilizing this method, a standard cost inventory item can generate a negative average cost if the actual item cost varies significantly from the standard cost.

A negative average cost or negative warehouse average cost should alert you of the possibility that the standard cost is not reflective of the actual costs. You should consider changing to another inventory costing method that more closely matches the characteristics of the inventory item or updating the item's standard cost to reflect current market costs.

The calculation of the average cost during a receipt update for a standard cost item is:

(Total cost of the warehouse quantity on hand + total cost of the quantity to be received) / (Total warehouse quantity on hand + total quantity to be received)

Note Total cost is figured using the standard cost. The average cost calculation for a standard cost item does not affect general ledger postings.

The simple moving average cost for a standard cost item is calculated as follows:

Item

11-12345

Standard Cost

$10.00

Quantity on Hand

10

Actual Dollar Value of Inventory

$100.00

Average Cost

$10.00

   

Receipt of 10 Units @

$15.00

Quantity on Hand

20

Actual Dollar Value of Inventory

$250.00

Average Cost

$12.50

   

Sales of 10 Units

(sale price irrelevant)

Quantity on Hand

10

Actual Dollar Value of Inventory

$150.00

Average Cost

$15.00

   

Receipt of 10 Units @

$1.00

Quantity on Hand

20

Actual Dollar Value of Inventory

$160.00

Average Cost

$8.00

   

Sales of 18 Units

(sale price irrelevant)

Quantity on Hand

2

Actual Dollar Value of Inventory

-$20.00

Average Cost

-$10.00

   

The receipt of 10 items at an actual cost of $1.00 is significantly less than the standard cost of $10.00.

 

Expand or collapse item LIFO/FIFO/Lot/Serial Valuation

The last cost from the Item Cost file is used. If the last cost is zero, the unit cost defaults to the standard cost. If the standard cost is zero, the unit cost defaults to the warehouse average cost. If the warehouse average cost is zero, the unit cost defaults to the item average cost.

For more information, see:

Calculating Extension Amounts

Vendor Price Level Maintenance

 

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks