• 제목/요약/키워드: Excel-Based Scheduling

검색결과 6건 처리시간 0.021초

중소 제조기업을 위한 엑셀기반 스케쥴링 시스템 (An Excel-Based Scheduling System for a Small and Medium Sized Manufacturing Factory)

  • 이창수;최경일;송영효
    • 품질경영학회지
    • /
    • 제36권2호
    • /
    • pp.28-35
    • /
    • 2008
  • This study deals with an Excel-based scheduling system for a small and medium sized manufacturing factory without sufficient capability for managing full-scale information systems. The factory has the bottleneck with identical machines and unique batching characteristics. The scheduling problem is formulated as a variation of the parallel-machine scheduling system. It can be solved by a two-phase method: the first phase with an ant colony optimization (ACO) heuristic for order grouping and the second phase with a mixed integer programming (MIP) algorithm for scheduling groups on machines.

현금 흐름을 고려한 건설일정 최적화에 관한 연구 (Optimizing a Construction Schedule Considering Cash-flow)

  • 이형국;임태경;손창백;이동은
    • 한국건축시공학회:학술대회논문집
    • /
    • 한국건축시공학회 2012년도 춘계 학술논문 발표대회
    • /
    • pp.303-305
    • /
    • 2012
  • This paper presents a system called a Cash-flow based Construction Scheduling Optimization (CfSO). The existing CPM is biased on schedule and cost management. For a profitable and successful project management, the cash-flow which occurred actually by contractual conditions should be considered in the project scheduling. Therefore, this study provides a method to estimate the amount of a cash-flow occurred periodically by integrating the terms of contract into scheduling. The proposed methodology is implemented as a system prototype in Microsoft Excel. CfSO helps a site manager as a decision-maker to establish a optimized project scheduling and decide profitable contractual conditions against a construction owner.

  • PDF

BDM기법을 적용한 공동주택 마감공사 TACT공정계획 수립 및 운영 (TACT Scheduling & Monitoring of Apartment Finish Works based on the BDM Technique)

  • 김선규;유재우;김동섭;박종일
    • 한국건설관리학회논문집
    • /
    • 제15권2호
    • /
    • pp.3-11
    • /
    • 2014
  • 최근 건설사업은 건축, 토목, 기계, 전기, 조경 등의 모든 분야를 포함하는 복합 건설사업으로 추진되고 있고 대형화, 고층화 되어감에 따라 반복공정이 증가하게 되면서 작업 연속성 확보를 통한 목표공기를 달성하는 TACT 공정관리기법이 대두되고 있다. TACT기법은 반복작업의 자원을 효율적으로 활용하기 위해 작업과 작업이 단절되지 않도록 일정한 작업흐름을 유지할 수 있지만 CPM기법에 의해 수립된 네트워크가 아니기 때문에 전진계산, 후진계산, Critical Path 관리, 여유시간을 알 수 없어 체계적인 공정관리라 할 수 없다. 본 연구에서는 공동주택의 마감공사 TACT 공정계획을 기존의 엑셀(Excel), PDM기법 기반의 공정관리소프트웨어인 Primavera(P6), 새로운 공정관리기법 BDM기법 기반의 공정관리소프트웨어인 Beeliner로 작성 및 운영하는 방법들을 비교분석함으로써 BDM기법에 의한 TACT 공정계획 수립 및 운영상 적용성을 제시하고자 한다.

A STUDY ON CONSTRUCTION SCHEDULE OPTIMIZATION INTEGRATING WITH CASH-FLOW

  • Hyung-Guk Lee;Dong-Pil Shin;Sung-Hoon An;Dong-Eun Lee
    • 국제학술발표논문집
    • /
    • The 5th International Conference on Construction Engineering and Project Management
    • /
    • pp.141-144
    • /
    • 2013
  • This paper presents a system called a Cash-flow based Construction Schedule Optimization system(CfSO). The existing CPM effectively handles schedule and cost management. However, funding strategy should be considered to obtain maximum profit and to progress a project favorably. One of measures is to coordinate the contract terms between owner and subcontractors (or suppliers). Contractor may decrease the interest cost attributed to project financing by adjusting the timing of cash-inflows and cash-outflows. It is an excellent method maximizing profits. This paper presents a method to estimate the amount of a cash-flow occurred periodically by integrating the terms of contract into scheduling. The proposed method is implemented as a system prototype in Microsoft Excel. This system provides a user an automated tool that identifies an optimal schedule that secures maximum profit by adjusting start and finish times of non-critical activities' free-floats without affecting on the project completion time. This system supports a project manager to establish an optimum project schedule and identifies profitable contractual conditions against to a construction owner.

  • PDF

해양 석유 생산 및 수송 최적화 문제에 관한 연구 (A Study on the Optimization Problem for Offshore Oil Production and Transportation)

  • 김창수;김시화
    • 한국항해항만학회지
    • /
    • 제39권4호
    • /
    • pp.353-360
    • /
    • 2015
  • 해양 석유 생산은 '해양'이라는 특성에 기인하는 여러 가지 변수를 동반하면서 막대한 비용과 시간을 필요로 한다. 모든 관련된 프로세스는 인명, 환경 그리고 재산의 손실을 줄이기 위한 치밀한 일련의 계획에 의하여 통제된다. 이 논문은 해양 석유 생산 및 수송의 최적화 문제를 다룬다. 문제 영역의 범위를 정의하기 위해 해양 석유 생산 및 수송 네트워크를 제시하고 그 문제를 해결하기 위한 혼합정수계획모형을 구축하였다. 제안된 최적화 모형의 타당성을 확인하기 위해 가상의 해양 유전과 수요 시장을 바탕으로 MS Office Excel의 해찾기를 이용하여 계산실험들을 수행하였다. 해양 석유 생산 및 수송 네트워크 하위 흐름은 해양 유전에서 생산된 원유를 수요 시장으로 배분하는 해사수송문제가 된다. 이 해사수송문제를 해결하기 위해 집합 패킹 모형을 이용하여 구축된 MoDiSS(Model-based DSS in Ship Scheduling)를 사용하였다. 이러한 연구결과들은 실제적인 해양 석유 생산 및 수송 최적화 문제에 의미 있게 적용될 수 있으리라 사료된다.

소형조선소 맞춤형 생산공정 계획관리 시스템 개발 및 적용에 관한 연구 (A Study on the Development and Application of a Small Shipyard Customized Production Process Planning and Management System)

  • 김영훈;홍민종;백승주;이원석;조용화;이대형;이훈식;나성태
    • 한국산업융합학회 논문집
    • /
    • 제25권1호
    • /
    • pp.79-86
    • /
    • 2022
  • In general, since the types and types of ships, so complex and various variables are included to measure the amount of construction work. In addition, it is mot easy to predict the schedule or the number of working hours before ship construction, and it is also mostly inaccurate. As a result, the master plan is manually drawn up by the expert's experience, but there are limitations due to various factors. Medium and large shipyards are operating APS(Advanced Planning and Scheduling) system that reflects industrial characteristics to improve productivity in the planning stage, and utilize information from systems such as ERP(Enterprise Resource Planning) system and MES (Manufacturing Execution System). On the other hand, small shipyards rely mostly on manual work such as Excel work based on the experience of the workers. Therefore, this study intends to develop a master plan management system that can efficiently manage the production process from the business planning stage in consideration of the characteristics of small shipyards.