Posted on Leave a comment

e-Commerce Selling: How to calculate your Inventory Value

e-Commerce Selling: Calculating inventory

Calculating Inventory Value and Cost – The Importance

We all know the importance of holding the correct inventory levels in our business, ensuring we meet customer demand, yet minimising stock holding costs and risks of obsolesce. However, do you know the impact of ensuring you have inventory recorded at the correct value?

UK Accounting Standards (FRS 102) state that inventory must be held in the company records at the lower of cost and the estimated selling price less costs to complete and sell. But how do we calculate cost?

Many SME business’ value their inventory based on the most recent purchase invoice from their supplier as this is the easiest method, however, is this accurate and what about the valuation of work in progress?

Calculating the inventory “cost”

Below is a summary of what should make up the calculation of “cost” for each line of inventory

Cost of purchase must includeFurther comments
Purchase priceInventory should be recorded at the spot rate at the date of the transaction if purchased in a foreign currency.
Import duties and other taxesThese costs should be included unless recoverable from the relevant authorities.
Transport and carriage costsThese costs should be included to the extent that they are directly attributable to the purchase of inventory.
Trade discounts and rebatesAny trade discounts or rebates should be deducted from the cost amount.
Cost of conversion (work in progress) must include:Further comments
Costs directly related to converting raw materials into finished goodsFor example:
– Direct labour (to include: gross wages, employers NIC, pensions, employee benefits)
– Subcontractor costs
– Specific components
Variable production overheadsFor example:
– Indirect materials (adhesives, packaging etc.)
– Indirect labour (to include: gross wages, employers NIC, pensions, employee benefits)
Fixed production overheadsFor example:
– Depreciation of plant, equipment, factory buildings
– Maintenance of plant, equipment, factory buildings
– Factory management costs and administration

Once the cost has been established, there are several valuation methods permitted under UK accounting standards, which are:

  • Specific Identification – this method is used for inventory items that are one-off bespoke items or produced for specific projects.
  • FIFO (First items to enter the inventory are the first to be used)
  • Weighted average

Depending on the valuation basis used, it is clear from the above that you may end up with differing values for stock and work in progress. The impact of this difference on the financial statements is potentially significant and we have provided a worked example below to show the difference under both the FIFO and weighted average bases of valuing inventory:

Valuing Inventory Example

Best Products Limited holds 200 widgets at its year end of 31 December 2017. The company’s purchases and sales of stock in the year were as follows:

Date of transactionQuality of widgetsInvoice price per unitTotal cost
1/10/17Purchase150£2£300
1/11/17Purchase100£2.50£250
1/12/17Sold(50)£5
31/12/17200

Using the FIFO method of valuation, the stock would be valued at £450 at 31 December 2017 or £2.25 per unit [(150-50) x £2 + (100 x £2.50)].

Using the weighted average method, the stock would be valued at £440 at 31 December 2017 or £2.20 per unit [(150 x £2) + (100 x £2.50)x 200/250].

Impact on profitability

If we consider the impact on profitability under the two scenarios:

Year end 31/12/2017FIFOAverage cost
Sales250250
Purchases500550
Less closing stock(450)(440)
Total purchases100110
Profit before tax150140
Gross profit margin60%56%
Tax (19%)(29)(27)
Profit after tax121113

As can be seen from the above, the gross profit margin is affected by the valuation method chosen, which in turn impacts upon profitability and the tax payable.