Publication Search

The manufacturing industry faces major challenges in maintaining consistent product quality amidst the dynamics of technology and global competition. This study aims to develop an effective Business Intelligence (BI) implementation model to support data-based quality control. The method used is a conceptual design approach through integrated system simulation, including MySQL database, PHP backend, Power BI visualization, Google Cloud AutoML predictive analytics, and initial processing using Microsoft Excel. Historical production data for 12 months is used for model training and defect trend visualization. The simulation results show that the implementation of BI can reduce product defect rates, accelerate system response, and increase inspection process efficiency. Technical validation proves the model's prediction accuracy is above 90%, while field validation shows positive acceptance from users regarding the ease of use of the dashboard. This system not only supports early detection of quality deviations but also contributes to real-time strategic decision making. With an integrated technology approach, BI enables medium-sized manufacturing companies to adopt an adaptive and sustainable digital quality system, in line with the concept of Quality 4.0.

This study uses a qualitative descriptive approach that aims to systematically describe the procedure for purchasing raw materials on credit at PT Bernofarm Pharmaceutical Company. The study focuses on various stages of purchasing, coordination between related departments (such as PPIC, purchasing, QC, warehouse, and accounting), and the use of documents and recording tools such as Microsoft Excel and ERP systems. This study is motivated by the importance of implementing standard purchasing procedures to ensure smooth production processes, accuracy of debt recording, and quality of raw materials. Primary data were obtained through direct observation during internship activities and unstructured interviews with management, especially the accounting department. Meanwhile, secondary data were obtained through a review of relevant literature to strengthen the analysis and discussion. The analysis technique was carried out qualitatively through the process of data reduction, data presentation, and drawing conclusions. The results of the study indicate that the procedure for purchasing raw materials on credit at PT Bernofarm is in line with the principles of internal control based on the COSO framework and meets applicable quality management standards, such as GMP/CPOB and ISO. Each stage from supplier evaluation, quality inspection, to debt repayment shows orderly and documented control. Thus, the procedures implemented support the operational effectiveness and integrity of the company's financial data.

This study aims to determine how students perceive the use of Microsoft Excel in preparing financial reports. The research method used is qualitative, which uses data collection techniques from questionnaires and interviews. This study contains a theoretical study of financial reports, Microsoft Excel, and students' perceptions. The research data were obtained from six informants with different secondary education backgrounds, namely vocational high schools majoring in accounting, MA majoring in social studies, and high schools majoring in social studies. With different secondary education backgrounds, it can influence students' perceptions about the use of Microsoft Excel in preparing financial reports.

This research was conducted in February-April 2025 at the Tebing Suban Tourism, Talang Ulu Village, East Curup, Selupu Rejang District, Rejang Lebong Regency. So the purpose of this study was to determine visitor satisfaction with the services of the Tebing Suban tourist attraction, Rejang Lebong Regency. The method used in this sampling was by Accidental Sampling, a sampling technique based on coincidence, namely anyone who accidentally meets the researcher can be used as a sample, if it is considered that the person who happened to be met is suitable as a data source. The data analysis method used is quantitative descriptive and data processing is carried out using the help of the SPSS (Statistical Program for Social Science) and Microsoft Excel applications which are presented in the form of tables and tabulations, then data measurements are carried out with visitor satisfaction tools, namely Importance Performance Analysis (IPA) and Customer Satisfaction Index (CSI). the results of the research that has been done, then several conclusions can be drawn, namely the results of the Importance Performance Analysis (IPA) based on the Cartesian diagram show that of the 20 service performance attributes of the Tebing Suban Tourism Object, there are 5 attributes that are considered very important and are the main priority in determining visitor satisfaction. Based on the calculation of the Customer Satisfaction Index (CSI), the satisfaction index value is 79.36%. This value is obtained from the Weighted Score divided by the Likert Scale value range.

Noni (Morinda citrifolia L. (Rubiaceae) is a medicinal plant that contains bioactive compounds with antioxidant and antibacterial properties. More than 160 phytochemical components have been identified in noni plants, most of which are polyphenol and antioxidant compounds. The purpose of this study was to determine a mathematical model of thin-layer drying in maximizing the development that can identify the characteristics of noni fruit. This study used an experimental method with slicing thickness treatments, namely: 3 mm, 5 mm and 7 mm, the drying tool used was a cabinet dryer, different temperature treatments ranging from 45 oC, 55 oC and 65 oC, with different drying times, namely: 3 mm thickness for 14 hours, 5 mm thickness for 16 hours and 7 mm thickness for 17 hours. The observation data were analyzed using a mathematical approach to complete the calculation of the mathematical model, the moisture ratio value was applied to various mathematical models, namely: the Midili et al, Page, Henderson pabis, logarithmic, Newton and modified Page models. Determination of constant values ​​using Microsoft Excel Solver Tools with input each drying model or equation used and curve fitting is carried out using non-linear regression analysis. The thin-layer drying model is obtained by finding the constant values ​​k, a and n of each model so that the best model for thin-layer drying of noni fruit is the page model for all temperatures with an R2 value at a temperature of 45 oC of 0.995 (RMSE 0.003), the R2 value at a temperature of 55 oC is 0.993, (RMSE 0.001) and at a temperature of 65 oC the R2 value is 0.992 (RMSE 0.000).

This study aims to determine the influence of Profitability, Liquidity, Sales Growth, and Operating Capacity on Financial Distribution on the clothing and luxury goods sub-sector listed on the Indonesia Stock Exchange for the 2019-2023 period. The sampling technique used is  Non Probability Sampling with a sample of 9 companies in the clothing and luxury goods sub-sector listed on the Indonesia Stock Exchange for the 2019-2023 period. In this study, a multiple linear regression method was carried out assisted by the SPSS version 29 program and Microsoft Excel 2010. The results showed that (1) Profitability had no effect on Financial Distress, (2) Liquidity had an effect on Financial Distress, (3) Sales Growth had no effect on Financial Distress, (4) Operating Capacity had an effect on Financial Distress.

The purpose of Community Service (PKM) is to improve the understanding and ability of business owners and crew members (ABK) in conducting simple and applicable financial analysis. This activity will be carried out in Laha Village, Ambon City, in May 2025 with the main target of the Arumbae ship fishing business actors and their crews. This PKM is carried out in three main stages, namely: the preparation stage, the implementation stage, and the monitoring and evaluation stage. In the preparation stage, an initial approach is made to ship owners and crew members to establish communication and identify specific needs related to understanding and skills in financial analysis. The implementation phase includes training activities that are designed in a participatory and applicable manner, using Microsoft Excel software as the main tool in calculating and analyzing the feasibility of the business. The training material includes business feasibility analysis techniques, cash management, simple financial recording, and profit and loss projections. The benefits felt by the participants were very significant. Business owners now have a better understanding of the importance of financial management, and can prepare a business feasibility analysis independently. They also show an improvement in the ability to prepare simple financial statements, as well as being motivated to develop fishing ventures to a larger and more sustainable scale. Monitoring shows a noticeable increase in understanding and skills after training. This activity also has a positive impact on building an orderly and disciplined financial recording culture, which has not previously been a habit among fishermen. In the future, it is hoped that this training can be replicated to other fishermen groups in the coastal area of Maluku to expand the impact. The conclusion of this activity shows that an educational and practical approach is able to encourage the increase of fishermen's capacity in the financial aspect of business. This activity also opens up opportunities for the development of fishing businesses professionally and oriented towards the sustainability of the local economy.

This study aims to analyze the optimization of seaweed seedling inventory management using the Economic Order Quantity (EOQ) method to enhance cost efficiency for farmers in Tarakan City. The research employs a quantitative descriptive approach, integrating EOQ with forecasting techniques (Moving Average and Exponential Smoothing) to predict raw material needs accurately. Data were processed using Microsoft Excel and POM-QM for Windows to ensure precision. The results indicate that EOQ yields an optimal order quantity of 878 ropes per order, with a frequency of 6 orders per year, a reorder point of 16 ropes, and a total inventory cost (TIC) of IDR 842,681. Compared to traditional methods (TIC IDR 2,132,083), EOQ reduces costs by 60.5%. Forecasting analysis reveals that Exponential Smoothing (MAPE 19.67%) outperforms Moving Average (MAPE 22.5%) in accuracy. These findings highlight EOQ’s effectiveness in minimizing waste, preventing stockouts, and improving productivity. The study provides practical insights for coastal small-scale farmers and policymakers in the marine sector.

Technological advancements and digital transformation have significantly impacted business management, including the consulting sector. PQM Consultants faces challenges in managing inquiries, which are still manually handled using Microsoft Excel. This manual process results in fragmented data, delays in accessing information, input errors, and difficulties in real-time monitoring of inquiry statuses. These issues affect operational efficiency, data transparency, and timely decision-making.   This research focuses on developing a web-based inquiry management platform through the Design Thinking methodology, aiming to improve the efficiency and effectiveness of inquiry handling at PQM Consultants. Adopting a qualitative case study approach, the study gathers insights through in-depth interviews, direct observations, and document reviews involving consultants and support team members who are directly engaged in the inquiry process. Research participants consist of consultants and support team members directly involved in inquiry management. The study uses a Design Thinking approach, which focuses on solving problems through repeated refinement and actively involving users throughout the development process. This framework supports the development of creative solutions by deeply understanding user needs, defining key challenges, and continuously refining ideas through prototyping and testing (Costich 2021). The Empathize stage focuses on understanding user needs and challenges. The Define stage formulates the core problems specifically. The Ideate stage generates creative ideas as potential solutions. The Prototype stage develops an initial design of the platform, which is then tested during the Test stage to gather feedback for further refinement. The results indicate that the web-based inquiry management platform effectively addresses various challenges in managing inquiry data, such as access delays, input errors, and data fragmentation. The platform enables consultants to monitor inquiry statuses in real-time, access data transparently, and make faster and more accurate decisions.

Kue cubit lumer is a traditional snack that is increasingly popular in Indonesia, especially among children and teenagers. This cake has a soft texture with a melting center. This study aims to optimize the production of kue cubit lumer using linear programming method with simplex analysis through Microsoft Excel Solver to determine the optimal production quantity of three variants: original, cheese, and chocolate. The calculation results show that the production of 2 pcs of original cubit cake, 4 pcs of cheese, and 4 pcs of chocolate will generate maximum profit of Rp124,000 per day. The simplex method proved effective in solving production optimization problems by maximizing the use of raw materials and increasing profitability. This study provides guidance for businesses to manage production efficiently to meet market demand and significantly increase profits. This study proves that the simplex method is effective in solving production optimization problems to achieve maximum profit.

Scientific argumentation skills are high-level thinking skills that are very important for students to have in the learning process, especially in 21st century education that shapes students to argue and shape students into individuals who are able to think critically. However, based on the results of observations, students are still not active in conveying their arguments and critical thinking. The purpose of this study is to analyze the relationship between scientific argumentation skills and critical thinking skills through the VAK (Visual, Auditory, Kinesthetic) learning model on cell material. The method used in this study is the correlational method with an ex post facto research design using 1 experimental class with a research sample of 30 students. The instruments used are 15 essay questions for both scientific argumentation skills and critical thinking skills. Data analysis was carried out using Microsoft Excel and data analysis techniques using the t-test. The results of the analysis through the posttest on students' scientific argumentation skills are in the form of an average value of 47.5, while the average value of critical thinking skills is 47.6, with the results of the t-test being 2.08> 1.69, which means that tcount> ttable, namely H0 is rejected. The results of the hypothesis test show a significant relationship between scientific argumentation skills and critical thinking skills using the VAK (Visual, Auditory, Kinesthetic) learning model on cell material.    

This research built a simulation model of the cans line mobilization process yogurt in the Mosul dairy factory to see average waiting time per can and the average number of cans that remain in the queue before the filling process. Where the model was built using Microsoft Excel and queuing model used for this study is the kind of M/M/1: (FeFs,00,00). The results are that the time of waiting for each packet in the queue about (17) minutes and the average number of cans in the queue is (206) can of the total cans (1440 packqge) for that day.    

Knowledge is the result of the process of understanding and recognizing something obtained through sensing an object. Beta-lactam antibiotics are a type of broad-spectrum antibiotic commonly used to treat bacterial infections, but their use still has the potential to cause side effects in the form of Adverse Drug Reactions (ADRs). This study aims to assess the level of patient knowledge regarding ADRs due to the use of beta-lactam antibiotics at Bendan Pekalongan Regional Hospital in 2024. This study used a prospective correlation design with a non-experimental approach. A total of 29 outpatients taking beta-lactam antibiotics were sampled, selected using a purposive sampling technique. Data were collected through questionnaires, medical records, and analyzed descriptively using Microsoft Excel. The results showed that 41% of respondents had low knowledge regarding ADRs, 28% had sufficient knowledge, and 31% had good knowledge. These findings indicate the need for more intensive education regarding the risks of ADRs in order to improve the safety of antibiotic use.

This study aims to determine the Influence of Task Complexity, Time Budget Pressure, Audit Experience, and Due Professional Care on Audit Quality in Auditors at Public Accounting Firms in the South Jakarta Region in 2025. The data sampling technique is through the distribution of questionnaires directly to respondents using the purposive sampling method. The population in this study is auditors who work in 7 Public Accounting Firms and obtained 47 auditors who are sampled in this study. This study uses multiple linear regression analysis techniques and uses the Statistical Package For The Social Science (SPSS) version 22 and Microsoft Excel 2019 program test tools. The results of this study prove that the variable of task complexity has a positive and significant effect on audit quality, while time budget pressure, audit experience, and Due Professional Care have no effect on audit quality.

Indonesia has experienced significant technological advances, including in the field of computer technology. This requires the government to adapt to changing technological developments. Therefore, Microsoft Excel training has been conducted for Central Lombok Bappeda employees to increase their knowledge and understanding of formulas that can facilitate the use of Microsoft Excel office applications. This training was held by the Monev division and aims to improve the ability of Bappeda employees to process data in a professional manner. It is hoped that this training will assist employees in completing tasks and meeting the needs of the Bappeda agency effectively.

The selection system at Bina Negara Gubug Vocational School Jl. KH. Hasan Anwar No.9 Gubug currently processes data on the criteria for each student for each type of scholarship. It does not yet have a database system but uses a computerized system with Microsoft Excel, so there are often delays in the selection process in preparing the selection report for scholarship recipients. This research uses the Research and Development (R & D) development model by Borg and Gall with 6 steps of development, namely Research and Information Collecting, Planning, Develop Premilinary Form of Product, Premilinary Field Testing, Main Product Revision, Main Field Testing. The scholarship selection decision support system application product uses the SAW (Simple Additive Waighting) method. Visual Basic 6.0 development software and Microsoft Access database. This system can provide a useful solution for the decision-making system for selecting scholarship recipients for schools so that a better and faster selection can be achieved.      

The purpose of this study is to find out which sectors are the leading sectors in North Kalimantan Province in 2017 – 2021, What economic sectors have fast growth rates in shifting economic sectors in North Kalimantan Province in 2017 – 2021, Which economic sectors have the power strong competitiveness in shifting economic sectors in North Kalimantan Province in 2017 - 2021. What economic sectors are included in the criteria as prime, potential, developing and underdeveloped sectors in North Kalimantan Province in 2017 - 2021. Quantitative analysis methods used in processing this data is Location quotient (LQ), Shift Share, Growth Ratio Model (MRP) and Overlay Analysis processed using Microsoft Office Excel. The results of the study show that the economic sectors which are categorized as basic sectors in North Kalimantan Province in 2017 – 2021 are the Agriculture, Forestry and Fisheries sectors; Mining and excavation; Construction; Transportation and Warehousing; Administration of Government, Defense and mandatory social security; Education Services.

This study aims to analyze the influence of auditor experience, independence, professional skepticism, time pressure, and red flags on the auditor's ability to detect financial statement fraud in the Public Accounting Firm (KAP) in the South Tangerang region. Data was collected through the distribution of questionnaires using the purposive sampling method, with a sample of 45 auditors from four KAPs. Data analysis was carried out using multiple linear regression with the help of SPSS software version 21 and Microsoft Excel 2021. The results showed that professional skepticism had a significant negative effect on the auditor's ability to detect fraud. On the contrary, auditor experience and red flags have a significant positive influence on auditor ability. Meanwhile, independence and time pressure do not have a significant influence on the auditor's ability to detect financial statement fraud.

Penelitian ini dilaksanakan di Zao Martial Art yang merupakan salah satu usaha industri konveksi yang bergerak dalam memproduksi seragam dan perlengkapan alat-alat taekwondo yang terletak di Jl. Raya Manyaran-Gunungpati, Cepoko, Kec.Gunung Pati, Kota Semarang. Perhitungan penerimaan dan pengeluaran kas setiap bulannya menggunakan Microsoft Excel dan untuk pencatatannya masih menggunakan tulis tangan pada selembar kertas. Belum adanya sistem informasi berbasis dekstop yang dapat memudahkan bagian pencatatan dan perhitungan penerimaan serta pengeluaran kas pada Zao Martial Art. Sistem informasi berbasis dekstop ini bertujuan untuk membantu mengelola pencatatan data serta perhitungan penerimaan dan pengeluaran kas. Pengumpulan data untuk penelitian dilakukan dengan beberapa opsi, diantaranya wawancara, observasi dan studi pustaka. Sistem ini dikembangkan dengan Microsoft Visual Studio 2013,  Xampp, MySql. Perancangan sistem menggunakan UML (Unifed Modeling Language) dengan metode R&D (Research and Development) sebagai metode pengembangannya.  

Self-medication is a common practice among the public in managing health complaints, including coughs. This study aims to assess the level of knowledge regarding self-medication for cough medicine among patients at Sehati Bina Cakrawala Pharmacy in Karawang during the June–July 2024 period. A descriptive research method was employed, with a sample of 132 respondents selected using purposive sampling. Data were collected through questionnaires and analyzed using univariate analysis with IBM SPSS 26 and Microsoft Excel. The findings indicate that out of 132 respondents, 93% had a good level of knowledge, 6% had a moderate level of knowledge, and 1% had a low level of knowledge regarding self-medication for cough medicine.