| ace="맑은 고딕"> |
ace="맑은 고딕">10 |
ace="맑은 고딕">10 |
ace="맑은 고딕">10 |
ace="맑은 고딕">10 |
ace="맑은 고딕"> |
경리 · 회계 > 업무자동화 | 조회 3140 | 답변완료(1)
-
가견적 재요청 드립니다.
pan style="font-size: 11pt;">
pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">1.pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-weight:bold;font-size:11.0pt;">업종 pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">: pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-weight:bold;font-size:11.0pt;">귀금속수리센터pan>
pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;"> pan> pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">2.pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-weight:bold;font-size:11.0pt;">예산 pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">: ??pan>
pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;"> pan> pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">3.pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-weight:bold;font-size:11.0pt;">제작 요청사항 pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">: pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-weight:bold;font-size:11.0pt;">어제pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">(2pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-weight:bold;font-size:11.0pt;">일pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">) pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-weight:bold;font-size:11.0pt;">통화하고 가견적 잘 받았습니다pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">. pan> pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-weight:bold;font-size:11.0pt;">빠뜨린 내용과 구체적 설명 등이 있어서 추가견적의뢰드립니다pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">. pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-weight:bold;font-size:11.0pt;">번거롭게 해드려 죄송합니다pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">.pan> pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;"> pan> pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">1)pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-weight:bold;font-size:11.0pt;">업무흐름 및 기존 업무방식pan> pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;">귀금속 수리업체로서 지점과 수리공장에서 고객이 의뢰한 수리물품이 입고되면 지점에서 의뢰된 물품은 본사를 거쳐 pan> pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;">공장에서 수리가 진행됩니다pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">. pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;">수리 후 지점으로 보내지고요pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">.pan> pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">※ pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;">수리물품은 본사에서 판매한 귀금속이 아니고 모든 귀금속에 대한 수리를 받습니다pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">.pan> pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;">2)pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;font-weight:bold;">자동화하고 싶은 업무pan>
pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">*pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">본사pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">수리공장pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">지점의 pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">3pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">곳이 연동되어 시스템이 보여져야 하고 본사와 공장은 pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">PC, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">지점은 모바일 사용을 기본으로 합니다pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">.pan> pan style="font-family:돋움;mso-fareast-font-family:돋움;">본사는 지점과 공장을 모두 볼 수 있어야하고 관리합니다pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">. pan> pan style="font-family:돋움;mso-fareast-font-family:돋움;">지점과 공장은 각각 해당하는 지점별의 내용만 볼수 있으며 pan> pan style="font-family:돋움;mso-fareast-font-family:돋움;">공장도 해당하는 내용만 볼 수 있습니다pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">.pan> pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">*pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">어제 상담했던 내용처럼 수리물품의 이력pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">수리금액도 기입하고 결산도 가능해야 합니다pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">.pan> pan style="font-family:돋움;mso-fareast-font-family:돋움;">수리종류pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">(pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">도금수리pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">사이즈수리 등 pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">6pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">개 정도와 기타pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">) pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">선택시 목록에 해당되는 금액이 자동 기입되는 구조이면 합니다pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">.pan> pan style="font-family:돋움;mso-fareast-font-family:돋움;">결산은 각 지점별의 결산과 모든 지점의 총결산내역이 반영되어야하며pan> pan style="font-family:돋움;mso-fareast-font-family:돋움;">지점에서 소매가격과 본사의 도매가격이 기입되어야 합니다pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">.(pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">첨부파일 참고pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">)pan> pan style="mso-fareast-font-family:돋움;font-size:9.0pt;"> pan> pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">*pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">공장에서는 외주수리도 주기 때문에 외주내용도 별도로 있어야 합니다pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">.(pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">현재 도금작업pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">시계수리 등 총 pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">4pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">곳정도pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">)pan> pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">*pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">수리이력에 추가되어야 할 사항은 pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">“pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">물품수리전 사진첨부란pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">”pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">과 위에서 말한 pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">“pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">결산pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">”pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">이 추가되어야 하고pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">, “pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">개인정보와 고지사항에 대한 고객동의pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">”, “pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">서명란pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">”pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">이 필요합니다pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">.pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">pan> pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">*pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">수리내용에 대한 수리장에 각 pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">QRpan>pan style="font-family:돋움;mso-fareast-font-family:돋움;">코드 생성되어 있으면 됩니다pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">.pan> pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;">
잘 읽어보시고 번거로우시겠지만 가견적 다시 한번 부탁드립니다.
연락 기다리겠습니다.pan>
pan>
-
엑셀 자동화 작업 의뢰 요청
pa n style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-hansi-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt">◎ pan> pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">의뢰자pan>
pan lang="EN-US" style="FONT-SIZE: 15pt; mso-fareast-font-family: HY견명조">pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">- pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">**************pan>
pan lang="EN-US" style="FONT-SIZE: 15pt; mso-fareast-font-family: HY견명조">pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">- pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">담당자 pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">: pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">***pan>
pan lang="EN-US" style="FONT-SIZE: 15pt; mso-fareast-font-family: HY견명조">pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">- pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">연락처 pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">: ***-***-****, ***-****-****pan>
pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-hansi-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt">◎ pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">주 담당 업무pan>
pan lang="EN-US" style="FONT-SIZE: 15pt; mso-fareast-font-family: HY견명조">pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">- pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">자치경찰단 수사과에서는 수사 사건을 전자문서pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">(pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">공문서pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">) pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">또는 출력된 고소장pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">고발장을 접수 받음pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">.pan>
pan lang="EN-US" style="FONT-SIZE: 15pt; mso-fareast-font-family: HY견명조">pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">- pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">접수받은 사건을 각 직원들에게 배당을 하고 사건을 처리하는 부서 임pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">.pan>
pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-hansi-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt">◎ pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">의뢰 목적pan>
pan lang="EN-US" style="FONT-SIZE: 15pt; COLOR: #0000ff; mso-fareast-font-family: HY견명조">pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">- pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; mso-fareast-font-family: HY견명조">관리자 입장에서 사건 관리하기 위함pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">.pan>
pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-hansi-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt">◎ pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">의뢰 내용pan>
pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">- pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">엑셀 작업 내용을 pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; mso-fareast-font-family: HY견명조">사건 접수pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">와 pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; mso-fareast-font-family: HY견명조">처리 사건 데이터 입력pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">하면 pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; mso-fareast-font-family: HY견명조">통계 및 직원별 사건 현황이 도출되는 자동화 시스템pan>
pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-hansi-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt">◎ pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">현재 엑셀 작업 방식pan>
pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">1) pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조">전자문서pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">(pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조">공문서pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">) pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조">또는 출력된 고발장pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조">고소장을 접수받으면pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">,pan>pan lang="EN-US" style="FONT-SIZE: 15pt; mso-fareast-font-family: HY견명조"> pan>
pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">2) pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.5pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">2020pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.5pt; mso-fareast-font-family: HY견명조">년 일반사건 접수pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.5pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.5pt; mso-fareast-font-family: HY견명조">처리현황pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.5pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">(pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.5pt; mso-fareast-font-family: HY견명조">예시pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.5pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">)pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.5pt; mso-fareast-font-family: HY견명조">의 pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.5pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">‘pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.5pt; mso-fareast-font-family: HY견명조">산림환경시트pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.5pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">’pan>pan lang="EN-US" style="FONT-SIZE: 15pt; COLOR: #0000ff; LETTER-SPACING: -0.4pt; mso-fareast-font-family: HY견명조"> pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.4pt; mso-fareast-font-family: HY견명조">또는 pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.4pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">‘pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.4pt; mso-fareast-font-family: HY견명조">공중식품시트pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.4pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">’pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; mso-fareast-font-family: HY견명조">에 사건 데이터를 입력함pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">.pan>
pan lang="EN-US" style="FONT-SIZE: 13pt; mso-fareast-font-family: HY견명조">pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-hansi-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt">※ pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">입력하는 데이터pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">) pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조">인지 종류pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조">접수일자pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조">배당일자pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조">담당 수사관pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.4pt; mso-fareast-font-family: HY견명조">위반법률pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.4pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">,pan>pan lang="EN-US" style="FONT-SIZE: 13pt; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조"> pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조">위반자pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">(pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조">인적사항pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">), pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조">위반내용pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조">발생지역pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조">위반장소pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조">비고pan>
pan lang="EN-US" style="FONT-SIZE: 15pt; mso-fareast-font-family: HY견명조">pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">3) pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">담당 수사관이 사건 처리pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">(pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">기소pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">불기소pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">내사종결pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">이송등pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">)pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">을 하면pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">,pan>
pan lang="EN-US" style="FONT-SIZE: 15pt; COLOR: #0000ff; mso-fareast-font-family: HY견명조">pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">4) pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">2020pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조">년 일반사건 접수pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조">처리현황pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">(pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조">예시pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">) ‘2020pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조">사건시트pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">’pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조">에 처리 사건의 데이터를 입력하여 내역을 관리 중임pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -0.2pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">.pan>
pan lang="EN-US" style="FONT-SIZE: 13pt; mso-fareast-font-family: HY견명조">pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-hansi-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt">※ pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">입력하는 데이터pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">) pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">지역pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">구분pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">사건번호pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">위반법률pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">위반자pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">(pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">성명pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">피의자수pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">위반유형pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">지역pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">장소pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">피해정도pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">위반목적pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">수사단서pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">처리결과pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">접수pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">(pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">배당pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">)pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">일자pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">송치일pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">처리기간pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">담당자pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">송치번호pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">수사지휘여부pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">처리월pan>
pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">5) pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">위와 같이pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">. pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">사건 접수pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">-> pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">사건처리내역의 데이터를 기반으로pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">,pan>
pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">6) pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">2020pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">년 일반사건 접수pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">처리현황pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">(pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">예시pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">)pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">의 시트별 통계 내역pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">과 pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">직원별 처리현황pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">(pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">예시pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">)pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; COLOR: #0000ff; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">의 엑셀파일과 같이 pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">직원별 처리pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조">보유유사건의 내역을 관리목적으로 확인 중임pan>pan lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: HY견명조; LETTER-SPACING: -1.6pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">.pan>
pan lang="EN-US" style="FONT-SIZE: 13pt; mso-fareast-font-family: HY견명조">pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-hansi-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt">※ pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">매월 주기적으로 데이터를 입력하더라도pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">, pan>pan style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; mso-fareast-font-family: HY견명조">직원별 보유현황등은 입력한 데이터를 기반으로 수작업 중 임pan>pan lang="EN-US" style="FONT-SIZE: 13pt; FONT-FAMILY: HY견명조; LETTER-SPACING: 0pt; mso-fareast-font-family: HY견명조; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: HY견명조">.pan>
pan>pan>
pan> pan style="FONT-SIZE: 11pt">pan style="color: rgb(31, 73, 125); font-family: "맑은 고딕"; font-size: small;">*************************pan>pan style="COLOR: #1f497d">ace="맑은 고딕"> 라고 합니다 pan lang="EN-US">pan>pan>
pan lang="EN-US" style="COLOR: #1f497d">ace="맑은 고딕" size="2"> pan>
pan style="COLOR: #1f497d">ace="맑은 고딕">저희는 냉동 패키지를 만드는 제조 업체 입니다 pan lang="EN-US">pan>pan>
pan style="COLOR: #1f497d">ace="맑은 고딕">대략적인 프로그램 요청 사항은 하기와 같습니다 pan lang="EN-US">pan>pan>
pan style="COLOR: #1f497d">ace="맑은 고딕">첨부자료 참조 하여 주시고 해당 발주서 포맷대로 구현이 가능한지 여부등 pan>
pan style="COLOR: #1f497d">ace="맑은 고딕" size="2">확인을 부탁드립니다 pan>
pan style="COLOR: #1f497d">ace="맑은 고딕" size="2">pan>
pan style="COLOR: #1f497d">ace="맑은 고딕" size="2">************************* 으로 pan>
pan style="COLOR: #1f497d">ace="맑은 고딕" size="2">접속 하시면 제조 제품을 보실수 있습니다 pan>
pan lang="EN-US">ace="맑은 고딕" size="2">
pan> pan style="font-size: 12px; color: rgb(0, 0, 0); font-family: 돋움, Dotum, Helvetica, sans-serif; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal;">--------------------------------------------------------pan> pan style="font-size: 12px; color: rgb(0, 0, 0); font-family: 돋움, Dotum, Helvetica, sans-serif; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal;">고객님의 업체명과 담당자 성함, 연락처 등의 소중한 개인정보는pan> pan style="font-size: 12px; color: rgb(0, 0, 0); font-family: 돋움, Dotum, Helvetica, sans-serif; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal;">비공개로 수정해드렸습니다.pan> pan style="font-size: 12px; color: rgb(0, 0, 0); font-family: 돋움, Dotum, Helvetica, sans-serif; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal;">엑셀쿠키에서 내용접수하였으니, 확인후 답변드리겠습니다^^pan> pan style="font-size: 12px; color: rgb(0, 0, 0); font-family: 돋움, Dotum, Helvetica, sans-serif; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal;">--------------------------------------------------------pan> pan lang="EN-US">ace="맑은 고딕" size="2">
pan>
ace="맑은 고딕">pan style="BACKGROUND: yellow; mso-highlight: yellow">발주 프로세스pan lang="EN-US"> :pan>pan>pan lang="EN-US"> pan>
pan lang="EN-US">ace="맑은 고딕" size="2"> pan>
pan lang="EN-US" style="mso-bidi-font-family: "맑은 고딕"">pan style="mso-list: Ignore">ace="맑은 고딕" size="2">1.pan style="FONT: 7pt "Times New Roman""> pan>pan>pan>ace="맑은 고딕">프로젝트 수주 후 각 한 프로젝트당 pan lang="EN-US">TAG (JOB)pan>번호 부여됨pan lang="EN-US"> (EX : TKR-19005P )pan>
pan lang="EN-US" style="mso-bidi-font-family: "맑은 고딕"">pan style="mso-list: Ignore">ace="맑은 고딕" size="2">2.pan style="FONT: 7pt "Times New Roman""> pan>pan>pan>ace="맑은 고딕">해당 번호를 기준으로 한 프로젝트당 대략적pan lang="EN-US"> BOM pan>이 나옴pan lang="EN-US"> (BILL OF MATERIAL) pan>
ace="맑은 고딕">이pan lang="EN-US"> BOM pan>은 전체 필요한 자재 리스트 이며 아주 간략히 나옴 pan lang="EN-US">pan>
pan lang="EN-US" style="mso-bidi-font-family: "맑은 고딕"">pan style="mso-list: Ignore">ace="맑은 고딕" size="2">3.pan style="FONT: 7pt "Times New Roman""> pan>pan>pan>ace="맑은 고딕">이pan lang="EN-US"> BOM pan>을 기준으로 각 아이템 별로 순차적으로 설계에서 구매로 발주 요청을 함pan lang="EN-US">pan>
ace="맑은 고딕">pan lang="EN-US">-pan>발주 요청 시 업체의 견적서pan lang="EN-US">, pan>도면pan lang="EN-US">, Detail pan>아이템 리스트pan lang="EN-US">(pan>엑셀파일pan lang="EN-US">) , pan>검사 관련pan lang="EN-US"> ITP pan>등 자료가 첨부로 제공됨pan lang="EN-US">pan>
pan lang="EN-US" style="mso-bidi-font-family: "맑은 고딕"">pan style="mso-list: Ignore">ace="맑은 고딕" size="2">4.pan style="FONT: 7pt "Times New Roman""> pan>pan>pan>ace="맑은 고딕">해당pan lang="EN-US"> Detail pan>아이템 리스트를 기준으로 구매에서 여러 업체에 견적 요청을 하고pan lang="EN-US"> 1pan>군데로 발주 진행 pan lang="EN-US">pan>
ace="맑은 고딕">pan lang="EN-US">-pan>발주 전 각 자재 별pan lang="EN-US"> (pan>발주서당pan lang="EN-US">) pan>목표가pan lang="EN-US"> (pan>예산pan lang="EN-US">) pan>이 있음 pan lang="EN-US">pan>
pan lang="EN-US" style="mso-bidi-font-family: "맑은 고딕"">pan style="mso-list: Ignore">ace="맑은 고딕" size="2">5.pan style="FONT: 7pt "Times New Roman""> pan>pan>pan>ace="맑은 고딕">발주서 작성을 하고 승인을 받아 발주서를 업체에 전달 하고 확인 서명 회신본을 받음 pan lang="EN-US">pan>
pan lang="EN-US" style="mso-bidi-font-family: "맑은 고딕"">pan style="mso-list: Ignore">ace="맑은 고딕" size="2">6.pan style="FONT: 7pt "Times New Roman""> pan>pan>pan>ace="맑은 고딕">필요시 중간에pan lang="EN-US"> revision pan>을 하고 재 송부pan lang="EN-US">, pan>도면 승인pan lang="EN-US"> , pan>제작 납기 관리pan lang="EN-US">pan>
pan lang="EN-US" style="mso-bidi-font-family: "맑은 고딕"">pan style="mso-list: Ignore">ace="맑은 고딕" size="2">7.pan style="FONT: 7pt "Times New Roman""> pan>pan>pan>ace="맑은 고딕">협의된 입고 일자에 입고가 되면 구매물류에서 가입고pan lang="EN-US">(pan>검수pan lang="EN-US">) pan>처리 하고 품질에서 검사가 완료되면 생산 투입 pan lang="EN-US">pan>
pan lang="EN-US">ace="맑은 고딕" size="2"> pan>
pan lang="EN-US">ace="맑은 고딕" size="2"> pan>
ace="맑은 고딕">pan lang="EN-US" style="BACKGROUND: yellow; mso-highlight: yellow">TK pan>pan style="BACKGROUND: yellow; mso-highlight: yellow">요청 사항pan lang="EN-US"> :pan>pan>pan lang="EN-US">pan>
pan lang="EN-US">ace="맑은 고딕" size="2"> pan>
ace="맑은 고딕">pan lang="EN-US">-pan>각pan lang="EN-US"> Detail pan>아이템 리스트별 엑셀 파일이 시스템에 업로드 될 수 있음pan lang="EN-US"> (pan>별도의pan lang="EN-US"> typpan class='search_bold'>ingpan> pan>없이pan lang="EN-US">)pan>
ace="맑은 고딕">pan lang="EN-US">-TK pan>발주서 양식이 그대로 구현될 것 pan lang="EN-US">pan>
ace="맑은 고딕">pan lang="EN-US">-TK pan>발주서 내용을 작성자가 원하는 내용 대로 작성이 가능하도록 빈칸이 많을 것 pan lang="EN-US">pan>
ace="맑은 고딕">pan lang="EN-US">-pan>설계에서 혹은 생산에서 혹은 품질에서 구매로 구매 요청을 시스템으로 가능하도록 할 것 pan lang="EN-US">pan>
ace="맑은 고딕">pan lang="EN-US">-pan>구매 요청 시 업체 견적서pan lang="EN-US">,pan>도면pan lang="EN-US">,pan>등등 자료가 첨부 가능 하도록 할 것 pan lang="EN-US">pan>
ace="맑은 고딕">pan lang="EN-US">-pan>프로젝트pan lang="EN-US"> TAG pan>별pan lang="EN-US">, pan>아이템 명pan lang="EN-US">, pan>아이템pan lang="EN-US"> TAG pan>별pan lang="EN-US">, pan>발주서번호별pan lang="EN-US">, pan>모두pan lang="EN-US"> SORTING pan>가능할 것 pan lang="EN-US">pan>
ace="맑은 고딕">pan lang="EN-US">(pan>예시로 한 프로젝트pan lang="EN-US"> TAG pan>를 누르면 해당 프로젝트 모든 발주 내역이 다 나올 것pan lang="EN-US"> /pan>
ace="맑은 고딕">한 아이템을 누르면 해당 아이템별 기 발주 내역pan lang="EN-US">(pan>예산pan lang="EN-US">,pan>발주가등 금액포함pan lang="EN-US">) pan>및 납기등이 다 나올 것pan lang="EN-US">)pan>
ace="맑은 고딕">pan lang="EN-US">-pan>신규 발주서 작성시 발주 번호 자동 생성 부여 표기 될 것 pan lang="EN-US">pan>
ace="맑은 고딕">pan lang="EN-US">-pan>신규 발주서 작성시 작성자명 자동 생성 부여 표기 될 것 pan lang="EN-US">pan>
ace="맑은 고딕">pan lang="EN-US">-pan>수정 발주서 작성시 신규 발주 번호는 그대로 유지하고pan lang="EN-US"> REVISION 1,2 pan>로 표기 될 것pan lang="EN-US"> (pan>작성자명pan lang="EN-US"> ORIGINAL pan>과 다를수 있음pan lang="EN-US">)pan>
ace="맑은 고딕">pan lang="EN-US">-pan>발주서상 상단 오른쪽 납기일pan lang="EN-US"> , pan>운송 조건등은 작성자가 임의로 작성이 가능하도록 할 것 pan lang="EN-US">pan>
ace="맑은 고딕">pan lang="EN-US">-pan>발주서상 하단pan lang="EN-US"> CONDITION pan>부분pan lang="EN-US"> Structure pan>만 유지 하고 내용은 작성자가 원하는 내용으로 표기 가능 할 것 pan lang="EN-US">pan>
ace="맑은 고딕">pan lang="EN-US">-pan>각 아이텝별 납기 일자 수정이 가능 할 것 pan lang="EN-US">pan>
ace="맑은 고딕">pan lang="EN-US">-pan>각 아이템별 도면 승인pan lang="EN-US"> (pan>제작 승인pan lang="EN-US">) pan>일자 표기 가 가능 할 것 pan lang="EN-US">pan>
ace="맑은 고딕">pan lang="EN-US">-pan>각 발주서별 대금지불조건 표기 가능 할 것 pan lang="EN-US">pan>
ace="맑은 고딕">pan lang="EN-US">-pan>입고 처리시pan lang="EN-US"> TAP pan>으로 현장에서 바로 가입고pan lang="EN-US">(=pan>입고검사요청pan lang="EN-US">) pan>처리 가능할 것pan lang="EN-US"> (BY pan>구매물류 담당자pan lang="EN-US">)pan>
ace="맑은 고딕">pan lang="EN-US">-pan>입고 처리 수정이 가능하고 검사시 합pan lang="EN-US">/pan>불 여부 처리 가능 할 것pan lang="EN-US"> (BY pan>품질팀 담당자pan lang="EN-US">)pan>
ace="맑은 고딕">pan lang="EN-US">-pan>합pan lang="EN-US">/pan>불 품질 처리가 완료되면 해당 자재 소모 여부pan lang="EN-US">(pan>생산투입pan lang="EN-US">) pan>처리 가능 할 것pan lang="EN-US"> (BY pan>생산팀 담당자pan lang="EN-US">)pan>
pan lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: "맑은 고딕"; mso-bidi-font-family: 굴림; mso-ansi-language: EN-US; mso-fareast-language: KO; mso-bidi-language: AR-SA">path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"> instyle="miter">path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f">path>ck aspectratio="t" v:ext="edit">ck>pan>
pan>
-
최종문의 드립니다.
pan style="font-size: 11pt;">
pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">■ 가견적 내용pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">
1.항목 정보 : 2공수pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;"> * 벨트, 지역 등 목록 정의
2.회원 정보 : 3공수pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;"> * 가입일자, 이름, 영문명, 이메일 등 개인정보pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">pan style="line-height: 20px !important; bpan class='search_bold'>ackpan>ground-color: rgb(255, 167, 0); color: rgb(255, 255, 255);"> * 증명사진(파일첨부)pan>
pan style="line-height: 20px !important; bpan class='search_bold'>ackpan>ground-color: rgb(255, 167, 0); color: rgb(255, 255, 255);"> pan>pan style="line-height: 20px !important; bpan class='search_bold'>ackpan>ground-color: rgb(255, 167, 0); color: rgb(255, 255, 255);">* pan>pan style="line-height: 20px !important; color: rgb(255, 255, 255); bpan class='search_bold'>ackpan>ground-color: rgb(255, 167, 0);">사단법인 대하주짓수회 멤버쉽(양식) : 3공수pan>
3.이력 관리 : 7공수pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;"> *자격증 관리pan style="line-height: 20px !important; bpan class='search_bold'>ackpan>ground-color: rgb(255, 167, 0);">(pan style="color: rgb(255, 255, 255); line-height: 20px !important;">파일첨부pan>)pan>pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;"> *승급 관리 : 승급 최소규정(예외시 증명사항 기재)pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;"> *팀이력(pan style="line-height: 20px !important; bpan class='search_bold'>ackpan>ground-color: rgb(255, 167, 0); color: rgb(255, 255, 255);">소속도장pan>) 관리pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;"> *제명 관리(허위사실)pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">
4.연회비 관리 : 4공수pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;"> *회원별 입금내역 관리
5.납부현황 : 4공수pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;"> *검색항목 : 기준년, 지역, 벨트pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;"> *연회비 납부현황, 미납금, 수련기간(자동계산) 등 조회pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">
pan>pan style="color: rgb(255, 0, 0);">회비 납부 필증 기능:2 공수 - 삭제pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">
6.회원현황 : 5공수pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">
*검색항목 : 지역, pan style="line-height: 20px !important; bpan class='search_bold'>ackpan>ground-color: rgb(255, 167, 0); color: rgb(255, 255, 255);">소속도장pan>, 벨트pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;"> *지역별 회원(현재) 승급, 팀 등 조회
pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(255, 0, 0); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">7.문자발송서비스 : 10공수 - 삭제pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;"> pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">pan style="line-height: 20px !important; bpan class='search_bold'>ackpan>ground-color: rgb(255, 167, 0); color: rgb(255, 255, 255);">8.메일발송 : 5공수
* 첨부파일(납부필증/안내문 등 양식)과 함께 메일 전송
pan>
pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">
pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">pan style="font-family: 함초롬바탕; font-size: 11pt;">안녕하십니까pan>pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">, pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">앞 서 문의드린 내용 및 가견적 내 주신 부분들 검토하여 최종적으로 문의 드립니다pan>pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">.pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-size: 11pt; color: rgb(255, 0, 0);"> pan>pan style="font-size: 11pt; color: rgb(255, 0, 0);"> pan>pan style="font-size: 11pt; color: rgb(255, 0, 0);"> pan> pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt; color: rgb(255, 0, 0);">- pan>pan style="font-family: 함초롬바탕; font-size: 11pt; color: rgb(255, 0, 0);">문자발송 기능 삭제pan> pan style="font-size: 11pt; color: rgb(255, 0, 0);"> pan>pan style="font-size: 11pt; color: rgb(255, 0, 0);"> pan>pan style="font-size: 11pt; color: rgb(255, 0, 0);"> pan> pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt; color: rgb(255, 0, 0);">- pan>pan style="font-family: 함초롬바탕; font-size: 11pt; color: rgb(255, 0, 0);">납부필증 삭제pan> pan style="font-size: 11pt; color: rgb(255, 0, 0);"> pan>pan style="font-size: 11pt; color: rgb(255, 0, 0);"> pan>pan style="font-size: 11pt; color: rgb(255, 0, 0);"> pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-family: 함초롬바탕; letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">?pan>pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">1. pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">회원도장 관리pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-family: 함초롬바탕; font-size: 11pt;">회원도장 가맹시 첨부해 드린 가맹신청서pan>pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">(pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">한글파일pan>pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">) pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">작성 과 구글시트를 모두 작성pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-family: 함초롬바탕; font-size: 11pt;">해당 정보 및 내용 관리pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">(pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">구글시트로 받은 엑셀화 된 정보를 프로그램에 자동으로 입력 되면 좋겠습니다pan>pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">.)pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">- pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">연회비 납입 관리 pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">18.08.20 - 00pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">만원 pan>pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">(18pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">년 연회비 납부pan>pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">)pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">19.06.22 - 00pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">만원 pan>pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">(19pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">년 연회비 납부pan>pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">)pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">20pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">년 연회비 미납pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">2. pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">멤버쉽 관리pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-family: 함초롬바탕; font-size: 11pt;">최초 회원 등록시 회원번호pan>pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">(pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">고유번호pan>pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">)pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">가 자동 발급되어 pan> pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan>pan style="font-size: 11pt;"> pan> pan style="font-family: 함초롬바탕; font-size: 11pt;">멤버쉽pan>pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">(pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">한글파일pan>pan lang="EN-US" style="letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-size: 11pt;">) pan>pan style="font-family: 함초롬바탕; font-size: 11pt;">내용 및 정보 관리 pan> pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">
pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">
pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">
pan> pan style="line-height: 10px; font-size: 9.5pt; font-family: 나눔고딕, NanumGothic, sans-serif; color: rgb(65, 64, 66); letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: -1px;">
pan>
pan>
-
공연실적 프로그래밍화
pan style="font-size: 11pt;">
ng>1.업종 : 공연서비스ng>
ng>2.예산 : 처음 제작이라 추정할 수 없음.ng>
ng>3.제작 요청사항ng>
ng>1)업무흐름 및 기존 업무방식ng>
ng>2)자동화하고 싶은 업무ng>
*
*
*pan style="font-size:18.0pt;mso-bidi-font-size:20.0pt">공연예술팀
실적관리 시스템pan>
pan>
pan lang="EN-US"> pan>
시스템 구축 사유pan lang="EN-US">: pan>기존 엑셀 실적자료 수식은 자잘한 실수가 발생하여
원하는 항목 필터링 시 자주 수치가 변경됨pan lang="EN-US">. pan>셀통합시 필터링에서 누락되는 경우 발생pan lang="EN-US">.pan>
pan lang="EN-US"> pan>
구조pan lang="EN-US">pan>
pan lang="EN-US">1.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>대관공연 실적pan lang="EN-US">pan>
pan lang="EN-US">A.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>pan lang="EN-US">4pan>개 공연장의 대관정보pan lang="EN-US">(raw data: pan>엑셀pan lang="EN-US">), pan>연도별 약 pan lang="EN-US">150pan>건pan lang="EN-US">, pan>약 pan lang="EN-US">10pan>년 이내
누적자료 업로드 필요pan lang="EN-US">pan>
pan lang="EN-US">B.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>pan lang="EN-US">row pan>항목pan lang="EN-US">:
pan>연도pan lang="EN-US">, pan>공연장이름pan lang="EN-US">, pan>공연일pan lang="EN-US">, pan>무대준비일pan lang="EN-US">, pan>대관료pan lang="EN-US">, pan>관람객
수 등 pan lang="EN-US">30pan>개pan lang="EN-US">pan>
pan lang="EN-US">C.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>가공 데이터pan lang="EN-US">: pan>연도별 총 대관 횟수pan lang="EN-US">, pan>총 관람객 수 등 다양한 항목으로 필터링 되어야 함pan lang="EN-US">.pan>
pan lang="EN-US">2.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>기획공연 실적pan lang="EN-US">pan>
pan lang="EN-US">A.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>pan lang="EN-US">4pan>개 공연장의 기획공연 집행 정보pan lang="EN-US">(raw data: pan>엑셀pan lang="EN-US">), pan>연도별 약 pan lang="EN-US">100pan>건pan lang="EN-US">, pan>약 pan lang="EN-US">10pan>년 이내
누적자료 업로드 필요pan lang="EN-US">pan>
pan lang="EN-US">B.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>pan lang="EN-US">Row pan>항목pan lang="EN-US">:
pan>연도pan lang="EN-US">, pan>공연장이름pan lang="EN-US">, pan>공연일pan lang="EN-US">, pan>티켓비pan lang="EN-US">, pan>관람객 수pan lang="EN-US">(pan>약
pan lang="EN-US">20pan>여개 권종 입력pan lang="EN-US">), pan>예산 등 pan lang="EN-US">40pan>개 항목pan lang="EN-US">pan>
pan lang="EN-US">C.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>공연별 할인내역 상세
pan lang="EN-US">D.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>가공 데이터pan lang="EN-US">: pan>연도별 총 기획공연 횟수pan lang="EN-US">, pan>관람객 수pan lang="EN-US">, pan>장르 구분 등 다양한 항목으로 필터링 되어야 함pan lang="EN-US">.pan>
pan lang="EN-US">3.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>공연장 가동율pan lang="EN-US">pan>
pan lang="EN-US">A.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>pan lang="EN-US">3pan>개 공연장의 무대준비pan lang="EN-US">, pan>공연당일pan lang="EN-US">, pan>유지보수일 등 설정pan lang="EN-US">pan>
pan lang="EN-US">B.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>가동율 통계 필요pan lang="EN-US">pan>
pan lang="EN-US"> pan>
공통기능pan lang="EN-US">pan>
pan lang="EN-US">1.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>모바일 버전 필요 없음pan lang="EN-US">. PC pan>접속 기준pan lang="EN-US">.pan>
pan lang="EN-US">2.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>검색 기능pan lang="EN-US">: pan>공연명pan lang="EN-US">, pan>공연단체명 등으로 검색 필요pan lang="EN-US">pan>
pan lang="EN-US">3.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>필터링한 데이터 엑셀 다운로드pan lang="EN-US">pan>
pan lang="EN-US">4.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>항목은 관리자가 신규 추가할 수 있어야 함pan lang="EN-US">(ex. pan>기획공연에서
새로운 할인 권종 등pan lang="EN-US">)pan>
pan lang="EN-US">5.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>웹 기반으로 구축pan lang="EN-US">. pan>담당자 변경시에 로그인만
하면 접속 가능해야 함pan lang="EN-US">. pan>
pan lang="EN-US"> pan>
비용 결제pan lang="EN-US">pan>
pan lang="EN-US">1.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>초기구축비용 일괄 지불pan lang="EN-US">pan>
pan lang="EN-US">2.pan style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-kernpan class='search_bold'>ingpan>: auto; font-optical-sizpan class='search_bold'>ingpan>: auto; font-feature-settpan class='search_bold'>ingpan>s: normal; font-variation-settpan class='search_bold'>ingpan>s: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";">
pan>pan>구축 이후 분기 단위 유지보수pan lang="EN-US">/pan>서버이용 등 비용
지불pan lang="EN-US">pan>
-
견적 수정 요청드립니다.
ac e="맑은 고딕"> 요청사항 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">.
-
[맞춤제작 컨설팅] 발주 및 납품, 프로젝트별 자동화 프로그램 요청 (가견적 상세내용 선택 후 재문의)
pa n la ng="EN-US">1. pan>업종 pan lang="EN-US"> : pan>집열패널
제조업 pan lang="EN-US">pan>
pan lang="EN-US">2. pan>예산pan lang="EN-US"> : pan>조달청 입찰공고
낙찰후 선금을 받아서 진행하는 구조라 유동성이 있음pan lang="EN-US">pan>
pan lang="EN-US">3. pan>제작 요청 사항pan lang="EN-US">pan>
pan lang="EN-US">pan style="mso-span class='search_bold'>pacpan>erun:yes"> pan>1) pan>업무
흐름pan lang="EN-US">(pan>프로세스pan lang="EN-US">)pan>
pan lang="EN-US">pan style="mso-span class='search_bold'>pacpan>erun:yes"> pan>pan>저희는
공기식태양열집열패널을 입찰 받아서 해외에서 수입후 납품 및 설치하는 업체입니다pan lang="EN-US">. pan>
pan lang="EN-US">pan style="mso-span class='search_bold'>pacpan>erun:yes"> pan>pan>간단하게 말씀드리자면pan lang="EN-US"> 'pan>원재료 발주pan lang="EN-US"> → pan>기간고려후 제품생산pan lang="EN-US">(pan>해외pan lang="EN-US">) → pan>납품 및 설치pan lang="EN-US">'pan>입니다pan lang="EN-US">.pan>
pan lang="EN-US">pan style="mso-span class='search_bold'>pacpan>erun:yes"> pan>pan>원재료를 해외에
발주하고 제품을생산하고pan lang="EN-US">(pan>해외pan lang="EN-US">), pan>통관절차를 거쳐 제품을 납품처로
납품 및 설치하는 업체입니다pan lang="EN-US">. pan>설치는 하도급으로 진행됩니다pan lang="EN-US">. pan>
pan lang="EN-US">pan style="mso-span class='search_bold'>pacpan>erun:yes"> pan>pan>해외에 발주시 제품
생산소요시간은pan lang="EN-US"> 6pan>주정도 예상이며pan lang="EN-US">, pan>긴급배송은pan lang="EN-US"> 2~3pan>주pan lang="EN-US">(pan>항공운송 및 통관pan lang="EN-US">)pan>이이
일반적인 것은 해상운송이며pan lang="EN-US"> 5pan>주정도의 기간이 걸립니다pan lang="EN-US">.pan style="mso-span class='search_bold'>pacpan>erun:yes"> pan>pan>
pan lang="EN-US"> pan>
pan lang="EN-US">pan style="mso-span class='search_bold'>pacpan>erun:yes"> pan>2) pan>기존
업무 방식pan lang="EN-US">pan>
기존에는 현금흐름표와 거래처 미지급대장 및 통관업무 등을 별도의
엑셀로 관리하고 있으며pan lang="EN-US">, pan>
기업은행과 함께하는 회계프로그램pan lang="EN-US"> SERPpan>프로그램을 사용중에 있습니다pan lang="EN-US">. pan>
pan lang="EN-US"> pan>
pan lang="EN-US"> pan>
pan lang="EN-US"> pan>
pan lang="EN-US">****위pan> 내용 기존 견적 요청 때와 동일pan lang="EN-US">****pan>
pan lang="EN-US"> pan>
pan lang="EN-US"> pan>
pan lang="EN-US"> ****아래 내용 추가 문의****pan>
pan lang="EN-US"> pan>
pan lang="EN-US"> pan> pan lang="EN-US">3)pan>자동화 하고 싶은 업무pan lang="EN-US">pan>
기존에 받은 가견적 세부 내용 중 금차에 제작하고 싶은 항목들을 아래와 같이 선택하였습니다pan lang="EN-US">. pan>
pan lang="EN-US"> pan>
pan lang="EN-US" style="color: rgb(58, 50, 195);">1. pan>pan style="color: rgb(58, 50, 195);">기본정보 등록 및 관리pan>pan lang="EN-US" style="color: rgb(58, 50, 195);"> :pan>
pan lang="EN-US" style="color: rgb(58, 50, 195);">- pan>pan style="color: rgb(58, 50, 195);">원재료 입고처 정보 등록 및 관리pan>pan lang="EN-US" style="color: rgb(58, 50, 195);"> (2pan>pan style="color: rgb(58, 50, 195);">공수pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">)pan>
pan lang="EN-US" style="color: rgb(58, 50, 195);">- pan>pan style="color: rgb(58, 50, 195);">생산공장pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">/pan>pan style="color: rgb(58, 50, 195);">하도급업체
정보 등록 및 관리pan>pan lang="EN-US" style="color: rgb(58, 50, 195);"> (3pan>pan style="color: rgb(58, 50, 195);">공수pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">)pan>
pan lang="EN-US" style="color: rgb(58, 50, 195);">- pan>pan style="color: rgb(58, 50, 195);">프로젝트 등록pan>pan lang="EN-US" style="color: rgb(58, 50, 195);"> (3pan>pan style="color: rgb(58, 50, 195);">공수pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">) pan>
pan lang="EN-US">pan style="color: rgb(58, 50, 195);"> pan>pan>
pan lang="EN-US" style="color: rgb(58, 50, 195);">2. pan>pan style="color: rgb(58, 50, 195);">내역입력pan>pan lang="EN-US" style="color: rgb(58, 50, 195);"> : pan>
pan lang="EN-US" style="color: rgb(58, 50, 195);">- pan>pan style="color: rgb(58, 50, 195);">원재료 발주pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">/pan>pan style="color: rgb(58, 50, 195);">도착 내역
입력pan>pan lang="EN-US" style="color: rgb(58, 50, 195);"> (3pan>pan style="color: rgb(58, 50, 195);">공수pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">)pan>
pan lang="EN-US" style="color: rgb(58, 50, 195);">- pan>pan style="color: rgb(58, 50, 195);">설치일정pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">/pan>pan style="color: rgb(58, 50, 195);">여부 내역
입력pan>pan lang="EN-US" style="color: rgb(58, 50, 195);"> (3pan>pan style="color: rgb(58, 50, 195);">공수pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">)pan>
pan lang="EN-US">pan style="color: rgb(58, 50, 195);"> pan>pan>pan style="color: rgb(58, 50, 195);">ㄴ
배송정보 및 도착여부 기록 및 관리pan>pan lang="EN-US" style="color: rgb(58, 50, 195);"> (3pan>pan style="color: rgb(58, 50, 195);">공수pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">)pan>
pan lang="EN-US" style="color: rgb(58, 50, 195);">- pan>pan style="color: rgb(58, 50, 195);">거래처별 수금pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">/pan>pan style="color: rgb(58, 50, 195);">지급내역
관리pan>pan lang="EN-US" style="color: rgb(58, 50, 195);"> (5pan>pan style="color: rgb(58, 50, 195);">공수pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">)pan>
pan lang="EN-US">pan style="color: rgb(58, 50, 195);"> pan>pan>pan style="color: rgb(58, 50, 195);">ㄴ
수금pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">/pan>pan style="color: rgb(58, 50, 195);">지급형태 기록 및 반영pan>pan lang="EN-US" style="color: rgb(58, 50, 195);"> (3pan>pan style="color: rgb(58, 50, 195);">공수pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">)pan>
pan lang="EN-US">pan style="color: rgb(58, 50, 195);"> pan>pan>
pan lang="EN-US" style="color: rgb(58, 50, 195);">3. pan>pan style="color: rgb(58, 50, 195);">조회pan>pan lang="EN-US" style="color: rgb(58, 50, 195);"> : pan>
pan lang="EN-US" style="color: rgb(58, 50, 195);">- pan>pan style="color: rgb(58, 50, 195);">기준년도 월별 프로젝트별 채무레포트 자동조회pan>pan lang="EN-US" style="color: rgb(58, 50, 195);"> (5pan>pan style="color: rgb(58, 50, 195);">공수pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">)pan>
pan lang="EN-US" style="color: rgb(58, 50, 195);">- pan>pan style="color: rgb(58, 50, 195);">프로젝트별 현금흐름표 자동조회pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">
(5pan>pan style="color: rgb(58, 50, 195);">공수pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">)pan>
pan lang="EN-US" style="color: rgb(58, 50, 195);">- pan>pan style="color: rgb(58, 50, 195);">기준년도 월별 거래처별 미수pan>pan lang="EN-US" style="color: rgb(58, 50, 195);">/pan>pan style="color: rgb(58, 50, 195);">미지급대장
자동조회pan>pan lang="EN-US" style="color: rgb(58, 50, 195);"> (3pan>pan style="color: rgb(58, 50, 195);">공수pan>pan lang="EN-US">pan style="color: rgb(58, 50, 195);">)pan>pan>
pan lang="EN-US"> pan> pan lang="EN-US">
pan>
pan lang="EN-US"> pan>
pan lang="EN-US">**pan>추가 질문 사항pan lang="EN-US">pan>
pan lang="EN-US" style="mso-ascii-font-family:"맑은 고딕";mso-fareast-font-family:"맑은 고딕";
mso-hansi-font-family:"맑은 고딕";mso-bidi-font-family:"맑은 고딕"">pan style="mso-list:Ignore">
pan>pan> pan lang="EN-US" style="mso-ascii-font-family:"맑은 고딕";mso-fareast-font-family:"맑은 고딕";
mso-hansi-font-family:"맑은 고딕";mso-bidi-font-family:"맑은 고딕"">pan style="mso-list:Ignore">-pan style="font:7.0pt "Times New Roman"">
pan>pan>pan>위 내용으로 맞춤제작 진행한다면pan lang="EN-US"> (pan>최초 작업
전 방문컨설팅 포함pan lang="EN-US">) pan>총 제작 기간이 대략 얼마나 될지요pan lang="EN-US">?pan> pan lang="EN-US"> pan> pan lang="EN-US">- 폼 개발 전 결제를 해야한다고 소개되어 있는데, 최초 결제 시 이용권 금액 결제만 하면 신청이 되는 것인지요? 그리고 맞춤 제작에 대한 선금:잔금 비율이 어느 정도인지, pan>pan style="text-indent: -18pt;">합의 가능 여부 등 비용 결제 방식에 대한 상세한 설명 부탁드립니다. pan> pan lang="EN-US"> pan>
pan lang="EN-US" style="mso-ascii-font-family:"맑은 고딕";mso-fareast-font-family:"맑은 고딕";
mso-hansi-font-family:"맑은 고딕";mso-bidi-font-family:"맑은 고딕"">pan style="mso-list:Ignore">-pan style="font:7.0pt "Times New Roman"">
pan>pan>pan>pan lang="EN-US">pan style="mso-span class='search_bold'>pacpan>erun:yes"> pan>pan>최종 제작 완료된 프로그램은 저희 회사측에서 기존 엑셀 파일 사용하듯이
사용할 수 있는 것인지요pan lang="EN-US">? pan>혹시 차이점이 있는 것인지 궁금합니다pan lang="EN-US">. pan>
-
제목 : 판매재고관리 자동화를 요청합니다.
주문서 파일 자동화 요청드립니다.
저희는 스포츠용품을 전문으로 판매하는 인터넷 쇼핑몰입니다.
오픈마켓을 주로 하다보니 엑셀로 다운을 받아서 사용하는데요.
거래처라 20군데 이상되어서 거래처별로 일단 주문서가 깔끔하면 정리가 되어서 뽑혔으면 좋겠구요.
홍보나 광고 문구가 많다보니, 그걸 일일이 지우거나 매크로로 지우곤 했는데 시간이 너무 많이 걸리네요
또한 그날 발송건이 있고 또한 품절건과 내일이나 모레 저희쪽으로 택배로 오는 거래처도 있습니다.
그부분들만 저희가 나누면 따로 관리가 되게 할수도 있는것인지두요~
일단 예문을 보면요.
나이키 운동화/GG-12345-678/에어맥스 2014 인기런닝화 패션화 캐주얼화 등등
아디다스 운동화/DF-G12345/아드리아 로우 패션화 캐주얼화 커플화 등등
여기서 GG- , DF- 이건 저희 거래처 창고 코드 입니다. 이것대로 발주가 들어갑니다.
주문서를 거래처로 넣을때 GG 는
1. 에어맥스 2014 12345-678 1개
DF거래처는
2. 아드리아 로우 G12345 1개
이런식으로 정리가 되어서 뽑히게 할수 있는지요?
필터링에, 매크로, 다 써봐도 완전 노가다네요.
문구가 좀 제각각이긴 하지만 좋은 방법이 있다면 훨씬 효과적일거 같아요.
주문서 들어온거랑 주문넣는 거래처 양식 예제로 보내드립니다.
연락부탁드립니다.
그외에도 여기 처음 알게 되어 보니 정말 대단하십니다.
저희 거래처 양식은 따로 없지만
보내드린 주문서로
AC-, AD-, RB- 등으로 알파벳 마다 품번, 제품명 수량등을 넣어주거든요
pan class='search_bold'>pacpan>pan class='search_bold'>ingpan>=0 cellPaddpan class='search_bold'>ingpan>=0>
| 예> AC- 주문서입니다. |
|
|
|
|
|
| 1 |
트레포일 레깅스 |
M30676 |
85 |
1 |
|
| 2 |
파이어버드 |
M30463 |
85 |
1 |
|
| 3 |
SPO크루 스웨트 |
G90919 |
90 |
1 |
|
| 4 |
SPO크루 스웨트 |
G90919 |
90 |
1 |
|
| 5 |
파이어버드 |
M30463 |
95 |
1 |
|
| 6 |
SPO크루 스웨트 |
M32686 |
95 |
1 |
|
| 7 |
SPO크루 스웨트 |
G90919 |
100 |
1 |
|
| 8 |
W CHILE CREWNEC 칠 크루넥 |
F50312 |
100 |
1 |
|
| 9 |
슈퍼 배기 트랙팬츠 |
M69912 |
100 |
1 |
|
| 10 |
아카이브 후디 |
S87507 |
100 |
1 |
|
이런식으로 알파벳 거래처 코드만큼 다 들어가고 답변을 받아 양식을 정리해서 발송을 내보냅니다.
일단 품절되는것도 있을것이고, 내일 나가는것도 있을것이고, 이거까지 같이 정리 되면 더 좋구여,
일단 이해 되셨을거라 믿습니다. 연락주시면 감사하겠습니다.
업무자동화 맞춤제작
고객님의 상황에 100% 맞춘 콘텐츠 제작 전문 서비스를 이용해 보세요.
프리미엄 무료 이벤트 중
|
회사소개 이용약관 최종사용자라이선스 개인정보취급방침 이메일 주소 수집거부 제휴·광고문의
KaKao ID 친구추가 : @coukey | 대표자 : 이정우 | 
