binuatan creations

Chapter I

Introduction

1

Background of the Study

Binuatan Creations is one of the pioneer handlooms weaving industry in Palawan. The

company has wonderful beginnings, after leaving as a government employee the owner, Ms. Eva

T. Valledor established this business from her savings worth Php 50,000.00 and which is her

separation pay after quitting in her former job.

Binuatan is a Cuyono term (the native Palawan dialect) word for CREATION. In

Puerto Princesa City, it has become synonymous with woven products made from Buntal fibers

such as mangrove grass, amumuting, buri sprigs and vetiver.

For the past 9 years the company managed to established 3 handloom weaving centers

both are located at Pajara and the first one is at the back of Puerto Princesa School of Arts and

Science Technology (PPSAT), the other one is along Employees Road and this is the largest

among the three and it seems like their main branch, another, in here the customers are allowed

to used the handloom machines to experienced weaving and to take pictures. Lastly, the other

one is located beside the house of the owner/manager of the company.

The Company started to export from 2004-2005 by the orders of Calvin Klein but due to

financial crisis and fluctuations in Dollars versus Pesos triggered to decline and stop its export.

Now the company is more focusing in domestic markets.

Here, they manufacture handloom woven products utilizing Palawan's indigenous fibers

like field grasses, buri etc. Among the products they produce are bags, placemats, table runners,

window blinds and curtains, ref covers and coaster wall hangers that are top quality they are

being exported all over the world.

The company manages to use a manual way of computing and recording the transactions

that results in errors during the monthly evaluations such as not accurate amounts of products

sold, unexplained tally of physical count versus the recorded tally, and the lost items. This also

results in the employee’s decrease in productive time, late preparation of reports and many more. 2

This is the reason why we conduct this research the Computerized Sales and Inventory System,

for them to minimize cost and maximize profit, reduce human effort and more accurate reports,

and increase productive time jobs.

This System will ensure Accounting of financial transactions of a business as an

important function of daily operations. Developing and using a proper accounting system will

ensure all transactions are recorded correctly and accurately on the company's general ledger.

Technological advances ease the accounting process for many businesses compared to the

manual way.

The Computerized Sales and Inventory System is our proposed system, to solve the

business problems mentioned above and to answer the needs of ever changing world of business.

Statement of the Problem

The Purpose of this study is to develop and create a Computerized Sales and Inventory

System which can be used by Binuatan Creations in recording transactions, and preparing

reports. The purpose of the study is to solve the following problems:

The loss of data due to mishandling of Records.

Inventory counts and incorrect sales figures.

data duplication: the same data gets repeated over and over since the workers find it hard to keep track of the documents, information and transactions

Lack of security: since data is stored in filing cabinets it is freely available to anyone. If information falls into the wrong hands it can be used against the company and customers and can blackmail them.

Common errors: when entering data customers might have accidentally switched details and data since it is hand written.

Inconsistency of data: there will be unavailability for future use, since data might get misplaced during manual filing. So data won’t be preserved properly for future use.

3

Repetition of work: if there are any changes to be made, the data will have to be entered again. at times the worker would forget to make the changes or forget that they had already altered it and might redo it again, its again time consuming.

Space consuming: since the data and paper is stored in filing cabinets it consumes too much place, as the amount of work done on paper increases the filing cabinets too increases.

Slow retrieval of data: the information of customers and details are stored in different parts of the site and so takes a long time to retrieve the data.it takes a long time to find the information about a relevant person. In case of a Delivery, the delivery will be held back.

Objectives of the Study

The Objectives of this study is to develop and create a Computerized Sales and Inventory

System for Binuatan Creations that will solve their problems. The objective of the study is the

assertion statement of the problem with the general objectives and specific objectives desired

outcome of the research process.

General Objectives

The General Objective of this study is to create a Computerized Sales and Inventory

System for Binuatan Creations that will eventually replace the existing manual system.

Specific Objectives

These are the following objectives that the researcher would like to achieve.

To Prevent Data loss.

To trace and manage all in and outs, of stock and assets.

To have a faster retrieval of data.

To prevent common errors in counting inventory.

4

To prevent data duplication.

To keep track everything from the ordering of materials to the point at which the finished product is shipped out.

To ensure quality control in businesses that handle transactions revolving

around consumer goods.

Significance of the Study

The study is to develop and create Computerized Sales and Inventory System for

Binuatan Creations will be a learning paradigm to other industries. To switch from the manual

system into a new computerized sales and inventory system that will help solve the problems that

the manual system gives. Some of these problems are repetition of work, Inconsistency of data,

Lack of security and errors in recording which provides more human effort that lessen the

productive time of the employees especially during month-ends and year-ends where they

prepare reports that are needed to be submitted in important institutions in the government like

BIR or the Bureau of Internal Revenue and other concern agencies. This system also encourages

the development of other types of system that will eventually help the needs of the market.

Scope and Delimitation

Scope

The System only covers the products that are listed in the Tables at the appendices (see

Appendices B). The 4 major functions of the system the Accounts Receivable Function, under

this is the input of pertinent data; Sales Function which is the main interface of system were the

user will input the product number and other important information, this function gives the

receipt immediately after entering the data; the Inventory Function that will show the total items

listed sold and are available for sale, the most purchased and the least purchased; and the last is

the Report Function were the user will choose what type of report he/she might want to see or

printed. 5

Delimitation

The system will not cover other functions that are not listed above paragraph. The system

will not cover the raw materials inventory, office supplies inventory, factory supplies inventory

and other expenses that are attributed in the Factory (Handloom Weaving Centers) area. And

also other expenses like utilities, maintenance and repairs of the showroom (the Shop itself). The

System will not cover Sales from other products that are not listed in the table (see page),

because this products are not owned by Binuatan Creations.

6

Chapter II

Theoretical Framework

Review of Related Literature

In the past, sales and inventory systems were mutually exclusive systems, with one used

to sell merchandise and the other used to track it; modern point-of-sale systems incorporate

computerized access to the inventory control system, allowing for real-time updating. An

inventory and sales system working in unison effectively tracks product from the moment it

enters the store to the moment it leaves, barring losses due to shrinkage.

Separate Origins of Sales and Inventory Systems

Originally, in the era before computers, sales were tracked with counter ledgers or, later

on, mechanically issued receipts from cash registers. Inventories had their own ledger book,

meaning that the two systems were entirely separate out of necessity. With the advent of modern

computer technology, it has become possible to combine the two systems into one digital

process.

Modern Sales and Inventory Integration

The modern miracle of inventory control would not be possible without automated sales

tracking. Point-of-sale information, gathered from inventory control systems, is used to adjust

the levels of goods produced by manufacturers, supplied by vendors and stocked by merchants.

Increased efficiency in the production and delivery of goods lowers costs for vendors, merchants

and consumers alike.

Modern inventory system

There are quite a number of computer operated systems available today. One type of

computer operated system is the barcode system. We are quite aware on how these work and

7

these systems are common today. Each product has a specific barcode to identify it and each box

of the product has another specific barcode which stores what items are stored in the container

and its quantity. The barcode system has little room for error once the code has been printed out

properly. For small scale businesses, they would just buy a barcode reader and the software to

manage it since products that are sold in retail or in wholesale already have their own unique

barcodes.

Another type of computer operated system is the radio frequency identification or RFID

system. The supplies are embedded with RFID transmitters to emit information that can be

collected at a certain distance. When these supplies come in to an establishment’s warehouse, the

receiving computer can then immediately record what is coming in and out of the warehouse.

This technology is still new and expensive but once it becomes feasible for everyone, a lot of

people and businesses will greatly benefit from it.

Each control system has its own advantages and disadvantages. Modern inventory control

systems cost more than the traditional ones but are more efficient for those who have larger

inventories.

Modern sales system

CYPHER is a fully integrated computer system solution that is easy to use, simple and fast. It

allows members to manage every aspect of their business including:

• Core banking

• Automated emailing

• Advance ship notices

• EDI and FAX interface

• Full accounting system

• Warehouse stock check

• Barcode scanning using

RF

• Online customer order entry

• Full inventory control system

• Warehouse management system

• Order entry system with catalogue

• Flexible program to manage customer pricing

• Electronic stock ordering to MSC distribution centers

• Electronic invoicing and statement processing from head

office

8

As an MSC member, you are provided full system hosting by head office and secured daily

backups, all included with your CYPHER package. Members also enjoy secure and encrypted

data storage and a guaranteed service uptime, as well as virus protection and helpdesk support

services. Updates are provided free of charge and maintenance on product files are also included.

CYPHER is a full business system with low investment and maintenance costs. Future

development and programming costs are minimal, and with full system integration, small and

medium sized member businesses receive the same reliability and power that large companies

use and expect.

Definition of Terms

Accounts receivable: Money owed to your business for goods or services that have been

delivered but not yet paid for.

Annual report: The yearly report made by a company at the close of the fiscal year, stating the

company's receipts and disbursements, assets and liabilities.

Available—refers to the status of inventory as it relates to its ability to be sold or consumed.

Availability calculations are used to determine this status. Availability calculations vary from

system to system but basically subtract any current allocations of holds on inventory from the

current on-hand balance. An example of an availability calculation would be: [Quantity

Available] = [Quantity On Hand] -[ Quantity On Hold] - [Quantity Allocated To Sales Orders] -

[Quantity Allocated to Production Orders].

Cash: Money in hand or readily available.

Cash discount: A deduction that is given for prompt payment of a bill.

9

Company: is a form of business organization. It is an association or collection of individual real

persons and/or other companies, who each provide some form of capital.

Consignment the act of consigning, which is placing any material in the hand of another, but

retaining ownership until the goods are sold or person is transferred. Like some of the items sold

in Binuatan Creations Showroom.

Cost-benefit analysis (CBA), sometimes called benefit-cost analysis (BCA), is an economic

decision-making approach, used particularly in government and business. CBA is used in the

assessment of whether a proposed projects, programme or policy is worth doing, or to choose

between several alternative ones. It involves comparing the total expected costs of each option

against the total expected benefits, to see whether the benefits outweigh the costs, and by how

much.

Database: is an organized collection of data for one or more purposes, usually in digital form.

Handloom is a simple machine used for weaving in which no power is used.

Inflation: a sustained increase in a country's general level of prices that devalues its currency,

often caused by excess demand in the economy.

Inventory: A list of assets being held for sale, the stock of finished goods, raw materials, and

work in progress held by a company.

Item Number: A number uniquely identifying a product or component.

Questionnaire: List of a research or survey questions asked to respondents, and designed to

extract specific information.

Manual system usually means done by hand. That could be typing all your information into

Notepad.

New System, pertains to the Computerized Sales and Inventory System.

10

http://www.businessdictionary.com/definition/information.html

http://www.investorwords.com/9654/extract.html

http://www.businessdictionary.com/definition/respondent.html

http://www.businessdictionary.com/definition/asked.html

http://www.businessdictionary.com/definition/survey.html

http://www.businessdictionary.com/definition/research.html

http://www.investorwords.com/10198/list.html

http://en.wikipedia.org/wiki/Companies_law

Non-VAT Registered: are the businesses who do not qualify to gain income greater than Php

1,500,000.00 in a 12 month period.

Payback Period is a financial metric that answer the question: How long does it take for an

investment to pay for itself? Or, how long does it take for incoming returns to cover costs? Or,

put still another way: How long does it take for the investment to break even?

Payment Term. Net 30 days is the most common payment term and simply means that the

customer must pay the invoice within thirty days.

Physical Count Inventory, the actual count of the inventory on hand at the end of the month or

year.

Revenue: Total sales during a stated period.

Sales: the activity of selling a company's products or services, the income generated by this, or

the department that deals with selling.

Shipping Charges. You must specify who pays the shipping charges. This charge is usually paid

by the person ordering the goods.

Returns and Claims. Specify claims limitations, such as "Returns or damage claims are not

accepted unless made within ten days after Receipt of Merchandise."

Year-end: relating to the end of a financial or fiscal (tax) year.

11

Chapter III

Research Methodology

Overview

The Research was conducted to develop and create a Computerized Sales and Inventory

System that will solve problems arising from the Existing Manual way of recording and

computing the transactions. In order to solve the problems and to meet the objectives of this

study; the researchers conducted interviews, especially to the users of this system so that they

can tell directly what problems arise. The researchers also visited the main shop so that they can

experience and see the problems through observation by their naked eyes.

Research Design

The Descriptive method of Research is used for this study. To define the descriptive type

of research, Creswell (1994) stated that the descriptive method of research is to gather

information about the present existing condition which is the Manual System of Recording and

computing transactions and preparation of Reports. The Descriptive method of research is more

on describing rather than judging or interpreting what you observed. The aim of descriptive

research is to verify formulated hypotheses that refer to the present situation in order to elucidate

it. Moreover, this method allows a flexible approach, thus, when important new issues and

questions arise during the duration of the study, further investigation may be conducted.

Descriptive research on the other hand is a type of research that is mainly concerned with

describing the nature or condition and the degree in detail of the present situation. This method

is used to describe the nature of a situation, as it exists at the time of the study and to explore the

cause/s of particular a phenomenon. The aim of descriptive research is to obtain an accurate

profile of the people, events or situations. With this research type, it is essential that the

researcher already has a clear view or picture of the phenomena being investigated before the

data collection procedure is carried out. The researcher used this kind of research to obtain first

hand data from the respondents so as to formulate rational and sound conclusions and

12

recommendations for the study. The descriptive approach is quick and practical in terms of the

financial aspect.

Through this method the Researchers visited the area in order to observe and describe

the place, the way people do their Jobs, and how they handle their customers. Through this

observation relevant information was collected especially when the researchers conducted the

interview, each researcher raise their questions.

Research Instrument Used

The researchers use a questionnaire during the interview. The questionnaire is divided

into three parts namely; The Company background, Company’s Operation, and The Company’s

Sales and Marketing Practices. These questions are related to each part where they are classified.

(see Appendices I).

Research Procedure

The Researchers follow the Systems Development life Cycle in order to solve the

business problems. This cycle serves as the procedure of the whole proposal.

Phase 1 Identifying Problems Opportunities and Objectives:

In this phase the researchers do brainstorming, make questions that they think are

important to know, do some research about the company’s background and established goals that

must to be meet during the whole cycle of developing the system.

Phase 2 Determining information requirements:

In this part the Researchers will do the interview to management and the users, and then

they will observe how the company handles its customer. In this phase the researchers learned

the: who, what, where, when, and how, and why of the things that they want to know.

13

Phase 3 Analyzing System needs:

In this phase the researchers make the proposal and put into the paper the information

that they gathered from the previous Phase 1 to Phase 2. Then they will create data flow

diagrams of the existing system and the propose one.

Phase 4 designing the recommended system:

Design the user interface.

Design output.

Design input.

Design system controls.

Design files and/or database.

Produce program specifications.

Produce decision trees or tables.

Phase 5 developing and documenting software

• Design computer programs using structure charts, Nassi-Schneiderman charts, and

pseudocode.

• Walkthrough program design.

• Write computer programs.

• Document software with help files, procedure manuals, and Web sites with Frequently

Asked Questions.

Phase 6 testing and maintaining the system

• Test and debug computer programs.

• Test the computer system.

• Enhance system.

14

Phase 7 implementing and evaluating the system

• Plan conversion.

• Train users.

• Purchase and install new equipment.

• Convert files.

• Install system.

• Review and evaluate system.

15

Chapter IV

Presentation of Data

Presentation of the Existing System

Binuatan Creation Showroom manages to use a manual system of recording and

computing the day to day transactions. The company handles it sales in to forms the Accounts

Receivable through Orders and in cash through direct purchase of their product on their

Showroom. In Accounts Receivable Form the customer will order products through calls, e-mail

and face-to-face to manager, the manager writes the details of the product orders with their

corresponding amounts, the manager can give discounts depending on the size of the orders, after

this stage the customer will give 50% of the amount of orders as an installment or in cash,

depending on their agreement. In Cash through direct purchase of their products on their

showroom, the seller will compute the amount of the product then write it on the yellow paper

next to the Official Receipt (OR) and last to the Record Book, were she writes also the number

of the products sold corresponding to names and types of each which one of the bases of the

items sold for the monthly inventory. The record book also shows the name of the Tour guides

and Drivers of the van that delivers customers and visitors. The record book also contains the

corresponding number of the visitors that purchased the product of Binuatan creations. The total

sales will multiply to 6% and will be divided to the number of Tour guide and driver and that

will be the basis of their Christmas bonus or “pamasko” and it will directly deducted to the

Yearly Sales of the Showroom. After the Recording of these sales the seller at the end of the day

tallies the total sale for the whole day and she will remit it to the manager which is also the

owner of the entity. The manager will check the computed amounts and after checking she will

store it in a file cabinet. At the end of the month the seller with other employees will do the

inventory so that they can confirm the correctness of the sales with inventory and the total

“Pamasko” for the drivers and tour guides. After this the manager will compute the month’s sale

to prepare the monthly reports. The same thing also goes with the preparation of annual reports.

16

Presentation of the Proposed System

The researchers will design a system that will minimize or lessen human effort that will

eventually increase the employee’s productivity.

The system is a DOS-based where the interface is a black and white and the main thing in

inputting or storing the transactions is through typing and entering. There are four major parts of

the system the Accounts Receivable Function, Sales Function, Inventory Function, and last the

Report Function.

The Accounts Receivable Function is design for inputting the name of the customer with

their corresponding address, mode of payment, mode of transaction, contact numbers, product

description, type of delivery, terms of delivery and discounts. By inputting the amounts and

discounts it will show the amount of discount and the total amount that the customer must pay.

The Sales Function is the main interface for the showroom; in this function you will enter

the product number that will show the name of the product and other descriptions. The user must

also input the numbers of items sold, and address. This function will compute the total amount of

the products sold, and will release the Official Receipt. This function will not compute the VAT

of the products because the business is a Non-VAT Registered means the annual income does

not exceed Php 1,500,000.00.

The Inventory function will show the total items sold and available for sale for the whole

day and for the month with their corresponding amount of inventory. This function shows what

product is most purchased and the least.

The last major function is the Report Function that will show three sub functions the

Report for Accounts Receivable, Reports of Sale and Inventory Reports. Under this sub

functions there is another functions, the user must choose the type of report she will see, the

Ending Day Report, Monthly Report and lastly the Annual Report after inputting the right

queries the user can know able to see and print the report that she needs.

17

Hardware Requirement

Processor: AMD Athlon dual core

Memory: RAM: 1 GB or higher

Hard disk: Minimum hard drive Space required: 60MB

DVD-ROMRW

1 Unit 19’ Qube Flat Screen Monitor

1 Unit of 500V Automatic Voltage Regulator

1 Unit QWERTY Keyboard

1 Unit Optical mouse

1 Unit Canon Inkjet printer

1 Unit UPower Source (UPS): 1000V

Software Requirement

Binuatan Creation Computerized Sales and Inventory System.

Application Software: Microsoft Word 2003/2007

Operating System: Microsoft XP or higher.

Computer Language: Dev C++

Database: MySQL server 5.0

18

User Requirement

This proposal, only allows two users, the cashier of the showroom, and the manager

itself. After the training that will be conducted they will easily remember how to use the system.

The head of the showroom/seller is only allowed by the system to enter the sales function only

and the daily sales report for the report function. He or she is not allowed to inter other functions

of this system. The manager is allowed to enter any function that she wishes.

COST-Benefit Analysis

Manual System

Cost

Yellow Pad Paper ( Excellent 80 leaves)

Quarterly 4pcs.@php 20

P 80, 000

Notebook (ordinary 80 leaves)

Semiannually 2pcs.@php 11

22, 000

Ballpen (any available ballpen)

*not consistent, it depends. More or less

quarterly.

24, 000

Record book ( 80 leaves)

Semiannually 2pcs.@php 61

122, 000

19

Computerized System

Cost-Development Notes

Training Cost and Other Training Expenses 1 Php 2,696.00

Programmer’s Fee 5,000.00

Total Development Cost: Php 7,696.00

Cost-Operational for 1 year of Usage of this system.

Supplies Expense 2 Php 2,505.00

Hardware Maintenance 3 1,500.00

System Maintenance 4 1,800.00

Computer Acquisition Expense 5 21.980.00

Total Operational Cost: Php 27,785.00

Total Cost: Php 35,481.00

Tangible Benefits-Amounts are Estimated for a 5-year Operation Cycle.

Decrease in Supplies Expense. Php 10,000.00

Fast Generation of Reports. 10,000.00

Accurate Computation of Sales and Tally of

Inventory.

10,000.00

20

Increase Employees Productive Time. 20,000.00

Total Tangible Benefits Php 50,000.00

Intangible Benefits-Amounts cannot be estimated.

Notes Breakdown:

Note 1: Training Cost and Other Training Expenses TOTAL

Training Cost: Php 75/hr X 4hrs/day X 3day @ 2persons Php 1,800.00

Training Materials

Handouts Folders Php 12.00 @ 3pieces Php 36.00

Printing Php 2.00 X 3 copy @ 65 pages 390.00

Subtotal: Php 426.00

Training Kit Long Envelope Php 12.00 @ 3pieces 36.00

Notebook Php 7.50 @ 2pieces 15.00

Pencil Php 6.00 @ 3pieces 18.00

Eraser Php 5.00 @ 3pieces 15.00

Sharpener Php 6.00 @ 3pieces 18.00

Pilot Ball pen Php 21.00 @ 3pieces 63.00

Subtotal: Php 165.00

21

Transportation Expense First day of training due to the transportation of the

materials.50.00

Second and Third Day Php 10.00 @ 3way 30.00

Sub Total Php 80.00

Food and Drinks

Expense

Php 75.00 @ 3persons Php 225.00

TOTAL: Php 2,696.00

Note 2: Supplies Expense TOTAL

Bond Papers Short Php 125.00/rim @ 3/year Php 375.00

Long Php 204.00/rim @ 3/year 612.00 Php 987.00

Ink Refills Php 500.00/refill @ 3/year 1,500.00

TOTAL: Php 2,487.00

Note 3: Hardware Maintenance Php 500.00 @ 3/year Php 1,500.00

Note 4: System Maintenance Php 600.00 @ 3/year Php 1,800.00

Note 5: Computer Acquisition Expense; Window XP OS, and Microsoft

Office are Included as a package.

Qube Central Processing Unit (CPU) Hard disk 320GB

22

Processor: AMD Athlon dual

core- (combined CPU and

Processor

Php 10,750.00

19’ Qube Flat screen Monitor 7,000.00

500V Automatic Voltage Regulator (AVR) 500.00

a4tech Keyboard 380.00

a4tech optical mouse 250.00

Canon Inkjet printer 3,100.00

UPS: 1000V Uninterruptable Power Source 2,000.00

Total: Php 21,980.00

Comparison

The comparison of cost and benefit and its depreciation in 5years.

BENEFIT 50,000COST (35,481) 14,519

DEPRECIATION (7696/5YEARS) (1539.2)TOTAL Php 12979.8

23

Chapter V

Summary, Conclusion, and Recommendation

Summary

These system proposal entitled “Binuatan Creations Computerized Sales and Inventory

System” is designed and develop to solve business problems that the company experience from

using the manual way of recording and storing transactions, Such as Loss of Data due to

mishandling of Records, Wrong computation of Sales due to the number of customers, estimated

50 to 100 people that produce lines on the counter, Delayed preparation of Reports due to

manual counts of the items and Errors in Computation and Decreasing Employees Productive

Time due to manual counts and computation. These are the problems that the researchers

discovered through their data gathering phase.

The data gathering phase is the stage where the researchers gathered the data through

interview and observation in the area. The researchers used these methods in generating the

needed data. Aside from these methods the researchers also used some available materials on

their hand so that even before the interview they know some information about the business.

These materials are magazines and articles from the internet.

The researchers used the System Development Life Cycle (SDLC) in developing this

proposal which is the systematic approach of solving business problems. Through this cycle the

researchers was able to solve the problems and to make the system more reliable and accurate in

producing outputs such as reports in a timely bases, prevent data loss, solve computing errors, to

serve the customer faster than the past, to minimize human efforts and to increase the employees

productive time in more important jobs. This system proposal will eventually replace the existing

manual system of the said business.

24

Conclusion

The Researchers therefore conclude that this system proposal entitled “Binuatan

Creations Computerized Sales and Inventory System” would be more efficient and effective in

recording, storing and generating of reports. This proposal also concludes that the company can

maximize profit and therefore minimize cost by using this system in long run, In contrast with

the manual system.

Recommendation

This research study suggests that the Binuatan “Creation” should replace the manually

operated system by this new system entitled “Binuatan Creations Computerized Sales and

Inventory System”, in order to achieve the conclusion of this study.

The researchers suggest that the user‘s aside from attending the training he/she should

have at least basic knowledge regarding the programming language that this system is made of,

the C++ or Dev C because this has a black and white interface that is vey rare in this type of

Sales and Inventory System.

The researchers suggest that this system must be maintain and continue developing in

order to meet the needs of the business and also to compare it in other programming language

like Visual Basic, Java etc.

25

Bibliography

Unpublished Works

Bryan, Angelo C. et. al. “Danny Agricultural Supply Sales and Inventory System” (Syst.

Proposal, P.S.U.-C.B.A., Tiniguiban, October 2009).

Grimpola, Marlon Roy B. et. al. “PSU Canteen Automated Inventory and Sales Management

System” (Syst. Proposal, P.S.U.-C.S., Tiniguiban, March 2009).

Lopez, John Dale A. et. al. “Puerto Princesa Auto Supply Inventory and Sales Management


Alcantara, Ruby Jane M. et. al. “PSU Bookstore Automated Sales and Inventory Control


Magazines

Prieto, A. “Wild Weaves.” Smile, February/March, 2008, 47-48.

Materials through Internet

Shuttleworth, Martyn. “Descriptive Research Design.” experiment-resources. 2003.

<http://www.experiment-resources.com/descriptive-research-design.html>

“Define a Sales and Inventory System.” eHow Money. 3 September 2011

<http://www.ehow.com/info_7758579_define-sales-inventory-system.html>.

26

Appendices

27

`A. Company Background:

A.1. Binuatan Creations Mission:

The Mission of Binuatan Creation Handloom Weaving passionately, produces well-

created-globally competitive, innovative, quality and diverse handicraft products made of

indigenous materials that are endemic in Palawan which creates excitement to its buyers

worldwide.

Each Product is carefully and beautifully done by our women-mothers, out of school

youths and working students.

It commits itself to high standards of integrity in contributing to the best of interest of our

customers and employees while providing for a sustained financial growth and a fair return to its

owner.

Mrs. Eva T. Valledor

28

A.2. Binuatan Creations List of Products

A.3. Binuatan Creations Products Snap shots:

B. Dataflow Diagram – Existing

C. Dataflow Diagram – Proposed System

D. Flowchart Symbols

E. Program Flowchart

F. Data Dictionary

G. Sample Output

H. User’s Guide

I. Interview Questionnaire

J. Communication Letters

K. Source Codes

29

Curriculum Vitae

30

Personal Data

Name: Harry C. Tesorio

Gender: Male

Address: Purok Silangan, Brgy. Tagburos Puerto Princesa City

Email Address: [email protected]

Status: Single

Birthday: February 28, 1993

Birthplace: Puerto Princesa City, Palawan

Height: 5’7

Weight: 143 lbs.

Citizenship: Filipino

Religion: Roman Catholic

Parents

Tesorio, Eduardo G.

Tesorio, Nelly C.

Educational Background:

Tertiary: BSBA Management Accounting

Palawan State University

Puerto Princesa City

June 2009 - Present

Secondary: San Jose National Highschool

Lomboy St. Brgy. San Jose


April 2009

Elementary: Tagburos Elementary School

Brgy. Tagburos


April 2005

Personal Data31

Name: Sheila May M. Arizabal

Gender: Female

Address: Escano St. Brgy. Tiniguban Puerto Princesa City


Status: Single

Birthday: May 19, 1993

Birthplace: Cuyo, Palawan

Height: 5’5

Weight: 98 lbs.



Parents

Arizabal, Ramil C. Fisherman

Arizabal, Jean Lucia M. Teacher





June 2009 – Present

Secondary: GAMNHS Bisucay

Balading, Cuyo Palawan

April 2009

Elementary: Funda Elementary School

Funda Cuyo Palawan

April 2005

Personal Data

Name: Shelley Mae N. Baaco32

Gender: Female

Address: 43-C Interior Liberty road Puerto Princesa City


Status: Single

Birthday: August 6, 1992

Birthplace: Puerto Princesa City, Palawan

Height: 5’5

Weight:



Parents

Baaco, Celso A.

Baaco, Virginia N.




Puerto Prinsesa City


Secondary: Holy Trinity College

Quezon Street Puerto Princesa City Palawan

Elementary: Palawan State University

Burgos St.

April 2005

Personal Data

Name: Riza S. Baral33

Gender: Female

Address: Kalye Seksi Brgy. Tiniguiban Puerto Princesa City


Status: Single

Birthday: July 21, 1992

Birthplace: Brgy. Bugsuk, Balabac Palawan

Height: 5’4

Weight: 55 kg



Parents

Baral, Salvador S.

Baral, Marina S.






Secondary: Bugsuk National High School

Brgy. Bugsuk, Balabac Palawan

Elementary: PMPECS

Brgy. Bugsuk Balabac Palawan

Personal Data

Name: Mary Cris Q. Favila

34

Gender: Female

Address: Pineda Street Brgy. San Pedro PPC,Palawan


Status: Single

Birthday: December 8, 1990

Birthplace: Cagayancillo Palawan

Height: 5’2

Weight: 43



Parents

Favila Ely B.

Favila, Obelia Q.






Secondary: Cagayancillo National High School

Cagayancillo,Palawan

Elementary: Cagayancillo Central Elementary School

Cagayancillo,Palawan

35

binuatan creations

Documents