When payroll cost information is available from your PSA data, MSPCFO can use these numbers. If you do not provide cost for members in your PSA or if you would like to override the PSA values, you can add them in MSPCFO in the Wage History Table under the Payroll tab. The values you enter in the Wage History Table are then used to propagate the Hourly Cost Report .

The Hourly Cost Table is calculated monthly from your starting feed month until the present. These calculations are only made for members whose information was entered into the Wage History Table in MSPCFO (table directly above the Hourly Cost Table). All other monthly values will come from your PSA, which may have zero values.

If the monthly salary was entered, MSPCFO calculates the hourly cost based on the greater of an 8-hour work day or the number of hours a person worked.  For these calculations, labor costs are completely variable per month based on salary and the number of hours worked in the specific month. For example, if the monthly salary is $4,000 and the person worked 160 hours in a 20 day month, the hourly cost would be $25 per hour ($4,000/ 160). If the same person works 200 hours in the following month, their cost would be $20 per hour ($4,000/200 hours).

If a pay change was made in the Wage History Table, it is reflected in the Hourly Cost Table. An example of this is Member 1830 who had a pay raise in January, 2015, but none since that date. Each month the hourly cost fluctuates because of the hours worked.

Months for a member that are highlighted in pink mean there are hours reported, but no cost in MSPCFO.