As savvy business owners and supply chain management enthusiasts, it's crucial to understand the ins and outs of inventory management, and finished goods inventory is no exception. In this comprehensive blog, we'll dive deep into the intricacies of the finished goods inventory formula, revealing the secrets behind calculating your stock like a pro.
Get ready to explore the world of finished goods produced formula, as we break down each step on how to calculate finished goods inventory, and ensure that your business remains efficient and cost-effective. But that's not all!
We'll also delve into the significance of inventory turnover and provide valuable insights to help you optimize your stock management. Whether you're an industry veteran or a newcomer, our easy-to-follow guide will equip you with the knowledge you need to excel in managing your finished goods inventory.
Here’s what accurately reported finished goods inventory helps you do:
- Reduce waste
- Determine profitability
- Optimize the inventory management process
Those are three very good things. And they all improve when you invest in tightening up your finished goods inventory process and reporting (see what is inventory).
So let’s get down to business. Here’s what finished goods inventory is, how to calculate it, and why it's one of the best types of inventory out there.
What Are Finished Goods?
Finished goods are the final products that manufacturers sell to buyers, such as upstream vendors or retailers. They are the culmination of raw materials and items in every stage of production. It’s also known as finished product inventory.
"Finished goods inventory", also known as "finished product inventory", is a term that can vary depending on the context.
One manufacturer's finished goods inventory may be a retailer's merchandise inventory, dropshipping inventory, or another manufacturer's raw material or component. The destination of these finished goods determines their classification after completion.
Becoming Finished Goods Inventory: The Journey from Raw Materials to Finished Goods Inventory
To better understand the finished goods produced formula, it's essential to grasp the entire manufacturing process. Finished goods inventory becomes finished goods inventory by first being the other two types of manufacturing inventory.
There are three main steps involved in transforming raw materials into finished goods inventory. Here’s how it all goes down:
Step 1: Raw Materials Inventory
Raw materials inventory is all the ingredients or base component parts that will be used in the production process. They’re considered raw materials inventory until they’re combined with human labor. At that point, the inventory is no longer raw. It’s been moved out of its initial warehousing environment and is now a work in procress.
Step 2: Work In Process Inventory
Work in process inventory (AKA work in progress or WIP inventory) is everything that happens to inventory in between raw materials and finished goods. This is when the actual manufacturing is happening.
There are some very short or simple manufacturing processes that don’t require specific reporting of WIP inventory. In those instances, companies move straight from raw materials inventory to finished goods inventory.
Step 3: Finished Goods Inventory
When the manufacturing process is finished, the work in process becomes a finished good. Finished goods inventory is what manufacturers depend on to generate revenue. Once finished, these goods can ship and it's time to focus on inventory tracking. Most of these goods are also assigned a SKU number.
How to Calculate Finished Goods Inventory
There are two types of finished goods inventories: one at the beginning of an accounting period and one at the end. Whenever anyone speaks about calculating finished goods inventory, they’re talking about ending finished goods inventory.
How to find finished goods inventory requires three piece of information:
- Beginning inventory of finished goods
- Cost of goods manufactured (COGM)
- Cost of goods sold (COGS)
All three of these are used in the finished goods inventory formula.
How to Calculate Beginning Inventory of Finished Goods
How to calculate beginning inventory of finished goods is the same as calculating ending finished goods. You just did it last accounting period.
That’s because beginning inventory of finished goods is the ending finished goods inventory from last period. If you’re calculating finished goods inventory regularly, determining beginning inventory of finished goods is typically as easy as looking at your past balance sheet.
So, how do you calculate finished goods inventory? Let’s look into COGM first.
The formula for cost of goods manufactured is:
Direct Raw Materials Used + Direct Labor Used + Manufacturing Overhead + Beginning WIP Inventory - Ending WIP Inventory
Where “direct” refers to raw materials inventory and labor that actually constitute or assemble the finished product.
COGS Finished Goods Inventory
Finished goods inventory has a big effect on the cost of goods sold (COGS). That’s because a manufacturer creates revenue when finished goods inventory is sold. Recognizing that revenue requires recognizing the COGS—because COGS considers the materials and labor costs applied to each unit sold.
Here’s a great resource for how to calculate COGS. And, long story short, here’s the formula:
COGS = Beginning Inventory + Received Inventory- Ending Inventory
Finished Goods Inventory Formula
The finished goods inventory formula is:
Finished Goods Inventory = Beginning Finished Goods Inventory + (COGM - COGS)
How to Get Finished Goods Inventory: An Example
Let’s say BlueCart Coffee Co. ended last period with $50,000 in finished goods inventory. That means this period their beginning finished goods inventory is $50,000.
Now let’s say their COGM for the period is $80,000 and their COGS is $60,000.
Here’s how to compute finished goods inventory:
Finished Goods Inventory = $50,000 + $80,000 - $60,000
Finished Goods Inventory = $70,000
And this $70,000 worth of finished goods inventory will, of course, be the next accounting period’s beginning finished goods inventory.
The Importance of Calculating Finished Goods Inventory
What’s the big idea? What’s the importance of calculating finished goods inventory?
- It identifies gross profit and current assets. Inventory is frequently a manufacturer’s largest profit driver and current asset. An accurate tally of current assets makes future operating budgets (like your MRO inventory spend) and financial budgets accurate.
- It helps keep waste down. If you know exactly what amount of inventory your business is capable of producing, you’ll make smarter raw materials purchases. You’ll also be able to tweak your safety stock levels and have less sitting inventory which frees up cash and lowers storage costs.
- It drives production efficiencies. You’ll be inventory tracking direct materials and labor costs. Looking over these historical numbers will allow you to tweak processes, integrate automation, and generally iterate toward cleaner, smoother inventory management. You may find that a just in time inventory setup or a vendor managed inventory agreement make sense after looking at the data.
Finished Goods Inventory Is Reported On The ...
Finished goods inventory is reported on the restaurant balance sheet as a current asset. That means they’re short-term assets meant to generate revenue within the next 12 months.
The manufacturing process, as outlined above, has multiple steps. All of these steps should be accounted for in inventory reporting. There is a raw materials account, a WIP inventory account, and a finished goods inventory account. When manufacturing is complete, the WIP account is credited and the finished goods inventory account is debited.
This way leadership and investors can accurately gauge inventory value by high-level insights into each inventory stage. That, importantly, gives them an idea of cash flow and how much cash is tied up in inventory. Two very important indicators of a company’s health.
Finished Goods Inventory Turnover Rate
One big benefit of learning how to figure out finished goods inventory is that you can find your finished goods inventory turnover rate.
Finished goods inventory turnover rate is a ratio. It measures the rate at which a company’s finished goods inventory is sold and replaced (turned over) during a set time frame. Here’s how to find annual finished goods inventory turnover rate:
Finished Goods Inventory Turnover Rate = Annual COGS / Average Month-End Finished Goods Inventory Value
How to Calculate a Finished Goods Inventory Budget
A finished goods inventory budget considers the direct raw materials, direct labor, and overhead costs. In that sense, it’s similar to the COGM calculation, but it doesn’t take in account WIP inventory. All it’s doing is assigning a value to every unit produced based on raw materials, labor, and overhead. It’s not a cumulative indicator.
Calculating a finished goods inventory budget helps set profitable and competitive prices for the products being sold. Consider BlueCart Coffee Co. again.
Direct material: A cumulative $3 for green coffee bean and packaging material. That’s $3 per unit. Packaging can include eCommerce packaging.
Direct labor: Sorting, roasting, and packaging coffee beans wholesale takes about 30 minutes per bag. If a roaster makes $20 per hour, that’s $10 per unit.
Overhead: The roasting business has fixed overhead costs of $7 per hour and variable overhead costs of $2 per hour. That’s a total of $9 per hour overhead costs. The overhead costs per unit are then $9 times .5 hours, or the 30 minutes it takes to go from green coffee bean to packaged roasted bean. That’s $4.50 per unit.
Total individual cost: $17.50 per unit.
Total finished goods inventory cost: $17.50 x inventory volume.
Woof. That’s expensive coffee. But you get the point.
So, What’s an Ideal Finished Goods Inventory Level?
It depends on your business. But, as a rule, you want to minimize finished goods inventory to keep storage costs down. What “minimize” means differs for each business. The point here is getting familiar enough with your finished goods inventory level that you can draw actually useful conclusions from it.
Like, how good are you at selling the things you make?
How much cash is tied up in your inventory, and how much could be freed?
Can you decrease the amount of pipeline inventory you have outstanding at any given time?
These are mega-important questions for both the B2B business model and B2C business model that can only be answered by sound finished goods inventory management. And once you have finished goods inventory numbers you’re confident in, you can start optimizing it. You can even start selling your products on an online marketplace with confidence.
Frequently Asked Questions About Finished Goods
Turning raw materials into merchandise inventory is the essence of finished goods. But you also need to see finished goods in the context of your business’s financial health. Learn how to value finished goods with the commonly asked questions below:
How do you calculate finished goods on hand?
Finished goods on hand can be calculated with a simple formula. First, take your cost of goods manufactured (COGM) and subtract your cost of goods sold (COGS) from your COGM. Second, add your previous cycle’s finished goods inventory. The result is your finished goods inventory for your current cycle.
How are finished goods valued?
Finished goods are valued by taking your starting inventory, adding your cost of goods purchased or manufactured, and subtracting the cost of goods sold.
Let’s say your starting inventory is $3,481, your cost of goods manufactured is $5,000, and your cost of goods sold is $2,090. This gives you a finished goods value of $6,391.
What is the difference between finished goods and inventory?
The difference between finished goods and inventory is finished goods are ready for sale and shipment; inventory is any material or product that is used to make finished goods.
For example, let’s say your business makes soda cans. You order thousands of aluminum sheets with which to make the cans, which is considered raw materials inventory. It’s not until the sheets are put on a production line that they become work-in-process inventory, and when they’re made into cans, then they are finished goods inventory.
What are the example of finished goods inventory?
Examples of finished goods inventory include:
- Electronics like smartphones, laptops, and TVs
- Packaged food products such as canned wholesale seafood, wholesale snacks, and wholesale popcorn
- Clothing items like shirts, pants, and jackets
- Automobiles, motorcycles, and bicycles
- Furniture like chairs, tables, and sofas
- Cosmetics and personal care products like shampoo, soap, and makeup
What is a finished goods inventory?
Finished goods inventory refers to the stock of completed products that manufacturers have produced and are ready to be sold to customers, retailers, or other businesses. This type of inventory is the final stage of the manufacturing process, where the products are ready for wholesale distribution and wholesale sales.
How do you record finished goods inventory?
Recording finished goods inventory in eCommerce accounting typically involves the following steps:
- Track the quantity and cost of raw materials used in the production process
- Allocate labor and overhead costs associated with manufacturing the finished goods
- Calculate the total cost of goods manufactured (COGM)
- Add the beginning finished goods inventory to the cost of goods manufactured
- Subtract the cost of goods sold (COGS) during the accounting period
- The resulting value is the ending finished goods inventory, which should be recorded in the balance sheet as a current asset
Is finished goods the same as COGS?
Finished goods inventory and the cost of goods sold (COGS) are related but not the same. Finished goods inventory represents the stock of completed products that are ready to be sold, whereas COGS represents the total cost of producing and selling those goods during a specific accounting period. COGS is an income statement item that helps businesses determine their gross profit, while finished goods inventory is a balance sheet item that represents the value of completed products held by the company.
How do we classify finished goods?
Finished goods are typically classified based on their type, purpose, or industry. Some common classifications include:
- Consumer goods: Products intended for direct use or consumption by end customers, such as wholesale microgreens seeds, gourmet popcorn, and wholesale dairy
- Industrial goods: Products used by businesses for further production, such as machinery, microgreens kit, bakery equipment, gourmet popcorn business equipment, and raw materials
- Durable goods: Products with a long useful life, such as automobiles, appliances, and furniture
- Non-durable goods: Products with a short useful life or that are consumed quickly, such as wholesale alcohol, seafood subscription box and disposable items