This is the most commonly used costing method. With this method, the average cost is assigned to each inventory piece when it’s sold throughout the year.
The average cost is calculated after each purchase with the next formula: Average cost (purchase price) = Old inventory value + landing cost / Old inventory quantity + landing cost Where the inventory value = purchase price + landing cost
The average cost contains your purchase price plus the shipping, handling, etc. (landing cost)
Susan has a bike store. She uses the weighted average method to run her inventory costs. If she purchases a bike on the 1st of March for $70, with $10 shipping, her average purchase price for the bike will be $80. On 9th of March, she purchases a bike from a different supplier for $50 and $10 shipping, her stock price will now be $70. Purchase cost balance = $80 + $60 = $140, divided by 2 pcs = $70
Upon making the sale, the $70 cost will be assigned to the bike:
As the inventory purchase price changes over time, so will the stock price (average purchase price).
ERPAG uses a perpetual inventory costing method in inventory transactions, which means that it updates the stock price (weighted average price) after each purchase.
FIFO (First In First Out)
The FIFO method means that the inventory that is first physically acquired will be charged to expenses account. Therefore, for this reason, the inventory items that were first bought they are sold first as well, and the remaining stock items at the end of the period are those that were last purchased or manufactured.
The FIFO inventory method is actually based on the physical flow of inputs or inventories without taking into account the price of these inventories and whether these inventories will be consumed in that order.
Karen also has a bike store, and she purchased 4 bikes on Monday at $70 each, and she purchased 2 bikes on Tuesday at $75 each (Jesus Karen, always buy in bulk when you find a great deal!). Mike comes in and purchases a bike. Even though he bought a bike that Karen paid $75, she will assign the cost of $70, because she is calculating her inventory costing by FIFO method. Her inventory stock amount will be $360.
The result that will arise by applying this method, expressed through the amount of expense and inventory at the end of the period, depends on whether or not the cost of inventories increases.
If it is assumed that it’s a sale of finished products, the effects of applying the FIFO method will affect the amount of cost sold and the value of the inventory that will be in stock at the end of the period.
LIFO (Last In First Out)
The LIFO inventory method means that the last purchased inventory item is sold first, and the remaining stock items at the end of the period are those items that were first purchased or manufactured.
Same as with the FIFO method, the LIFO inventory method is based on the physical flow, the input, ie the inventory, regardless of the price level of these inventories and regardless of whether the inventories are actually consumed in that order.
In this case, Karen will sell to Mike the bike that she purchased for $75.
The result that will occur by applying the LIFO method expressed through the level of costs or expense and inventory at the end of the period, will depend on whether the cost of inventories increases or decreases.
This method is used when you can track individual items of your inventory. Whether it’s through the serial number, or a barcode, or a QR tag. If you can distinguish each item in your inventory, you can track the cost of each and one of them through an accounting system, or even a simple XLS table. The point of the specific identification method is to track the cost of each item sold.
If Susan shifts to this costing method and purchases bikes in June for $65, and for $70 in July and puts QR codes on each one of them. Upon each sale, she will be able to identify the cost of the sold bike.
This sounds like the best option to track the cost of your inventory, but it’s also very time-consuming method, and it’s more suitable for items of high-value. And since Susan & Karen are super busy bike-shop owners, they need to rely on FIFO or weighted average, or, at the last spot – LIFO costing
method, if they want the procurement, inventory stocking, sales, and cost assignment to be done asap.
ERPAG as one of the ERP and MRP business software solutions offers Weighted average and FIFO as inventory costing methods. Due to opinion collision, we incorporated the 2 most used costing methods, and we give you a full ability to choose by which method you will run the warehouse. Once you assign it to your warehouse and start creating documents, we are stripping down that ability from you and tying your hands and you won’t be able to change the costing method anymore. So make a wise choice. At least, with ERPAG, you have such a possibility.
Here are a couple of essential steps which can help you with your movement in ERPAG. Clean database If you want to start fresh, to remove your dummy data and start importing your own, you can do that by going to Administration > Database/Backup > Clean database...
If you are a novice in using software to help you with better tracking your inventory and production,and if you have ever wondered what kind of production types there are, this manual will help you to differentiate them! It is normal that based on your workflow you...
General information for working with QuickBooks in ERPAG: The user needs to have their own QuickBooks account already createdThe QuickBooks company that the user wants to connect with ERPAG needs to be created as any country supported by QuickBooks Online. QuickBooks...
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.