Decoding inventory costing: Navigating SKU pricing, freight, and duty in e-commerce

Article

Unlocking true product costs: The importance of accurate landed costs in e-commerce profitability.

Introduction

In the dynamic realm of e-commerce, understanding the true cost of inventory is crucial. It's not just about purchase prices; it's about capturing every expense associated with bringing a product to sale. From freight charges to duty costs, they’re all relevant to understand margin. Dive into the world of inventory costing and discover its significance in shaping accurate profit margins.

A brief background: What is cost accounting?

Cost accounting is the method of capturing all costs incurred in producing a product. In e-commerce, it's the backbone of pricing strategies, profitability analyses, and financial planning. By accurately determining the cost of inventory, businesses can set competitive prices, offer strategic discounts, and ensure healthy profit margins.

Overview of costing methods

In the world of inventory management, the method chosen to value inventory plays a pivotal role in financial reporting and decision-making. Different costing methods provide varied perspectives on inventory value and cost of goods sold, each with its own set of advantages depending on market conditions and business strategy. FIFO is included as an example, but it’s not permissible under UK FRS102.

Let’s assume we have the following 4 purchase orders that make up our inventory balance.

 

Units 

Unit price (£) 

Total (£) 

Purchase order 1 

100,000 

5.00 

500,000 

Purchase order 2 

100,000 

4.50 

450,000 

Purchase order 3 

100,000 

4.00 

400,000 

Purchase order 4 

100,000 

4.25 

425,000 

TOTAL INVENTORY 

400,000 

 

1,775,000 


The average cost of all of the above inventory is £4.44 per unit (£1,775,000 / 400,000 units).

AVCO (Average Cost method)

This method averages out the costs of inventory over time, providing a balanced cost per unit. It's particularly useful when inventory costs fluctuate frequently, offering a smoothed-out cost perspective.

 

Units 

Unit price (£) 

Total (£) 

ORIGINAL INVENTORY 

400,000 

 

1,775,000 

Sold (and cost of goods sold) 

(200,000) 

4.44 

(887,500) 

UPDATED INVENTORY 

200,000 

 

887,500 

LIFO (Last-In, First-Out)

Here, the latest inventory purchased is the first to be sold. It's particularly useful when inventory costs are rising, as it can lead to higher cost of goods sold (COGS) and lower taxable income.

 

Units 

Unit price (£) 

Total (£) 

ORIGINAL INVENTORY 

400,000 

 

1,775,000 

Sold (and cost of goods sold) 

(100,000) 

4.25 

(425,000) 

Sold (and cost of goods sold) 

(100,000) 

4.00 

(400,000) 

INVENTORY 

200,000 

 

950,000 

FIFO (First-In, First-Out)

The oldest inventory items are sold first. This method is beneficial when prices are stable or declining, as it can result in lower COGS and higher taxable income.

 

Units 

Unit price (£) 

Total (£) 

ORIGINAL INVENTORY 

400,000 

 

1,775,000 

Sold (and cost of goods sold) 

(100,000) 

5.00 

(500,000) 

Sold (and cost of goods sold) 

(100,000) 

4.50 

(450,000) 

INVENTORY 

200,000 

 

825,000 

These three different ways to calculate inventory have both a material impact on inventory and cost of sales. Now, if we assume a consistent sales price across each method of £10 per unit, you can see how the margin fluctuates because of the various input costs. If these costing methods were applied inconsistently, there would be a lack of transparency and clear understanding of gross margin and performance.

 

AVCO (£) 

LIFO (£) 

FIFO (£) 

Revenue 

2,000,000 

2,000,000 

2,000,000 

Cost of goods sold 

(887,500) 

(825,000) 

(950,000) 

Gross margin 

1,112,500 

1,175,000 

1,050,000 

Gross margin (%) 

56% 

59% 

53% 

These various methods lead to different gross margin and ultimately EBITDA numbers. The above is a very simplified example, but in reality, these inventory “in and out” transactions for any e-commerce business would be extremely high and hard to manually keep up with in a spreadsheet.

Top tip: Regularly review your costing method, especially if your business undergoes significant changes, like expanding product lines or entering new markets.

Spreadsheet v technology: The right tools for accurate costing

While spreadsheets might seem like a simple solution, they can be prone to errors, especially in dynamic e-commerce environments. Modern inventory management systems offer automation, real-time updates, and integration capabilities, making sure accurate and efficient cost accounting. By leveraging technology, businesses can make sure that their costing remains consistent, factoring in variables and offering a clear picture of product profitability.

Top tip: Invest in a robust inventory management system that integrates with your e-commerce platform, ensuring seamless data flow and accurate costing.

The significance of accurate costing

Understanding the true cost of inventory is pivotal for various reasons. It influences pricing strategies, impacts profitability, and informs inventory purchasing decisions. Moreover, accurate costing ensures that businesses can navigate market fluctuations, respond to competitive pressures, and cater to customer demands effectively.

Top tip: Schedule regular audits of your inventory costs, ensuring that all associated expenses are captured and that your pricing strategies remain competitive.

Landed costs: Beyond the purchase price

In e-commerce, understanding the full cost of a product is essential. It's not just about the initial purchase price; it's about every associated cost that comes with getting that product into your warehouse and ready for sale. Landed costs are the total costs associated with getting a product ready for sale, including purchase price, freight, insurance, and any customs duties.

By factoring in all associated costs, businesses can accurately determine their product margins, making sure they price products profitably. Correctly capturing these in your cost of goods sold, means you have an understanding of your true product margin.

Common pitfalls in inventory costing

Mistakes in inventory costing can have ripple effects. Common errors include charging inventory directly to the P&L, which can distort profit figures, or incorrectly categorising expenses, leading to inaccurate product costs. Regular reviews and reconciliations, coupled with robust inventory management systems, can help mitigate these errors.

Conclusion

Inventory costing isn't just a financial exercise; it's a strategic endeavour. By accurately capturing all costs associated with their products, e-commerce businesses position themselves for sustained success. In the competitive e-commerce landscape, understanding the nuances of inventory costing can be the difference between thriving and merely surviving.

Scale your e-commerce business while we run your smart finance function.

Sign up for our latest insights