The Price Is Right? --Dickeson

Now, sort from highest VA to lowest. Divide into quartiles and find the averages for the Upper, Upper Middle, Lower Middle and Lower Quartiles.

For some Excel magic let's call up "Pivot Tables" under "Data." Pivot to look at a sort by percent VA and quartiles. Do the same for Count, Job Type, Salespeople, CSRs, Days to Invoice, Days to Collect and then tell me what you think. Remember always that these are "hard" numbers—our own past experience. No assumptions, projections, budgeted hourly rates or other gimmicks are used. Now, tell me what we're going to do about the jobs!