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

(강하넷) www.kangha.net 작  업  지  시  서(프레스 라인) 20    年      月    日  (  요일)  주 간 구   분 모델 / 품명 공정 생산 계획 생산 실적 달성율 작업공수효율 투입공수   미달성 원인및 대책 비    고 (%) (%) (HR*M) PRESS 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 소        계 　  -  - #DIV/0! #DIV/0! 126.0 　 　 실 가동시간(H)-> 총 작업 시간에서 조립공정 작업시간을 뺀 시간 구   분 모델 / 품명 공정 생산 계획 생산 실적 달성율 작업공수효율 투입공수   미달성 원인및 대책 비    고 (%) (%) (HR*M) 긴급 발주 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 소        계 　 　 　 　 　 　 　 　 www.kangha.net Email : kangha@daum.net

♣ E-mail : kangha@daum.net ♣ 파일의 다운로드는  www.kangha.net 을 참조하시기 바랍니다.

( ) 월 생산계획 󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲󰠲 W/O ( 납기 ) 품명 및 용량 TES 수량 전월 일 정 이월 공수 % 비고 납 품 처 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31