To run your business effectively, you should always have on hand the items that your customers are demanding. But it’s not financially feasible (and often, not even possible) to overstack every single item you offer within the inventory. So, it’s your job to determine a healthy inventory level to best serve customers while keeping your bottom line low.
To figure out the “sweet spot” for your inventory levels, there are tons of computations and accounting principles that you can apply to your business. One of the most common and perhaps most important aspects here is computing your average costs. Further, one of the ways you can do this is by using a figure called the moving average cost.
Here, we’ll explain
- what the moving average cost is
- how you can calculate it
- and why it’s important to your business
Moving Average Cost Definition
“Moving average cost” is sometimes referred to as the “moving average inventory method.” Accountingtools.com provides the following definition: “Under the moving average inventory method, the average cost of each inventory item in stock is recalculated after every inventory purchase. This method tends to yield inventory valuations and cost of goods sold results that are in between those derived under the first-in, first-out (FIFO) method and the last-in, first-out (LIFO) method. This averaging approach yields a safe and conservative financial result.”
In layman’s terms, the average unit cost of an item is recalculated every time an item is purchased. This process is ongoing since there are never-ending purchases and sales going on throughout the year. It also provides a safer estimate of cost as opposed to the FIFO or LIFO methods.
Calculating Moving Average Cost
Many businesses turn to a program or calculator that can automatically come up with your moving average cost. The formula behind these programs is as follows:
Unit Cost = (Total Cost After Purchase) / (Total Quantity After Purchase)
From there, we can break down the formula even further. You would start by adding your old quantity and your purchase quantity to come up with a figure for your new quantity. Then, in the same fashion, you would add your old value and your purchase value to come up with your new value. Finally, calculating the new value divided by the new quantity would give you the new price.
Let’s say that you run a candle company and you want to figure out your moving average cost. You currently have 300 units that each cost $5, which equals a beginning inventory of $1,500. You then purchase 100 extra candles at the start of the month. However, when you make your purchase, you find the price has increased from $5 to $8. So, your purchase of 100 candles at $8 per piece comes out to a new purchase amount of $800.
For the purposes of this example, we’ll say that you had no sales for this accounting period. Your new quantity would come out to 400 (300 + 100), new value would come out to $2,300 ($1,500 + $800), and your new price would come out to $5.75 ($2,300/400). So, in this scenario, the moving average cost of your candles increased from $5 to $5.75.
As we mentioned, this example maintained that your company had no sales during this time. However, if we do add sales into the equation, it gets a bit more complicated. Let’s continue with the same example.
Let’s say that, before you make any additional purchases for your company, you sell an average of 40 units at $5 each, leading to a cost of goods sold (COGS) of $200. The 40 units that you sold come out of your original stock of 300, leaving you with 260 units in stock with a value of $1,300 (since each unit is worth $5).
Later, you make your purchase of 100 extra units at $8 each. This purchase value comes out to $800, and when you add it to your previous inventory value of $1,300, you get a new value of $2,100. Since you’ve purchased 100 new units, adding to the 260 units in stock, you also have a new quantity of 360 units. Therefore, your new moving average cost is calculated as follows:
$2,100 / 360 = $5.83.
But since moving average cost is a perpetual process, it doesn’t stop there. Let’s say you go on to sell an additional 50 items, leaving 310 units in stock as your new quantity. We’ve got a new moving average cost of $5.83. When we multiply that by the 50 items we’ve just sold, it comes out to a new COGS of $291.50. Every time there’s a price increase, extra purchase, or sale, the average moving cost would be updated, allowing you to more accurately calculate your COGS.
Why is Moving Average Cost Important?
With all of that said and done, why is it even important to calculate your moving average cost? There are a few reasons why this figure is important for your business.
Make Sell-in-Bulk Easy
First, one of the main focuses of your business is to sell the products on hand and reduce your stock. Counting items individually can be quite easy, but if you sell items in bulk, the process gets much harder. It would be easy to calculate how many candles do you have on hand. However, imagine if you sell gasoline, it can be a lot harder to keep an accurate inventory.
Things that are sold in bulk make it virtually impossible to differentiate between old and new stock. Often, new deliveries will have different prices from the old ones. Without calculating your moving average cost, you may not have an accurate picture of your cost of goods sold.
More Accurate Sales & Inventory Reports
Being able to accurately determine your moving average cost is vital when it comes to sales and inventory reports. Every sale changes depending on how many items you have in stock and how much it costs to get them. Without an accurate picture at all times, your sales and inventory reports might be off. It can also give you a wrong idea of your overall financial standing.
Be in a Good Financial Position
Your moving average cost can be used when working out your net sales and comparing it with your cost of goods sold, giving you a more accurate gross profit computation. You can also use it when you’re recording your inventory to help you compute your assets. Though the process of calculating your moving average cost might sound complicated, it’s actually an important step to determining the most current price of any given item and helping your business stay in a good financial position at all times.
Automate Your Calculations
As you can see from our example above, calculating your moving average cost manually will prove next to impossible, especially as your business keeps growing. It can be incredibly time-consuming and complicated. With so many numbers involved and so frequently you will have to make the calculation, the potential for human error is incredibly high. One misstep could lead to a disaster of your entire calculation. If the error is not identified and you’ve already made several more purchases, there’s no telling how much time you have to spend going back and correcting the mistake.
Luckily, there are many online calculators that can handle all of these numbers for you. Not only are they the most accurate way to ensure that you’ve got the right moving average cost, but they will save you unimaginable amounts of time and money. Instead of having to slave away over the numbers after every purchase, you can simply open up your program to see what your moving average cost or cost of goods sold is at any given time.
Use Inventory Tracking Software
Using inventory tracking software can provide many more benefits on top of calculating your moving average cost. The software can help you monitor your inventory as it comes in and goes out in real-time, generate accurate reports that can help you forecast future demand, and optimize your stock levels to ensure that you never have too much or too little of any certain item.
Level Up Your Business With DEAR Systems
Technologies like inventory tracking software can be huge assets to the daily performance and future growth of your business. To ensure that you always have the most accurate information and can access it all in one convenient place, consider investing in a cloud ERP software like that available from DEAR Systems. They have designed the software to help you with virtually every aspect of your business, from inventory management and manufacturing to sales, accounting, purchasing, e-commerce, and more.
Not only will you have the benefits of DEAR cloud ERP, but also our (INNO) dedicated team of experts by your side every step of the way. We can help you customize your software together with DEAR to best meet your needs, integrate with other programs that you’re already using, and always ensure that your business is running as smoothly and efficiently as possible.
DEAR started in Australia and has now created the #1 rated cloud ERP software in the United States. It also activaly serves clients from over 78 countries. Your business has truly no limit when every aspect is integrated into a top-notch ERP software.
Exciting news is DEAR landed in China in early 2020 and have supported many small business owners to achieve successful digitization. For China users, DEAR Systems has not only localized the language, the server and also accounting functions for being in compliance with China regulations and formats. Contact Us today to learn more or to Get Free 14-day Access.
INNO is the first official partner of DEAR Systems in China. We care about data accuracy and efficiency since they are the key for businesses navigating the change of the market. Having developed a unique approach to software implementation, training and ongoing monitoring, we take clients through the beginning stage smoothly, so they can quickly pick the new software up. We believe it is essential to build up trust and empower staff and management to make well-informed decisions about the business with the help of powerful software.
INNO founder Jano Tse has 12 years of experience in implementing ERP systems for foreign and local SMEs. He also specializes in the accounting process under China’s business environment. Jano’s passion for disciplined delivery and methods for meeting goals on time and under budget is exactly what INNO brings to each of the clients.
3 essential elements driving the success of ERP projects:
- Assessment and software selection
- Software implementation
- Customized integration
- On-going monitoring and support
- Outsourcing of virtual CFO and cloud accountants
This article was originally posted at Dear Systems.