Average Costing Method Vs FIFO Costing Method Vs Sage ACCPAC ERP Costing Method

By | July 27, 2011

Well Average costing and FIFO costing has their own value, are equally important and have their own advantages. It depends on how they are used in various companies.

However here we shall understand the difference between Average costing method and FIFO costing method when they are used in business? Rather how do average and FiFO cost act in scenarios?

It would be illogical to state that one method is either simpler or more accurate than the other. The selection of method would entirely depend upon individual’s calculation as to what cost would give them appropriate cost of the product and give a proper profit margin on the sale.

The basic difference between the average costing and FIFO costing method is retention of cost when it is transferred to from one warehouse to another or sent for production or for consumption and so on.

Average cost would be cost of the [(total cost inventory lying in the location of the production floor or consumption department as on current date) divided by / ((total count of that inventory lying in the location of the production floor or consumption department as on current date)]. This average cost goes on changing whenever you add quantities or adjust cost in that location.

The FIFO method retains the inventory cost as a separate figure i.e. it holds the cost of the inventory as it is moving from 1 location to another, from 1 department to another. Every unit consumed/sold or purchased will retain its costs till you do not add/adjust costs to it Or in case of return of stocks from customer you specify different cost.

One should take care that If the FIFO method is used, inventory lost during a period must be identified from which bucket it is lost or else the complete value of FIFO costing would be lost. This would not be a case in Average Costing. Cause for Average costing it does not matter when it was purchased. It is concerned about the current value of the individual stock.

The other disadvantage of FIFO costing would be say there were 10 qty with different costs were sent to production/usage/consuming department with no proper tagging as to what cost is associated with which unit then it would be difficult for the production department to give you the exact cost of the consumed/finished product hence making it complicated for the management to decide the lot cost of the finished good or calculating cost of the consumed quantity. Under such scenarios, average costing method would lead to quite satisfactory cost computations.

One thing to note here is be it FIFO or Average cost, any back dated entry done in the system after the data entries have already been done for present would not give you appropriate results. This is where Sage has come up with a solution called Lot (Actual) costing. Using this costing method user will be able to select the lost from which the items have been consumed and the system would pick up the correct cost.

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, Salesforce.com and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrix, Document Attachment, Document Numbering, Auto-Bank Reconciliation, Purchase Approval System, Three way PO matching, Bill of Lading and VAT for Middle East.

For more details on Sage 300 and 300c Services, please contact us at accpac@greytrix.com. We will be glad to assist you.