엑셀 자동화 업무 프로그램, 문서 및 양식

CAPA 확보계획 업체명 　 부품명 　 품번 　 작성일자 　 CAPA 확보계획 수립 단계 CAPA 확보현황 점검 단계 NO 레벨 주요 (SUB)부품명 공정구분 공법 라인 구성 작업 형태 년간 생산 CAPA (만대/년) (A = ①*②*③*④/10,000) 차량 생산계획 (만대/년) 공용생산 라인 년간 소요량 (F=D+E) 과부족 (E=F-A) 점검실적 결과 비고 타차종 생산물량 UPH (점검실적) 년간 생산량 과부족 부족부품 대응방안 1 2 내외작 구분 지역 외주 업체명 전용/ 범용 신규/ 개조 F/TOOL 완료 예정일 (1,2,3) Shift ① UPH (ER/HR) ② 작업시간 (HR/일) ③ 작업일수 (일/년) ④ 가동율 (%) 생산수량 전체대수 옵션율 적용대수 D=B*C 사양구분 타차종 생산량 (E) 공용생산 타차종명 　 　 대수(B) 산정기준 비율(C) 산정기준 적용지역 기타구분 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 www.kangha.net Em