Ending work in process formula

What is the Ending Work in Process Formula?

Work in process (WIP) is inventory that has been partially completed, but which requires additional processing before it can be classified as finished goods inventory. The amount of ending work in process must be derived as part of the period-end closing process, and is also useful for tracking the volume of production activity. The calculation of ending work in process is:

Beginning WIP + Manufacturing costs - Cost of goods manufactured

= Ending work in process 

Related AccountingTools Courses

Accounting for Inventory

How to Audit Inventory

Example of the Ending Work in Process Calculation

ABC International has beginning WIP of $5,000, incurs manufacturing costs of $29,000 during the month, and records $30,000 for the cost of goods manufactured during the month. Its ending work in process is:

$5,000 Beginning WIP + $29,000 Manufacturing costs - $30,000 cost of goods manufactured

= $4,000 Ending WIP

Additional Calculation Considerations

This formula only yields an approximate ending work in process number, since such factors as rework, scrap, spoilage, and incorrect record keeping can cause a considerable divergence between the results of the formula and the cost of the actual WIP on hand. In most cases, these additional issues will reduce the amount of ending work in process by charging additional items to expense in the current period.

Consequently, some companies use two alternative practices to arrive at an ending work-in-process, which are noted below.

  • Record no work-in-process. The manufacturing process may be so rapid or streamlined that a company can complete all production by the end of the measurement period, resulting in no WIP. Alternatively, the amount of WIP may be so insignificant (as is the case in some just-in-time environments) that there is no need to measure it.

  • Conduct a count. Rather than using a formula, conduct a count of the work in process and assign standard costs based on the stage of completion. This approach is quite labor-intensive, and so is not recommended. It is easier to conduct a work-in-process count when there are only a few stages of work within the production process, so that only a few counts need to be conducted at specific points in the process.

Related Articles

The Difference Between Work in Process and Work in Progress

Work in Process Accounting