Services Limited
Integrated Business Solutions
|
|
Services Limited | Integrated Business Solutions | |
|---|---|---|---|
| SALES REPORTS |
All the reports have been run for a single salesman by Sales Code except for 8SMP02D2 which is a product report.
Salesman x Sales Code Values Only
Covering 1 period from 1/07/2001 to 31/07/2001
------------ C u r r e n t P e r i o d -------------- ---------- L a s t 1 2 m o n t h s --------
Total --- Gross Profit --- Target --variance-- Total --- Gross Profit --- Target --variance--
Description sales $ % Share $ -var- % sales $ % Share $ -var- %
Salesman: KJ KIM
PT PARTS 635 118 18.5 .4 118 8,719 1,931 22.1 .7 1,931
CS COMPONENTS 112 192
KS KITS 820 820 100.0 3.0 7,800 6,980- 89.5- 10,970 10,970 100.0 3.9 93,600 82,630- 88.3-
KJ === TOTALS === 1,567 938 59.9 3.5 7,800 6,862- 88.0- 19,881 12,901 64.9 4.6 93,600 80,699- 86.2-
Salesman x Sales Code Values Only
Covering 1 period from 1/07/2001 to 31/07/2001
-------- T H I S P E R I O D ------- ----- L A S T 1 2 M O N T H S -----
-------- This year ----------- ---- Last Year --- -------- This year ----------- ---- Last Year ---
Description Actual GP% Budget % Actual GP% Actual GP% Budget % Actual GP%
Salesman: KJ KIM
PT PARTS 634 18.5 939 22.1 8,718 22.1 11,290 20.0
CS COMPONENTS 112 192 1,746 7.8-
KS KITS 5,481 45.2
EX EXTRAS 820 100.0 7,800 89.5- 4,160 100.0 10,970 100.0 93,600 88.3- 22,268 99.6
GG GOODS 19,200 100.0
KJ === TOTALS === 1,566 59.9 7,800 79.9- 5,099 85.6 19,880 64.9 93,600 78.8- 59,985 76.6
8SMP02C3 12-period report - MAT
Salesman x Sales Code Values Only
Covering 1 period from 1/07/2001 to 31/07/2001
CODE DESCRIPTION 1 2 3 4 5 6 7 8 9 10 11 12 Last 12 Prev 12
Salesman: KJ KIM
PT PARTS 635 787 1868 266 1285 491 109 157 268 585 684 1586 8719 11290
CS COMPONENTS 112 80 192 1746
KS KITS 5482
EX EXTRAS 820 80 460 400 2540 320 280 1270 1960 960 1880 10970 22268
GG GOODS 19200
KJ TOTAL 1567 867 2328 266 1766 3031 429 437 1538 2545 1644 3466 19881 59986
Salesman x Sales Code Values Only
Covering 1 period from 1/07/2001 to 31/07/2001
---------- T H I S P E R I O D --------- ------- L A S T 1 2 M O N T H S -------
-------- This year -------- --------- Last Year ----- -------- This year -------- --------- Last Year -----
Description Actual $ -GP- % Actual $ -GP- % Actual $ -GP- % Actual $ -GP- %
Salesman: KJ KIM
PT PARTS 634 118 18.5 939 207 22.1 8,718 1,931 22.1 11,290 2,255 20.0
CS COMPONENTS 112 192 1,746 137- 7.8-
KS KITS 5,481 2,475 45.2
EX EXTRAS 820 820 100.0 4,160 4,160 100.0 10,970 10,970 100.0 22,268 22,168 99.6
GG GOODS 19,200 19,200 100.0
KJ === TOTALS === 1,566 938 59.9 5,099 4,367 85.6 19,880 12,901 64.9 59,985 45,961 76.6
Salesman x Sales Code Values Only
Covering 1 period from 1/07/2001 to 31/07/2001
----------- T H I S P E R I O D ------------ --------- L A S T 1 2 M O N T H S ---------
This Month - this year This Month - last year This Year to date Last Year to date
CODE DESCRIPTION Cost Sales GP% Cost Sales GP% Cost Sales GP% Cost Sales GP%
Salesman: KJ KIM
PT PARTS 516 634 18.5 731 939 22.1 6,788 8,718 22.1 9,035 11,290 20.0
CS COMPONENTS 112 112 192 192 1,882 1,746 7.8-
KS KITS 3,006 5,481 45.2
EX EXTRAS 820 100.0 4,160 100.0 10,970 100.0 99 22,268 99.6
GG GOODS 19,200 100.0
KJ === TOTALS === 628 1,566 59.9 731 5,099 85.6 6,980 19,880 64.9 14,024 59,985 76.6
Salesman x Sales Code Values Only
Covering 1 period from 1/07/2001 to 31/07/2001
CODE DESCRIPTION 1 2 3 4 5 6 7 8 9 10 11 12 Last 12 Prev 12
Salesman: KJ KIM
PT PARTS 118 177 110 30 451 216 11 39 42 219 220 297 1931 2255
CS COMPONENTS 137-
KS KITS 2475
EX EXTRAS 820 80 460 400 2540 320 280 1270 1960 960 1880 10970 22168
GG GOODS 19200
KJ TOTAL 938 257 570 30 851 2756 331 319 1312 2179 1180 2177 12901 45961
Salesman x Sales Code Values Only
Covering 1 period from 1/07/2001 to 31/07/2001
------- L A S T 1 2 M O N T H S --------
*-------- This year -------- --------- Last Year ------
Actual $GP Contr. Actual $GP Contr. Description
Salesman: KJ KIM
PT 8,718 1,931 .7 11,290 2,255 .8 PARTS
CS 192 1,746 137- COMPONENTS
KS 5,481 2,475 .9 KITS
EX 10,970 10,970 3.9 22,268 22,168 7.7 EXTRAS
GG 19,200 19,200 6.7 GOODS
19,880 12,901 4.6 59,985 45,961 16.0
Product Values Only
Covering 1 period from 1/01/2002 to 31/01/2002
------- This year ------- ------- Last Year -------
Description Sell Pr Avg cost Avg sell Qty Value GP% Qty Value GP%
CODE Description 12.00 5.75 12.27 11 135 42.8 8 88 30.6
Salesman x Sales Code Values Only
Covering 1 period from 1/07/2001 to 31/07/2001
-----T H I S M O N T H------ -----Y E A R T O D A T E-----
Description Last Yr. This Yr. % Value Last Yr. This Yr. % Value
Salesman: KJ KIM
PT PARTS 939.02 634.61 18.5 117.67 11,290.27 8,718.63 22.1 1,930.56
CS COMPONENTS 112.00 1,746.10 192.34
KS KITS 5,481.50
EX EXTRAS 4,160.00 820.00 100.0 820.00 22,268.00 10,970.00 100.0 10,970.00
GG GOODS 19,200.00
KJ === TOTALS === 5,099.02 1,566.61 59.9 937.67 59,985.87 19,880.97 64.9 12,900.56
Salesman x Sales Code Values Only
Covering 1 period from 1/07/2001 to 31/07/2001
----- T H I S M O N T H ------ ----- Y E A R T O D A T E -----
Annual % Tot Annual % Tot
Description Last Yr. This Yr. Change Sales Last Yr. This Yr. Change Sales
Salesman: KJ KIM
PT PARTS 939.02 634.61 304.41- 2.1 11,290.27 8,718.63 2,571.64- 2.5
CS COMPONENTS 112.00 112.00 .4 1,746.10 192.34 1,553.76- .1
KS KITS 5,481.50 5,481.50-
EX EXTRAS 4,160.00 820.00 3,340.00- 2.7 22,268.00 10,970.00 11,298.00- 3.1
GG GOODS 19,200.00 19,200.00-
KJ === TOTALS === 5,099.02 1,566.61 3,532.41- 5.1 59,985.87 19,880.97 40,104.90- 5.7
Salesman x Sales Code Values
Covering 1 period from 1/07/2001 to 31/07/2001
<--- T H I S P E R I O D ----> <-- L A S T 12 M O N T H S -->
COST Cost Sales GP $ GP% Cost Sales GP $ GP%
Salesman: KG KIM
PT 516 634 117 18.5 6,550 8,266 1,716 20.8 PARTS
CS 112 112 316 332 16 4.8 COMPONENTS
FR FREIGHT
KS 820 820 100.0 10,970 10,970 100.0 KITS
EX EXTRAS
KG 628 1,566 937 59.9 6,866 19,568 12,702 64.9 === TOTALS ===
=TOTALS== 628 1,566 937 59.9 6,866 19,568 12,702 64.9
* Format: ASCII, Comma-delimited
* Output: Based on 8SMP02C1
* Format: ASCII, Comma-delimited
* Output: Based on 8SMP02C3
* Format: ASCII, Comma-delimited
* Output: Based on 8SMP02C7
Customer x Sales Code Values Only
Covering 1 period from 1/07/2001 to 31/07/2001
------------ C u r r e n t P e r i o d -------------- ------------ Y e a r t o D a t e ------------
Total --- Gross Profit --- Target --variance-- Total --- Gross Profit --- Target --variance--
Description sales $ % Share $ -var- % sales $ % Share $ -var- %
Customer: COGITO Cogito Ltd
PT PARTS 135 21 15.2 .1 21 575 216 37.6 .2 216
CS COMPONENTS 862 230 26.7 .9 230 1,383 467 33.8 .5 467
KS Hardware services 1,320 1,320 100.0 4.9 1,320 2,460 2,460 100.0 2.4 2,460
EX Extras 3,252 3,252 100.0 12.1 3,252 9,160 9,160 100.0 8.9 9,160
GG Goods 1,600 1,600 100.0 5.9 1,600 6,400 6,400 100.0 6.2 6,400
COGITO === TOTALS === 7,169 6,423 89.6 23.9 6,423 19,978 18,704 93.6 18.1 18,704
Customer x Sales Code Values Only
Covering 1 period from 1/07/2001 to 31/07/2001
-------- T H I S P E R I O D ------- ------- Y E A R T O D A T E --------
-------- This year ----------- ---- Last Year --- -------- This year ----------- ---- Last Year ---
Description Actual GP% Budget % Actual GP% Actual GP% Budget % Actual GP%
Customer: COGITO Cogito Ltd
PT PARTS 135 15.2 108 25.0 575 37.6 1,420 23.6
CS COMPONENTS 862 26.7 1,533 9.8 1,383 33.8 3,882 15.4
KS KITS 1,320 100.0 580 100.0 2,460 100.0 7,340 100.0
EX EXTRAS 3,252 100.0 2,604 100.0 9,160 100.0 14,638 100.0
GG GOODS 1,600 100.0 1,600 100.0 6,400 100.0 6,400 100.0
COGITO === TOTALS === 7,169 89.6 6,425 77.2 19,978 93.6 33,681 87.0
Customer x Sales Code Values Only
Covering 1 period from 1/07/2001 to 31/07/2001
----------- C u r r e n t P e r i o d ------------- ---------- Y e a r t o D a t e -----------
-------- This year -------- --------- Last Year ----- -------- This year -------- --------- Last Year -----
Description Actual $ -GP- % Actual $ -GP- % Actual $ -GP- % Actual $ -GP- %
Customer: COGITO Cogito Ltd
PT PARTS 135 21 15.2 108 27 25.0 575 216 37.6 1,420 335 23.6
CS COMPONENTS 862 230 26.7 1,533 150 9.8 1,383 467 33.8 3,882 599 15.4
KS KITS 1,320 1,320 100.0 580 580 100.0 2,460 2,460 100.0 7,340 7,340 100.0
EX EXTRAS 3,252 3,252 100.0 2,604 2,604 100.0 9,160 9,160 100.0 14,638 14,638 100.0
GG GOODS 1,600 1,600 100.0 1,600 1,600 100.0 6,400 6,400 100.0 6,400 6,400 100.0
COGITO === TOTALS === 7,169 6,423 89.6 6,425 4,961 77.2 19,978 18,704 93.6 33,681 29,312 87.0
Customer x Sales Code Values Only
Covering 1 period from 1/07/2001 to 31/07/2001
----------- T H I S P E R I O D ------------ ------------ Y E A R T O D A T E -----------
This Month - this year This Month - last year This Year to date Last Year to date
CODE DESCRIPTION Cost Sales GP% Cost Sales GP% Cost Sales GP% Cost Sales GP%
Customer: COGITO Cogito Ltd
PT PARTS 114 135 15.2 81 108 25.0 359 575 37.6 1,086 1,420 23.6
CS COMPONENTS 631 862 26.7 1,383 1,533 9.8 915 1,383 33.8 3,283 3,882 15.4
KS KITS 1,320 100.0 580 100.0 2,460 100.0 7,340 100.0
EX EXTRAS 3,252 100.0 2,604 100.0 9,160 100.0 14,638 100.0
GG GOODS 1,600 100.0 1,600 100.0 6,400 100.0 6,400 100.0
COGITO === TOTALS === 746 7,169 89.6 1,464 6,425 77.2 1,274 19,978 93.6 4,369 33,681 87.0