ng>1.업종 : 와인 수입사ng>
 

ng>2.예산 : ng>
 

ng>3.제작 요청사항ng>
 

pan style="font-family: "Helvetica Neue"; font-size: 13px;">[ 업무흐름 및 기존 업무방식 ]pan>

당사는 해외에서 와인 및 음료 제품을 수입하여 한국에 있는 거래처(레스토랑, 와인바, 와인샵, 백화점 등)에 납품하는 회사입니다.pan class="Apple-converted-span class='search_bold'>pacpan>e"> pan>

현재 이카운트 ERP 프로그램을 사용 중이며, 이 이카운트에 등로된 데이터를 활용하여 한 눈에 우리의 비즈니스 상황을 체크/확인/점검할 수 있는 아래 각 리포트를 만들 수 있는 엑셀 프로그램 제작 상담을 요청드립니다.pan class="Apple-converted-span class='search_bold'>pacpan>e"> pan>

아래 내용 확인하시고 빠른 답변 부탁드립니다.pan class="Apple-converted-span class='search_bold'>pacpan>e"> pan>

감사합니다.pan class="Apple-converted-span class='search_bold'>pacpan>e"> pan>

ng style="font-family: 돋움, Dotum, Helvetica, sans-serif; font-size: 14.6667px;">
ng>

ng style="font-family: 돋움, Dotum, Helvetica, sans-serif; font-size: 14.6667px;">2)자동화하고 싶은 업무ng>
pan style="font-family: 돋움, Dotum, Helvetica, sans-serif; font-size: 14.6667px;">*pan>
pan style="font-family: 돋움, Dotum, Helvetica, sans-serif; font-size: 14.6667px;">*pan>
pan style="font-family: 돋움, Dotum, Helvetica, sans-serif; font-size: 14.6667px;">*pan>

pan style="font-family: 돋움, Dotum, Helvetica, sans-serif; font-size: 14.6667px;"> pan>

1. 고객 관리 리포트

목적: 고객별 구매 행동 및 성과 분석.

주요 내용:

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>고객별 매출 분석: 고객 이름, 특정 기간별 구매 횟수, 총 구매액, 최근 구매일.

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>고객별 전월, 작년 대비 매출 성과 데이터 분석

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>고객별 최근 구매 일자

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>월별 신규 거래처 매출 비중

2. 매출 관리 리포트

목적: 매출 성과 추적 및 주요 원인 파악.

주요 내용:

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>월별/분기별 매출 분석: 기간별 매출 추이, 목표 대비 달성률.

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>제품별 매출 비중: 베스트셀러 제품 TOP 10, 저조한 매출 제품.

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>거래처 업종별 분석: 각 거래처의 업종별 매출 성과.(온라인 포함)

3. 데일리 매출 리포트

목적: 일일 성과 확인 및 신속한 의사결정 지원.

주요 내용:

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>일일 총 매출: 당일 매출 금액, 전일 대비 증감률, 월간 목표 대비 퍼센트.

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>판매 제품 상세: 판매 제품 순위, 판매 수량, 재고 변동.

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>거래처 업종별 매출: 거래처 각 업종의 매출 및 주문 수.(레스토랑, 와인바, 와인샵, 백화점 등)

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>고객 행동 분석: 신규 고객 수, 재구매율, 활발한 구매 시간대.

4. 재고 관리 리포트

목적: 효율적인 재고 관리 및 비용 절감.

주요 내용:

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>재고 회전율 분석: 제품별 회전율, 낮은 회전율 제품 리스트.

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>제품의 유통기한별 회전율 제품 리스트

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>입출고 내역: 기간별 입출고 기록

5. 비용 관리 리포트
목적: 회사 운영의 비용 효율성을 높이고, 불필요한 지출을 줄이며 수익성을 극대화

주요 내용:

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>비용 항목별 분석: 주요 비용 항목(인건비, 물류비, 마케팅비 등) 및 월별/분기별 변화 추이.

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>제품별 원가 및 마진 분석: 제품별 제조 원가, 물류비용 등을 분석하여 마진율 확인.

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>고정비와 변동비 비교: 고정 비용과 변동 비용의 비율 파악 및 비용 구조 분석.

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>비용 절감 기회: 비용 절감이 가능한 항목 도출 및 제안 사항.

6. 종합 관리 리포트

목적: 사업의 전반적 성과를 요약 및 공유.

주요 내용:

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>사업 성과 요약: 월간 매출, 비용, 순이익.

pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>주요 KPI: 고객 수, 평균 구매 단가, 구매 전환율.

pan class="s1" style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; 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-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";">pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>?pan class="Apple-tab-span" style="white-span class='search_bold'>pacpan>e: pre;"> pan>pan>성장률pan class="s1" style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; 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-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";"> pan>및pan class="s1" style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; 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-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";"> pan>추세pan class="s1" style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; 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-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";"> pan>분석pan class="s1" style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; 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-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";">: pan>전월pan class="s1" style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; 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-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";">, pan>분기별pan class="s1" style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; 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-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";">, pan>전년도pan class="s1" style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; 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-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";"> pan>대비pan class="s1" style="font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-alternates: normal; font-size-adjust: none; 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-variant-position: normal; font-variant-emoji: normal; font-stretch: normal; line-height: normal; font-family: "Helvetica Neue";"> pan>성장률

pan style="color: rgb(0, 117, 200);">기존 내용 중 파란글씨 2가지가 추가부분이며pan>
pan style="color: rgb(0, 117, 200);">빨간부분은 구체적 내용입니다.pan>

pan style="color: rgb(0, 117, 200);">빠른 답변 부탁드립니다.pan>

pan lang="EN-US" style="font-size: 11pt; letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-weight: bold;"> pan>

pan lang="EN-US" style="font-size: 11pt; letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-weight: bold;">1.pan>pan style="font-size: 11pt; font-family: 함초롬바탕; font-weight: bold;">업종 pan>pan lang="EN-US" style="font-size: 11pt; letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-weight: bold;">: pan>pan style="font-size: 11pt; font-family: 함초롬바탕; font-weight: bold;">귀금속수리센터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 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 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;">(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 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;color:#c75252;">: pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">비고란과 같은 곳에 해당고지사항 자동입력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 style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">도금작업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;color:#c75252;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">시계수리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;color:#c75252;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">조각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;color:#c75252;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">레이저마킹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;color:#c75252;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">레이저땜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:10.5pt;">   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 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;color:#c75252;">: pan>pan style="font-family: 돋움; font-weight: bold; color: rgb(0, 117, 200);">탭 필요pan>pan lang="EN-US" style="font-family: 돋움; letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-weight: bold; color: rgb(0, 117, 200);">*(pan>pan style="font-family: 돋움; font-weight: bold; color: rgb(0, 117, 200);">은행처럼pan>pan lang="EN-US" style="font-family: 돋움; letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-weight: bold; color: rgb(0, 117, 200);">)pan>

pan style="mso-fareast-font-family:돋움;font-size:10.5pt;">   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="font-family: 돋움; letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; color: rgb(0, 117, 200);">*pan>pan style="font-family: 돋움; color: rgb(0, 117, 200);">주문발주기능pan>pan lang="EN-US" style="font-family: 돋움; letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; color: rgb(0, 117, 200);">: pan>pan style="font-family: 돋움; color: rgb(0, 117, 200);">지점에서 본사에 주문하기pan>pan lang="EN-US" style="font-family: 돋움; letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; color: rgb(0, 117, 200);">(pan>pan style="font-family: 돋움; color: rgb(0, 117, 200);">수리외의 물품pan>pan lang="EN-US" style="font-family: 돋움; letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; color: rgb(0, 117, 200);">)pan>pan style="font-family: 돋움; color: rgb(0, 117, 200);">가 가능하며 지점별로 월말결산이 가능해야만 합니다pan>pan lang="EN-US" style="font-family: 돋움; letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; color: rgb(0, 117, 200);">.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;color:#c75252;">* pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">결산세부내역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;color:#c75252;">- pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">지점별 수리내역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;color:#c75252;">: pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">건당 세부내역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;color:#c75252;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">일별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;color:#c75252;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">월별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;color:#c75252;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">연도별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;color:#c75252;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">수리종류별 등으로 검색가능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;color:#c75252;">.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;color:#c75252;">- pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">수리비용은 소비자가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;color:#c75252;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">지점산출가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;color:#c75252;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">수리원가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;color:#c75252;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">지점마진 등으로 구성되어야 하며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;color:#c75252;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">소비자가와 지점산출가가 다른 경우 차액이 별도 계산되어야 함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;color:#c75252;">.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;color:#c75252;">- pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">수리비용 입력은 지정된 금액 자동입력과 직접입력으로 구성되어야 함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;color:#c75252;">.: pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">이 경우 수리원가와 지점마진을 직접 입력해야 하는지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;color:#c75252;">??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;color:#c75252;">- pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">주문 발주품 페이지는 어떻게 구성되는지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;color:#c75252;">?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;color:#c75252;">- pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;color:#c75252;">주문 발주품도 위와 같은 구성으로 결산내역이 구성되어야 함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;color:#c75252;">.pan>

pan style="mso-fareast-font-family:한컴바탕;">   pan>