Part 1 showed that an order at Example Windows Co. takes 66 days to become cash and that about $1.06 million sits in open orders. Part 2 gave you the model. This post uses it to decide what to fix first.
Six fixes, tested one at a time
Each fix was run in the simulator on its own for one simulated year. Everything else stayed at the starting settings.
Table 1. Effect of each fix on its own. Days are quote-to-cash days.
| Fix | Change | Days | Cash tied up | Cash freed | On time |
|---|---|---|---|---|---|
| Starting point | 66.3 | $1,061,000 | 80% | ||
| Invoice on delivery day | Invoice lag 5 → 0 days | 61.1 | $966,000 | $96,000 | 80% |
| Follow up overdue invoices | Late payment 10 → 3 days | 59.5 | $938,000 | $123,000 | 80% |
| Take a 30% deposit | Deposit 0 → 30% | 66.3 | $497,000 | $564,000 | 80% |
| Quote in one day | Quote turnaround 5 → 1 day | 62.1 | $1,062,000 | None | 83% |
| Halve the batch size | Batch 4 → 2 orders | 65.3 | $1,049,000 | $12,000 | 97% |
| Raise machine uptime | Uptime 90 → 95% | 65.7 | $1,053,000 | $8,000 | 90% |
What the results say
- Three fixes free cash, and all three are in the office. The deposit frees the most, about $564,000. Following up overdue invoices frees about $123,000 and invoicing on delivery day about $96,000.
- A faster quote saves days and frees no cash. Nothing has been spent on an order while it is being quoted. The value of a one-day quote is commercial. The model does not count orders won or lost, so it cannot show that gain.
- The factory fixes protect the delivery promise. Smaller batches lift on-time delivery from 80% to 97%, and better uptime lifts it to 90%. Neither moves much cash.
On-time figures within about 3 points of each other are the same result, because the simulation is random.
Rank the fixes by effort
Start with the fixes that cost the least and need no agreement from customers.
Table 2. Suggested order of work
| Order | Fix | Effort | What it takes | Owner |
|---|---|---|---|---|
| 1 | Invoice on delivery day | Low | Raise the invoice from the delivery confirmation. Capture proof of delivery on a phone. | Finance |
| 2 | Follow up overdue invoices | Low | Automatic reminders before and after the due date. One person owns the overdue list. | Finance |
| 3 | Take a deposit | Medium | New terms on quotes, applied to new orders first. Sales needs to explain the change. | Sales and the owner |
| 4 | Quote in one day | Medium | A price book and a product configurator, so a quote no longer waits for one estimator. | Sales |
| 5 | Halve the batch size | Medium | Shorter changeovers and scheduling by due date. | Production |
| 6 | Raise machine uptime | Higher | Planned maintenance and a log of every stoppage. See What OEE Really Measures. | Production and maintenance |
The office package
Fixes 1 to 4 together take quote to cash from 66 days to 50. Cash tied up falls from $1.06 million to about $386,000, which frees about $675,000. Adding the two factory fixes brings the total to 49 days, and every order in the simulated year arrives on time.
A deposit is the largest item and the hardest to win. Some customers will refuse it. Even a 10% deposit on new orders frees a useful share of the amount, and the simulator in Part 2 lets you test any level.
The payback
Freed cash is a one-time release, not profit. Its yearly value is the cost of that money: the interest on a credit line, or what the cash could earn elsewhere in the business.
Try it: payback on the cash you free
The starting values are the office package in this example, with an assumed 7% cost of borrowing and an assumed project cost of $60,000.
In the example, $675,000 at 7% is worth about $47,250 a year. A $60,000 project covering the invoicing change, reminders, a price book and a configurator pays back in about 15 months on interest alone. The cash released is about 11 times the project cost. Both the 7% and the $60,000 are assumptions. Use your own figures in the calculator.
Some of this work may qualify for government support. The funding finder lists current programs.
A 90-day plan
Table 3. What to do in the first 90 days
| Days | Work | Result to check |
|---|---|---|
| 1 to 30 | Record six dates for every order: request, quote, order, delivery, invoice and payment. Invoice on delivery day. Turn on payment reminders. | Invoice lag under 1 day |
| 31 to 60 | Put deposit terms on new quotes. Build the price book for the most common products. | Share of new orders with a deposit. Quote turnaround. |
| 61 to 90 | Try a smaller batch on one product family. Log every machine stoppage. | On-time delivery. Days sales outstanding. |
What the model leaves out
- Orders won or lost. A faster quote and a deposit both change how many customers say yes.
- Bad debts. Every invoice in the model is paid in the end.
- Weekends and holidays. The model runs every day.
- Your own mix. The example has one product at one price. Real orders vary in size, margin and terms.
Takeaway. Fix the office first. In the example, four changes that need no new equipment cut quote to cash from 66 days to 50 and free about $675,000. Then use smaller batches and better uptime to protect the delivery promise.
Example Windows Co. and its figures are an illustrative example. The days and dollars come from a simulation model with round-number inputs, and they do not describe any real company.
