- Excel을 이용한 공학적 투자사업의 손익분기점분석
- ㆍ 저자명
- 김진욱,이현주,김진,Kim. Jin-Wook,Lee. Hyun-Ju,Kim. Jin
- ㆍ 간행물명
- 산업공학
- ㆍ 권/호정보
- 2002년|15권 3호|pp.279-285 (7 pages)
- ㆍ 발행정보
- 대한산업공학회
- ㆍ 파일정보
- 정기간행물| PDF텍스트
- ㆍ 주제분야
- 기타
A break-even analysis is a method used widely for profit planning or decisions in most companies. It is useful tool in financial studies because it is simple and offers useful insights from a modest amount of data. Although it is widely used, it has some weaknesses. It is limited in particular to the analysis for a short term time horizon or one period. We suggest a new break-even procedure to analyze projects with a long term time horizon as keeping the simplicity of a conventional break-even analysis. We will make efforts doing to include actual data for a cost or an income as much as possible rather than developing a mathematical model to improve unreality of a traditional break-even analysis. Also, we will use the spreadsheet software to solve problems.