Skip to main content

Cycle Time Report

Analyze how long projects spend in each stage across sales, design, and production.

Accessing the Report​

Reports > General > Cycle Time

Key Metrics​

MetricDescription
StageStage name
Avg DaysAverage time in stage
Median DaysMiddle value
Min DaysShortest time
Max DaysLongest time
Project CountNumber analyzed

Available Filters​

FilterDescription
Date RangeProjects completed in period
Stage TypeSales, Design, Production
Opportunity TypeProject category
DivisionBusiness unit

Understanding Cycle Time​

What It Measures​

Time from entering a stage to leaving it:

  • Measures process efficiency
  • Identifies bottlenecks
  • Sets realistic expectations

Stage Types​

Sales Stages: Lead to contract

  • New Lead
  • Qualified
  • Appointment Set
  • Proposal Sent
  • Negotiation

Design Stages: Concept to completion

  • Design Kickoff
  • Concept Development
  • Client Review
  • Final Design

Production Stages: Start to finish

  • Pre-Production
  • In Production
  • Punch List
  • Closeout

Average vs. Median​

Average (Mean)​

Sum of all values divided by count:

  • Affected by outliers
  • One long project skews results

Median​

Middle value when sorted:

  • More representative
  • Better for typical duration

Example​

Days: 5, 7, 8, 10, 50
Average: 16 days
Median: 8 days

Use median for "typical" duration.

Identifying Bottlenecks​

Signs of Problems​

  • High average vs. median (outliers)
  • Consistently long stage duration
  • Increasing trend over time
  • Wide min/max spread

Common Causes​

Stage TypeCommon Bottleneck
SalesProposal turnaround
DesignClient decisions
ProductionPermit delays

Using the Data​

Set Expectations​

  • Quote realistic timelines
  • Plan project schedules
  • Staff appropriately

Improve Process​

  • Focus on longest stages
  • Address bottleneck causes
  • Measure improvement

Benchmark​

  • Compare project types
  • Compare time periods
  • Track improvement

Export Options​

Click Export CSV to download:

  • Stage statistics
  • For analysis
  • Historical tracking

Tips​

  • Use median for customer quotes
  • Track trends over time
  • Compare similar projects
  • Investigate outliers