Tutorials › CAS Exam 5 - Basic Ratemaking and Estimated Claim Liabilities › Payroll And Sales Exposure Bases

CAS Exam 5 · Exposure Bases and Policy Data · Tutorial 19 of 989

Payroll And Sales Exposure Bases

Calculate payroll- and sales-based exposure from policy records, distinguishing actual reported amounts from revised annual estimates and preserving the units used.

Beginner 11 min read

What You'll Learn

  • Convert payroll and sales amounts into exposure units using the stated unit basis.
  • Distinguish incremental activity reports from cumulative-to-date snapshots.
  • Calculate exposure when an annual estimate changes during a policy period.
  • Apply time weighting only when the reported amount is an annualized estimate.
  • Check exposure calculations against the policy period and the units in the rate.

Why Payroll and Sales Need Their Own Exposure Basis

Some policies measure exposure by how much insured activity occurs, rather than by how many vehicles or other insured items are covered for a period of time. Workers compensation commonly uses payroll, while some liability policies use sales or receipts. The basis is the amount of activity associated with the covered operations during the relevant policy period.

Payroll and sales amounts are not interchangeable. A payroll-based rate might be stated per $100 of payroll, while a sales-based rate might be stated per $1,000 of sales. The exposure calculation must preserve that unit so the resulting exposure can be combined correctly with the rate.

Definition: A payroll exposure is the payroll amount assigned to covered operations for the specified policy period. A sales exposure is the sales or receipts amount assigned to covered operations for that period. An exposure unit is the amount of the stated basis corresponding to one unit of the rate, such as $100 of payroll or $1,000 of sales. If the applicable basis is \(B\) dollars and one exposure unit represents \(u\) dollars, then the number of exposure units is \(B/u\).

The first task is to understand what each record represents. An actual payroll or sales report may give activity occurring during a specified interval, or it may report a cumulative amount from the start of the policy period. An underwriting record may instead show an annualized estimate: a projected amount for a full year, even when the policy covers only part of that year. Those records require different calculations.

Record typeWhat the amount representsBasic treatment
Actual amount for an intervalActivity that occurred during that intervalAdd interval amounts for the period; do not prorate the reported activity again.
Cumulative-to-date amountActivity from the start of the period through the report dateUse the final cumulative amount, or difference successive snapshots to obtain intervals.
Annualized estimateProjected activity for a full year at the current estimateProrate for the time during which that estimate applies, under a stated uniform-activity assumption.

Actual Activity Reports and Exposure Units

When records give actual payroll or sales for a policy period, the exposure is the actual amount assigned to that period. If the policy uses payroll in $100 units, divide the payroll dollars by 100. If it uses sales in $1,000 units, divide sales dollars by 1,000. The divisor comes from the rate basis; it is not a conversion that can be omitted just because the underlying dollar amount is known.

For actual interval reports, add amounts that describe separate, non-overlapping intervals. If a report is cumulative, do not add successive snapshots as though each were a separate interval. Either use the final snapshot or calculate interval activity by taking differences.

Worked Example: Payroll Reported for Separate Intervals

A hypothetical workers compensation policy covers a fabrication shop from April 1 through September 30. Its final payroll records for the policy period show $318,400 of regular payroll, $41,600 of overtime payroll, and a documented additional $20,000 of covered payroll omitted from the initial extract. The rate is $6.35 per $100 of payroll. Calculate the payroll exposure units and the indicated premium from these records.

Method. This is an actual payroll total, not an annualized estimate. Add the covered payroll amounts for the period:

$$ 318{,}400+41{,}600+20{,}000=380{,}000\text{ dollars of payroll}. $$

One exposure unit represents $100 of payroll, so the number of units is:

$$ \frac{380{,}000}{100}=3{,}800\text{ units}. $$

The rate is $6.35 per exposure unit. Therefore:

$$ 3{,}800\times \$6.35=\$24{,}130.00. $$

The check is that 3,800 units each represent $100, giving \(3{,}800\times100=\$380{,}000\), exactly the covered payroll total. The corresponding premium calculation uses the same $100 unit as the rate. A common mistake is to multiply the full $380,000 by $6.35, treating a per-$100 rate as a per-dollar rate; that would overstate the result by a factor of 100. No interest rate, mortality assumption, or probability distribution is needed for this exposure calculation.

Handling Cumulative Sales Reports

Sales records may be produced as cumulative-to-date snapshots. Suppose reports show sales from the policy start through the end of each quarter. The first snapshot gives first-quarter sales; the next snapshot includes both first- and second-quarter sales; later snapshots include all prior quarters. Adding the snapshots counts earlier sales more than once.

If the snapshots are accurate and cover the same policy period and operations, the final cumulative value is the total for that period. Differences between adjacent snapshots provide an alternative check: each difference represents activity in a new, non-overlapping interval.

Worked Example: Sales Reported as Cumulative Snapshots

A hypothetical commercial liability policy uses a rate of $1.80 per $1,000 of sales. The insured reports the following cumulative sales for its policy year: $275,000 at March 31, $640,000 at June 30, $1,040,000 at September 30, and $1,500,000 at December 31. Calculate the sales exposure units and the premium based on the final reported amount.

Method. These are cumulative snapshots, so the final amount is the policy-year total. The interval amounts, calculated as differences, are:

$$ \begin{aligned} \text{First interval} &= \$275{,}000,\\ \text{Second interval} &= \$640{,}000-\$275{,}000=\$365{,}000,\\ \text{Third interval} &= \$1{,}040{,}000-\$640{,}000=\$400{,}000,\\ \text{Fourth interval} &= \$1{,}500{,}000-\$1{,}040{,}000=\$460{,}000. \end{aligned} $$

The interval amounts reconcile to the final snapshot:

$$ 275{,}000+365{,}000+400{,}000+460{,}000=1{,}500{,}000. $$

At $1,000 per exposure unit, the sales exposure is:

$$ \frac{\$1{,}500{,}000}{\$1{,}000}=1{,}500\text{ units}. $$

The premium calculation is:

$$ 1{,}500\times \$1.80=\$2{,}700.00. $$

The result is checked by summing the non-overlapping interval amounts and recovering the final cumulative total. The common error is to add all four snapshots: that produces $3,455,000, which repeatedly counts earlier sales. The policy-period exposure is $1,500,000, not $3,455,000.

Revised Annual Estimates During a Policy Period

An annualized estimate is not the same as actual payroll or sales accumulated over a specified interval. If the estimate changes during a policy term, each estimate applies only while it is in effect. Under a uniform-activity assumption, prorate each annual estimate by the fraction of a year in its applicable interval, then add the resulting amounts.

For example, an annual estimate of $2,400,000 in sales in effect for half a year contributes \(0.5\times \$2{,}400{,}000\) to the estimated exposure for that half-year. If a revised estimate takes effect for the other half, apply that estimate only to the second half. This is a time-weighting calculation for annualized estimates; it is not a reason to prorate actual activity amounts that already represent sales or payroll during a period.

Assumption for time weighting: When an annualized estimate applies over a fraction \(t_j\) of a year, the estimated amount for that interval is \(A_jt_j\), where \(A_j\) is the annual estimate and \(t_j\) is measured in years. This treats activity as accruing uniformly through the year while that estimate applies. If actual activity records are available and are the required exposure basis, use those actual amounts instead of this estimate.

Worked Example: Sales Estimate Revised at Midterm

A hypothetical one-year policy runs from April 1 through March 31. The insured reports an annualized sales estimate of $2,400,000 from April 1 through September 30. An endorsement effective October 1 revises the annualized estimate to $3,000,000 for October 1 through March 31. The rate is $2.40 per $1,000 of sales. Assuming uniform activity within each interval, calculate the estimated policy-period sales exposure units and the premium based on those units.

Method. Each estimate applies for six months, or \(6/12=0.5\) year. The first interval contributes:

$$ \$2{,}400{,}000\times0.5=\$1{,}200{,}000. $$

The second interval contributes:

$$ \$3{,}000{,}000\times0.5=\$1{,}500{,}000. $$

The estimated policy-period sales basis is therefore:

$$ \$1{,}200{,}000+\$1{,}500{,}000=\$2{,}700{,}000. $$

Convert to $1,000 sales units:

$$ \frac{\$2{,}700{,}000}{\$1{,}000}=2{,}700\text{ units}. $$

Then calculate the premium:

$$ 2{,}700\times \$2.40=\$6{,}480.00. $$

The check is that the two six-month contributions use one-half of each applicable annual estimate, and the two intervals cover the full 12-month policy term. A common error is to use the revised $3,000,000 estimate for the entire year, or to add the two annual estimates without time weighting. Both ignore the effective date of the endorsement. No interest rate, mortality assumption, or probability distribution is involved.

Why the Time-Weighting Formula Works

The formula follows from the meaning of an annualized estimate under the uniform-activity assumption. If an annual estimate \(A\) is spread evenly over one year, the estimated amount per year is \(A\). Over a fraction \(t\) of that year, the corresponding amount is \(At\). When estimates change, divide the policy term into intervals on which each estimate is constant and add the interval contributions.

$$ \begin{aligned} \text{Estimated amount in interval }j &= A_j\frac{\text{time in interval }j}{\text{one year}}\\ &=A_jt_j,\\ \text{Estimated policy-period basis} &=\sum_j A_jt_j. \end{aligned} $$

The fractions \(t_j\) must cover the applicable policy period without overlap or gaps. For a one-year term split into two equal six-month intervals, \(t_1+t_2=0.5+0.5=1\). If the same annual estimate applies throughout, the formula reduces to \(A(1)=A\), as expected for a full policy year.

1
Identify the record meaning.
Decide whether each figure is actual interval activity, a cumulative snapshot, or an annualized estimate.
2
Match amounts to the period.
Add separate actual intervals, use or difference cumulative reports, and time-weight annual estimates only over the intervals when they apply.
3
Convert to the rate basis.
Divide the applicable dollar amount by the number of dollars represented by one exposure unit.
4
Reconcile and retain units.
Check that the amounts cover the intended period and that exposure units match the rate's stated basis.

Common Traps and Practical Checks

A calculation can be arithmetically correct and still use the wrong exposure. Before calculating, check the reporting convention, the covered operations, the effective dates of changes, and the rate's unit. Keep the original dollar amount and the converted exposure units visible; the conversion does not erase what the exposure measures.

  • Adding cumulative snapshots. Use the last cumulative figure or difference successive reports. Do not treat overlapping totals as separate activity.
  • Prorating actual activity a second time. A reported $300,000 of payroll for a six-month interval is already an amount for that interval. Do not multiply it by \(6/12\) again.
  • Failing to prorate an annual estimate. An annual estimate that applies for part of the year contributes only for that part under the stated uniform-activity assumption.
  • Ignoring a change's effective date. A revised estimate applies from its effective date, not automatically from the start of the policy.
  • Dropping the unit basis. A payroll exposure measured per $100 cannot be paired with a rate per $1,000 without converting one of them consistently.
  • Mixing operations or basis types. Include only the payroll or sales assigned to the covered operations and the policy exposure being calculated. Do not combine payroll dollars and sales dollars as if they were the same basis.
Key takeaway: First determine what each reported amount represents and which period it covers. Then calculate the appropriate payroll or sales total, convert it into the rate's exposure units, and verify both the time basis and the unit basis.

Check Your Understanding

For each problem, identify the record type before calculating. Unless stated otherwise, use the stated exposure-unit basis.

  1. A hypothetical policy has $1,860,000 of actual covered payroll for its full policy period. The rate basis is $100 of payroll per exposure unit. How many payroll exposure units are recorded? (Answer: 18,600 units.)
  2. A hypothetical sales policy reports cumulative sales of $180,000, $470,000, $810,000, and $1,260,000 at successive quarter-ends. The rate basis is $1,000 of sales per unit. Find total policy-period sales and exposure units, using the reports as cumulative snapshots. (Answer: $1,260,000 of sales; 1,260 units.)
  3. A one-year hypothetical policy has an annualized payroll estimate of $750,000 for the first four months and a revised annualized estimate of $900,000 for the remaining eight months. Assuming uniform activity within each interval, find the estimated payroll basis and the number of $100 payroll units. (Answer: $850,000 of payroll; 8,500 units.)
  4. A hypothetical policy's actual sales reports give $215,000, $340,000, $295,000, and $150,000 for four consecutive, non-overlapping intervals. The rate is $2.75 per $1,000 of sales. Calculate total sales, exposure units, and the premium based on the reported amounts. (Answer: $1,000,000 of sales; 1,000 units; $2,750.00.)
  5. A hypothetical one-year policy has annualized sales estimates of $1,800,000 for the first three months, $2,400,000 for the next six months, and $3,000,000 for the final three months. Assuming uniform activity within each interval, calculate the estimated sales basis and the exposure units per $100. (Answer: $2,400,000 of sales; 24,000 units.)
Clinical Biostats