Examples
Examples
Try the starting example
- Disjoint merit cells: name, included staff, comparable payroll $, proposed raise %
- A,10,10000,5 B,20,20000,3
- Available raise budget ($)
- 1000
- Unscaled requested raise cost by cell ($)
- A: 500.00; B: 600.00
- Funded raise cost by cell ($)
- A: 454.55; B: 545.45
- Total funded cost ($)
- $1,000.00
- Unspent budget ($)
- $0.00
- Uniform scaling factor before cent allocation
- 0.909091
- Funded raise cost/total included payroll (%)
- 3.333333
Try another scenario
- Disjoint merit cells: name, included staff, comparable payroll $, proposed raise %
- A,10,10000,5 B,20,20000,3
- Available raise budget ($)
- 1200
- Unscaled requested raise cost by cell ($)
- A: 500.00; B: 600.00
- Funded raise cost by cell ($)
- A: 500.00; B: 600.00
- Total funded cost ($)
- $1,100.00
- Unspent budget ($)
- $100.00
- Uniform scaling factor before cent allocation
- 1
- Funded raise cost/total included payroll (%)
- 3.666667
Calculation method
Calculation method
Unscaled requested raise cost by cell ($)
Round each cell payroll×supplied raise percentage to US cents.
Funded raise cost by cell ($)
If over budget allocate budget US cents proportional to rounded cell requests, largest remainder with input-order ties; otherwise fund requests.
Total funded cost ($)
Sum funded cell amounts.
Unspent budget ($)
Budget−funded total.
Uniform scaling factor before cent allocation
min(1,budget/request total); one when no request cost.
Funded raise cost/total included payroll (%)
Funded cost/total supplied payroll×100.
Symbols and units
- a
- Disjoint merit cells: name, included staff, comparable payroll $, proposed raise %
- b
- Available raise budget ($)
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
- An aggregate supplied-matrix budget calculation. Cell labels, proposed raises and eligibility are external inputs; aggregate cell funding is not an individual employee raise allocation.
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
ILO: supplied workforce records and full-time-equivalent measurement background ↗
Background reading; this does not imply endorsement or independent review of SumFizz.