Tuesday, July 31, 2012

SYSTEM INFORMATION FOR AGENCY AND CHARTERER OR SHIPOWNERS

COOMING SOON!!!
SYSTEM INFORMATION FOR AGENCY AND CHARTERER OR SHIPOWNERS


BY: GEDE WAHYU YOGA DANA


GUI RELEASED!!



DETAIL DESCRIPTION WILL BE PRESENT LATER...



DESAIN LOKASI JASA PENCUCIAN MOTOR YANG RAMAH LINGKUNGAN


DESAIN LOKASI JASA PENCUCIAN MOTOR YANG RAMAH 
LINGKUNGAN DENGAN PENAMBAHAN ALAT PENYARING LIMBAH
Coba kita simak setiap hari pasti jasa pencucian motor di Indonesia ini tidak pernah sepi. Selalu saja ada pelanggan bahkan seringkali mengantri antara 30 menit – 1 jam. Hal ini terjadi karena pengguna sepeda motor di Indonesia sangatlah banyak, mungkin hampir sama ataupun lebih dari jumlah penduduk Indonesia. Tak heran bila jasa pencucian sepeda motor selalu ramai setiap hari. Roda ekonomi pun berputar dengan pesatnya, mulai dari tukang cuci, penyedia sabun cuci, dan pemilik lokasi cuci motor kebagian dollar J.
Namun, ada satu hal terlewatkan. Lingkungan kita kebagian limbahnya, kebagian limbah sabun hasil mencuci motor. Beberapa puluh tahun kemudian anak cucu kita yang menanggung dosa kita.
Untuk itu marilah berpikir bersama mengenai judul artikel ini. Desain lokasi jasa pencucian motor yang ramah lingkungan. Aliran air bekas cucian motor tidak langsung dibuang ke selokan namun ditampung dulu untuk diolah. Saya yakin ada teknologi pengolahan sederhana yang bisa diaplikasikan untuk hal ini.
Sekian dulu untuk artikel ini, selanjutnya akan dibahas cost benefit analysis dari aplikasi ide ini dan bagaimana cara mengubah paradigma masyarakat sehingga mau membayar lebih untuk jasa pencucian motor yang ramah lingkungan.
THIS IS NOT JUST AN IDEA, ITS SIMPLE AND APLICABLE
PERUBAHAN BELUM TENTU MENGHASILKAN KEMAJUAN
TAPI TANPA PERUBAHAN KITA TIDAK AKAN MENUJU PEMBAHARUAN
Cheerrss…

Sunday, July 29, 2012

Spreadsheet-Based Decision Support System for Inventory Management and Ship Scheduling


Optimization - Based Decision Support System 
for Inventory Management and Ship Scheduling

ABSTRACT



In order to distributing product in Indonesia which is archipelago country, company has to use waterway transportation, one of which is ship. By the company, the ship is used to fulfill and replenish warehouse on several islands in Indonesia. In this condition, charter scheme which company usually used to operate the ship is time charter. Scheduling ship with time charter scheme must be proper to avoid low utility which result in high distribution costs. Currently ship scheduling has been done manually using spreadsheet based on the planner knowledge and experience. This makes the planning time become long and exhausting. Besides that, the costs incurred is not evaluated well, thus the distribution costs become high. They rarely use the functions and features in spreadsheet, though there are many features in spreadsheet that when combine will be very helpful for the planner to arrange schedule and decide scenario that is used.

The purpose of this research is to make an integrated system between inventory management and ship scheduling. The inventory and forecast data at each warehouse which available in company enterprises resources planning (ERP) software is linked to Ms. Excel spreadsheet using SQL Server. Then the planner can arrange the planning base on this inventory and forecast data. The result of this research is spreadsheet-base decision support system (DSS) for inventory management and ship scheduling. By using this DSS, planner can decrease planning time, more accurate planning, better decision, and optimize the distribution costs.

Keyword: Inventory, Ship, Scheduling, Spreadsheet, DSS