This straightforward explanation of what is WIP (Work in Process) Inventory includes a step-by-step formula and explanation of the place of WIP inventory in the end-to-end supply chain.
This straightforward explanation of what is WIP (Work in Process) Inventory includes a step-by-step formula and explanation of the place of WIP inventory in the end-to-end supply chain.
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.
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.
On any merchant’s balance sheet, the inventory line item is made up of three types of inventory:
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.
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
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:
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.
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.
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.
There are three variables you need to calculate 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
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).