Automatable

A task performed by Financial Managers

Evaluate data pertaining to costs to plan budgets.

Red LightAI can do it · workers don't want it

Technically, much of it, experts rate AI capability 4/5, but workers don't want it automated (desire 2.67/5). It's an Automation Red Light: proceed with care.

Do you want this task automated?

Worker desire to automate2.7/5

How much the people who do this task want AI to take it over (avg of 6 workers).

AI capability today4.0/5

How capable experts rate current AI at this task (avg of 2 experts).

How much human involvement should stay?

The Human Agency Scale (H1–H5) captures how much human direction workers think this task should keep.

H3Equal human–AI partnership

Why workers feel the way they do

  • Helps handle larger scale50%
  • Frees up time for higher-value work33%
  • Reduces human error33%
  • It's repetitive17%
  • It's stressful17%

How to automate this

Doable with technology, but keep a person clearly in charge.

Analyzing & processing data

Let the spreadsheet or a BI tool do the math and the charts.

  1. 1Set up formulas and pivot tables once, so the numbers you need to evaluate data pertaining to costs to plan budgets recalculate themselves.
  2. 2Connect a free dashboard so reports refresh themselves (Looker Studio, Power BI).
  3. 3Use AI to summarise the findings, but keep the numbers in the spreadsheet.

Tools that can help

Excel / Google SheetsLooker Studio or Power BIAI assistant

Know a better way, or spot an error?

Share how you automate this in real life, or correct the data. Reviewed before publishing.

This is 1 of 9 tasks studied for Financial Managers, where workers want 44% of tasks automated.

More Financial Managers tasks

Other Red Light tasks