ace="맑은 고딕">요청사항 ng=EN-US>pan class='search_bold'>pacpan>e prefix = "o" />

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">l  ace="맑은 고딕">쇼핑몰 목록리스트 관리 및 반영ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">l  ace="맑은 고딕">제품코드 및 제품정보 관리ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; COLOR: red; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">판매코드 별 수수료율 ng=EN-US>(상시가ng=EN-US>/행사가ng=EN-US>)

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; COLOR: red; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">판매처에 상품등록 송신ng=EN-US> (모든 쇼핑몰 반영가능ng=EN-US>)

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">l  ace="맑은 고딕">안전재고 관리ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">재고량이 안전재고 ng=EN-US>+5미만인 경우 붉은 글씨 표기 및 프로그램 오픈 시 재고부족 목록 팝업창 띄우기ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">쇼핑몰 별 제품코드 정보 관리ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">제품코드 데이터 최초 입력 시 기존 데이터 이식ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">l  ace="맑은 고딕">세트상품 묶음 정보 등록 및 관리ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; COLOR: red; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">l  ace="맑은 고딕">쇼핑몰 별 주문건 및 클레임ng=EN-US>, 문의글 자동취합ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">주문서 파일 자동 접근 및 취합가능ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">주문리스트 조회 시 송장번호 표기 ng=EN-US style="COLOR: red">-> 택배비금액 추가ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">출고기록ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; COLOR: red; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">각 쇼핑몰 송장전송ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; COLOR: red; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">문의글 및 상담원문의글 수집ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; COLOR: red; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">클레임 ng=EN-US>(반품ng=EN-US>,취소ng=EN-US>,교환ng=EN-US>) 수집ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; COLOR: red; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">벤더사 주문수집 가능 ng=EN-US>(각 벤더사들이 직접 프로그램에 접속해 주문서 등록ng=EN-US>)

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">l  ace="맑은 고딕">반품ng=EN-US>/교환 내역 관리ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">l  ace="맑은 고딕">제품 입고 내역 관리ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; COLOR: red; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">생산발주서 공유 ng=EN-US>(생산공장에서 발주서 볼 수 있도록ng=EN-US>)

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; COLOR: red; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">입고수량 체크 관리 ng=EN-US>(입고처에서 입고수량 확인 후 입력가능ng=EN-US>)

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">l  ace="맑은 고딕">조회ng=EN-US>: 제작범위 내에서 첨삭이 가능합니다ng=EN-US>.

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">기준시간 제품 수불대장 조회ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">품목별 현재고 현황 조회ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">기준년도 월별 품목ng=EN-US>/쇼핑몰 별 매출 추이 통계산출 ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; COLOR: red; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">u  ace="맑은 고딕">통계산출에서 통계내역이 종류별로 확인ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; COLOR: red; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">u  ace="맑은 고딕">기간설정ng=EN-US>+택배비 확인 가능ng=EN-US>

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">l  ace="맑은 고딕">인터넷 데이터베이스ng=EN-US>(DB서버 운용으로 실시간 작업가능ng=EN-US>+작업공간제한없음ng=EN-US>)

ng=EN-US style="FONT-FAMILY: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-fareast-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s; mso-bidi-font-family: Wpan class='search_bold'>ingpan>dpan class='search_bold'>ingpan>s">n  ace="맑은 고딕">기로그인 및 권한설정

       --------------------------------------------------------

       고객님의 업체명과 담당자 성함, 연락처 등의 소중한 개인정보는
비공개로 수정해드렸습니다.
엑셀쿠키에서 내용접수하였으니, 확인후 답변드리겠습니다^^
--------------------------------------------------------

ace="맑은 고딕">ng=EN-US> 

ng=EN-US>ace="맑은 고딕" size=2> 

ng=EN-US>ace="맑은 고딕" size=2> 

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">1.업종 ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">: 제조

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">

  pan class='search_bold'>pacpan>e prefix = "o" />

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">2.예산 ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">: 200~300만원ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">(협의가능ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">)

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">3.제작 요청사항

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">1)업무흐름 및 기존 업무방식

저희는 부산 강서구에 있는 군용 기계부품 제조업체ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">(선반ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">,밀링 가공ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">)입니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

취급하는 부품은 직접제조 및 구매하는 부품포함 ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">4000~5000개 정도 입니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

현재 생산구매 관리는 팀원ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">4명이 엑셀을 이용하고 있습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

대략적인 업무프로세스는

물품계약 후 원재료 및 일부 구매부품을 발주하여ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 직접 제조하고ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 구매한 부품을 조립하여 검사후 납품처로 납품하는 형태입니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

여기서 제가 현재 엑셀프로그램을 좀더 고도화 시키고 싶은 분야가 바로 생산관리 부분입니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

계약후 ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">4명의 팀원이 아래와 같이 현재 각각 엑셀 양식을 사용하고 있습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

양식은 첨부파일에 넣어두겠습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

생산통합 관리현황 ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">(엑셀ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">)

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">- 말 그대로 전체 계약한 품목들의 정보들 및 전체 일정을 관리하는 통합 엑셀입니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">소재 발주일부터 공정이동일 등이 기입되어 한눈에 볼수 있게 해두었습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

자재ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">,부품구매 발주서ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">(엑셀ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">)

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">- 자재 및 부품을 발주하는 발주서로 발주서를 직접 작성하는 탭과 발주내용들을 조회할수 있는 탭으로

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">구분되어져 관리하고 있습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">. 이 부분은 아시는분에게 간이로 부탁드려서 사용하고 있으나ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">,

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">맘에 들지 않아 정식으로 제작의뢰해보려고 합니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

입출고 관리대장ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">(엑셀ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">)

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">- 제품이 입고 출고되는 내용을 기입하고ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 관리하는 대장으로 출고증까지 출력하도록 엑셀로 설정해놨습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">2)자동화하고 싶은 업무

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">- 이 세가지 엑셀을 하나의 엑셀로 통합가능하게 되었으면 좋겠습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">. 그러니까 생산통합관리현황이라는 엑셀을 중심으로 발주서ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 입출고 내용을 추가로 들어가서 연동이 되었으면 합니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">. 그래서 발주서를 작성하면ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 발주일이 각 부품별로 발주일을 기록할수 있고ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 입출고도 마찬가지로 한번 입력하면ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 통합관리 연결되었으면 합니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

현재 문제점

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">1. 각각의 엑셀을 사용하다보니ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 연동성이 없기에 통합엑셀로 한명이 매번 일일이 내용을 옮겨적고 있음

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">결국에 중복일 하는중

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">2. 생산통합 관리현황 ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">(엑셀ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">)의 경우 그림파일을 포함하여ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 입력되는 양이 많다보니ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 엑셀자료자체가 너무

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">무거워지며ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 특히나 오른쪽으로 입력되는 데이터가 너무 많아 양식이 한눈에 들어오지 않음

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">3. 자재ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">,부품구매 발주서ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">(엑셀ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">) / 입출고 관리대장ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">(엑셀ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">)은 개별적으로 만든 양식이다보니ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 일치성이 없고ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">,

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">임시적으로 보여ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 개선이 필요한 상태임ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">30명 정도의 작은 중소기업이라ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 지금까지 관리체계가 조금 엉망인 부분이 있었지만ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">,

현재 하나씩 개선을 진행하고 있습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">. 말 주변이 부족하여ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 설명이 제대로 되었는지 모르겠습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

검토가능하시고ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 상담진행가능하시면 연락부탁드립니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">. 수고하세요ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.