Labor sheets

Different departments may use different methodologies to track their labor expenses (FTEs and salary dollars). To accommodate these differences , the budget plan file template includes several different labor sheets for tracking payroll.

When a department's budget plan file is first created, the system copies the payroll sheet specified for that department in the LaborType field of the DEPT dimension table.

Four Labor sheets cover these methodologies:

  • JobCode – Use for departments that need to adjust FTEs on a monthly basis or based on volume.
  • Employee – Use for departments that budget at the employee level. No volume adjustments are included in the salary calculations.
  • Staffing – Use for 24/7 departments to prepare the budget by shift/day of the week.
  • ADC Configuration – Use for nursing departments to prepare the budget Average Daily Census (ADC) and Nursing Staffing grid levels by job class.

TIP: Use the Change View dropdown to shift focus within the Labor sheets. Options include Summary, Monthly, All, and Audit. The Audit view can provide insight into Source data for a sheet.