TCSDebtMissedSalesOpps
ACME TRUCK SERVICING LTD
Missed Sales Opportunities Report
For selected debtor control accounts, for all inventory control accounts, for all warehouses, top 5 items ranked by sales value
Debtor control
130
Item ranking for the period 01 Jun 2009 to 30 Jun 2009, customer purchasing for the period 01 Apr 2009 to 30 Jun 2009, ordered by customer alpha key
Inventory Item Code & Description
Sales Value
Inventory Item Code & Description
Sales Value
Inventory Item Code & Description
Sales Value
Sales Analysis:
D - Detroit Products
117151-S2 Fuel Filter, Detroit 8.2
114151-S2 Oil Filter, Detroit 8.2
2,177
1,089
Sales Analysis:
P - Perkins Products
117152-S2 Fuel Filter, Perkins
114152-S2 Oil Filter, Perkins
1,552
944
Sales Analysis:
Z - All Makes Products
108120 Battery, 12 Volt 21 Plate
142312 Brake Lining Set, COF 0.36
108200 Battery, 12 Volt 37 Plate
1,734
1,537
1,206
122105 Exhaust Tubing, 5"
101692 Headlamp Insert, Outer, Q/H
1,060
644
Page 1 of 1
Printed on 24 Jul 2009 at 11:09 AM
TCSDebtMissedSalesOpps
ACME TRUCK SERVICING LTD
Missed Sales Opportunities Report
Customer Account Number & Name
Non Purchased Items
S/A
10015 Auckland Storage & Freight Ltd
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
10120 Balmoral Transport Co
117151-S2
114151-S2
D
108200
108120
Z
10000 Cash Sales
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
18001 Central Transport Holdings Ltd
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
10215 Coastal Storage & Freight
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
10350 Davies Transport
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
19305 Deagon Transport Services Ltd
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
10695 Mr R G Edwards
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
10725 Frankton Freight
142312
122105
Z
10773 Freightline NZ Ltd
101692
Z
10835 Mr M L Grant
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
11480 Highways Freight Services Ltd
117152-S2
114152-S2
P
11520 Hutt Transport Services
117151-S2
114151-S2
D
Page 1 of 3
Printed on 24 Jul 2009 at 11:09 AM
TCSDebtMissedSalesOpps
ACME TRUCK SERVICING LTD
Missed Sales Opportunities Report
Customer Account Number & Name
Non Purchased Items
S/A
11520 Hutt Transport Services (Cont.)
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
11540 Hutt Transport Supplies
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
11600 Mainfreight NZ Ltd
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
10645 Mr G D Mitchell
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
12570 Nationwide Freighters Ltd
117152-S2
114152-S2
P
122105
Z
11715 N Z Freight Services Ltd
122105
101692
Z
11870 Prestige Removals Ltd
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
11650 Rangitikei Transport Co
117152-S2
114152-S2
P
11655 Mr T B Robinson
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
101692
Z
11985 Mr T J Robinson
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
15523 Smiths Transport Ltd
142312
122105
101692
Z
10999 Sundry Debtors
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
11880 Taranaki Motor Spares
117151-S2
114151-S2
D
117152-S2
114152-S2
P
Page 2 of 3
Printed on 24 Jul 2009 at 11:09 AM
TCSDebtMissedSalesOpps
ACME TRUCK SERVICING LTD
Missed Sales Opportunities Report
Customer Account Number & Name
Non Purchased Items
S/A
11880 Taranaki Motor Spares (Cont.)
142312
122105
108200
108120
101692
Z
11890 Transport NZ Ltd
117151-S2
114151-S2
D
117152-S2
114152-S2
P
142312
122105
108200
108120
101692
Z
11950 Waikato Transport Ltd
101692
Z
11900 Wanganui Transport Ltd
117152-S2
114152-S2
P
Page 3 of 3
Printed on 24 Jul 2009 at 11:09 AM