Tuesday, July 15, 2008

Enterprise Resource Planning (ERP)

Enterprise resource planning (ERP) is the planning of how business resources (materials, employees, customers etc.) are acquired and moved from one state to another.

An ERP system is a business support system that maintains in a single database the data needed for a variety of business functions such as Manufacturing, Supply Chain Management, Financials, Projects, Human Resources and Customer Relationship Management.

An ERP system is based on a common database and a modular software design. The common database can allow every department of a business to store and retrieve information in real-time. The information should be reliable, accessible, and easily shared. The modular software design should mean a business can select the modules they need, mix and match modules from different vendors, and add new modules of their own to improve business performance.

Ideally, the data for the various business functions are integrated. In practice the ERP system may comprise a set of discrete applications, each maintaining a discrete data store within one physical database.

Origin of the term

MRP vs. ERP-ENTERPRISE RECOURCE PLANNING — Manufacturing management systems have evolved in stages over the past 30 years from a simple means of calculating materials requirements to the automation of an entire enterprise. Around 1980, over-frequent changes in sales forecasts, entailing continual readjustments in production, as well as inflexible fixed system parameters, led MRP (Material Requirement Planning) to evolve into a new concept : Manufacturing Resource Planning (or MRP2) and finally the generic concept Enterprise Resource Planning (ERP)[1]

The initials ERP originated as an extension of MRP (material requirements planning then manufacturing resource planning) and CIM (computer-integrated manufacturing) and was introduced by research and analysis firm Gartner. ERP systems now attempt to cover all basic functions of an enterprise, regardless of the organization's business or charter. Non-manufacturing businesses, non-profit organizations and governments now all use ERP systems.

To be considered an ERP system, a software package must provide the function of at least two systems. For example, a software package that provides both payroll and accounting functions could technically be considered an ERP software package.

However, the term is typically reserved for larger, more broadly based applications. The introduction of an ERP system to replace two or more independent applications eliminates the need for external interfaces previously required between systems, and provides additional benefits ranging from standardization and lower maintenance (one system instead of two or more) to easier and/or greater reporting capabilities (as all data is typically kept in one database).

Examples of modules in an ERP which formerly would have been stand-alone applications include: Manufacturing, Supply Chain, Financials, Customer Relationship Management (CRM), Human Resources, Warehouse Management and Decision Support System.

Overview

Some organizations — typically those with sufficient in-house IT skills to integrate multiple software products — choose to implement only portions of an ERP system and develop an external interface to other ERP or stand-alone systems for their other application needs. For example, one may choose to use human resource management system from one vendor, and the financial systems from another, and perform the integration between the systems themselves.

This is very common in the retail sector[citation needed], where even a mid-sized retailer will have a discrete Point-of-Sale (POS) product and financials application, then a series of specialized applications to handle business requirements such as warehouse management, staff rostering, merchandising and logistics.

Ideally, ERP delivers a single database that contains all data for the software modules, which would include:

Manufacturing

Engineering, Bills of Material, Scheduling, Capacity, Workflow Management, Quality Control, Cost Management, Manufacturing Process, Manufacturing Projects, Manufacturing Flow

Supply Chain Management

Inventory, Order Entry, Purchasing, Product Configurator, Supply Chain Planning, Supplier Scheduling, Inspection of goods, Claim Processing, Commission Calculation

Financials

General Ledger, Cash Management, Accounts Payable, Accounts Receivable, Fixed Assets

Projects

Costing, Billing, Time and Expense, Activity Management

Human Resources

Human Resources, Payroll, Training, Time & Attendance, Rostering, Benefits

Customer Relationship Management

Sales and Marketing, Commissions, Service, Customer Contact and Call Center support

Data Warehouse

and various Self-Service interfaces for Customers, Suppliers, and Employees

Enterprise Resource Planning is a term originally derived from manufacturing resource planning (MRP II) that followed material requirements planning (MRP).[2] MRP evolved into ERP when "routings" became a major part of the software architecture and a company's capacity planning activity also became a part of the standard software activity.[citation needed] ERP systems typically handle the manufacturing, logistics, distribution, inventory, shipping, invoicing, and accounting for a company. Enterprise Resource Planning or ERP software can aid in the control of many business activities, like sales, marketing, delivery, billing, production, inventory management, quality management, and human resource management.

ERP systems saw a large boost in sales in the 1990s as companies faced the Y2K problem in their legacy systems. Many companies took this opportunity to replace their legacy information systems with ERP systems. This rapid growth in sales was followed by a slump in 1999, at which time most companies had already implemented their Y2K solution.[3]

ERPs are often incorrectly called back office systems indicating that customers and the general public are not directly involved. This is contrasted with front office systems like customer relationship management (CRM) systems that deal directly with the customers, or the eBusiness systems such as eCommerce, eGovernment, eTelecom, and eFinance, or supplier relationship management (SRM) systems.

ERPs are cross-functional and enterprise wide. All functional departments that are involved in operations or production are integrated in one system. In addition to manufacturing, warehousing, logistics, and information technology, this would include accounting, human resources, marketing, and strategic management.

ERP II means open ERP architecture of components. The older, monolithic ERP systems became component oriented.[citation needed]

EAS — Enterprise Application Suite is a new name for formerly developed ERP systems which include (almost) all segments of business, using ordinary Internet browsers as thin clients.[citation needed]

Advantages

In the absence of an ERP system, a large manufacturer may find itself with many software applications that do not talk to each other and do not effectively interface. Tasks that need to interface with one another may involve:

Change how a product is made, in the engineering details, and that is how it will now be made. Effective dates can be used to control when the switch over will occur from an old version to the next one, both the date that some ingredients go into effect, and date that some are discontinued. Part of the change can include labeling to identify version numbers.

Some security features are included within an ERP system to protect against both outsider crime, such as industrial espionage, and insider crime, such as embezzlement. A data tampering scenario might involve a disgruntled employee intentionally modifying prices to below the breakeven point in order to attempt to take down the company, or other sabotage. ERP systems typically provide functionality for implementing internal controls to prevent actions of this kind. ERP vendors are also moving toward better integration with other kinds of information security tools.[12]

Disadvantages

Problems with ERP systems are mainly due to inadequate investment in ongoing training for involved personnel, including those implementing and testing changes, as well as a lack of corporate policy protecting the integrity of the data in the ERP systems and how it is used.

Disadvantages

  • Customization of the ERP software is limited.
  • Re-engineering of business processes to fit the "industry standard" prescribed by the ERP system may lead to a loss of competitive advantage.
  • ERP systems can be very expensive leading to a new category of "ERP light" solutions
  • ERPs are often seen as too rigid and too difficult to adapt to the specific workflow and business process of some companies—this is cited as one of the main causes of their failure.
  • Many of the integrated links need high accuracy in other applications to work effectively. A company can achieve minimum standards, then over time "dirty data" will reduce the reliability of some applications.
  • Once a system is established, switching costs are very high for any one of the partners (reducing flexibility and strategic control at the corporate level).
  • The blurring of company boundaries can cause problems in accountability, lines of responsibility, and employee morale.
  • Resistance in sharing sensitive internal information between departments can reduce the effectiveness of the software.
  • Some large organizations may have multiple departments with separate, independent resources, missions, chains-of-command, etc, and consolidation into a single enterprise may yield limited benefits.
  • The system may be too complex measured the actual needs of the customer.


* source : http://en.wikipedia.org/wiki/Enterprise_resource_planning, 07/15/2008

Read More...

Monday, July 14, 2008

Data Flow Diagram (DFD) Sistem Informasi Penjualan Tiket Pesawat Online

Sebuah perusahaan penerbangan ”Colombus” ingin membangun sebuah Sistem Informasi Penjualan Tiket Pesawat Online (Web). Adapun prosedur penjualan tiket pesawat online yang akan diterapkan adalah sebagai berikut :

- Setiap customer yang akan melakukan pembelian tiket harus terlebih dahulu melakukan pendaftaran customer, karena setiap transaksi penjualan yang akan dilakukan harus melewati proses login terlebih dahulu.

- Apabila customer sudah melakukan pendaftaran, maka sistem akan memberikan login dan password supaya customer dapat melakukan pembelian tiket secara online.

- Untuk melihat jadwal penerbangan, customer dapat memilih menu schedule dan memasukkan data tujuan penerbangan (dari dan tujuan penerbangan) untuk mengetahui ketersediaan dan jam penerbangan tersebut.

- Apabila schedule telah didapatkan, customer dapat memilih menu e-booking availability untuk melakukan cek seat penerbangan.

- Apabila seat penumpang masih ada, maka customer dapat melakukan pembelian tiket pesawat dengan cara meng-click jadwal yang sesuai, dan sistem akan memberikan sebuah kode yang dipakai untuk melakukan pembayaran beserta nomer rekening untuk pembayaran tersebut.

- Kode yang diterima oleh customer akan dipakai untuk pembayaran lewat sebuah ATM dengan cara transfer ke nomer rekening yang telah disebutkan di web.

- ATM akan mengeluarkan sebuah slip yang didalamnya terdapat pin sepanjang 12 digit. Pin tersebut akan digunakan oleh customer untuk dimasukkan ke dalam menu Reconfirm yang ada pada halaman web, untuk membuktikan bahwa customer telah melakukan pembayaran.

- Slip yang didapat dari pembayaran di ATM harus disimpan oleh customer untuk ditukarkan dengan tiket pesawat di loket bandara saat akan melakukan penerbangan.

Dari cerita di atas, anda sebagai seorang tim pengembang sistem informasi, diminta untuk membuat Data Flow Diagram (DFD) mulai dari context diagram sampai dengan break down level detail sesuai dengan analisis anda.

Jawaban :


Context Diagram









DFD Level 1









DFD Level 2

1. Pendaftaran Customer









2. Pemesanan




Read More...

Monday, March 17, 2008

Basis data, DBMS dan Penerapannya dalam Industri

Basis data adalah adalah kumpulan informasi yang disimpan di dalam komputer secara sistematik sehingga dapat diperiksa menggunakan suatu program komputer untuk memperoleh informasi dari basis data tersebut.

Sedangkan sistem basis data adalah sistem yang terdiri atas sekumpulan tabel data yang saling berhubungan dan sekumpulan program (DBMS) yang memungkinkan berbagai user dan/atau program lain dapat mengakses dan memanipulasi tabel-tabel tersebut.

DBMS (Database Management System) atau dalam bahasa Indonesia biasa disebut SMBD (Sistem Manajemen Basis Data) adalah kumpulan program yang digunakan oleh user untuk memanajemen database (create, maintain). Atau dengan kata lain suatu sistem atau perangkat lunak yang dirancang untuk mengelola suatu basis data dan menjalankan operasi terhadap data yang diminta banyak pengguna.

Komponen utama DBMS dapat dibagi menjadi empat macam :
1. Perangkat keras,
2. Data, Data dalam basis data mempunyai sifat terpadu (integrated) dan berbagi
shared)
3. Perangkat Lunak,
4. Pengguna.

MODEL BASIS DATA

1. Model Hirarkis / Model Pohon
2. Model Jaringan
3. Model Relasional

Model Relasional merupakan model yang paling sederhana sehingga mudah digunakan dan dipahami oleh pengguna, serta merupakan model yang paling populer saat ini.Model ini menggunakan sekumpulan tabel berdimensi dua ( yang disebut relasi atau tabel ), dengan masing-masing relasi tersusun atas tupel atau baris dan atribut.
DBMS yang bermodelkan relasional biasa disebut RDBMS (Relational Data Base Management System).

Contoh produk DBMS yang menggunakan model relasional adalah :
1. Sybase --> Sybase Inc.
2. Oracle --> Oracle Corp.
3. MsSQL Server --> Microsoft Corp.
4. Informix --> Informix Corp.
5. Ingres --> ASK Group Inc.
6. DB2 --> IBM

> Oracle
Basis data Oracle adalah basis data relasional yang terdiri dari kumpulan data dalam suatu sistem manajemen basis data RDBMS. Perusahaan perangkat lunak Oracle memasarkan jenis basis data ini untuk bermacam-macam aplikasi yang bisa berjalan pada banyak jenis dan merk perangkat keras komputer (platform).Basis data Oracle ini pertama kali dikembangkan oleh Larry Ellison, Bob Miner dan Ed Oates lewat perusahaan konsultasinya bernama Software Development Laboratories (SDL) pada tahun 1977. Pada tahun 1983, perusahaan ini berubah nama menjadi Oracle Corporation sampai sekarang.

>
Microsoft SQL Server
Microsoft SQL Server adalah sebuah
sistem manajemen basis data relasional (RDBMS) produk Microsoft. Bahasa kueri utamanya adalah Transact-SQL yang merupakan implementasi dari SQL standar ANSI/ISO yang digunakan oleh Microsoft dan Sybase. Umumnya SQL Server digunakan di dunia bisnis yang memiliki basis data berskala kecil sampai dengan menengah, tetapi kemudian berkembang dengan digunakannya SQL Server pada basis data besar.

Microsoft SQL Server dan Sybase/ASE dapat berkomunikasi lewat jaringan dengan menggunakan protokol TDS (Tabular Data Stream). Selain dari itu, Microsoft SQL Server juga mendukung ODBC (Open Database Connectivity), dan mempunyai driver JDBC untuk bahasa pemrograman Java. Fitur yang lain dari SQL Server ini adalah kemampuannya untuk membuat basis data mirroring dan clustering. Pada versi sebelumnya, MS SQL Server 2000 terserang oleh cacing komputer SQL Slammer yang mengakibatkan kelambatan akses Internet pada tanggal 25 Januari 2003.


Contoh penerapan DBMS di dalam industri.

Banyak sekali macam database yang digunakan di industri maupun perkantoran. Hampir semua industri dan perusahaan saat ini yang menggunakan database untuk menyimpan arsip2 penting usahanya. Salah satunya adalah Oracle yang banyak digunakan oleh kebanyakan perusahaan saat ini. Contoh yang paling banyak dijumpai adalah penggunaan database Oracle yang digunakan di perusahaan telekomunikasi. Oracle yang banyak digunakan di perusahaan telekomunikasi. Data2 pelanggan di simpan di dalam database. Database tersebut tidak hanya terletak hanya di kantor pusat, tapi juga mempunyai beberapa back-up. Jadi apabila ada salah satu database yang rusak, maka back-up dapat digunakan sebagai pengganti database yang rusak tersebut. Apabila perusahaan tersebut tidak mempunyai back-up, maka dapat di prediksikan kalau perusahaan tersebut akan mengalami kerugian yang sangat besar bahkan bisa bangkrut. Karena data2 yang ada di dalam database tersebut merupakan informasi2 pelanggan yang sangat penting. Maka perusahaan harus bisa menjaga dan mengamankan data2 pelanggannya tersebut.

Read More...

Sunday, March 16, 2008

Hmmm,,, akhirnya muncul lagi...

Hmmm,,, akhirnya gue muncul lagi di blogger setelah sekian lama gue gak muncul di blogger. Kali ne gue muncul dengan wajah baru, semangat baru, dan berita baru... *kaya' iklan aja*

wkwkwkwkwk...

Padahal sebenernya ne gara2 da tugas kul gue aktif lagi blogging. Tapi gue gak memungkiri kalo blogging emang asyik untuk share berbagai macam hal.

Gak dapat dipungkiri lagi kalo saat ini banyak orang yang memanfaatkan blogger untuk mencari keuntungan. Emang bener kata dosen gue kalo segala sesuatu yang berhubungan dengan jasmaninya pasti UUD (Ujung-Ujungnya Duit). Emang tuh dosen konyol banget...

Gue kira cukup segitu dulu pembukaan dari gue.

Wassalamualaikum...

Read More...

Sunday, January 13, 2008

What is SEO

SEO (Search Engine Optimization) is the art of increasing the ranking of your website on leading search engines. Old 'tricks of the trade' no longer work and can even reduce your rankings, especially after Google's recent Jagger Update.

Optimize My Site offers some useful advice as well as supporting services to jumpstart your efforts at achieving better search engine rankings. Better rankings = more traffic = more business.

More and more businesses are realizing that having a great website is not good enough if clients can't find it. If your competitors are being ranked higher on leading search engines such as Google, Yahoo, or MSN, then it is quiet likely that they are winning more business. Using some effective techniques, you can ensure that your site rankings are optimal.

Increasing traffic to your website is a fairly straightforward process, as long as key steps are followed in the correct order. There is no benefit in attempting to increase your web traffic if your website is not optimized for search engines. If search engines don't like your content or agree with the technology you have used your efforts will be in vain. So, first ensure that your website is optimized for search engins, then ensure that it has been submitted to all the major search engines, and then commence with link building and other initiatives to increase your website visibility on the Internet.-http://www.optimizemysite.co.za/-

Read More...