SAINT LOUIS UNIVERSITY

School of Engineering and Architecture

"We envision Saint Louis

University as an excellent
missionary and transformative
educational institution zealous in
developing human resources
imbued with the Christian Spirit
and who are creative, competent
and socially involved.”

Implementation of Online Website System (OWS) Design of

Annie’s Sweets and Pastries Online-Based Bakery

In partial fulfillment of the requirements for GIT (Living in the I.T. Era) Subject

By:
Almocera, Deo Jose
Formeloza, Erwin
Marcos, Arnon Grunt
Miado, Joshua
Orina, Jaymar
Sao-an, Dwayne
Ignacio, Aira Karyl

DATE OF SUBMISSION:
May 20, 2020
 TABLE OF CONTENTS
Acknowledgement i
CHAPTER I: COMPANY OVERVIEW
Company Profile 1
Mission of the Company 2
Vision of the Company 2
Organizational Chart 3
Business Rules 4
Business Operations 4
Business Process Diagram (flowchart) 5
CHAPTER II: SYSTEMS ANALYSIS
Problems Statement 6
Problems Encountered 7
Ishikawa Diagram 8
Proposed Solution 9
Non-functional Requirements 10
Functional Requirements 10
Scope and Delimitation 11
Feasibility Analysis 11
Cost Benefit Analysis
Table of Estimation 12
 Return on investment Computation 13
Payback Period Computation 14
Tangible and Intangible Benefits 15
CHAPTER III: PROPOSED SOLUTION MODELING
Decomposition Diagram 16
Context Diagram 17
Level diagrams of the system 18
Prototype 19
CHAPTER IV: CONCLUSIONS AND RECOMMENDATIONS
Conclusions 23
Recommendations 24
BIBLIOGRAPHY 25
APPENDICES 26
Gantt chart
Images of the business
 Acknowledgment
The success of this study would not be possible without the help of a few

people. We, the researchers, would like to thank Mrs. Annie Angaga, for allowing

us to conduct a study regarding her business, Annie’s Sweets and Pastries. Also,

we would like to thank Mrs. Laarni Natividad, GIT Instructor, who gave us

constant guidance throughout the whole study. This would not have been a success

without the moral and financial support of our parents, friends and classmates.

Lastly, we would like to express our deepest gratitude to Almighty God for the

wisdom and strength that allowed us to finish the study on time.

Sincerely Yours,

Almocera, Deo Jose

Formeloza, Erwin
Marcos, Arnon Grunt
Miado, Joshua
Orina, Jaymar
Sao-an, Dwayne
Ignacio, Aira Karyl

i
 CHAPTER I: COMPANY OVERVIEW

Company Profile

Business Information

Business Name: Annie’s Sweets and Pastries

Business Owner: Annie B. Angaga

Business Address: Apugan, Irisan, Baguio City

Phone: 0995806869

Email: annie_angaga@yahoo.com.ph

Primary Line of Business: Sweets and Pastries

General Business Activities:

Annie’s sweets and pastries is an online-based bakery store located in Apugan,

Irisan, Baguio City Philippines. The business can cover around La Trinidad , Tuba and

Baguio City and they can be contacted by the means of their Facebook account and

phone number. They sell products such as fruit pies, tarts, cookies, cupcakes, cakes and

cheesecakes. Their best selling product is the assorted flavored cheesecake. In terms of

service, they provide catering service and house to house service. As of now the business

is in good condition and is gaining an average of Php1, 500 a week.

1
Background and development:

Mrs. Angaga started baking as a hobby in the year 2017. Later on, she got

pregnant and decided to resign from her work to take care of her son. Due to the

increasing expenses in the family, she decided to start baking goods and selling it to her

neighbors and her friends. To further increase her knowledge and enhance her skills, she

took a vocational course in Cookery at Chets Academy Baguio City, Benguet on April

2018. The first service opportunity of the business began with the delivering cookies

cupcakes and sweets in school canteens in 2018. She then decided to enroll again for

Bread and Pastry NCII on April 2018 in the same culinary school she went before. Thirty

Thousand Pesos was the total capital of the business. This includes the equipment and

ingredients bought. In 2019 they decided to sell cakes which make their business grow

more.

Mission of the Company:

“To be the sole provider of satisfaction for every sweet tooth with the products of

Annie’s Sweets and Pastries in Benguet province.”

Vision of the Company:

“Annie’s Sweets and Pastries will continue to bake the finest goods, served with

happiness, one order at a time.”

2
3
 Organizational Chart

ANNIE B. ANGAGA
Owner/Baker

Minerva Perez Sophia Angaga Althea Boyao

Packaging Packaging Packaging

Marcial Angaga
Delivery/Pick-up

3
Business Rules

Since Annie’s Sweet and Pastries is a Sole Proprietorship business, the business rules are

only limited to the owner/baker. In addition, the products of Annie are homemade giving her the

freedom to do the things she wants with her business. But certain rules and regulations are being

strictly followed by Annie.

These are:

 Products that are close to its expiration date must be sold first and expired pastries must not

be sold to customers and must be disposed of.

 Ingredients’ expiration date must be strictly observed and make sure that no ingredient will

be put to waste.

 Proper dress code should be followed. Using a hair net, face mask and hand gloves is a must.

 Products made must be well refrigerated to extend the product’s shelf life.

Business Operations

The customer will request an order personally or through phone, then after that the

worker will list their desire orders and then do a confirmation for their finalize order. After that

they provide a schedule or processing time for customer order. If the customer agrees, they will

process the product immediately. When the product is finish, they will update the customer and

tell them that their order is ready to pick up. They’ll wait until the customer will arrive. Once the

customer see the product and feel satisfied, they will give the receipt to the costumer and then

accept the customer fee. The owner also accepts a refund, if ever the customer has a problem or

isn’t satisfied to the product.

4
Business Process Diagram

5
 CHAPTER II:SYSTEMS ANALYSIS

Problems Statement

 Limited Audience

The company’s means of advertisement and promotion doesn’t cater to a big number of

audiences. Moreover, the customers of the business are only limited to the owner’s friend and

friends of friend. The business wastes potential customers and clients, which leads to low

expectancy of profit. Having limited audience may also lead to the downfall of the business for

6
competitors might be able to take advantage of the business customers. In addition, it would

severely damage the business in the long run for its limited customers will not be enough to

sustain the company’s expenses.

 Absence of past records

The company does not record any present orders. Thus, no records are saved for the past.

The business is not able to compare data for accounting purposes and be able to determine

factors affecting the business’s strengths and weaknesses. The business is not able to undergo

such analysis and it only depends on its constant and stable way of management. No

improvements are being implemented and no further research is done.

 There is no list of orders for the audience to choose from

The business doesn’t have any proper list of options for the customers to choose from.

The customers/audience will not be knowledgeable of what they would be buying. Lack of such

a list would decrease the purchasing power of the customers for they are not able to determine

6
what they would buy. Moreover, the business would not be able to determine the least and best

product they could offer to the people.

Ishikawa Diagram

The diagram below illustrates the issues and problems encountered from the old

system of Annie’s Sweets and Pastries.

7
Proposed Solution

In order to provide solutions to particular problems mentioned, the researchers proposed

a system design. The primary concern is to build up a site for the business that would include

the following:

1) The company’s profile, services offered and interactive system that would allow a

customer-owner interaction;

2) Advertisement and promotions that would be a medium to cover a wider scope of

audience; and

3) An administrative system for the owner to automatically record data from orders using

the site. With the proposed system, customers will be able to see the different services

and products that are being offered by the company.

The proposed site will require an IT specialist for a professional build-up of the system. It

will also need various business data that will be used for the components of the site. The system

will be incurring expenses such as indirect labor from the IT specialist and advertising and

promoting expenses that would be included at the income statement of the company. Moreover,

when implemented the expenses would then be compared for the data next month if the proposed

solution would be effective and efficient for the business.

8
Non-Functional Requirements

A non-functional requirement defines the criteria of a system which includes operation

capabilities and constraints that would help enhance its functionality. In order for the proposed

system for Annie’s Sweets and Pastries business attain its best performance, the following must

be observed:

a) The system shall be able to display a menu at all times to facilitate manual order taking;

b) The system shall be capable of restoring itself to its previous state in case of failure (e.g.

system crash);

c) The system doesn’t require the users to log in, in order to access the site.

d) The system should have a good scalability (e.g. reduce the page load time, number of

errors, time to implement changes, and the cost to update the site);

e) The system should have a Planned maintenance - Changes and fixes on your website or

web content management system (WCMS) - adding new components to your authoring

environment, implementing a new page layout, changing branding elements such as

colors, logos, etc. and so on; and

f) The website should be easy to navigate.

Functional Requirements

Functional requirements specify the behavior or action the system should do. It also

describes the services offered by the system. The following are the functional requirements of

the proposed system for Annie’s Sweets and Pastries business:

9
 a) Sales should be generated every week;

b) It provides audit trailing;

c) It provides easier transaction and communication for both user and owner;

d) It provides a menu where the users could actually choose from; and

e) It serves as an advertisement and promotion for the company.

Scope and Delimitation

This study will focus on improving the system of a particular online-based business

which is Annie’s Sweets and Pastries. Profit Optimization and Data Organization are the main

function of the system that will be put up for the business to utilize. It will only be conducted

within the 3 municipalities: Tuba, La Trinidad, and Baguio City. The duration of the study will

last from March 2020 to May 2020. Data evaluation will use the recorded order information of

the first 20 customers from the system.

Feasibility Analysis

Schedule Feasibility

Set a time for the meeting about the details of the website, some of the topics are; how

will the website look like, how will it operate, how can we make the website easy to understand,

etc... The estimation on how long it will take to create the website is 4 to 7 days; this step

includes designing the website, making the website, and making final changes to the website.

Next is figuring out how the advertisement page will look, what information should be listed on

the website, creating a proper menu and list the steps on how the process of ordering in the

website. The meeting in general will take about a week or more for the details to be finalized and

10
approved. Finishing the whole system implementation and the time for the staff to adjust to the

new system would take about 2 weeks to a month.

Technical Feasibility

Worldwide retail online sales had already reached approximately $1 trillion by the end of

2010(Goldman Sachs 2011). More than 60% of US online users made a purchase online in 2009

(Forrester Research 2009). Online marketing is still growing up to this day. However, regardless

of the rapid growth in online shopping, many customers indicate that they are unsatisfied with

their online purchase experiences (Luo et al. 2012). Since it is said that a lot of people are

dissatisfied with their experience in online shopping, planning the website will have to be given

more effort so the business will not increase the statistics of unsatisfied customers. Hiring a

professional website designer should be the answer on how to make the website, we will let the

website designer pick what software to use in creating the website, after the details have been

told, the correct software will then be picked by the designer. For the staff, they will be taught on

how the website will work and how to operate it so they can adapt to the new system.

Operational Feasibility

Lately, online shopping has witnessed a remarkable leap forward (Chiu et al. 2014, Kim

et al. 2006, Luo et al. 2012) with sales growing more than 19% a year (Internet Retailer 2011)

and has become an important distribution channel or business model for many companies (Chiu

et al. 2014). Online marketing and selling has been a very huge success based on the studies of

their companies. Since the current system of the business is using pen and paper to record the

sales, and no way to order online, the new proposed system will be the answer to the problems

11
that the business currently have. The two websites that will be created will increase the

advertising prowess of the business; it will also be able to record the totality of the sales, and the

trends of the amount of sales with respect to time.

Cost-Benefit Analysis

Table of Estimation

Figure 2.1 Total Amount of Business Investment

Item Cost
Gas Range Oven ₱25,000.0

0
Microwave Oven ₱15,000.0

0
Electric Hand Mixer ₱5,000.00
Stand Mixer ₱1,500.00
Baking Utensils (e.g. Pans, Spatula, ₱20,000.0

Piping Bag) 0
Baking Ingredients ₱5,000.00
Total Amount ₱71,500.0

0
The table above indicates the expenses by the owner in setting up the business. It includes

the ovens, baking utensils and baking ingredients that totals up the amount of Php71, 500.

12
 Figure 2.2 Total Amount of System Investment

Cost
IT Technician Labor ₱5,000.0

0
Website Creator Software ₱600.00
Printing of Manual ₱250.00
Total System Investment ₱5,850.0

The table above indicates the estimated expenses in setting up the new system of

business. It includes the labor fee, website creator software payment and the materials used for

the manual which totals up the amount of Php5, 850.

Return on Investment

Figure 2.3 Total Amount of Sales with the New System

Week Sales
1st Week ₱3,000.00
2nd Week ₱2,250.00
3rd Week ₱2,000.00
4th Week ₱2,250.00

13
Total Amount ₱9,500.00
Total Sales with Commission ₱15,350.00

13
 The table above shows the amount of sales with the implementation of New System for

the first month. It also includes the commission or the amount spent for the system investment.

The total sales are Php15, 350. These values will be used to compute for the return of

investment.

ROI = (Net Profit/Total Sales)*100%

= (Php9, 500/Php15, 350) *100%

= 0.6189*100%

= 61.89%

The return of investment percentage is 61.89%.

Payback Period Computation

The total initial expenditure of the business, including the expenses on the build-up of

new system, is Php 77, 350. The system is expected to require Php10, 000 annually for the

maintenance costs. The expected annual payments from customers is Php50, 000.Thus, net

annual positive cash flows are expected to be Php40, 000.

Payback Period = Total Initial Expenditure/Net Annual Positive Cash Flow

= Php 77, 350/Php 40, 000

= 1.934

Therefore, the estimated payback period of the business is 1.9 years.

14
Tangible Benefits

 Increased Revenue

- Based from the amount of weekly sales during post-implementation of the newly-

built system, the average amount is around Php 2,375 per week. This is 58.33%

higher than the average income generated by the existing system.

 Productivity Gain and Reduced Workload

- Automated transactions require lesser time and effort than manual transactions. This

would allow the business to cater a larger number of customers since all the processes

and cash flows would be managed and organized by the system automatically.

Intangible Benefits

 Trade Name Promotion and Identifying Partnerships

- Online based advertisement is more functional advertisement system which has a

faster and easiest way to let the people know about your business. Having a

partnership/collaboration to some certain vloggers and bloggers can help to boost the

number of audience.

 Data Accuracy and Information System

- Internet based inventory has a better data accuracy and information system it has a

better management of business information’s and costumer information’s. Also it

keeps track of the past records avoiding discrepancy in the data management of the

business.

15
 CHAPTER III: PROPOSED SOLUTION MODELLING
Decomposition Diagram

The diagram below shows the outline of Annie’s Sweets and Pastries System. It includes

the various departments, its functions, and the relations of it with regards to the owner.

16
Context Diagram

The context diagram, also known as Level 0 diagram, below shows the relationships of

external entities to the system, how the information flows, and restrictions or boundaries of data

flow of Annie’s Sweets and Pastries.

Product Details
Finance Dept.
Confirm Costumer
Order

Reports
Product Orders /
Payments Costumer’s location
Feedback and request
Process
Record sales orders/
payments 0

Annie’s Sweets and

Pastries System

Feedback Management
Details Reports
Confirm Shipping Request
Request

Website Product
Maintenance Updates
Manager / Owner
Shipping Agent Feedback
Details

Website Admin

17
Lower Level Diagram

The diagram below shows specifically how the system works such as order processing,

payment processing, and information flow within the system. It also includes which entities

handle particular tasks such as order management, finance management, food production, and

order distribution.

18
Prototype

Home Tab

The Home tab will serve as the default tab for the customers. It displays some of the

products and advertisements of the business.

19
 About Us Tab

The About Us tab displays the background information of the business as well as the

mission and vision of the company.

20
 Products Tab

The Products tab will display all the products and the services of the business in an

organized way using categories. It will allow the customers to choose orders systematically.

Another service offered by the business is the ‘Create your own’ where the customer is allowed

to customize his or her own cake at a reasonable price.

21
 My Order Tab

After choosing, the orders will be displayed in the My Order tab. It will allow the

customers to finalize their order before submitting it. This is also where the order will be filled-

up with necessary information that will be recorded as stored data of the system.

22
 CHAPTER IV: CONCLUSIONS AND RECOMMENDATIONS

Conclusions

Annie’s sweets and pastries have not been using any kind of method to record their sales

which can result in a business exhausting the budget; leading to spending more than what is

coming in. Also only few people have known about this business so they only have limited

costumers. Therefore the researchers proposed the Online Website System (OWS) for the

business. After implementation of the new system, the researchers have generated the following

conclusions:

1) Sales generated by the business increased by 58% higher than the old revenue;

2) It allowed the business to cater more customers in a time-efficient manner;

3) Data retrieval was easier, more organized, and more time-saving than the old system;

4) It widened the scope of potential customers through various advertisements and

promotions;

5) Workloads are reduced and the usage of paper materials is lessen since transactions are

already automated; and

6) It opened opportunities for potential investors of the Annie’s Sweets and Pastries online

business.

Furthermore, Online Website System (OWS) also ensured that the data stored will have a

backup in case of any error/corruption that will occur, considering that the area, where the

business is situated, is affected by the rotational brownout within Baguio City.

23
Recommendations
The study was only limited to the improvement of data organization, order processing,

finance management, and business presentation through the implementation of Online Website

System (OWS) to Annie’s Sweets and Pastries business. Further research regarding the

following is recommended for the further development of the said business:

1) Occurrence of various backlogs and proper website maintenance of the system;

2) Possible cyberattack to the data stored in the system; and

3) Impact of establishment of a physical store of the business to the existing system.

24
 BIBLIOGRAPHY

Rowe, C. (n.d.). The 6 biggest risks concerning small businesses. Retrieved from
https://www.clearrisk.com/risk-management-blog/bid/47419/the-6-biggest-risks-
concerning-small-businesses?fbclid=IwAR3Xtbc5CFEdtC-
cDVQLSXbj2SycMQyrWWs_ChqTUYajAPGlQvS8ClmvxkA

Thompson, A. (2003). Understanding the Proof of Business Concept. Retrieved

from http://library.uniteddiversity.coop/Business_Plans/Understand_a_proof_of_
business.pdf?
fbclid=IwAR0cMdBzqFbZu6sZAM0yEGaBe1bGdqIvwUoRewXxHJJk23warHFpanNea
LE

A study of factors related to successful and failure of entrepreneurs of small industrial business
with emphasis on their level of education and training. (2005, September 7). Retrieved
from https://www.leeds.ac.uk/educol/documents/143150.htm?
fbclid=IwAR2N6hb2vUm6OgHnTGuc7nYKygxkLLu3xDabMn9Bq8ceJ5HcMIpYH5JN
IO4

How to make a data flow diagram. (n.d.). Retrieved from

https://www.lucidchart.com/pages/data-flow-diagram/how-to-make-a-dfd

3 target audience problems to avoid. (2015, March 16). Retrieved from

https://www.business2community.com/marketing/3-target-audience-problems-avoid-
01177657/amp?
fbclid=IwAR2TUci96yt2yEc9tQWrZfX5IzjGurxgjNBPBh84awOAP9iqxgw1Si-7Pyg

Understanding functional requirements. (2018, July 25). Retrieved from

https://thebusinessanalystjobdescription.com/understanding-functional-requirements/

Cost-benefit analysis. (n.d.). Retrieved from

https://www.mindtools.com/pages/article/newTED_08.htm

Walts, A. (n.d) Your Essential Guide to Effective Inventory Management + 18 Techniques You
Need to Know. Retrieved from https://www.bigcommerce.com/blog/inventory-
management/#inventory-management-techniques

25
APPENDICES

26
 Breads by Annie’s Sweets and Pastries

Cupcakes by Annie’s Sweets and Pastries

27