Troll Group (system Study) By Kating

Current Physical Model

Filling Cabinet

Filling Cabinet

Owner

Bookkeeper

Personnel / cashier

Supplier

Delivery Personnel

Customer

Current Logical Model

Filling Cabinet

Products reciept

Bookkeeper

Product receipt + Product

Supplier

Products receipt

Filling Cabinet

Products details

Personnel

Delivery Personnel

Payment

Purchased product

Reports of sold out products

product receipt

Cash + purchased details

Customer

Owner

The figure shown above is the current logical model of the system. It starts when the supplier gives the list of the product to the bookkeeper and generates report to be submitted

in

the

owner.

In

the

other

hand,

when

the

personnel received cash from the delivery personnel from its customer, the personnel will generates a report to be submitted in the owner.

AGUSAN DEL SUR STATE COLLEGE OF AGRICULTURE AND TECHNOLOGY

SYSTEM ANALYSIS AND DESIGN CORPUZ MERCHANDISE PRODUCT AND SALES RECORD SYSTEM

Submitted by: “TROLL GROUP” Michael Barol Catherin Bagaman Paul Jordan Santos Jerlyn Dela Cruz Jomar Etang

Submitted to: Ms. Charice Burillo Instructor

Context Diagram

Supplier

0 Reports daily sales and purchased product

Products receipt

CMPSRS

Owner

Product + payment

Product product details + payment

Purchased product receipt

Customer

The figure shown above or the context diagram contains the external entities of the new system which are the owner and customer. It starts when the supplier gives the list of the new supplies to he personnel, then the personnel will input data into the system. On daily sales transactions the personnel can make a report to be submitted to the owner.

CORPUZ MERCHANDISE PRODUCT AND SALES RECORD SYSTEM

Statement of the Problem: The Corpuz Merchandize System of daily stock record is incompletely automated because of separated record of sales and products. The personnel who managed the record of sales everyday used common software called Microsoft Excel while other personnel who managed the record of product everyday used only a record book. Although they accurately identified the sales of the product every day but it is easier to automate the records of the product, as well.

Specific Problem: The

following

are

the

common

problems

that

during inventory. 1. Time consuming in recording. 2. Unidentified broken/ damage products. 3. In accurate listing of daily products records.

occur

REVIEW OF RELATED LITERATURE

IVRS is an automated record inquiry system available only to established Record Inquiry Account Holders (RIAH). If

approved

for

an

account,

you

are

pre-qualified

to

receive record information. Account holders have access to DMV's

Interactive

Voice

Response

System

(IVRS). Advantages for IVRS users include 24-hour access to certain

driver

and

vehicle

record

information,

and

overnight turnaround time for prints ordered through the system.

Through

IVRS,

you

have

the

following

six

menu

choices: Listen to driver license name and address, description and status,

listen to vehicle description and ownership,

order a three-year non-employment driving record, order a complete or certified court print driving record,

order a

three-year

vehicle

employment

driving

record.,

order

a

record print. http://www.oregon.gov/ODOT/DMV/records/recinquiry_daveaccts .shtml#top

Defination in Terms

IVRS -

Interactive Voice Response System

RIAH -

Record Inquiry Account Holders

OBJECTIVES OF THE STUDY

General Objectives: This

study

aims

to

automate

completely

the

Corpuz

Merchandize in San, Teodoro, Bunawan Agusan del Sur.

Specific Objectives: 1. To improve timely and comprehensive reports. 2.

To minimized the time in inputting and processing of data in daily transactions.

3. To ensure the consistency of data.

SCOPE AND DELIMITAION OF THE STUDY

This study covers to completely automate the product and sales records of Corpuz Merchandize in San Teodoro, Bunawan Agusan del Sur, particularly the study focuses of combining for the damage, sold and remaining products.