TCSDocuPInvVarAnal
ACME TRUCK SERVICING LTD
Detailed Purchase Invoice Forex 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
Values presented in Australian Dollar
-1.24%
-100.00
8,089.00
8,089.00
10
XI000097
18 Nov 2009
3905 Australian Brake Corp Ltd
Q111109
7,989.00
142312 Brake Lining Set, COF 0.36
40
147.50
147.50
145.00
-100.00
-1.69%
MAIN
Total Australian Dollar:
8,089.00
8,089.00
7,989.00
-100.00
-1.24%
Values presented in New Zealand Dollar
-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%
Total New Zealand Dollar:
10,056.25
10,056.25
9,747.50
-308.75
-3.07%
Values presented in United States Dollar
-2.80%
-18.00
642.00
642.00
10
XI000098
26 Nov 2009
3918 RST Filter Corporation
R121109
624.00
114151-S2 Oil Filter, Detroit 8.2
40
5.50
5.50
5.25
-10.00
-4.55%
MAIN
117151-S2 Fuel Filter, Detroit 8.2
40
10.55
10.55
10.35
-8.00
-1.90%
MAIN
-2.72%
-14.00
514.00
514.00
10
XI000099
30 Nov 2009
3915 Perkins Diesel Inc
P131109
500.00
114152-S2 Oil Filter, Perkins
20
9.85
9.85
9.50
-7.00
-3.55%
MAIN
117152-S2 Fuel Filter, Perkins
20
15.85
15.85
15.50
-7.00
-2.21%
MAIN
Printed on 11 Dec 2009 at 03:55 PM
Page 1 of 2
TCSDocuPInvVarAnal
ACME TRUCK SERVICING LTD
Detailed Purchase Invoice Forex 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
Total United States Dollar:
1,156.00
1,156.00
1,124.00
-32.00
-2.77%
Printed on 11 Dec 2009 at 03:55 PM
Page 2 of 2