Sad.sumagka

ACLC COLLEGE TAGUIG FTI Complex, Taguig City COLLEGE OF COMPUTER STUDIES

POINT-OF-SALE WITH INVENTORY SYSTEM FOR MABOLO FLOWER SHOP

In Partial Fulfillment of the Subject in System Analysis and Design for the Degree Of Bachelor of Science In Information Technology

Submitted by: Candelario, Francis D. Ebrahim, Al-amin T. Oberes, John Pete R. Opiña, John Rhey C. Sumagka, Allen A. Ubang, Alvin C.

September 5, 2017


Table of Contents I.

Chapter 1: The Problem and Its Background 1.1 Introduction……………………………………………………….... 1.2 Background of the Study…………….…………………………… 1.3 Purpose and Description…………….…………………………… 1.4 Conceptual Framework…………………………………………… 1.5 Statement of the Problem………………………………………… 1.5.1 General Problems…………………………......... 1.5.2 Specific Problems…………………………......... 1.6 Objectives of the Study……………….………………………….. 1.6.1General Objectives……………………………… 1.6.2 Specific Objectives……………………………… 1.7 Scope and Limitations of the Study……………………………... 1.7.1 Scope of the Study……………………………. 1.7.2 Delimitation of the Study…………………….. 1.8 Significance of the Study……………..…………………………. 1.9 Definition of Terms…………....………………………………....

II.

Chapter 2: Review of Related Literature 2.1 Foreign Related Literature…………..…………………………. 2.2 Local Related Literature……………...…………………………. 2.3 Foreign Related Studies……………..…………………………. 2.4 Local Related Studies………..………………………………….


III.

Chapter 3: Methodology and Technical Background 3.1 Data Gathering Procedures……………………………………. 3.2 System Methodology………………………………………….. 3.2.1 Project Development Method………………………. 3.2.2 Diagramming Scheme……………………………….. 3.2.2.1 System Flowchart…………………………… 3.2.2.2 Data Dictionary……………………………… 3.2.2.3 DFD (Data Flow Diagram) ……………….. 3.2.2.4 ERD (Entity Relationship Diagram)……… 3.3 Statistical Treatment…………………………………………… 3.4 System Requirements…………………………………………. 3.4.1 Hardware……………………………………………… 3.4.2 Software……………………………………………… 3.5 Cost Benefit Analysis…………………………………………

IV.

Chapter 4 : Presentation, Analysis, and Interpretation of Data 4.1 Respondent of the Study……………………………………… 4.2 Software Presentation…………………………………………. 4.3Analysis and Interpretation of data…………………………….


V.

Chapter 5 : Summary of Findings, Conclusion and Recommendation 5.1 Summary……………………....………………………………… 5.2 Conclusion ……………………………………………………… 5.3 Recommendation…………….…………………………………

Appendices Appendix A: Letter of Project Proposal Appendix B: Letter for Conducting Interview Appendix C: Interview Questionnaire Appendix D: Gantt Chart Appendix E: User’s Manual with Software Appendix F: System Prototype Appendix G: Program Codes Appendix H: Survey Tool Appendix I: Evaluation Tool Appendix J: Representations of Actual Development Appendix K: Resource Persons List of Figures List of Tables Bibliography


Chapter 1 THE PROBLEM AND ITS BACKGROUND 1.1 Introduction

In the world of business, sales and inventory report has one of the biggest roles in the field of business industry. Recording data from past to present will calculate every statement and will help in monitoring the status of the business. Manual data recording of sales and inventory data are now a thing of the past. Indeed, the world is now inconceivable without computers. Billions of important data can now be stored and handily retrieved because of the database technologies that exist today. Precious time should be in properly managed in order to do all the things that the company or business has. Monitoring and managing the sales and inventory is a hard task for the manager or the owner.

As the world moves further and faster into a thriving technological age, so must the way we conduct our business. The Point-Of-Sale (POS) has been created by IT professionals to make the system of the business easy to manage. It calculates the sales for the day. And, Inventory System programs now on the market lets you track the usage, monitor changes in unit costs, calculate it when you need to reorder, and analyze inventory levels in item-by-item basis. It can even view stocks in the inventory right at the cash register with point-of-sale (POS) systems. Point-of-Sale System records each sale when it happens, and the inventory records are updated automatically.

Commented [J1]: Rephrase your sentence


1.2 Background of the Study The company Mabolo Flower Shop is a small flower shop that is managed by one person, the owner. The business sells different items or products like a typical flowers that we can see everywhere. The business can’t view their proper records of sales or income in a given time. It also doesn’t have its proper listings of product. In some instances, lost items are just being ignored by the owner. Our project title is “Point-of-Sale with Inventory system for Mabolo Flower shop”. By using our system, users can analyze inventory records, and figure it out how well all the items in the shop sell. Also, they can maintain and review sales histories easily. We used Microsoft Visual Basic 2010 and MySQL Management Studio 2008 R2. Using My SQL Server 2008 R2 as the main storage of the company`s inventory and sales report will cause problems such as data redundancy, data lost and data integrity because admin can easily access the company`s master list.

Commented [J2]: Explain clearly this section


1.3 Purpose and Description The researchers hoped that the findings of this study will be beneficial to the Mabolo flower shop. This study will serves as a valuable reference to the better development of Business IT System on various managing techniques and services for businesses. The reason behind we proposed the Point-of-sale with Inventory system is because of the problems facing by the shop in managing the inventory and transactions, the researcher decided to build a system which is sales with inventory system to help the owner and staffs of the shop to manage the inventory efficiently and record the transactions and sales of the shop.


Commented [J3]: Please used precise procedures

1.4 Conceptual Framework

Existing process

INPUT

PROCESS

Manually collecting Customer Order

of order Information and computation of

OUTPUT

Issuance of official receipt to customer.

stocks

Proposed system

INPUT

Sales Order Details

PROCESS

Accurate and integrated Computerized Client System

OUTPUT

Point of Sale With Inventory System


1.5 Statement of the problem The staff of Mabolo Flower Shop are having difficulties in keeping their transactions and inventory records.

1.5.1 General Problem How to develop a system that can process and manage the daily transaction in an efficient and reliable way.

1.5.2 Specific Problems ● How to develop a system that will update the inventory from time to time and will record the transactions of the shop by incorporating point of sales. ● How to enhance accuracy and security for data redundancy and data lost. ● How to implement a module that will generate a sales report and stocks report. ● How to provide an organize records of the shop.


1.6 Objectives of the Study This study aims to develop and assist the staffs of Mabolo Flower Shop in the monitoring of stocks and can generate daily sales in their shop.

1.6.1 General Objective To develop a system that can process and manage the daily transaction in an efficient and reliable way.

1.6.2 Specific Objectives ● To develop a system that will update the inventory from time to time and will record the transactions of the shop by incorporating point of sales. ● To enhance accuracy and security for data redundancy and data lost. ● To implement a module that will generate a sales report and stocks report. ● To provide an organize records of the shop. Commented [J4]: Complete all the statement


1.7 Scope and Delimitations of the Study 1.7.1 Scope The study primarily aimed to design a Point of Sale with Inventory System for Mabolo Flower Shop. The system focuses on the business processes which includes; Point-of-Sale, automatic computing of sales for the day and Inventory report.



The admin can add, update, delete and search items.



The admin can add stocks to a particular item



The admin can view and search for the daily, monthly and yearly

transactions of the shop. 

The admin can add, update, delete and search accounts.



The admin can generate reports for list of items and the daily, monthly and

annually transactions 

The system has a security feature where users have to log in first before

using the system. 

The system saves all the changes made in products menu, account menu.

The system also records the users that use the system. 

The system has a capability to back up the database.

 The admin can be able to view and search for the daily, monthly and annually of most sold items of the shop.




The system has a point of sale for performing smooth and accurate

transaction.  It can create new sale or discard one, computes total purchase, cash receive and change, and the system can only accept cash payments. Sales are then logged on the Sales report for the employee so he/she can monitor his/her transactions made.  All products have Item Name and Item Code so searching is more efficient.

1.7.2 Delimitations 

The proposed system does not use hardware devices like barcode scanner.



Limits the payment transactions into cash.



Does not accept credit card, debit card and cheques as payment.



Its features is limited only to a LAN (Local Area Network) meaning it cannot be deployed over the internet.



Does not include the expiration date of the items.



The system can’t be use during brown outs.



Lastly returning and exchanging of sold item/s when customer made an error of purchasing an item is not supported by the system.


1.8 Significance of the study This study will be valuable and significant to users, company, costumers, and researchers.

For the Users Our proposed system will enable the user to work more efficiently and conveniently because gathering of inventory data and in sales transactions will be automated. For the Company Our proposed system will improve the Mabolo flower shop Inventory management of files and records will be automated, reducing the risk of lost files/records because of their current way of manually storing them.

For the Costumers Transactions will be done faster than the usual process because the gathering and inventory of the product records will be automated.

For the Researchers The system would benefit for the present and future researchers. By means if this study. They would have an idea on how to conduct their own study. The study could be a source of information and would be the foundation of a new and improve system. Since the industries are now research based.


1.8 Definition of Terms Accuracy – the ability to work or perform without making mistakes. Admin – manages the adding of stocks, updating the inventory, and determining the users of the system. Conceptual Framework - is an analytical tool with several variations and contexts. It is used to make conceptual distinctions and organize ideas. Strong conceptual frameworks capture something real and do this in a way that is easy to remember and apply. Delimitation - are choices made by the researcher which should be mentioned. They describe the boundaries that you have set for the study. Inventory - a complete list of the things that are in a place. Inventory System - Inventory systems are tracking systems that inform you of the amount of raw materials, supplies or final products you have readily available. The inventory system is updated each time you sell an item or use raw materials to create a product, so you know what you have available for the following day or week. This type of system also allows you to order products in advance, so you have everything you need at all times. Mircrosoft Visual Basic 2010 - is an integrated development environment (IDE) from Microsoft. It is used to develop computer programs for Microsoft Windows, as well as web sites, web apps, web services and mobile apps.

Commented [J5]: Should be in alphabetical order and use all the technical term mention in your documentation


My SQL Server 2008 R2 - To get to the kernel (pun intended) of the issue, R2 in Windows Server

2008

means

“Release

2,”

and

the

primary

reason

why Microsoft uses the R2 nomenclature as opposed to revising the major product version is as follows: R2 releases do not require administrators to purchase upgrade client access licenses (CALs). Order – a product/s that someone has requested from a business. Receipt. Summary of the sale, it includes the product, quantity, total price, money rendered, change customer name and the sales ID. Redundancy - the use of words or data that could be omitted without loss of meaning or function; repetition or superfluity of information. Reports – an official document that gives information about a particular subject. Point of Sale - A retail point of sale system typically includes a cash register (which in recent times comprises a computer, monitor, cash drawer, receipt printer, customer display and a barcode scanner) and the majority of retail POS systems also include a debit/credit card reader. Sales – The activity or business of selling products or services. Security – the state of being protected or safe from harm. Stocks – the supply of goods available for sale in a store.


Chapter II REVIEW OF RELATED LITERATURE This chapter presents the literature and studies relevant to presentation investigation 2.1

Foreign Related Literature As defined by Carolina Barcode Inc., a Point-of-Sale system is a computer

software and hardware networked together to track sales and inventory as they occur. Point-of-Sale systems will solve a multitude of problems in your business. It is one of the focal points of any retail or hospitality business in the cash register. The ability to process transactions and tender cash are essential to the efficient operation of the enterprise. If you have a lot of cash transactions, replacing the cash registers with a Point-Of-Sale (POS) system save you money (2013). The researchers propose system that has the functionality of a POS and the ability to manage your stocks by an Inventory System. Carolina Barcode Inc. stated of the having a Point-of-Sale with Inventory system can give you the ability to transact multiple transactions in cash registers and automatically updated in inventory stocks. The researchers develop a system that that is efficient in the operation enterprise. Link: https://www.carolinabarcode.com/run-my-store-a-36.html

Commented [J6]: Use topic and article related to POS and Inventory System Do not use articles and topics that only define the two.


As stated in the book entitled Introduction to Information System by Ralph Stair and George Reynolds. Purchasing Systems is the traditional Transaction processing system that supports the purchasing business function including inventory control, purchase and order processing. This integrated set of systems enables an organization to plan, manage, track and pay for its purchases of raw materials parts and services. The researchers propose a system that will process fast automated transactions and create reliable sales report of every day, and month automatically on a day to day basis. The researchers develop a system that creates transaction report or log that will help on tracking transactions when needed. Link: http://site.iugaza.edu.ps/kdahleez/files/2014/09/stair78292_0538478292_02.01_ chapter01.pdf According to the U.S. Small Business Administration, “Inventory refers to stocks of anything necessary to do business” (U.S. Small Business Administration, 2010) The U.S. Small Business Administration publication describes what constitutes successful inventory management balancing cost versus benefits of inventory, including Maintaining a wide assortment without spreading the rapidly moving items too thin, Increasing inventory turnover without sacrificing service, Keeping stock low without sacrificing performance, Obtaining lower prices by


making volume purchases, Maintaining an adequate inventory without an excess of obsolete items. The researchers propose a system that will create accurate and informative sales and inventory reports pointing out to the products that needs stock and the products that needs to lower stocks. Link: https://www.sba.gov/sites/default/files/files/SBA%20Program%20Inventory.pdf

2.2

Local Related Literature According to Gemma Navarro (2012) Computer is general purpose device

which can be programmed to carry out a finite set arithmetic or local operation. Computer has a big rule in our nation today because of our technology. Wherever you go computer still exist, especially in business it makes the procedure easy and secure by programming the manual system into a computerizing system. The rule of technology in our life today has a big impact. The researchers propose a system that has features and functions based on their current manual based process. The researchers develop a Point-of-sale with inventory system that you are counting your products then reconcile it with your sale while when you use the computerized system you can save more time because it is automatically count and total the remaining


item and the items that was already both and sold. By using a computerized inventory system, a business owner can ensures that all orders, reports and other documents relating to inventory are uniform in their presentation regardless of who has created them. Link: https://www.scribd.com/document/322616561/POS-andINVENTORY-SYSTEM

In this study conducted by Ariel Magat, he stated that the Inventory System of the vital to any institution, agency, or department. The proper safekeeping, processing and disposal of records play important roles in the efficient, effective and smooth operation that eventually would lead to the success attainment of the goal and objectives of institution, agency and department concerned. Based on her recommendation there should be a central record management office that will hold data of the agency to serve as locator of the record and to control the disposal of each record. This can be possible through the use of computerized system. Computer with the appropriate software package is capable of handling records efficiently and effectively. And locating records that are computerized is faster than finding them in the filling cabinet. The researchers propose a secure and reliable inventory system storing consistent data and only showing it to the people who has access

to

it.


Link: http://www.academia.edu/27515183/Procurement_Inventory_and_Supply_Mo nitoring_System

In the study from Averion, Gaela, and Libo (2009) it stated that inventory system help to minimize the difficulty of the manager in processing inventory because physical counting products, stocks and computing inventory summary will be the system job. It will monitor the availability of products, items to prevent under stocking, over stocking and running out of stocks. The system will also simplify the transaction between dealer and supplier relationship because of the updated supplier information and price list of items will correspond to collaboration with other supplier. The researchers propose a system similar to the article that automatically counts the current inventory when needed faster and efficient. Link: essay

https://blablawriting.com/inventory-system-for-best-choice-rice-dealer-


2.3

Foreign Related Studies According to the thesis of Carlo Magno. There was a ground swell to

move from paper signature and documents because the task of record management was huge. We had file cabinets full of backup materials. By converting from manual process, we would be able to eliminate a lot of paper. We could go further with the automation of manual process and remove manual paperwork if people trusted the technology. The researchers propose a system that can manage multiple transactions and reports of transactions and inventory details but in minimum use of paper. Link: https://books.google.com.ph/books?id=0Lu1CrN9h9MC&pg=PA227&lpg=PA227& dq=according+to+carlo+magno&source=bl&ots=ij6AofO1AN&sig=F1vJaTqZ4q7C wgH1scqJagk_fao&hl=en&sa=X&ved=0ahUKEwi4seu0k4fWAhVHQI8KHSX0DdI Q6AEIJDAA#v=onepage&q=carlo%20magno&f=false

According to Mike Toland “We need a better tracking system than excel spreadsheets and paper”. Paper is too cumbersome and also too limiting, you’ll never know how to specify all the information that you need. The researchers propose a system that can store data securely by the use of a local database on the locales computer. Link: http://uknowledge.uky.edu/cgi/viewcontent.cgi?article=1009&context=edsc_etds


Inventory System By: Wal-Mart Wal-Mart runs its stores on a perpetual inventory system. This system records the quantity of items sold as items are purchased. The computer system at Wal-Mart constantly keeps up with additions or deductions from inventory and tells management what items are on hand. The organization also conducts counts of employee manual counts of inventory periodically. When an item arrives at the Wal-Mart distribution center it is scanned into the inventory system. When the items are purchased by the consumer, the point-of-sale system reduces the inventory from that purchase. According to Wal-Mart’s Gail Lavielle, a leaner inventory will help clear out store clutter and help Wal-Mart focus on specific brands and products that consumers want. The researchers propose a system that generates report that are manageable trough fast searching of records of the proposed system. So that the admin can easily check the status of the stocks of every item in the stocks. Link: http://panmore.com/walmart-inventory-management


2.4 Local Related Studies A study conducted by Mr. Gragasin(2010) et,al. Entitled “A customized Point of Sale and Inventory System for Anespee Enterprise Hardware Carangian” concluded that the implementation of the Developed system increases the business efficiency and effectively in terms of every transaction that they have. Managing the records such as employee, customer, suppliers and transaction is faster and easier than using the manual paper based system. The researchers propose a customized system that would likely be adapted by the locale to speed up its processes and increase the efficiency of the business. Link: https://www.omicsonline.org/speaker/Michael_A_Gragasin_Philippine_Center_F or_Postharvest_Development_And_Mechanization_br_Philippines_Food_Techn ology2014/

According to J.De Leon and M. Ferrer (2009) Under the Koread RedGinseng Enterprise Sales and Inventory System, the researchers came up with acomputerized sales and inventory system. The proponents used database toeasy access of files and for easier and faster processing of the selling andinventory transaction. The program was designated to generate reports such asmonthly reports, inventory reports, sales invoice and list of items.


The researchers propose a system that can store data securely by the use of a local database on the locales computer. Link: https://studymoose.com/sales-and-inventory-monitoring-system-essay

Based on the research entitled “Computerized Sales and Inventory system for Ronmon Trading” (de Alday, Espino, Ragudo) 2010, the replacement of the manual system with the proposed system provided more efficient and accurate processing of transaction. The said system is much reliable, eliminated errors and inaccurate information, and provided valuable reports with integrity. The researchers propose a system that generates report that are manageable through fast searching of records of the proposed system. Link: http://rumbopolitico.info/index.php/component/k2/itemlist/user/19794%22%3ERevi ew


Chapter III RESEARCHS METHODS AND PROCEDURES 3.1 Data Gathering procedures This chapter deals with methods of research used by the researchers in order to come up with a solution. The research methodology, data gathering tools and process flow diagrams was elaborated in this chapter.

Type of Research Research and Development The software development methodology is a framework used to structure, plan, and control the process of developing the System for Mabolo Flower shop. METHODS OF RESEARCH The researchers considered the following methods to develop a meaningful and productive output. Internet Method. The developers researched on various websites to gather data relevant to the study. The extensive browsing of the internet provided vital references, studies, articles and application which are related with the study conducted.

Commented [J7]: Explain it clearly


Library. The developers also researched on published reference and unpublished materials such as thesis and dissertations from the library. The school library provided relevant information and literature used in the study. Research Studies and Thesis. The researchers synthesized the materials, references and knowledge acquired from the research conducted which became the basis in the conceptualization, designing and actualization. Survey questionnaire. The questionnaire was created using suitable questions modified from the related research and individual questions formed by the researchers. The questionnaire was compromised of questions, which were related to the background of the company. The researchers conduct an interview to the owner of the store related in transaction of customer to the cashier and the transaction done by the owner. The researchers also understood the problems of the Mabolo flower shop encounter especially in the inventory of all products and sales reports due to manual process of the store.


3.2 System Methodology Systems methodology is an approach to organizational process modeling (business process modeling) and it can be used both for general problem solving and in the management of change.

3.2.1 Project Development Method

.

Figure 2. Systems Development Life Cycle (SDLC)


The Systems Development Life Cycle (SDLC), this framework provides system designer and developers to follow a sequence of activities. It consists of a set of steps or phases in which each phase of the SDLC uses the result of the previous one to create the whole system. With a SDLC model, programs built will have a clear documentation, structure and even in coding. SDLC model will have the proper documentation of every step and every part of the program.

Planning.

At the first stage of planning the session, the researchers have

undergone a brainstorming session to identify the target locale and discussed the needs and arising problem within. The researchers discovered that the Mabolo Flower shop is still using manual based process in making a sale and managing their inventory. The researchers listed down the problems that the locale encountered and discussed them with the locale.

Analysis. In this phase includes a thorough and detailed understanding of the current system, the researcher identifies the problem that need modification to solve the problem. The problems of the shop are the inefficiency in managing the inventory and no records of sales transactions. That is why the researchers develop a point-of-sale with inventory system to monitor and organized the inventory of the shop.

Commented [J8]: Please define it in your own words


Design. In this phase the design is the structure or the architectural design for the proposed system being carried out from the requirements define by the client. The researcher designed the system by the demands of the client.

Implementation. In this phase the objectives and the requirements of the proposed system are being developed. The coding and testing of the system in this phase. The implementation is the system of the design based on the requirements. Point-of-sale with inventory system will be install by the developer. The developer also give a manual to the owner on how the system works and how to use it. The developer also teaches and demonstrates to the owner on how to use the system.

Maintenance. In this phase the maintaining the system is an important aspect of SDLC. As key personnel change positions in the organization, new changes will be implemented, which will require system updates. The developer is willing to develop and enhance the system for improvements. If the user found an error or bugs, the owner can contact the developer. The developer will usually come to shop to check the system.


3.2.2 Diagramming Scheme 3.2.2.1 System Flowchart System flowcharts are a way of displaying how data flows in a system and how decisions are made to control events. To illustrate this, symbols are used. They are connected together to show what happens to data and where it goes. The basic ones include: Symbols used in flow charts. EXISTING PROCESS FLOWCHART START

INVENTORY

SALES

CUSTOMER ORDER

RECEIVING STOCKS W/ A RECEIPT

PAYMENT NO RECORDING OF STOCKS RECEIVED

RECEIPT

END


PROPOSED SYSTEM FLOWCHART ADMIN START DISPLAY ERROR ADMIN LOGIN

FALSE

TRUE

DISPLAY STOCKS

MANAGE ACCOUNT

TRANSACTIONS DETAILS

SALES REPORTS

PRINT SALES REPORT

ADD/UPDATE DELETE/SEARCH ITEMS

ADD/DELETE AND UPDATE USER

PRINT STOCKS REPORT

DATABASE

END


CASHIER

START DISPLAY ERROR

FALSE

CASHIER LOGIN

TRUE CUSTOMER ORDER DISPLAY INSUFFICIENT

FALSE

PRODUCT CONFIRMATION TRUE SALES ORDER

COMPLETED ORDER

PRINT RECEIPT

END


3.2.2.2 Data Dictionary Users Table Field name user_id

Data type

Data length

int

Constraint Not null

Description User ID, auto generated

first_name

nvarchar

50

Not null

First name of user

middle_name

nvarchar

50

Allow nulls

Middle

name

of user last_name

nvarchar

50

Not null

Last name of user

email

nvarchar

50

Not null

Any email ID

user_name

nvarchar

50

Not null

Login username for user

pass_word

nvarchar

50

Not null

Login password user

for


Sales Table Field name

Data type

sale_id

int

product_name

nvarchar

product_Type

nvarchar

Data length

Constraint

Description

Not null

Sale ID

50

Not null

Product name

50

Not null

Product category

sale_date

nvarchar

sale_quantity

int

50

Not null

Date of sale

Not null

Quantity

of

product sale_price

decimal

10,2

Not null

Price of the product

total_Sale_Price

decimal

10,2

Not null

Total price of the order

sale_user

nvarchar

50

Not null

User sale


Product Table Field name product_id

Data Type

Data length

int

Constraint Not Null

Description ID

of

the

product product_name

nvarchar

50

Not Null

Name of the product

product_type

nvarchar

50

Not Null

Type

of

the

product description

nvarchar

Max

Allow Nulls

Description of the product

price

decimal

10,2

Allow Nulls

Price

of

the

product quantity

int

Not Null

Quantity of the product

picture

varbinary

Max

Not Null

Picture of the product


3.2.2.3 DFD (Data Flow Diagram) =

Customer

Customer Order

POS w/ Inventory System

Cashier

Product Confirmation

Input Data

Check Status

Products Inventory Order

Inventory Repair

Order Inventory

Supplier

Inventory Order

Inventory Generate Report

Billing Process

Issuance of Receipts

Issue Receipts

Admin Inventory Details


Commented [J9]: This section indicate the relationship between objects

3.2.2.4 ERD (Entity Relationship Diagram)

Product ID Product Name Type Description Quantity Price Picture Transaction details ID User ID Product

User ID User First Name Middle Name Last Name Email Username Password

Order ID Sales Name Type Date Quantity Price Total Price Sale User


3.3 Statistical Treatment The statistical treatment is essential in order to make use of data in right form and it is only one aspect of any projects. FORMULA Weighted mean an aggregated mean for more than one step of scores calculated to give weight to each sets separated mean according to sample size. Wm = [(E*5) + (VS*4) + (S*3) + (F*2) + (P*1)] N

Where: Wm = Weighted mean N = Total number of respondents E = Total number of respondents who marked Efficiency VS = Total number of respondents who marked Very Satisfactory S = Total number of respondents who marked Satisfactory F = Total number of respondents who marked Fair P = Total number of respondents who marked Poor

3.4 System Requirements


3.4.1 Hardware Hardware specification HARDWARE

DESCRIPTION

Laptop/Desktop

Intel I3 core processor 2.7 GHz and higher

Hard Disk Drive

Minimum of 1gb hard disk space to store

the

software

required to

be

installation used

in

of the

development of the proposed system Random Access Memory (RAM) Monitor

Memory of 2GB or higher At least 1366x768 or higher


3.4.2 Software Software specification SOFTWARE

DESCRIPTION Windows 7/8

The operating system that will be compatible to support the software that will be in use.

Microsoft Visual Basic 2010

A application builder that will be in used to develop the point of sale and inventory system of the locale

My SQL Server 2008 R2

A DBMS from Microsoft that combines the Microsoft Relational Jet Database Engine with a Graphical User Interface and Software Development Tools.


3.5 Cost Benefit Analysis Cost benefits analysis is the process of comparing the anticipated costs of an information system to the anticipated benefits. Cost benefits analysis is performed throughout the SDLC to determine the economic feasibility of an information system project and to compare alternative solutions. Cost and Benefits COST Utilities

BENEFITS Less consumption of paper cost and other miscellaneous item

Maintenance

Easy to maintain the system

Installation

Friendly – user and accurate to all student and faculty

Personnel

Personnel savings

Equipment

Purchase Improved control


Cost Estimate For 60 days project System Analyst

Php 5,000.00

System Programmer

Php 5,000.00

System Cost

Php 5,000.00

System Hardware Cost

Php 75,500.00

System Software Cost

Php 5,000.00

Training

Php 2,000.00

Installation

Php 2,000.00

Total Cost

Php 99,500

Sad.sumagka

Recommend Documents