AI FTE Savings Calculator

📊 Input Parameters (Adjustable)

% of time BO assistant devotes to processing invoices: %
Workload AI can take away: (0 to 1)

📋 Fixed Parameters

Parameter Value Description
Invoices per day (1 BO assistant) 29 Average number of invoices processed daily
Device lines per day (1 BO assistant) 200 Average number of device lines processed daily
Target FTE savings 2 Number of FTEs to be saved
Working days per month 21 Standard working days

🎯 AI Processing Requirements

Metric Daily Monthly (21 days) Formula
Invoices AI must handle 70 1,470 =(29 × 2 × TimePercent%) ÷ AIWorkload
Device lines AI must handle 480 10,080 =(200 × 2 × TimePercent%) ÷ AIWorkload

📈 Calculation Breakdown

Step Calculation Result
1. Total capacity of 2 FTEs Invoices: 29 × 2 = 58/day
Lines: 200 × 2 = 400/day		 58 invoices, 400 lines
2. Effective capacity (time %) Invoices: 58 × 60%
Lines: 400 × 60%		 34.8 invoices, 240 lines
3. AI requirements Invoices: 34.8 ÷ 0.5
Lines: 240 ÷ 0.5		 69.6 invoices, 480 lines

🔍 Sensitivity Analysis

AI Invoices Required (Daily) - Two-Way Sensitivity Table

AI Device Lines Required (Daily) - Two-Way Sensitivity Table

💡 How to use this model:

  1. Adjust the % of time to see how different time allocations affect AI requirements
  2. Modify the AI workload reduction to test different AI efficiency scenarios
  3. The sensitivity tables show how results change across multiple parameter combinations
  4. Yellow highlighted cells in sensitivity tables show the current parameter combination