IT 3A Final Output
IT 3A Final Output
IT 3A Final Output
List of Tables
Table 1: Best Seller Products..........................................................................................................................................3
Table 2: Hardware Requirement (BUILD).....................................................................................................................9
Table 3: Software Requirement (BUY)........................................................................................................................10
Table 4: Software Requirement (BUILD)....................................................................................................................10
Table 5: Manual Operating Cost...................................................................................................................................11
Table 6: Summary of Proposed System Cost per year.................................................................................................12
Table 7: POS Operating Cost........................................................................................................................................13
Table 8: Total Profit per year........................................................................................................................................14
Table 9: Comparison of Operating Expenses...............................................................................................................15
Table 10: Data Dictionary of Data Flow.......................................................................................................................19
Table 11: Data Dictionary of Data Store......................................................................................................................25
Table 12: Data Dictionary of Data Process...................................................................................................................26
Table 13: Data Dictionary of Entity..............................................................................................................................27
List of Figures
Figure 1: Business Process Flow Chart.........................................................................................................................5
Figure 2: Organizational Hierarchy................................................................................................................................6
Figure 3: Gantt chart.....................................................................................................................................................11
Figure 4: Decomposition Diagram................................................................................................................................18
Figure 5: Context Diagram...........................................................................................................................................18
Figure 6: Level 0 Diagram............................................................................................................................................19
Figure 7: Homepage......................................................................................................................................................28
Figure 8: Figure 8: Employee Homepage.....................................................................................................................29
Figure 9: Order Process................................................................................................................................................29
Figure 10: Manager Log-in...........................................................................................................................................30
Figure 11: Management Homepage..............................................................................................................................30
Figure 12: Product List.................................................................................................................................................31
Figure 13: Sale Report..................................................................................................................................................31
Figure 14: Update Product Information........................................................................................................................32
Figure 15: Receipt.........................................................................................................................................................32
Chapter I: Company Profile
History
Sinner or Saint Café is owned by Girlie Asiong Apuntan. The Café is born out of the passion of the owner and her
family for cooking, baking and love for their tradition. She started as an online business- catering only to her few
friends. And her online business eventually evolved into a café offering cakes and Cordillera fusion foods with the
help of her family. Through their food they are able to promote who they are, their culture and their local products.
Sinner or Saint Café is based on the food that they are offering, ‘Sinner’ for the “guilty pleasure food” and ‘Saint’
for the “guilty free food”.
Vision
To be the leading café in La Trinidad, Benguet with the best quality of food and service that can amend the
customers experience in Cordillera.
Mission
To serve a remarkable foods and beverages with a touch of Cordilleran taste. To offer their customers a service with
warmth and hospitality. To set up a café like no other and keep up their originality.
Services
They provide a pleasant environment for dinning, and mainly for enjoying a cup of coffee followed by pastry dishes
and pasta. They customized cakes for all occasions like; birthdays and wedding celebrations. They also accept
orders for take outs. Sinner or Saint also sells their own version of rice wine or locally known as tapey. Sinner or
Saint Café is also accepting seminars, meetings or any special events with their new hall located near the café’s area.
Target Market
The target markets of Sinner or Saint Café are teens and adult since the atmosphere is suitable in all ages who want
to experience delicious and remarkable foods. They target both sexes and the café also appeal to families or group of
friends since it is a great place to relax and to spend quality time with each other.
Suppliers
The management said that some of their ingredients are bought only at Tiongsan, La Trinidad Benguet like the
pasta, flour, sugar etc. while the vegetables and fruits are bought at Baguio City Public Market. And for the meat,
they bought it from Paran Meat Store located at Magsaysay Avenue, Baguio City.
Indirect Competitors
Some indirect competitors of Sinner or Saint Café are Fast food Chains like McDonalds and Jollibee where they sell
different products but they can satisfy the same target market especially that now a days fast food chains are
preferably for some youths for its cheaper price but unhealthy food. While Sinner or Saint serves with a relaxing
atmosphere and more variety of food that will surely satisfy your cravings with healthier ingredients. Another
1|Page
indirect competitor of Sinner or Saint is restaurants like for example the Grumpy Joe located at Leonard Wood road
the said restaurant has the same target market as the café, but Sinner or Saint Café is much cheaper than Grumpy Joe
and suitable amongst students who want a place to study or unwind after class.
Direct Competitors
Fika Café, located at Buyagan, La Trinidad and The Loft café at km 5 La Trinidad are examples of direct
competitors of Sinner or Saint especially around La Trinidad area, though they serve the same products like coffees,
pasta and other pastries Sinner or Saint is more convenient since it is closer to different tourist site like Bell Church
also known as China Town of Baguio and STOBOSA where houses are painted with bright and different colors, also
Sinner or Saint is closer to Baguio where you don’t have and endure the long traffic along km 4 La Trinidad. There
are a lot of Café around Baguio City like Gossip Café, Rewind Café etc. these café serves the same kind of food but
only Sinner or Saint Café serves in a different way since their products has a touch of cordilleran class that other
café doesn’t have.
Constraints
Tables are the main constraint around the Café since the space is limited; same goes with parking area where
customers who have a car usually park besides the road.
Future Direction
Sinner or Saint in the future will have its second branch at Baguio City and expecting to expand their branch at La
Trinidad, Benguet. The café is also aiming to satisfy more customers and to build positive experiences through their
services and products.
2|Page
3. Strawberry Cake Slice- 89php
Whole- 550php
Small- 139php
4. Pinikpikan Pasta
Medium- 299php
Large- 750php
Small- 139php
5. Bean Paste Noodles
Medium- 299php
Large- 750php
69 or 149php
8. Black Currant Coffee
3|Page
Business Process
Sinner or Saint Café is open from Monday to Sunday (9:00 am to 10:00 pm) but the employee is required to come
on or before 7:30 am to prepare the café and double check their supply.
Once everything is settled the café will then start their business by taking the order of the customer in their table if it
is for dine in and if not the customer have to order directly to the cashier. The employee will then check if the order
is available or not. If not available, then the customer may order different dish, after the order is verified for
availability then it will be forwarded to the kitchen for them to be updated in any changes in customers order. After
that the food is now ready to serve and will be deliver to the respective customer.
Then the employee assigned in the cashier will write down the updated order details of the customer, after that the
employee will process the transaction and compute for the amount due. After the customer eats, he/she may get
his/her official receipt and then pay the amount due and then leave the café.
Yes
NO
Yes
4|Page
5|Page
Girly Asiong
Apuntan
Owner
Jhovie Sianen
General Manager
Business Rules
The following are the business rules according to the management of the restaurant.
Statement of Problem
Sinner or Saint Café started their business year 2017 which they used manual system for their day-to-day operations
that leads the following problems
6|Page
- Records are not legibly written that may result to miswritten data that are essential in producing the
financial report of a company.
Up-to-date reports are hard to generate
- Due to the number of orders made each day, there’s a difficulty in having an updated report.
Sales Data are hard to locate
- Sometimes there are orders that are missed to account because of the numbers of orders accounted
every day.
Serving of Incorrect orders
- The employee may interchange orders due to lack of table numbers and product information. This may
cause to decrease customer satisfaction that leads to profit loss.
Proposed Solution
The proposed POS System will keep track of everything that happens in the café, providing accuracy and
reliability of the reports.
The POS System will automatically generate reports by the end of the day, week, or month.
Sales will be always updated in every transaction made leaving nothing unrecorded and the POS System
will have a separate folder for the Sales data.
The system will have all the product information and table number will be assigned to the customer.
Functional Requirement
The point of sale system must process order details with designated table number and calculate for the
amount due of the order.
The system must also generate accurate sales reports at the end of the day or during transactions.
Non-functional Requirement
Safety- the point of sale system shall be able to save all the changes in a data.
Availability- the system shall be available anytime for the manager or employee to use and track
transactions.
Security- the system shall be non-operational without the input of proper information of employee or
the manager.
7|Page
organized way of dealing with their sales. In addition, managers will be able to review more accurate and exact sale
reports, update product information such as product price or additional product and generates official receipt.
However, the prototype will strictly only be giving information about sales but will not give detail regarding
inventory system, discounts or promos. We will also not be concerned with spoilage of inventory and return of
products.
Feasibility Study
Operational Feasibility
With the help of the system we proposed, Sinner or saint Cafe can do its operation faster. It will also lessen the
hassle that cashiers and customers usually experience. We observed that the taking of orders is very slow and
sometimes the cashier tends to have some error in listing the orders of the customers, also for the price of the orders.
That’s why we proposed a system that will automatically know the price of the products; a system that will
automatically update and monitor the sales of the company; a computer system which contains product information
and a system that will compute the daily sales of the company. Through this, the company will now know the daily,
weekly and monthly sales because it will be automatically computed by the system. The system is user-friendly and
easy-access for the employees when they use it; it will not take long time for them to learn on how to use the said
system. The employees, as well as the owner, will easily adapt to the change because it is much more comfortable
using computer and encoding the orders than just merely writing.
With the start of the new system, the environment of the restaurant will change to reliable and faster service. The
customers will take their orders on an earliest point of time because the cashier will now only enter the orders of the
customers and the price will automatically be there. The system will be a great advantage to the company because
the work of the employees will be less hassle, it will help the company’s daily operational task and it will make the
employee’s performance better. It is also a big asset for having this system in the company because many restaurants
don’t have this system. By having the said system, the company will be more competitive towards its competitors.
The organization will benefit from the system, results will be measurable by having the ability to analyze sales data
from past transactions that can be used to forecast future needs, though it will take months to see the results but it
doesn’t mean it has a negative effect to the company but rather it will surely have high beneficial impact.
Technical Feasibility
Sinner or Saint Café doesn’t have software when it comes to their sales transaction. So we proposed a system that
requires a tablet which they already have, they are currently using a Samsung tablet for their calculations and storage
of their sale transaction data.
58mm Mini Portable Bluetooth 4.0 Wireless Receipt -Print speed: 90mm/sec
Thermal Printer
-Reliability TPH Life: 100km
8|Page
-Resolution: 203DPI (8dot/mm)
9|Page
- Amounted to 15,000, with the protection of the
system and errors checking, the maintenance of
Installation of System the software 3 times a year that cost 1500 is
Schedule
Economic Feasibility
Ball Pen
Price per piece 7 175
Multiply by: Number of Ball pen 25
needed a year
10 | P a g e
Folder
Price per piece 8.50
Multiply by: Number of Folder 6 51
needed a year
Record Books
Price per piece 75
Multiply by: Number of Record 6 450
Book needed a year
Carbon Paper
Price per pad 180
Multiply by: Number of paper 12 2,160
needed a year
11 | P a g e
Table 7: POS Operating Cost
A. For Printing
2,134
Source: LAZADA
D. Training Fee
12 | P a g e
12
Total Training Fee
1350
Source: Mr. Vincent Tan IT Expert 1350
Total 150,000
13 | P a g e
Return of Investment
ROI= (1,800,000-71,344/71,344)
ROI= 24.23%
Payback Period
Tangible Benefits
1. Decrease in Expense
After using the proposed system the expenses will decrease by Php 986, the original manual operating expense
amounted to 2,836 per year will only be 1,850.
Thermal Paper
Ball Pen
175 Source: LASER
Source: LASER OFFICE 1,850
OFFICE SUPPLY
SUPPLY
Folder
51
Source: LASER OFFICE
SUPPLY
Record Books
450
Source: LASER OFFICE
SUPPLY
Receipt Paper
2,160
Source: LASER OFFICE
SUPPLY
Total 2,836
14 | P a g e
1,850
Other Benefits:
[1]
The system minimizes the possible human errors especially in taking the order of their customer and in their
billing process, using the Point of Sale system the EMPLOYEE just have to input the order details in the system
then it will automatically be computed by the system using the right amount. Also they may give their customer the
order receipt in a proper and clearer thermal paper, unlike before the customer may misinterpret the written receipt
especially if the employee has errors in the receipt or bad handwriting.
[2]
Point of sale systems has reporting features that allow you to keep a close eye on sales, profits, and expenses. With
the help of the system generating reports, the management may use this to evaluate their company and to know more
about their customers, for example they can see the list product which is in demand to their customer or maybe the
product not being sold; after knowing this they have to think a strategy to improve the product, they can lower the
price or change the product itself. Sale Reports are important for the company especially when their accountant
submit their financial reports to the BIR, with proper and accurate figures generated by the system it will be easier
for the accountant to create or understand the cash flows made by the operation of the company.
[3]
Using the point of sale system, it won’t take time to take order since it is automated already. Also the manager
won’t have to experience the hassle of doing a report each day, since before writing the needed reports repetitively
can cause to decrease in the quality of the person doing it. Saving time from doing unnecessary works is the biggest
benefit impact of a computerizes point of sale system, now the manager can easily track the sale reports any time
and doesn’t have to worry in doing the reports that took her/him hours to make before.
Sources:
[2]
15 | P a g e
Chapter III: Proposed Solution Modeling
16 | P a g e
Proposed Solution Level-0 Diagram
17 | P a g e
Data Dictionary
A. Data Flow
ORDER DETAILS =
Desired product Check
{Product} + Quantity
Order Details of a customer to Customer Availability of
QUANTITY = Digits
the café. Order
PRODUCTS = {Products}
18 | P a g e
ORDER UPDATES =
Check
Order Updated order of Confirmation of {Product} + Quantity+
availability of
Order
Updates the customer order Product Price
QUANTITY = Digits
PRODUCT PRICE= Digits
VERIFIED ORDER
Confirmed and Encode
Verified Confirmation of DATA={Product} +
final order of the Confirmed
Order Data Order
Order Quantity+ Product Price
customer
QUANTITY = Digits
PRODUCT PRICE= Digits
COMPLETE ORDER
Includes the name INFORMATION= Computed
Complete of the product, the Computation of Generate Order Data
Order Order Receipt
Information quantity of each COMPUTED ORDER DATA
products ordered, ={Product} + Quantity+
and the amount of Product Price
each product. QUANTITY = Digits
PRODUCT PRICE= Digits
Payment Customer Generate
Details Receipt
Includes the name PAYMENT DETAILS =
of the product, the Billable Amount + (Excess
quantity of each
19 | P a g e
product ordered,
Paid)
the amount of
EXCESS PAID = Change
each product, and
CHANGE = Amount Paid –
the total amount
Billable Amount
of the products
AMOUNT PAID = Digits
ordered.
Receipt It is the hardcopy Printing of Customer
Details of the customer Receipt RECEIPT DETAILS= Name
about the of Cafe + Date + Address +
transaction and Telephone Number + Table
amount paid. number + Transaction Number
+ Product + Quantity + Unit
Price + Amount Due + Cash
Payment + Change +Employee
Name + Employee Position+
Product Code
NAME OF CAFE= letter
LETTERS= A-Z
ADDRESS= Street number +
Street Name + City
STREET NUMBER= Digits
20 | P a g e
QUANTITY= Digits
UNIT PRICE= Selling Price
SELLING PRICE= digits
AMOUNT DUE= Quantity *
Unit Price
QUANTITY= Digits
UNIT PRICE= Selling Price
CASH PAYMENT =Amount
Due + [Excess Paid]
EXCESS PAID = Change
CHANGE = Amount Paid –
Amount Due
AMOUNT PAID = Digits
PRODUCT CODE= Letters +
Digits
COMPUTED ORDER
INFORMATION = Payment
Details + Order Details
PAYMENT DETAILS =
Amount Due + (Excess Paid)
EXCESS PAID = Change
Compose of the CHANGE = Amount Paid –
Computed information about Amount Due
Order Sales Record Preparation of
the sold products, AMOUNT PAID = Digits
Information Sales Report
including the ORDER DETAILS= Order
amount paid by information + Product
the customer. Description
ORDER INFORMATION =
{Product} + Quantity
PRODUCT DESCRIPTION=
{Product}+Product Price
QUANTITY= Digits
21 | P a g e
Products Sold+ Amount Paid+
Date+ Unit Sales
PRODUCT SOLD=
{Products}+ Quantity
quantity sold, QUANTITY= Digits
cash payments AMOUNT PAID= Digits
and the date of DATE= Month + Day + Year
transaction. MONTH= [January…
December]
DAY= [1…31]
Year= 4[Digits]
UNIT SALES= Digits
PRODUCT INFORMATION=
Change in Product
CHANGE IN PRODUCT=
[Additional Product |
Reduction of Product] +
Changes made by Change in Price +
Updated
the manager due ADDITIONAL PRODUCT=
Product Data Manager Product
to the result of {Products}
Information
sales report. REDUCTION OF
PRODUCT= {Products}
INCREASE PRODUCT
PRICE={Products}+ New
Price
NEW PRICE= Digits
22 | P a g e
Change in Price +
ADDITIONAL PRODUCT=
{Products}
REDUCTION OF
PRODUCT= {Products}
INCREASE PRODUCT
PRICE={Products}+ New
Price
NEW PRICE= Digits
B. Data Store
INVENTORY = Product
It has all the information of the
Description + Product Price +
products including prices, stock-
Stocks+ Product Code
on-hand, product name and sizes.
PRODUCT DESCRIPTION =
It is the basis of information being
Inventory Letters
used by the manager and
LETTERS = A-Z
employee. In case of changes in
PRODUCT PRICE = Digits
the product, it will store in the
STOCKS= Digits
system.
PRODUCT CODE= Letters+
Digits
Sales Records
This is the information about the SALES RECORDS = Product
café’s product whether it is the Description + Unit Sales+
best-selling or not. It is also the Amount Due
basis of the management in PRODUCT DESCRIPTION =
deciding about a certain changes Letters
23 | P a g e
that are needed to increase the
UNIT SALES = digits
profit of the café and to know if
AMOUNT DUE = Quantity *
the employee is encoding the
Unit Price
right amount or product that are
being address to the customer.
C. Data Process
24 | P a g e
will be printed.
D. External Entity
25 | P a g e
Prototype (screenshots)
Figure 7: Homepage
26 | P a g e
Figure 9: Order Process
27 | P a g e
Figure 11: Management Homepage
28 | P a g e
Figure 13: Sale Report
29 | P a g e
Figure 15: Receipt
Conclusion
After the evaluating the Point of Sale System, we conclude that it eliminates the error in recording sales transactions,
which are reported to the owner. Also, the billing system is easier, faster and more accurate. The POS system
provides more efficient and reliable operations of the business compared to the manual system. This may increase
the sales revenue of the business because the proposed system can let the manager access the actual sales of the
current month and compare it from last month, the manager will decide a more effective way to increase their sales.
Since the system minimizes errors, it will increase customer service that leads to customer satisfaction.
Recommendation
We highly recommend Sinner or Saint to have online reservation, online order, catering and deliveries; this will
increase their revenue and expand their business. Also, we recommend for them to have customer loyalty program
like for example they can give a discount coupons or offers promo to the public. Lastly, we recommend starting
accepting payments through debit and credit cards for customers' convenience.
30 | P a g e