Examples
Examples
Try the starting example
- Agency placements: ID, annual salary $, fee %, extra fixed fee $, start date, actual exit or none, supplied guarantee days, rebate % of full fee
- A,100000,20,0,2026-10-01,2026-10-15,30,50 B,80000,15,1000,2026-10-01,none,30,100
- Audit date
- 2026-10-20
- Full supplied fee by placement ($)
- A: 20000.00; B: 13000.00
- Date-eligible modeled rebate by placement ($)
- A: 10000.00; B: 0.00
- Total supplied fees for started placements ($)
- $33,000.00
- Started fees less modeled date-eligible rebates ($)
- $23,000.00
- Maximum supplied rebates for still-active placements in guarantee window ($)
- $13,000.00
Try another scenario
- Agency placements: ID, annual salary $, fee %, extra fixed fee $, start date, actual exit or none, supplied guarantee days, rebate % of full fee
- A,100000,20,0,2026-10-01,2026-10-15,30,50 B,80000,15,1000,2026-10-01,none,30,100
- Audit date
- 2026-11-05
- Full supplied fee by placement ($)
- A: 20000.00; B: 13000.00
- Date-eligible modeled rebate by placement ($)
- A: 10000.00; B: 0.00
- Total supplied fees for started placements ($)
- $33,000.00
- Started fees less modeled date-eligible rebates ($)
- $23,000.00
- Maximum supplied rebates for still-active placements in guarantee window ($)
- $0.00
Calculation method
Calculation method
Full supplied fee by placement ($)
Round salary×supplied fee percent, then add fixed fee.
Date-eligible modeled rebate by placement ($)
For a started placement with actual exit on/before audit and elapsed exit days≤guarantee days, apply supplied rebate percent to full fee.
Total supplied fees for started placements ($)
Sum full fees for start dates on/before audit.
Started fees less modeled date-eligible rebates ($)
Subtract date-eligible modeled rebates; no real refund is assumed.
Maximum supplied rebates for still-active placements in guarantee window ($)
For started placements not exited at audit and audit≤start+guarantee, show full fee×rebate percent as a contingent maximum, not an expected credit.
Symbols and units
- a
- Agency placements: ID, annual salary $, fee %, extra fixed fee $, start date, actual exit or none, supplied guarantee days, rebate % of full fee
- b
- Audit date
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 supplied agency-fee and guarantee-date scenario. Date eligibility alone does not establish a contractual entitlement; all conditions, rebate bases and fees must be supplied and independently approved. No refund or accounting entry is made.
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.