Support refund approval workload calculator

Calculate request count by supplied approval tier and review workload by tier with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use request count by supplied approval tier and review workload by tier to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Requests: ID, requested refund $
A,50 B,200 C,500
Amount tiers in order: level, inclusive ceiling $ or none for final, minutes per request, reviewers
L1,100,5,1 L2,none,15,1
Minutes available per reviewer this period
20
Request count by supplied approval tier
L1: 1; L2: 2
Review workload by tier (minutes)
L1: 5; L2: 30
Requested cash exposure by tier ($)
L1: 50.00; L2: 700.00
Review-minute shortage by tier
L1: 0; L2: 10
Total review workload (minutes)
35

Try another scenario

Requests: ID, requested refund $
A,50 B,200 C,500
Amount tiers in order: level, inclusive ceiling $ or none for final, minutes per request, reviewers
L1,100,5,1 L2,none,15,1
Minutes available per reviewer this period
40
Request count by supplied approval tier
L1: 1; L2: 2
Review workload by tier (minutes)
L1: 5; L2: 30
Requested cash exposure by tier ($)
L1: 50.00; L2: 700.00
Review-minute shortage by tier
L1: 0; L2: 0
Total review workload (minutes)
35
Calculation method

Calculation method

Request count by supplied approval tier

Assign each amount to the first inclusive ceiling it meets; the final tier must be unbounded.

Review workload by tier (minutes)

Tier count×supplied minutes per request.

Requested cash exposure by tier ($)

Sum requested amounts assigned to each tier, without treating them as approved credits.

Review-minute shortage by tier

max(0,tier workload−reviewers×available minutes).

Total review workload (minutes)

Sum tier workloads; an assignment is not a real approval.

Symbols and units
a
Requests: ID, requested refund $
b
Amount tiers in order: level, inclusive ceiling $ or none for final, minutes per request, reviewers
c
Minutes available per reviewer this period

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • A requested-refund workload categorization under supplied amount limits. It does not determine refund rights, assign authorized approvers or approve or pay any request.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

Zendesk: response metrics and business-hour definitions; this tool uses its displayed convention ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.