A Generic Approach to Entity Resolution Mechanisms for Big Data on Real World Match Problems in the Global Oil and Gas Sector

/in /by

Complex challenges are facing the global oil and gas industry. Oil prices are dropping due to OPEC production level, US oil boom, and other factors. Many experts believe that prices of oil will remain low for years at equilibrium of around $40-50 (Blumberg, 2018; Walls and Zheng 2018; Azar, 2019). Although 2019 oil price is expected to average at $65 with a further decline at $62 by 2020 (Amadeo, 2019; Kasim, 2019). Also, newly commercial resources are extremely expensive to develop, as massive capital investments are required. This research intends to develop a comprehensive entity resolution framework that has the ability to search across multiple databases with disparate forms, tame large amounts of data very quickly, efficiently resolving multiple entities into one, as well as finding hidden connections without human intervention. Putting in place a system to manage these entities will not only help to better assign resources, but to do so in a more expedient fashion. Although the necessary information is mostly already available within the oil and gas companies, it is spread around different company areas and application. Entity resolution will helps to aggregate these data, identify and exploit connection between entities and offer holistic all-in-one information that can helps to identify and deal with potential risk. We therefore present such an evaluation of existing implementations on challenging real-world match tasks. We consider approaches both with and without using machine learning to find suitable parameterization and combination of similarity functions. In addition to approaches from the research community we also consider a state-of-the-art commercial entity resolution implementation. Our results indicate significant quality and efficiency differences between different approaches. We also find that some challenging resolution tasks such as matching product entities from Opec database are not sufficiently solved with conventional approaches based on the similarity of attribute values.

Evaluation of Onion peels as Feed Additive on Blood Profile Broiler

/in /by

The purpose of this study was to assess how adding garlic peel (Allium sativum L.), shallot peel (Allium ascalonicum L.), and onion peel (Allium cepa L.) as additives to the blood profile. The material used was 189 one-day-old commercial broiler chicken (unsexing) and assigned to nine treatment T0(-): basal diet, T0(+): basal diet + antibiotic (zinc bacitracin 0.1%), T1: basal diet + 0.5 % garlic peel, T2: basal diet + 0.5 % shallot peel, T3: basal diet + 0.5 % onion peel, T4: basal diet + 0.25 % garlic peel and 0.25% shallot peel, T5: basal diet + 0.25 %. garlic peel + 0,25% onion peel, T6: basal diet + 0.25% shallot peel + 0.25% onion peel, T7: basal diet + 0.167% garlic peel + 0.167% shallot peel + 0.167% onion peel. The observed variables are hemoglobin, hematocrit, erythrocytes, and leukocytes. The data are analyzed using Analysis of Variance (ANOVA). The study results show that adding three garlic powders has no effect (P>0.05) on hemoglobin, hematocrit, erythrocytes dan leukocytes. In summary, Onion peel flour can be used as a feed additive to enhance the immune system.

Applying Warren Buffet’s Investment Strategy to Indonesia Stock Market

/in /by

In the past five years, there has been a significant surge in local Indonesian investors, predominantly comprising millennials and Gen Z, contributing to the positive growth of the stock market. However, a concerning phenomenon known as “herding bias” has been observed, highlighting the tendency of young investors to follow prevailing trends without fully understanding the intricacies and risks associated with their investments. This paper aims to address this issue by enhancing public awareness of stocks and minimizing associated risks, focusing specifically on value investing as an effective strategy. The research utilizes a ten-year period, selecting samples from companies listed in IDX30 through Warren Buffett’s screening test. This test incorporates key factors such as Conservative Debt, Price-to-Earnings Ratio (P/E Ratio), Price-to-Book Ratio (P/BV Ratio), Debt to Equity Ratio (D/E Ratio), and Return on Equity (ROE). Following the sample selection, the paper calculates the intrinsic value of chosen stocks, determines the margin of safety, estimates expected returns, and evaluate the risk-adjusted performance. Additionally, qualitative factors like understanding the business, market conditions, and internal company factors are considered. The findings indicate that Warren Buffett’s investment strategy can be successfully applied to Indonesian stocks. Investors are advised to select stocks based on careful consideration of financial ratios, analyzing annual reports, calculating intrinsic values, determining margins of safety, and assessing expected returns alongside associated risks. This research provides valuable insights that can serve as a practical reference for stock investment decisions, particularly for stocks with high market capitalization. By promoting a comprehensive understanding of value investing, this paper aims to empower young Indonesian investors to make informed and strategic choices, thereby mitigating the impact of herding bias in the local investment landscape.

Impact of Related Lending on Bank Health: Case Study in Indonesia Banking Industry

/in /by

Related lending is a critical driver of banks’ health, particularly on its profitability and risks profile. As banks engage in related lending activities, they face challenges in managing profitability and assessing various risks, including systemic and credit risks. Nevertheless, the banking literature presents divided views on this: the information view and the looting view. The information view posits that related lending could enhance bank profitability and reduce risks through improved information symmetry between banks and borrowers. Conversely, the looting view theorizes that related lending may deteriorate banks’ performance, reducing profitability and increasing risks, primarily due to the misallocation of resources and the prioritization of personal interests by banks’ insiders.

The challenges of related lending have been intensified by the global crisis of the COVID-19 pandemic. Empirical research indicate that banks tend to increase lending to related parties by up to 20% during economic difficulties, with more significant effects in emerging economy such as Indonesia. This trend is reflected in increasing related lending ratio and deteriorating financial indicators of publicly listed Indonesian banks, such as declining profitability ratios of return on assets (ROA) and net interest margin (NIM), as well as increasing risk ratios of higher non-performing loans (NPL) during the pandemic’s onset.

Therefore, this study will investigate the impact of related lending on bank health of publicly listed Indonesian banks across two critical periods, before crisis (2013-2019) and during the crisis due to the pandemic (2020-2022). By employing a quantitative approach through regression analysis, this study will be able to assess the relationship between bank profitability and risk ratios with their corresponding variables. The aim is to provide empirical evidence on whether related lending enhance or impair bank performance in terms of profitability and risk, particularly under the economic strains brought by the pandemic.

The Determination of Maximum Flow Rate in Well X Layer Y Field Z

/in /by

The field development target which usually in field X are mostly carried out in gas reservoirs over time, in several candidate wells gas reserves have started to run low so that the remaining oil reserves and pressure in the reservoir naturally decrease or natural depletion. This is due to continuous production of gas reserves. One of the wells that has the biggest potential for oil reserves in field X is well A9. In this study, the maximum flow rate was determined in the A9 layer A well in field X with a skin value of 10 using manual calculations. From manual calculations on the condition of well X with skin 10 Qmax Well X from the IPR plot results with manual calculations is 25.87 bbl/day with a PI value obtained 0.009371 stb/d/psi meanwhile in well condition X without skin the Qmax value obtained is 40.12 bbl/day with a skinless J value of 0.01457 stb/d/psi. From the determination of IPR on ECRIN, the Qmax value in well X without skin is 43.08 bbl/day, meanwhile in the condition of well X with skin 10 the Qmax value obtained is 25.84 bbl/day

Purchase Intentions in Indonesian E-Learning: A Study on Brand Equity, Advertising, and Pricing

/in /by

This study investigates the factors influencing purchase intentions for online paid courses in Indonesia, with a particular focus on brand equity, advertising, and price. Utilizing a Likert scale questionnaire distributed to 595 Indonesians aged 18-35, who bought their e-learning themselves or through family support. The research employs Partial Least Square-Structural Equation Modeling (PLS-SEM) for data analysis. Key findings indicate a strong preference for e-learning platforms offering interactive, practical content aligned with personal and professional development goals. The study reveals that enhancing skill sets, especially for career advancement or entrepreneurship, is a primary motivator for users. The importance of practical application of skills in real-world scenarios is emphasized, highlighting the need for practical exercises and case studies in course content. Quality mentorship and interactive features like live sessions significantly improve the learning experience, while technical issues and budget considerations are noted as potential barriers. The findings suggest that e-learning providers should focus on delivering high-quality content through flexible and competitive pricing models to attract and retain learners.

The Effect of Digital Transformation on Employee Performance (Case Study: PT. Indonesia Power UPJP Kamojang)

/in /by

PT. Indonesia Power UPJP Kamojang is one of the business units engaged in the Generation Unit and Generation Services (UPJP). Performance at PT. Indonesia Power UPJP Kamojang changes every year. In 2022 it is said that there will be a decrease compared to 2021. In line with this decrease, the company is carrying out a digital transformation that is required for all PLN subsidiaries. The purpose of this study is to determine the digital transformation that is implemented, the performance of existing employees and how much influence digital transformation has on the performance of employees of PT. Indonesia Power UPJP Kamojang based on existing dimensions. This type of research is descriptive and causal in nature. This study used a quantitative method with a questionnaire data collection technique which was distributed to 148 employees of PT. Indonesia Power UPJP Kamojang, with a sampling technique that is simple random sampling. Data analysis using the Structural Equation Model (SEM).The research results show that digital transformation seen from the customer experience and collaborative capability dimensions is categorized as quite good, the process and business model dimensions are categorized as good, the culture and technology dimensions are categorized as strong, and employee performance seen from the dimensions of task performance and contextual performance is categorized as quite high. The statistical test results showed that there was a significant influence of customer experience, collaborative capabilities, process, business model, culture and technology on task performance and contextual performance of PT. Indonesia Power UPJP Kamojang. It is recommended that companies need to improve digital-based customer service technology, training on digital tools, digitalization processes by senior management and supervisory teams, company value propositions, development of digital culture, use of new digital technology, giving targets to employees and giving rewards to employees.

Infrastructure Management for Children with Special Needs in Inclusive Schools: A Literature Review

/in /by

The importance of infrastructure management for children with special needs in inclusive schools is interesting to study more deeply in order to achieve educational goals. There are several articles on infrastructure management in inclusive schools that can be found. The review was conducted to find out how infrastructure management is conducted in inclusive schools. Based on the results of the literature review, it was found that there is a significant relationship between infrastructure management in inclusive schools in order to achieve learning objectives. The management of infrastructure facilities has six important points in its implementation, namely planning needs, procurement of infrastructure facilities, inventory, maintenance, use, and elimination. This is carried out in order to achieve educational goals in inclusive schools.

Proposed Marketing Strategy for Music Band in Indonesia (Case: YOI Band)

/in /by

YOI is an Indonesian music group that was founded in Bandung. They have been successful since the publication of their first album in 2007, however they have struggled with decreasing sales in recent years. The band members stated that improper management, especially with regard to marketing initiatives that make them less competitive, is the primary cause of the issues. In order to improve YOI’s business performance, this research suggests a marketing plan. The SWOT analysis, TOWS matrix, and 4P Mix Marketing framework are among the various of the strategic analytical techniques and frameworks that were utilized in this research to help formulate strategy. The research’s approach focused on consumer analysis, while gathering data from surveys, interviews, and secondary sources. In order to identify opportunities and threats facing YOI, the research also included an external analysis that considered political, legal, economic, demographic, sociocultural, technological, global, and physical aspects. The industry analysis was conducted using Porter’s Five Forces model. In order to get a deeper understanding of the competitive environment, this research also conducts competitor and internal analysis to pinpoint YOI’s strengths and weaknesses. The findings indicate that YOI had challenges such as low barriers to entry and intense competition, while simultaneously benefiting from advantages such as a strong brand reputation and a favorable economic climate. In order to address the difficulty and make the most of the prospects, the research suggested focusing on the young and established enthusiasts segments, and strategically positioning by aligning YOI’s capabilities with their desires. The study provided strategies to harness the influence of social media users in order promote YOI’s positive image and undertake product differentiation initiatives to address the intense competition. The study concludes with proposing a marketing strategy and implementation plan to effectively tackle the issues faced by YOI and capitalize on the potential available.

Financial Analysis for Land Reinforcement Project to Optimize Dump Capacity INL Pit Case: Coal Mining Company PT. XYZ East Kalimantan

/in /by

PT XYZ, a leading coal mining company in Indonesia located in East Kalimantan, boasts a production capacity of 55 million tonnes annually. Engaging in coal mining and sales for domestic and international clients across diverse industrial sectors, PT XYZ’s INL Area plays a pivotal role in its production for the next eight years, producing low-quality coal with an average calorific value of 4200 Kcal/kg GAR. As a cost leadership business, the company prioritizes cost efficiency, particularly in fuel consumption, notably for overburden movement. To enhance efficiency, PT XYZ explores the optimization of the distance from the mining front of the INL pit to the waste dump. A financial analysis case study compares two scenarios using a financial model: Scenario A, utilizing the recent waste dump with a cycle time of approximately 6.7 km, and Scenario B, proposing a new waste dump design with an investment in borepile reinforcement to accommodate overburden removal for the INL pit, resulting in a reduced cycle time of around 5 km. The financial model assesses feasibility parameters such as NPV, IRR, PI, and PBP between the scenarios, conducting scenario analysis to measure project success probability and identify significant variables affecting project feasibility. A Rsik Analysis on the project considers coal price realization and fuel consumption as key variables influencing the project’s value. The recommended option is Scenario B, presenting higher value for PT XYZ, with an investment in borepile reinforcement yielding a potential NPV of around $144.24 million, an IRR of 33%, and a PBV of 4.2 years.