Blog · Finance metrics and formulas · Manufacturing
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.
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.
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?
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.
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.
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.
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.
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.
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.
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.