Transcript Perancangan dan Pembuatan Sistem Informasi Penjualan dan

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
supplier
nota
pembelian
customer
9
data user /
pegawai
retur
barang
pembelian
data retur
pembelian
3
data discount
nota retur
pembelian
perusahaan
order
owner
customer
order
data supplier
nota
penjualan
laporan
data gaji &
pengolahan
3
1
2
data
penjualan
8
7
2
pembelian
data
pembelian
kartu stok
6
4
data pembayaran
data master
barang
data
penjualan
pegawai
informasi
barang
1
data discount
10
data
penyesuaian stok
4
penyesuaian stok
•4 process which
relate each other
data
pembelian
laporan
pembuatan nota
penjualan
DESAIN DFD
(LEVEL 0)
data
supplier
•Each process have
different fungtion
DESAIN DFD (LEVEL 1 PURCHASE)
-4 process
-Each process have
different fungtion.
2.4
13
pelunasan hutang
data pembayaran
data retur pembelian
data supplier
informasi
pembayaran
owner
data order
pembelian
2.1
data utang
informasi
barang
2.2
pembuatan order
pembelian
12
purchase
order
10
data
pembelian
1
penerimaan barang
order pembelian
pengiriman
barang
data supplier
nota
pembelian
supplier
informasi
retur
pembelian
retur barang pembelian
14
kartu stok
4
2.3
retur barang
3
data retur pembelian
data master
barang
-Frist process is
making report
-Second process is
making expense
DESAIN DFD (LEVEL 1 REPORT)
8
kartu stok
owner
data biaya pengolahan
data biaya telepon
data biaya gaji
pegawai
laporan-laporan
4
data master barang
3
data retur pembelian
3.2
3.1
pembuatan beban
pembuatan laporan
2
data penjualan
1
data pembelian
11
6
data pembayaran
data gaji pegawai
5
data beban
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
Memorry
Hardisk
Printer
: Intel atom / pentium 4 or above.
: 512 MB
: 40 GB
: size paper A4
Install Web Server using XAMPP
 Web browser with add-ons adobe reader

IMPLEMENTATION

Database conection (example)
<?
$Hostname
$DataBase
$User
$Pass
= "localhost";
= "sinarmakmur";
= "root";
= "";
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_name
SET column1=value, column2=value2,...
WHERE some_column=some_value
DELETE FROM table_name
WHERE 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.