POINT OF SALE WITH SALES MONITORING SYSTEM

FOR ED’s KITCHENETTE

A Capstone Project Presented

To the AMA Computer College

In Partial Fulfillment of the Course Requirement for the Degree

Bachelor of Science in Information Technology

By

Rojean Acosta
 APPROVAL SHEET

This research proposal entitled “POINT OF SALE WITH SALES

MONITORING SYSTEM FOR ED’s KITCHENETTE” prepared and submitted by

ROJEAN ACOSTA in partial fulfillment of the course requirements for the degree of

BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY, has been examined and

recommended for acceptance and approval for Oral examination.

Adviser

Approved by the Committee of Oral Examination of <Date> with the grade of ____.

NAME OF EVALUATOR
Chairman

NAME OF EVALUATOR NAME OF EVALUATOR

Member Member

Accepted as partial fulfillment of the course requirement of the degree BACHELOR

OF SCIENCE IN INFORMATION TECHNOLOGY.

NAME OF THE DEAN

Dean, College of Business Administration
Date

2
 ACKNOWLEDGEMENT

First and foremost, we would like to thank the Almighty God, Most High over

all the earth, for teaching, for reproving, for setting things straight, for disciplining in

righteousness,

Our parents, who supported us mentally, physically, and financially while conducting

this paper.

We would like to thank our primary supervisor, Mr. ------------, for his guidance. Their

mentorship and expertise were invaluable in helping us shape the direction of our

research and bring our ideas to fruition.

Finally, we would like to extend our heartfelt thanks to all of the participants in

our study who generously shared their time, experiences, and insights with us. Their

willingness to engage with our research was essential to the success of this project,

and we are deeply grateful for their participation.

Overall, this Capstone project would not have been possible without the

support and contributions of so many people. We are deeply grateful to all of those

who helped make this project a reality, and we hope that our findings will make a

meaningful contribution to the field.

3
 TABLE OF CONTENTS

APPROVAL SHEET 2
ACKNOWLEDGEMENT 3
TABLE OF CONTENTS 4
CHAPTER I: THE PROBLEM AND ITS BACKGROUND

Introduction 6
Statement of the Problem 6
Objective of the study 7
Significance of the Study 7
Scope and Limitation 8
CHAPTER II: REVIEW OF RELATED LITERATURE AND STUDIES 9
Chapter III: RESEARCH DESIGN AND METHODOLOGY
Research Design 13
System Development Life Cycle 14
Data Gathering Procedure 16
Research Instruments 16
Gantt Chart 17
Result and Discussion 17
System Overview 17
Architectural Design 18
Hardware Development Components 18
Software Development Components 18
Hardware Requirement Specifications 19
Software Requirement Specifications 19
Payback Period 21

Conclusion 22

Recommendations 22

References 23

Definition of Terms 24

4
Technical Terms 24

Appendices

Appendix A: Evaluation Instrument 26

Appendix B: System Models 27

Appendix C: User Manual 30

Appendix D: Cost Benefit Analysis 36

5
 Chapter I

INTRODUCTION

In the world of business, there are two ways of managing the transaction

process, the manual method and the computerized method. Using the technology,

transactions made faster than the manual way.

Point of sale system is an advanced technology that is now commonly used in

many businesses. The business started as carenderia from an idea of Mr. Bryan Jay

Soriano’s Parents. Their food business grew, and they thought to expand. In year

2017, they formed the first branch in San Marcelino and second branch in Castillejos

in 2018 for the purpose of serving food that Zambaleňos and everyone love And now

serving varieties of meals. The name of the business is eduardo’s kitchenette located

in Purok 4 Brgy.Sta Maria Castillejos, Zambales.

Eduardo’s Kitchenette is using a manual method of computation and

recording of transaction. Because of this, payment process consumes so much time

and often causes miscalculation. The proposed system handles transactions that

can show the total sales of the payments to the customer. It also shows and

monitor the transactions details.

Statement of the Problem

According to the owner, Mr. Bryan Jay Soriano, the issue concerning the use

of manual operation, that it is time consuming especially in computing the

transactions of payments, and making sales reports. Since data are written

manually, transactions are prone to human errors and that may also slow the

operation of the business.

6
 Some specific problems were also observed:

1. Cannot provide instant total payments of transaction to the customers.

2. Unable to produce sales report in a specific time.

3. Monitoring of sales

Objective of the study

The researchers study the problem to create and develop a system that can

help the Eduardo’s Kitchenette business. Researchers provide a Point of Sale with

Sales Monitoring for Eduardo’s Kitchenette. A Proposed system will generate instant

total of adding up order and income reports.

Specifically, it attempts to:

1. Provide the total payments while adding up orders.

2. Having specific reports of sales in kitchenette.

3. Can handle big transactions.

Significance of the Study

The researchers developed a system that helped the Eduardo’s kitchenette in

business. A Point of Sale system with Sales monitoring that handles big transactions

providing instant total sales of payments. The customers will no longer need to wait

the total payments for their orders.

This study will also beneficial to the following:

To the Beneficiary. It enhanced the process of the transactions of the

kitchenette. The owner will no longer need to compute adding up of the orders

because the proposed system can generate the total payments in just a few click.

The proposed system designed to improve the processes and transactions of

Eduardo’s kitchenette.

7
 To the Researchers. The proposed system enhanced the ideas of the

researchers in developing a system. Researchers gained more knowledge in

designing the UI of the system that will match to the Eduardo’s kitchenette.

To the Future Researchers. The proposed study will serve as a reference

or guide particularly a study related to a Point of sale system, and the propose

system will become basis on writing of researches in the field of Information

Technology.

Scope and Limitation

The scope of the proposed system is to provide and record sales report of

the kitchenette. It also focused mainly in storing data in the database and secured

all the information of the business.

The proposed system can calculate payments such as total amount of daily

income. All of the encoded data are stored in database. The beneficiary has the right

to archive, add, update, view and print specific report. The admin is also able to

change the username and password for security purposes.

The certain limitation of the proposed system is not an online based system

but a web-based type of system. Where the proposed system can be accessed

through the use of web-browser by the cashier and the admin.

8
 Chapter II

REVIEW OF RELATED LITERATURE AND STUDIES

This chapter shows the related to the study. It presents facts and ideas from

literatures like books, journals, and electronic sources. It also provides brief

discussion about related studies from local and foreign studies.

As Defined by Khut Kho titled A Proposed Study of Point of Sale and

Inventory Sale with Online Ordering and Bar Code Scanner for Philcom, Point of Sale

(POS) is an electronic system designed to help business maintain and analyze and

transaction data on a continuous basis, but POS refers to the place where

transaction occurs in exchange for goods and serves.

According to Sandstrum entitled A More Profitable Way to Price Annuals

Today’s Garden Center, Mobility and Information obtained from POS improves

marketing by helping salespersons make better judgments and ultimately practice

smarter selling. Data a report highlight specific needs and eliminate guessing and

biases that employees develop throughout the course of their work.

As stated by Casison Retail Technology Update 2013. Gifts & Decorative

Accessories, Further research shows that a POS system streamlines the process of

entering inventory into a computer upon completion of sales, thereby allowing for

expedited inventory management for companies still doing this counting manually.

According to Kentwatak named Computerized Sales and Invertory System for

Anthony’s General Merchandise and Construction Supply, Computerized Sales and

Inventory System is a product of human knowledge with a use of technology so why

not use an advantage and benefit ourselves. This system aims to lighten works and

solve the problems involving strict and complex recording and calculations.

9
 As Stated by Lori Fairbanks The Best POS System Of 2019, The mobility and

customer experience are hot topics in the point-of-sales market. The industry

continues to move to cloud-based POS systems that run on tablets and allow

merchants to bring the checkout to the customer, either on the sales floor of retail

stores or tableside at restaurants, eliminating the frustration retail customers feel

when waiting in line and the anxiety diners experience when their credit cards are

out of sight.

According to Bob Frazier titled Restaurant POS 3-Step Purchase Process, The

selection of a Restaurant POS system is critical to the restaurant's operation and is a

major investment that the restaurant's management and staff must live with for

many years. The selection and purchase of a restaurant POS system that is perfect

for your restaurant is a huge undertaking. The restaurant's management and staff

will work with the restaurant POS system every day and will have to live with it for

many years. The right restaurant POS system decision will pay for itself in a matter

of months.

According to Ritesh Mehta entitled The Point of Sale Application System of

Retail Industries all Over the World, For any retailer, anywhere in the world, a POS,

or 8 a Point of Sale System is a central component of the business. It’s the hub

where everything merges. Moreover, it’s the place wherein a customer executes the

payment for services or goods bought from a company. The retail industry these

days is facing huge competition from new digital channels, such as mobile

commerce, electronic commerce and social media. Customers nowadays are well

informed, tech savvy and demands better and faster services. The new dynamics

has imposed big challenges to the industry when it comes to customer service and

10
operations and supply chain as well.

According to Evan Schuman titled The Best Point-of-Sale (POS) System of

2018, POS system should be able to clock employees in and out, and offer different

levels of security depending on employees' status. A cashier won't have access to

the same back-office functions that manager has. POS systems are not just about

taking payments; they also let you track your customers, and employees. As you

make sales, the system should be able to track what has been sold how many items

still remain. POS feature need to have the ability to provide analytics, to see what

products sell.

According to Nathan Tienzo Easy POS Solution Inc. various login profiles allow

for certain levels of access to utilities, maintenance and reports. Serving staff can be

restricted to only placing orders, access to cash register, managers to reports and an

administrator complete access to amend, add and delete items.

According to Scott Gerber entitled Cha-Ching: 10 Point-of-Sale Systems That

Do More Than Just Smell, If you're in retail, you're counting on your POS system for

a smooth, reliable transaction. Your current system might not be cutting it, you

might want one with extra features, or maybe you're shopping for your first-ever

software. Whatever the case may be, there are endless options. You can now

choose from cloud-based POS systems or stick with traditional hardware.

In Nathan Tienzo stated. On its references the same capability of proposed

system such as the various login profiles allow for certain levels of access to utilities,

maintenance and reports. The managers to reports and an administrator complete

access to amend add and delete items.

As stated in Evan Schuman. The system should be able to clock employees

11
and offer different levels of security depending on employees' status in accordance

to the manager. Our proposed system offers this kind of monitoring capability that

differentiate it from common point of sale systems.

According to Lori Fairbanks. The mobility and customer experience are hot

topics in the point-of-sales market. This only proves that point of sale system is still

relevant to this modern day of age for businesses

As mentioned in Bob Frazier he stated that. Restaurant POS 3-Step Purchase

Process, that there is the selection of a Restaurant POS is critical to the restaurant's

operation and is a major investment that the restaurant's management and staff

must live 10 with for many years. Restaurant is related to the proposed system that

is being created for the beneficiary.

In accordance to Scott Gerber stated. The Cha-Ching: 10 Point of Sale that do

more than just sell article, it shows that there are other types of point of sale that

might be related to the proposed system.

12
 Chapter III

RESEARCH DESIGN AND METHODOLOGY

In this chapter, the researchers discussed the different methods of research for

developing the proposed system. Moreover, the researchers gathered information and

conducted researches for the development of the proposed system.

Research Design

The proposed system is designed, developed, and evaluated to know if the

proposed system meets the criteria of consistency and effectiveness. As mentioned

by Richey, R.C. and Klein, J.D. “Developmental research describes in terms of the

traditional stages of planning, conducting, and reporting a research project problem

definition, literature reviews, and research procedures.”

The researchers developmental research assesses changes over an extended

period of time by looking at the same groups of subjects for months or even years.

Looking at academic and social development that may access and choose a small

sample from each of the low and high income areas also, it employs the systematic

method of designing, 11 developing programs and processes that must meet the

criteria of consistency and effectiveness

Researchers used the waterfall model. It shows the method of development

of the system. The waterfall method involves Requirements Analysis, Design, System

Development, Testing, Implementation, and Maintenance.

13
System Development Life Cycle

Planning Research

Analysis

Design

Coding

Testing

Implementation

Maintenance
Figure 1: Waterfall Model

Figure 1 shows the model and technique used by the researchers as a

method of research. As stated by Morse, P.A. “The waterfall model is a software

development process emphasizes on logical progression of steps is taken throughout

the software development life cycle. It can provide a number of benefits, particularly

for larger projects and organizations that required tough deadlines.”

The researcher used the waterfall model because the progress can be

conclusively identified. It ensures minimum waste of time and effort; it also help

reduces the risk of schedule slippage.

The following discuss the phases involved in the model:

1. Planning and Research. The researcher has decided to conduct and

set interview to the beneficiary. The discussion was used by the

researchers to trace the problem and possible solutions and through

those interviews the researchers were able to determine the main

functions and purpose of the proposed system.

2. Analysis. The researchers were able to come up with the procedure of

14
 the system and it was comprehensively documented The researchers

gathered information for the requirements and specifications and to

create the ideal design based on the gathered requirements

3. Design. In the design phase, the researchers gathered some ideas from

their beneficiary to come up with a better output with regards to the

outcome of the proposed system.

4. Coding. In this phase, the system function was coded by the knowledge

of the researchers to make the proposed system worked. Researchers

used the Visual basic in developing the system where the function of the

proposed system was build and coded.

5. Testing. After coding, the proposed system has tested for the

functionality by the researchers. The test focused on the finished

application.

6. Implementation. The researchers implemented of the proposed system

Point of Sale. The system was installed in the beneficiary’s computer by

the developer’s team.

7. Maintenance. Once the system is implemented, maintenance is

essential to keep premises and the work environment reliable. It is

important that a planned maintenance programmer is in place and that all

maintenance work is risk assessed before beginning the task.

15
Data Gathering Procedure

The researchers gathered the data and information needed in the

development of this study at Eduardo’s Kitchenette

Research Instruments

The researchers used different kinds of instruments to make this study

possible.

The following tools were used for gathering of data:

1. Interview. The researchers conducted an interview with Mr. Bryan Jay

Soriano, the owner, to gather all the information needed for the development

of

2. Analysis. The researchers were able to come up with an interview guide that

aims to tackle how the transactions are done, how they manage and monitor

their sales.

3. Web Research. The researchers used the internet in gathering supportive

and related facts and latest information associated with the proposed system

for the purpose of further understanding.

4. Library Research. The researchers used the library to further gather

information relevant to their research. The library was able to provide

information that helped the researchers to further enhance their

documentation and provide information for their system development

16
Gantt Chart

February March April May

1st 2nd 3rd 4th 1st 2nd 3rd 4th 1st 2nd 3rd 4th 1st 2nd
wk. wk. wk. wk. wk. wk. wk. wk. wk. wk. wk. wk. wk.

Figure 2: Gantt chart

Figure 2 shows the progress made by the researchers during the development

of the system. The researchers provide a planning and research to gathered

data and ideas on the proposed system. The proposed system will also have

some testing and maintenance to make the system reliable and secured.

RESULT AND DISCUSSION

This chapter explains the system requirements namely hardware and

software development components. These system requirements are more

detailed description of the user requirements. They may serve as the basis for

the implementation of the system and should therefore be a complete and

consistent specification of the whole system.

System Overview

The proposed system for Eduardo’s Kitchenette is a point of sale

system that can calculate the total of adding up orders in just a few clicks.

The proposed system is also capable of generating reports.

17
Architectural Design

The architectural design of the proposed system is composed of its hardware

and software components, and the specifications required for the

development of the proposed system.

Hardware Development Components

Table 1 shows the hardware development components of the proposed

system. The hardware that is used to develop the proposed system.

Table 1: Hardware Development Components

Hardware Name Specification Specification

Memory 4GB

Processor Intel core i3-4005U 1.7GHz

Power supply 500 watts 3x220V

Mouse & Keyboard Generic/USB

Monitor Generic PnP Monitor

Software Development Components

Table 1 shows the software development components of the proposed

system. This is the software composed use in developing the proposed system.

Table 2: Software Development Components

Software Name Developer/Manufacturer Description

Microsoft Microsoft Corp. Operating system of the
Windows 10 computer. Allowed the
researcher’s pc to run.
Brackets Adobe System Is a modern text editor that
makes it easy to design in the
browser
XAMPP Web Server A free Apache Friends open source cross-platform web
and server solution stack package
that allowed the researchers to
run the proposed system into
local host.

18
Hardware Requirement Specifications

Table 2 shows the hardware requirement specifications needed to implement

the proposed system to fully perform its specified task. The researchers required a

Random Access Memory with at least 2GB capacity or higher, a hard disk with at

least 250GB or higher, and receipt printer POS compatible.

Table 3: Hardware Requirement Specification

Hardware Name Specification

Memory 4GB or higher of DDR2 or higher

Processor Intel core i3-4005U 1.7GHz or higher

Power supply Minimum of 500 watts 3x220V

Monitor Generic PnP Monitor or higher

Mouse & Keyboard Generic/USB

Software Requirement Specifications

Table 3 shows the software requirements needed to use for the proposed

system. The operating system is for the main program of the computer that controls

and operates the computer and Visual Basic to run the system.

Table 4: Software Requirement Specification

Software Name Description

Microsoft Windows 7 At least windows 7 or higher

Brackets At least version 2010 or higher

Cost Benefit Analysis

Cost Reduction = Existing – Proposed

Benefits = Cost Reduction – Development Cost

This table shows the result of cost benefit analysis between the manual

19
operation and proposed system. It also shows the total cost reduction that of the

beneficiary can benefit once the system is implemented.

Table 5: Result of Cost Benefit Analysis

Manual Proposed Cost Reduction

A. Materials Php 13, 710.00 Php 4,449.00 Php 9,261.00

B. Electricity Php 123,639.54 Php 126, 579.84 Php – 2, 940.30

C. Employee Php 268, 920.00 Php 268, 920.00 Php 0.00

Total Php 415, 208.00 Php 399, 406.00 Php 6, 320.70

Development cost Php 5,000.00

Benefit Php 1,320.7 0

Return on Investment (ROI) Return of Investment = Cumulative Benefits –

Cumulative Cost

ROI = Cumulative Benefits / Cumulative Cost * 100

Year Cumulative Cost Cumulative Benefits Payback ROI

1 Php 5,000.00 Php 1,320.70 Php – 3679.03 26.41%

2 Php 5,000.00 Php 2,614.40 Php – 2385.60 52.28%

3 Php 5,000.00 Php 3,962.10 Php – 1037.90 79.24%

4 Php 5,000.00 Php 5,282.80 Php 282.80 105.65%

Table 6: Payback/Return of Investment

This table shows the payback/return of investment of the beneficiary for

implementing the proposed system.

Payback Period

20
This proposed system will recover its initial investment in 4.71 Years

Payback period = C+ (A) / (B)

= 4 + (- 7,102 / 282.80)

= 4.71 years

C – Years of negative cash flow

A – Amount of negative cash flow

B – Total positive cash flow

21
 CONCLUSION AND RECOMMENDATION

In this chapter, the researchers discuss the conclusion and recommendations

regarding the Proposed System.

Conclusion

This chapter discusses the conclusion and recommendations about the study

and proposed system. Based on the beneficiary specifications, the cost benefit

analysis, the researchers concluded that the proposed system is beneficial to the

kitchenette because it lessens the materials used in manual system like writing

transactions in a record book. The admin will able to monitor the sales income and

make changes to the proposed systems in terms of adding a menu of the

kitchenette. The proposed system can generate instant total of adding up of orders.

Recommendations

The researchers recommend to the beneficiary to use at least the minimum

required software and hardware specifications. To the future researchers, improve

the client interface, add extra catches if vital relying upon the requirements/extra

task or administrations offered by the business. Make the interface more user

friendly. Explore and enhance the usefulness of the system. The beneficiary can also

limit the people who would have access to the system for extra safety efforts so the

intruders could not alter and destroy the system.

22
 REFERENCES

K. Kho, “A Proposed Study of Point of Sale and Inventory System with Online
Ordering and Bar Code Scanner for PhilCom”, July13, 2013. [Online] .
Available:https://prezi.com/z5coy5dcpedo/pos-and-inventory-system/,
[Accessed April 2019].

M. Sandrum, A More Profitable Way To Price Annuals. Today’s Garden Center,

February 2014, 11(2), 12–14.

J. Casison, Retail Technology Update 2013. Gifts & Decorative Accessories, 2013,
114(8), 36.

Kentwatak, “Computerized Sales and Inventory System for Anthony’s General

Merchandise and Construction Supply”, 2013. [Online].

Available:https://capstoneguide.com/lesson/review-of-related-literature-sales-
inventory-systembarcode/, [Accessed April 2019].

5L. Fairbanks, “The Best POS Systems Of 2019”, 2019. [Online].

Available: https://www.business.com/categories/best-pos-systems/, [Accessed

April 2019].

B. Frazier, “Restaurant POS 3-Step Purchase Process”, 2013. [Online].

Available: https://newswire.net/newsroom/pr/00077555-restaurant-pos.html,
[Accessed April 2019].

R. Mehta, “The Point of Sale Application System for Retail Industries all Over the
World”, 2018, [Online].

Available: http://www.ibosocial.com/riteshmehta/pressrelease.aspx?
prid=586672, [Accessed April 2019].

E. Schuman, “The Best Point-of-Sale (POS) Systems of 2018”, 2018, [Online].

Available: https://au.pcmag.com/cloud-services-1/41492/the-best-point-of-
sale-possystems, [Accessed April 2019].

23
 DEFINITION OF TERMS

Operational Terms

Accurate. This refers to data and information that is error-free in all aspects.

Input. This refers to the act of entering data into the computer.

Output. This refers to something, such as power, energy, or information that is

produced by a machine or system.

Manual. This refers to a process not using any device specifically computer.

Proponents. This refers the person who advocates the project.

Proposed System. This refers to a system that is planned and intends to do.

Reports. This refers to an output generated by computer for the sales and

inventory.

Researchers. Is someone who conducts research.

Sales. This refers to the items sold and the overall profit of the business.

User. This refers to a person who uses the system.

Technical Terms

Database. This refers to an organized collection of data.

Computer. This refers to an electronic device designed to accept data

mathematical and logical operational at high speed, and display the results of

these operations.

24
Compute. This refers to a process wherein an exact and correct value is given

manually or through the use of computer.

Monitor. This refers to continuous records of a process or quantity in a point of

sale system.

Software. This refers to the programs and other operating information used by

a computer.

System. This refers to the different programs to form as a whole and do what

the task intended to it.

Update. This refers to continuously recording new data and information added

and removed.

25
 APPENDICES

Appendix A

EVALUATION INSTRUMENT

METHODS OF EVALUATING THE PROPOSED SYSTEM

Title:
Point of Sale with Sales Monitoring System for Eduardo’s Kitchenette.
Name: _______________________
(Eduardo’s Kitchenette Staff)
Legend:

5 - Excellent

4- Very Good

3- Good

2 - Fair

1 – Poor

5 4 3 2 1
1.Functionality

2. Reliability

3. Efficiency

4.User-friendliness

5. Security

Signature

Figure 7: Methods of Evaluating the Proposed System

Figure 7 shows the methods that the researcher used to assess and evaluate the

proposed system.

26
 Appendix B

SYSTEM MODELS

Entity Relationship Diagram

Figure 8: Entity Relationship Diagram

Figure 8 shows the entity relationship diagram of the proposed system. The

diagram shows the entities which are the cashier, food menu and its relationship

between every entity

27
 System Flowchart

Figure 9: System Flowchart

Figure 9 shows the system flowchart of the proposed system, wherein the

user must select from the menu to be access. It’s either the menu or the orders.

28
Program Flowchart

Figure 10: Program Flowchart

Figure 10 shows the Home page of the proposed system; it accepts the valid

password input to access the administrator page.

29
 Appendix C

USER MANUAL

Figure 11: Login Page

Figure 11 shows the login page wherein the user will login their user/admin

accounts.

Figure 12: Cashier Page

Figure 12 shows the Cashier page wherein the user can see the available

menu. In this page also show details of the menu and the available table.

30
 Figure 13: Table Page

Figure 13 shows the Table Page added by admin. In this page also show

how many tables are available.

Figure 14: Order Page

Figure 14 shows the Order page wherein the user can see the list of food that

they order. In this page you can move table, add or minus quantity the details of the

order.

31
 Figure 15: Verify Page

Figure 15 shows the Verify page wherein the order will verify by admin.

Figure 16: Dashboard Page

Figure 16 shows the Dashboard page wherein the admin can see what table

available, order pending, verified transaction and earnings today.

Figure 17: Table and Order Page

Figure 17 shows the Table and Order page wherein the admin can access add

menu of the cashier.

32
 Figure 18: Transaction Page

Figure 18 shows the Transaction page wherein the admin can see all the

order that verified or not verified. In this page admin can also process the verify of

order.

Figure 19: Transaction Verify Page

Figure 19 shows the Transaction Verify page wherein the admin can verify the

33
payment.

Figure 20: Menu Page

Figure 20 shows the Menus page wherein the admin can add menu. In this

page admin can update menu category, menu name, menu price, and menu

availability.

Figure 21: Reports Page

34
 Figure 21 shows the Reports page wherein the admin can print menu, open

menu in excel and PDF file.

35
 Figure 22: Reports Transaction Page

Figure 22 shows the Reports Transaction page wherein the admin can print

daily reports, monthly reports and yearly reports

Figure 23: Print Page

Figure 23 shows the Print page wherein the admin can print the receipt of the

customer total payment.

36
 Appendix D

COST BENEFIT ANALYSIS

Operating Cost of the Manual Operations

Materials

This table shows the annual cost of materials used by the beneficiary.

These materials are used in the manual operations by the business of the

beneficiary.

Price
Item Quantity Unit Frequency Total
(per piece) (in a year)

Ball pen 20 Piece Php 10.00 Php 200.00

1

BondPaper 10 Reams Php 175.00 Php 1,750.00

1

Receipt 20 Packs Php 128 Php 2560.00

1
Pad Paper

Ink (Ink 10 Cartridg Php 875.00 Php 8,750.00

1
Jet Printer) e

Folder 30 Piece Php 15.00 1 Php 450.00

Total Annual Php 13,710.00

Table 7: Annual Materials Cost of the Manual Operation

The type of receipt pad paper being used by the business of the beneficiary

is the Glocarl Sold To/Order by 3x50's Carbonless 2ply 5 x 4-1/4

37
Electric Consumption

Rate/kw = Php 8.25 (based on Zameco II)

Monthly Consumption = (KW/hour) * rate * hours of work/month * No. of Unit

Annual Consumption = Monthly Consumption * 12 months

This table shows the annual electrical consumption of the manual

operational costs by the business of the beneficiary.

Table 8: Annual Electrical Consumption Cost of the Manual

Operation

Item No. Kw/hour Work Work Monthly Annual

of Hour/Day Hour/ Consumption Consumption
Unit Month

Compute 1 0.225 11 297 Php 551.30 Php 6,615.60

r
Desktop
Air 1 3.5 11 297 Php 8,575.87 Php
Conditione 102,910.50
r
Fluorescen 8 0.020 11 297 Php Php
t Light
392.04 4,704.48
8 0.040 11 297 Php 784.08 Php 9,408.96

Orbital
Fan
Total Annual Php Php

10,303.29 123,639.54

The business of the beneficiary has an ink jet printer, so it is not part of the

electric consumption equation due to the fact it is used rarely or on occasions only

38
Employees Salary

This table shows the annual salary of each employee of the business in

manual operation of the beneficiary.

Table 9: Annual Salary of the Employee in the Manual Operation

Employee Work of Rate per Daily Salary Monthly Salary Annual Salary
Hours Hour
(30days)
(including
OT)
Crew Fix Php 19.23 Php 250.00 Php 7,500.00 Php 90, 000.00

Cook Fix Php 31.69 Php 412.00 Php 12,360.00 Php

148,320.00

Total Annual Php Php

19,860.00 238, 320.00

Breakdown of Operating Cost for Manual Operation

This table shows the breakdown of operating cost of the manual operation

throughout the year.

Table 10: Breakdown of Operating Cost for Manual Operation

Annual Materials Cost Php 13,710 .00

Annual Electric Cost Php 123,639.54

Annual Employee Salary Php 238, 320.00

Total Annual Cost of the Manual Operation Php 373,609.54

Operating Cost of the Proposed System Materials

This table shows the annual cost of materials used by the beneficiary. The

39
table also shows that some materials are replaced, and quantities of materials are

lessened with regards to the proposed system.

Table 11: Annual Materials Cost of the Proposed System

Item Quantity Unit Price Frequency Total

(per piece) (in a year)
Ball pen 20 Piece Php 10.00 1 Php 200.00

Bond Paper 3 Reams Php 175.00 1 Php 525.00

Receipt Paper 10 Packs Php 15.00 1 Php 150.00

Folder 10 Piece Php 15.00 1 Php 150.00

Direct Thermal 1 Piece Php 899.00 1 Php 899.00

Receipt Printer
Ink (Ink Jet 3 Cartridge Php 875.00 1 Php

Printer) 2625.00
Total Annual Php 4,449.00

40
Electric Consumption
Rate/kw = Php 8.25 (based on Zameco II)

Monthly Consumption = (KW/hour) * rate * hours of work/month * No. of Unit

Annual Consumption = Monthly Consumption * 12 months

This table shows the annual electric consumption cost of the proposed system.

297 hours = 12 hours a day * 27 (4 weeks)

Table 12: Annual Electric Consumption Cost of the Proposed System

Item No. Kw/hour Work Work Monthly Annual

of Hour/Day Hour/ Consumption Consumption
Unit Month

Computer 1 0.225 11 297 Php 551.30 Php 6,615.60

Desktop

Air 1 3.5 11 297 Php 8,575.87 Php

Conditioner 102,910.50
Direct 1 0.100 11 297 Php 245.02 Php 2,940.30
Thermal
Receipt
Printer
Fluorescent 8 0.020 11 297 Php 392.04 Php 4,704.48
Light
Orbital Fan 8 0.040 11 297 Php 784.08 Php 9,408.96

Total Annual Php Php

10,548.31 126,579.84

The business of the beneficiary has an ink jet printer, so it is not part of the

electric consumption equation due to the fact it is used rarely or on occasions only.

41
Employee Salary

This table shows the annual salary of each employee of the business in the

proposed system of the beneficiary. Nothing has changed in comparison to the

manual operations.

Monthly Salary: Daily Salary * 27 (4 weeks)

Table 13: Annual Salary of the Employee in the Manual Operation

Employee Work of Rate per Daily Monthly Annual

Hours Hour Salary Salary Salary
(including
(30days)
OT)
Crew Fix Php 19.23 Php 250.00 Php 7,500.00 Php 90, 000.00

Cook Fix Php 31.69 Php 412.00 Php Php

12,360.00
148,320.00

Total Annual Php Php

19,860.00 238, 320.00

Breakdown of Operating System Cost for Proposed System

This table shows the breakdown of the total annual operating cost of the

proposed system lesser compared to the manual operation used by the beneficiary

throughout the year.

Table 15: Breakdown of Operating cost of the Proposed System

Annual Materials Cost Php 4449.00

Annual Electric Cost Php 126,579.84

Annual Employee Salary Php 238,320.00

Total Annual Operating Cost of the Proposed System Php 369,348.84

42
 Presentation of Values

Proposed Total Cost (1st year of implementation)

Operating Cost = Php 369,348.84

Development Cost = Php 5,000.00

Total = Php 379,548.84

Operating Total Cost of the Manual Operation

Operating Cost = Php 375,669.54

Cost Benefit Analysis

Point of Sale System With Sales Monitoring for Eduardo’s Kitchenette

Total Cost (Manual Operation) Php 375,669.54

Less: Proposed System (Point of Sale System With Sales Monitoring for Eduardo’s

Kitchenette)

Operating Cost (Proposed System) Php 369,348.84

Development Cost Php 5,000.00

Figure 24: Cost Benefit Analysis

This figure shows the cost of benefit analysis of the manual operations and

the proposed system in comparison

43
Comparison of the Manual Operating and Proposed System

Materials

Chart Title

13,710

4,449

0 2000 4000 6000 8000 10000 12000 14000 16000

Proposed System Manual Operation

Figure 25: Comparison of Materials Cost of the Manual Operation and the

Proposed System

This figure shows the comparison between the manual operational cost and

the proposed system cost. There is a large amount of difference between the

materials cost that the beneficiary had consumed in comparison to the proposed

system costs.

44
Electric Consumption

Chart Title

126,597.84

123,639.54

0 20000 40000 60000 80000 100000 120000 140000

Proposed System Manual Operation

Figure 26: Comparison of Electric Consumption of the Manual

Operation and the Proposed System

This figure shows the comparison between the manual operational cost and

the proposed system cost. This shows the difference of the amount of cost that has

been added in the electrical consumption due to the addition of a direct thermal

printer for the business of the beneficiary using the proposed system

45
Employee Salary

Chart Title

238,320

238,320

0 50000 100000 150000 200000 250000 300000

Proposed System Manual System

Figure 27: Comparison of Employees Salary Materials Cost of the Manual

Operation and the Proposed System

This figure shows the comparison between the employee salary cost of the

manual operation and the proposed system cost. There is no change or difference in

the salary of the employee, and it is still the same.

46