RSNE Sales Dashboard
Gross margin by Sales Lead — Active & Closed jobs. Real jobs only (number-prefixed name, actual costs > $0). Gabriel Perez, Douglas Gibbons, David Shea, and Unassigned excluded from analysis.
Gross Margin & Cash by Sales Lead
Estimated GM% = (Contract − BudgetTotal) / Contract — what we sold the job for. Actual GM% = (Contract − Actual Cost) / Contract on closed jobs; on active jobs it's a forecast using max(actualCosts, committedCosts, budgetTotal) as the cost-at-completion. Diff (pp) = Actual − Estimated, in percentage points: positive = beating bid, negative = missing bid. Cash Collected = Invoiced Payments + Deposits.
Top Jobs by GM $ Contribution