pandahr

Underwriting Workflow

⌘K
Auditor Avatar

Apex Horizon Manufacturing

Outputs ready
Rate Source Market Carrier
Default state filings applied to CA jurisdiction.
Carrier Fade Factor
Not used by this carrier
Carrier rates without a fade factor.
Experience Mod (EMOD)
Carrier rates at 1.00 — X-Mod 1.57 for reference
Hierarchy: Worksheet (Won) → ACORD → 5-Yr History → Manual
Audited Payroll Edit Class Lines ↗
$2,242,000 in force 3 Classes • 29 Lives
CA jurisdiction basis • Effective Rate: 5.51%
01

Carrier Manual Premium

3/3 Mapped
$123,450

Sum of audited base manual rates across active classes

4828 CA Soap or Synthetic Detergent Mfg.
$1.67M × $5.82 × 1.25
$121,493
8810 CA Clerical
$298k × $0.36 × 1.25
$1,341
8871 CA Telecommuter
$274k × $0.18 × 1.25
$617
Manual territory mod: 1.25 (4) Rates in Sync
02

Loss Projection

Uniform prior
$101,192

Actuarially selected baseline frequency & severity model

Funded Aggregate
$49,380
Loss fund • 40% of carrier
Loss Shortfall
$51,812
Rolls into premium
Actuarial Model: Uniform prior
Credibility Weight (Z): 0.20 (Low)
Experience Basis: 3 years
Values populated via standard Bayesian development
03

Required Premium Rollup

FINAL ROLLUP
$212,247

Net billable pricing (all schedules applied)

Net Carrier Premium $123,450
Loss Shortfall Loading +$51,812
Profit / Margin (0.0%) $0
Broker Commission (15.00%) +$30,216
Deductible Credit ($2k plan) -$4,038
Taxes, Assessments & Fees +$10,807
Tax Spread Profit: + $6,612 Remitted delta

Target Premium Back-Solve Engine

Input a competitive prospect target premium. The reverse calculation solves for the implied loss pick and scales the premium build-up to match.

$
Live Telemetry: No target applied — pricing runs forward from the computed premium of $212,247.

Actuarial Loss-Pick Method Comparison

Select the actuarial loss development formula. Current selection directly drives the Required Premium engine.

Credibility Threshold: Z = 0.20
Industry curve
Loaded Loss Pick
$26,232
Implied loss ratio 17.7%
Expected losses $22,479
Vs selected -74.1%
Historical direct
Loaded Loss Pick
$110,100
Implied loss ratio 49.3%
Expected losses $94,345
Vs selected +8.8%
Exposure weighted
Loaded Loss Pick
$43,006
Implied loss ratio 29.0%
Expected losses $36,852
Vs selected -57.5%
Uniform prior
Loaded Loss Pick
$101,192
Implied loss ratio 47.7%
Expected losses $86,712
RECOMMENDED
Prior + Reported
Loaded Loss Pick
$73,267
Implied loss ratio 41.2%
Expected losses $62,783
Vs selected -27.6%
Low credibility (Z=20%) — Bornhuetter-Ferguson is more stable for thin books.
Blended
Loaded Loss Pick
$63,938
Implied loss ratio 38.5%
Expected losses $54,789
Vs selected -36.8%

Historical Claims Review & Actuarial Exclusions

Control claim shock losses, apply outlier caps with load-backs, and audit historical incidents.

Outlier Cap:
$
0 Flagged
Individual Caps: 0 (+0.0% load-back • $0)
Claim ID Date of Loss Class Code Injury Description Incurred Total Audit State Exclusion Decision
WC608H63472 03/19/2025 — EE WAS FILLING BOTTLES WITH ACID WHEN HE WAS SPLASHED WITH ACID DUE TO STUCK BOTTLE $93,767 open Included in Pick
WC608P03406 09/24/2025 — EE ADVISED HR THAT SHE WAS SEEN BY HER PCP AND WAS TOLD HER PAIN IS INDUSTRIAL AND TO REPORT IT FOR TREATMENT WITH OCCUP $57,583 open Included in Pick
WC608H69403 05/06/2025 — EE SLIPPED AND FELL FROM TRUCK STEPS AFTER STOPPING TO REFUEL COMPANY TRUCK $2,690 Included in Pick
WC608P14930 12/21/2025 — EE LOST FOOTING WHILE WALKING DOWN STAIRS IN PRODUCTION AREA $2,670 Included in Pick
WC608H61057 02/26/2025 — EE WAS HELPING MOVE LABELS; EE BENT DOWN AND FELT PAIN $1,903 Included in Pick
WC608P07682 10/28/2025 — EE WAS TROUBLESHOOTING A STUCK ITEM ON PRODUCTION LINE WHEN THE MACHINE POWERED ON AND STRUCK EMPLOYEE $1,245 Included in Pick
WC608G95635 05/05/2024 — Laceration / Lip (LIP LACERATION) $762 Included in Pick
WC608H75271 06/02/2025 — Head (EE WAS CLEANING MACHINERY WHEN THE LID TO MIXER FELL ON HIS HEAD) $493 Included in Pick
WC608P08227 10/27/2025 — Ear (EE COMPLAINED OF HEARING LOSS) $453 Included in Pick
WC608H43312 10/15/2024 — Eye (TOUCHED EYE WITH HAND THAT HAD PREVIOUSLY HANDLED A CLEANING AGENT) $442 Included in Pick

Operating Expenses, Margin & PEPM

29 Lives

Configure administrative fees, broker participation, and per-employee headcount economics.

Admin Fee Surcharge 0.0% ($0)
Broker Commission 15.00% ($30,216)
Underwriting Target Profit
%
$0 Net Profit Target
Eliminate margin
Full-Time PEPM
$
Part-Time PEPM
$
Payroll Processing PEPM (FT)
Internal cost per full-time employee / month
$ 0.00
Payroll Processing PEPM (PT)
Internal cost per part-time employee / month
$ 0.00
Annual HR Expense
$ 0
Annual Risk Management
$ 0
Annual Overhead Base
Fixed non-variable operations allocation
$ 0
Aggregate Program Mark-up: 14.9%
Margin as % of cost

Deductibles & Schedule Modifiers

Composite Mod: 1.000

Program retentions, per-claim stop loss, and discretionary schedule credits within bounds (0.75 – 1.25).

Client Per-Claim Retention
$
Applied per occurrence
PEO Per-Claim Deductible
$
Master program layer
Apply Deductible Credit (LER)
min(claim, $2k) averaged over loss years
-$4,038
0.0% 1.00
0.0% 1.00
0.0% 1.00
0.0% 1.00
0.0% 1.00
Allowed range: 0.75 – 1.25
Total Schedule Credit: 0.0%

Statutory Taxes, Surcharges & Assessment Schedules

Pass-through state assessments, regulatory funds, and carrier surcharge reconciliation.

Assessment Base:
= $201,440
Customize / override
AUTO-DERIVED SCHEDULE • $10,807
California Insurance Guaranty Association 0.459%
$925
State assessment
Occupational Safety & Health Fund 0.530%
$1,068
State assessment
State W.C. Administrative Surcharge 1.496%
$3,013
State assessment
State W.C. Fraud Assessment 0.096%
$193
State assessment
Subsequent Injuries Benefits Trust Fund 0.568%
$1,144
State assessment
Uninsured Employers Benefits Trust Fund Asse... 2.043%
$4,115
State assessment
Policy Fee FLAT
$350
Program fee
Tax Spread Profit Reconciliation
Billed to Client: $10,807 • Remitted to State/Carrier: $4,195
Arbitrage Retained Delta: +$6,612 Net