• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 2002.05a
• /
• pp.1038-1043
• /
• 2002

손익분기점분석이란 기업의 이익계획이나 의사결정 방법으로 널리 이용되는 유용한 기법이다. 간단한 정보만으로 사업을 분석하고, 경영전략을 세울 수 있다는 점에서 손익분기 점분석이 매우 유용한 분석방법이기는 하지만 비현실적인 가정을 전제조건으로 하는 단점이 있다. 이런 가정은 전통적인 손익분기점 분석의 과정을 단순화하지만 경영분석기법으로 적용하는 데에 한계성을 갖게 한다. 이 논문의 목적은 손익분기점분석의 간편함을 유지하면서 장기적인 투자사업에도 적용할 수 있도록 하여 손익분기점분석의 적용성을 향상시키는데 있다. 따라서 전통적인 손익분기점분석의 비현실성을 개선하기 위해 수리적인 모형의 개발을 지양하고, 비용이나 수입에 대한 실제자료를 최대한 반영시킴으로써 분석의 정확성을 높일 것이다. 또한 기업 실무에서도 쉽게 적용할 수 있도록 스프레드시트를 활용하여 손익분기점분석의 해를 구할 것이다.

• Korean Journal of Computational Design and Engineering
• /
• v.10 no.5
• /
• pp.349-355
• /
• 2005

This paper concerns about how and why design frameworks for optimization should consider various software development environments such as MATLAB, VB, VBscript, Python, Tcl, PHP, Perl, and JAVA. The frameworks can be utilized by many engineers who have a basic concept about the optimization theory and/or basic knowledge about the computer programming languages. The framework will integrate a number of remote CAE tools, automatically execute them for design optimization, and have the capabilities of post-processing of data such as objective functions, state variables and design variables using a third-party spreadsheet program like Excel. The prototype framework developed in this study will be applied to various examples of optimization problems and show the validity of the proposed method of a framework implemenation.

• Journal of the Korea Society of Computer and Information
• /
• v.22 no.11
• /
• pp.143-149
• /
• 2017

In this paper, we propose efficient management method of liberal education for improving computer literacy. We analyzed the actual conditions and factors affecting education and reflected the analysis results in education. The subject of the study is 'Practice Excel', and tested achievement based on computer literacy. In order to evaluate objectively, we conducted CBT(Computer Based Test) based on Computer Specialist in Spreadsheet & Database Level-2. Analysis of the questionnaire included the use of the popular statistical program, IBM SPSS 24 trial, and frequency, ANOVA, t-test, crossover analysis, and correlation. Evaluation results, An important factor influencing educational performance was active participation. It also proved to be very helpful for understanding excel functions & expression.

• Communications of Mathematical Education
• /
• v.24 no.4
• /
• pp.877-889
• /
• 2010

Mathematical modelling is a useful method for reinterpreting the real world and for solving real problems. In this paper, we introduced a theory on mathematical modelling. Further, we developed a mathematical model of the H1N1 influenza with Excel. Then, we analyzed the model which tells us what role it can play in an appropriate prediction of the future and in the decision of accompanied policies.

• Proceedings of the Korean Institute of Navigation and Port Research Conference
• /
• 2022.11a
• /
• pp.334-335
• /
• 2022

Among domestic car carrier operating shipping companies, some shipping companies are operating a stowage planning system that is installed and executed on a computer, and most shipping companies are executing stowage plans with documents such as Excel. This is a study on how to utilize web service technology so that multiple users can use the planning system more efficiently in the cargo stowage planning process for car carriers.

• Proceedings of the Korea Information Processing Society Conference
• /
• 2008.05a
• /
• pp.208-210
• /
• 2008

정형 정보를 저장하는 대표적인 수단인 Microsoft Excel과 Database 간 상호변환에 있어서 다양한 방법들 중 Web을 기반으로 하는 변환 기술은 활용도가 매우 높을 것이다. 특히 많은 자료가 엑셀로 관리되는 경우 데이터 중복의 문제가 발생하며 DB를 통한 통합관리는 사용자 편의성 측면에서 높은 필요성을 갖는다. 본 논문은 이런 문제를 해결하기 위한 방안으로 POI를 이용한 변환 기법을 소개한다.

• Bulletin of the Korean Chemical Society
• /
• v.32 no.5
• /
• pp.1463-1464
• /
• 2011

• The magazine of the Korean Society for Advanced Composite Structures
• /
• v.6 no.2
• /
• pp.57-67
• /
• 2015

• Journal of the Korean Data and Information Science Society
• /
• v.23 no.5
• /
• pp.905-912
• /
• 2012

We are dealing with the Bayes' rule education tool with Excel Macro and its usage example. When an event occurs, we are interested in whether it does under certain conditions or not. In this case, we use the Bayes' rule to calculate the probability. Bayes' rule is very useful in making decision based on newly obtained statistical information. We introduce an efficient self-teaching educational tool developed to help the learners understand the Bayes' rule through intermediate steps and descriptions. The concept and examples of intermediate steps such as conditional probability, multiplication rule, law of total probability, prior probability and posterior probability could be acquired through step-by-step learning. All the processes leading to result are given with diagrams and detailed descriptions. By just clicking the execution button, users could get the results in one screen.

• The Korean Journal of Food And Nutrition
• /
• v.16 no.3
• /
• pp.180-186
• /
• 2003

In order to prediction of lethal effects on target microorganisms, this study was developed the program in the basis of Excel that was systemized with Visual Basic. This program was automatically calculated the lethal effects (L and Fo value) by using thermal characteristics (D and z value), kinetic model and mathematic model. For the selection of target microorganisms, we are selected two microorganisms because of spoilage increasing by acid production and decreasing quality of food, and heat resistance microorganisms. The target microorganisms were Bacillus cereus (D$_{121.1}$=0.0065 min, z=7.8$^{\circ}C$) and Bacillus subtilis (D$_{121.1}$=0.5 min, z =12$^{\circ}C$). The program was developed for the target microorganisms, and that was very useful for various microorganisms that direct introducing known D and z value.