Live Inventory Tracking System Using IOT

Abstract

Inventory Management System software is important for organisations that operate hardware stores, where the store owner keeps track of sales and purchases. Poor inventory management leads to disgruntled customers, excess money in warehouses, and slower sales. With this initiative, paper work, human mistake, manual delay, and process acceleration are all avoided. An inventory management system can help a store owner keep track of sales and available goods, as well as calculate when and how much to repurchase. Inventory Management System is a Windows application for Windows operating systems that focuses on inventory control and the ability to generate all essential reports.

Introduction

I. INTRODUCTION  

Inventory management software monitors inventory levels, orders, sales, and deliveries. It can be used to generate a work order, a bill of materials, and other industrial-related documents. 

Businesses use inventory management software to prevent product overstock and outages. It is a tool for organising inventory data, which was traditionally recorded on paper or in spreadsheets. Our goal is to create a replenishment plan that is more effective in the face of changing market conditions and maximises revenues throughout the supply chain. Regular updates and tracking will be provided. A dependable system will provide you with a consolidated view of your inventory across all sales channels, allowing you to maintain track of your inventory. produces inventory for several sales channels, cutting costs. lowers costs by producing stock reports for inventory analysis. Maintaining records allows you to spend less time managing inventory. data patterns are examined in order to manage planning and forecasting

A. Problem Statement

To keep track of the items and reduce logistical loss. Inventory costs have a substantial impact on the company's profitability and performance. Inventory management and optimal decisions require the identification of essential success criteria and the making of relevant judgements at the appropriate moment. It is critical to decrease expenses in order to maximise the outcomes of the inventory function in a changing market situation. reduces expenses by producing stock reports for inventory analysis. You can spend less time maintaining inventory if you keep records. Data patterns are studied in order to manage planning and forecasting so that decision-making and the factors influencing decision-making can be prioritised. The survey approach can provide insight on variables that contain biassed data. The dependability of the parameters employed is critical.  Variables in decision-making can be enhanced by applying scientific approaches to test the factors that influence invention decisions. As a result, the current study focuses on two aspects: identifying variables influencing inventory optimisation among SMEs in the steel sector using a structured and unstructured questionnaire, categorising these variables as internal and external variables, and optimising by combining the information for the best decision. 

II. LITERATURE SURVEY 

The loss in logistic for Fastmoving Consumer Goods (FMCG) has been very high since they have entered into big markets.

Hindustan Coca-Cola Beverages' (HCCB) losses from 2016 to 2018: 

According to documents filed with the Registrar of Companies, it had a loss of Rs. 2.33 billion in 2016–17. 

In 2017-18, a loss of Rs. 1.18 billion was reported. https://www.business-standard.com/article/companies/coca-cola-s- bottling-arm-reports-loss-for-2nd-straight-year-at-rs-1-18-bn-118112701080_1 PepsiCo midlife crisis:  

According to its RoC filings, PepsiCo India reported a loss of Rs280 crore as opposed to a profit of Rs17.6 crore the year      before. https://www.livemint.com/Companies/V5SxXWA0oicnJFmAXNZaqJ/PepsiCos-midlife-crisis-in-

India.html Amazon Seller Services„ faced the loss of Rs. 5,685 crores during fiscal year 2018-19.

https://economictimes.indiatimes.com/small-biz/startups/newsbuzz/amazon-indias-e-comm-arm-narrows-fy19-loss-to-rs-5685-crore/articleshow/71796214.cms

According to regulatory documents filed by Flipkart, which were sourced from business intelligence platform Paper.vc, the company reported a net loss of Rs 3,836 crore as opposed to Rs 2,063 crore in the prior financial year.

https://www.business-standard.com/article/companies/flipkart-india-s-losses-increase-85-91-to-rs-3-836-cr-income-rises- 42119102800862_1.html#:~:text=Flipkart%20India%20Private%20Limited%20reported,business%20intelligence%20plat form%20Paper.vc

 III. DESIGN & ARCHITECTURE  

1. Sensor Data Input: The output of a device that recognises and responds to a particular kind of physical world input is referred to as sensor data. The output could be used to control another system or a process. With sensors, almost any physical element may be located. 
2. Data Processing: The handling of data with computer assistance. Flow of data from the CPU and memory to the output device, formatting or other data preparation, and transformation of raw data into machine-readable form Data processing is the act of performing specified actions on data using computers. 
3. Cloud Dispersion Cloud Distribution is a next-generation value-added distributor that specialised in bringing cutting-edge, disruptive, cloud-first networking, data centre, and cyber security technologies to market.. 
4. Grid condition: The grid manager displays both the overall grid state and the current condition of each grid service. The grid status represents those grid members or services that are most important. When every component of the grid is operating correctly, the overall grid status is green. 
5. Service engineer: Among the duties that service engineers have both within and outside of buildings are the design, installation, and maintenance of mechanical, electrical, and public health safety systems. 
6. Cloud provider: A third-party company is referred to as a cloud provider if it provides cloud-based platforms, infrastructure, applications, or storage services. 
7. Warehouse officer: The warehouse officer plays a critical role in the supply chain team and process. He or she is there to support projects and programmes. .  

  8. INDEX.HTML: INDEX.HTML is the homepage by default. The index.html page is the most popular term for the default page that is shown on a website when no other page is provided when a visitor requests the site. In other words, the home page of the website is called index.html.

9. CDN: A content delivery network (CDN) is a group of geographically scattered servers that expedites the delivery of web content by bringing it closer to users. Data centres all over the world employ caching, a method that saves copies of files temporarily, so you can access online content through a web-enabled device or use a local server to speed up your browser. CDNs cache web pages, images, and video on proxy servers close to where you are actually at. You may view a movie, download software, check your bank account, post on social media, and make purchases all without having to wait for the content to load. 

10. Server: A device that answers to client requests, such as a server, network computer, software programme, or other apparatus. When a client requests web pages over the internet, for example, a web server is a computer that uses the HTTP protocol to transfer those web pages to the client's computer. A print server manages one or more local area network printers and prints. files that are sent to it by client computers. Additional examples of servers include file servers, which store and retrieve files for clients, and network servers, which control network traffic.  

11. Controller: To allow several electronic components on a single vehicle to share vital control data, the automotive industry developed the Controller Area Network (CAN), a separate type of serial communications protocol. 

12. The LDR Grid values An LDR is a component whose variable resistance changes in response to the quantity of light it receives. They can now be utilised in light sensor circuits as a result. The LDR has a high value when there is no light. The LDR's resistance value varies according on kind. It is approximately 10,000 this time. According to Ohm's Law, when the light intensity increases, the resistance reduces, increasing the current and, as a result, the voltage at A0 (Va0). 

IV. SYSTEM REQUIREMENT & SPECIFICATION

A. Hardware Requirement

B. Software Requirement

C. Technologies Used

• MEAN stack for web and UI applications
• Third party IoT cloud applications for Android app
• Arduino IDE
• C Language for firmware

In this system two android application are developed such as user application and driver application.

1. User App-

a. Log in- User log in on system.

b. Register -User register on app.

c. Home – Rearrangement of LDR Objects

d. Change of the LDR Colour As its Changing incident light intensity on hardware

2. Admin Panel

Admin is able to add New Module, Supervise all the services if they are working fine.

VI.  ACKNOWLEDGMENT  

Our project report on the "Live Industrial Inventory Tracking System" is being presented among a vast landscape that has given us motivational advice and encouragement. We would like to take this occasion to express our gratitude to everyone who has helped us in whatever way. We would like to express our heartfelt appreciation and sincere thanks to Prof. S.S. Shinde for being our internal mentor throughout the years. We were able to finish our project work thanks to his enthusiasm and support. The department head, Dr. M. L. Bangare, and the other faculty members, as well as everyone else involved both directly and indirectly for their assistance in every facet of the project. Last but not least, we would like to extend our deepest gratitude to Dr. A.V.Deshpande, for  providing us with infrastructure and technical environment. 

Conclusion

In conclusion, a live inventory tracking system using LDR (Light Dependent Resistor) sensors offers numerous benefits for businesses. By utilizing LDR sensors, the system can accurately monitor and update inventory levels in real-time, ensuring accurate stock management and minimizing errors. The LDR sensors detect changes in light intensity, enabling the system to track the presence or absence of items on shelves or in storage areas.

References

[1] Aditya A. Pande, S.Sabihuddin, “Study of Material Management Techniques on Construction Project”, International Journal of Informative & Futuristic Research, ISSN: 2347-1697, Vol.2 (3), May 2015, pp.3479-3486. [2] S.Angel Raphella, S.Gomathi Nathan and G.Chitra, “Inventory Management- A Case Study”, International Journal of Emerging Research in Management &Technology, ISSN: 2278-9359, Vol.3 (3) June 2014, pp.94-102. [3] Ashwini R.Patil, Smita V. Pataskar, “Analyzing Material Management Techniques on Construction Project”, International Journal of Engineering and Innovative Technology (IJEIT), Vol.3 (4), Jan 2013, pp.96-100. [4] Dipak P. Patil, Pankaj P. Bhangale, Swapnil S.Kulkarni, “Study of Cost Control on Construction Project”, International Journal of Advanced Engineering Research and Studies, Vol.02, April 2014, ISSN2249–8974. [5] P.G. Matsebatlela and K. Mpofu, “Inventory Management Framework to Minimize Supply and Demand Mismatch on a Manufacturing Organization”, International Federation of Automatic Control, Vol.3, No.48, Mar 2015, pp- 260- 265. [6] Sayali Shet, Raju Narwade, “An Empirical Case Study Of Material Management In Construction Of Industrial Building By Using Various Techniques”, International Journal of Civil Engineering and Technology, Vol. 12 (09), April 2015, pp.393-400. [7] 2016 IEEE 55th IEEE Conference on Decision and Control (CDC) 2. 2014 American Control Conference - ACC 2014. [8] 2012 Portland International Conference on Management of Engineering & Technology (PICMET). [9] \"Inventory Management Software\". EGA Futura. Retrieved 23 November 2012. [10] \"Integrations and Apps for Online Inventory Management. Software Trade Gecko\". www.tradegecko.com. Retrieved2015-11-24.

Copyright

Copyright © 2023 Prof. S. S. Shinde, Ganesh Karadkhele, Pratik Lohakare, Shubham Shete, Vaibhav Vaidya . This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.