DESIGN AND BUILDING OF INFORMATION SYSTEM SALES AND PURCHASE FABRIC IN UD. SINAR MAKMUR PASAR ATUM

By : Hendranata S (26406072)

MAIN GOAL FOR MY FINAL PROJECT

Purpose of making this final project is to facilitate the purchase order transaction records, sales, purchases, purchase returns, making reports and listing of stocks with include making COGS base on computerized in UD. Sinar Makmur by making an application that could handle all that.

MAIN SCOPE AND LIMITATION

Sales , purchase, order and purchase retur Make Cost of Good Sold (COGS) with method first in

first out (FIFO) Opname Stock Profile employee Supplier Salary or wage Report Access rights Discount Etc.

ANALYSIS OF PROBLEMS UD. SINAR MAKMUR Did’n have list and record stoks. profit-loss calculations which were calculated

incorrectly because using the wrong formula. Spend much time for a monthly profit-loss

calculation because the calculation of total sales gained for a month and errors in manual calculations due to inaccurate or invoices stuck or lost without a cause known to be inaccurate yielded information. All of this until now is not efficient.

employees and owners have to memorize all the stocks of shop from the kinds of goods and the price of each item varies.

Making bill of sale is often not made if the situation in shop is very crowded.

ANALYSIS REQUIREMENTS (1)

Listing of purchase, sale, returns of goods and connected base on computerized inventory records.

Owner or employee does not need to memorize all the list prices of existing fabric. By looking at the contents of the database is sufficient.

Recording the existence of purchase orders on a program that has been created making it easier to conduct inspection of the goods owner who has to be sent whether in accordance with the orders. It is also useful to remind that order have been received or not.

ANALYSIS REQUIREMENTS (2)

Employee payroll done once a month at the end of the month and employee payroll data will be input into the database as a report salary to the owner.

The existence of calculating Cost of Goods Sold (COGS) to determine the selling price and profit - loss of the company. When COGS > selling price then the store will lose money.

The existence of user access group between owners and employees have different and can be changed in accordance with the desire owner.

The reports of sales, purchases, stock, profit-loss company, employee salaries, best seller and etc will be stored in a database.

DESAIN DFD (CONTEX DIAGRAM)

-Only 1 process-4 external entity

DESAIN DFD (LEVEL 0)

data gaji & pengolahan

data supplier

data discount

data penyesuaian stok

informasi barang

data pembelian

customer order

nota penjualan

data penjualan

laporan

nota pembelian

perusahaan order

nota retur pembelian

retur barang

pembelian

owner

pegawai

customer

supplier

1

pembuatan nota penjualan

2

pembelian

3

laporan

1data

pembelian2

data penjualan

3data retur pembelian

4data master

barang

7 data discount

9data user /

pegawai

10data

supplier

4

penyesuaian stok

6 data pembayaran

8 kartu stok

•4 process which relate each other

•Each process have different fungtion

DESAIN DFD (LEVEL 1 PURCHASE)

informasi pembayaran

data utang

data supplier

retur barang pembelianinformasi

retur pembelian

informasi barang

data order pembelian

purchase order

pengiriman barang

nota pembelian

supplier

1data

pembelian

4data master

barang

2.1

pembuatan order pembelian

2.2

penerimaan barang

owner

3 data retur pembelian2.3

retur barang

10 data supplier

2.4

pelunasan hutang

12 order pembelian

data retur pembelian

13 data pembayaran

14 kartu stok

-4 process-Each process have different fungtion.

DESAIN DFD (LEVEL 1 REPORT)

data biaya gaji pegawai

laporan-laporan

owner

2 data penjualan

1 data pembelian

4 data master barang

3 data retur pembelian 3.1

pembuatan laporan

5 data beban

3.2

pembuatan beban

11 data gaji pegawai

6 data pembayaran

8 kartu stokdata biaya telepon

data biaya pengolahan

-Frist process is making report-Second process is making expense

DESAIN KONSEPTUAL ERD

-There are 21 tables that relate- There is 1 tabel temporary (temp_retur)- there is 1 tabel that not relate (beban)

Total table used is 23 tables

PREVIEW PROGRAM (HOME PAGE)

IMPLEMENTATION

requiretment implementation : Computer with specifications :

Processor : Intel atom / pentium 4 or above.Memorry : 512 MBHardisk : 40 GBPrinter : size paper A4

Install Web Server using XAMPP Web browser with add-ons adobe reader

IMPLEMENTATION

Database conection (example)

<? 

$Hostname = "localhost";$DataBase = "sinarmakmur";$User = "root";$Pass = "";

 mysql_connect($Hostname,$User,$Pass) or

die("Problem"); ?>

IMPLEMENTATION

Syntax SQL database (example)

INSERT INTO table_name (column1, column2, column3,...)VALUES (value1, value2, value3,...)

UPDATE table_nameSET column1=value, column2=value2,...

WHERE some_column=some_value

DELETE FROM table_nameWHERE some_column=some_value

CONCLUSION

Each of the sales transaction, the owner can know how much a benefit. So, owner can provide the best price for customers and minimize errors of the selling price.

making reports include charts on best-seller reports useful for decision making process of purchasing goods and returns the next item.

Based on the questionnaire that was taken from the owner and employees can be concluded that overall the application is made is good enough and has a percentage value of about 88% , so it can be said this application was already meet the criteria of UD. Sinar Makmur.

SUGGESTIONS FOR THE FUTURE

Fore expected to be developed by making accounting information systems so that there is clearly the result of bookkeeping reports.

For employee attendance is expected to use the fingerprint to be more secure if necessary.