Abstract:This study aims to determine the effect of workload and competence on turnover intention with work stress as a mediating variable among Alfamart employees in South Gorontalo City. This research employed a quantitative approach…
proach with data collection conducted through questionnaires distributed to 62 respondents. Data analysis was carried out using inferential quantitative analysis with SEM-PLS 3.1. The results of the study indicate that: (1) workload has a positive but insignificant effect on turnover intention with an effect value of 7.80%; (2) competence has a positive and significant effect on turnover intention with an effect value of 27.90%; (3) workload has a positive and significant effect on work stress with an effect value of 37.60%; (4) competence has a positive and significant effect on work stress with an effect value of 51.80%; (5) work stress has a positive and significant effect on turnover intention with an effect value of 58.40%; (6) workload through work stress has a positive and significant effect on turnover intention with an effect value of 21.90%; and (7) competence through work stress has a positive and significant effect on turnover intention with an effect value of 30.20%. The R-square value of the turnover intention variable is 60.00%, indicating that turnover intention can be explained by the variables in this study, while the remaining 40.00% is influenced by other variables such as job satisfaction and compensation. The R-square value of work stress is 35.90%, while the remaining 64.10% is influenced by other variables such as the work environment.
Abstract:This study aims to examine the effect of the Current Ratio (CR) and Debt to Equity Ratio (DER) on stock returns, with the exchange rate as a moderating variable, in retail sub-sector companies listed on the Indonesia Stock…
ck Exchange during the 2019–2023 period. This research employed a quantitative approach using secondary data obtained from annual financial reports and stock price data. The sampling technique used purposive sampling, resulting in 25 companies with 125 observations. Data analysis was conducted using multiple linear regression and Moderated Regression Analysis (MRA). The results indicate that the Current Ratio has a negative and significant effect on stock returns, meaning that excessively high liquidity tends to reduce stock returns. Debt to Equity Ratio also has a negative and significant effect on stock returns, indicating that higher leverage increases financial risk and lowers investor confidence. Simultaneously, Current Ratio and Debt to Equity Ratio significantly affect stock returns. However, the exchange rate has no effect on stock returns. Furthermore, the exchange rate is unable to moderate the relationship between Current Ratio and stock returns, as well as between Debt to Equity Ratio and stock returns. These findings imply that internal company factors, particularly liquidity management and capital structure, are more dominant in influencing stock returns than external macroeconomic factors such as exchange rate fluctuations. Therefore, investors are advised to pay closer attention to financial fundamentals when making investment decisions in the retail sector.
Abstract:• DEF is a company engaged in the sale of coffee, both wholesale and retail. Currently, the sales recording system is still carried out manually, which often leads to problems such as delays in reporting, data entry errors,…
rors, and difficulties in retrieving historical information. This study aims to improve the efficiency and accuracy of the sales recording system by implementing the INDEX MATCH and SUMIFS functions in Microsoft Excel. The research method used is descriptive qualitative with a case study approach, involving observation, interviews, and documentation of the existing system. The results show that the use of INDEX MATCH and SUMIFS can accelerate the data retrieval process, improve the accuracy of sales reports, and reduce input errors. This study provides a practical solution for small and medium enterprises (SMEs) in implementing an efficient sales recording system without requiring significant investment in ERP software. However, the system still has limitations, such as dependence on Excel files that are vulnerable to damage or unintended changes, and the lack of advanced automation features such as receivables reminders or inter-departmental integration. Therefore, future research is expected to develop a web-based system with a centralized database.
Abstract:Under the guidance of Mr. Dedi Kusbiantoro, S.P., M.M. as chairman of the supervisory commission and Mrs. Hj. Henny Pratiwi, S.P., M.M. as a member of the advisory committee. The purpose of this study was to determine the…
e pattern of tofu marketing channels, to analyze tofu marketing costs, profits and margins; and to analyze the level of economic efficiency of each tofu marketing channel in Dolok Masihul District, Serdang Bedagai Regency. The choice of research location was done purposively. The sample in this study were 19 respondents who owned the tofu industry. Field research was conducted from March 2022 to April 2022. The method used is marketing margin analysis to determine differences in price levels in marketing channels, this study also uses farmer's share analysis to determine marketing efficiency. The results of the study concluded that the fried tofu housing industry in Dolok Masihul District has 2 (two). In marketing channel I, the total marketing cost is Rp. 30/ptg, the total marketing profit for retailers is Rp. 303.33/ptg, and the marketing margin is Rp. 83.33/ptg. For marketing channel II there is no marketing fee. On stock farmers that marketing channels I and II are included in the efficient category.
Abstract:Abstract: The development of information and communication technology has increased public demand for digital services, particularly data packages as the primary means of internet access. This high demand requires data package…
ackage retailers to manage inventory optimally to ensure product availability meets customer needs. At CMC Cell, the determination of data package stock is still based on intuition without systematic data analysis, resulting in stock accumulation for certain products and stock shortages for others when demand increases. This study aims to design and implement a web-based Decision Support System (DSS) using the Multi-Objective Optimization on the Basis of Ratio Analysis (MOORA) method to determine the optimal stock of data packages. The MOORA method is applied to rank data package alternatives based on several criteria, including data package demand, sales history, remaining stock, selling price, and validity period. Sales data are analyzed using the calculation stages of the MOORA method. The results show that the Telkomsel V 3 GB data package achieves the highest preference value of 0.1498 and is therefore recommended as the top-priority data package, with an optimal stock quantity of 200 units. With the implementation of this system, the recommendations for determining data package stock become more measurable, objective, and data-driven.
Keywords: MOORA; PHP; decision support system; optimal stock; stock priority
Abstrak: Perkembangan teknologi informasi dan komunikasi telah meningkatkan kebutuhan masyarakat terhadap layanan digital, khususnya paket data sebagai sarana utama akses internet. Tingginya permintaan tersebut menuntut pelaku usaha penjualan paket data untuk mampu mengelola stok secara optimal agar ketersediaan produk sesuai dengan kebutuhan pelanggan. Pada Toko CMC Cell, penentuan stok paket data masih dilakukan berdasarkan intuisi tanpa analisis data yang sistematis, sehingga sering terjadi penumpukan stok pada beberapa produk dan kekosongan stok pada produk lain saat permintaan meningkat. Penelitian ini bertujuan untuk merancang dan mengimplementasikan Sistem Pendukung Keputusan (SPK) berbasis web menggunakan metode Multi-Objective Optimization on the Basis of Ratio Analysis (MOORA) dalam menentukan stok optimal paket data. Metode MOORA digunakan untuk melakukan perangkingan alternatif paket data berdasarkan beberapa kriteria, yaitu permintaan paket data, riwayat penjualan, jumlah stok tersisa, harga jual, dan masa aktif. Data penjualan paket data dianalisis menggunakan tahapan perhitungan metode MOORA. Hasil penelitian menunjukkan bahwa paket data Telkomsel V 3 GB memperoleh nilai preferensi tertinggi sebesar 0,1498 sehingga direkomendasikan sebagai paket data dengan prioritas stok tertinggi, dengan jumlah stok optimal sebanyak 200 pcs. Dengan adanya sistem ini, rekomendasi penentuan stok paket data yang dihasilkan menjadi lebih terukur, objektif, dan berbasis data.
Kata kunci: MOORA; PHP; sistem pendukung keputusan; stok optimal; prioritas stok
Abstract:Abstract: Inventory managemet plays a strategic role in supporting the operational sustainability of retail businesses. Errors in determining the quantity of goods procured can lead to inventory buildup or stockouts, which…
ch impacts increased storage costs and reduced customer service levels. Attar Jaya store still uses a manual inventory management system, so the restocking recording and decision-making processes are not yet supported by an integrated and data-driven system. This condition has the potential to cause inefficiency in inventory management. This research aims to apply the concept of Electronic Supply Chain Management (E-SCM) integrated with the Economic Order Quantity (EOQ) method to determine the optimal order quantity of goods. The EOQ method is used to calculate the most economical order quantity by considering ordering and storage costs, while E-SCM plays a role in integrating inventory management processes digitally. The research methods include observation, interviews, and literature studies, with system design using the Unified Modelign Language (UML). The system was developed using the PHP programming language and the MwSQL database. The research result are expected to help Toko Attar Jaya improve the accuracy of resctocking decision-making, minimize the risk of overstocking and understocking, and increase the efficiency of inventory mangement.
Keywords: MySQL; PHP; e-supply chain management; economic order quantity; restock items
Abstrak: Manajemen persediaan memiliki peran strategis dalam mendukung keberlangsungan operasional usaha ritel. Kesalahan dalam menentukan jumah pengadaan barang dapat menyebabkan terjadinya penumpukan persediaan maupun kekurangan stok yang berdampak pada meningkatnya biaya penyimpanan seerta menurunnya tingkat pelayanan kepada pelanggan. Toko Attar Jaya masih menerapkan sistem pengelolaan persediaan secara manual, sehingga proses pencatatan dan pengambilan keputusan restok belum didukung oleh sistem yang terintegrasi dan berbasis data. Kondisi tersebut berpotensi menimbulkan ketidakefisienan dalam pengelolaan stok barang. Penelitian ini bertujuan untuk menerapkan konsep Electronic Supply Chain Management (E-SCM) yang terintegrasi dengan metode Economic Order Quantity (EOQ) dalam menentukan jumlah pemesanan barang yang optimal. Metode EOQ digunakan untuk menghitung jumlah pemesanan yang paling ekonomis dengan mempertimbangkan biaya pemesanan dan biaya penyimpanan, sedangkan E-SCM berperan dalam mengintegrasikan proses pengelolaan persediaan secara digital. Metode penelitian meliputi observasi, wawancara, dan studi literatur, dengan perancangan sistem menggunakan Unified Modeling Languge (UML). Sistem dikembangkan mengguanakan bahasa pemrograman PHP dan basis data MySQL. Hasil penelitian diharapkan mampu membantu pihak Toko Attar Jaya dalam meningkatkan akurasi pengambilan keputusan restok, meminimalkan risiko kelebihan dan kekurangan persediaan, serta meningkatkan efisiensi pengelolaan persediaan.
Kata kunci: MySQL; PHP; e-supply chain management; economic order quantity; restok barang
Abstract:Abstract: Semangat Store, a rapidly growing retail store in Kisaran, faces challenges in inventory management due to its manual system. Ordering is done by contacting suppliers individually, and sales data is recorded conventionally…
nventionally in a general ledger. As a result, the store often experiences overstock, which increases storage costs and the risk of damaged goods, or stockouts that can disappoint customers. To address these issues, this study aims to implement an integrated, web-based Supply Chain Management (SCM) system. This system is designed to accurately record inventory, manage demand, place orders in a timely manner, and support fast, data-driven decision-making. The system was built using the PHP programming language and a MySQL database. The implementation results show that the proposed SCM system is able to improve operational efficiency and inventory management accuracy at Semangat Store. Store owners can monitor sales and order reports directly, and the system provides notifications when inventory reaches the minimum limit. Thus, Semangat Store can reduce the risk of overstocking or understocking, increase profitability, and simplify the restocking process with suppliers through a more structured system.
Keywords: supply chain management (scm); stock management; information systems; semangat store
Abstrak: Toko Semangat, sebuah toko ritel yang berkembang pesat di Kisaran, menghadapi tantangan dalam pengelolaan stok barang karena masih menggunakan sistem manual. Proses pemesanan barang dilakukan dengan menghubungi pemasok satu per satu, dan pencatatan data penjualan masih dilakukan secara konvensional di buku besar. Akibatnya, toko sering mengalami kelebihan stok (over stock) yang meningkatkan biaya penyimpanan dan risiko kerusakan barang, atau kekurangan stok yang dapat mengecewakan pelanggan. Untuk mengatasi masalah ini, penelitian ini bertujuan untuk mengimplementasikan sistem Supply Chain Management (SCM) yang terintegrasi dan berbasis web. Sistem ini dirancang untuk mencatat stok barang secara akurat, mengelola permintaan, melakukan pemesanan secara tepat waktu, serta mendukung pengambilan keputusan yang cepat dan berbasis data. Sistem ini dibangun menggunakan bahasa pemrograman PHP dan database MySQL. Hasil dari implementasi menunjukkan bahwa sistem SCM yang diusulkan mampu meningkatkan efisiensi operasional dan akurasi pengelolaan stok barang di Toko Semangat. Pemilik toko dapat memantau laporan penjualan dan pemesanan secara langsung, dan sistem memberikan notifikasi jika stok barang mencapai batas minimum. Dengan demikian, Toko Semangat dapat mengurangi risiko kelebihan atau kekurangan stok, meningkatkan profitabilitas, dan mempermudah proses restock dengan pemasok melalui sistem yang lebih terstruktur.
Kata kunci: supply chain management (scm); pengelolaan stok; sistem informasi; toko semangat
Abstract:The COVID-19 pandemic has had a significant impact on many business sectors throughout the world, both large businesses and MSMEs. Mr. Selamat owns the Asahan Selasih Chips business, a souvenir business in the city of Kisaran…
saran that sells various types of processed chips, such as sweet potatoes, bananas, and other tubers. This company relies on direct sales from its production house and retailing at kiosks, minimarkets, and supermarkets in Kisaran, Asahan Regency. Also, they have to face the impact of the pandemic by surviving and trying to continue producing their products. One of the causes of declining sales during the post-COVID-19 pandemic is the need for promotional media to expand the market. Just expecting regular customers significantly influences declining sales because the economic turnover of the people in Asahan Regency is limited due to the impact of COVID-19. Apart from that, digital business competition is also a challenge for the Kisaran souvenir chips business.
Using observation methods and providing direct training to partner locations, implementing a website and e-catalog is essential for the Selasih Chips business in facing business challenges after the COVID-19 pandemic. Technology can help companies to improve operational efficiency, increase customer trust, and expand their markets in this digital era. Implementing a website and e-catalog can also help Pak Selamat expand its customer reach.
Keywords: website; e-catalog; umkm
Abstrak: Pandemi COVID-19 telah membawa dampak besar bagi banyak sektor bisnis di seluruh dunia, baik bisnis besar maupun UMKM. Bapak Selamat adalah pemilik usaha Keripik Selasih Asahan yaitu usaha oleh-oleh kota Kisaran contohnya yang menjual berbagai jenis olahan keripik seperti ubi, pisang, dan umbi-umbian lainnya, usaha yang mengandalkan penjualan langsung dari rumah produksinya dan mengecer ke kios-kios maupun minimarket dan supermarket yang ada di kota Kisaran Kabupaten Asahan, juga harus menghadapi dampak pandemi dengan bertahan dan berusaha untuk tetap memproduksi produknya. Salah satu penyebab menurunnya penjualan dimasa pasca pandemi COVID-19 dipengaruhi kurangnya media promosi untuk memperluas pasar. Hanya dengan mengharapkan pelanggan tetap, menjadi pengaruh besar terhadap menurunnya penjualan disebabkan perputaran ekonomi masyarakat di Kabupaten Asahan menjadi terbatas akibat dampak COVID-19. Selain itu persaingan bisnis secara digital juga menjadi tantangan tersendiri bagi usaha keripik oleh-oleh Kisaran. Dengan metode observasi dan memberikan pelatihan langsung ke lokasi mitra maka penerapan website dan e-katalog merupakan langkah penting bagi usaha Keripik Selasih dalam menghadapi tantangan bisnis pasca pandemi COVID-19. Dalam era digital ini, teknologi dapat membantu bisnis meningkatkan efisiensi operasional, meningkatkan kepercayaan pelanggan, dan memperluas pasar mereka. Penerapan website dan e-katalog juga dapat membantu Pak Selamat untuk memperluas jangkauan pelanggan mereka.
Kata kunci: website; e-katalog; umkm
Abstract:Abstract: The development of information technology encourages retail businesses to manage customer and transaction data more effectively. However, many small-scale retailers still rely on manual record-keeping, resulting…
g in unintegrated data and limited decision-making support. This study aims to design and implement a web-based Electronic Customer Relationship Management (E-CRM) system called MySaffana for Saffana Gallery Boutique to optimize customer and transaction data management. The research method includes requirement analysis, system design using UML, implementation using PHP and MySQL, and system testing using black box testing. The results show that the MySaffana system is able to manage customer data, products, transactions, and sales reports in an integrated and efficient manner. System testing indicates that all main features function properly and meet user requirements. Therefore, the developed E-CRM system provides an effective and practical solution for strengthening data-driven decision-making in small-scale retail businesses.
Keywords: boutique; customer data management; customer profiling; E-CRM.
Abstrak: Perkembangan teknologi informasi mendorong usaha ritel untuk mengelola data pelanggan dan transaksi secara lebih efektif. Namun, banyak usaha ritel skala kecil masih melakukan pencatatan secara manual sehingga data tidak terintegrasi dan kurang optimal dalam mendukung keputusan. Penelitian ini bertujuan untuk merancang dan mengimplementasikan sistem Electronic Customer Relationship Management (E-CRM) berbasis web bernama MySaffana pada Butik Saffana Gallery yang dapat mengoptimalkan pengelolaan data pelanggan dan transaksi. Metode penelitian meliputi analisis kebutuhan, perancangan sistem menggunakan UML, implementasi dengan PHP dan MySQL, serta pengujian menggunakan metode black box testing. Hasil penelitian menunjukkan bahwa sistem MySaffana mampu mengelola data pelanggan, produk, transaksi, dan laporan penjualan secara terintegrasi dan efisien. Pengujian sistem membuktikan seluruh fitur berjalan sesuai fungsi dan kebutuhan pengguna. Dengan demikian, sistem E-CRM berbasis web ini dapat menjadi solusi yang efektif dalam mendukung pengelolaan data dan pengambilan keputusan berbasis data bagi usaha ritel skala kecil.
Kata kunci: butik; E-CRM; profil pelanggan; pengelolaan data pelanggan.
Abstract:Abstract: Distributors in the Fast Moving Consumer Goods (FMCG) sector, such as CV. Sahabat Jaya Sukses, face significant challenges in inventory control, particularly related to product expiration and stock discrepancies…
s caused by manual recording. This study aims to design and implement a web-based Supply Chain Management (SCM) system that integrates the flow of goods from suppliers to retailers by applying the First Expired First Out (FEFO) method to minimize financial losses due to expired products. The research methodology employs the Waterfall model, which is selected because of its structured and systematic development stages and its suitability for systems with clear and stable requirements, facilitating effective analysis, design, implementation, and testing processes. The research stages include requirements analysis, system design, implementation, and testing. The results show that the SCM system successfully integrates data across the entire supply chain, automates inventory recording, and effectively prioritizes product distribution based on the nearest expiration dates. Black Box testing confirms that all system functionalities, including FEFO logic, operate properly, thereby improving operational efficiency and data accuracy.
Keywords: supply chain management; FEFO; web-based system; distributor; inventory
controls
Abstrak: Distributor di sektor Fast Moving Consumer Goods (FMCG) seperti CV. Sahabat Jaya Sukses menghadapi tantangan dalam pengendalian persediaan, khususnya terkait produk kedaluwarsa dan selisih stok akibat pencatatan manual. Penelitian ini bertujuan merancang dan mengimplementasikan sistem Supply Chain Management (SCM) berbasis web yang mengintegrasikan aliran barang dari pemasok hingga pengecer dengan menerapkan metode First Expired First Out (FEFO) untuk meminimalkan kerugian akibat produk kedaluwarsa. Metodologi penelitian menggunakan model Waterfall yang dipilih karena memiliki tahapan pengembangan yang terstruktur, sistematis, dan sesuai dengan kebutuhan sistem yang jelas serta stabil, sehingga memudahkan proses perancangan, implementasi, dan pengujian. Tahapan penelitian meliputi analisis kebutuhan, desain sistem, implementasi, dan pengujian. Hasil penelitian menunjukkan bahwa sistem SCM berhasil mengintegrasikan data di seluruh rantai pasok, mengotomatisasi pencatatan stok, serta memprioritaskan distribusi barang berdasarkan tanggal kedaluwarsa terdekat. Pengujian Black Box membuktikan bahwa seluruh fungsi sistem, termasuk logika FEFO, berjalan dengan baik sehingga meningkatkan efisiensi operasional dan akurasi data.
Kata kunci: distributor; FEFO; manajemen rantai pasok; pengendalian stok; sistem berbasis web