HomeInsightsBlogThe importance of correct inventory valuation

Insights

Blog // 14/02/2018

The importance of correct inventory valuation

The importance of correct inventory valuation

Caroline Milton - Menzies AccountantWe 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 (FRS102) 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 include:Further 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 transactionQuantity 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

menzies

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.

If you would like any assistance with exploring the impact of your own valuation of inventory on the profitability of the business, please feel free to get in touch with Caroline Milton at cmilton@menzies.co.uk or call 01372 360130.

Print Friendly, PDF & Email


RELATED CONTENT
  • How competitive is the UK’s tax system in relation to others?

    Although the government is proud of the UK’s position with its most competitive tax system in the G20, initiatives such as the BEPS (Base Erosion and Profit Shifting) project, which has already been adopted by 124 countries, making it harder to stand out from the crowd. With tax becoming an increasingly important global topic, the […]

    Print Friendly, PDF & Email
    READ MORE >
  • Is your profit data misleading you? Part 1 – valuable insight

    Tim Dunn – Strategic Advisory Partner Developing good products and services is important, but it is not everything – commercially there are a number of pieces of the jigsaw that need to come together if a business is to achieve its potential and fulfil the owner’s dreams. Ultimately, profitability must be a key consideration – […]

    Print Friendly, PDF & Email
    READ MORE >
  • Is your profit data misleading you? Part 2 – applying to the business

    Tim Dunn – Strategic Advisory Partner In part one we examined the data challenges that face many SMEs and the power in defining what data you need and the difference between detailed analysis verses meaningful analysis. Now it’s time to consider what parts of your business you want to understand better. Stage 1 – define […]

    Print Friendly, PDF & Email
    READ MORE >