ALL Metrics
-
Views
-
Downloads
Get PDF
Get XML
Cite
Export
Track
Software Tool Article

Web/Mobile system innovation: An efficient revolution in warehouse management.

[version 1; peer review: 2 not approved]
PUBLISHED 21 Mar 2024
Author details Author details
OPEN PEER REVIEW
REVIEWER STATUS

This article is included in the Software and Hardware Engineering gateway.

Abstract

In today’s society, the amount of data available in many area has made it more important than ever to use effective technological tools for accurate and clear analysis and presentation of information. Therefore, the main objective of the research is to implement a Web/mobile system to improve inventory management in a private company. It has been developed under an agile extreme programming XP methodology, taking into account the following phases, which are carried out four structural activities planning, design, coding and testing. In addition, the following technologies were chosen: such as with programming languages PHP, with markup language PHP, MySql v. 10.0 as database system MySql v. 10.0, and cascading style sheets CSS for visual customisation. Therefore, the results showl a 13% improvement in the efficiency of the percentage of spools to be located (PSL, a 28% a better control of the index of percentage of inventoried coils (IC) and an 1,1% difference in efficiency of the Productivity per user (PU) index. With the implementation of a web-based web/mobile inventory management system to improve inventory control and mobile to better control of a company inventory management, using as a reference the most agile methodology to diversify the cases and functionalities contained in the system.

Keywords

Information Technology, Web/Mobile System, Inventory Management; Extreme Programming (XP).

Introduction

In recent years, society has experienced continuous exponential growth, which has led to the need for effective tools for the analysis and visualization of information systems technologies suitable for business growth, continuous development, and the use of information systems with large increases in resources. Compliance with requirements and provision of information.1 In this environment, it’s a way of simplifying certain tasks on the internet, and a static website is primarily a means of communication. Web-based information systems are examples of web applications that have evolved from dynamic web pages to database-based information systems. There are systems with additional functions such as system tracking.2 Traditional software systems have been extensively studied, quantum software maintenance is still a new area of research, but it is a critical element in ensuring the quality of the entire quantum computing system.3 In this sense, we are in a globally connected society that is always updated with instant information.4 In addition, there is a personalised digital system accessible to all, which, thanks to the improvement of technology, makes it possible to sell products or services via the internet and also includes media of great importance.5

In this context, technology has exploded in all areas of our society, and technology is no exception, in the constant search for optimising production and service delivery: more efficient and safer management; The inventory control system for the mobile/web production floor has become one of the most important and crucial factors for companies to maintain their stability and success.6 Improve performance, efficiency, and understand the different levels of companies that manage their manufacturing inventory levels in different waysBy evaluating internal controls, we can determine the level of reliability and risk in inventory management.79 A process-based inventory management system has been implemented for the inventory management of incoming and outgoing goods.10

The development of a proper stock policy is essential to maintain a certain level of operation of the inventory system operation and relatively low maintenance costs. In this way, inventory management contributes to the consolidation of warehouses and provides greater efficiency in accounting entries thanks to the records made in the various inventory sheets that describe the actions carried out both in the warehouse outflows and in the purchase, sale, production, maintenance and service of an organisation. To ensure fast and efficient production, we use an inventory management system that helps reduce the cost costs and time spent on shipping raw materials and products.1113 It requires change management processes and the use of mobile applications. It can increase the productivity of employees in the workplace. It is a reuse-based approach to defining, implementing, and assembling independent, loosely coupled components into a system.14 A good inventory management system will always have a positive impact on customer satisfaction in dealing with the uncertainty of demand.15

Numerous studies have shown that the development of web/mobile inventory management systems has the potential to positively impact inventory efficiency, accuracy, coordination, and security. Reduce inventory carrying costs and increase operational efficiency with a manageable and easy-to-use system with a web interface that provides convenient and efficient inventory management and integrates barcodes and cloud computing, Arduino-based wireless station nodes,16 IoT, and secure form channels to access data through a dedicated web portal. On the other hand, develop an intelligent system implemented in a web-based environment to integrate multiple stores and ensure effective coordination of all stores and optimise inventory management performance by integrating multiple systems and ensuring effective coordination and monitoring. It has been compared to analyse the combined impact of interest rates and inflation on inventory systems in different countries in the context of rising inflation and linear demand over time affecting inventory costs. In his article, he developed a web application for the efficient development of a slippage inventory in an economical way.1719 Based on Ref. 20 their multi-item inventory model thakes into account warehouse capacity constraints, demand uncertainty, and lead times.

However, the technical community still lacks reliable, accurate, and up-to-date data on the implementation of a web/mobile inventory management system, including the process that begins with the distribution of raw materials, most likely, unprinted rolls. Positioning, return and switching of flows between actions, manual calculations and security issues, incidents that result in duplication of information or duplication of information or abandonment of parts of the technological infrastructure. Under these conditions, web and mobile systems have been designed and implemented for the production area, facilitating the use of mobile/web systems for better control of the distribution and location of rolls during processing, as well as more efficient inventory management.

This study contributes to filling the knowledge gap by examining in detail the specific benefits and challenges associated with the implementation of web/mobile system to improve inventory management for a private company. The development of this system allows collaborative work between the company, the worker and the customer, being a diversified, modern help that will effectively improve inventory management effectively, in this way there will be economic productivity.

Therefore, the objective of this research is to implement a mobile/web system to improve inventory management, improve processes in the production area and inventory management in the company Emusa Peru S.A.C., Chorrillos.

Methods

Two laptops equipped with Quick Emulator (QEMU) Virtual Central Processing Unit (CPU) processors version 2.5 + 2.60 GHz were used, accompanied by 32 GB of Random access memory (RAM) with C# from Microsoft Visual Studio.Net 2019 with ASP.NET Core Runtime 3.1.25 with Angular frame interface and Ionic 6 with a standard Windows Server 2016 operating system or higher with internet information services version 10 with base Oracle Data Platform, Visual Studio 19 were used for the development of the web/mobile system to improve inventory management.

  • Implementation

We chose to use the agile extreme programming XP methodology, taking into account the following phases that are executed in the four structural activities as shown in Figure 1.21

6dec92e6-aa33-4c29-ab80-f62ea63d1bf7_figure1.gif

Figure 1. XP Methodologies Rules, adapted from Ref. 21.

  • Operation

Planning phase

The description of the users based on the indicators (Pending Dispatch, Pending Inventory, Pending Location). The first requirement is to access the system, registration of the users (Administrator, support user, client user). The second requirement allowed the creation of task, the third requirement allowed the creation of a task, the third requirement allowed the creation of task is in progress with its respective location and the fourth one generated report about that in process this or in what process it stayed or if it finished the task.

Design phase

Users with a simple design were selected. In addition, tasks (CRC Cards) were created to allow even better system analysis and compression, as shown in Figure 2.

6dec92e6-aa33-4c29-ab80-f62ea63d1bf7_figure2.gif

Figure 2. CRC card model.

Coding phase

The structure of the web registry has been programmed using the HTML tag language, CSS for the customisation layer, JavaScrip to make it more dynamic, among other technologies such as Axios, JQuery, Sweet alert and Ladda. For the operation of the web system, the programming language PHP8, and the database administrator MySql v. 10.0. Figure 3 shows the lines that pointing to a production development environment. As shown in Figure 3.

6dec92e6-aa33-4c29-ab80-f62ea63d1bf7_figure3.gif

Figure 3. DataBase.cs Report.

Testing phase

A verification was carried out The system was verified by performing unit tests to find some kind of role in the codes and improve their quality, the acceptance test was carried out, which was supervised together with the client to approve the application. Figure 4 shows the software development flow visually. As shown in Figure 4. Also, Figure 5 also shows the database diagram, which shows ta is structured and the relationships between them.

6dec92e6-aa33-4c29-ab80-f62ea63d1bf7_figure4.gif

Figure 4. Software development flowchart.

6dec92e6-aa33-4c29-ab80-f62ea63d1bf7_figure5.gif

Figure 5. Inventory Control Web System Database.

Results

Presentation Login to the web system

Figure 6 and Figure 9 show the process of accessing the Web/Mobile system, as shown in the two web/mobile access interfaces.

6dec92e6-aa33-4c29-ab80-f62ea63d1bf7_figure6.gif

Figure 6. Logging in to the Web system.

In the case of the access web access, you will need to enter your username and password.

Inventory Report Process

In Figure 7, the user has the option to generate queries, select the indicators option, and select the chart to monitor.

6dec92e6-aa33-4c29-ab80-f62ea63d1bf7_figure7.gif

Figure 7. Inventory Report.

Process of Exporting in Excel

In Figure 8, the user has the ability to create queries and select chart to monitor.

6dec92e6-aa33-4c29-ab80-f62ea63d1bf7_figure8.gif

Figure 8. Export in Excel.

Mobile System Login Process

In Figure 9, in the case of the Mobile interface, you will need to enter your username and password. Then select the type of product you wish to trade. Select the warehouse where they will perform the operation.

6dec92e6-aa33-4c29-ab80-f62ea63d1bf7_figure9.gif

Figure 9. Login to the Mobile System.

Indicator Report & Code Generator

Figure 10, select an option from the indicators (Pending to Locate, Pending to Inventory, or Pending by Dispatch). Place the data you want to enter and a code will be generated that will be located in the rack, this way it will be done by making a count and it will also decrease according to how the days go on in the following indicators for a better control. In this way, it will be easier for the workers in the production area to have a better management and control of it.

6dec92e6-aa33-4c29-ab80-f62ea63d1bf7_figure10.gif

Figure 10. Indicator and Code Generator.

Discussion

In Figures 6 and 9, the asset management system in the web/mobile system access interface allows the browser (user) to interact with the machine ensuring fault tolerance, visual appeal, control and, most importantly, meeting the user’s expectations. The relationship between the asset management system and web/mobile system access is undeniable. This is in line with the assertion that the critical processes applied within the company to develop new web systems help to increase sales within the company and even without this, you still need to reopen your main POS system. Thanks to the web system developed, most of the company’s products can be found in an organised way in Internet search engines. Web applications are widely used todays of the convenience of the web browser as a thin machine client and the independence of the operating system.22,23 Saving money and improving management are two benefits of using web/mobile applications. Mobile configuration has been shown to improve overall system performance by introducing clustering capabilities.24

In Figure 7 and Figure 10, registering a new code (inventory) allows users to create and facilitate better service delivery, on both web and mobile platforms, to improve inventory automation. The link between registration and web/mobile platforms cannot be denied. This is in line with what he says are some of the advantages offered by information systems that are integrated with current technological tools that allow fast and flexible communication. The system will allow the company to optimise inventory management, which will be reflected in lower costs for inventory management ordering, storage, among other variables.25,26 It is presented as a very effective strategy to improve the mobile/web system and optimise inventory management on different platforms. Mobile: Addresses data privacy, mutual authentication, session key agreements, and prevention of potential attacks.27

In Figure 8, the user has the option to generate queries and select the graph to monitor. This shows the close relationship between query generation, web performance, and the selection of images to view, and this relationship is undeniable. This is in line with what he says is an important feature of a performance tracking system, allowing users to identify critical performance issues and take action quickly. It collects and analyses the data and provides with detailed information to the system administrators. Custom control provides with additional functionality for a more modern and up-to-date control system.28,29 The ability to provide detailed information in an easy-to-manage digital format can be useful for good governance. In addition, it is effective and cost-efficient to maintain constant communication with production staff for good inventory management. Regular updates are required to monitor production and support this utility.30

Conclusion and future work

This study has successfully completed the development and implementation of a web/mobile inventory management system in a company that relied on existing manual management. During the course of the study, modernisation issues of production data collection, storage, and availability in terms of inventory management were addressed and overcome.

Initially, the inherent limitations of manual recording systems were identified, including lack of efficiency, difficulties in accessing and organising information, and the risk of data loss in any process. The implementation of web/mobile systems has emerged as a viable solution to address these shortcomings. By moving of various processes to a digital environment has made production information has become more available, readable, and secure. These changes have significantly improved the quality of management and efficiency in the manufacturing industry by providing relevant information in an accessible and efficient manner.

In addition, the creation of a web/mobile system facilitated communication and coordination between departments. Centralised access to data from each process optimises the creation of detailed and accurate records, increasing the word efficiency of production specialists. Interaction between different regions and different locations proved to be one of the main advantages, overcoming one of the limitations.

In short, new researchers are encouraged to use the latest information technologies to achieve optimal results in assessments, such as expert systems and/or artificial intelligence systems. Exploiting the connectivity of devices through the Internet of Things (IoT). In addition, it is important to develop evaluation tools to measure the positive and negative impact of the implementation of this new module on the patient experience.

Comments on this article Comments (0)

Version 1
VERSION 1 PUBLISHED 21 Mar 2024
Comment
Author details Author details
Competing interests
Grant information
Copyright
Download
 
Export To
metrics
Views Downloads
F1000Research - -
PubMed Central
Data from PMC are received and updated monthly.
- -
Citations
CITE
how to cite this article
ZAVALETA SAENZ CL, Romero Ruiz A and Pacheco A. Web/Mobile system innovation: An efficient revolution in warehouse management. [version 1; peer review: 2 not approved]. F1000Research 2024, 13:213 (https://doi.org/10.12688/f1000research.144942.1)
NOTE: If applicable, it is important to ensure the information in square brackets after the title is included in all citations of this article.
track
receive updates on this article
Track an article to receive email alerts on any updates to this article.

Open Peer Review

Current Reviewer Status: ?
Key to Reviewer Statuses VIEW
ApprovedThe paper is scientifically sound in its current form and only minor, if any, improvements are suggested
Approved with reservations A number of small changes, sometimes more significant revisions are required to address specific details and improve the papers academic merit.
Not approvedFundamental flaws in the paper seriously undermine the findings and conclusions
Version 1
VERSION 1
PUBLISHED 21 Mar 2024
Views
5
Cite
Reviewer Report 17 Sep 2024
Sadia Samar Ali, King Abdulaziz University, Jeddah, Saudi Arabia 
Not Approved
VIEWS 5
After a comprehensive review of the paper, several critical issues emerged.

The discrepancy in the paper title, too, as it does not suggest or address the main focus, may not be adequately represented as per the scope ... Continue reading
CITE
CITE
HOW TO CITE THIS REPORT
Samar Ali S. Reviewer Report For: Web/Mobile system innovation: An efficient revolution in warehouse management. [version 1; peer review: 2 not approved]. F1000Research 2024, 13:213 (https://doi.org/10.5256/f1000research.158812.r318135)
NOTE: it is important to ensure the information in square brackets after the title is included in all citations of this article.
Views
8
Cite
Reviewer Report 21 May 2024
Aamir Rashid, York College,, City University of New York (CUNY), New York, USA 
Not Approved
VIEWS 8
Thank you very much for this research presentation. The research has researched that is very relevant and required in this era. However, the research lacks in providing the rationale of the study. The literature is not sufficiently provided that questions ... Continue reading
CITE
CITE
HOW TO CITE THIS REPORT
Rashid A. Reviewer Report For: Web/Mobile system innovation: An efficient revolution in warehouse management. [version 1; peer review: 2 not approved]. F1000Research 2024, 13:213 (https://doi.org/10.5256/f1000research.158812.r260276)
NOTE: it is important to ensure the information in square brackets after the title is included in all citations of this article.

Comments on this article Comments (0)

Version 1
VERSION 1 PUBLISHED 21 Mar 2024
Comment
Alongside their report, reviewers assign a status to the article:
Approved - the paper is scientifically sound in its current form and only minor, if any, improvements are suggested
Approved with reservations - A number of small changes, sometimes more significant revisions are required to address specific details and improve the papers academic merit.
Not approved - fundamental flaws in the paper seriously undermine the findings and conclusions
Sign In
If you've forgotten your password, please enter your email address below and we'll send you instructions on how to reset your password.

The email address should be the one you originally registered with F1000.

Email address not valid, please try again

You registered with F1000 via Google, so we cannot reset your password.

To sign in, please click here.

If you still need help with your Google account password, please click here.

You registered with F1000 via Facebook, so we cannot reset your password.

To sign in, please click here.

If you still need help with your Facebook account password, please click here.

Code not correct, please try again
Email us for further assistance.
Server error, please try again.