Article Per Year (5 Year)
p-Index From 2021 - 2026
1.756
P-Index
This Author published in this journals
All Journal JITK (Jurnal Ilmu Pengetahuan dan Komputer) JURNAL TEKNIK INFORMATIKA DAN SISTEM INFORMASI Explore IT : Jurnal Keilmuan dan Aplikasi Teknik Informatika GUYUB: Journal of Community Engagement LOGIC : Jurnal Ilmu Komputer dan Pendidikan Biner : Jurnal Ilmu Komputer, Teknik dan Multimedia AMMA : Jurnal Pengabdian Masyarakat JOKI: Journal of Computing and Informatics
Maulidiansyah Maulidiansyah
Teknologi Informasi, Universitas Nurul Jadid, Probolinggo, Indonesia
Religion Humanities Chemistry Civil Engineering, Building, Construction & Architecture Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Economics, Econometrics & Finance Education Electrical & Electronics Engineering Engineering Environmental Science Industrial & Manufacturing Engineering Law, Crime, Criminology & Criminal Justice Materials Science & Nanotechnology Mechanical Engineering Nursing Social Sciences Transportation Other

Published : 11 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 11 Documents
Search

 1   2 
Production Optimization of Refill Drinking Water Using Linear Programming and Excel Solver: A Case Study of AMIL Depot in Madura Maulidiansyah; Rohimatul Maisyaroh
JOKI: Jurnal Komputasi dan Informatika Vol 2 No 1 (2025): June 2025
Publisher : CV. Laskar Karya

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.65678/joki.v2i1.154

Abstract

In the era of data-driven decision-making and operational efficiency, the optimization of production processes has become vital for sustaining competitive advantage. AMIL, a leading refill drinking water brand in Madura, Indonesia, is striving to enhance its production profitability amidst increasing consumer demand and resource constraints. This study presents a linear programming-based approach using Microsoft Excel Solver to optimize the production planning of two key product variants 19-liter and 15-liter gallon refill bottles at the AMIL depot. By formulating an objective function that maximizes daily profit and incorporating constraints such as production capacity, raw material limitations, and market demand, the model identifies the optimal product mix. The results indicate that producing only the 19-liter variant under the given demand scenario (25 units/day) yields a maximum daily profit of IDR 150,000, while the 15-liter variant, under the same demand, yields a lower return of IDR 125,000. The optimal production ratio is thus determined to be 2:0 in favor of the 19-liter gallon. This study demonstrates the practical utility of Excel Solver as an accessible and effective decision support tool for small to medium-scale manufacturing operations. The findings offer actionable insights for resource allocation, cost minimization, and strategic production planning in the refill water industry. Furthermore, this approach may serve as a replicable framework for other enterprises seeking to optimize operational performance through linear programming.
Co-Authors Ahmad Firman Syahruddin Ahmad Maula Syahdifa Andhika Arya Bagaskara Asrofil Hidayatur Rahman Fathorazi Nur Fajri Hikmatul Wasidah Inayatul Maula Jamiatul Uhrowiyah Lailatul Ismi Miftahul Huda Moch Dzikri Hidayatullah Mochammad Faid Moh Novi Hermawan Mohammad Ainul Yaqin Syah Mohammad Samsuddin Muhammad Abdullah Aziz Muhammad Zulfa Zainul Muhsin Mukhlas Adi Putra Nanda Dwi Dzikrillah Nurul Faizin Nurul Hidayah Rizki Anwar Rohimatul Maisyaroh Roji Fayyumi sudriyanto sudriyanto Taufiq Hidayatullah Wahab Sya’roni Zainal Arifin Zhylal Al Fath