JFH Management Group, Inc. 901 South Main Street, Fairfield, IA 52556 719.371.2558

Your Subtitle text

Sales System Output

Sales System Output Examples

The QSource^sm Sales System has amazing flexibility to provide the output you need. Data critical to your needs can easily be identified and output designed. We work with you to customize your modeling process so the output allows you to act immediately.

Annual Hours by Account Classification

The data gives a clear view of the type of accounts in a territory, the required hours, sales data, etc.

	QSource Annual Hours By Class

Acct Class	# of Accts	% of Total Count	Coverage Hrs/ Yr	Travel Hrs/ Yr	Total Hours/ Yr	% of Hrs	Product 1 2009 $	Product 2 2009 $	Profitability
A	2	0.1%	148.0	8.0	156.0	2.4%	$535,369	$2,577	$84,188
B	24	1.7%	864.0	72.0	936.0	14.6%	$3,857,513	$67,518	$426,316
C	32	2.3%	576.0	96.0	672.0	10.5%	$2,827,317	$60,385	$368,449
D	45	3.2%	540.0	90.0	630.0	9.8%	$2,821,607	$34,693	$342,706
E	156	11.0%	1,248.0	202.8	1,450.8	22.6%	$4,281,730	$72,464	$530,468
KA	1	0.1%	74.0	4.0	78.0	1.2%	$380,178	$2,347	$43,969
KB	7	0.5%	252.0	21.0	273.0	4.2%	$1,226,410	$43,787	$165,480
KC	8	0.6%	144.0	24.0	168.0	2.6%	$761,341	$12,438	$73,580
KD	3	0.2%	36.0	6.0	42.0	0.7%	$179,175	$1,433	$13,659
KE	9	0.6%	72.0	11.7	83.7	1.3%	$237,944	$6,453	$30,200
KF	49	3.5%	122.5	34.3	156.8	2.4%	$133,147	$12,395	$40,249
NC	547	38.6%	0.0	0.0	0.0	0.0%	$3,646,289	$91,742	$215,327
NCARR	5	0.4%	30.0	7.2	37.2	0.6%	$155,672	$4,313	$0
NL	19	1.3%	38.0	26.1	64.1	1.0%	$1,286,092	$47,015	$0
NSC	82	5.8%	164.0	133.9	297.9	4.6%	$6,934,564	$197,843	$0
NST	2	0.1%	12.0	5.4	17.4	0.3%	$88,122	$730	$0
T	427	30.1%	1,067.5	298.9	1,366.4	21.3%	$1,497,037	-$29,405	$188,120
Total	1,418	100.0%	5,388.0	1,041.3	6,429.3	100.0%	$30,849,507	$628,728	$2,522,710

Territory by Classification

The data shows how many accounts by classification, hours by year, % of hours, etc. along with the total manpower equivalents for that sales responsibility.

		Annual Hours By Territory

Terr #	Reg	Acct Class	# of Accts	% of Total Count	Coverage Hrs/ Yr	Travel Hrs/ Yr	Total Hours/ Yr	% of Hrs	Manpower Equiv.
01	PF	A	1	1.0%	74.0	6.0	80.0	12.4%
01	PF	B	2	2.0%	72.0	9.0	81.0	12.6%
01	PF	C	3	3.0%	54.0	13.5	67.5	10.5%
01	PF	D	7	6.9%	84.0	21.0	105.0	16.3%
01	PF	E	18	17.8%	144.0	36.0	180.0	28.0%
01	PF	NC	33	32.7%	0.0	0.0	0.0	0.0%
01	PF	T	37	36.6%	92.5	37.0	129.5	20.1%
			101	100.0%	520.5	122.5	643.0	100.0%	0.41

Territory Recap by Account

This recap provides all relevant data for each account in a given sales area. Account names are hidden for confidentiality. The dollars and profit at the account level are actuals. QSource^sm has a unique indexing system that "masks" actual profit.

Territory by Account

Reg	Terr #	Account Name	Acct #	Acct Class	# Visits /Yr	Hrs/ Yr	Travel Time	Total Time	Total $	Profit.
PD	06		D888	E	4	8	2.3	10.3	$ 34,794	$ 5,130
PD	06		A360	D	6	12	3.5	15.5	$ 70,439	$ 9,019
PD	06		A742	D	6	12	3.5	15.5	$ 51,909	$ 7,842
PD	06		CH62	T	2	2.5	1.2	3.7	$ 11,777	$ 1,208
PD	06		2433	T	2	2.5	1.2	3.7	$ 4,183	$ 997
PD	06		CV81	E	4	8	2.3	10.3	$ 14,278	$ 2,159
PD	06		0105	D	6	12	3.5	15.5	$ 38,930	$ 6,698
PD	06		K331	NC	0	0	0	0	$ -	$ -
PD	06		DX63	T	2	2.5	1.2	3.7	$ -	$ -
PD	06		A088	C	9	18	5.3	23.3	$ 88,180	$ -
PD	06		CN74	T	2	2.5	1.2	3.7	$ 18,283	$ -
PD	06		DA55	NC	0	0	0	0	$ -	$ -
PD	06		BG00	T	2	2.5	1.2	3.7	$ 4,975	$ -
PD	06		N872	NC	0	0	0	0	$ -	$ -
PD	06		5811	D	6	12	3.5	15.5	$ 66,137	$ 7,796
PD	06		J159	E	4	8	2.3	10.3	$ 42,405	$ 7,202
PD	06		A798	T	2	2.5	1.2	3.7	$ 3,432	$ 87
PD	06		0988	B	9	36	5.3	41.3	$ 200,596	$26,539

Annual Hours Sales People Requirements

This chart is a recap of the process for a rather large entity showing annual hours, profitability of sales region, total number of required sales people with percentages of totals for comparison purposes. Obviously the data can be gathered to perform the analysis you wish to see. Under each of the region columns this chart cascades down to sales territory, then to the customer level.

	Annual Hours

Region		# of Accts.	Hours per Year	Travel Hours per Year	Total Hours Per Year	% of Hours	Profitability	% of Total	Sales People Req.	% of Total
Region JA Total:		1418.0	5388.0	1041.3	6429.3	4.3%	$ 2,522,710	4.3%	3.70	4.0%

Region KA Total:		852.0	8682.5	1278.8	9961.3	6.7%	$ 5,365,706	9.2%	6.30	6.8%

Region KB Total:		647.0	6451.5	1265.0	7716.5	5.2%	$ 3,708,990	6.4%	4.17	4.5%

Region PA Total:		2324.0	8762.5	2409.7	11172.2	7.5%	$ 3,669,262	6.3%	6.72	7.2%

Region PB Total:		2355.0	9334.0	2514.5	11848.5	7.9%	$ 4,899,920	8.4%	7.50	8.0%

Region PC Total:		1668.0	8845.0	2447.5	11292.5	7.5%	$ 4,409,349	7.6%	7.15	7.7%

Region PD Total:		2318.0	9627.0	3447.0	13074.0	8.7%	$ 4,002,074	6.9%	8.27	8.9%

Region PE Total:		1502.0	8051.0	2500.1	10551.1	7.1%	$ 3,034,354	5.2%	6.68	7.2%

Region PF Total:		2275.0	11545.5	3070.1	14615.6	9.8%	$ 5,994,846	10.3%	9.25	9.9%

Region PG Total:		2808.0	14038.5	4772.5	18811.0	12.6%	$ 7,308,016	12.5%	11.91	12.8%

Region PH Total:		2232.0	13328.0	3661.3	16989.3	11.4%	$ 6,852,629	11.7%	10.75	11.5%

Region PJ Total:		2331.0	13164.5	4021.3	17185.8	11.5%	$ 6,600,534	11.3%	10.88	11.7%

Grand Total:		22730.0	117218.0	32429.1	149647.1	100.0%	$58,368,391	100.0%	93.28	100.0%

QSource^sm is incredibly flexible to suit your needs. Call or email today for your FREE consultation on how the QSource^sm Sales System can reduce cost and improve the efficiency and productivity of your sales effort.