TCSWhsePriceAnalysis
ACME TRUCK SERVICING LTD
Warehouse code MAIN
Inventory Pricing Analysis
For all franchises
From first group to last group, from first account to last account, ordered by franchise
Prices R, U and P, excluding GST, all increases only
Margin
Variance
Margin
Margin
Proposed
New Retail
Retail
Margin & Group
Unit
Account Name
Account
Superseded By
Franchise: P - Perkins
35.38%
25.66
3.92%
37.43%
26.50
34.97%
25.50
P2
B
Oil Filter, Perkins
114152-S2
Each
37.58%
41.84
2.41%
38.55%
42.50
37.07%
41.50
P2
B
Fuel Filter, Perkins
117152-S2
Each
Franchise: Z - All Makes
30.84%
94.40
15.90%
30.84%
94.40
19.85%
81.45
P1
A
Lamp, L/Range Driving 12V 55W
100805
Each
31.03%
100.92
16.07%
31.03%
100.92
19.95%
86.95
P1
A
Lamp, L/Range Driving 12V 100W
100810
Each
31.03%
109.33
14.90%
31.03%
109.33
20.75%
95.15
P1
A
Headlamp Insert, Inner, Q/H
101691
Each
31.04%
103.68
14.25%
31.04%
103.68
21.21%
90.75
P1
A
Headlamp Insert, Outer, Q/H
101692
Each
31.03%
14.21
14.14%
31.03%
14.21
21.29%
12.45
P1
A
Lamp, Cab Marker, Clear
103100
Each
31.09%
14.21
14.14%
31.09%
14.21
21.35%
12.45
P1
A
Lamp, Cab Marker, Amber
103104
Each
31.03%
14.21
14.14%
31.03%
14.21
21.29%
12.45
P1
A
Lamp, Cab Marker, Red
103105
Each
30.55%
16.82
7.24%
30.83%
16.89
25.83%
15.75
P1
A
Bulb 24V, Licence Plate
103207
Each
31.06%
14.65
16.73%
31.06%
14.65
19.52%
12.55
P1
A
Bulb 12V 55W, Q/H
105205
Each
31.03%
16.24
15.59%
31.03%
16.24
20.28%
14.05
P1
A
Bulb 12V 100W, Q/H
105210
Each
31.03%
20.59
16.00%
31.03%
20.59
20.00%
17.75
P1
A
Bulb 24V 70W, Q/H
105407
Each
31.03%
23.49
15.43%
31.03%
23.49
20.39%
20.35
P1
A
Bulb 24V 100W, Q/H
105410
Each
31.01%
252.74
2.31%
31.67%
255.20
30.10%
249.45
P1
A
Battery, 12 Volt 21 Plate
108120
Each
31.04%
283.19
1.23%
31.04%
283.19
30.19%
279.75
P1
A
Battery, 12 Volt 27 Plate
108150
Each
31.04%
354.24
1.37%
31.04%
354.24
30.09%
349.45
P1
A
Battery, 12 Volt 37 Plate
108200
Each
31.04%
46.33
6.51%
31.04%
46.33
26.55%
43.50
Radiator, Top Hose (NZ Mod)
119151-NZ
Each
31.09%
15.66
6.17%
31.09%
15.66
26.84%
14.75
P1
A
Exhaust Tubing, 3"
122103
Foot
33.04%
18.78
12.12%
33.04%
18.78
24.93%
16.75
P1
A
Exhaust Tubing, 4"
122104
Foot
31.03%
25.38
7.77%
31.03%
25.38
25.67%
23.55
P1
A
Exhaust Tubing, 5"
122105
Foot
32.64%
18.71
13.05%
32.64%
18.71
23.85%
16.55
P1
A
Exhaust Clamp, 3"
122203
Each
31.03%
20.16
8.68%
31.03%
20.16
25.05%
18.55
P1
A
Exhaust Clamp, 4"
122204
Each
32.95%
23.06
12.21%
32.95%
23.06
24.76%
20.55
P1
A
Exhaust Clamp, 5"
122205
Each
145710B
25.94%
38.21
4.54%
25.94%
38.21
22.57%
36.55
P2
B
Slack Adjuster, 10 Spline
145710
Each
145710B
25.93%
45.78
21.92%
25.93%
45.78
9.69%
37.55
P2
B
Slack Adjuster, 10 Spline
145710A
Each
33.18%
48.59
28.04%
33.18%
48.59
14.45%
37.95
P2
B
Slack Adjuster, 10 Spline
145710B
Each
145728B
25.93%
40.57
5.79%
25.93%
40.57
21.64%
38.35
P2
B
Slack Adjuster, 28 Spline
145728A
Each
35.11%
43.97
10.06%
35.11%
43.97
28.58%
39.95
P2
B
Slack Adjuster, 28 Spline
145728B
Each
Page 1 of 1
Printed on 04 Feb 2005 at 01:02 PM