Manufacturing Cash Flow: How to Forecast and Manage It

Manufacturers carry cash at every stage: raw materials bought ahead, work in progress on the floor, finished goods in the warehouse, and customers taking 30 to 60 days to pay. The longer that chain, the more cash the business needs, and the faster it grows, the more cash it consumes. This playbook sets out the routines that keep a manufacturer’s cash under control. For how manufacturing cash flow works and a worked large-order example, see the manufacturing cash flow forecast page.

The weekly routine

1. Cash received from customers against forecast.
2. Purchase orders due for payment in the next eight weeks.
3. Production schedule against orders and inventory targets.
4. Overdue customer accounts and next actions.
5. Payroll, energy and loan payments due.
6. Cash balance and the lowest point in the next 13 weeks.

From production plan to cash plan

The cash forecast should be built from the operations plan:

1. Sales forecast by product and customer.
2. Production plan to meet it, with target inventory levels.
3. Material requirements from the production plan and bills of materials.
4. Purchase timing from supplier lead times, and payment timing from supplier terms.
5. Labour and overtime from the production schedule.
6. Customer receipts from invoice dates and real payment terms.

When sales or production plans change, the cash forecast changes with them. Finance and operations should review the plan together at least monthly.

Inventory targets

Set target days of inventory for each stage:

With cost of goods around $2 million a year (about $5,500 a day), inventory above target is tying up about $120,000. Review slow-moving and obsolete stock quarterly, and write down or clear it rather than carrying it forever. Warehouse space, insurance and handling all cost money for stock that isn’t selling.

Customer terms

Many manufacturers sell to distributors or larger customers who expect 45 to 60 days. Agree terms before the first order, check new customers’ credit, invoice on dispatch, and chase overdue accounts weekly. For large or custom orders, ask for a deposit or stage payments to fund materials. Credit insurance can protect against a major customer failing to pay.

Supplier terms

Negotiate terms that reflect your own cash cycle: 45 or 60 days on major materials, consignment stock for high-volume components, or staged payments on large orders. Pay on the due date rather than early, unless an early-payment discount is worth more than the cash.

Large orders

Before accepting a large order, forecast its cash profile: materials bought ahead, extra labour and overtime, and the customer’s payments on their real terms. The gap before the first payment is the working capital the order needs. If it’s more than the business can fund, negotiate a deposit, stage deliveries, or arrange funding before you commit. See cash conversion cycle.

Export and currency

Export customers often pay on longer terms and in other currencies. Forecast export receipts on their real timing, convert at a cautious exchange rate, and consider whether letters of credit, export credit insurance or currency hedging are appropriate for larger contracts. Imported materials bring the same issues in reverse, plus freight and duties.

Energy and maintenance

Energy is a significant and volatile cost for many manufacturers, and contract renewals can change it sharply. Forecast it from usage and current tariffs, and model a price increase. Planned maintenance is cheaper than breakdowns; keep a maintenance budget in the forecast and a reserve for major repairs.

Capital expenditure

New machines, tooling and facility upgrades are large and lumpy. Put them in the forecast in the months they’re paid, compare cash purchase with leasing or asset finance, and time purchases for when cash is strongest. Paying for a large machine from operating cash can leave too little for the materials it needs to run. A new machine that increases capacity also needs working capital for the extra output.

A worked quarter

A manufacturer with $220,000 of monthly sales wins a contract adding $60,000 a month from April. Materials are 38 percent of sales and bought a month ahead; the customer pays on 60-day terms. The forecast shows the extra working capital peaking at about $90,000 in May, when materials for April and May production are paid and the first payment hasn’t arrived.

The finance lead negotiates a 20 percent deposit on the first three months’ orders, asks the main supplier for 60-day terms on the additional volume, and trims finished goods inventory on slower lines by 10 days. Together, these release about $95,000, and the contract goes ahead without new borrowing.

Pricing and cost increases

When material or energy costs rise, the cash effect arrives quickly, while price increases to customers often take a quarter or more to agree and apply. Build price review clauses into longer contracts where you can, forecast the lag between cost and price changes, and model how much cash the gap needs.

Measuring the cycle monthly

Calculate days of inventory, customer payment days and supplier payment days every month from your accounting data, and chart them. A rising cycle is often the first sign of trouble, weeks before the bank balance shows it.

Warning signs

• Days of inventory rising at any stage
• Slow-moving stock growing
• Customer payment days lengthening
• Large orders accepted without a cash check
• Overtime and expediting costs rising
• Capital purchases paid from operating cash without a plan
• Customers asking for longer terms as a condition of new orders
• Suppliers shortening your terms or requiring payment on order

When cash gets tight

1. Reduce purchasing to match firm orders and target inventory.
2. Clear slow-moving finished goods.
3. Chase overdue customers and ask for deposits on new orders.
4. Negotiate supplier terms and staged payments.
5. Consider invoice finance or asset-based lending, with a clear plan.

Tools

The premium Manufacturing template includes a Customer Terms tab that converts invoices into collections, a Raw Materials tab that calculates supplier payments from sales and lead time, scenarios for a large order, and a dashboard. See also working capital explained.