BI Dashboard

Dashboard Description

Commonly Used By

Executive

Provides a high level overview of all key departmental metrics.

Visuals include:

• Sales/Starts/Closings analysis

• Construction snapshot

• Gross Margin over time

• Variance analysis

• High level financials

• P&L

CEO, COO, CFO, Division Presidents

Sales

Provides detail and summary level sales, starts, and closing metrics.

Visuals include: 

• General project, job, buyer, sales analysis

• Actual vs Budget of units

• Projected closings and revenue analysis

• Highlight of at risk closings

• Sales agent review

• Plan sales analysis

Sales VP, Sales Coordinator, Division Presidents

Production

Provides summary and detailed view of active construction jobs and historical cycle time analysis.

Visuals include: 

• Timeline review of in-progress homes

• Start to close anaysis

• Milestone analysis

• Cycle time and average days to complete

• Variance analysis

• Warranty review

Construction VP, Construction personnel, Sales

Purchasing

Provides summary and detailed breakdown of plan budget data, job budget analysis, and variance metrics.

Visuals include: 

• Base plans comparison by total cost and cost/sqft

• Option cost comparisons by plan

• Original budget v Current budget

• Job cost analysis

• Variance Review

Purchasing, Estimating, VP Sales, Controller, VP Finance, Construction, Controller, Warranty

Finance

Provides high level financial reporting, AP metrics, and job level financial reviews.

Visuals include: 

• Trial balance and P&L

• Budget to actual

• AP invoice lookup & aging reporting

• Overview of job profit v projections

• WIP/Inventory review

• Loan analysis

• Vendor lookup

Accountants, Controller, VP Finance, Purchasing