Total Number of Subscribers: 464   

 



Powered by Prime Academy  
In pursuit of excellence    

    Date: 12th August 2008

Compiled by Mr. M. Sathya Kumar  

 

 

Audit of transport and logistics

Introduction :

Internal Audit was undergoing a radical change at SIA Breakable Products Ltd. The Chief Internal Auditor — Raj Malhotra who had attended an International Conference on Internal Audit had returned with new ideas particularly on Improving Audit Quality. While Raj was abreast with the changes happening in the field of Internal Audit, he focussed on providing ‘adequate performance’ from the Management and Board perspective. He had never ventured into new avenues of internal audit to give a new dimension to the internal audit function. While management was still satisfied with the performance of his team, he sought to make his life a lot more exciting after coming back from the conference. He was attempting to make a qualitative difference in the function of the internal audit department. Hence, he focussed on the ‘Value Add’ and ‘Consulting’ dimension in addition to being focussed on Cost Savings in his audits.

Given the high cost of logistics, he took up for review, with an objective to verify the adequacy of the control system of finalisation of ‘Inward’ and ‘Outward’ freight charges with the transporters and the system of selecting transporters.

Methodology :

An analysis of transport charges was carried out for three financial years. Freight and detention charges data was taken from the concerned department. An analysis of freight charges was carried out both Zone wise & State wise. Detention charges details were taken from the Accounts Department. As Inward freight expenses were included in the raw material cost, details were not available.

Transport agreements were reviewed. Clause no. 19 as per Outward Freight Contract and Clause no. 15 as per Inward Freight Contract on revision of freight charges were particularly reviewed with alternative calculations. An analysis was also carried out by using different data to give the increment in the freight charges as shown in Exhibit and supporting example also given to understand the saving in freight charges in case of change in freight rates.

The above analysis, interaction and feedback received from different officials were the basis of the report submitted to the management.

Gist of observations and recommendations :

Need for obtaining more information about transporters on finalising contracts :

In the past, due to modified contract finalisation processes, freight cost had reduced for the organisation. However, there were difficulties in obtaining vehicles for despatches. This had severely impacted the sale performance. This happened as several contractors backed out of the agreements citing losses. The reasons were :

1. Only lowest rates were considered for finalisation of contracts.

2. Parties’ goodwill, reputation and capacities were not verified.

It was decided that in order to ensure that financially and operationally strong parties are contracted, the following may be obtained from them :

1. Copy of the latest financial statements.

2. Details of transporter’s own vehicles — Number of trucks with the copies of RTO Books.

3. List of customers — If possible take the feedback from such corporates.

4. Copy of the standard contract signed with other customers.

5. His duration in the transport business and whether the contractor has other businesses.

The contract Rates for Transport contracts were finalised on the basis of tenders. Rates used for negotiation were exactly based on past contract rates. The contracts were finalised with escalation clause (clause 19 in Outward freight contract and clause 15 in Inward freight contract) for changes in diesel rates. The benchmark for diesel rate was the rate at which diesel is available in Mumbai.

Further, at times, the diesel rates prevalent at Navi Mumbai were also considered.

Escalation Clause for hike in fuel rates :

Escalation clause was normally invoked only if the hike in fuel rates is above 5% increase or decrease.

Method 1 (New Method) : Out of total per ton freight charge, 35% is of fuel consumption and freight charge increases as increase in percentage of fuel rate to fuel consumption only.

Example : Average fuel rate reference (Mumbai Rate) on October 1, 2004 was Rs.30.31.

Monthly Review No.

Fuel price

Fuel rate reference

Cumulative percentage changes

Increase or decrease in freight rate

Remark

1

30.31

30.31

Nil

Nil

 

2

30.95

30.31

2.11%

Nil

 

3

31.83

30.31

5.00%

Nil

 

4

32.74

30.31

8.00%

2.80%

Effective from 1st day of following month

5

31.10

32.74

- 4.99%

Nil

Less than 5% decrease w.r.t. new fuel rate reference

6

30.11

32.74

- 8.02%

- 2.81%

Effective from 1st day of following month

7

 

30.11

 

 

New fuel rate reference

Method 2 (Old Method) : Company used the following formula to increase the freight charges. The result of using the formula was an increase in the rate per Ton as compared to Method 1.

Formula

 

 

Destination distance in KM ex Navi Mumbai

x

(Rates of diesel after 5% cumulative increase or decrease, as against the price prevailing in Mumbai on the date of work order) — (Diesel rate on the date of work order)

 

 

10 x 4

The transporter was not ready to adopt the 1st method as the consideration of fuel consumption in freight charges per Tonne was at the rate of 35%. As per industry norms, consumption of diesel is near to 50%-60%. (Although Raj was clear that 35- 40% is reasonable, the Purchase Department were unwilling to buy his view and the management also preferred to take one thing at a time. So in the larger interest of goods movement he considered 50%-60% for the working). The internal audit department analysed the total freight cost as per the old method and new method with changed percentages of 50% and 60%. Detailed working is given in Exhibits 1, 2, 3, 4.

Cost Savings could be achieved by realistically considering the diesel component at 50% as shown in Exhibit 1 which was worked out for New Delhi where the road distance was 1407 kms. Refer the illustrative example in Exhibits 1,2,3 and 4 for New Delhi when the hikes in diesel rates are considered by 10.50%, 8.31% & 7.22%.

Delhi :

As per Exhibit 1 — Hike 1 — @ 10.5%

Particulars

 

Benchmark Rate                ...            ...

Rs. 27.43

Current Rate                     ...            ...

Rs. 30.31

% of increase                    ...            ...

10.50%

Contract Rate                    ...            ...

Rs. 1,601

NEW @ 50%                     ...            ...

Rs. 1,645

NEW @ 60%                     ...            ...

Rs. 1,654

Method 2nd — Formula                     ...

Rs. 1,654

 

Particulars

Basic rate (Rs.)

Increase rate (Rs.)

Rate - 2nd method (Rs.)

Incr. per tonne (Rs.)

Loading (tonne) PA

Saving P.A. (Rs.)

Savings @50%

1,601

1,645

1,654

9

5,600

50,400

Savings @60%

1,601

1,654

1,654

0

5,600

 
Delhi :

As per Exhibit 1 — Hike II — @ 8.31%

Particulars

 

Benchmark Rate                    ...          ...

Rs. 30.31

Current Rate                         ...          ...

Rs. 32.83

% of increase                        ...          ...

8.31%

Contract Rate                        ...          ...

Rs. 1,601

NEW @ 50%                         ...          ...

Rs. 1,672

NEW @ 60%                         ...          ...

Rs. 1,687

Method 2nd — Formula                       ...

Rs. 1,743

 

Particulars

Basic rate (Rs.)

Increase rate (Rs.)

Rate - 2nd method (Rs.)

Incr. per tonne (Rs.)

Loading (tonne) PA

Saving P.A. (Rs.)

Savings @50%

1,601

1,672

1,743

71

5,600

397,600

Savings @60%

1,601

1,687

1,743

56

5,600

313,600

Delhi :

As per Exhibit 1– Hike III - @ 7.22%

Particulars

 

Benchmark Rate                    ...          ...

Rs. 32.83

Current Rate                         ...          ...

Rs. 35.20

% of increase                        ...          ...

7.22%

Contract Rate                        ...          ...

Rs. 1,601

NEW @ 50%                         ...          ...

Rs. 1,691

NEW @ 60%                         ...          ...

Rs. 1,709

Method 2nd — Formula                       ...

Rs. 1,826

 

Particulars

Basic rate (Rs.)

Increase rate (Rs.)

Rate - 2nd method (Rs.)

Incr. per tonne (Rs.)

Loading (tonne) PA

Saving P.A. (Rs.)

Savings @50%

1,601

1,691

1,826

135

5,600

756,000

Savings @60%

1,601

1,709

1,826

117

5,600

655,200

For escalation clause in contract method 1 with a percentage of 50% was to be used in preference to method 2 which was being currently considered.

Delivery within committed schedule time not monitored :

Truck was required to reach the destination within specified time periods as mentioned in the contract and for verification, date as mentioned in the transporter’s Delivery Slip/Challan was to be considered. In case there were delays, penalty was chargeable @1% of the freight bill per day upto 5%. But as observed the date is not mentioned in the delivery slip. Thus effectively payments are made without ensuring compliance to this clause. Complaints of non delivery within reasonable time were received intermittently but in the absence of specific data, customer service was not monitored.

It was directed that all dealers should mention the date and time of delivery on the Delivery Challans.

Increased Credit Notes for breakages/claims :

Material was being sent covered with tarpaulins. While there was transit insurance for damage or loss of material, there was a limit below which claims were not to be raised. The cases of such below limit claims were increasing. While these were being recovered from transporters, there were instances where this was also not done.

In order to improve control over material, a practice of fixing a metal seal to the tarpaulin cover after loading the truck was introduced. Strict instructions of not tampering this seal till unloading were given. In case of any tampering, penalty was to be charged if there was any loss of material.

It was also made obligatory on transporter to take in writing from customer that the metal seal was broken only in his presence in the prescribed form which gave both the time and date of delivery.

Penalty for delay in vehicle availability :

Clause no. 12 : Normally truck was expected to be made available within 24 hours after placing the order. However, in the contract no penalty was prescribed for delay.

Detention charges :

An increasing trend in detention charges on a yearly basis was seen :

Financial year

Detention charges

2002-2003

321500

2003-2004

709000

2004-2005

1673500

2005-2006

492000

Given general nature of reasons like 1. Due to the Logistics and 2. System failure, it was not possible to identify specifically the controllable aspects of the problem.

Detention charges in financial year 2005-2006 are lower than in previous year. Reasons for the low detention charges was mainly due to low dispatches due to production stoppage.

Instructions were given to prepare a Monthly MIS for detention charges giving specific reasons to be reviewed in operations meeting.

Inward and Outward of materials for same and nearby locations :

Quite a few instances were observed where materials were received from and sent to the same or nearby location.

It was decided to finalise the contract with transporter in cases where the transporter was assured of business from both sides.

Conclusion :

As a result of the elaborate exercise in the area, which was more in the nature of a consulting assignment, Raj was able to emphasise the ‘Add Value’ and ‘Consulting’ roles of an Internal Auditor as per the definition of Internal Auditing by Institute of Internal Auditors, Florida. The Management while appreciating the efforts also asked Raj to come up with a comprehensive programme for Audit Improvement in line with the latest global standards of Internal Auditing and also Quality Assurance. He was also sanctioned an increased budget for his department. He was further asked to submit an audit plan for the next year along with man-power required and cost of technology to be acquired for enhancing the contribution of his Department.

EXHIBIT 1

Analysis of hike in freight charges by different alternatives — Delhi 1407 kms

 

 

50%

60%

Old formula - Consider

Diesel rate

Inc %

% increase in freight rate per tonne

Freight rate per tonne (Rs.)

% increase in freight rate per tonne

Freight rate per tonne (Rs.)

Increase Rs per ton

Freight per ton

27.43

1,601

1,601

1,601

28.62

4.34

1,601

1,601

1,601

30.31

5.90

2.75

1,645

3.30

1,654

53

1,654

32.83

8.31

1.66

1,672

1.99

1,687

142

1,743

35.20

7.22

1.11

1,691

1.33

1,709

225

1,826

37.57

6.73

0.87

1,705

1.04

1,727

308

1,909

35.32

(5.99)

(0.49)

1,697

(0.59)

1,717

229

1,830

EXHIBIT 2 — Statement showing the calculation of freight charges considering the effect of 5% Fuel Consumption — 50%

Diesel rate

Diesel

Not hike (%)

Incre consider

Freight after 5% (assume)

Diesel per tonne

Other Cons.

Inc Cons.

Total freight hike

Overall hike

Freight per ton

A

B

C

D

E

F

G

H

I

J

K

 

 

 

(B-C)

 

(E*0.50)

(E-F)

F+(F*D/100)

(G+H)

(I-E)/E*100

K+(K*J/100)

27.43

5.00

100.00

50.00

50.00

50.00

100.00

1,601

28.62

4.34

5.00

100.00

50.00

50.00

50.00

100.00

1,601

30.31

10.50

5.00

5.50

100.00

50.00

50.00

52.75

102.75

2.75

1,645

32.83

8.31

5.00

3.31

102.75

51.37

51.37

53.08

104.45

1.66

1,672

35.20

7.22

5.00

2.22

104.45

52.23

52.23

53.39

105.61

1.11

1,691

37.57

6.73

5.00

1.73

105.61

52.81

52.81

53.72

106.53

0.87

1,705

35.32

(5.99)

5.00

(0.99)

106.53

53.26

53.26

52.74

106.00

(0.49)

1,697

EXHIBIT 3 — Statement showing the calculation of freight charges considering the effect of 5% Fuel Consumption — 60%

Diesel rate

Diesel

Not hike (%)

Incre consider

Freight after 5% (assume)

Diesel per tonne

Other Cons.

Inc Cons.

Total freight hike

Overall hike

Freight per ton

A

B

C

D

E

F

G

H

I

J

K

 

 

 

(B-C)

 

(E*0.60)

(E-F)

F+(F*D/100)

(G+H)

(I-E)/E*100

K+(K*J/100)

27.43

0

5.00

100.00

60.00

40.00

60.00

100.00

1,601

28.62

4.34

5.00

100.00

60.00

40.00

60.00

100.00

1,601

30.31

10.50

5.00

5.50

100.00

60.00

40.00

63.30

103.30

3.30

1,654

32.83

8.31

5.00

3.31

103.30

61.98

41.32

64.03

105.35

1.99

1,687

35.20

7.22

5.00

2.22

105.35

63.21

42.14

64.61

106.76

1.33

1,709

37.57

6.73

5.00

1.73

106.76

64.05

42.70

65.16

107.87

1.04

1,727

35.32

(5.99)

5.00

(0.99)

107.87

64.72

43.15

64.08

107.23

(0.59)

1,717

EXHIBIT 4 — Statement showing the calculation of freight charges as per Formula (Old) Delhi — 1407 Kms

Diesel rate

Hike in diesel rate (%)

Hike in diesel rate (%) not considered

Hike in diesel rate more than 5%

Freight rate per tonne (Rs.)

Distance in km for Delhi

Diesel rate on work order date (Rs.)

Hike in diesel rate upto which no change in freight (Rs.)

Increase in freight charges (Rs.)

Final rate (Rs.)

A

B

C

D

E

F

G

H

I

J

 

 

 

(B-C)

 

 

 

G+(G*C/100)

F*(A-H)/10*4

(E+I)

27.43

0

5.00

1,601

1407

27.43

28.80

1,601

28.62

4.34

5.00

1,601

1407

27.43

28.80

1,601

30.31

10.50

5.00

5.50

1,601

1407

27.43

28.80

53

1,654

32.83

8.31

5.00

3.31

1,601

1407

27.43

28.80

142

1,743

35.20

7.22

5.00

2.22

1,601

1407

27.43

28.80

225

1,826

37.57

6.73

5.00

1.73

1,601

1407

27.43

28.80

308

1,909

35.32

(5.99)

5.00

(0.99)

1,601

1407

27.43

28.80

229

1,830

 
Source : Article by Deepjee Singhal , Manish Pipalia, Chartered Accountants
 

 

 


 

Rewards waiting for feedback at
E-mail : smarttrainee@gmail.com

 


 

www.primeonlinetest.com

 


 

Disclaimer: We believe that the information contained in this e-zine is true. If you do not wish to receive Smart Trainee please click here.

 

Prime Academy - In Pursuit of excellence

 

 

 

Click here to contact us, if you are unable to view the content properly