Product finance · NetSuite TD3016323

Product Line Profitability Analysis

Revenue, cost, margin, growth, and portfolio position for every product line and the products inside them, from twelve months of billed sales.

Prepared 2026-09-23 · Subsidiaries 1-3, elimination excluded · Source: NetSuite sales lines via SuiteQL · Prompt: Product Line Profitability Analyzer, NetSuite AI Prompt Library v1 · Standard Review depth

Executive Summary

Billed revenue over the trailing twelve months was $1,862,370, up 85% on the prior twelve, and gross profit on that revenue was $1,199,768. Two things drive the headline and they should be read separately. Product lines, meaning the four classes that carry inventory, earned $511,779 on $1,174,381 of revenue, a gross margin of 43.6%, with every class between 42% and 60%. Delivery service, a single service item with no cost recorded against it, added $687,989 of revenue that shows as pure margin. That is 37% of revenue and 57% of gross profit, and the second figure is not real until the cost of delivering is captured.

Among the product lines, Home and Decor is the largest at $624,469 and grew 27%; Apparel is second at $386,820 and grew 26%. Both are stars on the portfolio matrix: growing faster than 10% with margins above 40%. Beauty is a cash cow, 44% margin on 7% growth. No product line and no product sells below cost, but the margin range within lines is wide, from an Estes Park chair at 3% to a leather valise at 63%.

Profitability Summary

Comparing: September 23, 2025 to September 23, 2026 against the twelve months before. Gross profit = revenue minus the cost estimate carried on each sales line. Ranked by gross profit.

Margin Analysis

Margins by product line sit in a narrow band, which says the pricing and costing conventions are consistent across categories. The spread is inside the lines.

Most profitable products

The Contour Rhapsody Breeze mattress line accounts for eight of the top twelve products by gross profit and roughly doubled in every size. Its margin is 38%, below the line average, so its contribution comes from volume.

Lowest-margin products with meaningful revenue

The Estes Park chair earns $252 on $9,477 of sales, a 3% margin, while the ottoman, chest, and headboard in the same collection earn 49%. That is the pattern to investigate first: a single item in an otherwise healthy collection, which usually means a costing or pricing error rather than a product problem.

Portfolio Analysis

Based on: growth above 10% and margin above 40% as the quadrant thresholds, applied to the four product lines. Delivery service is excluded because its margin is unmeasured.

Mix and margin contribution

Every product line contributes gross profit below its revenue share, because delivery service, with no cost, absorbs 57% of gross profit on 37% of revenue. Correct the delivery cost and the product lines' contribution shares rise to match their revenue shares almost exactly.

Recommendations

• Capture delivery cost. Until a cost is recorded against the delivery service item, the business's largest revenue line has an unknown margin, and every mix statistic is distorted by it. This is an accounting setup task, not an analysis task.
• Investigate the Estes Park chair. One item at 3% margin in a 49% collection. Check the item's cost record and its price before drawing any conclusion about demand.
• Fund the stars. Home and Decor and Apparel are growing at 26 to 27% with margins above 40%. The mattress line in particular is doubling on volume; inventory positioning for it deserves attention.
• Hold Beauty. Healthy margin, slow growth, small share. No action beyond keeping the assortment current.

Product discontinuation, cost allocation, and pricing decisions require human review under the prompt's controls. None is recommended here.

Appendix: Data Lineage

Adaptations from the prompt's templates: product line is the class on the transaction line, because the item record's class is unpopulated for most items in this account; revenue is transactionline.netamount (sign-reversed), which nets discounts; the cost estimate is stored negative and was sign-corrected; transaction.subsidiary is not exposed, so the elimination subsidiary is excluded through the line; the prompt's :minimum_revenue filter was applied as $2,000 for the low-margin table only.

SELECT t.id, t.type, t.trandate, t.entity, tl.item, BUILTIN.DF(tl.item), i.itemtype,
       NVL(BUILTIN.DF(tl.class),'None'), NVL(BUILTIN.DF(tl.department),'None'), NVL(BUILTIN.DF(tl.location),'None'),
       -tl.quantity, -NVL(tl.netamount,0), NVL(tl.costestimate,0), tl.rate, tl.subsidiary
FROM transaction t JOIN transactionline tl ON tl.transaction = t.id JOIN item i ON i.id = tl.item
WHERE t.type IN ('CustInvc','CashSale') AND t.posting = 'T' AND tl.mainline = 'F' AND tl.taxline = 'F' AND tl.subsidiary <> 4
  AND t.trandate >= ADD_MONTHS(SYSDATE, -24)

Appendix: Assumptions and Verification

Confidence: 90% in product-line revenue and growth; 75% in margins, which depend on the cost estimate being maintained; the delivery service margin is unknown.