MACS Time Management Module
Time Management maintains a history of sales calls made by each
salesman on all customers. Sales call information is usually entered from
salesman call reports. Time Management provides for review of salesman
performance in relation to time expended. Call information appears on
Sales Analysis Reports and Management Reports for comparison to sales and
commissions. This information is extremely helpful in discussions with
salesmen and customers, as well as manufacturers.
You enter a minimum of information--MACS does the rest.
Once call activity has been entered into the MACS system, the
information is available for printing on Sales Analysis reports using
various formats and sorts, as shown below.
Total Sales Analysis by Customer with Call Summary (Format Y, Sort
SA1)
Y /SA1 SR\11.1 Any Sales Oriented Agency PAGE 1
11/15/06 S/A REPORT: Smn / Cst * 2* Jim Black Calls 10/06 Sales 10/06
—————————————————————————————————————————————————————————————————————————————————————————————————————————————
CUSTOMER LAST CURR YEAR - TO - DATE COMPARISON TOTAL ** CALLS YTD **
ACTVY MONTH CURR LAST $ % LST YR LAST PRIM SEC
—————————————————————————————————————————————————————————————————————————————————————————————————————————————
Abbott Health Produc Louisville K 10/06 18560 243793 114155 120638 +114% 126615 10/06 86 28
Adel's Dist / Cinci Cincinnati, 10/06 14784 185548 237671 52123- -22% 278975 10/06 37 06
Baker Tubing Louisville K 10/06 9772 106542 100682 5860 +6% 119315 10/06 48 12
Aerovent Cooling South Bend I 10/06 13604 102983 132831 29848- -22% 170131 8/06 37
Acme Sign Company Cincinnati O 10/06 1777 90838 10546 71292 +365% 10546 10/06 71 78
Antenna Development South Bend I 10/06 5476 87368 161709 74341- -46% 194486 10/06 61 8
American Instruments Louisville K 10/06 10316 72880 49834 23046 +46% 57502 10/06 37 23
Aiken Sanding Ashland KY 10/06 1105 59750 105171 45421- -43% 111710 9/06 32
American Tooling Co Cincinnati O 10/06 5603 27229 31190 3061- -13% 30514 10/06 26 45
Alcon Enterprises, I Owensboro KY 8/06 11481 59081 47600- -81% 59081 10/06 16 3
Area Chemical Ashland KY 9/06 177 83 94 +113% 139 10/06 14
Jim Black 10/06 80997 988589 1011053 23364- -2% 1177014 10/06 379 293
Calls 10/31/06 16 379 506 588
(Desc Sales-ThisYTD )
|
"How many primary and secondary calls were made to generate sales
for my agency?"
Customer Sales Analysis by Manufacturer with Call Summary (Format Z,
Sort LR2)
Z /LR2 SR\11.1 Any Sales Oriented Agency PAGE 1
11/15/06 S/A REPORT: Smn / St/Reg / Cst / Mfg * 2* Jim Black Calls 10/06 Sales 10/06
—————————————————————————————————————————————————————————————————————————————————————————————————————————————
STATE/REGION LAST CURR YEAR - TO - DATE THIS-VS-LAST THIS-VS-PREV TOTAL
CUSTOMER ACTVY MONTH THIS-YR LAST-YR PREV-YR $ % $ % LAST YR
—————————————————————————————————————————————————————————————————————————————————————————————————————————————
OH, Cincinnati
Adel's Dist / Cinci **Mr. William Shelton **** C * B ***************************************
Cincinnati, OH 717 Alpha Drive P O Box 9812 45122-1234 513-442-0600
Apcal Alloy Compa 10/06 338 821 194 151 627 +323% 670 +444% 8243
Isle Restoring Co 10/05< 887 569 887--100% 569--100% 459
Lee Jacob Mfg 10/06 11471 166203 222819 177454 56616- -25% 11251- -6% 257314
MNC Company 10/06 810 8303 3004 2149 5299 +176% 6154 +286% 248
Simpso Part Suppl 10/06 2165 10221 10767 8509 546- -5% 1712 +20% 12711
*Ttl Cust *ADED00CI* 10/06 14784 185548 237671 188832 52123- -22% 3284- -2% 278975
Calls 10/31/06 3 37 57 40 68
------------------------------------------------------------------------------------------------------------
* Ttl St/Reg *OH102* 10/06 22164 303615 288407 229219 15208 +5% 74306 +32% 338035
Calls 10/31/06 6 134 123 78 145
|
"How many calls were made to a particular customer or
region?"
Commission Income Analysis per Call (Format T, Sort C1)
T /C1 SR\11.1 Any Sales Oriented Agency PAGE 1
11/15/06 S/A REPORT: Cst YTD Descending Calls 10/06 Sales 10/06
—————————————————————————————————————————————————————————————————————————————————————————————————————————————
SMN CUSTOMER LAST CURR * YEAR-TO-DATE * *COMPARISON* * YEAR-TO-DATE *
ACTVY MONTH CURR LAST $ % COMM$ CALLS CM/CL
—————————————————————————————————————————————————————————————————————————————————————————————————————————————
4 American Air Product Toledo OH 10/06 65163 488480 362137 126343 +35% 20424 48 426
4 Adel's Dist / Toledo Toledo, Ohio 10/06 81832 414916 157828 257088 +163% 22700 61 372
4 Akland Printing Equi Fort Wayne IN 10/06 527 251033 405058 154925- -38% 3547 47 75
2 Abbott Health Produc Louisville KY 10/06 18560 243793 114155 120638 +114% 7543 86 88
4 American Laboratorie Indianapolis IN 10/06 34134 237017 97261 139756 +144% 13553 62 219
3 Achin Welding Co Flint MI 10/06 16225 197507 125065 71542 +57% 11171 63 177
------------------------------------------------------------------------------------------------------------
3 Ballash Tile Company Detroit MI 9/06 16 16 2 1 2
1 Albert Molded Spcial Dayton OH 1/05< 141273 141273--100% 1
*REPORT TOTAL* 10/06 433526 4088738 3810673 278065 +7% 218118 1392 157
Calls 10/31/06 77 1392 1623
(Desc Sales-ThisYTD )
|
"What is the ratio of commission dollars earned to calls made for
each customer?" |
