What is Work in Process (WIP) Inventory and How to Calculate It

Work in process (WIP) inventory is an important line item on a merchant’s balance sheet and a key indicator of the health of their supply chain. WIP inventory is not applicable to merchants who purchase finished goods from a supplier for resale. However, if your procurement process looks anything like the following three scenarios, you should be tracking and calculating your WIP inventory.

• You’re in the business of custom, hand-made goods, and you acquire raw materials to assemble your products yourself. 
• You work with multiple suppliers to source materials then send them to a manufacturer to assemble your finished goods.
• You partner with a single supplier/manufacturer that sources materials on you behalf and assembles your finished goods.

In all three of these scenarios, you have unfinished goods (or WIP inventory) at some stage of the process. Continue reading to learn exactly what is WIP inventory, how to calculate it, why it matters, and how it fits into a healthy supply chain.

What is Work in Process (WIP) Inventory?

On any merchant’s balance sheet, the inventory line item is made up of three types of inventory:

• Raw Materials: These are the materials used to assemble your product. For example, if you sell baking mixes, your raw materials would be the flour, salt, baking powder, etc. in the mix, as well as packaging materials. 
• WIP Inventory: These are products that are currently at some phase of the manufacturing process. They are unfinished state and therefore you cannot sell them. Once a raw material meets human labor, you should consider it a work in process.
• Finished Goods: These are your final assembled products that are ready for sale. Once an item has been sold it’s referred to as merchandise and associated costs move to Cost of Goods Sold (COGS) in the accounting ledger.

So for the purposes of accounting, WIP inventory is the total value of any unfinished goods, and although they can’t be sold, you should count these goods as an asset on a balance sheet. It’s important to include WIP inventory as an asset when calculating the value of your business for finding investors or securing financing. On the accounting side, calculating WIP inventory also helps you understand the true value of your inventory for tax purposes.

What’s more, calculating WIP inventory gives you a clear picture of the health of your supply chain so you can better optimize supply chain planning. Generally speaking, best practice is to carry as little WIP Inventory as possible. Having too much WIP inventory on-hand can be an indication of bottlenecks in your manufacturing or procurement process.

Work in Process Inventory Formula

Most merchants calculate their WIP inventory at the end of a reporting period (end of quarter, end of year, etc.), and are looking for their “ending WIP inventory”. To calculate ending WIP inventory, you need beginning WIP inventory, which is the previous reporting period’s ending WIP inventory.

You must also calculate the production costs that are currently tied up in unfinished inventory. This includes the raw materials and the labor and overhead costs associated with the percentage of work that has been completed.

Finally, you need the value of your finished goods, which is the total value of your inventory ready to be sold. It includes manufacturing costs, raw materials, and overhead costs.

Once you have all of these variables determined, the formula for WIP inventory is as follows:

WIP Inventory Example:

For example, if your business is calculating WIP inventory at the end of each quarter, and your accounting records show that your ending WIP inventory previous quarter was $15,000, that will be your beginning WIP inventory for the current quarter.

Then you find that you have invested $225,000 in production costs for the quarter, and the total value of your finished goods is $215,000. 

In this example, you would calculate your ending WIP inventory as follows:

($15,000 + $225,000) – $215,000 = $25,000

The Role of Work in Progess (WIP) Inventory in the Supply Chain

Although you can’t see WIP inventory, it is considered an asset on a the balance sheet. For this reason, it’s considered best practice to hold as little WIP inventory as possible.

In fact, an excess of WIP inventory can be a symptom of bottlenecks within the supply chain. Having excess WIP inventory on-hand can also raise operating costs and reduce productivity in the following ways:

• You must store WIP inventory somewhere, and holding unsellable inventory for an extended period of time will increase inventory carry costs and drag down profitability. Free up storage space for finished goods that are ready to create revenue.
• WIP inventory represents capital that is tied up in raw materials and overhead costs. Holding as little WIP inventory as possible means you’re putting your capital back to work for you in the form of finished (sellable) goods.
• Unfinished products are more are at higher risk for loss or damage in the process.

Recently, an inventory glut has forced even large retailers to offer deep discounts and offload excess inventory, ultimately damaging earnings. In fact, CNBC reports that excess inventory levels will be the most important factor investors watch in upcoming quarterly earnings reports.

How to optimize inventory flow

It’s particularly important to monitor supply chain efficiency in a time of unprecedented supply chain disruptions leading to raw material shortages and extended lead times. These elevated lead times have led many merchants to forecasting demand and procuring inventory 6 months in advance (as opposed to historically forecasting on a quarterly basis). To avoid a buildup of WIP inventory, it’s important to work closely with suppliers for the most accurate projections of lead times possible.

Another important factor in keeping WIP inventory low is accurate inventory cycle counts. An integrated Warehouse Management System (WMS) can give you accurate, real-time inventory counts. This helps you build more accurate forecasts to communicate with suppliers and freight forwarders more efficiently. Small to mid-size businesses can access enterprise-grade inventory management by outsourcing fulfillment to a 3PL or 4PL.

Looking for an integrated WMS? Schedule a demo of FulfillmentVu today

WIP Inventory FAQ’s

What is included in work in progress inventory?

Work-in-process costs include all raw materials and labor needed to manufacture the final product. Calculating WIP inventory is complicated because it requires an assessment of the cost of labor and overhead associated with the percentage of work completed.

Because it is difficult and time-consuming to calculate, most merchants try to have as much inventory as possible in the finished goods state before the end of a reporting period.

How do you calculate work in process inventory?

There are three variables you need to calculate work in process inventory:

• Beginning work in process inventory: You must have the previous quarter’s ending work in process inventory, which is carried over as the next quarter’s beginning work in process inventory.
• Production costs: This is a sum of your raw materials used, labor costs, and any overhead such as machine operating costs.
• Finished goods: This is your total cost of goods manufactured (COGM), which is calculated by adding raw materials, labor, overhead, and beginning inventory work in process inventory, then subtracting ending work in process inventory.

Once you have all three of these variables, the formula for calculating WIP inventory is:

(Beginning WIP Inventory + Production Costs) – Finished Goods = Ending WIP Inventory 

How do I account for work in progress inventory?

Works in process (WIP) are included in the inventory line item as an asset on your balance sheet. The two other categories of inventory are raw materials (the beginning materials used to manufacture a product) and finished goods (fully assembled products ready to be sold).