Reports

Cycle Time Trend

This report shows the average cycle time for jobs grouped by region, division, and community. Cycle time is defined as the number of days from the adjusted start date of the JBST milestone task to the adjusted end date of the JBFN milestone task. Baseline cycle time is the date difference from the baseline date of JBST to JBFN. Users must have the Region and Division flags set for their orgs in order for this report to work properly. The report will work org down. A user may only display cycle time information for the org the user belongs to and down.

 

To generate the report:

  1. Choose a Region from the drop-down list. The Division filter displays all divisions in that region.

  2. Choose a Division from the drop-down list. The Community filter displays all communities in that division.

  3. Choose a Community from the drop-down list.

  4. Choose Calendar Days or Construction Days from the Days drop-down list.

  5. Choose which Month the report should start reporting on from the drop-down list. The reports shows a total of 13 months, starting with the month you choose.

  6. Choose the Year on which you want to report.

  7. Choose the Job Status you want to view on the report.

  8. Click the Generate Report button. The Cycle Time Trend report opens.

  9. Click a hyperlinked number to open the Cycle Time Trend - Detail.

 

Where does that come from?

Below is a list of information in the Cycle Time Trend report and where the information comes from.

Report Filters

Region – Contains a list of all regions. Only users at the company level will be able to run the report for all regions. For users assigned at a division level, the report pre-populates the region so the user does not have to select the region.

Division – Contains a list of all divisions. If the user is assigned at a division-level org, the report pre-populates the division and region. If a region is selected, the Division filter will only include divisions under that region. If all regions are selected, the user will need to select a division or all divisions. Defaults to All Divisions.

Community – Contains a list of all communities based on the Region and Division filters selected. The user may select an individual community or all communities. Defaults to All Communities.

Days – Contains two options: Calendar Days and Construction Days. This filter determines if the average cycle time displayed is based on calendar days or construction days. Calendar days include Saturdays, Sundays, and holidays. Construction days exclude Saturdays, Sundays, and holidays.

Month – Allows the user to select the starting month for generating the report. The report will begin with the month selected and show average cycle time for jobs for the next 12 months (13 months total). On the report, brackets appear around the month selected.

Year – Contains three options: Prior Year, Current Year, and Next Year. Allows the user to select the year for the month selected. Defaults to the Current Year.

Job Status – Contains a list of all job statuses. This multi-select filter allows the user to filter the jobs by job status. Defaults to Active.

Report Columns

Region - Displays the regions selected in the report. Regions are sorted alphabetically.

Division - Displays the divisions for each region selected on the report. Divisions are sorted alphabetically within each region.

Community - Lists all active communities (subdivisions) for each region and division selected in the report. The communities are sorted alphabetically within each division.

Total Homes - Displays the total number of homes (jobs) within each community that have a task with the milestone key JBST and a task with milestone key JBFN. If at least one job is found without the required milestone keys, the report displays an asterisk* after the Total Homes number. If no jobs are found for that month, the cell is left blank.

Avg. Cycle Time (Days) - This section spans 13 columns. The 13 columns display months starting with the month and year selected in the report. Each month column has three numbers:

Division Subtotal - Displays a weighted average of the cycle time. This average is weighted by the number of homes within each community. Weighted Average = (Total Number of Community Homes x Average Adjusted Cycle Time) / Total Number of Homes.

Region Subtotal - Displays a weighted average of the adjusted cycle time. This average is weighted by the number of homes within each division. Weighted Average = (Total Number of Division Homes x Weighted Average Cycle Time) / Total Number of Homes.

Grand Total - Displays a weighted average of the adjusted cycle time. This average is weighted by the number of homes within each region. Weighted Average = (Total Number of Region Homes x Weighted Average Cycle Time) / Total Number of Homes.

 

Related Topics