MicroStrategy ONE

Benefit and Time Off metrics

The following metrics are used primarily in the Benefits analysis area. See the object definition for details.

Metric/KPI Description Formula

Company Cost

Cost to the company of a benefit per employee, by quarter.

Sum([Company Cost]) {~}

Employee Cost

Cost to the employee of a benefit per employee, by quarter.

Sum([Employee Cost]) {~}

Participants

Number of people participating in a benefit. This can be different from the number of enrolled employees since employees can enroll their family members.

Sum([Number of Participants]) {~}

Enrolled Employees

Number of employees enrolled in a certain benefit.

Count(Employee) {~, Time}

Participation Rate

See formula to the right.

((1.0001 * [Enrolled Employees]) / (1.0001 * Employees))

Avg. Company Cost per Enrolled Employee

See formula to the right.

(Sum([Company Cost]) {~} / [Enrolled Employees])

Avg. Company Cost per Participant

See formula to the right.

(Sum([Company Cost]) {~} / Participants)

Accrued Days

Number of days accrued per employee, per time off type.

NullToZero(Sum([Number of Accrued Days])) {~}

Available Days

See formula to the right.

([Accrued Days] - [Used Days])

Used Days

Number of days used per employee per year.

Sum([Number of Used Days]) {~}