MACS Forecasting Module
Forecasting establishes and maintains forecast data. Enter sales quotas
or forecasts into MACS. Forecast Worksheets (below) are available for
quick and easy entry.
- You can forecast sales, commission received and orders.
- Space is provided for current and next year's forecasted sales for
each salesman's customer buying from a particular manufacturer.
- Forecasts may be calculated automatically by setting next year's
forecast to a percentage of the current year.
- Forecasts may be entered by each salesman for a manufacturer total
or for each customer/manufacturer.
FO\12.1 Any Sales Agency, Inc. 2 Jim Black Page 1
11/15/06 Forecast Worksheet/Report - Sales Mfg *LJM* Lee Jacob Mfg 10/06
—————————————————————————————————————————————————————————————————————————————————————————————————————————————
CustCd Name DateLast ** Next Year ** *** This Year *** ***** Annual Sales *****
Smn City / State Actvty Forecast Y-T-D Forecast LastYr PrevYr 3YrsAgo
—————————————————————————————————————————————————————————————————————————————————————————————————————————————
ABBH00 Abbott Health Products
Louisville KY 10/31/06 ________ 25366 25725 23840 17592 20716
ACMS00 Acme Sign Company
Cincinnati OH 10/20/06 ________ 1777 0 0 0 0
ADED00CI Adel's Dist / Cinci
Cincinnati, OH 10/31/06 ________ 166203 320160 257314 198390 228973
AIKS00 Aiken Sanding
Ashland KY 10/31/06 ________ 20389 42137 31408 23845 27627
ALCE00 Alcon Enterprises, Inc.
Owensboro KY 8/31/06 ________ 11481 10166 11060 9070 10515
AMEI00 American Instruments
Louisville KY 10/26/06 ________ 66400 79751 57502 43219 50361
AMET00 American Tooling Co
Cincinnati OH 10/31/06 ________ 12168 13890 11862 8984 10423
ANTD00 Antenna Development Inc
South Bend IN 7/31/05 ________ 0 269 234 187 211
Totals ________ 303784 492098 394120 301287 348826
________ _________________________ ________
________ _________________________ ________
________ _________________________ ________
________ _________________________ ________
________ _________________________ ________
________ _________________________ ________
|
Forecast information is available on several Sales Analysis Reports and
Management Inquiry screens. Forecasts are
entered as an annual total, but MACS prorates them on reports for
comparison with year-to-date totals.
Sales Analysis with Annual Forecast Prorated (Format K, Sort S3)
K /S3 SA\11.1 Any Sales Agency, Inc. PAGE 1
11/15/06 S/A REPORT: Smn / Mfg * 2* Jim Black Sales 10/06
———————————————————————————————————————————————————————————————————————————————————————————————————————————
LAST CURR % * Y E A R - T O - D A T E * * COMPARISON * TOTAL
MANUFACTURER ACTVY MONTH REL FCST CURR LAST $ % LAST YR
———————————————————————————————————————————————————————————————————————————————————————————————————————————
Apcal Alloy Company 10/06 13583 +206% 60462 184064 55362 120602 +234% 58789
B.C. Industries 10/06 5980 -44% 111255 62579 86269 23690- -27% 115648
H. F. Krause 10/06 9335 +33% 69056 91563 66463 25100 +38% 72767
Isle Restoring Co. 9/06 -39% 1488 912 1589 677- -43% 1377
Lee Jacob Mfg 10/06 31984 -26% 410082 303784 340300 36516- -11% 394120
MNC Company 10/06 14625 -4% 123582 118327 138085 19758- -14% 172321
Rollins/Parts Group 8/06 -72% 30324 8635 34550 25915- -75% 41864
Rollins/Components Group 10/06 453 +45% 3763 5451 3830 1621 +42% 5276
Saclia Supply 10/06 78 -72% 704 198 987 789- -80% 987
Simpso Part Supply 10/06 4959 +31% 28639 37590 24563 13027 +53% 33265
Simplex Manufacturing 9/06 -34% 264198 174586 174586
S P & P Inc. 12/05< 259955 259955- -100% 280600
* Total Slsmn * 2* 10/06 80997 -10% 1103553 988589 1011953 23364- -2% 1177014
|
"I need to monitor our annual forecast throughout the year."
Sales Analysis with Annual Forecast in Total (Format M, Sort S1)
M /S1 SR\11.1 Any Sales Oriented Agency PAGE 1
11/15/06 S/A REPORT: Smn / Mfg / Cst * 2* Jim Black Sales 10/06
———————————————————————————————————————————————————————————————————————————————————————————————————————————
MANUFACTURER LAST CURR YEAR-TO-DATE COMPARISON* ** ANNUAL SALES **
CUSTOMER ACTVY MONTH THIS LAST $ % TARGET LST YR PRIOR
———————————————————————————————————————————————————————————————————————————————————————————————————————————
Apcal Alloy Company
Abbott Health Produc Louisville K 10/06 13245 184143 55168 128975 +234% 65484 50546 35404
Adel's Dist / Cinci Cincinnati, 10/06 338 821 194 627 +323% 7070 8243 4980
* Total Mfg *APC* 10/06 13583 184064 55362 120602 +234% 72554 58789 40384
.
.
.
Lee Jacob Mfg
Adel's Dist / Cinci Cincinnati, 10/06 11471 166203 222819 56616- -25% 320160 257314 198390
American Instruments Louisville K 10/06 10316 66400 49834 16566 +33% 79751 57502 43219
Aiken Sanding Ashland KY 10/06 1105 20389 27583 7194- -26% 42137 31408 23845
Abbott Health Produc Louisville K 10/06 4147 25366 18488 6878 +37% 25725 23840 17592
Alcon Enterprises, I Owensboro KY 8/06 11481 11060 479- -4% 10166 11060 9070
American Tooling Co Cincinnati O 10/06 3168 12168 9382 2786 +30% 13890 11862 8984
Antenna Development South Bend I 7/9< 234 234--100% 269 234 187
Acme Sign Company Cincinnati O 10/06* 1777 1777 1777
* Total Mfg *LJM* 10/06 31984 303784 340300 36516- -11% 492098 394120 301287
.
.
.
* Total Slsmn * 2* 10/06 80997 988589 1011953 23364- -2% 1324264 1177014 891161
Calls 10/31/06 19 465 586 692
(Desc Sales-LastYrTtl)
|
"How can I see my annual forecast on sales reports?" |
