Report Topics  

Mix Factor Report

Contents

1 Overview

2 Data Validation

3 Exception Report

4 Detail Report

5 Summary Report

6 How-to

7 Exception Report Fields

8 Detail Report Fields

9 User Tips

5 Summary Report

The Summary Report lists FTE, Mix Factors, and salaries summarized from the detail data. The total number of individuals "out of compliance" is included when Use Salary Compliance Edits is checked as a Report Option. If the summary report option is selected and no information is found to report, then this message will print under the summary report headings: "No data was found matching selection criteria."

 

See the Detail Report for more information about FTE, Mix Factor, and Salary. The Summary Report contains the following data:

 

Data Category

Description

FTE (Item 1)

The sum of calculated FTE for the column.

MIX FACTOR (Item 2)

The sum of mix factors for the column.

AVG MIX (Item 3)

The total mix factors (Item 2) divided by the total FTE (Item 1) for the column.

SALARY (Item 4)

The sum of salaries for the column.

AVG SAL (Item 5)

The total salary (Item 4) divided by total FTE (Item 1) for the column.

BASE SAL (Item 6)

The average salary (Item 5) divided by average mix factor (Item 3) for the column.

WARNING

The total number of individuals out of compliance when an employee’s total certificated base salary for all programs is $1.00 more or $1.00 less than state standards.

 

Page Updated 8/08

Top