Scenarios and Client Concentration

1Alternative outcomes and planning assumptions

A managed services provider (MSP) supplies technology services and products. The business plans around future clients, staff and supplier costs, but those outcomes can change. A scenario is a coherent set of assumptions used to explore a possible outcome. A baseline is the starting forecast used for comparison.

A sensitivity test changes one input while keeping the other stated inputs unchanged. A scenario may change several related inputs because a single business event has several effects. Losing a client can reduce revenue, some licenses and collections while leaving payroll unchanged. Label which kind of test you are performing so the result has a clear meaning.

QuickBooks Online supplies accounting actuals. Syncro supplies contract, service and billing detail. Excel can calculate the forecast consequences. The admin manager checks the starting records and formulas. The CEO selects the business assumptions and leads decisions about hiring, financing and changes to client or supplier arrangements.

The purpose is to prepare decisions that depend on uncertain events. Begin with a specific question, such as whether a proposed hire remains affordable if a client renews late. Define the event, date and evidence before changing the model. A general instruction to make the forecast pessimistic gives the reader no explanation of what happened or why the amounts changed.

2Client concentration and the comparison basis

Client concentration is the share of a defined business measure attributable to one client or a group of clients. Revenue concentration can measure how much earned revenue depends on a client. Receivables concentration can measure how much outstanding collection depends on that client. Contribution concentration can measure how much direct contribution comes from the relationship.

The denominator determines the meaning. A client's recurring service revenue divided by company recurring service revenue is a recurring-revenue concentration measure. A client's total earned revenue divided by company total earned revenue is a total-revenue measure. These measures can differ when projects and hardware are significant. Label the period and revenue categories in both the numerator and denominator.

Practice example: a hypothetical client contributes $8,000 of monthly recurring revenue, and the company has $40,000 of recurring revenue under the same definition. Concentration is 20%. If total company revenue including projects is $50,000, the same $8,000 is 16% of total revenue. Neither percentage replaces the other; each uses a different comparison basis.

The supplied company exports contain aggregate revenue, rather than client-level revenue and contracts. They do not establish the company's largest client or its concentration. Obtain a reconciled client schedule before making a company concentration claim. An account category total can help reconcile the schedule, but it cannot reveal which clients produced the revenue.

The company financial reference records the supplied aggregate figures, reporting periods and missing supporting records. Use that reference when checking this lesson's company calculations.

3Lost revenue and avoidable costs

An avoidable cost is a cost the business can actually stop or reduce under a specified decision and timing. Some client-specific licenses may be cancellable when service ends. Other licenses have annual commitments or notice requirements. Payroll may continue while employees are reassigned. The cost forecast needs the terms and dates that establish what can change.

Operating profit is revenue minus direct delivery and product costs, then minus operating overhead, under the stated classification.

Practice example: baseline monthly revenue is $50,000. Direct delivery and product costs are $30,000, and operating overhead is $15,000. Operating profit is $5,000. A departing client accounts for $8,000 of revenue and $2,000 of monthly vendor costs that can be stopped immediately in this exercise. No payroll or overhead is reduced.

After the departure, revenue is $42,000. Direct costs are $28,000. Overhead remains $15,000. Operating profit becomes negative $1,000. The lost client reduces operating profit by $6,000: $8,000 of lost revenue minus $2,000 of avoidable costs. The calculation explains why the full lost revenue is not automatically the lost profit.

Do not remove the client's allocated labor from company payroll merely because its revenue stops. An allocated cost estimates how the existing team served a client. It does not establish a cash saving when the client leaves. The CEO may decide to redeploy capacity, seek replacement work or consider a staffing change. Each response needs its own timing, obligations and cost assumptions.

Contract notice, service transition and final billing can extend the effect. Confirm what the agreement requires and ask an appropriate adviser about legal questions. The admin manager should show the evidence rather than assume that every revenue and expense ends on the same date.

4Collection delays and cash exposure

A loss of future service revenue and a delay in collecting an existing invoice are different events. The first changes future earnings under the contract assumptions. The second changes receipt timing. An invoice that is no longer collectible may also require an accounting allowance or write-off under the applicable policy.

A cash forecast estimates dated receipts, payments and balances. Test a collection delay by moving the expected receipt to a later supported date while keeping the other obligations unchanged. The final balance may recover after the payment arrives, while the earlier cash balance falls. The CEO needs the lowest balance and its date to decide whether action is required.

The supplied October 6 receivables balance is $128,891.43, and reported bank balances total $312,490.80. Those aggregates do not identify the age of invoices, the largest debtor or available cash after commitments. The company bills on the first day of the month. Obtain the aging and dated payment records before concluding that the balance represents a collection problem or a cash reserve.

Concentration in receipts can matter even when revenue is diversified. If several major clients pay in the same week, a common delay can affect payroll funding. Identify the significant expected receipts and test realistic timing changes. Do not simply remove a percentage of every receipt unless the CEO has chosen that explicit stress assumption and understands its limits.

5Growth delays and capacity steps

Growth can add revenue, related licenses, onboarding costs and employee commitments. A scenario should change the linked inputs together. If a new client starts later, move both the revenue start and the relevant per-client costs. Keep staffing costs at the dates already committed unless the business can actually change them.

Practice example: after the lost-client scenario above, the business considers $6,000 of new monthly revenue. The new work requires $1,200 of additional non-labor direct cost and fits within existing capacity. The additional contribution is $4,800, raising operating profit from negative $1,000 to positive $3,800. The exercise assumes no additional payroll or overhead.

If the same work instead requires an employee costing $6,000 monthly, the result becomes negative $2,200. The new revenue is unchanged, but the capacity assumption changes the cost. The CEO needs evidence that the work fits existing capacity before accepting the first result.

A later start can produce an interim funding need even when the steady monthly result is positive. The hire may begin before service revenue or collections. Initial onboarding and equipment payments may also occur early. Show the monthly operating results and the weekly cash effect separately. A profitable eventual month does not demonstrate that earlier obligations can be funded.

A sensitivity test can help identify which input deserves better evidence. Change the user count, price, start date or delivery hours one at a time. Describe the tested range as an assumption. The result indicates dependence on that input, rather than the probability that the input will take a particular value.

6Response options and decision timing

A response option is a practical action the business could take under the scenario. Compare each option with the same event, cost basis and time horizon. The CEO may consider replacement sales, a scoped service change, a delayed purchase, an agreed supplier adjustment or financing. An option should include what must happen before it can produce the modeled benefit.

A trigger is a specified condition that prompts a review or approved response. The business selects the trigger from its actual obligations. Examples could include a renewal decision date, a supported collection delay or a capacity condition. Keep the action owner and the last useful decision date visible.

Some responses need lead time. Recruiting an employee, obtaining credit or selling an asset may take longer than a short forecast gap allows. The CEO should compare the date the problem occurs with the date the option can produce an effect. If an option depends on someone else's approval, show that dependency explicitly.

Do not add several response benefits without checking whether they can occur together. Delaying a hire while assuming the same delivery capacity can produce an inconsistent scenario. Selling equipment while assuming unchanged use of that equipment can do the same. Read the changed assumptions as one business story and remove combinations that cannot reasonably coexist.

7Client loss scenario practice

Use the hypothetical monthly baseline of $50,000 revenue, $30,000 direct costs and $15,000 overhead. The departing client provides $8,000 of revenue and $2,000 of immediately avoidable vendor costs. No other costs change. Replacement work could add $6,000 of revenue and $1,200 of non-labor direct costs.

1. Calculate baseline operating profit and the lost-client result.
2. Calculate the replacement-work result using existing capacity.
3. Add a $6,000 employee cost if replacement work requires new capacity.
4. Calculate recurring-revenue concentration using $8,000 client revenue and $40,000 company recurring revenue.
5. Write an evidence request for each cost that the scenario assumes can change.
6. List the separate inputs required to estimate the cash effect.

8Your company scenario review

The admin manager prepares a reconciled client-revenue schedule and the current operating and cash forecast versions. Keep client identifiers and commercial details in the approved restricted workspace. The CEO chooses one important uncertainty to test, such as a renewal, a collection, a proposed hire or a client start.

Prepare a baseline and at least one coherent alternative. Show changed assumptions, resulting operating profit, lowest cash and the evidence supporting each change. Identify costs that cannot be reduced on the scenario's timetable. If the contract or vendor terms are unknown, label the cost saving pending confirmation rather than presenting it as available.

The CEO reviews the practical response options and selects the next evidence or approval step. Record the trigger, responsible person and last useful decision date chosen for the business. The deliverable is a scenario comparison with a concentration definition, an assumption register and a decision plan. The admin manager should be able to explain the calculations without making the major business decision alone.

9Going deeper

10The completed work

A baseline and scenario comparison with concentration definitions, sourced assumptions and a CEO decision plan.

Keep approved company work in your finance workspace. The course records study progress in this browser; it does not store your reports or forecast files.

11Quiz

1. A client has $8,000 of recurring revenue and the company has $40,000 of recurring revenue under the same definition. What is concentration?

   A.16% using a separate total-revenue denominatorB.25% calculated against the remaining clientsC.$32,000 after subtracting the client amountD.20%
   Answer

   Label the period and recurring-revenue definition for both numerator and denominator.

   Check answer
2. A client leaves with $8,000 of monthly revenue. Only $2,000 of costs can stop immediately. What is the immediate monthly profit reduction?

   A.$6,000B.$8,000 with all cost assumptions omittedC.$2,000 equal to the vendor savingD.The client's allocated payroll cost added to revenue
   Answer

   Use costs that can actually change under the decision and timing being tested.

   Check answer
3. The model removes a client's allocated labor after departure, but payroll continues unchanged. What should be corrected?

   A.Add the lost revenue back to the baselineB.Keep payroll in the company forecastC.Treat existing employee pay as a future client receiptD.Reduce overhead by the same allocated labor amount
   Answer

   Company costs should change only when the underlying obligation changes.

   Check answer
4. A large receipt is delayed two weeks but arrives within the forecast horizon. Which effect needs review?

   A.The permanent loss of all contracted revenueB.The immediate elimination of supplier obligationsC.The lower interim cash balanceD.A higher operating margin caused by the delayed cash
   Answer

   Review the lowest cash balance and date, even when ending cash is unchanged.

   Check answer
5. Replacement work adds $6,000 revenue and $1,200 non-labor cost. It also requires a $6,000 employee. What is the added monthly operating effect?

   A.Positive $6,000 using only the revenue lineB.Positive $4,800 excluding the required employeeC.Zero because employee cost equals revenueD.Negative $1,200
   Answer

   Link the growth assumption to all costs required to deliver the new work.

   Check answer
6. A scenario delays a hire while keeping the same capacity that required the hire. What should the reviewer do?

   A.Resolve the inconsistent capacity assumptionB.Accept the result because lower payroll improves profitC.Average the hiring and non-hiring resultsD.Remove the baseline so the two versions cannot be compared
   Answer

   Check whether the changed staffing, workload and delivery assumptions can occur together.

   Check answer

12Glossary

Scenario

A coherent set of changed assumptions used to explore a possible outcome.

Baseline

The starting set of amounts and assumptions used for a comparison.

Sensitivity test

A test changing one input while keeping the other stated inputs unchanged.

Client concentration

The share of a defined business measure attributable to one client or group of clients.

Avoidable cost

A cost the business can actually stop or reduce under a specified decision and timing.

Response option

A practical action the business could take under a specified scenario.

Trigger

A specified condition prompting a review or approved response.

Last useful decision date

The latest date an action can be chosen in time to produce its required effect.

Probability-weighted forecast

A forecast combining possible outcomes using assigned probabilities.

Collection delay

A change that moves an expected customer cash receipt to a later date.

13Sources

Company examples use the accrual reports supplied on October 6, 2026. Report periods, selected totals and limits are recorded in the company reference. Examples labeled practice use hypothetical inputs.

• OpenStax: Contribution margin: Revenue and cost relationships supporting scenario calculations.