Claim Missing Document
Check
Articles

SPREADSHEET BASED BUSINESS DECISION MAKING SYSTEM (CASE STUDY IN BONOROWO LAND, LAREN, LAMONGAN) Desrina Yusi Irawati; David Andrian; Albertus Daru Dewantoro
Spektrum Industri Vol. 18 No. 2: October 2020
Publisher : Universitas Ahmad Dahlan Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.12928/si.v18i2.16967

Abstract

Bonorowo land in Laren Subdistricts, Lamongan Districts, is one of the areas that uses its land for rice, corn and kenaf cultivation. The agricultural sector in Laren does not yet have a detailed economic analysis. Farmers ignore the importance of considering initial capital and some “small” costs in this activities. Therefore, in this study, the calculation of business feasibility was carried out on rice, kenaf, and corn farmer groups in Bonorowo land, West Laren. Business feasibility analysis is conducted through calculation of the value of NPV, IRR, and IP. The calculation system uses a Microsoft Excel spreadsheet formula. The NPV, IRR, and PI values of corn cultivation are Rp. 524,182.40; 144.43%; and 2,9. The NPV, IRR, and PI values for kenaf cultivation are Rp. 1,145,532.39; 266.43%; and 5.15. The NPV, IRR, and PI values for rice cultivation are Rp. -495,085.78; -25.18%; and -0.79. The results of the economic analysis of the cultivation of rice, corn, and kenaf in Bonorowo land, Laren Subdistrict, show that rice cultivation has caused losses and is not feasible to continue.
Sentiment Analysis about Electric Motorbikes in Indonesia Using Twitter Data Desrina Yusi Irawati; Agrienta Bellanov; Florencia Agatha Damayanti
Spektrum Industri Vol. 22 No. 1 (2024): Spektrum Industri - April 2024
Publisher : Universitas Ahmad Dahlan

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.12928/si.v22i1.158

Abstract

Along with the rapid development of technology, various types of transportation have experienced increased innovation in shapes, colours,models, and even engines. However, one thing that needs special attention is the number of pollutants or emissions released by vehicles. One effort to reduce emissions is increasing the production of Battery-Based Electric Motorized Vehicles. Battery-based electric vehicles developed in Indonesia include electric cars and electric motorcycles. Among these types of electric vehicles, Indonesian society widely adopts electric motorcycles. However, sales of electric motorbikes were only 15 thousand units, lower than sales of petrol motorbikes which reached 5 million units. This study contributes to understanding further how the community responds to electric motorcycles in detail through sentiment analysis on social media data. Consumer acceptance of electric motorcycles can be seen from the numerous active Twitter users in Indonesia who provide positive and negative comments on the presence of electric motorcycles. Text information based on public comments in Indonesia via Twitter is collected using Sentiment Analysis in R Studio. Twitter comments will be classified into positive, negative, and neutral groups. The results show 63% positive, 21% unfavourable, and 14% neutral opinions. This condition means that Indonesian society accepts and has a supportive opinion of the presence of electric motorcycles. The government and entrepreneurs can use this information to create electric motorcycles that align with the community's preferences.
Integrasi Quality Function Deployment (QFD) dan Conjoint Analysis untuk Mengetahui Preferensi Konsumen Desrina Yusi Irawati; Moses Laksono Singgih; Bambang Syarudin
Jurnal Optimasi Sistem Industri Vol. 13 No. 2 (2014): Published in October 2014
Publisher : The Industrial Engineering Department of Engineering Faculty at Universitas Andalas

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.25077/josi.v13.n2.p618-640.2014

Abstract

The advantages of QFD is to translate customer need into a technical response. But QFD has some disadvantages related to the difficulties in distinguishing the difference of needs between consumers, difficulties to fulfill the needs of different consumer groups, and the exietence of conceptual gap between consumers and companies. The proposed method to overcome these disadvantages is conjoint analysis. The main advantage of conjoint analysis is the ability to get the optimal design combination for products or services based on consumers' preference. The result of conjoint analysis, estimation of perceived value, and integration of QFD can be used to know the preference market needs among consumers, identify the office desk, determine consumer segments and technical respons, and estimate the additional price of office desk attributes as an effort to the development of the office desk. In overall the best Office desk combination results based on consumers' preference of Office desk is the white color without additional drawers or supporting features, with table size is 120x60x75 cm and footstool. Segmentation based on preferences resulting in three clusters, namely size, color, and availability of drawer. The highest technical response to be the company's priority in meeting the needs of consumers is to make the proper hole connection. Based on the perceived value, the company is capable to predict that the additional prices of 1 drawer is Rp.1-Rp.500.000, the addition price of 2 drawers is Rp.800,000 - Rp.900.000, and the addition price of the foundation of the foot is Rp.50.000 - Rp.150.000, and the additional price of supporting features is Rp.150.000-Rp.250.000.Keywords: Quality Function Deployment (QFD), conjoint analysis, segmentation and perceived value.AbstrakKeunggulan QFD adalah menterjemahkan customer need menjadi respon teknis. Namun QFD mempunyai kekurangan terkait sulit membedakan antara beragam kebutuhan konsumen yang bertentangan, sulit memenuhi kebutuhan konsumen yang berbeda kelompok, dan kesenjangan konseptual antara konsumen dan perusahaan. Untuk melengkapi kekurangan QFD, diusulkan metode conjoint analysis. Keunggulan utama conjoint analysis mampu mendapatkan kombinasi desain yang optimal untuk produk yang melekat pada preferensi konsumen. Hasil integrasi QFD dan conjoint analysis serta estimasi perceived value dapat mengetahui preferensi konsumen meja kantor, mengidentifikasi segmen konsumen meja kantor, menentukan respon teknis, dan mengestimasi harga penambahan atribut meja kantor sebagai upaya pengembangan meja kantor. Secara keseluruhan hasil kombinasi meja kantor terbaik berdasarkan preferensi konsumen meja kantor adalah warna putih, tidak membutuhkan penambahan fitur laci, tidak membutuhkan penambahan fitur pendukung, ukuran meja 120x60x75 cm, dan terdapat tumpuan kaki. Berdasarkan segmentasi preferensi terbentuk tiga klaster, yaitu klaster warna, klaster ukuran, dan klaster ketersediaan laci. Secara keseluruhan respon teknis yang menjadi prioritas perusahaan untuk memenuhi kebutuhan konsumen adalah pembuatan lubang sambungan yang tepat. Berdasarkan hasil perceived value, perusahaan dapat memperkirakan harga penambahan 1 laci berkisar Rp.1 - Rp.500.000, penambahan 2 laci adalah Rp. 800.000 – Rp. 900.000, penambahan tumpuan kaki Rp. 50.000 – Rp. 150.000, dan penambahan fitur pendukung Rp. 150.000-Rp. 250.000.
Simulasi Sistem Produksi Robochop Dasar dengan ARENA Purba, Lasman Parulian; Irawati, Desrina Yusi; Wulandari, Lusi Mei Cahya
JOURNAL OF INDUSTRIAL AND MANUFACTURE ENGINEERING Vol. 9 No. 1 (2025): EDISI MEI
Publisher : Universitas Medan Area

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31289/jime.v9i1.14535

Abstract

Dalam membuat produk terkadang diperlukan suatu perangkat lunak (tools) untuk menjelaskan proses yang terjadi, menganalisis proses dalam pembuatan produk dan bahkan mengusulkan suatu perbaikan dimana perlu. Simulasi komputer merupakan salah satu perangkat lunak (tools) yang lazim dipakai. ARENA merupakan salah satu piranti lunak (tools) yang dapat dipakai untuk menjalankan simulasi sistem produksi. Dalam penelitian ini, simulasi digunakan untuk menggambarkan sistem produksi Robochop Dasar. Dengan menggunakan simulasi ARENA, proses produksi Robochop Dasar dapat dianalisis dengan lebih mudah dan jelas, membantu dalam pemahaman durasi dan tahapan pembuatan produk tersebut. Hasil dari simulasi ini memberikan wawasan yang berguna, seperti identifikasi area yang memerlukan perbaikan untuk meningkatkan efektivitas dan efisiensi dalam pengelolaan sumber daya produksi. Selain itu, simulasi juga memungkinkan perbandingan antara hasil eksperimen dan hasil simulasi, yang dapat memberikan informasi tentang sejauh mana keduanya berbeda. Dengan demikian, penggunaan simulasi komputer dapat membantu dalam perencanaan dan pengambilan keputusan, serta mendukung upaya perbaikan berkelanjutan dalam sistem produksi Robochop Dasar.
Inovasi Dodol Buah Salak untuk Meningkatkan Kesejahteraan Petani Salak di Desa Bilaporah, Kabupaten Bangkalan Suryawati, Nany; Irawati, Desrina Yusi
Aksiologiya: Jurnal Pengabdian Kepada Masyarakat Vol 6 No 4 (2022): November
Publisher : Universitas Muhammadiyah Surabaya

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.30651/aks.v6i4.12770

Abstract

Peningkatan inovasi merupakan modal utama untuk mendorong pertumbuhan ekonomi yang lebih tinggi, berkelanjutan serta mensejahterakan secara adil dan merata. Salah satu cara pencapaian pertumbuhan ekonomi di desa adalah dengan melakukan pembinaan kelompok-kelompok dalam masyarakat desa. Di desa Bilaporah, Kecamatan Socah, Kabupaten Bangkalan, terdapat perkebunan salak yang memiliki potensi untuk dikembangkan. Ibu-ibu PKK pernah mengolah salak menjadi dodol salak. Namun usaha tersebut berhenti dikarenakan kurangnya motivasi masyarakat, dodok salak kurang awet, dan kemasan yang tidak menarik. Sesuai dengan kebiasaan masyarakat Indonesia yang gemar mengkonsumsi makanan ringan, maka dodol salak memiliki peluang untuk dikembangkan. Untuk permasalahan tersebut, solusi yang ditawarkan adalah memfokuskan pada cara memotivasi masyarakat untuk mau melanjutkan usaha mandiri, memberikan pelatihan mengolah dodol yang baik dan benar serta menambahkan natrium benzoate sehingga dodol awet, dan membuat desain label serta kemasan yang menarik. Tahapan pelaksanaan program pengabdian ini adalah tahap penentuan jadwal kegiatan, tahap pelaksanaan, penyuluhan dan pelatihan, monitoring dan keberlanjutan produksi.
PENDAMPINGAN USAHA MAKANAN AMAN DAN SEHAT PADA IBU-IBU KEMBANG KUNING MULYO, SURABAYA Irawati, Desrina Yusi; Widari, Nyoman Sri; Canariesa, Armadeo Ruben; Prastyo, Yohanes Okta Dwi
ABIDUMASY Vol 6 No 01 (2025): ABIDUMASY : JURNAL PENGABDIAN KEPADA MASYARAKAT
Publisher : Lembaga Penelitian dan Pengabdian kepada Masyarakat

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33752/abidumasy.v6i01.8808

Abstract

Women dominate food traders in the Kembang Kuning area. Most of the food businesses they run are small businesses carried out at home or around the grave area. The business activities carried out by Kembang Kuning Mulyo women are still relatively simple. Food products are only sold in front of the house using a table to place food. Unfortunately, traders pay little attention to hygiene standards, have limited knowledge of capital calculations and product cost, and refrain from using promotional media. The solution to overcome this problem is to provide education and practice regarding healthy and clean food business management, provide simple counseling regarding business finances, and help design promotional media such as banners or posters. Program implementation begins with problem identification, followed by implementing each activity according to plan, monitoring and evaluation, and assistance after completing the program. Through this service program, women can apply hygienic steps in every business process, calculate profits and losses from their merchandise, and have banners to beautify their stalls. Overall, this community service program ran smoothly. The partners showed high enthusiasm during the mentoring, as evidenced by their willingness to provide information, participate in counseling, and have active discussions.
Sentiment Analysis untuk Mengidentifikasi Faktor Penunjang Kesuksesan Feeder Wira Wiri Suroboyo Bellanov, Agrienta; Irawati, Desrina Yusi
Science Tech: Jurnal Ilmu Pengetahuan dan Teknologi Vol 11 No 2 (2025): August
Publisher : Universitas Sarjanawiyata Tamansiswa

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.30738/st.vol11.no2.a19400

Abstract

Traffic congestion is a major issue in Surabaya, a metropolitan city with a high rate of private vehicle growth. To address this problem, the Surabaya city government launched the Wira Wiri Suroboyo feeder service as a complement to the Suroboyo Bus mass transportation system. This study aims to identify public responses to the service through sentiment analysis of comments posted on the official Instagram account @wirawirisuroboyo. The methodology employed sentiment analysis and text mining techniques using R Studio software. Data were collected via web scraping from 230 comments and processed through data cleaning, tokenization, case folding, and stopword removal. The results show that 37% of comments were positive, 16% expressed trust, 10% were sad, and 8% were negative. A word cloud revealed dominant words such as "halte" (bus stop), "rute" (route), and "bisa" (can), reflecting the community’s need for better accessibility and service coverage. This research contributes as an evaluation input and recommendation for policymakers to improve the quality and distribution of Wira Wiri Suroboyo services, supporting a more inclusive and sustainable public transport system in Surabaya.