TCSDocuPInvVarAnal
ACME TRUCK SERVICING LTD
Detailed Purchase Invoice Variance Analysis
For all departments, for all suppliers, ordered by invoice number
Invoices numbered from first to last, dated from 01 Nov 2009 to 30 Nov 2009, variances exceeding 0.00%, variance items only
Ord Unit Cost
Item Code & Description
% Var
Shp Variance
Warehouse
Qty
Inv Unit Cost
Shp Unit Cost
Ord Variance
% Var
% VAR
ORDER VAR
% VAR
DEPT
SHIPMENT TOTAL
INVOICE
INV DATE
SUPPLIER ACCOUNT & NAME
SUPP INVOICE
INVOICE TOTAL
SHIPMENT VAR
ORDER TOTAL
-2.46%
-30.00
1,220.00
1,220.00
10
LI000215
06 Nov 2009
3275 Engine Rebuilders Ltd
E061109
1,190.00
165159 Misc Waterpump Re-manf
5
130.00
130.00
125.50
-22.50
-3.46%
MAIN
165151-R2 Detroit 8.2 Waterpump Re-Manf
3
190.00
190.00
187.50
-7.50
-1.32%
MAIN
-6.04%
-22.50
372.50
372.50
50
LI000216
11 Nov 2009
3675 Radiator Services
R111109
350.00
72022 Check and repair radiator as required
1
372.50
372.50
350.00
-22.50
-6.04%
-0.30%
-10.00
3,317.50
3,317.50
10
LI000217
16 Nov 2009
3260 Exhaust Specialities Ltd
E151109
3,307.50
122203 Exhaust Clamp, 3"
20
11.25
11.25
10.95
-6.00
-2.67%
MAIN
122204 Exhaust Clamp, 4"
10
12.25
12.25
11.95
-3.00
-2.45%
MAIN
122205 Exhaust Clamp, 5"
20
14.00
14.00
13.95
-1.00
-0.36%
MAIN
-4.64%
-218.75
4,718.75
4,718.75
50
LI000218
24 Nov 2009
3625 Panel & Paint Services Ltd
P241109
4,500.00
72035 Repair and paint cab
1
4,718.75
4,718.75
4,500.00
-218.75
-4.64%
-6.43%
-27.50
427.50
427.50
50
LI000219
25 Nov 2009
3675 Radiator Services
R251109
400.00
72035 Repair damaged radiator, replace hoses
1
427.50
427.50
400.00
-27.50
-6.43%
-0.60%
-61.70
-20.75%
-2,117.70
8,089.00
10,206.70
10
XI000097
18 Nov 2009
3905 Australian Brake Corp Ltd
Q111109
10,145.00
142312 Brake Lining Set, COF 0.36
40
186.12
147.50
-1,544.80
-20.75%
184.13
-79.60
-1.07%
MAIN
-1.74%
-15.20
-26.48%
-231.20
642.00
873.20
10
XI000098
26 Nov 2009
3918 RST Filter Corporation
R121109
858.00
114151-S2 Oil Filter, Detroit 8.2
40
7.48
5.50
-79.20
-26.47%
7.22
-10.40
-3.48%
MAIN
117151-S2 Fuel Filter, Detroit 8.2
40
14.35
10.55
-152.00
-26.48%
14.23
-4.80
-0.84%
MAIN
-3.05%
-21.60
-27.50%
-195.00
514.00
709.00
10
XI000099
30 Nov 2009
3915 Perkins Diesel Inc
P131109
687.40
114152-S2 Oil Filter, Perkins
20
13.59
9.85
-74.80
-27.52%
13.06
-10.60
-3.90%
MAIN
117152-S2 Fuel Filter, Perkins
20
21.86
15.85
-120.20
-27.49%
21.31
-11.00
-2.52%
MAIN
Total:
21,845.15
19,301.25
-2,543.90
-11.65%
21,437.90
-407.25
-1.86%
Printed on 11 Dec 2009 at 03:51 PM
Page 1 of 1