All scenarios

Custom architectural sign fabrication and installation · fictional example

Cedarline Signworks

USD 1.728M annualized revenue · 13 staff including owner · Toledo, Ohio

Cedarline Signworks is a fictional sign shop producing 48 completed jobs per month: 24 standardized jobs for a property-management group and 24 custom jobs for independent businesses. The property-management account demands priority scheduling, pays slowly, and appears unprofitable after overhead allocation, prompting the owner to consider dropping it. Meanwhile, finishing and assembly are nearly full, so accepting more work could simply create longer queues. All financial figures and operating capacities below are illustrative assumptions, expressed in USD and per month unless stated otherwise; annualized revenue assumes 12 identical months.

The owner's question

Should the owner retain and renegotiate the property-management account, replace it gradually, or expand capacity—and which option would improve profit without creating a cash or delivery crisis?

What the analysis finds

The account contributes cash toward fixed costs despite its allocated loss

The property-management account generates $48,000 revenue from 24 jobs at $2,000 each, less $30,000 of direct, avoidable costs, leaving $18,000 contribution, or 37.5%. Independent customers generate $96,000 from 24 jobs at $4,000 each, less $42,000 of direct, avoidable costs, leaving $54,000 contribution, or 56.25%. Direct costs comprise purchased materials, outsourced components, job freight and consumables; regular employee payroll is excluded because it remains payable if volume falls. Total revenue of $144,000 minus $72,000 direct costs and $60,000 fixed payroll and overhead leaves $12,000 operating profit, an 8.3% margin, before interest and tax. Allocating half the fixed costs to each segment makes the property account show a $12,000 accounting loss, but dropping it without replacement or fixed-cost reductions would reduce company operating profit to a $6,000 loss.

Finishing is tight, but installation limits the eventual upside too

Each property-account job consumes 2 artwork hours, 8 fabrication hours, 10 finishing/assembly hours and 8 installation hours; each independent job consumes 3, 12, 12 and 10 hours respectively. Current monthly loads are therefore 120, 480, 528 and 432 hours, against practical staffed capacities of 140, 560, 540 and 480 hours. These capacity assumptions allow for normal setup, maintenance, travel and absence; job hours include routine rework. Finishing/assembly has only 12 spare hours, enough for one additional independent job. Even if finishing capacity increased, installation's 48 spare hours would limit additional independent work to four whole jobs before another constraint emerged. Weekly scheduling and simultaneous crew availability still require validation.

Slow collection creates exposure that contribution margins do not show

The property account receives no deposit and pays 60 days after completion, creating approximately $96,000 of steady-state receivables at $48,000 monthly billing. Independent customers pay 50% before production and the balance at completion, so their completed jobs create no continuing receivable under the assumed collection pattern. Direct-cost suppliers are paid 30 days after purchase, while payroll is paid during the month. Stable collections eventually match $144,000 monthly revenue, but growth or late payment can consume cash first. The $96,000 receivable is not a complete working-capital requirement: supplier credit, customer deposits, work in progress and payment dates must also be modeled.

The moves we'd make

Test revised account economics before terminating it

At renewal, test a $250 increase per property-account job alongside defined approval deadlines, consolidated installation windows and separately approved change orders. If all 24 jobs remain and direct costs are unchanged, the price change would add $6,000 monthly contribution; that is a scenario, not a forecast. Measure acceptance, actual job hours and rework before assuming the improvement is durable.

Replace contribution gradually, not revenue blindly

Each independent job currently contributes $2,250, so eight additional jobs would replace the property's $18,000 monthly contribution if the account ended entirely. Those eight jobs require 24 artwork, 96 fabrication, 96 finishing/assembly and 80 installation hours, all within the capacity released by removing the 24 property jobs. Test whether that demand can be won at the assumed price and cost, including any incremental selling expense, before giving notice. Separately pilot cross-training and finishing batch schedules; verify their effect on quality and downstream installation queues rather than promising capacity gains.

Negotiate cash terms and track the transition weekly

Test a 30% deposit on new property-account orders, equal to $14,400 for one month's assumed volume, and seek a shorter balance-payment term. Deposits change cash timing, not revenue or profit, and existing receivables will still collect on their original schedule. Build a rolling 13-week cash forecast covering receivable runoff, deposits, supplier bills, payroll and any replacement-job ramp. Review stage-level backlog and promised installation dates weekly before releasing additional work.

Tools that would do this work

This company and its numbers are invented for illustration.