Path: Transactions > Custodial > Custodial Labor Estimate
Use the Custodial Labor Estimate window to estimate the amount of labor required for a given criteria selection.
The Query Fields Section includes District, Facility, Building, and Template Type.
When you select your criteria and click the Get Estimate button, you can view results in the five Sections:
-
Totals
-
Facility Totals
-
Building Totals
-
Building Type Totals
-
Template Totals
In addition to the total weekly hours, the system provides separate Projected Hours for Cleanliness Level 1 through Level 5 as well as Projected Hours for each level route.
Labor Estimate Filters
After you click the Get Estimate button, the results display in the related Sections.
Each Section on this window includes five filters. Click a link to change your view of the values in the grid. At any time, you can look at the first column (Data Type) as a reminder of the type of data being viewed.
- Show Combined Totals is the default view. It reflects both Routine and Project data.
- Show Routine Totals displays only Routine data.
- Show Project Totals lists Project Only data.
- Show Projections includes additional columns in the grid. Scroll across to see numerous Projected columns. The projected data shown is based on the last Data Type totals you viewed. For example, click Show Routine Totals and then click Show Projections to see projections for Routine data only.
- Hide Projections provides a way to conceal the projection columns when not needed.
Custodial Labor Estimate Field Definitions
The columns for each of the Sections have the same field names such as Area Count, Area SF, and Applied Weekly Hours. The following definitions will help you understand your results regardless of the Section.
Area Count. Area Count is the count of all areas that are linked to a Custodial Template. Whether the area is assigned to a route is not considered. The Route Count field lists the count of areas that are linked to a route.
Rules:
-
The associated facility must be active
-
The associated building must be active
-
The associated template must be active
Area SF. Area SF is the sum of the Square Footage value found on the Area records of the Area Count. All the rules for the Area Count apply to this value as well.
Applied Weekly Hours. The value in this field is based on the filter option selected. Depending on your selection, it is one of three:
-
Routine Hours
-
Project Hours
-
Routine + Project Hours
The calculation is: Template Minutes * Area Count
Template Minutes are the number of minutes required to clean the average room to the default level of cleanliness. It does not consider the Actual Square Footage of individual rooms. This is merely the average room size times the number of rooms you have. Be sure to ensure that the average size used on the Template is the actual average size of your rooms. The Custodial module includes the tools you need to do this.
Applied Weekly FTE. The value in the field shows the number of full-time employees required to perform the task. This value takes the Applied Weekly Hours defined above and divides by 40 (hours per week) or the value you have set for full-time employees.
Applied Cost. The value equals the cost per week to perform the tasks. It is calculated by multiplying the Applied Weekly Hours by the value you have set as your average hourly rate for custodians.
Cost/SF. This field is calculated by dividing the Applied Cost field value by the Area SF (both defined above).
Projected fields. The values calculated for these fields are theoretical values based on whether you set cleanliness Levels to 1, 2, 3, 4, or 5. This allows you to see the time and cost differences if you were to switch to a higher or lower cleanliness standard.
Route Count. This is like the Area Count field, except it only counts Areas that belong to at least one Custodial Route.
Applied Projected Hours (Route). This field contains the work route; therefore, it only counts areas that belong to a Custodial Route. This is very much like Applied Weekly Hours (defined above) but only counts Areas that belong to a custodian’s route schedule.
Applied Project FTE (Route). Like the Applied Weekly FTE (defined above), this field shows projected full-time employee requirements; however, it only considers Areas that are linked to at least one Route. Where the Applied Weekly FTE considers all Areas that are linked to a Custodial Template, the Applied Projected FTE (Route) only considers Areas that are linked to a Custodial Template and assigned to a Custodial Route.
NOTE: The Organization > Area / Custodial Info Tab contains the square footage. If the field on this Tab is empty (null), WebTMA uses the default quantity, which is derived from the Template data.
Custodial Labor Estimate Totals
The values in the Totals Section apply to all the results for the criteria you selected in the Query Fields Section. The label FTE indicates Full Time Employees. Use the Labor Estimate Filters to filter the data to see different columns as needed. Custodial Labor Estimate Field Definitions provide information on the meaning of the values in the various columns.
Custodial Labor Estimate Facility Totals
The values in the Facility Totals Section apply to all the results for the Facilities that were included in criteria you selected in the Query Fields Section. The label FTE indicates Full Time Employees. Use the Labor Estimate Filters to filter the data to see different columns as needed. Custodial Labor Estimate Field Definitions provide information on the meaning of the values in the various columns.
Custodial Labor Estimate Building Totals
The values in the Building Totals Section apply to all the results for the Buildings that were included in criteria you selected in the Query Fields Section. The label FTE indicates Full Time Employees. Use the Labor Estimate Filters to filter the data to see different columns as needed. Custodial Labor Estimate Field Definitions provide information on the meaning of the values in the various columns.
Custodial Labor Estimate Building Type Totals
The values in the Building Type Totals Section apply to all the results for the Buildings Types of the Buildings that were included in criteria you selected in the Query Fields Section. The label FTE indicates Full Time Employees. Use the Labor Estimate Filters to filter the data to see different columns as needed. Custodial Labor Estimate Field Definitions provide information on the meaning of the values in the various columns.
Custodial Labor Estimate Template Totals
The values in the Template Totals Section apply to all the results for the templates that were included in criteria you selected in the Query Fields Section. The label FTE indicates Full Time Employees. Use the Labor Estimate Filters to filter the data to see different columns as needed. Custodial Labor Estimate Field Definitions provide information on the meaning of the values in the various columns.
Want to Know More?
Visit the WebTMA Help Page