← An AI Project, End to End
Module 2 Free 6 min

The CIO: Where the Money Goes

Daniel has $600k, seven teams asking for $1.1m, and no idea why customers are leaving — so he funds the two things that can answer that question and tells marketing no.

What you'll learn

  • Translate a falling revenue number into priorities, and tell symptoms from root causes
  • Read a customer's lifetime value against what it cost to win them, in plain English
  • See how one budget split quietly sets the limits for eight people over the next six months

It is 8:30 on a Monday and Daniel, Northwind’s Chief Information Officer, is the last person to speak in a meeting already forty minutes old. Sales has blamed the product. Product has blamed the March price rise. Marketing has asked, twice, for a bigger discount budget. Everyone is confident, and no two of them are confident about the same thing.

Then the CEO turns to him. “You keep telling us we should be smarter with our data. You have $600k. Show me.” Daniel now owns the most consequential desk in this course, and the reason has nothing to do with technology. He will not choose a single tool this week. He will choose which capabilities exist for the rest of the project — and what everybody after him can and cannot do is about to be settled in a spreadsheet with seven rows in it.

THE BOARD−15% revenue, $600k, 26 weeksDANIEL — CIOTurns a decline into prioritiesOMAR — FINANCEMandate + $325k ceiling

A number and a pot of money go in; a written mandate and a hard spending ceiling come out. No technology is chosen at this desk.

What lands on Daniel’s desk

Four facts, four theories, and no shared version of the truth.

The board hands over less than it thinks. Revenue booked $11.3m last year and is tracking to $9.6m, a fall of about 15%. Churn — the share of customers who cancel in a year — has doubled from 9% to 18%, which on 400 accounts is about 36 extra departures, and at an average contract of $24k a year that is some $864k of recurring revenue which will not repeat. The ratio the board watches most closely, lifetime value against acquisition cost, has slid from about 7:1 to 4:1.

What does not land on his desk is any explanation. Nobody can name the accounts that left, or say whether they went over price, or the export feature that broke in March, or onboarding that quietly stopped working. Four theories, zero shared facts. The board has also fixed two constraints before Daniel says a word: $600k, and 26 weeks. Both are still binding in module 12 when someone asks whether it worked.

What a CIO actually does

The job is not choosing software. It is deciding which problem the company is allowed to spend money on.

People assume the CIO’s day is spent picking systems. In a well-run company it is closer to the opposite: the CIO translates a business problem — “revenue is falling” — into priorities before anyone writes a line of code, then defends those priorities against six executives who each arrived with a solution already in mind.

The core skill is telling a symptom from a root cause. Cancellations are the symptom; they are what you can see. The root cause is whatever produces them, and at Northwind that is genuinely unknown. This sounds academic until you notice what it does to spending: every proposal on the table — discounts, more salespeople, a product rebuild — is a solution to a cause somebody has assumed. Buying one means betting $600k on a hunch and finding out in month nine.

The four numbers on Daniel's page

Churn
The share of customers who cancel in a year. Northwind’s has doubled, from 9% to 18%, and that doubling makes everything else on this page worse.
CLV
Customer Lifetime Value — the profit one customer produces before they leave. Here: $24k a year at 75% gross margin is $18k of profit a year; divide by 18% churn and the average customer is worth about $100k. At 9% churn they were worth double.
CAC
Customer Acquisition Cost — what sales and marketing spend to win one customer. At Northwind, about $25k.
CLV:CAC
Lifetime value divided by acquisition cost. It was around seven to one; it is now about four. Nothing about how Northwind sells has changed — customers simply leave sooner, so there is less life to be valued.

That last line is the one Daniel repeats all week: Northwind has not got worse at winning customers, it has got worse at keeping them — and you cannot discount your way out of that, because a discount lowers the $24k too.

The software on Daniel’s desk

A CIO’s tools are not technical. They are queues, portfolios and one slide.
ServiceNowForty asks, one queueEvery department's requestlands in the same place, soasks compete on merit.Power BIWhat is already runningThe portfolio: what is live,what it costs, what is late.The context for every yes.ExcelThe split itselfSeven pots, $600k, and acolumn that has to totalexactly the budget.PowerPointThe one-slide caseFunding decisions travel asslides: the problem, theask, the expected return.

Forty asks arrive in a queue; one slide leaves with a decision on it. Everything between is comparison.

None of Daniel’s software is clever, and that is the point. ServiceNow — an IT service management tool, essentially a shared queue with rules — matters because it puts every department’s request in one list. When the asks sit side by side, they compete on merit rather than on who caught the CIO at the coffee machine. The $1,100k of requests against $600k of budget is visible as a fact rather than a feeling.

The Power BI portfolio view supplies the context that makes a “no” defensible: what is already running, what it already costs, and which teams are already committed. Then the actual allocation happens in Excel, because it always does, and travels to the board as a PowerPoint slide, because funding decisions are made by people reading one page. If you take one thing from this desk, take that: the most consequential decision in the whole course is made in a spreadsheet and communicated in a slide.

The software on this desk

ServiceNow
An IT service management tool. Here it is the queue every department’s request lands in, so competing asks can be compared rather than lobbied for.
Power BI
Microsoft’s reporting tool. For a CIO it shows the portfolio — every live project, its cost and its status — which is the context every funding decision is made in.
Excel
Where the allocation is actually built and re-built. Unglamorous, and still the tool behind most large financial decisions.
PowerPoint
How the decision travels. A funding case that cannot fit on one page usually has not been made yet.

The decisions Daniel makes this week

Three decisions, taken in a fortnight, that eight people will still be living inside in November.

Deciding what the project is actually for

Before a penny moves, Daniel writes one sentence: the objective is not “reduce churn”, it is “find out which customers are leaving, why, and early enough to act — then act”. The target he attaches is churn back toward 9% within a year.

This looks like semantics and is not. “Reduce churn” is an outcome anyone can claim credit for; a good quarter would satisfy it. Daniel’s version names a mechanism, and a mechanism can be funded, tested and disproved. It also carries an assumption he writes down, because an unstated assumption is what kills a project quietly: we believe customers about to leave behave differently, visibly, in time to be saved. If that is false, the project should stop. Ben tests it in module 6, finding that leavers’ logins slide for about ten weeks before they cancel — and it is only because Daniel wrote the assumption down that anyone recognises the answer when it arrives.

Splitting $600k across $1.1m of asks

The asks, in full

Product engineering wants $250k, marketing incentives $200k, customer success $150k, data infrastructure $200k, AI and analytics $150k, employee training $75k, cybersecurity and governance $75k. That is $1,100k of want against $600k of money.

This is where opportunity cost stops being a textbook phrase. Every dollar Daniel puts in one pot is a dollar that is not in another, and because he is $500k short, funding anything properly means telling somebody no to their face. The temptation — enormous, because these are colleagues he sees at lunch — is to give everyone roughly 55% of what they asked for. Nobody storms out. Nobody is singled out.

And nothing works. Half a data platform is not half as useful as a data platform; it is pipelines that break on Tuesdays and a customer table two teams do not trust. An even split funds seven half-capabilities and buys none of them, which is why the sharpest thing to know about this desk is that an even split is not a compromise, it is a refusal to decide — and the refusal is paid for by whoever inherits the half-built thing, with no budget left to fix it.

So Daniel applies a harder rule: fund the smallest number of things to the level where they work, say no clearly to the rest, and write down what has to be true for the outcome to happen. Here is where he lands.

Data infrastructure, $175k, and AI and analytics, $150k, funded close to their asks because they are the only pots that answer the question why. Everything else on the list responds to an answer nobody has yet. Deliberately, this is the largest commitment in the split: $325k combined.

Product engineering, $100k. Not the $250k asked for — that was a roadmap wrapped around a bug fix — but enough to pay down the March release properly, including the export feature Corvex Manufacturing has raised 23 tickets about.

Customer success, $75k, half the ask: enough to add retention capacity, not enough to hire the way they wanted before anyone knows which accounts are worth calling.

Employee training, $50k, and governance, $50k. Small amounts, and Daniel protects them first rather than last. They are cheap insurance — and cheap insurance is always what gets trimmed at the end of a budget meeting, by people who will not be there when the claim is made.

Marketing incentives, $0.

Telling marketing no

The discount budget is the hardest conversation, because the case for it is genuinely good: it produces revenue this quarter, and this quarter is on fire. Daniel refuses it anyway, and his reasoning is worth borrowing.

A blanket discount cannot tell who it is talking to. It retains the customers who were leaving over price — the Fenwick Retails of the base, demanding 30% off — and hands the same money to everyone who was staying anyway, which is most of them. Subsidising the majority to save a minority is arithmetic that only works if you never do the arithmetic. Worse, it treats the symptom so well that it hides the cause: renewals tick up, and nobody learns why March broke.

What Daniel says to marketing is not “never” but “not until we know who” — a different sentence, and the one that keeps a colleague on side while still refusing them $200k.

The trap in this room

Spending on a symptom is seductive because it works immediately and stops working invisibly. Discounts, win-back offers and emergency hires all produce a number this quarter. None produce an explanation — so none stop the problem returning next year, on a worse margin.

Where this goes wrong

Nobody ever decides to fund seven things badly. It happens by consensus.

In real companies the failure is almost never a wild bet on the wrong technology. It is the polite version: the budget is spread evenly, and the CIO leaves the room having offended no one and committed to nothing. Six months later the data platform is unreliable, the model built on it is not trusted, the support team was never trained to read the output, and the governance review has no capacity, so it takes three weeks in the worst possible month. Each is a small underfunding. Together they are a failed project, and no single decision looks like the cause.

The second failure is quieter: choosing the technology first. Buy a well-reviewed retention platform in week two and every question after that gets answered in terms of what that platform happens to do. Northwind has chosen nothing yet — not indecision, but the correct order.

What Daniel hands on

One page, to Omar in Finance, with a number on it that binds everyone downstream.

The deliverable is a strategic mandate: the problem stated plainly, the target outcome (churn back toward 9%), the $600k split, the measures of success, and the written assumption that leavers can be spotted early enough to save. It goes to Omar, the Finance Business Partner, with one question attached — before we build anything, is this worth the money?

Watch what travels with it, because this is the rope, not the relay. The $325k of data and AI money is now the hard ceiling on the spending envelope Omar can approve in module 3; he can approve less, never more. The $50k of training money decides how many accounts Jade’s operations team can work through each week in module 11 — a ranked list of at-risk customers is worth nothing if nobody has been taught to read it. The $50k of governance money decides whether Elena’s risk review in module 9 is a one-week formality or a three-week scramble. And the $100k of product money decides whether, when Corvex Manufacturing’s broken export surfaces again in module 11, there is a real fix to escalate to — or only an apology.

Daniel has just done the most consequential thing in this entire project, and no technology was involved.

The bottom line

A CIO’s real instrument is allocation, not technology: Daniel funds data and AI to $325k because they are the only pots that answer why, protects training and governance as cheap insurance, funds a product fix, and tells marketing no — because discounts pay the customers who were staying anyway. An even split is a refusal to decide, and the refusal is paid for downstream by people who cannot see who signed it.

Spot the decision

Read each situation, decide what a good CIO does and why, then tap a card to flip it.

Quick check

1. Why does Daniel fund data infrastructure and AI ahead of everything else?

2. What does the combined data and AI figure of $325k determine downstream?

3. The course calls an even budget split "a refusal to decide". Why?