material management project report
TRANSCRIPT
Material Management
TABLE NO: 5.1
TABLE SHOWING INVENTORY TO NET SALES
INVENTORY TO NET SALES = InventoryNet Sales∗100
Rs. In Lakhs
ANALYSIS:
From the above table it can be analyzed that there is a increasing level in
the rate of inventory to net sales is 44.895% during the year 2011-2012. Where as
there it has been increased to 46.36% in the year 2012-2013. In the year 2013-
Page 1
YEAR
INVENTORY (RS) NET SALES PERCENTAGE
(%)
2011-2012 2,460.77 5,482.11 44.89%
2012-2013 2,673.80 5,767.64 46.36%
2013-2014 3,191.29 6,103.82 52.28%
2014-2015 3,298.71 6,275.52 52.56%
Material Management
2014 it increased to 52.28%, however there is increase in the year 2014-2015 with
the52.56%.
GRAPH NO : 5.1
GRAPH SHOWING INVENTORY TO NET SALES
2011-2012 2012-2013 2013-2014 2014-201540.00%
42.00%
44.00%
46.00%
48.00%
50.00%
52.00%
54.00%
44.89%
46.36%
52.28% 52.56%
INTERPRETATION:
From the above graph it can be inferred that due to the increase in the demand for Wire
products their has been slight increase in the level of inventory to sales in the year 2014-
2015 when compared to previous years.
Page 2
Material Management
TABLE NO: 5.2
TABLE SHOWING INVENTORY TO CURRENT ASSETS RATIO
INVENTORY RATIO = Inventory
Current Asset∗100
Rs. in Lakhs
ANALYSIS:-
Page 3
YEAR INVENTORY(Rs)
CURRENT ASSET(RS)
PERCENTAGE(%)
2011-2012 2460.77 6292.29 39.11
2012-2013 2673.8 12133.27 22.03
2013-2014 3191.29 11828.45 26.97
2014-2015 3298.71 11991.62 27.5
Material Management
From the above table we can observe that in the year 2012-2013 there is a
increase in the current asset value when compare to other years , but in the other years
also there is a increase in the current asset and inventory.
GRAPH NO : 5.2
GRAPH SHOWING INVENTORY TO CURRENT ASSETS RATIO
2011-2012 2012-2013 2013-2014 2014-201545
46
47
48
49
50
51
49.18
47.43
50.47
46.92
INTERPRETATION:-
From the above graph it can be inferred that there is a more increase in the value of raw
materials due to more purchases during the year 2014-2015. So why there is more
increase in the values of current assets and inventory during the year 2014-2015 when
compared to other years.
Page 4
Material Management
TABLE NO:5.3
TABLE SHOWING INVENTORY TO TOTAL ASSETS RATIO
INVENTORY TO TOTAL ASSETS RATIO = InventoryTotal Inventory
∗100
Rs.in Lakhs
ANALYSIS:-
Page 5
YEAR INVENTORY(RS)
TOTAL ASSETS(RS)
PERCENTAGE(%)
2011-2012 2460.77 5003 49.18
2012-2013 2673.8 5636.96 47.43
2013-2014 3191.29 6322.86 50.47
2014-2015 3298.71 7029.85 46.92
Material Management
The above table shows that there is increase in the total assets due to increase
in the current assets. In the year 2011-2012 the total assets were less when
compared to 2014-2015, and the percentage has been decreased in the year 2014-
2015.
GRAPH NO:5.3
GRAPH SHOWING INVENTORY TO TOTAL ASSETS RATIO
2011-2012 2012-2013 2013-2014 2014-201545
46
47
48
49
50
51
49.18
47.43
50.47
46.92
INTERPRETATION:-
From the above graph it can be inferred that there is increase in both
inventory and the total assets during the year 2014-2015 and percentage wise it is
Page 6
Material Management
decreased when compared to previous years, because there is increase in both the
inventory and the total assets during the year 2014-2015.
TABLE NO:5.4
TABLE SHOWING INVENTORY TO WORKING CAPITAL
INVENTORY TO WORKING CAPITAL RATIO = InventoryWorkingCapital
∗100
Rs. In Lakhs
YEAR INVENTORY(RS)
WORKING CAPITAL
PERCENTAGE(%)
2011-2012 2460.77 -1347.23 -1.83
2012-2013 2673.8 3500.6 0.76
2013-2014 3191.29 4421.35 0.72
2014-2015 3298.71 5093.68 0.65
ANALYSIS:-
Page 7
Material Management
From the above table it is clear that there is a negative value in the working
capital ratio during the year 2011-2012 due to the increase in the current
liabilities=Rs 7639.52Lakhs and the current assets =6292.29Lakhs. So why the
working capital is having the negative value.
GRAPH NO:5.4
GRAPH SHOWING INVENTORY TO WORKING CAPITAL.
2011-2012 2012-2013 2013-2014 2014-2015
-2
-1.5
-1
-0.5
0
0.5
1
-1.83
0.76 0.72 0.65
INTERPRETATION:
From the above graph it can be inferred that due to increase in the current
liabilities value, due to this slight changes in the level of inventory of a
Page 8
Material Management
company during the year 2014-2015, so why there is a slight variations in the
working capital.
TABLE NO:5.5
TABLE SHOWING ANNUAL CONSUMPTION OF RAW
MATERIALS
Rs.in Lakhs
Page 9
YEARANNUAL
CONSUMPTION OF R/M(IN LAKHS)
2011-2012 2123.08
2012-2013 3072.8
2013-2014 3824.67
2014-2015 3139.53
Material Management
ANALYSIS:-
From the above table it is clear that the annual consumption of raw
material has been increased in the year 2013-2014 when compared to other previous
years, but there is a decrease in the values of annual consumption of raw materials during
the year 2014-2015.
GRAPH NO:5.5
GRAPH SHOWING CONSUMPTION OF RAW MATERIAL
.
2011-2012 2012-2013 2013-2014 2014-20150
500
1000
1500
2000
2500
3000
3500
4000
4500
2123.08
3072.8
3824.67
3139.53
Page 10
Material Management
INTERPRETATION:-
From the above graph it can be inferred that there is more annual
consumption of raw materials in the year 2013-2014, may be due to a more production
and more demand to a product, and there is a increase in the consumption of raw
materials year by year.
TABLE NO:5.6
TABLE SHOWING THE STOCK OF WORK IN PROGRESS.
ANALYSIS:-
The above table indicates the stock of work in progress, the stock has been
increased in the WIP from the year on year, there is a more increase in the year 2014-
2015, i.e.. Rs. 196.86 Lakhs.
Page 11
YEARWORK IN PROGERSS(IN
LAKHS)
2011-2012 58.99
2012-2013 113.56
2013-2014 161.42
2014-2015 196.86
Material Management
GRAPH NO:5.6
GRAPH SHOWING STOCK OF WORK IN PROGRESS
2011-2012 2012-2013 2013-2014 2014-20150
50
100
150
200
250
58.99
113.56
161.42
196.86
INTERPRETATION:-
Page 12
Material Management
From the above graph it can be inferred that during the year 2014-
2015 there is more increase in the value, because the orders during this year is more when
compared to other years.
TABLE NO: 5.7
TABLE SHOWING INVENTORY CONVERSION PERIOD.
Inventory conversion period = Noof days∈a yearStock turnover ratio .
.
Page 13
YEAR NO OF DAYS IN A YEAR
STOCK TURNOVER
RATIO
INVENTORY CONVERSION
PERIOD (DAYS)
2011-2012 365 2.19 167
2012-2013 365 2.25 162
2013-2014 365 2.08 175
2014-2015 365 1.93 189
Material Management
ANALYSIS:-
From the above table it is clear that the stock turnover ratio has been
decreased from 2014-2015, when compared to other years, but there is a increase in the
inventory conversion period during the year 2014-2015.
GRAPH NO: 5.7
GRAPH SHOWING INVENTORY CONVERSION PERIOD.
2011-2012 2012-2013 2013-2014 2014-20151.7
1.8
1.9
2
2.1
2.2
2.3
2.19
2.25
2.08
1.93
INTERPRETATION:-
Page 14
Material Management
From the above graph it can be inferred that there is a
decrease in the stock turnover ratio due to increase in the average stock and the cost of
goods sold during the year 2014-2015, There is a increase in the inventory conversion
period due to decrease in the stock turnover ratio during the year 2014-2015.
TABLE NO:5.8
TABLE SHOWING AVERAGE STOCK OF RAW MATERIAL.
Average stock of raw material =
OpeningStock of Rawmaterial+Closing Stock of Rawmaterial2
Rs.in Lakhs
YEAR O/S OF RAW MATERIAL
C/S OF RAW
MATERIAL
AVERAGE STOCK OF
RAW MATERIAL
2011-2012 3024.54 3135.77 3080.15
2012-2013 3135.77 3669.03 3402.4
2013-2014 3669.03 4084.93 3876.98
Page 15
Material Management
2014-2015 3583.56 3583.56 3583.56
ANALYSIS:-
From the above table it can be analyzed that the average stock of raw
material in the year 2011-2012 was 3080.15, 2012-2013 was 3402.4, 2013-2014 was
3876.98 and in the year 2014-2015 was 3583.56.This shows the increasing trend of
average stock of raw material.
GRAPH NO:5.8
GRAPH SHOWING AVERAGE STOCK OF RAW MATERIAL
2011-2012 2012-2013 2013-2014 2014-20150
500
1000
1500
2000
2500
3000
3500
4000
4500
3080.153402.4
3876.983583.56
INTERPRETATION:
Page 16
Material Management
From the above graph it can inferred that there is no drastic changes in the average stock
when compare to previous year 2013-2014. The company has maintained consistency in
purchase of raw material during the year 2014-2015.
TABLE NO: 5.9
TABLE SHOWING CURRENT RATIO
Rs. In Lakhs
YEAR CURRENT ASSETS
CURRENT LIABILITIES
CURRENT RATIO
2011-2012 6,292.29 7,639.52 0.82
2012-2013 12,133.31 8,632.67 1.4
2013-2014 11,828.45 7,407.10 1.59
2014-2015 11,991.62 6,897.94 1.74
Page 17
Material Management
ANALYSIS:
From the above table it is clear that the current assets are more when compare to current
liabilities except in the year 2011-2012, but there is a increase in the current assets and
current liabilities, and also the current ratio during the year 2014-2015.
GRAPH NO:5.9
GRAPH SHOWING CURRENT RATIO
2011-2012 2012-2013 2013-2014 2014-20150
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.8
2
0.82
1.4
1.591.74
INTERPRETATION:
Page 18
Material Management
From the above graph it can be inferred that there is a slight increase in the year 2014-
2015, which indicates good liquidity position of the business in the year 2014-2015.
TABLE NO:5.10
TABLE SHOWING DEBTOR’S TURNOVER RATIO
Dr’s turnover ratio= Net annual salesAverage Debtors
Average Dr’s = OpeningDebtors+Closing Debtors2
Rs. In Lakhs
YEARNET
ANNUAL SALES
AVERAGE DR’S
DR’S TURNOVER
RATIO
2011-2012 5,482.11 2535.8 2.16
Page 19
Material Management
2012-2013 5,767.64 2,795.10 2.06
2013-2014 6,103.82 3010.81 2.02
2014-2015 6,275.52 3731.6 1.68
ANALYSIS:
From the above table it can be analyzed that there is a increase in the year on year and
also the average Dr’s has been increased in the year 2014-2015, but the Dr’s turnover
ratio has been decreased in the year 2014-2015.
GRAPH NO:5.10
GRAPH SHOWING DR’S TURNOVER RATIO
2011-2012 2012-2013 2013-2014 2014-20150
0.5
1
1.5
2
2.5
2.162.06 2.02
1.68
Page 20
Material Management
INTERPRETATION:
From the above graph it can be inferred that due to lower ratio in the year 2014-2015, the
management has to give more interest towards the collection of the money in a better
way.
TABLE NO:5.11
TABLE SHOWING STOCK TURNOVER RATIO
Stock turnover ratio = Sales
Average inventory
Average inventory =Openinginventory+Closinginventory
2
Rs. in Lakhs
YEAR SALES AVERAGE INVENTORY
STOCK TURNOVER
RATIO
2011-2012 5,482.11 2,498.83 2.19
2012-2013 5,767.64 2,567.28 2.25
Page 21
Material Management
2013-2014 6,103.82 2,932.54 2.08
2014-2015 6,275.52 3,245 1.93
ANALYSIS:
From the above table it is observed that there is a increase in the Average inventory and
the Sales during the year 2014-2015, when compared to other previous years, but the
stock turnover ratio has been decreased in the year 2014-2015.
GRAPH NO : 5.11
GRAPH SHOWING STOCK TURNOVER RATIO
2011-2012 2012-2013 2013-2014 2014-20151.7
1.8
1.9
2
2.1
2.2
2.3
2.19
2.25
2.08
1.93
Page 22
Material Management
INTERPRETATION:
From the above graph it can be inferred that the company has more inventory by the
anticipation of the sales which have not occurred in the year 2014-2015, so the stock
turnover ratio has been decreased during these year.
TABLE NO:5.12
TABLE SHOWING CURRENT ASSET TURNOVER RATIO
Rs. In Lakhs
YEAR SALESCURRENT
ASSETS
CURRENT ASSET
TURNOVER
RATIO
2011-2012 5,482.11 6,292.29 0.87
2012-2013 5,767.64 2,133.27 0.47
2013-2014 6,103.82 11,828.45 0.52
2014-2015 6,275.52 11,991.62 0.52
ANALYSIS:
Page 23
Material Management
From the above table it is clear that there is a decrease in the current assets during the
year 2011-2012 due to the cash & bank balances & the capital work in progress values,
in the year 2012-2013 due to the gradual increase in the current assets the Current asset
turnover ratio has been decreased.
GRAPH NO :5.12
TABLE SHOWING CURRENT ASSET TURNOVER RATIO
2011-2012 2012-2013 2013-2014 2014-20150
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1
0.87
0.470.52 0.52
INTERPRETATION:
Page 24
Material Management
From the above graph it can be inferred that there is no much impact on the business ,
because the ratio is constant during the year 2013-2014, 2014-2015 which implies the
company has made more product sales with minimum investments in the current assets
during these years.
TABLE NO : 5.13
TABLE SHOWING AVERAGE COLLECTION PERIOD
Average period=Noof working days∈a yearDebtors turnover ratio
YEARNO OF
WORKING DAYS
DR’S TURNOVER
RATIO
AVERAGE COLLECTION
PERIOD
2011-2012 365 2.16 169
2012-2013 365 2.06 177
2013-2014 365 2.02 181
2014-2015 365 1.68 217
Page 25
Material Management
ANALYSIS:
The above table depicts the average collection period due to changes in the debtor
turnover ratio the collection period has been increased. The Dr,s turnover ratio has been
decreased year by year due to increase in the net annual sales and the average Dr’s.
GRAPH NO : 5.13
GRAPH SHOWING AVERAGE COLLECTION PERIOD
2011-2012 2012-2013 2013-2014 2014-20150
50
100
150
200
250
2.16 2.06 2.02 1.68
169 177 181
217
Page 26
Material Management
INTERPRETATION:
From the above graph it can be inferred that the company has not followed the stringent
collection procedure so the collection period has been increased in the year 2014-2015.
TABLE NO:5.14
TABLE SHOWING INVENTORY TURNOVER RATIO
INVENTORY TURNOVER RATIO ¿ Cost of goods soldAverage inventory
YEAR COST OF GOODS SOLD
AVERAGE INVENTORY
INVENTORY TURNOVER
RATIO
2011-2012 3144.67 2498.83 1.26
2012-2013 3579.09 2567.28 1.39
2013-2014 3806.93 2932.54 1.29
2014-2015 3630.89 3245 1.12
Page 27
Material Management
ANALYSIS:
From the above table it is clear that there is a fluctuations in the values during the year
2013-2014 and in the year 2014-2015 when compare other previous years.
GRAPH NO: 5.14
GRAPH SHOWING INVENTORY TURNOVER RATIO
2011-2012 2012-2013 2013-2014 2014-20150
0.2
0.4
0.6
0.8
1
1.2
1.4
1.6
1.261.39
1.29
1.12
Page 28
Material Management
INTERPRETATION:
From the above graph it is inferred that there is a decrease in the ratio due to reduction in
the demand and also the high inventory in the year 2014-2015.
TABLE NO : 5.15
TABLE SHOWING STOCK TURNOVER IN DAYS
STOCK TURNOVER IN DAYS = AVERAGE STOCK* 365 DAYS/
COST OF GOODS SOLD
Rs. In Lakhs
YEAR AVERAGE STOCK * 365 DAYS
COST OF GOODS SOLD
STOCK TURNOVER IN
DAYS
2011-2012 2498.83*365 3144.67 290
2012-2013 2567.28*365 3579.09 262
Page 29
Material Management
2013-2014 2932.54*365 3806.93 281
2014-2015 3245*365 3630.89 326
ANALYSIS:
From the above table it shows that the average stock of the company has been increased
due to the increase in the production of the products and the addition of some of the
products during the year 2014-2015.
GRAPH NO:5.15
GRAPH SHOWING STOCK TURNOVER IN DAYS
Page 30
Material Management
2011-2012 2012-2013 2013-2014 2014-20150
500
1000
1500
2000
2500
3000
3500
4000
3144.67
3579.093806.93
3630.89
290 262 281 326
COST OF GOODS SOLDSTOCK TURNOVER IN DAYS
INTERPRETATION:
From the above graph it can be inferred that the company holds the inventory for 326
days during the year 2014-2015, because of the decrease in the sales or demand to the
products during this year.
CHAPTER- 6
FINDINGS
Objective of the study:-
Page 31
Material Management
1. To study the Material management system in the company.
4. To analyses the Material management performance through turn over
ratio.
3. To make suggestions if there are any problems with regard to Material
management.
4. To identify the critical arias of Material management in the company.
5. To analyses the defects in Material management.
6. To identify the defects in Material management.
7. To know the Material techniques in Material management.
8. To introduce the modern methods in Material management.
9. To study the Material management system in the company.
10. To identify the modern Material system.
11. To identify the existing Material system.
Scope of the study:-
The study is helps to analyses the Material managements in Tata Steel
Ltd-Wire Division and the main objective is to reallocate the any defects made by
the firm helps to utilization.
FINDINGS
Page 32
Material Management
The percentage of the Inventory to Net sales has been increased in the year 2014-
2015 when compared to other years.
Due to increase in the Inventory and the Current assets the inventory to current
ratio has been increased in the year 2014-2015.
The percentage o the working capital has been increased from -1.83 to , 65 during
the year 2014- 2015.
The net sales of the company as increased in the year 2014 – 2015, as a result of
this inventory to net sales as increased to 52.56%.
The increase in the total assets in the year 2014-2015 the percentage of the
inventory to total assets has been decreased to 46.92% in the year 2014-2015.
The annual consumption of the raw materials has been increased to Rs. 3,324.67
Lakhs in the year 2013-2014.
The average collection period have been increased by 217 days in the year 2014-
2015.
The turnover ratio have been decreased by 1.93 in the year 2014-2015.
The current asset turnover ratio have been decreased in the year 2014-2015.
CHAPTER- 7
Page 33
Material Management
SUGGESTIONS AND CONCLUSION
SUGGESTIONS
By going through all the procedures followed in Tata Steel Ltd-Wire Division we can say
that the management of the inventories play a major role in the success of the
organization. As a whole the firm is following a good purchase procedure over different
materials, the company will be purchasing only certain materials from the outside of the
company for the production purposes. But there are certain content in the existing
Material Management system. Hence on the basis of the study the following suggestions
can be given. I hope that suggestions will be taken by the organization in a right spirit and
implemented.
It is found that in every production units there are A, B and C item
It is suggested to keep the materials A class items in some units, B class items in some
units, and C class items in some units so that it is very easy to identify the items in a
order wise and they can give attention towards each and every unit according to their
importance.
Method of Analysis
It is found that the company is using the ABC analysis to a large extent, hence
it is suggested to follow the different methods for classification such as
Classification Basis
VED To know the importance of critically Vital,
Essential, Desirables.
FSN To know the place at which materials
Moves (fast
Moving, slow moving, none moving)
HML To know the unit price of materials
Page 34
Material Management
( high, medium, low)
SDE To know the difficulties in procurement
(Scare, difficult, easy to obtain)
Reduction in Lead time
The company must try to minimize the lead time at the time of production, so that
the company can reduce the production time so the company can meet the
customers expectations. It is suggested that the company should be adopt some
new management systems in order to communicate vendors in a short span of
time their by reducing the lead time. Hence the organization can compete at the
International market and have a better future.
CONCLUSION
Page 35
Material Management
Material Management is one of the basic important functions of every business. An
average manufacturing organization in India has more than 60% of its current asset
invested in inventories. Therefore, by following proper efficient Material Management
principles, the company can certainly reduce the cost of inventory and can improve its
bottom line and thereby, becoming competitive, which in turn will improve its market
share.
The research topic Material Management has a greater implications on Indian industry,
from the analysis of Material Management in Tata Steel Ltd-Wire Division, it is very
clear that, it has achieved greater importance in production control to a large extent. It is
also enhances the arising need of the organization, in respect of Material Management.
The Material Management in Tata Steel Ltd-Wire Division, the inventories of the
company other than disposable scrap are valued at lower of cost or net realizable value.
The cost of materials is ascertained by using the weighted average cost formula.
Adequate provision is made for inventory which is more than five years old which may
not be required for further use.
Therefore Material Management acts as the “Pulse” of any organization, and will have
impact on all other activities in the organization. Though Material Management
comprises huge investment, it gives good results, when good inventory control
techniques are adopted, and thus enhances the smooth functioning in production.
This study has helped me a lot in obtaining good knowledge of Material Management in
Tata Steel Ltd-Wire Division. Hereby Material Management is an essential element in
any organization, provide it is maintained tactfully by adopting latest techniques and
utilizing best resulting from computerization.
Finally I conclude that the company is maintaining the good Material Management in
order to meet the future demands.
Page 36
Material Management
BIBLIOGRAPHY
1. K.Ashwathappa and K.Shridar Bhat - Production and Operations
Management, Himalaya Publishing House.
2. TATA STEEL LTD-WIRE DIVISION Booklets.
3. Dr. Monshi and Dr. Gayithri Reddy - Research Methodology,
Himalaya Publications.
4. Broachers.
5. Company Website.
WWW.tatasteelltd.com
ANNEXURE
Page 37
Material Management
Financial Statement of TATA STEEL LTD-WIRE DIVISION.
Particulars Mar '14 Mar '13 Mar '12 Mar '11 Mar '10
12 mths 12 mths 12 mths 12 mths 12 mths
Sources Of FundsTotal Share Capital 80 80 80 80 80Equity Share Capital 80 80 80 80 80Preference Share Capital 0 0 0 0 0Reserves 6,937.24 6,223.69 5,542.21 4,922.57 4,265.68Revaluation Reserves 0 0 0 0 0Net worth 7,017.24 6,303.69 5,622.21 5,002.57 4,345.68Secured Loans 12.61 19.17 14.76 0.41 0.73Unsecured Loans 0 0 0 0 0Total Debt 12.61 19.17 14.76 0.41 0.73Total Liabilities 7,029.85 6,322.86 5,636.97 5,002.98 4,346.41Application Of FundsGross Block 2,206.77 2,054.07 1,885.03 1,789.00 1,702.17Less: Accum. Depreciation 1,555.83 1,478.62 1,374.87 1,305.29 1,212.21Net Block 650.94 575.45 510.16 483.71 489.96Capital Work in Progress 196.86 161.42 113.56 58.99 31.43Investments 11.98 11.98 11.98 11.98 11.98Inventories 3,298.71 3,191.29 2,673.80 2,460.77 2,536.90Sundry Debtors 4,128.54 3,334.67 2,686.95 2,903.25 2,168.36Cash and Bank Balance 4,564.37 5,302.49 6,772.52 928.27 596.74Total Current Assets 11,991.62 11,828.45 12,133.27 6,292.29 5,302.00Loans and Advances 1,675.88 1,868.83 2,089.38 778.06 1,700.44Fixed Deposits 0 0 0 5,591.09 2,981.67Total CA, Loans & Advances 13,667.50 13,667.50 14,222.65 12,661.44 9,984.11Current Liabilities 6,897.94 7,407.10 8,632.67 7,639.52 4,476.20Provisions 599.49 716.17 588.72 573.6 1,694.88Total CL & Provisions 7,497.43 8,123.27 9,221.39 8,213.12 6,171.08Net Current Assets 6,170.07 5,574.01 5,001.26 4,448.32 3,813.03Miscellaneous Expenses 0 0 0 0 0Total Assets 7,029.85 6,322.86 5,636.96 5,003.00 4,346.40Contingent Liabilities Book Value(Rs) 773.64 787.36 1,119.72 266.69 205.77
Profit and Loss Account of TATA STEEL LTD-WIRE
DIVISION.
Particulars Mar '14 Mar '13 Mar '12 Mar '11 Mar '10
Page 38
Material Management
12mths 12 mths 12 mths 12 mths 12 MthsINCOME
Sales Turnover 6,275.52 6,103.82 5,767.64 5,540.68 5,237.51Excise Duty 0 0 0 58.57 41.88
Net Sales 6,275.52 6,103.82 5,767.64 5,482.11 5,195.63Other Income 428.47 609.98 585.49 326.11 243.54
Stock Adjustments -47.33 278 89.95 5.58 28.11Total Income 6,656.66 6,991.80 6,443.08 5,813.80 5,467.28
ExpenditureRaw Materials 3,583.56 4,084.93 3,669.03 3,135.77 3,024.54
Power & Fuel Cost 37.37 34.13 26.9 30.45 27.22Employee Cost 1,030.43 1,110.79 1,081.23 1,041.86 1,009.58
Other Manufacturing Expenses 0 0 0 17.05 15.87Selling and Admin Expenses 0 0 0 260.84 240.75
Miscellaneous Expenses 685.72 509.49 465.82 61.23 62.43Preoperative Exp Capitalised 0 0 0 -0.19 -0.36
Total Expenses 5,337.08 5,739.34 5,242.98 4,547.01 4,380.03Operating Profit 891.11 642.48 614.61 940.68 843.71
PBDIT 1,319.58 1,252.46 1,200.10 1,266.79 1,087.25Interest 3.4 0.78 0.6 10.79 9.37PBDT 1,316.18 1,251.68 1,199.50 1,256.00 1,077.88
Depreciation 142.1 130.71 120.8 122.04 115.94Profit Before Tax 1,174.08 1,120.97 1,078.70 1,133.96 961.94
Extra-ordinary items 0.65 -6.37 -3.86 22.64 84.06PBT (Post Extra-ord Items) 1,174.73 1,114.60 1,074.84 1,156.60 1,046.00
Tax 243.12 224.76 244.95 295.09 324.88Reported Net Profit 931.62 889.83 829.9 861.47 720.87
Total Value Addition 1,753.51 1,654.41 1,573.94 1,411.24 1,355.50Preference Dividend 0 0 0 0 0
Equity Dividend 186.4 178.4 166.4 172.8 153.6Corporate Dividend Tax 31.68 29.95 26.99 28.22 25.7
Per share data (annualised)Shares in issue (lakhs) 800 800 800 800 800Earning Per Share (Rs) 116.45 111.23 103.74 107.68 90.11Equity Dividend (%) 233 223 208 216 192
Book Value (Rs) 877.15 787.96 702.78 625.32 543.21
Page 39