Claim Missing Document
Check
Articles

Found 26 Documents
Search

IMPLEMENTASI MICROSOFT EXCEL UNTUK MENINGKATKAN EFEKTIVITAS PROSES STOK OPNAME DI PT RATNA ASIA Yuafini, Chamdan; Zaman, Komarun; Setyowati, Lis
CENDEKIA: Jurnal Ilmu Pengetahuan Vol. 5 No. 4 (2025)
Publisher : Pusat Pengembangan Pendidikan dan Penelitian Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.51878/cendekia.v5i4.7115

Abstract

ABSTRACT Stock opname is a crucial activity to ensure consistency between administrative records and the physical inventory conditions in the warehouse. At PT Ratna Asia, this process was previously performed manually, often resulting in reporting delays, the risk of recording errors, and a lack of efficiency. This study aims to illustrate the implementation of Microsoft Excel as a practical solution to improve the effectiveness of stock opname. The research method used was a case study with a qualitative approach through semi-structured interviews, direct observation over three weeks, and analysis of company documents. Data validity techniques were carried out using source triangulation, method triangulation, and member checking. The results showed that the use of Excel features, such as automatic formulas (SUM, IF, VLOOKUP), filters, and sorting, can speed up the recording process, minimize human error, and produce more accurate and systematic reports. Furthermore, Excel supports the digitalization of inventory management, making reports easier for management to analyze. Thus, the implementation of Microsoft Excel has been proven to improve the effectiveness of the stock opname process at PT Ratna Asia, both in terms of speed, accuracy, and report quality, while also providing a foundation for the company to adopt more advanced information systems in the future. ABSTRAK Stok opname merupakan aktivitas penting untuk memastikan kesesuaian antara catatan administrasi dan kondisi persediaan fisik di gudang. Di PT Ratna Asia, proses ini sebelumnya dilakukan secara manual sehingga sering menimbulkan keterlambatan pelaporan, risiko kesalahan pencatatan, dan kurangnya efisiensi. Penelitian ini bertujuan untuk menggambarkan penerapan Microsoft Excel sebagai solusi praktis dalam meningkatkan efektivitas pelaksanaan stok opname. Metode penelitian yang digunakan adalah studi kasus dengan pendekatan kualitatif melalui wawancara semi-terstruktur, observasi langsung selama tiga minggu, dan analisis dokumen perusahaan. Teknik keabsahan data dilakukan dengan triangulasi sumber, triangulasi metode, dan member check. Hasil penelitian menunjukkan bahwa penggunaan fitur Excel, seperti rumus otomatis (SUM, IF, VLOOKUP), filter, dan sorting, mampu mempercepat proses pencatatan, meminimalkan human error, serta menghasilkan laporan yang lebih akurat dan sistematis. Selain itu, Excel mendukung digitalisasi manajemen persediaan sehingga laporan lebih mudah dianalisis oleh manajemen. Dengan demikian, implementasi Microsoft Excel terbukti meningkatkan efektivitas proses stok opname di PT Ratna Asia, baik dari sisi kecepatan, ketelitian, maupun kualitas laporan, sekaligus memberikan landasan bagi perusahaan dalam mengadopsi sistem informasi yang lebih maju di masa depan.
The Effect of Price Discounts and Sales Promotions on the Increase of Medicine Sales Volume at PT MBF Surabaya Suprihono, Suprihono; Zaman, Komarun; Pratama, Devangga Putra Adhitya
Dinasti International Journal of Management Science Vol. 7 No. 1 (2025): Dinasti International Journal of Management Science (September - October 2025)
Publisher : Dinasti Publisher

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.38035/dijms.v7i1.5576

Abstract

This study investigates the effect of price discounts and sales promotions on the sales volume of pharmaceutical products at PT. MBF Surabaya, a distributor operating in a competitive market environment. The research was motivated by fluctuating sales performance and the company’s reliance on discount schemes and promotional activities as key marketing strategies. The objective was to analyze the individual and combined influence of discounts and promotions on sales outcomes. A quantitative associative method was employed, using structured questionnaires distributed to 32 respondents consisting of marketing staff and customers, supported by internal sales data. Data were analyzed through multiple linear regression, validity and reliability testing, as well as classical assumption tests. The results revealed that both discounts and sales promotions significantly increase sales volume, with promotions contributing more strongly than discounts. Simultaneous testing showed that 72% of the variance in sales volume was explained by the two variables combined. The findings highlight the importance of integrating financial incentives with creative promotional strategies to sustain competitiveness.
Penerapan Metode Belanja Barang dan Jasa Pemerintah Melalui Sistem E-Purchasing (E-katalog) di RSUD Dr. Soetomo Paryono; Zaman, Komarun; Megasari, Aisyah Darti
Jurnal Pengadaan Barang dan Jasa Vol. 4 No. 2 (2025): Jurnal Pengadaan Barang dan Jasa, Edisi Oktober 2025
Publisher : Ikatan Fungsional Pengadaan Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.55961/jpbj.v4i2.73

Abstract

This study aims to describe the implementation of the government procurement method for goods and services through the e-purchasing system (e-catalog) at Dr. Soetomo Regional General Hospital. The data reviewed are a summary of procurement methods and types. Data collection techniques used include interviews, observation, and documentation. Qualitative data analysis was used. The results of this study indicate that the e-catalog system is simple, effective, efficient, and on-target. The e-catalog has problems such as frequent application errors, unmet product needs, and the inability to provide services within the specified timeframe without a contract. Criteria for selecting goods and services providers include licensing, good reviews, and product prices that meet requirements. Late delivery or exceeding the deadline is subject to sanctions. The benefits of the e-catalog simplify the monitoring and maintenance process, as it facilitates communication between all parties involved. Its advantages include ensuring the certainty of the technical specifications of the goods or services ordered and ensuring appropriate prices.
THE INFLUENCE OF BRAND REPUTATION, PRODUCT QUALITY, AND PRICE ON REPURCHASE INTENTION OF RESPIRO RIDINGWARE PRODUCTS IN SURABAYA Dinda alkarimah, Dinda; Megasari, Aisyah Darti; Zaman, Komarun; Nuryadi
International Journal of Global Accounting, Management, Education, and Entrepreneurship Vol. 6 No. 1 (2025): International Journal of Global Accounting, Management, Education, and Entrepre
Publisher : Sekolah tinggi ilmu ekonomi pemuda

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.48024/ijgame2.v6i1.211

Abstract

This study aims to analyze the extent to which Brand Reputation, Product Quality, and Price influence consumers' Repurchase Intention of Respiro Ridingware products in Surabaya. This research uses a quantitative approach. The sampling technique applied is probability sampling with a simple random sampling method, and the Slovin formula was used to determine the number of respondents, totaling 100 participants. The research findings indicate that Brand Reputation, Product Quality, and Price simultaneously have a significant influence on consumers' Repurchase Intention.Keywords: Brand Reputation, Product Quality, Price and Repurchase Intention.
IMPLICATIONS OF FIXED ASSET REVALUATION ON FINANCIAL STATEMENT PERFORMANCE AND COMPANY CAPITAL STRUCTURE: A CASE STUDY OF PT. LUMBUNG PEDIA KERAMIK Resmina, Herty Widyatini; Zaman, Komarun; PRATAMA, DEVANGGA; Nuryadi
International Journal of Global Accounting, Management, Education, and Entrepreneurship Vol. 6 No. 1 (2025): International Journal of Global Accounting, Management, Education, and Entrepre
Publisher : Sekolah tinggi ilmu ekonomi pemuda

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.48024/ijgame2.v6i1.214

Abstract

Historical valuation of fixed assets often does not reflect the current fair value, so revaluation is one of the accounting policies that can measure this gap. This study aims to analyze the effectiveness of fixed asset revaluation on the company's financial statement performance and capital structure, through a case study at PT. Lumbung Pedia Keramik. The variables used include Debt to Equity Ratio (DER), Fixed Assets to Net Worth, and Return on Investment (ROI). The analysis method is a normality test followed by a Paired Sample t-Test to compare the ratios before and after the revaluation. The results of the study stated that fixed asset revaluation did not provide a significant difference in the three ratios. The implication of this finding is that although revaluation increases the book value of assets, its direct effect on financial performance and capital structure is not automatically significant. This study suggests that companies carefully consider the costs and benefits of revaluation before its implementation
Pengaruh Motivasi Kerja, Budaya Organisasi dan Gaya Kepemimpinan Terhadap Kinerja Karyawan di PT. Natura Nuswantara Nirmala Akbar, Vina Nurpuji Setya; Nuryadi, Nuryadi; Zaman, Komarun
J-CEKI : Jurnal Cendekia Ilmiah Vol. 3 No. 6: Oktober 2024
Publisher : CV. ULIL ALBAB CORP

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.56799/jceki.v3i6.5608

Abstract

This study aims to analyze the influence of work motivation, organizational culture, and leadership style on employee performance at PT Natura Nuswantara Nirmala. The results show that work motivation has a positive and significant effect on employee performance. Motivation in the form of rewards and development programs has been proven to significantly improve performance. Furthermore, a supportive organizational culture also positively influences employee performance, where good values and work environment encourage employees to work more effectively and efficiently. Transformational leadership style also has a positive and significant impact on employee performance, providing clear direction and motivating performance improvement. Overall, work motivation, organizational culture, and leadership style collectively have a positive and significant influence on employee performance at PT Natura Nuswantara Nirmala.