TRM GROUP BENCHMARKING SURVEY

DSO & Bad Debt Ratio Worksheet (click here for calculation worksheet)

Company Profile & AR Metrics
Note: The responses provided in this section will be kept confidential.
1. What is the primary service your company provides?	SELECT ONE -RESUBMIT FORM IF MORE THAN ONE CATEGORY APPLIES
2. Is your company regional or national/international?
3. What are your company’s annual sales?
4. What percent of your receivables was 0-30 days aged by invoice date?	%
5. What percent of your receivables was 31-60 days aged by invoice date?	%
6. What percent of your receivables was 61-90 days aged by invoice date?	%
7. What percent of your receivables was over 91 days aged by invoice date?	%
(Total for #4-7 should equal 100%)
8. What was your company’s average days sales outstanding for July 2007-September 2007?	# days INSERT DSO FROM WORKSHEET HERE
9. What was your company’s bad debt ratio for July 2007-September 2007?	% INSERT RATIO FROM WORKSHEET HERE

General Practices
Note: The responses provided in this section will NOT be kept confidential, so that survey participants may inquire further about responses.
10. What percentage of your BOL’s does your company receive electronically (EDI, web or other) prior to freight billing?	% None Don't know
11. What percentage of your invoices does your company send electronically (EDI, email, web, other)?	% None Don't know
12. What is your company's average days to invoice from delivery date?	# days Don't know
13. What is the average number of contacts your collectors make per day?
14. When measuring collector performance, do you include email communication as a contact?
15. Does your company have a separate group handling collections from freight payment agencies, or are they blended with all collection calls?
16. Does your company have a separate group handling collections from Interline carriers?
17. Does your company have a different collection process for balance due bills or are they blended in with the normal collection efforts?
18. Do you report to customers on a consistent basis how their freight paying agent is performing?
19. What is your % of unposted cash to daily revenue?	% None Don't know
20. Do you use an automated web scraping method for gathering payment status from freight payment service companies?

NACM Member Completing the Survey - REQUIRED (for survey distribution verification purposes only)	REQUIRED
NACM Member number - REQUIRED (for survey distribution verification purposes only)	REQUIRED

THIS SURVEY IS NOW CLOSED FOR Q3 DATA. TRM GROUP BENCHMARKING SURVEY ONLY by participating in this survey, will you receive a copy of the results. Responses must have be received by January 21, 2008

THIS SURVEY IS NOW CLOSED FOR Q3 DATA.
TRM GROUP BENCHMARKING SURVEY
ONLY by participating in this survey, will you receive a copy of the results.
Responses must have be received by January 21, 2008