Penerapan Metode Simplex Dengan Microsoft Excel (Solver) Untuk Optimalisasi Hasil Penjualan Tempe

  • Erny Untari Universitas PGRI Madiun
  • Indra Puji Astuti Universitas PGRI Madiun
  • Doni Susanto Universitas PGRI Madiun
DOI: https://doi.org/10.62775/edukasia.v4i1.307
Keywords: Metode Simplex, Maximisasi, Solver, Keuntungan

Abstract

Dalam dunia perdagangan masalah optimasi meliputi memaksimumkan keuntungan (maksimasi) atau meminimumkan biaya (minimasi), dimana keduanya dapat diselesaikan menggunakan metode simpleks. Tujuan penelitian ini adalah untuk memaksimalkan keuntungan produksi rumah tangga  tempe kedelai milik Ibu Kusmini yang beralamatkan di Desa Bulu, Kecamatan Sukomoro, Kabupaten Magetan dengan menggunakan metode simpleks. Penelitian ini dilakukan di rumah Ibu Kusmini selaku pemilik industri rumah tangga tempe kedelai. Analisis yang dilakukan dalam penelitian ini adalah analisis menggunakan metode simpleks dengan microsoft excel fungsi solver. Instrumen yang digunakan adalah observasi dan wawancara. Hasil penelitian menunjukkan banyaknya jumlah produksi optimum dari masing-masing produk (tempe ukuran kecil, sedang, besar) pada produksi rumah tangga  tempe kedelai milik ibu Kusmini sehingga memperoleh keuntungan maksimum.

Downloads

Download data is not yet available.

References

Hiller, S.F & Lieberman, G.J 1990. Introduction To Operations Reseach. (Gunawan, E &Mulia,AW). Jakarta: Erlangga
Mulyono, S. 2017. Riset Operasi: Jakarta: Mitra Wacana Media
Nitisusastro, M. 2010. Kewirausahaan & Manajemen Usaha Kecil. Bandung: Alfabeta
Nurmayanti, L. 2021. Implementasi Linear Programming Metode Simpleks Pada Home Industry. Jurnal Manajemen. Vol. 13 (3), 431-438
Rahmi, M. D. 2018. Program Linier. Yogyakarta: Deepublish.
Samsuriah. 2020. Metode Simpleks Dalam Program Linear Dengan Fungsi Solver di Excel. Progres (Profesional Jurnal in Integrity, Knowledge, and Skill), 12(1), 2-7
Sugiyono. 2013. Metode Penelitian. Bandung: Alfabeta
Ulfasari Rafflesia, S. M. 2014. Pemrograman Linier. Bengkulu: Badan Penerbit Fakultas Pertanian UNIB.
Published
2023-05-31
How to Cite
Untari, E., Astuti, I. P., & Susanto, D. (2023). Penerapan Metode Simplex Dengan Microsoft Excel (Solver) Untuk Optimalisasi Hasil Penjualan Tempe. EDUKASIA: Jurnal Pendidikan Dan Pembelajaran, 4(1), 567-574. https://doi.org/10.62775/edukasia.v4i1.307
Issue
Vol. 4 No. 1 (2023): Edukasia: Jurnal Pendidikan dan Pembelajaran
Section
Articles

Copyright (c) 2023 Erny Untari, Indra Puji Astuti, Doni Susanto

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

Please find the rights and licenses in EDUKASIA. By submitting the article/manuscript of the article, the author(s) agree with this policy. No specific document sign-off is required.

1. License

The non-commercial use of the article will be governed by the Creative Commons Attribution license as currently displayed on Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License. 

2. Author(s)' Warranties

The author warrants that the article is original, written by stated author(s), has not been published before, contains no unlawful statements, does not infringe the rights of others, is subject to copyright that is vested exclusively in the author and free of any third party rights, and that any necessary written permissions to quote from other sources have been obtained by the author(s).

3. User/Public Rights

EDUKASIA's spirit is to disseminate articles published are as free as possible. Under the Creative Commons license, EDUKASIA permits users to copy, distribute, display, and perform the work for non-commercial purposes only. Users will also need to attribute authors and EDUKASIA on distributing works in the journal and other media of publications. Unless otherwise stated, the authors are public entities as soon as their articles got published. 

4. Rights of Authors

Authors retain all their rights to the published works, such as (but not limited to) the following rights;

  • Copyright and other proprietary rights relating to the article, such as patent rights,
  • The right to use the substance of the article in own future works, including lectures and books,
  • The right to reproduce the article for own purposes,
  • The right to self-archive the article,
  • The right to enter into separate, additional contractual arrangements for the non-exclusive distribution of the article's published version (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal (EDUKASIA: Jurnal Pendidikan dan Pembelajaran).

5. Co-Authorship

If the article was jointly prepared by more than one author, any authors submitting the manuscript warrants that he/she has been authorized by all co-authors to be agreed on this copyright and license notice (agreement) on their behalf, and agrees to inform his/her co-authors of the terms of this policy. EDUKASIA will not be held liable for anything that may arise due to the author(s) internal dispute. JOSI will only communicate with the corresponding author.

6. Royalties

Being an open accessed journal and disseminating articles for free under the Creative Commons license term mentioned, author(s) aware that EDUKASIA entitles the author(s) to no royalties or other fees. 

7. Miscellaneous

EDUKASIA will publish the article (or have it published) in the journal if the article’s editorial process is successfully completed. EDUKASIA's editors may modify the article to a style of punctuation, spelling, capitalization, referencing and usage that deems appropriate. The author acknowledges that the article may be published so that it will be publicly accessible and such access will be free of charge for the readers as mentioned in point 3.