Variance Analysis for Personnel

Recently, an Adaptive Insights client requested variance analysis to be built into their Personnel planning and reporting. This is particularly useful for organizations that do not have a Human Capital Management system, but want to report the causes for variance between actual and budget/forecast. Some of the variances included New Hires Not Planned, Replacements above Planned Compensation, Future Impact of Compensation Differences, etc. This was accomplished by maintaining both Actual and Planned versions of the Personnel modelled sheet and using calculated accounts to isolate the variables.