Product Margin Analysis

Clean revenue and unit costs, gross margin by product, service line and customer, monthly refreshes and reviews, and the repricing and discontinue decisions that follow from them.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Product Margin Analysis, and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help you organise decisions about money. It is not financial, investment, tax or legal advice, and it does not recommend any product, investment or deal. Rules differ between countries, so check decisions that matter with a qualified, licensed adviser in yours. Investing and trading can lose money, and raising or managing other people's money is regulated in most countries.

What it installs.

1

Pillar

1

Area

50

Projects

204

Starter tasks

🧾 Finance & Accounting

Product Margin Analysis

Analysing gross margin by product, service line or customer to find what is profitable, what to reprice and what to stop selling.

  1. Three decisions the margin analysis must inform
  2. Agreed definition of gross margin for the business
  3. Product family structure for margin reporting
  4. Unit cost sheet for the top twenty sellers
  5. Realised price after discounts, rebates and returns
  6. First twelve-month gross margin table by product
  7. Gross margin by customer baseline
  8. Margin data source and extract map
  9. Margin data quality check
  10. Monthly product margin refresh
  11. Supplier cost change log
  12. Quarterly margin league table review
  13. Weekly discount and price override watch
  14. Negative-margin order alert
  15. Quarterly customer profitability review
  16. Yearly unit cost reset before the price review
  17. Returns and credit note margin leakage
  18. Margin floor register by product family
  19. Fixed, variable and stepped costs in product margins
  20. Price, volume and mix variance analysis
  21. Cumulative profit curve of products and customers
  22. Margin percentage versus margin cash in decisions
  23. Price sensitivity basics for repricing
  24. Spreadsheet skills for margin work
  25. Cost-to-serve for customer margin
  26. Repricing the lowest-margin products
  27. Keep or discontinue decision for tail products
  28. Small order surcharge or minimum order decision
  29. Supplier renegotiation for margin-dragging lines
  30. Bundle, kit and package margin check
  31. Discount policy with margin guardrails
  32. Customer price tier structure redesign
  33. Unprofitable customer repricing or exit plan
  34. Product mix shift toward higher-margin lines
  35. Sales commission based on gross margin
  36. Annual price increase round
  37. Margin check before a new product launch
  38. Margin briefing for the board or investors
  39. Response to a major supplier price rise
  40. Margin sign-off for a large quote or tender
  41. Margin view for a founder's first product range
  42. Service line margin for a people-based business
  43. Online seller margin after platform and fulfilment fees
  44. Manager taking over a product line's margin
  45. Wholesale, retail and online channel margin comparison
  46. Margin protection for importers facing cost and currency swings
  47. Margin evidence for a fundraise or business sale
  48. Product, customer and channel margin cube
  49. Price waterfall from list price to pocket price
  50. Rebates and promotional funding in customer margin

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Three decisions the margin analysis must inform

Margin analysis without a decision attached turns into a large spreadsheet nobody opens twice. Naming the three choices you actually face this year, such as which lines to reprice, which customers to renegotiate and which products to drop, tells you what level of detail is needed and what can be left out.

First tasks

  • Write down the pricing or range questions you have put off this year
  • Pick the three that would move profit most if answered
  • Note the margin figure that would tip each decision one way or the other
  • Agree an owner and a decision date for each of the three

Agreed definition of gross margin for the business

Ask three people what goes into cost of sales and you will often get three answers: one includes inbound freight and packaging, another adds card fees, a third counts direct labour. Writing one definition, agreed with your accountant, stops arguments about whose number is right and makes every later comparison fair.

First tasks

  • List every cost line that currently lands in cost of sales
  • Mark freight, packaging, payment fees and direct labour as in or out
  • Write one worked example showing margin and markup on the same item
  • Send the draft definition to your accountant for comment

Product family structure for margin reporting

Two hundred individual items are too many to discuss and three categories are too few to act on. Grouping what you sell into eight to fifteen families, each with a clear owner, gives a level where margin patterns become visible and decisions can be made in a meeting.

First tasks

  • Export the full active item list with last year's sales value
  • Draft eight to fifteen families that a buyer or manager would recognise
  • Add a family field to the item list and fill it for every item
  • Write a two-line rule for assigning new items to a family

Make it yours.

Install Product Margin Analysis, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.