1 / 17

By : Hendranata S (26406072)

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.

reuel
Download Presentation

By : Hendranata S (26406072)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Design and Building of Information System Sales and Purchase Fabric in UD. Sinar Makmur Pasar Atum By : Hendranata S (26406072)

  2. 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 makingCOGS base on computerizedin UD. SinarMakmurby making an application that could handle all that.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. Desain DFD (contex diagram) • Only 1 process • 4 external entity

  8. Desain DFD (level 0) • 4 process which relate each other • Each process have different fungtion

  9. Desain DFD (level 1 purchase) • 4 process • Each process have different fungtion.

  10. Frist process is making report • Second process is making expense Desain DFD (level 1 report)

  11. 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

  12. Preview program (Home page)

  13. Implementation • requiretment implementation : • Computer with specifications : Processor : Intel atom / pentium 4 or above. Memorry : 512 MB Hardisk : 40 GB Printer : size paper A4 • InstallWeb Server using XAMPP • Web browser with add-ons adobe reader

  14. implementation • Database conection (example) <? $Hostname = "localhost"; $DataBase = "sinarmakmur"; $User = "root"; $Pass = ""; mysql_connect($Hostname,$User,$Pass) or die("Problem"); ?>

  15. 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

  16. 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.

  17. 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.

More Related