Finance Project Nethra
Finance Project Nethra
Finance Project Nethra
Submitted by
Nethra M
1
ACKNOWLEDGEMENT
I have a pleasure in submitting the project report & take this opportunity to express
my sincere gratitude to all those who has helped me in this completion of the project
My heartfelt gratitude to all those who have directly and indirectly given
assistance in making this project easier & possible.
Nethra M
02191047955
2
INTRODUCTION
3
COMPANY PROFILE
Saint-Gobain Glass commissioned its first float line and a dolomite processing
facility in Sriperumbudur and sand beneficiation plant in Tada, Andhra Pradesh. In
2005 it launched its second float line in Sriperumbudur and extended its float plant in
Jagadia, Gujarat and Bhiwadi, Rajasthan. In 2019, launched its fifth float along with
Glass solution line of business. The group also emphasis in ensuring that its business
practices meet the highest standards of corporate governance and ethics. In 2020,
Saint-Gobain registered a sales of INR 62.985billion with a huge opportunity for
growth.
4
HISTORY
Saint Gobain was founded in the year 1665 for royal manufactory of Mirror glass
in France. Soon Mirror benefitted not only for royal order but it also opened door for
expansion of business soaring popularity among general public.
Saint Gobain designs, manufactures and distributes materials and solutions that
improve the comfort of each of us and the future of all. The products are found
everywhere in our daily lives, from the home to the office, in cars and infrastructure,
and high-performance materials for health and many industrial applications. The
group aims to meet today’s individual requirements for comfort, performance, safety
and aesthetics.
Design, Manufacture and distribute materials and solutions which are key
ingredients in the well-being of each of us and the future of all.
VISION
PURPOSE
6
FINANCE DEPARTMENT IN SAINT GOBAIN
Hence this study has been made to evaluate how Saint Gobain glass India is
employing financing system for business. Depending on the data provided by the
accountants’ management takes critical business decision.
7
OBJECTIVES OF THE STUDY
Broad Objective
Specific Objective
8
Limitations of the study
This study has been prepared based on the basis of observation and experience
gained during Internship period. It is confined only in Finance Department. The
following are the limitations of study
9
ACTIVITIES PERFORMED DURING THE PERIOD OF
INTERNSHIP
10
AUTOMATION OF COP
First, I was assigned a to report Finance head Mr. Bijay Sahoo in the project
“Automation of COP”. In which I closely worked for 3 months with all five float cost i.e,
3float in Sriperumbudur, Chennai and flaot3 in Bhiwadi and float4 in Jagadia. For first
few weeks I had brief meeting with head in which I get to know about the company
process and an overview of glass manufacturing and also got a clear view of finance
department contribution. Then I started my work to prepare a consolidated cost sheet
for all the float for the period of 2018-June2021.
At first collected previous year COP from all plants and worked majorly in excel
sheet. I was given a total cost of each plant, segregated each cost accordingly to find
the cost of different glass as each plant produce clear and tinted glass except Jagadia
which produce only clear glass. Prepared variance and made apportionment of cost
on the basis number of glass production happened. I had faced some difficulty working
on electricity cost which as to be converted to MMBtu in previous data as i couldn’t
match total cost after apportioning on the basis of production and other importance.
With the help of team members and weekly review meeting with other plant head
sorted out issue with the help of updated information.
All through the process I was constantly guided by Mr. Bijay Sahoo as it is my
first internship he made it comfortable and helped me to learn analytical concepts.
Once I consolidated all cost of all plants with its requirement, I worked with jedox team
to update the same to get the outcome as expected. Along with it also did other
preliminary works as grouping the cost to find the difference between budget and
actual and also worked in Finesse team updated version of excel which help the
organization to fetch past data without having to spend much time, it gives easy access
11
to filter required data. In which presented all data accordingly to the requirement of
that application to get an outcome as expected.
VENDOR EVALUTION
I worked in this project to evaluate the vendor using performance analysis and
financial ratios. I made detailed working of Asahi India Glass ltd(AIS), in which I got a
clear understanding of the vendor with the help of Annual reports of AIS. It showed a
good rating as there is a slight increase in operating profit in admist of lockdown and
slow-down of sales, also a good liquidity position.
Saint gobain India invest major part of its investment in service provided by
outside organization with the support of which organization runs efficiently, so it is
important to evaluate the past and current status of the service provider to investment
most efficiently in upcoming years, if there is any setback or material loss in faced by
service provider we could easily figure out and swap to other contract to minimize the
loss faced by us.
Along with it, worked the same for different vendor to provide rating and to find
the slow-paced companies taking into account liquidity position, turnover ratios to
find whether the vendor is financially stable, can meet out its debts and make payment
promptly, can provide service demanded on time and not met any financial or material
12
losses or to evaluate that he has any major dealing or commitments in any near future
so that as a buyer we won’t get affected. Here I have learned to apply ratios and
performance analysis practically and to find the profit and loss from the balance sheet
of the different organization is a real time learning which helped me to understand
more clearly about what I have been going through theoretically all these years.
C00605- Utilities
Here I have analyzed last two years’ data of utilities cost in which plant spent around
Rs.18million every year. I understood it covers most of the cost under two heads
Annual maintenance cost (AMC) and Original Manufacturing Maintenance.
Here I analyzed few Gl of FGU FCA cost which contains details of all general cost,
I understood that most of the consultancy expenses covers audit fee paid to the
financial service provider once in a year, and it has some recurring expenses to incur
13
MEIS license for which service charge has to be paid monthly after realization of
export. And analyzed transportation expenses of employees which is major expenses
in FGU FCA cost, which covers around Rs.20million every year not only regular office
bus transport but it also benefits employees by providing shift car and pool car
facilities also spends on Ambulance Maintenance and most of the transportation
expenses are recurring in nature. And also analyzed housekeeping and rent gls which
covered hotel stay of employees due to covid-19 lockdown.
Staffing Report
14
mostly despatch and warehouse site uses more manpower as material handling
activities are higher to load the truck according to the orders received.
In MHE, most of the equipment cost are fixed which includes forklift, cranes, pay
loader etc., except TVS forklift which is mostly used in dispatch and warehouse
department cost varies according to the type and number of forklift used.
CANTEEN COST
I worked in canteen cost tracker to update monthly expenses incurred by the plant in
providing food to office employees and OSSP workers. Worked in swift to get details
of total quantity of food provided in the month to get the breakup of breakfast, lunch,
dinner, snacks to arrive at the cost based on the rate fixed. Canteen cost incurred by
OSSP employees is reimbursed by the management in OSSP man-day cost due to
12hour shift which incurred around Rs.54lakhs till date. Office employees has a
concession in canteen of half the rate, but due to covid lockdown for few months,
plant provided free food due to which plant incurred a huge expense.
Overhead
Overhead cost is generally operating cost which helps to run the organization
efficiently, it has to be reviewed regularly in order to increase the profitability of the
organization.
I worked in overhead tracker to update last five year cost for all five plants from
production and maintenance consumable file and maintenance service files. I analyzed
that in the year 2020 overhead cost has reduced 33% compared with the cost incurred
in 2019. In 2021, there is huge fluctuation in hot end-1 cost which is due to revamping
15
of furnace in Float-1 around Rs.7.8million and utilities cover the major cost around
Rs.40lakhs incurs regularly to meet the Government related payments.
IMH analysis
Input Material Handling cost covers mostly raw material handling manpower and
warehouse and dispatch department handling equipment cost. Here I analyzed last
two years’ data to find the regular expenses which are likely to occur, it majorly overs
manpower for raw material handling Naveen Kumar management service provides
manpower regularly and TVS supply chain is one of the regular service provider who
provides equipment to support the production activities in the plant. Most of the cost
are incurred monthly and quarterly.
I got to know about cost center and GL codes, how it works in the organization
and how costs are put together in different codes.
I learnt to use SAP, got introduced to tcodes and now able to fetch the required
data from SAP application without requiring support.
Worked on impetus to validate the cost savings of different plants.
Understood the concept of creating provisions for upcoming months and to
check whether the bills are booked.
Helped in maintaining IEX power cost monthly and to ensure the accuracy of
cost.
Understanding new term and terminologies by discussing with the team
Helped the team in maintaining the monthly records systematically without any
pending.
16
CONCLUSION
17
SELF ASSESSMENT AS FUTURE PROFESSIONAL
18
In order to survive in a professional world, both theory as well as practical learning
is very important. Theoretical knowledge provides basic information where practical
learning provides better understanding on the subject through practical experience.
19
THANK YOU
20