Calculating work in progress (WIP) involves determining the value of partially completed goods or services that are still in the production process. The calculation of WIP is important for determining the current value of inventory and for monitoring the efficiency of production processes.
To calculate WIP, you need to determine the cost of the materials and labor that have been used to produce the partially completed goods or services. This calculation is typically done by adding up the costs incurred up to a specific point in the production process. Here are the steps to calculate WIP:
- Determine the total cost of all materials used in the production process up to the current stage of completion. This includes both direct materials and indirect materials, such as supplies or tools used in the production process.
- Determine the total cost of all labor incurred in the production process up to the current stage of completion. This includes both direct labor costs and indirect labor costs, such as supervision or training.
- Add the cost of materials used and labor incurred to obtain the total cost of the partially completed goods or services.
- Subtract any revenue earned to date from the partially completed goods or services to arrive at the estimated value of the WIP.
For example, suppose a company is producing a batch of widgets and has incurred $10,000 in direct materials and $5,000 in direct labor costs. The company has completed 80% of the production process, and expects to earn $25,000 in revenue from the sale of the completed widgets. To calculate the value of the WIP, you would use the following formula:
WIP = (Total cost of materials used + Total cost of labor incurred) – Revenue earned to date
WIP = ($10,000 + $5,000) – ($25,000 x 80%)
WIP = $15,000 – $20,000
WIP = -$5,000
In this example, the value of the WIP is negative, indicating that the company has incurred more costs than it expects to earn from the sale of the completed widgets. This may indicate a potential problem with the production process, such as inefficient use of materials or labor.
WIP is often a contentious issue….sellers need to understand it and recognize the buyers expectation. Healthy and clear books and records make the process simple. An experience broker/intermediary can assist, prior to sale in setting an expectation of your WIP and how it plays in your deal. Contact Michael Shea Tampa Bay Business Broker for more information at mike@tworld.com or 321-287-0349.