TCSDocuStocktakeDiscrep
Stocktake Discrepancies
ACME TRUCK SERVICING LTD
From document 14 to document 14, full stocktake report, ordered by bin location, excluding lot/serial references
Count quantities asterisked are not pack quantity multiples
Pack Qty
Last Count
Cum Var Amt
Variance Amt
Unit Cost
Var Qty
Stock Qty
Count Qty
Count Ref
Count
Line
Bin Locn
Account Name
Account
Warehouse: MAIN - Main-Parts Warehouse Count Date: 11 Feb 2008 Narration: Stocktake Adj
Type: Manual
Zero Qty: No
Lot/Serial Checking: Yes
Stocktake: 14
143320
Service Chamber, Type 20
A01S01
19
1
-2
43.74
87.47 Cr
87.47 Cr
57
55
10 Oct 2006
143324
Service Chamber, Type 24
A01S02
20
1
-1
51.59
51.59 Cr
139.06 Cr
41
40
10 Oct 2006
143330
Service Chamber, Type 30
A01S03
21
1
-2
51.42
102.83 Cr
241.89 Cr
60
58
10 Oct 2006
145710B
Slack Adjuster, 10 Spline
A02A01
22
1
33.11
50
50
10 Oct 2006
145728B
Slack Adjuster, 28 Spline
A02A02
23
1
29.15
55
55
10 Oct 2006
141605
Brake Drum, 15", 3 Spoke
A04C02
16
1
198.30
1
1
10 Oct 2006
141607
Brake Drum, 16", 5 Spoke
A04C04
17
1
215.57
1
1
10 Oct 2006
142312
Brake Lining Set, COF 0.36
A06B03
18
1
-1
181.04
181.04 Cr
422.93 Cr
119
118
10 Oct 2006
100805
Lamp, L/Range Driving 12V 55W
B01A07
1
1
65.10
29
29
10 Oct 2006
100810
Lamp, L/Range Driving 12V 100W
B01A07
2
1
69.60
36
36
10 Oct 2006
103207
Bulb 24V, Licence Plate
B03C01
6
1
-2
11.60
23.20 Cr
446.13 Cr
43
41
10 Oct 2006
103100
Lamp, Cab Marker, Clear
B03C02
3
1
9.80
31
31
10 Oct 2006
103104
Lamp, Cab Marker, Amber
B03C02
4
1
1
9.80
9.80 Dr
436.33 Cr
30
31
10 Oct 2006
103105
Lamp, Cab Marker, Red
B03C02
5
1
9.80
31
31
10 Oct 2006
108120
Battery, 12 Volt 21 Plate
B04A01
7
1
-1
174.30
174.30 Cr
610.63 Cr
25
24
10 Oct 2006
108150
Battery, 12 Volt 27 Plate
B04A02
8
1
195.30
24
24
10 Oct 2006
108200
Battery, 12 Volt 37 Plate
B04A03
9
1
244.30
36
36
10 Oct 2006
197151-R2
Detroit 8.2 Engine Re-Manf
BAY-4
26
1
15,895.00
2
2
30 Jun 2007
119151
Top Hose, Radiator
C01C01
14
1
24.47
11
11
10 Oct 2006
119152
Bottom Hose, Radiator
C01C03
15
1
19.58
7
7
10 Oct 2006
165151-R2
Detroit 8.2 Waterpump Re-Manf
E02A01
24
1
-1
182.50
182.50 Cr
793.13 Cr
4
3
30 Jun 2007
0
1
-1
182.50
1
Lot/Serial:
DWP2007865
***Missing***
165159
Misc Waterpump Re-manf
E02A02
25
1
121.67
6
6
30 Jun 2007
117151-S2
Fuel Filter, Detroit 8.2
F01C01
12
1
-3
15.96
47.87 Cr
841.00 Cr
640
637
10 Oct 2006
117152-S2
Fuel Filter, Perkins
F01C02
13
1
-1
23.48
23.48 Cr
864.48 Cr
366
365
10 Oct 2006
114151-S2
Oil Filter, Detroit 8.2
F02C01
10
1
-2
8.09
16.19 Cr
880.67 Cr
654
652
10 Oct 2006
114152-S2
Oil Filter, Perkins
F02C02
11
1
-1
14.25
14.25 Cr
894.92 Cr
581
580
10 Oct 2006
Lines with count entered:
Lines with positive variances:
Lines with negative variances:
26
26
100.00%
2,924
2,940
-16
1
3.85%
1
9.80 Dr
11
42.31%
-17
904.72 Cr
894.92 Cr
122,578.15 Dr
Totals: Stock Value:
Document Lines:
-0.54%
-0.58%
0.03%
-0.74%
0.01%
-0.73%
31
30
2,573
2,590
Page 1 of 1
Printed on 14 Feb 2008 at 02:19 PM