Cotton wicks business profit: yield, costs and contribution

Cotton wicks business profit comes from saleable output and realized customer prices after production and selling costs. Start with the batch release report, then connect its usable yield and costs to invoices. A margin assumption taken from another market cannot replace an existing US manufacturer's own records.

Assemble the batch and invoice rows

Use production records with batch ID, cotton consumed, released output, rejects, pack size, labor hours and packaging consumed. Add recorded material and labor costs. Separate fixed factory expenses from costs that change with output.

For sales, retain invoice date, customer, batch, SKU, quantity, price, discounts and credit memos. Match selling expenses by customer or order. Unsold production remains inventory under the costing policy used here.

IRS Publication 334 describes manufacturing costs including production labor, materials, integral packaging and factory overhead. The contribution calculation below deliberately separates variable production costs from fixed factory expenses; it is a management view that must reconcile to the full cost report.

Calculate usable yield before unit cost

This illustrative US manufacturer makes one cotton-wick specification. Cotton weights exclude packaging, and no moisture adjustment, scrap recovery or work in process remains in the batch.

Released content is 100 − 8 = 92 kg. Convert kilograms to grams before dividing: 92 × 1,000 / 20 = 4,600 packs. Yield is 92 / 100 = 92.0%. Count released packs independently against the packing record; a weight calculation alone does not establish that all packs passed inspection.

Build the production cost sheet

Enter this table in a worksheet called Production, with headings in row 1 and cost rows in rows 2–5. The consumables line is the recorded batch total represented as one lot.

In Excel, use these formulas in D2, D6 and D8, respectively. Fill D2 through D5 and enter 4600 released packs in D7:

=B2*C2
=SUM(D2:D5)
=D6/D7

The variable cost per released pack is $2,300 / 4,600 = $0.50. Separately, the batch carries $920 of fixed factory cost, making full manufacturing cost $2,300 + $920 = $3,220, or $0.70 per pack. Those figures use the same released quantity and keep fixed cost visible.

For capacity and overhead questions beyond this batch, see manufacturing margins. The broader profit per unit calculation explains how the cost definition changes a unit-level result.

Match customer revenue and selling costs

Assume all released packs sell in the same reporting period, with no discounts or returns. Customer A buys 2,800 packs at $1.25; Customer B buys 1,800 at $1.10. Their prices are illustrative invoice inputs.

On Orders, use A for customer, B for packs, C for price, D for net revenue, E for variable production cost, F for freight, G for payment charges, H for special handling, I for contribution and J for margin. Enter these formulas in D2, E2, I2 and J2, respectively:

=B2*C2
=B2*Production!$D$8
=D2-SUM(E2:H2)
=IF(D2=0,"",I2/D2)

Fill down for both customers. Keep intermediate calculations unrounded and display money to cents and percentages to one decimal place.

For example, Customer B contributes $1,980 − $900 − $240 − $39.60 − $100 = $700.40. The total margin is $2,550.40 / $5,480 = 46.5%, calculated from totals rather than averaged customer percentages. The contribution margin ratio guide explains that denominator.

If the export contains many orders, summarize contribution by customer using the same columns. With the selected customer in Summary!A2:

=SUMIFS(Orders!$I$2:$I$5000,Orders!$A$2:$A$5000,A2)

Microsoft documents SUMIFS as summing values that match specified criteria. Covirage is not affiliated with Microsoft.

Reconcile contribution to operating profit

Assume recorded administrative expenses are $1,100 for the period. The full bridge is:

Check it another way: revenue of $5,480 less full manufacturing cost of $3,220 gives gross profit of $2,260. Freight, charges, handling and administration total $420 + $109.60 + $100 + $1,100 = $1,729.60. Then $2,260 − $1,729.60 = $530.40, matching the contribution bridge.

Customer B's lower contribution prompts questions about price, shipment consolidation and custom handling. Production owns yield; sales owns terms; finance owns the reconciliation. Connect those actions through the financial analytics process.

Where it goes wrong

• Input confused with output. Divide by released packs, after inspecting rejects and confirming the pack specification.
• Fixed labor called variable. Classify costs according to how they behave in the decision period, rather than assuming every production hour disappears with fewer orders.
• Unsold packs expensed immediately. Reconcile batch output to sales and ending inventory before calculating period profit.
• Customer costs omitted or repeated. Include special handling once; do not add freight already included in another cost line.

Work through your own batch in Covirage

Bring a sample of your own batch, invoice and customer expense files. Covirage maps the columns, and its tools compute and check the yield, cost and contribution figures; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and set up your business with your own records.

See Covirage for industrial manufacturers.