Manufacturing working capital: inventory and cash needs

Manufacturing working capital is the funding tied up in production inventory and customer receivables after supplier trade credit. Calculate it by adding raw materials, work in process, finished goods and trade receivables, then subtracting trade payables. Separate the inventory stages to find where the balance sits before choosing an action.

Start with a plant-level export

Use a common closing date and reporting currency. Bring inventory balances by plant and production stage, receivables by customer and plant, supplier payables by plant, and net sales for the preceding year. Preserve the ledger account, document reference and balance date so each total can be reconciled.

The Census Bureau's manufacturing definitions distinguish materials and supplies, work in process and finished goods. Its work-in-process definition includes accumulated costs of items undergoing fabrication. Use your recorded carrying costs, including the production costs already capitalized there, rather than an estimate of selling price.

Confirm who owns goods at outside processors and in transit. IRS Publication 538 lists raw materials, work in process and finished products as inventory and explains that purchased merchandise can belong in inventory after title passes even without physical possession. That tax guidance is a useful ownership check; keep the actual calculation tied to your company's financial-reporting ledger and policies.

This article uses trade operating balances. The broader working-capital formula includes all current assets and current liabilities, so do not compare its result directly with this plant measure.

Calculate inventory and the trade balance

Manufacturing trade working capital = Raw materials + Work in process + Finished goods + Trade receivables − Trade payables

The illustrative US manufacturer below has balances at September 30, 2026, and sales for the twelve months ending then. These are invented teaching figures, not industry benchmarks. Interplant balances have been eliminated and external sales are assigned consistently.

With plant in A, sales in B, inventory stages in C:E, receivables in F and payables in G, add these calculated columns:

H2=SUM(C2:E2)
I2=H2+F2-G2
J2=I2/B2

Copy the formulas down through Pine. Column H is inventory, I is trade working capital, and J is its share of annual sales. Format J as a percentage.

Cedar's inventory is $420,000 + $300,000 + $480,000 = $1,200,000. Adding $900,000 of receivables and subtracting $500,000 of payables gives $1,600,000. Dividing by $6,000,000 gives 26.666667%, shown as 26.7%; all displayed percentages round to one decimal place after calculation.

For the group percentage use:

=SUM(I2:I3)/SUM(B2:B3)

The result is $2,900,000 / $10,000,000 = 29.0%. Do not average the plant percentages. For an industry context, use the same definition in the working-capital comparison by industry.

Prove the totals before assigning actions

The inventory stages must reconcile: $700,000 + $800,000 + $800,000 = $2,300,000. Then $2,300,000 + $1,500,000 − $900,000 = $2,900,000, matching the sum of the plant trade balances.

Tie inventory to the inventory control accounts, receivables to the customer aging total and payables to the supplier aging total. Document excluded nontrade accounts and reconciling items. An unexplained difference is a stop signal for the comparison, because it could put the same balance in different plants or periods.

Pine has a larger work-in-process balance despite lower annual sales. Production should inspect order age, stalled jobs and completion constraints. Credit should review unpaid customer invoices, while procurement checks that supplier terms are current and sustainable. Finance owns the common definitions and reconciliation.

Test a production change without claiming cash too early

Suppose Pine reduces its work-in-process requirement while every other balance and annual sales remain unchanged. This is an illustrative balance scenario:

The scenario calculation is $280,000 + $400,000 + $320,000 + $600,000 − $400,000 = $1,200,000. At unchanged sales of $4,000,000, Pine's share becomes 30.0%. That is a lower funding requirement under the stated assumptions, not proof of a bank receipt.

If work merely moves from unfinished production into finished stock, total inventory does not fall. Validate the purchasing, shipment and collection schedule separately. Use working-capital days for a timing view and initial working capital when funding a new plant's opening operation.

Where plant comparisons go wrong

• Inventory counted twice. Add stage balances or the inventory total, never both.
• Internal transfers treated as sales. Interplant movements can inflate the denominator without producing external cash.
• Different cost policies. Reserves, overhead allocation or cost-method differences can change carrying values without improving production flow.
• Overdue suppliers mistaken for efficiency. More unpaid trade bills reduce the calculated balance but may signal missed payment obligations.

Check your plant export in Covirage

Bring a file or Google Sheet with plant-level inventory stages, trade receivables, trade payables and sales. Covirage maps the columns, and its tools compute and check the plant balances; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for industrial manufacturers.