TCSJobMakeAnalysis
ACME TRUCK SERVICING LTD
Cost Details Jobs by Make Analysis
For all control accounts, for all vehicle makes, for the period from 01 Jan 2010 to 31 Jan 2010, all jobs, ordered by account number
Billed Value
Accum Costs
Status
Job Start
Account Number & Name
Vehicle Make
Purch Services
Act Hrs
Employee Time
Inventory Use
Sundry Costs
Est Hrs
Control account 220.10 JOB COSTING-AUCKLAND WORKSHOP
Complete
12 Jan 2010
10043566 Hino FE1JKKA
Hino
12.00
10.00
450.00
4,126.51
25.00
4,601.51
4,511.51
Open
25 Jan 2010
10043572 Hino FE1JPKA 10055
5.00
5.50
220.00
3,128.45
3,348.45
Complete
27 Jan 2010
10043574 Hino FE1JPKA 10037
8.00
9.00
407.50
1,036.90
279.39
1,723.79
1,718.40
6,229.91
9,673.75
3
Total for Hino:
25.00
1,077.50
5,163.41
3,432.84
24.50
Complete
05 Jan 2010
10043560 MACK R686RS 77757
Mack
0.25
0.25
9.25
0.46
9.71
9.71
Complete
05 Jan 2010
10043561 MACK CH689RST 56344
4.00
4.00
166.00
83.54
237.20
486.74
486.74
Complete
06 Jan 2010
10043563 MACK R685RS 29685
5.00
5.50
203.50
83.54
295.68
582.72
527.22
Complete
09 Jan 2010
10043564 MACK CH613RSX 69863
4.00
4.50
202.50
83.54
277.13
563.17
563.17
Complete
11 Jan 2010
10043565 MACK MHR613RST 1386
0.25
0.25
10.06
0.50
10.56
10.56
Complete
13 Jan 2010
10043567 MACK CH613RST 71638
4.00
5.00
225.00
83.54
281.90
590.44
590.44
Open
14 Jan 2010
10043568 MACK CH689RST 56344
10.00
10.00
450.00
17.50
467.50
180.00
Complete
19 Jan 2010
10043569 MACK CH613RST 71640
8.00
10.00
450.00
450.00
360.00
Complete
21 Jan 2010
10043570 MACK MHS613RST 1385
0.25
0.50
23.75
16.74
40.49
25.00
Open
22 Jan 2010
10043571 MACK MHS613RST 1385
6.00
8.00
380.00
2,893.63
3,273.63
Complete
30 Jan 2010
10043577 MACK MHS613RST 1385
10.00
8.00
380.00
28,000.00
119.00
28,499.00
28,499.00
31,251.84
34,973.96
11
Total for Mack:
51.75
2,500.06
28,334.16
4,139.74
56.00
Open
06 Jan 2010
10043562 MAN 27.422 VFR F104142
M A N
3.00
2.50
98.75
98.75
Open
26 Jan 2010
10043573 MAN 10.223 YW 7960
8.00
6.50
260.00
7,856.80
1,293.00
9,409.80
Complete
28 Jan 2010
10043575 MAN 27.422 VFR F104142
6.00
6.00
237.00
875.65
1,112.65
1,112.65
1,112.65
10,621.20
3
Total for M A N:
17.00
595.75
7,856.80
2,168.65
15.00
38,594.40
55,268.91
17
Control Account Total:
93.75
95.50
4,173.31
41,354.37
9,741.23
Page 1 of 1
Printed on 15 Feb 2010 at 11:22 AM
TCSJobMakeAnalysis
ACME TRUCK SERVICING LTD
Summary Jobs by Make Analysis
For all control accounts, for all vehicle makes, for the period from 01 Jan 2010 to 31 Jan 2010, all jobs, analysed by cost value
Vehicle Make
Total
220.10
9,674
Hino
9,674
Percentage by Make:
Percentage of Control Account:
17.50%
17.50%
100.00%
34,974
Mack
34,974
Percentage by Make:
Percentage of Control Account:
63.28%
63.28%
100.00%
10,621
M A N
10,621
Percentage by Make:
Percentage of Control Account:
19.22%
19.22%
100.00%
Control Account Total:
55,269
55,269
100.00%
100.00%
Percentage:
Page 1 of 1
Printed on 15 Feb 2010 at 11:22 AM