Sign in

Blog · Finance metrics and formulas · Manufacturing

Manufacturing financial analysis: profit, costs and cash

Manufacturing financial analysis connects plant profit to output, production costs and inventory cash. Follow a worked monthly review with spreadsheet formulas and checks that separate better operations from cost absorption.

The short answerManufacturing financial analysis compares plant revenue, production costs, inventory and cash movements for the same period. Start with sales and cost exports, reconcile them to the ledger, then separate selling volume, unit costs and overhead absorption. A profit increase supported by higher inventory can coexist with weaker cash generation, so review both before deciding what improved.

Manufacturing financial analysis connects plant profit changes to sales volume, production costs, overhead absorption and inventory cash. Reconcile those movements before treating a higher gross profit as evidence of better plant performance. The same sales can produce more reported profit while leaving less cash available.

Start with a review that ties to the books

Choose one accounting month and one plant. Export invoice lines with product, quantity, net revenue and posting date; production completions; material issues; payroll or job labor costs; and the inventory movement report. Keep the controller's overhead allocation schedule beside the files.

First tie net revenue to the plant income statement. Then tie material, labor and overhead accounts to the production cost report. Finally reconcile raw materials, work in process and finished goods to their opening and closing ledger balances. Transfers between plants need a separate label so they cannot become outside sales.

Production costs do not all become current-period expenses. The IRS inventory guidance identifies direct materials, direct labor and certain indirect costs as manufacturing inventory cost elements. Use the company's approved financial reporting policy for the review; the tax publication is background, not a replacement for that policy.

The broader financial analysis workflow covers the statement review. Here the question is narrower: what changed inside the plant, and where did its cash go?

Build the monthly comparison from recorded quantities

Consider an illustrative US components manufacturer in January and February 2026. It sells the same product at the same net price. Both months begin with no finished goods, and there is no work in process or raw-material balance change.

Put the inputs below in columns A through C, with January in B and February in C. The first input is spreadsheet row 2. Dollar amounts are USD; quantities are units.

Input January February
Units produced 10,000 12,000
Units sold 10,000 10,000
Net selling price per unit (USD) 50 50
Material cost per unit (USD) 20 20
Direct labor per unit (USD) 8 8
Variable overhead per unit (USD) 4 4
Fixed production overhead (USD) 120,000 120,000
Normal output used for approved allocation (units) 12,000 12,000

For this example, the controller's policy allocates fixed overhead at the normal-output rate and expenses any unabsorbed amount in cost of goods sold. January's lower output leaves some fixed overhead unabsorbed. This assumption makes the absorption effect visible; it does not prescribe a costing policy for another plant.

Calculate the fixed overhead rate in B11:

=B8/B9

That is $10 per unit. The variable production cost is =SUM(B5:B7), or $32 per unit. Inventory therefore carries $42 per unit. Copy formulas across for February without changing the approved rate denominator.

Calculate profit and prove the inventory movement

Use these formulas for January, then copy across:

Revenue: =B3*B4
Unabsorbed fixed overhead: =MAX(0,B8-B2*B11)
COGS: =B3*(SUM(B5:B7)+B11)+MAX(0,B8-B2*B11)
Ending finished goods: =(B2-B3)*(SUM(B5:B7)+B11)
Production costs incurred: =B2*SUM(B5:B7)+B8

This compact example assumes production does not exceed the approved normal output. Investigate any such case with the controller before applying the same allocation formula.

Result January (USD) February (USD)
Net revenue 500,000 500,000
Unabsorbed fixed overhead, included in COGS 20,000 0
Cost of goods sold 440,000 420,000
Gross profit: revenue less COGS 60,000 80,000
Ending finished goods 0 84,000
Production costs incurred 440,000 504,000
Plant cash contribution, under assumptions below 60,000 -4,000

The inventory identity must hold:

Beginning inventory + Production costs incurred = COGS + Ending inventory

January gives 0 + 440,000 = 440,000 + 0. February gives 0 + 504,000 = 420,000 + 84,000. The unabsorbed overhead is already included in COGS; adding it again would break the check.

Gross profit rises by $20,000 because less fixed overhead is expensed immediately. No selling price or variable unit cost improved. Use manufacturing KPIs to investigate output and quality, and manufacturing financial ratios for the wider set of ratios rather than expanding this review into a catalog.

Put the cash beside the profit

Assume every sale is collected and every production cost is paid in its month. There are no depreciation charges, selling expenses, taxes, interest or other cash movements in this illustration. Plant cash contribution is therefore revenue less production costs incurred: February is 500,000 - 504,000 = -$4,000.

The alternative check is gross profit less the inventory increase: 80,000 - 84,000 = -$4,000. January generates $60,000 on the same basis. These figures describe this simplified plant view; a company cash flow statement also includes other operating balances and activities. The SEC's financial statement guide explains why profit and operating cash flow differ.

The action is to review demand for the unsold units before scheduling more output. Ask whether the inventory builds an agreed customer buffer or merely delays expense recognition. A recurring forward-looking workbook belongs in the separate manufacturing financial model.

Where the review goes wrong

  • Production called sales. Units completed belong in the inventory movement until sold; they are not revenue.
  • Purchases called material consumption. Material bought can remain in stores. Compare issues and returns with actual production before interpreting unit costs.
  • Absorption called efficiency. Higher output can change when fixed costs reach the income statement without reducing the plant's total spending.
  • Different cutoffs. A late goods receipt or an invoice posted in another month breaks the inventory identity and the margin comparison.
  • Inventory growth called the whole cash movement. Receivables, payables, depreciation and equipment purchases need separate treatment outside this simplified example.

Review your own plant file in Covirage

Bring your plant income statement, production cost workbook and inventory movements to Covirage as a file or Google Sheet. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the movements 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 for the supporting industry context.

Questions people ask

Which files are needed for manufacturing financial analysis?

Bring the monthly plant income statement, invoice lines, production quantities, material issues, labor costs and inventory movements. Add opening and closing inventory balances and the approved overhead allocation schedule. Use the same plant identifiers and accounting cutoff across every export.

Why can manufacturing profit rise while cash falls?

Producing goods that remain unsold uses resources while some production costs remain in inventory. Reported profit can improve as more fixed overhead is absorbed into inventory. Receivables, supplier payments and equipment spending can create additional differences between earnings and cash.

Should plant managers compare cost per unit across all products?

Compare like products with consistent units and cost definitions first. A change in product mix can move a plant average even when each product's efficiency stays constant. Use equivalent units only when the conversion factors have a clear operational basis.