- Before
- Adjusts standing orders in spreadsheets and checks vault, truck and cutoff limits by hand before 3:00 p.m.
- Now
- Opens each route already sized and checked, reads why each machine changed, and sends the rest.
ATM cash forecasting for one route, from the forecast to the carrier's order file
Thursday, October 29, at Corvane National Bank. Marisol Brandt prepares Friday's run for Route 14 · Dayton East: Halvard Armored, truck 2, leaving the Dayton hub vault at 6:30 a.m. with 24 stops, 22 ATMs and 2 branch vaults, next visit Tuesday. The weekend has SSI paid Friday, Halloween Saturday and Social Security Tuesday. Here is what happens next, screen by screen, in the working solution.
- 01Thursday morning
Friday's routes, riskiest first, before the 3:00 p.m. cutoff
Marisol Brandt · Cash Operations AnalystMarisol's region has 6 routes and 131 stops for Friday. Route 31 needs a retry after the carrier portal timed out at 10:21 a.m.; Route 14 is ready for her with 4 exceptions; two routes are already with her manager and one is approved, its file sent. The agents' briefing since 6:00 a.m.: Friday's 6 routes carry $9.62 million against $12.38 million of standing orders, ATM 0417 would run out Sunday at 3:00 p.m., and the Challenger questioned 7 forecasts.
One button: “Prepare Route 14 · Dayton East”.
- 02Route 14
The whole run in one sentence, every figure cited
Forecast agent, Challenger agent, Limits agentThe agents propose $1,840,000 for Route 14, $770,000 less than the standing order of $2,610,000. The Forecast agent puts demand to Tuesday at $1.62 million, 18% above last week. The Challenger questioned 2 machines. The Limits agent notes that on the standing order the route would need a second truck, $1,150, and the Kettering Avenue vault would sit at 99% of its limit.
“It fits one truck under the carrier's $2.5 million limit, and the Dayton hub vault stays at or under $3.18 million this week, inside its $3.5 million insurance limit.”
- 03One line per stop
Each change from the standing order, with its reason
Load plannerEvery ATM and branch vault sits on one line in stop order: cash now, days of cash against Tuesday's visit, the proposed load by denomination, the standing order and the change. ATM 0402 at the Kettering Ave drive-up gets $82,000, not $120,000: it returned $41,800 unused on average over its last 6 visits. The Kettering Avenue branch vault gets $96,000 in six denominations, not $180,000, because its tellers need $88,000 in $1s to $50s and the vault already holds $412,000, mostly $100s.
- 04ATM 0417
The hospital ATM that would run dry on Sunday
Marisol Brandt · Cash Operations AnalystATM 0417 in the Halloway Medical Center lobby has $31,260 and 1.2 days of cash. Marisol opens its line in place: on the $80,000 standing order the curve hits zero Sunday at 3:00 p.m.; the agents' $120,000, all in twenties, reaches the Tuesday 7:40 a.m. visit. If she disagrees, she changes the load with a reason and the Load planner and Limits agent recheck it.
“Hospital payday moved to Wednesdays; on the standing order it runs out Sun 3:00 p.m.”
- 05Why $106,000
The drivers add up to the forecast
Forecast agent and Challenger agentSame four days over the last 8 weeks: $76,600. The hospital's payday, moved to every other Wednesday, adds $16,400; SSI on Friday $5,300; Halloween $6,100; Social Security on Tuesday $1,600. The Challenger found the payday after two Wednesday misses: $13,900 forecast against $20,700 actual on October 14, and $14,200 against $21,860 on October 28. $120,000 leaves $14,000 at the visit, above the $12,000 safety stock.
- 066:00 to 10:30 a.m.
How the route was built, step by step
The agentsTen steps, each with its agent's version, sources and confidence. The Challenger found 20 of 22 machines within 15% of yesterday's forecast and left ATM 0452's overnight spike, $48,800, out of demand with a referral to Fraud Operations. ATM 0461 is out of service, so the crew loads it only if it is repaired. ATM 0498, installed in September, has a confidence of 64%, under the 70% threshold, so a person must confirm its load.
The referral's outcome is not shown in the solution.
- 07The limits
Every vault through the week, not one number
Limits agentThe Dayton hub vault peaks at $3.18 million on Thursday and holds $3.13 million on Monday after the Federal Reserve order, against its $3.5 million insurance limit; sized for standing orders it would reach $3.78 million. Monday's $2,300,000 Federal Reserve order, 95 bundles of $20s and 4 of $100s, does not cross-ship: the fit $20s went in on Tuesday, October 27, and the order falls in a new business week.
- 0810:42 a.m. · 10:52 a.m.
She sends it; her manager approves with one button
Marisol Brandt and Owen TaggartMarisol sends Route 14 to Owen Taggart, Cash Operations Manager, with the exceptions and her changes summarized. Owen opens the same route and approves $1,840,000 for 24 stops after one check line: one truck, the Dayton hub vault at or under $3.18 million, every ATM under $200,000, the file before the cutoff. Had he changed a load, the approval would have gone to the Head of Cash Operations instead.
“The Federal Reserve order for Monday stays a separate approval.”
- 09Accepted
Only then does the carrier order file go
Order file agentWith both approvals in, the Order file agent sends order file HLV-1030-14 to Halvard Armored and the carrier portal accepts it: 24 stops, one line per machine by denomination, ATM 0461 marked to load only if in service. It drafts Friday's cash-in-transit entry for the general ledger. No card or account data is in the file, and it is kept five years.
- 10On the record
Every forecast, change and approval, for the examiner
Helen Marsh · Internal AuditThe trail shows Owen's approval with the 4 exceptions he reviewed, Marisol's send, the 10:30 a.m. refresh, the ATM 0452 exclusion and the accepted file, people and agents side by side. Internal audit filters and searches it, and exports an audit pack for an examiner with redaction and a checksum.
“Records are append-only.”