Payment resources for owner-run local businesses

Compare machine-shop customer concentration before chasing one account

Compare one machine-shop customer’s sales with the same-period shop total. Model a stated reduction scenario and export assumptions without predicting loss.

Use the free tool Read the guide
Updated 2026-10-03 | 5 minute read | By BlueFinch Advisors

Customer sales concentration scenario

Calculate an account’s same-period share and model a user-stated sales reduction.

Use the interactive tool without signing up. It runs in your browser: enter your numbers, save a comparison, download results or print a working copy. Your numbers are not sent to BlueFinch.

Illustrative example inputs

These starting values show how the math works. They are not industry averages, customer results or a quote.

InputExample value

Total shop sales in the period

Use one documented sales basis and period.

$200,000.00

Selected account sales in the same period

A subset of the entered shop total.

$70,000.00

Assumed account sales reduction (%)

A scenario assumption, not a forecast.

20

Example results

MeasureResult

Selected account share

Account sales divided by same-period total sales.

35%

Sales reduction in the scenario

The entered assumption applied to account sales.

$14,000.00

Shop sales after scenario reduction

All other customer sales are held unchanged.

$186,000.00

Calculation detail

MeasureResult
Account sales after scenario reduction$56,000.00
Scenario reduction as share of shop sales7%

Model assumptions

  • One period and the same sales basis for account and shop.
  • Customer grouping is defined outside this model.
  • Only the selected account changes in the reduction scenario.
  • No change in costs, collection timing or replacement sales is assumed.
  • A zero shop total produces an unavailable share.

Read alongside these results

  • This model calculates sales, not profit or collection availability.
  • No universal safe concentration threshold or customer-loss prediction is supplied.

Download this worked example (CSV). Use the interactive version to export your own inputs and results.

Assorted metal components and cutting tools on a light surface.
Photo by Mastars on Unsplash. Stock photography. Photo license.

One customer accounts for a large share of recorded sales. Another sends plenty of quote requests but places few orders. Inbox activity does not measure customer concentration. Choose a consistent sales basis and observation period for the selected account and your shop.

The share calculator above uses $200,000 in shop sales and $70,000 from one account as illustrative inputs. The account represents 35% of the total. A stated 20% reduction in its sales removes $14,000 from the scenario, not from a forecast. No input is an industry average or BlueFinch customer result.

Use with this guide

Measure decided RFQ outcomes

Keep quote activity separate from recorded customer sales.

Map the customer’s buying roles

Check the company relationship before grouping contacts into an account.

Review the BlueFinch dashboard

See the available owner workspace without assuming a machining ERP or drawing archive.

Track repeat machining orders without promising an automatic discount

An account placing another order is different from a quote revision. Count customers consistently before calling an offer successful.

Machine-shop customer exposure: compare unpaid invoices

Compare unpaid machine-shop invoices by customer, separately from historical sales. Use the exposure worksheet to assign acceptance and collection follow-up.

Browse the complete machine shop guides and worksheets.

Choose the sales basis before counting

Use the same accounting basis for the shop and the account. Invoiced sales and collected receipts describe different things. Do not divide one customer’s collected payments by the shop’s uncollected quoted value. Decide whether returns and credits are included, then document the definition. Your accounting records should identify the period and basis behind both numbers.

Group related divisions according to a stated rule when deciding what one account means. A company trading through several contacts is different from several independent buyers. HubSpot’s association documentation explains relationships among companies, contacts and deals. Use your own customer structure and records. A contact count does not establish how much sales depend on one economic relationship.

Sources for this section: HubSpot: Associate records

Read the account share and the scenario separately

Divide the selected account’s sales by total shop sales for the same period, then multiply by 100. The illustrative $70,000 divided by $200,000 produces a 35% share. Enter a reduction assumption separately. A 20% reduction in the account’s sales equals $14,000, leaving $56,000 from the account and $186,000 in shop sales if all other sales stay unchanged.

The tool rejects account sales greater than the entered total. With no shop sales, the share is unavailable. A scenario reduction is an assumption you supplied, not evidence the buyer will cancel work. The model changes sales only. It does not calculate contribution, staffing needs, profitability or how quickly replacement work will arrive.

Check the jobs behind the share

Review order timing, payment status and the kind of work involved before changing your account strategy. A single large completed project has a different history from recurring orders. Inspect the actual record rather than treating the percentage as a universal risk grade. Keep open quotes separate from realized sales and identify credits belonging to the selected period.

Does the account require unusual material purchases, outside processing or reserved capacity? Review cash flow and operations separately to answer those questions. The calculator does not assess contractual rights or predict a customer’s financial condition. Take the exported definitions and scenario to the staff member or advisor handling your business records before making a consequential decision.

Compare periods without changing definitions

Record the start and end dates of each period. Use the saved scenario to compare another period with the same customer-grouping rule and sales basis. A higher share might reflect growth in the selected account, a decline elsewhere or a change in timing. Review the underlying sales before deciding which explanation fits.

The SBA’s finance guidance provides a starting point for maintaining and reviewing business finances. This page supplies a narrow share calculation, not a full financial assessment. Keep your accountant’s reporting definitions consistent. A percentage threshold chosen for your own review is not a published machine-shop standard, and the tool presents no universal safe account share.

Sources for this section: SBA: Manage your finances

Assign a specific account question

Use the result to identify the next review, such as verifying upcoming order dates, resolving unpaid invoices or checking whether other customers need quotes your team has not answered. Name an owner for the question. Chasing more RFQs alone does not establish diversification until the work produces sales under your chosen definition.

BlueFinch’s dashboard is an owner workspace with its published scope, not a replacement for your accounting or machining system. Review the available toolkit against the issue you identified. Download the share calculation with its assumptions for a business review. Browser scenarios clear on reload. No entered account figures are sent to BlueFinch, and the worksheet promises no revenue or savings outcome.

Sources for this section: BlueFinch: Business dashboard scope and demo

Primary sources

BlueFinch last reviewed these sources on October 3, 2026. Payment rules and state requirements can change.

Use this page for general business information. It is not legal, tax, or accounting advice.

Related resources