MACS Management Reports Module
The Management Reports module includes two special report series:
Management Reviews and Management Profiles. Each of these series give the
agency manager an overview of the agency's performance with some unique
statistics.
Management Review Reports rank manufacturers and salesmen within the
agency. These reports are designed to give the agency manager a monthly
overview of sales performance by manufacturer. The manufacturers that
represent approximately 80 percent of agency sales are double spaced at
the top.
MR\14.2 Any Sales Oriented Agency Page 1
11/25/06 14.8 MANAGEMENT REVIEW --- AGY/MFG Sales 10/06
—————————————————————————————————————————————————————————————————————————————————————————————————————————————
%OF ******** Y E A R T O D A T E S A L E S ********* ** CUSTOMERS **** ** COMM **
TTL LINE THIS YR COMP .MILLIONS O=LAST YR +=THIS YR . TTL NEW PEN CNTCS EST$ %
—————————————————————————————————————————————————————————————————————————————————————————————————————————————
0 .2 .4 .6 .8 1.0 1.2 1.4 1.6
22% Lee Jacob Mfg 887159 +18%.0000000000000000000+++ . 27 2 4.2 927 59511 27%
20% MNC Company 801641 +17%.00000000000000000+++ . 16 2 4.7 640 20644 14%
13% J. F. Krause 542443 +55%.000000000+++++ . 16 3 5.1 617 33510 16%
12% Task Supply Mech. 503265 +135%.00000++++++++ . 12 1 5.0 450 25246 12%
12% Simplex Manufactur 484283 .++++++++++++ . 11 11 5.4 451 11851 5%
7% Apcal Alloy Compan 281333 +109%.000++++ . 14 2 4.7 493 18151 8%
4% Isle Restoring Co. 143207 +47%.00++ . 12 1 4.5 443 12666 6%
3% Rollins/Parts Grou 131331 +22%.000 . 5 0 6.6 243 4548 2%
3% Rollins/Components 103385 +106%.0++ . 5 1 5.4 305 5169 2%
2% B.C. Industries 79468 -34%.00O . 16 3 4.5 660 7664 4%
2% Simpso Part Supply 68694 +163%.0+ . 8 3 5.8 289 7103 3%
1% Saclia Supply 38678 -59%.0O . 9 2 4.9 354 1062 1%
1% Rollins/Capital Eq 23851 -66%.0O . 5 1 4.2 122 1093 1%
100% TTL ACTIVE LINES 4088738 +51% 218118 100%
S P & P Inc. 0 -100%.OOOOOOOOOOOOOOOOOOOOOOOOOOO . 12 0 4.9 458 0
TTL INACTIVE LINE 0 -100% 0
TOTAL AGENCY 4088738 +7% 218118
|
Based on this report, the agency knows the following about Lee Jacob
Mfg.:
- They generate 22% of the agency sales volume.
- Sales this year-to-date have been $887,159.
- That figure is 18% ahead of last year at this same time.
- The bar graph shows how they rank with other manufacturers this year
and last year.
- 27 agency customers buy from Lee Jacob Mfg.
- The agency has sold 2 new Lee Jacob Mfg. customers so far
this year.
- Each of their customers buys from 4.2 manufacturers the
agency represents.
- The agency has made 927 calls on their 27 customers so far
this year.
- Lee Jacob has generated $59,511 commission dollars so far
this year.
- Lee Jacob generates 27% of the agency commission dollars.
Management Profile reports include a 25-month graph of sales activity.
The 25th column is always the current month. The previous two years are
separated by the vertical bars. The "<" in each year
represents the year-to-date average month for that year. To the right of
the graph is an analysis of the components contributing to a year-to-date
increase or decrease. The top section deals with old lines—lines the
agency had last year as well as this year. The bottom section shows the
increases and decreases in volume from lines lost and from new lines added
to the agency.
MR\14.11 Any Sales Oriented Agency PAGE 3
11/17/06 SALESMAN PROFILE Sales 10/06
Jim Black * 2*
216,673 ( HIGHEST MONTH * )
____________________________________________________
217| | * | | LAST YEAR-TO-DATE SALES $1,011,953
206| | X | |
106| | X | |
185| | X | | OLD CUSTOMERS,OLD LINES $53,008 +5.2%
174| | X | |
163| | X | |
152| | X | X | NEW CUSTOMERS,OLD LINES $183,583 +18.1%
141| | X | X X |
131| | X | X X |
120| | X X | X X X | SUB-TOTAL ......... $236,591 +23.4%
109| |------X---X-X-X-X--<---| X X X <|
98| | X X X X X X X|X X X X X X |
87| < | X X X X X X X X X|X X X X X X X X X | + INCREASE / NEW LINES $0
76|X----| X X X X X X X X X X|X X X X X X X X X X |
66|X X| X X X X X X X X X X X|X X X X X X X X X X |
55|X X|X X X X X X X X X X X X|X X X X X X X X X X | - DECREASE/DROPPED LINES $259,955- -25.7%
44|X X X|X X X X X X X X X X X X|X X X X X X X X X X |
33|X X X|X X X X X X X X X X X X|X X X X X X X X X X |
22|X X X|X X X X X X X X X X X X|X X X X X X X X X X | THIS YEAR-TO-DATE SALES $988,589 -2.3%
11|X X X|X X X X X X X X X X X X|X X X X X X X X X X |
____________________________________________________
O N D J F M A M J J A S O N D J F M A M J J A S O
|
|
