Data management, Analysis and Data Visualization of Majestic Enterprise (PVT.) LTD.

Abstract

Majestic Enterprise PVT LTD (MEPL) is a processor and exporter of frozen and chilled raw food items, as well as dry food items. The company has been oper ating since 1998 and exporting its products to various countries worldwide. This report is about my internship program at MEPL. In this comprehensive report, I have discussed about my work experiences, the proposed methods, my implemented works and my training experience under MEPL. I have also aimed to highlight some drawbacks of the company from my observation during my internship period. The following tools: Microsoft word, Microsoft Excel, Microsoft Power Point and Mi crosoft Power have been used for the documentation of the company’s data and for carrying out proper analysis. This report has been divided into five chapters. The first part of the report is in troduction. The second part of the report is an overview of the company. The third part of the report is about the works that I have learnt from my training un der MEPL. The fourth section of the report discusses about the proposed solutions. For increasing efficiency of inventory management, Standard operating procedures (SOP) and stock-keeping units (SKUs) have been introduced. SOPs describes what needs to happen for an outcome and it helps to simplify the data entry process and avoid errors. SKUs being unique and specific to particular locations allows to keep track of final inventory status more effectively. The fifth part of the report is dis cusses about the internal and external problems faced by the company and about their feasible solutions. Analog data keeping, absence of modulated procurement production schedule and wastage and inventory mismatch are some of the internal problems. Suggesting usage of Enterprise Resource Planning softwares to build a database and manage inventory effectively, raising awareness at critical points and accurate and honest reporting of waste percentage can provide remedy to the above mentioned problems. Increase in Price of Raw Materials and Skilled labor crisis are some of the external problems that the company faces. Building alliance with various shipping line companies, freight forwarding companies and international authority and training the workers under strict supervision and legal contract can help solve the external problems to a great extent. The final and the last part of the report is about my experience gathered from the internship.