How do you calculate FIFO cost per unit?
FIFO Costing Overview Show Purpose: There are three costing methods available: • Standard costing, in which you fix the cost for each item • Average costing, in which the system updates the cost to reflect the prices and quantities at purchase order receiving • FIFO costing, which is described below. The Costing Method (A25) system control value defines the costing method your company uses to track inventory valuation. What is FIFO costing? In simplest terms, FIFO (first-in, first-out) costing allows you to track the cost of an item/SKU based on its cost at purchase order receipt, and apply this cost against each shipment of the item until the receipt quantity is exhausted. The system determines the cost by creating a FIFO cost layer when you receive a purchase order, and selecting the oldest eligible FIFO cost layer when you ship an order. Example:You receive 10 units of an item at $10.00 each. Subsequently, you receive 20 units of the item at $12.00 each. Each creates a separate FIFO cost layer. When you next bill an order for two units of the item, the system valuates the inventory at $20.00 ($10.00 * 2), and reduces the quantity of the first FIFO cost layer to eight. In addition to purchase order receiving, several other inventory transactions may create FIFO cost layers. See Inventory Transactions and FIFO Updates. In this topic: • Item/Warehouse Level • Extended Transaction Costs • Changing To or From FIFO Costing • Inventory Transactions: Cost Selection and Updates • Basic Hierarchy • Guidelines for FIFO Costing Process • Purchase Order Number in Inventory Transactions • Inventory Transactions and FIFO Updates • Weighted Average FIFO Cost • If You Need to Change the Cost of a FIFO Layer • Inquiry and Reporting • Screen Differences Related to FIFO Costing Item/Warehouse Level The system tracks FIFO cost layers at the item/warehouse level for non-SKU’ed items, and the item/SKU/warehouse level for SKU’ed items. Regardless of the location where you store or pick stock, the system determines the FIFO stock layer to use for each transaction by the same hierarchy based on the age of the FIFO layer. Example:You receive 10 units of an item at $10.00 each, and store them in location BULK. Subsequently, you receive 20 units of the item at $12.00 each, and store them in location PRIMARY. When you next bill an order for two units of the item, the system selects the first FIFO cost layer of 10 units at $10.00, even though you picked the inventory out of location PRIMARY. Transfers within a warehouse: Because you track FIFO cost at the warehouse level, transfers of stock within a warehouse will not cause any change to the FIFO stock layers; however, a transfer from one warehouse to another will decrease the FIFO layer for the “from” warehouse and create a new FIFO layer for the “to” warehouse. Example:When you transfer eight units of an item from location BULK to location PRIMARY in your main warehouse, there is no change to the FIFO cost layers for this item. Subsequently, you transfer five units from location PRIMARY in your main warehouse to a location in a secondary warehouse. In this case, the system reduces the FIFO cost layer in the main warehouse from eight units to three, and creates a new FIFO cost layer in the secondary warehouse for five units. Extended Transaction Costs When you use average or standard costing, the cost of a transaction is tracked at the per-unit level, since each unit will always have the same cost. When you use FIFO costing, however, it is possible for a transaction to derive its cost from multiple FIFO layers. For this reason, transaction costs are represented as extended amounts when you use FIFO costing. Example:You bill 10 units of an item. The first available FIFO cost layer has an on-hand quantity of five units at a cost of $10.00 each. The next available FIFO layer has 20 units at $11.00 each. The system uses an extended cost of $105.00 for the billing transaction (5 @ $10.00, or $50.00, and 5 @ $11.00, or $55.00). The system uses related detail tables to track the different costs that make up the extended cost for each transaction. See Inventory Transactions: Cost Selection and Updates. Changing To or From FIFO Costing Difference from other system control values: To change most system control values, you can select Change for the value through Work with System Values/Features to advance to the Change System Control Value screen. However, you cannot change the Costing Method (A25)system control value this way if your change involves moving to or from FIFO costing. Instead, you must use the Work with FIFO Cost Conversion menu option to change your costing method. Note:If you are first setting up a new company, you can change to FIFO costing without running the conversion program; however, if there has been any inventory activity in the new company, you must run the conversion. Why is conversion necessary? You need to run the conversion program when you change to FIFO from another costing method because you must build the records the system needs for FIFO cost tracking. These records include the FIFO cost layers, and inventory and invoice cost detail. Also, the system changes transaction cost tracking from a per-unit to an extended amount, as described under Extended Transaction Costs. Similarly, if you transfer from FIFO to another costing method, the system deletes the FIFO cost layers and related detail records and converts back to unit costs appropriately. Note:You can change between AVERAGE and STANDARD costing using the Change System Control Value screen. It is not necessary to run a conversion. See Working with FIFO Cost Conversion (WFCV) for more information on converting to or from FIFO costing. Inventory Transactions: Cost Selection and Updates Purpose: The key to understanding FIFO costing is to review the logic the system uses when it selects a cost for each inventory transaction. The updates the system makes are also important to understanding the process. Basic Hierarchy The system uses the following hierarchy to determine the cost to use for inventory transactions: 1. Use the cost from the oldest open FIFO cost layer for the item/SKU/warehouse. 2. If there are no open FIFO cost layers for the item/SKU/warehouse, use the cost from the most recently closed FIFO cost layer. 3. If there are no FIFO cost layers, open or closed, use the Last purchase cost from the SKU table. The system uses a slightly different hierarchy for an adjustment or vendor charge back if you specify a purchase order number for the transaction. See Purchase Order Number in Inventory Transactions. Additionally, transactions that represent a reversal of a previous transaction, such as a vendor charge back reversal or a customer return, do not generally follow the standard hierarchy. See Inventory Transactions and FIFO Updates. Guidelines for FIFO Costing Process When the system processes an interactive or automatic inventory transaction, it performs the following steps: • Selects one or more FIFO layers using the above hierarchy, and uses the appropriate cost(s) for all table updates described below. • Updates the FIFO layer(s) appropriately. Decreases in inventory, such as issues, lower the on-hand quantity for the FIFO layer; when the on-hand quantity reaches zero, the FIFO layer’s status changes to closed (X). Increases in inventory, such as purchase order receipts and customer returns, create new FIFO layers. • If there is a discrepancy between the on-hand quantities for the FIFO layers and the item/warehouse and/or item/location, the system creates an inventory transaction error. You can review these errors through Working with Inventory Transaction Errors (WITE). Purchase Order Number in Inventory Transactions You can enter a purchase order number for an inventory transaction in Work with Inventory Transactions (batch or immediate) for adjustment transactions only. Similarly, you can enter a purchase order number for a vendor charge back. When you specify a purchase order number, the system uses the following costing hierarchy: 1. Use the cost from the oldest open FIFO cost layer for item/SKU/warehouse associated with this purchase order. 2. If there are no open FIFO cost layers for the item/SKU/warehouse that are associated with this purchase order number, use the cost from the most recently closed FIFO cost layer that is associated with this purchase order number. 3. If there are no FIFO cost layers, open or closed, use the Last purchase cost from the SKU table. Inventory Transactions and FIFO Updates
User-defined transaction codes: Any additional transaction codes you have set up in your company will create a new FIFO layer if they increase inventory, or decrease the totals for a FIFO layer if they decrease inventory. See the A (adjustment) transaction described above for more information. Excluded transaction codes: The system does not allow you to enter O (on-hand) and G (item-to-item transfer) transactions when you use FIFO costing. Weighted Average FIFO Cost Purpose: The system updates the weighted average FIFO cost for inquiry and reporting purposes (for example, the FIFO Activity Report lists this cost). The weighted average FIFO cost is stored in the FIFO cost field in the SKU table. This cost is calculated by dividing the total extended cost of all FIFO layers for an item or SKU by the item/SKU’s total on-hand quantity. Note that this cost includes all warehouses where you keep the item. If this calculation would produce a weighted average FIFO cost of zero, the system uses the SKU’s Last purchase cost. If You Need to Change the Cost of a FIFO Layer Purpose: You can change the cost associated with a FIFO layer if it was created incorrectly. To correct a FIFO layer’s cost, select Change for the layer at the Work with FIFO Cost Layers Screen. When you change the cost, the system updates the unit and extended cost for the FIFO layers, and posts the increase or decrease in inventory valuation to the General Ledger Interface table. * inventory transaction code: Before you can change the cost of a FIFO layer, you must first create a “*” inventory transaction code. The system uses this code for changes in inventory valuation which do not affect the on-hand quantity of an item. You can review any * inventory transaction through Display Inventory Transaction History (DITH), or you can review the * transactions for a particular FIFO layer through Using FIFO Cost Layer Inquiry (WFCF). Inquiry and Reporting Purpose: The following menu options, screens and reports are available for you to review the FIFO cost layers that make up your inventory and transactions. • Using FIFO Cost Layer Inquiry (WFCF): Use this menu option to review the FIFO layers in your company and their history, or to change the cost of a FIFO layer. • Invoice Cost Detail Screen: Use this screen to review the FIFO layers that make up the cost of an item on an invoice or credit invoice. You can display this screen by selecting FIFO cost history for an item at the Display Invoice Detail screen in standard order inquiry (fast path = OIOM). • FIFO Stock Aging Report by Item or FIFO Stock Aging Report by Warehouse: Use this report to review the age of inventory based on the date when each FIFO cost layer was created. • FIFO Activity Report by Item or FIFO Activity Report by Warehouse: Use this report to review all transaction activity against FIFO cost layers. Reporting differences: If you use FIFO costing, you cannot review cost variance for individual item/locations, because the unit cost may not the same for all units of an item within a location. For this reason, the system produces two different versions of the evaluation report: • Physical Evaluation Variance Report by Unit Variance: provides variance information at the item/location level, but cost information is omitted • Physical Evaluation Variance Report by Item Warehouse:provides the total cost variances based on the total of all selected FIFO layers. Screen Differences Related to FIFO Costing Purpose: Screens that display the cost of an item, such as the Inventory Transaction History Screen (2 of 2) in Display Inventory Transaction History (fast path = DITH), display the extended cost rather than the unit cost if you use FIFO costing. Cost override field: The Cost override field on the Work with Order Line screen in order entry and order maintenance is not enterable when you are using FIFO costing. This restriction is in place to maintain the integrity of the FIFO costing method and to keep inventory information in sync with the FIFO layers for your company. Vendor charge back: The Cost field is display-only on the Vendor Charge Back Detail screen if you use FIFO costing. Also, the system splits any detail line on a vendor charge back that derives its cost from more than one FIFO layer. How do you find the unit cost of FIFO?To calculate FIFO (First-In, First Out) determine the cost of your oldest inventory and multiply that cost by the amount of inventory sold, whereas to calculate LIFO (Last-in, First-Out) determine the cost of your most recent inventory and multiply it by the amount of inventory sold.
What is FIFO method with example?The FIFO method requires that what comes in first goes out first. For example, if a batch of 1,000 items gets manufactured in the first week of a month, and another batch of 1,000 in the second week, then the batch produced first gets sold first. The logic behind the FIFO method is to avoid obsolescence of inventory.
How is FIFO process costing?Under the FIFO method of process costing, costs are transferred to next department and ultimately to finished goods in the order in which they entered the current department i.e. costs entering first are transferred first and hence the name FIFO–first-in-first-out.
What are the steps for FIFO?The FIFO procedure follows 5 simple steps:
Locate products with the soonest best before or use-by dates. Remove items that are past these dates or are damaged. Place items with the soonest dates at the front. Stock new items behind the front stock; those with the latest dates should be at the back.
|