Illustrating Internship!!!

Before I write more about South India, I thought to write about my internship. So, I reached Chennai and reported to Mr. Subbaraman who introduced me to his boss Mr. Ashok Kumar. He asked the duration of my internship. Hearing two months, he said, “Okay, we’ve got two projects for you; each for one month. Apart from that if something else comes up, we’ll let you know. One will pertain to shrinkage. Do you’ve any idea about shrinkage?”

‘Shrinkage of stock’ were the words which came out of my mouth. Then I went on explaining that in the course of examining products, (prospective) customers may end up spoiling products. He added not only spoiling; they’ll take the products home which causes a major reduction in stock and consequently a loss for the store. So, you have to analyze the shrinkage-data and give a conclusion. Mr. Ramesh will be your mentor for this project.

“The other project will be about accounts. The stress will be on cost minimization; rather cost optimization. It’s about ‘triggering the trigger before it triggers the Books of Accounts’. Once an entry is made in the books, you cannot do much about it. So some things need to be done before posting the entries in the books. Mr. Subbaraman will be your mentor for this project.”

After that Mr. Ramesh took charge. He explained me the three types of size of Reliance stores and added that 87 stores are there in Chennai and ___ stores are there in Tamil Nadu. He further said that all the stock are first collected in the Distribution Centers and then dispatched to various stores. Certain perishable-prone items are directly distributed to the stores without the need of going through the Distribution Centre like bread etc. I added, “fruits and vegetables”. He said, “No, Distribution Centre acts as a collection centre for umpteen vendors as they can’t go individually to separate vendors.

He further said that ideally the %age of shrinkage should not exceed 0.5%. The moment it crosses 4%-5%; margin gone! I asked what the margin % is. He replied that some things are kept on a high-level.

After the verbal briefings, he opened an excel report sent by one of the stores. There were circa 4800 items and their various details. For the first time I was seeing the handling of such big data. He started using Auto Filter in various respects and bingo! the results started coming. I haven't used Auto Filter till that point of time, so I was trying to observe minutely. By that time I started feeling very sleepy. So, at the end of the day, he squeezed some meaningful insights from the raw data (I didn’t follow much!) and mailed back his questions (based upon the insights) to the store. I saw the professional thing happening.

Next day, Mr. Ramesh has to attend some meeting. So he forwarded two files to me and asked me to attempt them. I was allotted a corner of a cubicle with a decent hp desktop. For the first hour I didn’t have any idea what the files were about. I started reading the contents of the file and slowly understood that the first file is the file which was refined yesterday and the second file is the raw data of another store. Once I understood them, it hardly took 30-40 minutes to sort 50% of the data accordingly. Two terms which I didn’t understand were Zero-Count and No-Cost-SKUs. In the lunch I went to the Mount Road for some other work and had lunch at the Sarvana Bhawan.

Food is almost same in Tamil Nadu and Kerala. I think here they don’t have ‘toran’-a dry ‘sabji’ of every possible edible. Anyways, I liked the food at both the places. After lunch, he explained me both the terms and I sorted the data accordingly.