Plan Calculations for MUs

For MUs, you see the plan rollup and then the single MU parameter values.

MU Plan Rollup Parameters

For these plan calculations:

  • Interval: week or month

  • Rows highlighted in dark gray are parameters you cannot modify.

PARAMETER

MU WEEK/MONTH

FTE Required

FTE Required for the entity. See the calculation for FTE Required under CT Set, BU, BU Set, EG, EG Set column.

FTE Actual

Sum(MUFTEActual)

FTE Required +/-

PlanRollupFTEActual - PlanRollupFTERequired

Attrition (%)

(PlanRollupAbsAttrit / PlanRollupFTEActual) x 100

Attrition (absolute)

Sum(MUAbsolute Attrition)

FTE New Hire

Sum(MUNewHireFTE)

Individual MU Parameters

For these plan calculations:

  • Interval: week or month

  • CT calculations are a sum of each MU related to the CT for each day, week, or month.

  • Rows highlighted in dark gray are parameters you cannot modify.

PARAMETER

MU WEEK/MONTH

FTE Actual

Week: max[0, FTEActual(previous interval) - AbsAttrit(previous interval)] + FTENewHire(i)

where i = WeekStartDate - NewHireTrainingPeriod

Month: Daily FTE Actual on the first day of the month, taking into account attrition and new hire training as daily values

Attrition (%)

(AbsAttrit / FTEActual) x 100

Attrition (absolute)

Week: User entered value

Month:Sum(DailyAbsoluteAttrition)

DailyAbsoluteAttrition = WeeklyAbsoluteAttrition / NumberOfDaysInWeek

FTE New Hire

Week: User entered value

Month:Sum(DailyFTENewHire)

The week value is the day value for the first day within that week.