Whether you’re a manufacturer or distributor, inventory is the currency of doing business.
Inventory is closely linked to cash flow. Simply put, the less inventory you have sitting in the warehouse the more cash you can have sitting in the bank. This must be balanced with the difficult to measure metric of how many sales could be lost because of insufficient inventory.
You don’t want to have old, out of date inventory or too much inventory, and you need to be able to replenish the inventory in a timely and efficient manner. You need to be able to understand and manage the costs of your inventory. Controlling the costs at source can improve your margins without needing to raise sales prices and becoming uncompetitive in the marketplace.
To achieve this goal, you need the visibility, flexibility and control delivered through a fully integrated ERP (Enterprise Resource Planning) system, that can manage the inventory from procurement through manufacturing to delivery to the customer, giving visibility of quantity and cost at all stages.
The Right Product
The first step in inventory management is making sure that you have the right product and in the right quantities. This may not be as simple as it sounds. Different manufactured products may have similar but different components, you may have controlled versions of various manufactured products, and products may be managed and/or stocked in a variety of units of measure.
The starting point for getting the product right is Sage X3’s
Product Record, providing full details of each unique product, and the variety of units of measure that it can be transacted in. Within Sage X3 you can manage separate units for stock, sales and purchasing, along with a variety of packing units; all with conversion factors, with 6 decimal places of conversion possible per unit. This will ensure that you communicate with both your suppliers and customers in a unit of measure that is correct and convenient to them, thus avoiding mistakes and incorrect deliveries.
If the product is a manufactured or subcontracted product it will have a Bill of Materials (BOM) listing the components that are required either by the manufacturing process or that need to be sent to a subcontractor. It’s also not unusual for the design of a product to evolve during its lifetime and to manage this, the standard functionality of Sage X3 Version Control can be used; managing and enforcing the versions and revisions to the product.
Using demand forecasts, sales orders and inventory shortages as inputs, aligned to the correct version of a product BOM, Sage X3’s comprehensive Materials Resource Planning (MRP) process can be utilised to calculate the quantities required to be manufactured or purchased to maintain the correct/required quantities of the desired products. Using detailed parameterisation such as Economic Order quantities and Safety Stock quantities, the system will ensure that the right quantity of inventory is delivered.
Getting the inventory to your warehouse is only the first stage of efficient inventory management. Utilising pallet management, barcode scanning and labelling, along with location management and system-driven replenishment, you can be sure that not only is the product delivered to your warehouse in the right quantities, but it is also stored, picked, and despatched in the right quantities too.
The Right Time
There is no point in just getting the right number of products delivered if it is delivered too late, or even too early, enforcing an increase in the inventory holding cost and causing problems in the warehouse with lack of storage space.
Sage X3 can help you in multiple ways to get the right product at the right time; including lead times for all products and suppliers. To assist further with the calculation of precisely when orders for materials need to be placed, materials and manufacturing operations are linked together; ensuring that orders are placed with a delivery date that is “Just In Time” for when the materials are required on the shop floor.
Furthermore, the MRP process, each time it is run, will continue to monitor the outstanding purchase orders advising of required adjustments to dates in the case of the inevitable movement in demand.
The Right Cost
Getting the right product into the warehouse at the right time, or for manufacturers making it in the first place, is a waste of effort if it is going to be too expensive to sell and make a reasonable margin on. You are, after all, in business to at least make some profit! Keeping tabs on the various costs is therefore an essential part of inventory management. These are both the price paid to the supplier, and less obvious costs such as freight, duty and warehousing/administration overheads.
Getting the right cost starts with managing supplier prices; using the comprehensive pricing engine in Sage X3 to ensure that the correct price is calculated on the purchase order, thus avoiding any nasty surprises when the supplier’s invoice is received.
Furthermore “landed costs” can be calculated as part of the receipt costs making allowances and accounting entries for such things as freight and duty. In addition, cost prices can include complex overheads that can recover the normally hidden administrative costs at the point of receipt.
The costs incurred in manufacturing processes also require careful control as no matter how good the purchasing team are, margins can be won and lost in the efficiency of the manufacturing process. Using the cost analysis tools provided as standard with Sage X3 you can compare what was planned to what actually happened on the shop-floor at a cost level; giving you detailed insight into any issues, and allowing you to take any remedial action to improve the productivity and hence future margins too.
For every movement of inventory into or out of the business there is a financial impact. It is therefore vital that the correct costing methodology is chosen to reflect the most accurate overall value. Sage X3 can value inventory in several ways, including standard cost, average cost, or FIFO cost; with comprehensive tools to analyse and ‘create’ the costs. Every inventory movement is valued and updated real-time into the balance sheet and financials.
No one said that managing a supply chain would be easy, but correctly managed inventory can be a massive boost to a business in terms of both increased sales due to better availability and better supported margins from correct costs.
The importance of Right Product, Right Time, Right Cost cannot be understated, and with the support of Sage X3’s suite of sophisticated tools, the task of effectively managing Operations may have just got a little easier; and with all of this reflected real time in the financials, even the Finance head’s job suddenly got a little easier too.
Right Product – Right Quantity, Right Version
Right Time – On Time, Just in Time
Right Cost – Right Price, Right Margin
All in REAL TIME
To find out more about how Sage X3 can help you with your inventory, contact us today to organise a demo.
How customers manage change with Sage X3
Posted on May 24, 2022
Change is a constant and as we explored in our ‘Business in a changing world’ whitepaper, the speed of change has increased over the past decades. This increases the pressure on organisations to manage...
Are you ready for Enterprise Resource Planning (ERP)?
Posted on April 20, 2022
The pains of ineffective processes and software in business are fairly universally felt, but as each company is unique, there isn't an exact guideline that can be written to determine whether you are ready...
Global Sage X3 implementation – lessons learned
Posted on April 6, 2022
The fact that Sage X3 is a truly global ERP system doesn’t automatically guarantee a successful international deployment. In this blog we share some of the lessons we’ve learned during Inixion’s...
Considerations for ERP selection
Posted on April 6, 2022
Selecting and implementing a new ERP system is an expensive proposition. A project like this doesn’t just involve the cost of the software but is resource and time hungry and carries multiple risks to...
What is ERP and why does my business need it?
Posted on March 31, 2022
Even in these days of tech-driven insights and hybrid working patterns, some businesses are still relying on pen and paper, spreadsheets and filing cabinets for essential corporate processes and information....
Staff absences don’t have to mean business stops
Posted on March 17, 2022
After the initial shock of the sudden lockdown in March 2020, followed by supply chain and other challenges and the subsequent need to figure out new ways of working, most business leaders had hoped things...
Happy Groundhog Day
Posted on February 2, 2022
For our customers in the UK and the rest of the world, yes, Groundhog Day is a real thing in North America. It’s actually a brilliant example of how something that’s folklore can become famous and...
The Year Ahead in Business Process: ERP Predictions for 2022
Posted on January 20, 2022
This time last year, much of the business world was hopeful that 2021 would be a smoother, less fraught year for trading. But then Covid-19 reared its head again, supply chains continued to be hit by issues...
Visibility across your business drives performance
Posted on January 12, 2022
Having the right Enterprise Resource Planning (ERP) system to help manage your business in a constantly changing environment; will provide visibility across your business allowing you to make informed...
From solo venture to Sage X3 powerhouse: celebrating 15 years of Inixion
Posted on December 1, 2021
As Inixion turns 15, we look back on a decade-and-a-half of gold standard work and glance forward to where the ERP market might be heading. Many years ago, Inixion founder Ian Bromley took a trip to...
Sage celebrates 40 years – Inixion team reminisces
Posted on July 21, 2021
Sage celebrates 40 years of delivering financial and ERP software this year. We asked our team to share their personal memories of Sage. Enjoy reading them and hopefully these memories will trigger some...