Profit margin on blinds: measure each completed job

Profit margin on blinds is the profit on a completed order divided by that order's net sales. The useful operating measure includes the blinds, installation, freight, commission and actual rework. Product gross margin is a separate subtotal, and neither measure is company net margin.

Build a completed-job file

Start with the completed-order register for one reporting period. Join supplier invoice lines, inbound freight, installer time, commissions and remake records using the order or job ID. Retain the source invoice or time-entry reference for every cost.

Keep product sales and installation charges in separate columns. Use net revenue after job discounts and credits; exclude collected sales tax from this example. Do not substitute deposit receipts or supplier payments for revenue and costs matched to completed work.

The IRS's cost-of-goods-sold guidance includes freight-in on merchandise purchased for sale and distinguishes product costs from other expenses. Here, supplier cost and inbound freight form product cost. Installation labor, commission and rework are additional job costs in the management view. Reconcile that view to your own accounting classifications.

For the accounting definition of product margin, use the gross profit margin guide. This workflow adds the costs needed to judge an installed order.

Work two jobs from their source costs

An illustrative US blinds company completes these orders in the same month. The supplier amounts are net of any credits. Installation labor includes the employer cost assigned to the job; rework includes the additional costs associated with a callback.

Product gross profit subtracts supplier product cost and inbound freight from product revenue. Job contribution subtracts all the listed costs from total job revenue:

All percentages round to two decimals from unrounded calculations. The two jobs have identical product gross margins, but their completed-job contribution margins differ. That difference points to installation and service costs that a product-only comparison would miss.

Put the calculation in Excel

Arrange one row per completed job with these columns: A job ID; B product revenue; C installation revenue; D supplier cost; E inbound freight; F installation labor; G rework; H commission. Place B101 on row 2 and B102 on row 3.

Add I for net job revenue, J for job contribution and K for contribution margin. In I2, J2 and K2, respectively, enter:

=B2+C2
=I2-SUM(D2:H2)
=J2/I2

Fill down to the second job and format column K as a percentage. Microsoft's SUM documentation confirms that SUM adds a cell range. Covirage is not affiliated with Microsoft.

For product gross profit and product gross margin, respectively, use:

=B2-D2-E2
=(B2-D2-E2)/B2

For the total contribution margin, divide totals:

=SUM(J2:J3)/SUM(I2:I3)

Do not average column K. The larger job must carry more weight because it represents more revenue. The profit margin calculator covers gross, operating and net margin when you have the full company expense lines.

Prove the result before using it

The first check is the cost total: $2,310 plus $140 plus $560 plus $140 plus $210 equals $3,360. The second is the profit bridge: $5,250 net job revenue minus $3,360 assigned costs equals $1,890 contribution. The individual contributions also sum to $1,890.

Tie the revenue total back to the completed jobs in the ledger, and tie each cost category to its source export. If an installer or freight invoice has no job ID, keep it visible as an unresolved cost rather than quietly excluding it. Confirm whether an apparent zero means no cost or a missing record.

Job contribution still has to cover expenses outside this file, such as office administration and other shared costs. For the final company result, use net profit margin. Record any additional overhead allocation separately so managers can see both contribution and the allocated result.

Use rework as an investigation signal

Change only B102's rework cost to see its effect:

The difference is $140 of contribution. This sensitivity does not prove the callback was avoidable. Review measurement notes, supplier defects, installation records and approved scope changes before deciding what process or quote should change.

For orders sold through an online channel, the ecommerce profit margin workflow covers the additional order-fee and refund reconciliation.

Where it goes wrong

• Quotes mixed with completions. Estimated supplier cost and actual completed revenue produce a forecast, not an actual job result.
• Installation revenue without installation cost. That combination overstates the margin available from the work.
• Unrecorded callbacks. Later rework can reverse an initially strong result; keep job IDs on follow-up charges.
• Freight charged twice. If freight is already included in a supplier line, do not add it again from a separate report.
• Markup called margin. Divide profit by revenue for margin. Profit divided by cost is a different measure.

Measure your completed jobs in Covirage

Bring a sample of your own completed-order and job-cost files to Covirage: it maps the columns, and its tools compute and check product margin and job contribution. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your export.

See customer profitability for the broader business context.