Essay: AN ONLINE SALES AND INVENTORY SYSTEM WITH CREDIT-LINE MONITORING FOR IYAMU ENTERPRISES

Nowadays online process systems are utilized everywhere throughout the web. One of the online process systems is the online sales and inventory system. It became convenient in every aspect of businesses. Every process data are required details of the costumers such as Items purchased, price list and date, using sales and inventory system can benefit the producers and trade resellers from a thorough solution. Sales and inventory system authorized much highest accuracy on stocking and product management. It also manages ease of relationship between employees and shoppers. So employees can easily finish a daily task.
Primarily, online sales and inventory are not new in a country; most of the business established utilizes this kind of system. Sales and inventory system can be a great edge in any kind of business. It can possibly enhance the business process. It’s quite indeed a great investment; to have an online sales and inventory system. Intelligence gathered from sales and inventory static, using sales and inventory software is one of the key to have successful marketing strategies. Also guarantees competitive edge for any type of business. Furthermore, the sales and inventory software is advantageous towards business line. Every sales transaction the system will automatically update the company’s database. And also display the corresponding demand in terms of inventory and investment.
According to the Freescoreindia (2015), almost every people used credit monitoring services to assist them to be updated on their credit histories and to increase their capacity to recognize an illegal activity. Credit Monitoring services alert individuals about changes to their credit report easily – either via email, instant message on mobile phones or by phone calls.
Furthermore, using a Credit-line monitoring will be useful to the company, it will help to monitor the credit-line of each customer, it will also find out if how much is the available credit line and how much is the debt of the customers to the company.
There are a lot of businesses that required an online sales and inventory with credit line monitoring. Iyamu Enterprises is one of the businesses that really need this kind of information system. Iyamu Enterprises is a direct selling company; the dealer can purchase products and pay after one month. Iyamu Enterprises is using pen-paper method in recording their transaction. However, they are using Microsoft Excel in recording and tracking the credit of the dealers.
The researchers developed an online sales and inventory with Credit line monitoring system for Iyamu Enterprises in order to manage their transactions and product correctly and have an accurate way in terms of monitoring the dealer’s credit.
Iyamu Enterprises is located in Angeles City. Marietta Maniti and Fernando Maniti, they are the couple who owned the business. They started in a small group of regular dealers with one employee. Iyamu Enterprises is a direct selling business, which offers a one month to pay credit on their products. If the dealer completed the following requirements such as; Barangay Clearance, valid Id, 1×1 or 2×2 pictures and the company will accept the dealers with one thousand five hundred initial credit-lines and get an extra discount up to 30% in their purchased products. Iyamu Enterprises has two types of dealers, the regular dealers, and walk-in dealers. The regular dealers can credit products within one month. The walk-in dealers are not allowed to have a credit in the locale. They should buy products in cash payment method.
The locale can return products to the supplier within sixty days of purchasing. Most of the products they returned to the supplier are coming from the dealers. The dealers can also return products to the locale except for the cosmetics, fragrances, and underwear unless it’s defective. They can return products within one week, these are the products that have damaged or it can be wrong served.
Iyamu Enterprises is using Microsoft Excel for recording and computing some of their transactions and they also depend on their manual listing of products and inputs of data, it does not have proper listings of product in some instances; every piece of documents they used is important to serve as their record and reference, if who is still in debt. The business requires keeping the records, accounts and become accurate in the number of products.
The numbers of dealers of the locale become bigger, and their products sale has grown. Mishandling of inventory can cause discrepancies in the supplies. All suppliers at one time or another end up with under stock or overstock products, under the stock of products can lead to a loss for the company because orders of dealers may be out of stock.
To address the problem, the researchers developed an Online Sales and Inventory with Credit-Line Monitoring System for Iyamu Enterprises in order to handle accurate sales and inventory and to monitor the credit line of their dealers.
The main objective of the study is to develop an Online Sales and Inventory System with Credit-Line Monitoring for Iyamu Enterprises.
Specifically, the study seeks to achieve the following:
1. To design, develop features that will provide user access level.
1.1 Admin Account;
1.2 Staff Account; and
1.3 Dealer Account.
2. To develop a system with the following features:
2.1 File Maintenance;
2.2 Sales Transactions;
2.3 Generating reports for Sales, Collection, Inventory, Dealer master files and Return Items.
2.4 Credit line Monitoring;
2.5 SMS Notification using SMS Gateway Me;
2.6 Content Management System;
2.7 Back up Data and Generating CSV.
3. To create a system using the following tools:
3.1 HTML5;
3.2 Adobe Photoshop CS6;
3.3SMS Gateway Me;
3.4 Bootstrap v.4;
3.5 XAMPP v3. 2. 2;
3.6 Semantic UI; and
3.7 Code Igniter.
4. To administer the Alpha and Beta tests.
5. To evaluate the system using the ISO 25010 with the following criteria:
5.1 Functional Suitability;
5.2 Performance Efficiency;
5.3 Compatibility;
5.4 Usability;
5.5 Reliability;
5.6 Security;
5.7 Maintainability; and
5.8 Portability.
The study focused on building an online sales and inventory system with credit-line monitoring for Iyamu Enterprises.
The study includes three access levels. The administrator, staff, dealers, the administrator account, is the business owner which can add access to the system, updates credit limit of the dealers. Another account is the staff which can also access the entire system except for the update and add account access and increased the credit limit of the dealers. The dealers will register on the locale through completing the certain requirements, after registration, the admin will be added the access of the dealers in the system. The dealers account can access the content management of the system.
The system includes the file maintenance where the admin or staff can view and update the product master files and the dealer’s master files. This module includes all the list of the dealers and product information.
The sales transactions which can be made in credit or cash, the user can print reports and invoice for sales transactions. The total purchased of the dealer was automatically added in their account. The system can also create a list of return items. This will serve as the reference of the locale to know if how much the total products they returned to the suppliers.
The system can generate CSV and back up the whole database.
The sales and inventory report is generated. In addition, the admin or staff can also view the daily, weekly, monthly, and yearly sales. Each product of the system has a unique key.
The credit line monitoring module that was provides clarity of credit issues and supports monitoring dealer’s credit, whenever the dealers are qualified for an increased credit-line according to their performance in paying their accounts.
The system also has an SMS notification using SMS gateway me which serves to notify new dealers to their username and password in the system. It is also used to send due date reminders, promos, and an announcement in the locale.
The content management system features which will function as an advertisement tool for Iyamu Enterprises by posting their promos. It enables dealers to view the online brochure that shows the features products of the suppliers. This may help the dealers to view and be updated on the latest information about Iyamu Enterprises. The dealers can create list of order by clicking the add button in the online brochure and it will be added to their sales transaction but the inventory will not be affected. The listed products of the dealers have limitation up to twenty thousand pesos only. The content management also has a messenger button were the users can send a message directly to the Facebook account of the locale.
The researchers used some part of the XAMPP which is the PHP v.7 and MySQL in developing the system. HTML5, Bootstrap v.4, and Semantic UI were used by the researchers for designing the user interfaces of the system. For the back end function, the researchers used Code Igniter. The graphics of the system were done using software editing tool Adobe Photoshop CS6. The researchers also used SMS Gateway Me for SMS technology.
The system was tested using Alpha and Beta Testing. Alpha will be for IT experts and beta will be for not IT experts. There are (4) IT Expert in MCC, and (1) IT experts in cloud staff, to test the front and back end of the system. To test the system for the beta testing the researchers looked for 25 end users, which are the dealers, staff, and admin ofIyamu Enterprises. The system was evaluated using ISO 25010 which is Functional Suitability, Performance Efficiency, Reliability, Security, Maintainability, Compatibility, Usability, and Portability.
For the limitation of the study, the researchers’ developed online system which the dealers can view their accounts but they cannot pay online.
The researchers believe that this study will benefit the following:
To the locale,
It will benefit in term of lessening the time and money of the whole process in sales and inventory. The developed system will provide easy transactions will be faster and they do not have to hire another employee to work for Iyamu. It gives more correct and secure records of sales and a list of products.
To the employees of the locale,
One of the people will be significant because they can easily type instead of writing transactions of the dealers. Their job will be much easier using the system.
To the Researchers,
It will be significant to the researchers because it will enhance their knowledge in the field of IT industry, it will serve as their reference for the future career or even in terms of finding their work that relates to their profession.
To the Dealers of the locale,
It will benefit the study in a way the printed invoice rights after purchasing an item the system will provide and they can better understand the flow of their transaction and monitor their credit-line.
The Future Researchers,
This study will have a reference on how making a system project. They will also have an idea on how to improve existing systems and what module to develop and more reliable system.
The terms used in the study defined conceptually and operationally for the readers to understand better meaning of it.
Credit line- is an order in which a bank or a business expand a particular amount of unsecured credit to a specified borrower. The deal between the dealers and locale, if how much is the specific amount that the dealers can owe in the locale.
Dealer/s ‘ The locale customers that buy and sell their products.
Direct Sales – is a procedure of marketing and retailing goods and services directly to the costumes, in their homes or in any other location away from enduring retail premises. The Market the good and service directly to the customer in one month to pay method.
Distributor ‘ a representative who supplies goods to stores and other company that sell a specific product to consumers.
Short Message Service Notification – It uses equalize transmission protocols to enable mobile phone devices to exchange short messages. Short message used to notify dealers from there due dates and promos from the locale.
Suppliers ‘ a group that provides something needed such as a product or services.
Online brochure – an instructional paper document often also used for promoting products that can be shown into a template. Picture list of items from their supplier (MSE, Natasha, Avon)
Credit-Standard or arranged terms (offered by a seller to a buyer) that control, the monthly and total credit.
Sales and Inventory – manages the inventory purchasing order fulfillment and other line functions for a company.
Walk-in – Customers who arrive without a registration in the locale, walk-in are not allowed to have a credit in the locale. They should buy products in cash payment method.
This section presents the written works and studies that exhibit importance and similarity with the developed study. It also discusses the capabilities and limitation of existing researchers, theories and paradigms that are related to the study.
According to Bryant (2013), the internet is most trusted information sources. People depend on internet for business and organizations. It provides us unlimited information about everything. One of the things that makes internet is easily attainable. An internet is giving a window into the global world. Internet put up everyone with a computer to think globally. The internet allowed the business line to international relationship with new customers or seller to lower cost and new buyer or customer to increase the sales.
Henderson (2013), before the evolution of the internet, the business owner may create advertisement, promoting their products locally in creating a name for their business but now using the internet they can easily promote their products in many ways.
Shopintergator (2013), this bright message can then be used to better customer relations and feedback into business strategies. Because of internet the business has a lot of opportunity to increase the communication between the customers they can interact different aspect such as product review’s, client criticism email bulletins dialog discussions and online journals
According to Fennewald (2014), a business need to store, analyze, and sort through an excess of information from many different sources such as customers, vendors, Stockroom and transporting with a specific end goal to be viable a business needs to remain efficient. Information systems give the organizations to learn and grow better approaches for business methodology. Information organization enables automation of steps in business ways that used to be performed manually like creating an account shipping order and labels. But nowadays, information technology can do better.
Alter (2016), Advances in computer-based information technology in the past years has prompted a wide assortment of systems that directors are presently utilizing to settle on and actualize choices. All things considered, these systems have been created without any preparation for particular purposes and vary altogether from a standard electronic information handling frameworks. Over and over again, lamentably, administrators have little say in the advancement of this choice emotionally supportive network; in the meantime, non-managers who do create them have a restricted perspective of how they can be utilized.
Markgraf (2015), some portion of administration is assembling and sharing data, and information system can make this procedure more effective by enabling supervisors to convey quickly. Rather than using Email, although it’s quite effective; But information system can work much efficiently by storing documents in folders they share with other employee who needed it.
One of the most sought after automated systems of various organizations is a sales and inventory system which comes as an inseparable unit. A Sales and inventory system is essential for each association because a good sales and inventory management can make phenomenal profitability.
According toPasceki (2012), the inventory administration is regularly utilized by organizations to track stocks, as they are being transported from distribution center to retail store lastly to the clients.
Harmon (2012), sales is software that calculates sales manages the computerized cash drawer; it sums up the sales total and calculates the change. Items that are purchased by the client will minus the amount of items sold on the inventory system. Sales ought to have the capacity to handle deals with sales and inventory
Essays, UK (2013), sales is a system that monitors business transaction, and manages a tasks that are drawn out when done manually, for example, monitoring and managing stock.
Peavler (2015), sales and inventory management system make it easy in checking cost and recording the markdown simple. Rather than experiencing a pile of receipt towards at the finish of the day, the sales system automatically updates the sales as it occurs.
PC World, Philippines (2015), the entrepreneur will have access tools that can help him organize sales leads, manages accounts and contacts, generate real-time reports, even integrate functionality and data from existing business application such as sales system.
Credit-Line Monitoring According to Small Business Development Corporation (2016), Entrepreneurs nowadays are implementing sets of policies, to minimize the capital tied up in debtors and to lessen the vulnerability of the business to bad debts. Thus having properly managed finances prevents having a tail of creditors asking you for the payments of your debts.
Smith V. (2013) Affirms that research which concerns shorter range or working capital decision making has come out, to be unproductive. The inabilities of financial managers to think of a plan and properly control the assets and liabilities of their respective firms. This has been likely the cause of business failure/ bankruptcy in the recent years.
Bhatt V. (2013) widely touches upon a method of evaluative working capital finance; applications of large manufacturing concerns. It states that similar methods need to be devised for other sectors such as; agriculture, trade, etc. The author point of view is that while banks provide short-term finance, they focus their attention on adequacy of security and payment capacity.
In the threshold of our generation, technology’s growth is enormous; towards the future of the World Wide Web, software engineering and computer programming. Mobile devices or smart phones are globally used. Aside from the use of the device as a medium of communication, people nowadays wants these devices to do everything, including accessing their e-mail accounts, Internet surfing, even accessing personal and corporate information. One types of fast growing technology nowadays is called SMS (Short Messaging Service).
Parker (2014), SMS is instant at a time when customers handed over money and they are eagerly waiting for news about their products; it’s indeed much convenient to use SMS as a communication tool. Over 90% of texts get ready within just 5 minutes. And your customers will definitely appreciate the instant updates.
Orla (2013), basically, using SMS is promoting an instant communication; Using SMS when you want to share something value to offer in your customers they will simply send the message to their friends or family. SMS is not for only existing customers but also it will help to gain a lot of costumers to patronize the company or the business.
SMS Gateway Me, Inc. (2017), the SMS Gateway Me a Messaging API (Application Program Interface) makes it so easy to send and receive SMS and MMS messages as well as Question meta information about instant messages, for example, conveyance status related media stage and use devices like copilot to manage with your messages all around at scale.
There are various languages and software that can be used in creating an information system. The following will compare which is best to use.
MySQL, was developed of new features found in MySQL server version 5.0.0 and the newer MySQL has a number of benefits, the key benefits being:
‘ Object-Oriented interface
‘ Support for Prepared Statements
‘ Support for Multiple Statements
‘ Support for Transactions
‘ Enhanced debugging capabilities
PHP vs. ASP, According to PixelCrayons (2016), Active Server Pages (ASP), a program runs with Microsoft alongside with Internet Information Server while Hypertext preprocessor (PHP), is more similar with C++ languages; it is also much more flexible in terms of database connectivity.
Apache, According to Providence (2017), Apache is the world’s most popular web server. That provides a full range of web server features.
SMS Enabler, According to Alexander Smirnov (2015), SMS enabler allows automatically receiving and replying to incoming SMS messages using a GSM or 3G mobile phone.
Adobe Photoshop, according to ThoughtCo (2017), is considered one of the leaders in photo editing software.
HTML5, used to build website, there are several new features that open up a world of opportunities in HTML5.
According to Khriyenko O. (2014), 2014 semantic UI assumes imperative part for administrations and application to be more appealing for end client.
According to Gerchev (2014), the goal of Semantic UI framework is to empower designers and developers “by creating a language for sharing UI personalization on semantic level”. As other frameworks do, it utilizes plain English.
According to Chiaretta (2017), Semantic UI is a natural language, it is more profound and almost philosophical reasoning that led to the creation. Semantic UI is developed with less, a very basic theme, so theming is just a matter of customizing variables.
According to Linked in (2014), a Code Igniter, is a framework that most popular in developer’s community and has a simple and elegant toolkit to create full-featured web applications.
According to Digital Ocean (2016), powerful PHP framework that can help you greatly speed up the development and does a great job separating logic from presentation.
According to Vegibit (2017), in the MVC structure separate out the logic from presentation. When it comes in making request to the website, the controller begins in creating some decisions.
Software testing, is more than just debugging, it ensures the quality of the software, verification and validation, or reliability estimations. Software testing remains an art; however the difficulty in software testing is, it consumes more time and requires much human effort. Software testers need to have inputs and also check the performance of the software or application, to make sure it never fails.
According to Center Code (2017), Alpha test, a test among the researchers to confirm that the system works. The first phase of testing in a software development process, includes unit, component and system testing. The researchers will also test the system on the lowest machine to sure download times are accepting and pre-loaders work.
At the same time, Beta testing deliberate free trial to figure out the certain products. Also consider the beta testing as ‘pre-release testing.’
According to Beihang (2013), The W3C validation is just a standard for specified machine language, checking web documents, spelling, grammar, syntax, and proofreading.
According to iso2500.com (2013), the aim of ISO/IEC/25015 is the quality model cornerstone of software quality evaluation for testing, which can be used to any software development. It ensures the (Functionality, performance efficiency, compatibility, usability, reliability, maintainability, and security). These are the eight quality models that categorize the product quality into the characteristics and sub-characteristics.
Based on the foreign, local studies and literatures examined by the researchers were very helpful in developing the study.
The Internet is very useful in all kinds of business and organizations. Internet allowed the business world to international relationship with new customer or seller to lower cost and new buyer or customer to increase the sale. The system includes an online based. All the customers, admin, staff must have internet access in using the system.
Information system can do more in the field of business. Information System has a major role in business such as creating new products and services. Information system also is helpful in storing and sharing data. The system includes information system to organize all their data and to improve their efficiency of their operations in order to achieve higher profitability.
A sales and inventory system is very important in every organization, Thus a good sales and inventory management creates, excellent productivity and to have an organized record the products and customers. The study includes sales and inventory module to organize the record of the products and dealers. Sales and inventory can make the transaction much easier for the customer. Through the help of the inventory system the right balance of stocks are maintained. It provides the actual quantity of products in the stocks of the locale and also the system can determine whether a product expires, gets damaged or goes out of season.
Credit management is implementing and maintaining a set of policies and procedures to minimize the amount of capital tied up in debtors and to minimize the exposure of the business to bad debts. The system includes credit line monitoring system in order to manage the credit line or the due dates of suppliers and customers.
The short message service (SMS) technology is one of the most widely used a mobile communication methods after phone calls. Through the help of this technology, communication has been a lot easier. SMS is not only used for communication, even in business transactions. Most business establishments use SMS to send notifications. The system has a SMS notification using gateway me used to notify the dealers from the promo’s, announcement, and due dates.
The researchers used the conceptual framework in order for the users to easily understand the concept of the developed project. The inputs of the study contained the requirements needed for developing the System. The knowledge requirements include knowledge of content management system, information system,
Programming language and related literature and studies. For software requirements the researchers used XAMPP for developing the system and as a database in storing data. Adobe Photoshop, HTML5 and Bootstrap for designing the interfaces of the system. The system will include an online product reservation, advertising the latest promos, services and products of the locale. The SMS Notification using SMS Gateway Me, mobility of the system will be used as a means of reminding for the due dates and sales products. For the hardware requirements the process phase includes the web which is used to develop the system by coding, designing and planning requirements, the Alpha testing, which the system is tested by IT experts, the Beta testing, which is tested by non-IT experts and also the ISO 25010 that evaluated by the system functional suitability, performance efficiency, compatibility, usability, security, maintainability and portability. The researchers used an Acer Laptop in developing the project with a specification of Intel Core i3, RAM At least 512 MB, Hard Disk At least 80 GB for the output of this phase is the Online Sales and Inventory with Credit-Line Monitoring for Iyamu Enterprises.
This section describes an initial exploration if how organization are using system development methodologies. It explains the development of a system or method for a unique situation.
The modified waterfall uses the same phases as the pure waterfall, but is not done on a discontinuous basis. This enables the phases to overlap when needed. The pure waterfall can also split into subprojects at an appropriate phase (such as after the architectural design or detailed design). The researchers used modified waterfall methodology, because it has more relaxed approach to formal procedures, documents and reviews. It also prevents having a huge bundle of documents. Hence the researchers has more time to devote themselves to work on the coding and don’t have to be bothered about the procedures.
This, in turn, helps to finish the product faster. SDLC adheres to important phases and steps taken that is essential for developers, such as planning, analyzing, designing, developing and testing.
Planning Phase, in this phase the researchers think first for what the researchers are going to develop and look a company to be fit in capstone project and Iyamu Enterprises is one of our choice to study, the researchers conducted an interview in the locale and find out that Iyamu Enterprises is using Microsoft Excel for recording and computing some of their transactions. To make their work easier the researchers decided to develop an Online Sales and Inventory System with Credit-line Monitoring.
Analysis Phase, is where researchers consider the functional requirements of the project. In this phase the researchers thinks and analyze on what will be the flow of the cost of the project. Did that the researchers study the company carefully and the researchers think that Iyamu Enterprises is one of the businesses that really need this kind of information system.
Designing Phase, in this phase the researchers developed an online sales and inventory system with credit-line monitoring and SMS notification for Iyamu Enterprises in order to handle accurate sales and inventory and to monitor the credit line of every customers.
Development Phase, in this phase the researchers used some parts of the XAMPP which is the PHP and MYSQL in developing the system. HTML5 and Bootstrap is used by the researchers in designing the user interfaces of the system. The graphics of the system were done using software editing tool Adobe Photoshop CS6. The researchers also used SMS Gateway Me API for gateway in SMS technology.
Testing and Evaluation Phases, the last phases involve system integration and system testing. The system will be tested using Alpha and Beta Testing. Alpha will be for IT experts and beta will be for non ‘ IT experts. There are (4)IT experts in MCC, and (1) IT experts in cloud staff, to test the front and back end of the system. To test the system for the beta testing the researchers looked for 25 end users, which are the dealers, staff and admin of Iyamu Enterprises. The system was evaluated using ISO 25010 which is Functional Suitability, Performance Efficiency, Reliability, Security, Maintainability, Compatibility, Usability and Portability.
The existing process was evaluated. Problems were identified. This was accomplished by interviewing Ms. Charlene Toca (Head Secretary) and staff that isdirectly involved with the current inventory. The data gathered is used to identify the scope and objectives of the study.
The existing process was examined, the data gathered from the researchers and interviews done to Ms. Charlene Toca the head secretary of Iyamu Enterprises were used to consider the system requirements. In particular, the deficiencies in the existing process must be addressed with specific proposal for improvement.
This was used to graphically show the inputs and outputs from/to external factors. There are four entities in the diagram which is shows the data flow of the studies. The dealers, admin, staff and supplier, the dealer’s entity give payment and order list which will be received by the staff entity. The Dealers entity received the invoice, list of brochure and SMS notification data from staff. The admin received report updates and credit updates data from the staff entity. The supplier give the delivery details which will received by the staff. The staff gives the order data and return details to the suppliers. The admin will give the payment data to the suppliers.(See Appendix A for the Context Diagram of the developed system).
Each dealer only have one account, Therefore in the Dealers table has a DealerID used as the primary key. Where in the account table has an AccountID also used as primary key and the DeaerID as foreign key. To create dealers list it will undergo to the items table to get a product, then it will create a list of items that will be sort by category table that used as primary key, the dealers list can proceed with the item table. Supplier table has a SupplierID that is used as primary key for the items t under table. After selecting products under the items table the next step will be the invoice table that requires the dealer’s list items and under this table the Collection Report table used as primary key and it will return to the invoice for the Sales report.(See Appendix B for the ER Diagram of the developed system).
This was used to graphically show the role of every user and the interaction between the systems. USE Case Diagram is a virtual tool to display system actors, USE Case and their relations. The diagram shows the function of each entity. There are three entities which is the admin, staff and dealers. The admin can add new account, manage user accounts, monitor dealers Credit-line, and update inventory and sales reports. It is also show the role of staff entity which is the staff can print invoice, update stocks, add new products, create return product list, send SMS notification, create sales transaction and create back up data. (See Appendix C, D, and E for the USE Case Diagram of the developed system).
The design phase develops the system specification of the developed system. It identifies the needed system modules and what will it do.
The Online Sales and Inventory System with Credit-Line Monitoring provided the locale with a cost-effective means of handling inventory management and report generation. This system provides three aspects of services, namely: Sales, Inventory and a Credit-Line Monitoring Function.
Mapping Diagrams. A function is a special type of relation in which each element of the domain is paired with exactly one element in the range. A mapping shows how the elements are paired. It is like a flowchart for a function, showing the input and output values (See Appendix F, G and H for the Mapping of the developed system).
In this phase of SDLC deals with the development of the developed system based on the design specification made. The researchers used the following software in developing the system:
‘ MySQL the programming language used to develop the system interface.
‘ XAMPP v3.2.2 a free and open source cross-platform web server solution packages was used for the system database;
‘ SUBLIME were the IDEs used for coding the system;
‘ ADOBE PHOTOSOP, for designing the system;
‘ GOOGLE CHROME, MOZILLA FIREFOX and MICROSOFT EDGE is the browser used to test the system;
‘ WINDOWS 7 or 10 Operating System
For the hardware used to develop the system, the researchers used a PC with the following specification:
‘ Intel Core i3
‘ 4GB RAM DDR3
‘ 500 GB of HDD
Testing phases required researchers to complete various test to ensure the accuracy of programmed code, the inclusion of expected functionality and the interoperability of application. The system was tested using Alpha and Beta Testing and used the criteria in ISO 25010 which is functionality feasibility, usability, portability, efficiency, maintainability, reliability and security. It will be tested by an IT expert during the Alpha testing. The system was tested by the Iyamu Enterprises staff, admin and dealers during the Beta testing.
Meanwhile the corresponding score given by the respondents in alpha and beta test are interpreted in a verbal manner with the use of Likert Scale.
The questioner served as basic guide of the evaluation in assessing the Functional Suitability, Performance Efficiency, Reliability, Security, Maintainability, Compatibility, Usability and Portability.
The data that were obtained from this research was treated as statistics. It will analyzed using mathematical equations. The Initial Mean is obtained by adding all the scores gained per question divided by the total number of respondents. The formula for Initial Mean is:
Initial Mean = Total score gained per question____
Total number of respondents
The final mean is obtained by Initial Mean divided by the total number of questions. The formula for Final Mean is:
Final Mean = Initial Mean___________
Total number of questions
Mean:
X = ‘ f x
n
Where:
X = Weighted Mean
f = weight given to each respondent
x= number of respondents
n= total number of respondents
The weighted mean would be used to determine the evaluation of the respondents. Certain degree of evaluation was given and each corresponds to the amount of quality that the answer provides.
In this section all the requirements for the new system are presented from the hardware and software that are needed to develop, implement and maintain the new project.
The online sales and inventory system with credit-line monitoring will be uploaded in the internet, the users of the said system were taught to access it through the internet with the browser Google Chrome. Trainings were conducted for the users for them to operate or work with the system with ease. (See Appendix I for System Architecture of the developed system).
This chapter presents the development of the prototype, and analysis and presentation of data gathered from the Alpha and Beta tests.
For the completion of the system, the researchers used alpha and beta tests. In alpha test, five (5) respondents were asked to evaluate the system; all of them attained college education degree; Mary Ann F. Quioc a Master of Science in Information Technology, Mark M. Cruz a Master of Information Technology, Harold Ian Navarro a computer Laboratory Assistant,Edmin a Web Developer and Kevin Villanueva a Cloudstaff Senior Application Developer. The five respondents were selected based on their experience in the field of Information of Communication and Technology (ICT).
In beta testing, the IyamuEnteprises (2) Admin; Marietta Maniti and Fernando Maniti, (4) Staff; Charlene Toca, Kimberly Manusig, MerlitaDela Cruz, EukinaSalunga and 20% of the Dealers of Iyamu Enterprises.
The system was tested based on eight (8) categories; Functional Suitability, Performance Efficiency, Compatibility, Usability, Reliability, Security, Maintainability and Portability.
Shown in Table 3, the five respondents of alpha test rated the system’s compatibility as very great extent which had the highest rating. The system’s performance efficiency, security and portability were also rated as very great extent. The system’s functional suitability weighed mean got 2.73 which have verbal description great extents, usability weighed mean got 2.60 which have a verbal description great extent, and reliability weighed mean got 2.30 which have a verbal description great extent. They also rated the system as great extent because the system ensures validity of inputs, processes and outputs, and it also provides accurate result in every transaction.
The maintainability of the system was rated 1.80 which has the lowest rating which have a verbal description moderate because the system is not totally operational or efficient.
Shown in Table 4, the beta test rated the system’s functional suitability weighed mean got 3.88 which had the verbal description to very great extent and had the highes”t rating because of the execution of the system but in alpha test compatibility is the highest rating.
The system’s performance efficiency weighed mean got 3.72 which had the verbal description to very great extent.
The system’s compatibility weighed mean got 3.66 which had the verbal description to very great extent.
The system’s usability weighed mean got 3.75 which had the verbal description to very great extent.
The system’s reliability weighed mean got 3.62 which had the verbal description to very great extent.
The system’s security weighed mean got 3.81 also rated as a very great extent.
The maintainability of the system was rated 3.52 which has the lowest rating same as alpha test which have a verbal description moderate but in beta is very great extent, because the system is not totally operational or efficient and the system’s portability weighed mean got 3.70 which had the verbal description to very great extent
Shown in Table 5, is the comparison of the two tests conducted for the system. In terms of functional suitability of the system the rate is great extent in alpha test, very great extent in beta test.
The alpha testing got a lower result because the five (5) IT respondents encountered some problems including the functions and bug of the system. The beta testing got a higher result of evaluation because all the recommendation from alpha testing has been improved and accomplished.
The summary of alpha and beta testing for the criteria of ISO 25010 the functional suitability weighed mean got 2.73 which had the verbal description of great extent for alpha testing result because the respondents detect some errors in confidential information and
for the beta test weighed mean got 3.88 which had the verbal description of very great extent because the system has improved the confidential securities of the system.
The performance efficiency weighed mean got 3.20 which had the verbal description of very great extent for alpha testing result because some of navigation button did not worked and for the beta test weighed mean got 3.72 which had the verbal description of very great extent because the system improve in time consumed in finishing transaction.
The compatibility weighed mean got 3.60 which had the verbal description of very great extent for alpha testing result because the system encountered problems with other application and for the beta test weighed mean got 3.66 which had the verbal description of very great extent because the system can interact well with other system without causing problem with other systems running.
The usability weighed mean got 2.60 which had the verbal description of great extent for alpha testing result because the system did not met the usefulness of the system to the intended locale and users and for beta test weighed mean got 3.75which had the verbal description of very great extent because the system in improve and it easy to use.
The reliability weighed mean got 2.60which had the verbal description of great extent for alpha testing result because some of case of interruption or failure and beta test weighed mean got 3.62 which had the verbal description of very great extent because the system works well.
The security weighed mean got 3.24 which had the verbal description of very great extents for alpha testing result while beta test weighed mean got 3.81 which had the verbal description of very great extent because the system has improved the securities.
The maintainability weighed mean got 1.80 which had the verbal description of moderate for alpha testing result because some users don’t understand how the system works and for beta test weighed mean got 3.52 which had the verbal description of very great extent because it improve and easy to understand in how the system works.
The portability weighed mean got 3.26 which had the verbal description of very great extent for alpha testing result because the interface is not appropriate users and for the beta test weighed mean got 3.69 which had the verbal description of very great extent because the interface us appropriate users.
It summarizes the main conclusions of the project and their significance with a list of specific conclusion. Recommendations are specified to be taken in association with the conclusion.
Based on the objectives of the study, completed analysis, testing and evaluation of the system on the previous chapters, the proponents came up with the following conclusions:
The system an online Sales and Inventory system with Credit-line monitoring for Iyamu Enterprises was designed in accordance to the locales specification and performs all functions written on the objectives of the study.
The proponents were able to integrate software technologies and tools such as HTML5, Adobe Photoshop CS6, SMS Gateway Me, Bootstrap v.4, XAMPP v3. 2. 2, Semantic UI and Code Igniter in developing the system.
The system has been successfully uploaded in the web host and it can be access anytime as long as the user has an internet connection. It can run in different browser such as Microsoft Edge, Google Chrome, Torch, Firefox etc.
The study underwent in alpha and beta testing, the alpha testing was administered by five (5) IT Experts and the beta testing was administered by twenty five (25) Individuals coming from the locale. The result of alpha testing for the system which conducted outside the locale got a rating of Great Extent, which means the system has a minimal error that the proponents corrected before proceeding to the beta testing. The result of the beta testing for the system which was conducted inside the locale got a rating of Very Great Extent.
The following recommendations are offered to the future researchers as possible way to improve the system.
‘ It is recommended to add a Barcode scanner in processing the products, Using barcode scanner eliminate the possibility of human error.
‘ It is recommended to improve the availability of the system to Android and IOS devices as an application for faster loading and less use of data.
‘ It is recommended to find alternative gateway for the SMS technology to improve the speed of the SMS notification.