맞춤제작 전문가 답변 검색결과 4,466건
-
법조문암기용 빈칸문제생성 프로그램 제작요청
ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>ti
n; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>안녕하세요.ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>저는ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>변리사시험을ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>준비중인ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>수험생입니다. ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>변리사의ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>주요ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>시험과목은ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>특허법, ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>상표법ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>등과ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>같은ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>법과목들인데ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>이ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>법과목들의ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>공부에ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>있어서ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>가장ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>중요한ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>부분이ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>바로 <ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>법조문>ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>을 ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>암기하는ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>것입니다.
ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>그런데ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>무턱대고ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>법조문을ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>암기하는ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>것은ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>매우ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>비효율적이라ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>여러ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>수험생이ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>모여서ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>그날ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>암기한 ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>법조문들을ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>시험보는ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>형식으로ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>공부를ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>하는데ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>이ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>때ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>빈칸채우기ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>형식으로ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>시험지가ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>자동으로ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>생성&ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>출력될ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>수ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>있도록ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>해주는ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>프로그램이ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>있으면ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>좋겠다는ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>생각이ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>들었습니다.
ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>예를ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>들면
ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>법조문:
ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>특허법 1ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>조: ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>이ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>법은ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>발명을ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>보호.ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>장려하고ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>그ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>이용을ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>도모함으로써ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>기술의ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>발전을ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>촉진하여ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>산업발전에ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>이바지함을ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>목적으로ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>한다
ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>문제:
ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>특허법 1ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>조:ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>이ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>법은ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>발명을 ( ). ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>장려하고ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>그 ( )ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>을 ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>도모함으로써 ( )ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>의ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>발전을 ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>촉진하여 ( )ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>에ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>이바지함을 ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>목적으로ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>한다.
ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>이런식으로ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>말이죠. ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>그래서ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>제가ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>직접ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>엑셀VBA ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>사용하여ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>만들어보려했는데ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>제ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>실력으로는ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>부족하더군요. ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>도움을ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>주실ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>수ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>있으신지요?
ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>일단ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>제가ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>원하는ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>프로그램의ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>모습과ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>요청사항을ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>엑셀에ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>간단히ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>적어서ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>첨부했습니다. ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>보시고ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>대략적인ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>견적을ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>말씀해주세요. ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>학생이라ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>견적이ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>너무ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>높게ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>나오면ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>진행을ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>할ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>수ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>없으니까요. ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>대략적인ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>견적이ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>제가ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>수용가능하다면ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>좀ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>더ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>구체적인ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>요청사항을ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>말씀드리겠습니다. ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>추가되는ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>요청사항에ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>따라ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>견적이ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>올라갈ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>수ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>있음은ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>저도ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>인지하고ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>있습니다. ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>이ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>부분은ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>개발자님과ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>피드백을ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>주고받으며ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>제가ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>지불할ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>수ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>있는ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>비용내에서ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>진행하고ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>싶습니다. ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>하지만ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>제가ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>보내드린ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>엑셀파일의ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>요청사항에서ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>많이ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>벗어나지ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>않을ng=KO> ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>것입니다.
ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>연락부탁드립니다. ng=KO style='FONT-FAMILY: "맑은 고딕"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-laold'>old'>tin; mso-fareast-font-family: "맑은 고딕"; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-laold'>old'>tin'>고맙습니다.
-
"와인 수입사를 위한 맞춤형 엑셀 리포트 제작 상담 요청"
>1.업종 : 와인 수입사ng>ng
ng>2.예산 : ng>
ng>3.제작 요청사항 ng>
[ 업무흐름 및 기존 업무방식 ]
당사는 해외에서 와인 및 음료 제품을 수입하여 한국에 있는 거래처(레스토랑, 와인바, 와인샵, 백화점 등)에 납품하는 회사입니다.
현재 이카운트 ERP 프로그램을 사용 중이며, 이 이카운트에 등로된 데이터를 활용하여 한 눈에 우리의 비즈니스 상황을 체크/확인/점검할 수 있는 아래 각 리포트를 만들 수 있는 엑셀 프로그램 제작 상담을 요청드립니다.
아래 내용 확인하시고 빠른 답변 부탁드립니다.
감사합니다.
ng style="font-family: 돋움, Dotum, Helvold'>eold'>tica, sans-serif; font-size: 14.6667px;"> ng>ng style="font-family: 돋움, Dotum, Helvold'>eold'>tica, sans-serif; font-size: 14.6667px;">2)자동화하고 싶은 업무 ng>
*
*
*1. 고객 관리 리포트
목적: 고객별 구매 행동 및 성과 분석.
주요 내용:
? 고객별 매출 분석: 고객 이름, 특정 기간별 구매 횟수, 총 구매액, 최근 구매일.
? 고객별 전월, 작년 대비 매출 성과 데이터 분석
? 고객별 최근 구매 일자
? 월별 신규 거래처 매출 비중
2. 매출 관리 리포트
목적: 매출 성과 추적 및 주요 원인 파악.
주요 내용:
? 월별/분기별 매출 분석: 기간별 매출 추이, 목표 대비 달성률.
? 제품별 매출 비중: 베스트셀러 제품 TOP 10, 저조한 매출 제품.
? 거래처 업종별 분석: 각 거래처의 업종별 매출 성과.(온라인 포함)
3. 데일리 매출 리포트
목적: 일일 성과 확인 및 신속한 의사결정 지원.
주요 내용:
? 일일 총 매출: 당일 매출 금액, 전일 대비 증감률, 월간 목표 대비 퍼센트.
? 판매 제품 상세: 판매 제품 순위, 판매 수량, 재고 변동.
? 거래처 업종별 매출: 거래처 각 업종의 매출 및 주문 수.(레스토랑, 와인바, 와인샵, 백화점 등)
? 고객 행동 분석: 신규 고객 수, 재구매율, 활발한 구매 시간대.
4. 재고 관리 리포트
목적: 효율적인 재고 관리 및 비용 절감.
주요 내용:
? 재고 회전율 분석: 제품별 회전율, 낮은 회전율 제품 리스트.
? 제품의 유통기한별 회전율 제품 리스트
? 입출고 내역: 기간별 입출고 기록
5. 비용 관리 리포트
목적: 회사 운영의 비용 효율성을 높이고, 불필요한 지출을 줄이며 수익성을 극대화주요 내용:
? 비용 항목별 분석: 주요 비용 항목(인건비, 물류비, 마케팅비 등) 및 월별/분기별 변화 추이.
? 제품별 원가 및 마진 분석: 제품별 제조 원가, 물류비용 등을 분석하여 마진율 확인.
? 고정비와 변동비 비교: 고정 비용과 변동 비용의 비율 파악 및 비용 구조 분석.
? 비용 절감 기회: 비용 절감이 가능한 항목 도출 및 제안 사항.
6. 종합 관리 리포트
목적: 사업의 전반적 성과를 요약 및 공유.
주요 내용:
? 사업 성과 요약: 월간 매출, 비용, 순이익.
? 주요 KPI: 고객 수, 평균 구매 단가, 구매 전환율.
? 성장률 및 추세 분석: 전월, 분기별, 전년도 대비 성장률
-
안녕하세요 업무자동화 제작 문의드려요
안녕하세요 ㈜**** ***입니다 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">.
저희는 이번에 중국쪽에서 오더한 의류사입을 맡ng="EN-US">ng="EN-US">
아서 진행하게 되면서 업무의 편의를 위해 프로그램 의뢰합니다 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">. 지난번 견적문의 드렸었는데ng="EN-US"> 내ng="EN-US">
ng="EN-US" style="mso-fareast-font-family:함초롬바탕">
부적인 문제로 잠시 중단되었다가ng="EN-US"> 추가로 사입의뢰가 들어와서ng="EN-US"> (2호점ng="EN-US">) 다시 견적문의 드림니다ng="EN-US"> .
ng="EN-US" style="mso-fareast-font-family:함초롬바탕">
업무 내용은 동일하고ng="EN-US"> 주문서 양식만 다르며 내용은 같습니다ng="EN-US"> .( 필요한 부분만 복사 붙여넣기로 ng="EN-US">
ng="EN-US" style="mso-fareast-font-family:함초롬바탕">
할예정ng="EN-US"> )ng="EN-US"> 업무내용은 백화점 또는 아울렛 재품들을 오더받아서 저희는 각 매장에 주문을 하고 물건ng="EN-US">
ng="EN-US">
이 나오면 확인하고 국제택배로 중국으로 발송하는 업무입니다 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">.ng="EN-US">
ng="EN-US">
각 매장마다 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">(브랜드ng="EN-US" style="mso-fareast-font-family:함초롬바탕">) 선입금을 먼저 하면 재품가격에 추가로 할인해주는 협의를 하고 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">(선입ng="EN-US">
ng="EN-US">
금 없이도 할인해주는 매장도 있습니다ng="EN-US" style="mso-fareast-font-family:함초롬바탕">) 매일매일 중국에서 오더 받은 재품을 각 매장으로 ng="EN-US">
ng="EN-US">
주문을 넣고있습니다 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">. 선입금 없는 매장은 껀바이껀으로 결제함 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">. (참고로 아울렛 재품은 기ng="EN-US">
ng="EN-US">
본적으로 이월재품이며 판매가격이 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">30% 40% 50% 60% 70% 등등 할인 적용되서 판매되는 ng="EN-US">
ng="EN-US">
재품ng="EN-US" style="mso-fareast-font-family: 함초롬바탕">)ng="EN-US">
ng="EN-US">
자동화 요청사항 ng="EN-US">
ng="EN-US" style="mso-fareast-font-family:함초롬바탕">1.일일 주문서 등록 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">( 오더날짜 ng="EN-US" style="mso-fareast-font-family: 함초롬바탕">, 주문날짜 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">, 주문번호 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">, 브랜드 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">, 품번 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">,색상 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">,사이즈 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">,가격 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">,ng="EN-US">
ng="EN-US">
몇프로할인상품인지ng="EN-US" style="mso-fareast-font-family:함초롬바탕">?(할인율ng="EN-US" style="mso-fareast-font-family:함초롬바탕">) ,할인전 재품소비자가격ng="EN-US" style="mso-fareast-font-family:함초롬바탕">, 연락처 ng="EN-US" style="mso-fareast-font-family: 함초롬바탕">,주소 ng="EN-US" style="mso-fareast-font-family: 함초롬바탕">,국제송장번호 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">, 재품 각ng="EN-US">
ng="EN-US">
각 무게 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">) ------일일 주문서 복사 붙이기로ng="EN-US"> 발송내역 미송란에ng="EN-US"> 붙여넣기 ng="EN-US">
ng="EN-US" style="color:red">
몇프로 할인상품인지 ng="EN-US" style="mso-fareast-font-family:함초롬바탕;color:red">-> 30% ,40%,50% , 60%,70% , 균일가 상품 수동으로 표시ng="EN-US">
ng="EN-US">
발송 선택하면 발송란으로 이동ng="EN-US"> 품절 선택하면 품절란 이동ng="EN-US"> (취소 반품 등등등ng="EN-US" style="mso-fareast-font-family:함초롬바탕">.)ng="EN-US">
ng="EN-US">
ng="EN-US" style="mso-fareast-font-family:함초롬바탕">2. 사이즈 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">,색상 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">,가격수정 변경시 날짜와 변경 히스토리 표기위한 비고란 ng="EN-US">
ng="EN-US">
ng="EN-US" style="mso-fareast-font-family:함초롬바탕">3. 검색기능 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">, 수동검색 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">->상품번호 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">or 주문번호 ng="EN-US">
ng="EN-US">
ng="EN-US" style="mso-fareast-font-family:함초롬바탕">4.각 브랜드별 할인율 적용 예를들면 ng="EN-US" style="mso-fareast-font-family: 함초롬바탕">(?ng="EN-US" style="mso-fareast-font-family: 함초롬바탕">10% , -5% , 30%->40%후 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">-10% , -5% 후 ?ng="EN-US" style="mso-fareast-font-family:함초롬바탕">10% ng="EN-US">
ng="EN-US">
등등 경우의 수는 많음 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">) ng="EN-US">
ng="EN-US">
아울렛 판매재품에 추가할인 브랜드마다 틀림 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">( 동일브랜드 내에서도 ng="EN-US" style="mso-fareast-font-family:함초롬바탕">40%할인 재품은 추가 ng="EN-US">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family: 굴림;color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family: 굴림;color:black;mso-font-kernold'>ing:0pt">10%할인 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">70%할인재품은 추가 ?ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">5%할인 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">,즉 할인율에따라 추가할인율이 다름 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">), 어떤브랜드ng="EN-US" style="mso-bidi-font-size: 10.0pt;line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
는 전재품 추가 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">10%할인 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">, 어떤 브랜드는 ng="EN-US" style="mso-bidi-font-size: 10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family: 굴림;color:black;mso-font-kernold'>ing:0pt">5%할인 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">,어떤 브랜드는 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">5%할인후 추가 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">10%할인 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕;mso-fareast-font-family: 굴림;mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family: 굴림;color:black;mso-font-kernold'>ing:0pt">,어떤브랜드는 기존에ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%; font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black; mso-font-kernold'>ing:0pt">30% 할인해서 판매되는 상품을 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%; font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black; mso-font-kernold'>ing:0pt">40%할인적용해서 추가 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">10%할인 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">, 어떤ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
재품은 시즌오프라서 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%; font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black; mso-font-kernold'>ing:0pt">40%할인된 재품을 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">60%할인 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">(40%에서 ?ng="EN-US" style="mso-bidi-font-size: 10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family: 굴림;color:black;mso-font-kernold'>ing:0pt">20%할인이 아님 예를들면 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height: 160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family:굴림; color:black;mso-font-kernold'>ing:0pt">10만ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-fareast-font-family:굴림;mso-hansi-font-family:굴림;mso-bidi-font-family:굴림; color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
원짜리를 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">40%할인해서 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">6만원에 팔던 재품을 시즌오프또는 행사기간이라 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">60%할인하면 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">4만원ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕;mso-fareast-font-family: 굴림;mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
에 판매한다는 뜻ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">) ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height: 160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family:굴림; mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
이벤트할인 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">(추가할인 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">, 날짜적용 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">) 예를들면 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">A브랜드 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">10일부터 추가 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">10% 할인 수동적용ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-fareast-font-family:굴림;mso-hansi-font-family:굴림;mso-bidi-font-family:굴림; color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family: 굴림;color:black;mso-font-kernold'>ing:0pt">5.브랜드별로 선입금 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%; font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black; mso-font-kernold'>ing:0pt">500만원ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">-2000만원 수동설정 일별 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">,월별 매출 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">,브랜드별 매출 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">, 선입ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕;mso-fareast-font-family: 굴림;mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
금 날짜 설정후 매일매일 합산 잔액표시 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height: 160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family:굴림; color:black;mso-font-kernold'>ing:0pt">-> 국제택배 발송날짜 등록 기준ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height: 160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family:굴림; mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family: 굴림;color:black;mso-font-kernold'>ing:0pt">6. 택배 무게를 체크하는 이유는 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height: 160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family:굴림; color:black;mso-font-kernold'>ing:0pt">0.5 ,1 ,1.5 ,2 kg마다 국제운송비가 적용되기 때문입니다 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">.ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-fareast-font-family:굴림;mso-hansi-font-family:굴림;mso-bidi-font-family:굴림; color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family: 굴림;color:black;mso-font-kernold'>ing:0pt">0.5kg=4500원 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">, 추가 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">0.5kg 마다 ng="EN-US" style="mso-bidi-font-size: 10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family: 굴림;color:black;mso-font-kernold'>ing:0pt">3500원 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">(예를들면 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">0.1-0.5kg =4500원 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">/ 0.51-1kg ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family: 굴림;color:black;mso-font-kernold'>ing:0pt">=8000원 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">/ 1.1kg-1.5kg =11500원ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">) 적용됨 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">,국제운송비는 수시로 조정 될수 있음ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">.ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height: 160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family:굴림; mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family: 굴림;color:black;mso-font-kernold'>ing:0pt">6. 국제택배 발송 날짜 기준으로 각 브랜드별 월말결산기능 ng="EN-US" style="mso-bidi-font-size: 10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family: 굴림;color:black;mso-font-kernold'>ing:0pt">(미송 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">,반품 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">, 품절 ng="EN-US" style="mso-bidi-font-size: 10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family: 굴림;color:black;mso-font-kernold'>ing:0pt">,발송ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">) 합계 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">,국제운송비ng="EN-US" style="mso-bidi-font-size: 10.0pt;line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
첨부파일ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-fareast-font-family:굴림;mso-hansi-font-family:굴림;mso-bidi-font-family:굴림; color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:Wold'>ingdold'>ings; mso-fareast-font-family:Wold'>ingdold'>ings;mso-bidi-font-family:Wold'>ingdold'>ings;color:black; mso-font-kernold'>ing:0pt">● 중국에서 들어오는 오더 주문서 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">(거의 매일 매일 ng="EN-US" style="mso-bidi-font-size: 10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family: 굴림;color:black;mso-font-kernold'>ing:0pt">)ng="EN-US" style="mso-bidi-font-size: 10.0pt;line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:Wold'>ingdold'>ings; mso-fareast-font-family:Wold'>ingdold'>ings;mso-bidi-font-family:Wold'>ingdold'>ings;color:black; mso-font-kernold'>ing:0pt">● 주문 ng="EN-US" style="mso-bidi-font-size: 10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family:굴림;mso-bidi-font-family: 굴림;color:black;mso-font-kernold'>ing:0pt">,품절 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕; mso-hansi-font-family:굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing: 0pt">,발송 ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:함초롬바탕;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">,반품 장부ng="EN-US"> (현재 관리중 파일ng="EN-US">) (일일정리ng="EN-US"> , 정산ng="EN-US"> ,합계표ng="EN-US"> )ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
ng="EN-US" style="mso-bidi-font-size:10.0pt;line-height:160%;font-family:Wold'>ingdold'>ings; mso-fareast-font-family:Wold'>ingdold'>ings;mso-bidi-font-family:Wold'>ingdold'>ings;color:black; mso-font-kernold'>ing:0pt">● 각브랜드별 매출 및 선입금 잔액 ng="EN-US">(현재 관리중 파일ng="EN-US">) (일일정리ng="EN-US"> , 정산ng="EN-US"> ,합계표ng="EN-US"> )ng="EN-US" style="mso-bidi-font-size:10.0pt; line-height:160%;font-family:함초롬바탕;mso-fareast-font-family:굴림;mso-hansi-font-family: 굴림;mso-bidi-font-family:굴림;color:black;mso-font-kernold'>ing:0pt">
ng="EN-US">
--------------------------------------------------------고객님의 업체명과 담당자 성함, 연락처 등의 소중한 개인정보는비공개로 수정해드렸습니다.엑셀쿠키에서 내용접수하였으니, 확인후 답변드리겠습니다^^ng="EN-US">
--------------------------------------------------------ng="EN-US">
-
자재 입출고 및 재고 현황+ 재고검색
1.업종 : 수입차전문 정비업
>2.예산 : 100~200만원ng>ng
ng>3.제작 요청사항 ng>
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>안녕하세요
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>수입차 정비를 전문하고 있는
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>조이오토 리페어 입니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>저희 매장에서 정비시 필요한 자재를
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>많이 가지고 있는데
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>그중 필터류의 종류가 상당히 많습니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>필터류의 입,출고 현황과 재고파악이
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>가능한 프로그램이 필요합니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>그중 제일 중요한게 재고로 보유하고 있는
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>필터를 검색하는 기능이 꼭 있어야 합니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>예를들면 한가지의 필터를 검색할수 있는
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>조건이 여러가지로 가능해야 합니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>차량모델명, 엔진코드, 정품품번,
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>타메이커품번 등등으로 검색을 하여
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>현재 재고가 있는지 확인이 가능해야합니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>여러 입출고 프로그램을 확인해 봤지만
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>보유하고 있는 부품에 대한 호환성여부 및
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>검색 조건을 충족하는 프로그램이 없어서
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>문의드립니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>그리고 한가지더 있는데
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>바코드로 입출고 체크를 하고 싶습니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>현장에서 작업자들이 부품 재고 여부확인후
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>찾은 부품을 바코드를 찍어 출고가 체크되고
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>최소 수량이 남았을때 발주할수 있게
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>확인이 되었으면 좋겠습니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>또한 재고부족으로 추가 발주하여
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>부품입고시 바코드생성및 인쇄를 통해
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>입고 부품을 빠르게 정리할수 있었으면
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>좋겠습니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>위 사항이 가능하다면
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>바코드 프린터까지 구매 혹은 렌탈로
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>현장에서의 작업을 수월하게 했으면
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>좋겠습니다.
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>참고로 엑셀도 모르고 바코드 기계도
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>사용안해봤지만 꼭 저희매장에
inline !important; float: none; background-color: transparent; color: rgb(67, 67, 67); font-family: "돋움",Dotum,Helvold'>eold'>tica,Sans-serif,"Apple SD Gothic Neo"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacold'>ing: normal; orphans: 2; text-align: left; text-decoraold'>tion: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacold'>ing: 0px; word-wrap: break-word;'>필요한 프로그램이 있었으면 좋겠습니다.
답변부탁드립다.
-
맞춤제작 의뢰드립니다
회원제 먹거리 쇼핑몰을 운영하고 있습니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing
:0.0pt;mso-text-raise:0.0pt;">.ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">6개 품목을 고객이 원하는 수량으로 포장해서 매월 정기적으로 배송하고 있습니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
고객 주문정보 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">DB를 관리하는 기능이 필요합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
고객정보 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">: 고객코드ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">/이름ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">/연락처ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">/주소
주문품목과 수량 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">: 예ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">) 1번품목 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">3개 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">/ 2번품목 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1개 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">/ 3번품목 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">4개 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">/ 4번품목ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1개
입금정보 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">: 카드ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">or자동이체ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">or계좌입금 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">/ 매월 입금한 내역과 액수
대략 이정도의 항목이고ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 전체고객은 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">500명 정도 됩니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
첨부한 액셀파일과 같은 양식으로 관리를 하고 있으며ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">,
매월 배송할 날짜가 되면 이 파일을 출력하여 포장팀에게 전달해야 합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
문제는ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 주문품목을 고객들께서 수시로 변경하신다는 겁니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
전화로 변경요청을 받으면 액셀파일에서 해당고객을 찾아서 제품수량을 변경하고ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 변경이 없는 고객은 전달의 주문정보를 그대로 이월하여 처리합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
그래서ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 매월 정해진 날에 발송업무가 끝나면 그 달 배송리스트를 액셀로 저장하여 백업을 해둡니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">. 예를 들어 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">11월 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">25일에 출고가 끝나면ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 그때까지 리스트를 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">‘11월ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">’파일로 저장하고ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 11월 파일을 카피하여 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">12월 변경사항을 한 달 동안 적용시켜서 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">12월ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">25일에 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">‘12월ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">’파일을 저장하는 식이에요
그러다보니 특정고객을 검색하여ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 이 고객이 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">9월ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">,10월ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">,11월ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">,12월에 어떻게 배송 받았는지 조회를 해보고자 할 때 굉장히 번거롭습니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
또ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 기존 액셀파일이 깔끔하질 못해서ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 고객님들의 주문변경요청 전화를 받을 때ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 전산에서 바로 작업하질 못하고 수기로 작성한 다음에 액셀파일에 두 번 수정을 하고 있는데
이러다보니 빼먹는 부분도 생기고 여러 가지로 번거러움이 큽니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
업무자동화서식중에 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">“고객 상담관리 업무자동화 프로그램ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">(상담구분별 월별현황ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">)” 프로그램을 다운받아서 사용하고 있는데ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 고객정보가 월별로 나뉘지 않고 한 파일에 다 저장되니 고객이름으로 검색했을 때 현재까지 상담한 내용을 모두 확인가능해서 참 편리합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
이 프로그램에 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">‘주문정보ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">’ 항목을 추가해서
품목ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1
품목ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">2
품목ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">3
품목ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">4
품목ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">3개
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">2개
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5개
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">0개
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1개
위와 같은 정보를 삽입하고ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 또 상담내역과 함께 조회할 수 있는 프로그램이 필요합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
또 이 정보를 월별로 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">export와 출력할 수 있는 기능이 필요합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
고객 이름으로 검색했을 때ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 해당 고객의 월별 리스트와ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 상담했던 리스트ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 한 달에 여러 번 상담내역이 있다면 그 여러 번의 상담내역을 모두 알 수 있어야 하고
월별로 검색했을 때는 해당 월의 모든 고객의 내역을 볼 수 있어야 합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
또ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 제품 포장 조합에 따라 상품코드가 있습니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">. 상품코드에 따른 검색결과도 출력가능해야 합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">11월 내역을 출력할 때ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 전체내역ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 상품코드ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1번ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 상품코드ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">2번ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 상품코드ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">3번ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">... 의 내역을 각각 액셀파일로 추출할 수 있는 기능도 필요합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
한가지 더ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 입금내역입니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
고객마다 월별로 입금한 내역과 금액을 한 시트에서 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1년치를 볼수 있어야 합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
기본 시트에 누적된 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">DB에서 금액부분만 뽑아서 별도시트에 연동시켜서 모든 고객의 ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1~12월까지의 입금내역을 볼 수 있는ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.... 아래와 같은 시트가 필요합니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">1월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">2월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">3월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">4월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">6월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">8월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">9월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">10월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">11월
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">12월
김은영
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">5만
유지민
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">10만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">10만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">10만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">10만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">10만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">10만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">7만
업무과정에서 불편했던 내용들을 서술해 봤습니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
적당한 프로그램이 있는지ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 혹은 커스터마이징 컨설팅이나ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">, 필요하면 주문제작을 하고 싶습니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">.
비용과 기간도 안내부탁드립니다ng="EN-US" style="font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0.0pt;mso-text-raise:0.0pt;">!
-
맞춤제작 문의드립니다.
>1.업종 : 쇼핑몰 ng>ng
ng>2.예산 : 가격 협의 ng>
ng>3.제작 요청사항 ng>매입/매출/개인경비/재고관리를 한눈에 볼 수 있게끔 제작 의뢰 드립니다.
첫 시트에는 매월 매년 선택하면 한눈에 볼 수 있게끔 제작하고싶고
나머지 시트들에는 일 매출 일 매입 일 개인경비 일 재고 등 세세하게 작성하고 싶습니다.
들어가야할 내용들 아래 작성하였으며, 혹시 제작기간과 견적은 어떻게 될까요?
또한, 첨부드린 파일같은 느낌으로 제작하고싶습니다.
메일 회신 부탁드립니다.
감사합니다.
< 매입 관련 >
아래 적힌 항목들 작성할 수 있는 틀을 만들어주세요!
- 회사용 -
날짜 / 매입처 / 매입 품목명 / 매입 단가 / 부가세
- 개인용 -
날짜 / 구매처 / 품목명 / 구매 단가
--------------------------------------------------------------------------------------------------------------
< 매출 관련 >
저희 제품이 2가지 라인으로 구분되어있습니다.
( OEM 향수 / 수제 향수/ 세트 구성 )
이로 인하여 OEM 매출 / 수제 매출 / 세트구성 나누어서 각 항목별 월 총합 매기고 또 셋이 합친 최종 총 매출을 매기고 싶습니다.
저희는 향수를 취급하고 있는 쇼핑몰이며, 공장과 협업하여 제조한 OEM 향수 ( 케라/ 라즈베리 ) / 저희가 직접 제조하는 수제향수 ( 약 30종 정도 되는 향수 ) / 세트구성 ( OEM 제품 1종 + 수제향수 1종 ) 이렇게 판매를 하고 있습니다.
--------------------------------------------------------------------------------------------------------------
< 입점사 >
자사몰 / 스토어팜 / 로켓배송 / 아트박스 / 브랜디 / 서울스토어 / 뉴템스토어 / 우먼스톡 / 위메프 / 티몬 / IDUS
--------------------------------------------------------------------------------------------------------------
< 각 입점사별 수수료 > - 이거는 달력같은데에 한눈에 수수료표 볼 수 있게끔 만들어주세요 !
자사몰 : 3.85%
스토어팜 : 2.58%
브랜디 : 29.5%
서울스토어 : 27.5%
뉴템스토어 : 20%
우먼스톡 : 15%
위메프 : 14.3%
티몬 : 13%
IDUS : 22%
--------------------------------------------------------------------------------------------------------------
< 쿠팡 및 아트박스 납품가 (VAT+) = 즉, 매출 >
쿠팡 : 11,000원 ( 라즈베리 상품만 10,000원)
아트박스 : 9,350원
--------------------------------------------------------------------------------------------------------------
*** OEM 향수기준에 나와있는 1+1 / 2+1 이런 상품이 케라+케라 / 케라+라즈베리 / 라즈베리+라즈베리 이런 세트 구성입니다. ***
< 판매가 및 순수익 OEM 향수 기준 >
자사몰 / 스토어팜 : 제품 1개(17,000원) - 55.9% / 1+1 상품(32,000원) - 57.9% / 2+1상품(42,000원) - 56.8%
브랜디 : 제품 1개(23,000원) - 30% / 1+1 상품 (43,000원) - 36% / 2+1 상품 ( 63,000원) - 40%
서울스토어 : 제품 1개(23,000원) -32.7 % / 1+1 상품 (43,000원) - 38% / 2+1 상품 ( 63,000원) - 42.5%
뉴템스토어 : 제품 1개 (17,000원) - 44.2% / 1+1 상품 (32,000원) - 44%
우먼스톡 : 제품 1개 ( 20.000원) - 53% / 1+1상품 (40.000원) - 54% / 2+1 상품 ( 60.000원) - 45%
위메프 : 제품 1개 ( 20,000원) - 53.5% / 1+1 상품 (40,000원) - 55% / 2+1 상품 ( 60,000원) - 51%
티몬 : 제품 1개 ( 20,000원) - 55% / 1+1 상품 (40,000원) - 56.5% / 2+1 상품 ( 60,000원) - 52%
쿠팡 : 케라 1개 ( 11,000원) - 53.5% / 라즈베리 1개 (10,000원) - 49%
아트박스 : 케라 1개 ( 9,350원 ) - 47% / 라즈베리 1개 ( 9,350원 ) - 44.4%
--------------------------------------------------------------------------------------------------------------
< 판매가 및 순수익 수제 향수 기준 >
자사몰 / 스토어팜 : 제품 1개(17,000원) - 49%
브랜디 : 제품 1개(23,000원) - 27.3%
서울스토어 : 제품 1개(23,000원) -30 %
뉴템스토어 : 해당 쇼핑몰에 수제향수 판매 안함
우먼스톡 : 제품 1개 ( 20.000원) - 50%
위메프 : 제품 1개 (20.000원) - 50.5%
티몬 : 제품 1개 ( 20,000원) - 52.5%
IDUS : 제품 1개 ( 17,00원) - 37.5%
쿠팡 : 제품 1개 ( 11,000원 ) - 36.3% / 제품 1개 ( 13,600원 ) - 48.8% << 이거는 제품별 달라서 가격으로 저희가 어떤 제품인지 파악할게요!
아트박스 : 제품 1개 ( 9,350원 ) - 25.6%
--------------------------------------------------------------------------------------------------------------
< 판매가 및 순수익 세트구성 기준 >
자사몰 / 스토어팜 : 1+1 구성 ( 32,000원) - 59.5%
브랜디 : 1+1구성 (43000원)- 39.5%
서울스토어 : 해당 쇼핑몰에 세트구성 판매 안함
뉴템스토어 : 해당 쇼핑몰에 세트구성 판매 안함
우먼스톡 : 해당 쇼핑몰에 세트구성 판매 안함
위메프 : 해당 쇼핑몰에 세트구성 판매 안함
티몬 : 해당 쇼핑몰에 세트구성 판매 안함
--------------------------------------------------------------------------------------------------------------
< 휴대용 공병 기준 >
자사몰 / 스토어팜 : 제품 1개 ( 3,500원 ) - 80% / 제품 3개 ( 9,000원 ) - 76.6%
쿠팡 : 개당 (2,500원) - 72% << 해당건은 협의중이여서 확정 단가가 아닙니다! 추후 저희가 가격 수정할 수 있나요?
--------------------------------------------------------------------------------------------------------------
< 판매 수량 >
메블릭퍼퓸 케라 50ml 1개
메블릭퍼퓸 케라 50ml 1+1
메블릭퍼퓸 케라 50ml 2+1
메블릭퍼퓸 케라 + 라즈베리
메블릭퍼퓸 라즈베리 50ml 1개
메블릭퍼퓸 라즈베리 50ml 1+1
메블릭퍼퓸 라즈베리 50ml 2+1
(세트구성) 수제향수 + 케라
(세트구성) 수제향수 + 라즈베리
메블릭퍼퓸 Soap 50ml
메블릭퍼퓸 넥타린블로썸허니50ml
메블릭퍼퓸 딸기 50ml
메블릭퍼퓸 라일락 50ml
메블릭퍼퓸 라튤립 50ml
메블릭퍼퓸 러블리 50ml
메블릭퍼퓸 레드로지스 50ml
메블릭퍼퓸 로맨틱피오니 50ml
메블릭퍼퓸 몽파리50ml
메블릭퍼퓸 밤쉘50ml
메블릭퍼퓸 베이비파우더 50ml
메블릭퍼퓸 벨루치나 50ml
메블릭퍼퓸 복숭아 50ml
메블릭퍼퓸 블랙체리50ml
메블릭퍼퓸 소프너 50ml
메블릭퍼퓸 시크릿 50ml
메블릭퍼퓸 어벤투스 50ml
메블릭퍼퓸 에끌라드아르페쥬 50ml
메블릭퍼퓸 잉글리쉬프리지아 50ml
메블릭퍼퓸 포도 50ml
메블릭퍼퓸 포도레몬 50ml
메블릭퍼퓸 프리지아 50ml
메블릭퍼퓸 피오니&블러시스웨이드 50ml
메블릭퍼퓸 미니 휴대용공병 1개 단품
메블릭퍼퓸 미니 휴대용공병 3개 세트
--------------------------------------------------------------------------------------------------------------
< 매일 순수익 볼 수 있는 시트도 만들어주세요 >
순수익은 위에 순익 % 정리해서 작성하였습니다.
저희가 자사몰과 스토어팜에서는 고객님들에게 쿠폰을 발행해드리고 있습니다.
그러므로 매일 총 쿠폰 발행 금액 작성할 수 있는 칸도 남겨주시고 이 또한, 순익에서 볼 수 있게 설정해주세요.
( 매출 장부 한번에 볼때도 볼 수 있게 설정해주세요. )
광고비 항목 ( FB/IG / 쿠팡 ) 두가지 적어주세요 !
--------------------------------------------------------------------------------------------------------------
-
추가견적 요청합니다.
기존 내용 중 파란글씨 2가지가 추가부분이며
빨간부분은 구체적 내용입니다.빠른 답변 부탁드립니다.
ng="EN-US" style="font-size: 11pt; letter-spacold'>ing
: 0pt; font-weight: bold;">ng="EN-US" style="font-size: 11pt; letter-spacold'>ing: 0pt; font-weight: bold;">1.업종 ng="EN-US" style="font-size: 11pt; letter-spacold'>ing: 0pt; font-weight: bold;">: 귀금속수리센터
ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;font-size:11.0pt;">
ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">2.예산 ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">: ??
ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;font-size:11.0pt;">ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">3.제작 요청사항 ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">: 어제ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">(2일ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">) 통화하고 가견적 잘 받았습니다ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">. 빠뜨린 내용과 구체적 설명 등이 있어서 추가견적의뢰드립니다ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">. 번거롭게 해드려 죄송합니다ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">.
ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;font-size:11.0pt;">
ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;">1)업무흐름 및 기존 업무방식
귀금속 수리업체로서 지점과 수리공장에서 고객이 의뢰한 수리물품이 입고되면 지점에서 의뢰된 물품은 본사를 거쳐 공장에서 수리가 진행됩니다ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">. 수리 후 지점으로 보내지고요ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">.
※ 수리물품은 본사에서 판매한 귀금속이 아니고 모든 귀금속에 대한 수리를 받습니다ng="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">.
ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;font-weight:bold;">2)자동화하고 싶은 업무
ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">*본사ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">, 수리공장ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">, 지점의 ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">3곳이 연동되어 시스템이 보여져야 하고 본사와 공장은 ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">PC, 지점은 모바일 사용을 기본으로 합니다ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">.본사는 지점과 공장을 모두 볼 수 있어야하고 관리합니다ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">.
지점과 공장은 각각 해당하는 지점별의 내용만 볼수 있으며
공장도 해당하는 내용만 볼 수 있습니다ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">.
ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">*어제 상담했던 내용처럼 수리물품의 이력ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">, 수리금액도 기입하고 결산도 가능해야 합니다ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">.
수리종류ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">(도금수리ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">, 사이즈수리 등 ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">6개 정도와 기타ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">) 선택시 목록에 해당되는 금액이 자동 기입되는 구조이면 합니다ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">.ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">: 비고란과 같은 곳에 해당고지사항 자동입력
결산은 각 지점별의 결산과 모든 지점의 총결산내역이 반영되어야하며
지점에서 소매가격과 본사의 도매가격이 기입되어야 합니다ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">.(첨부파일 참고ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">)
ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">*공장에서는 외주수리도 주기 때문에 외주내용도 별도로 있어야 합니다ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">.(현재 도금작업ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">, 시계수리ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">, 조각ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">, 레이저마킹ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">, 레이저땜ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">)
ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">*수리이력에 추가되어야 할 사항은 ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">“물품수리전 사진첨부란ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">”과 위에서 말한 ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">“결산ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">”이 추가되어야 하고ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">, “개인정보와 고지사항에 대한 고객동의ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">”, “서명란ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">”이 필요합니다ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">.ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;font-weight:bold;color:#c75252;">: 탭 필요ng="EN-US" style="font-family: 돋움; letter-spacold'>ing: 0pt; font-weight: bold; color: rgb(0, 117, 200);">*(은행처럼ng="EN-US" style="font-family: 돋움; letter-spacold'>ing: 0pt; font-weight: bold; color: rgb(0, 117, 200);">)
ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">*수리내용에 대한 수리장에 각 ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">QR코드 생성되어 있으면 됩니다ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;">.
ng="EN-US" style="font-family: 돋움; letter-spacold'>ing: 0pt; color: rgb(0, 117, 200);">*주문발주기능ng="EN-US" style="font-family: 돋움; letter-spacold'>ing: 0pt; color: rgb(0, 117, 200);">: 지점에서 본사에 주문하기ng="EN-US" style="font-family: 돋움; letter-spacold'>ing: 0pt; color: rgb(0, 117, 200);">(수리외의 물품ng="EN-US" style="font-family: 돋움; letter-spacold'>ing: 0pt; color: rgb(0, 117, 200);">)가 가능하며 지점별로 월말결산이 가능해야만 합니다ng="EN-US" style="font-family: 돋움; letter-spacold'>ing: 0pt; color: rgb(0, 117, 200);">.
ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">* 결산세부내역
ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">- 지점별 수리내역ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">: 건당 세부내역ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">, 일별ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">, 월별ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">, 연도별ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">, 수리종류별 등으로 검색가능ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">.
ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">- 수리비용은 소비자가ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">, 지점산출가ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">, 수리원가ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">, 지점마진 등으로 구성되어야 하며ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">, 소비자가와 지점산출가가 다른 경우 차액이 별도 계산되어야 함ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">.
ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">- 수리비용 입력은 지정된 금액 자동입력과 직접입력으로 구성되어야 함ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">.: 이 경우 수리원가와 지점마진을 직접 입력해야 하는지ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">??
ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">- 주문 발주품 페이지는 어떻게 구성되는지ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">?
ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">- 주문 발주품도 위와 같은 구성으로 결산내역이 구성되어야 함ng="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-spacold'>ing:0pt;mso-text-raise:0pt;color:#c75252;">.
-
제목 : 판매재고관리 자동화를 요청합니다.
안녕하세요
저희는 소형가전을 온라인에서 판매하는 업체입니다.
판매매출자료를 보다 편리하게 확인할수 있는 엑셀프로그램을 제작하고 싶습니다.
매일매일 각 거래처별 매출 데이터를 프로그램에 업로드해서 피벗테이블처럼 원하는 기준으로 자료를 볼수 있었으면합니다.
아래는 저희가 기본적으로 원하는 예시 만들어 보았으니 참고 부탁드립니다.
기타 자세한사항은 상담시 말씀드리겠습니다.
수고하세요.
old'>ing=0 cellPaddold'>ing=0 width=504 border=0>
<TBODY> 날짜 거래처명 매출가 품목 수량 A 가 B 나 C 다 D 라 품목분류 ex) 그룹 olSpan=2>린나이코리아 분류 olSpan=2> 2구가스렌지 품목 olSpan=2> RTR-T2201 기간 설정 품목명 품목명이나 품목그룹, 품목분류로도 조회가능 거래처명 olor=#ff0000 size=3 face="맑은 고딕">매출수량 olor=#ff0000 size=3 face="맑은 고딕"> olor=#ff0000 size=3 face="맑은 고딕"> olor=#ff0000 size=3 face="맑은 고딕"> olor=#ff0000 size=3 face="맑은 고딕"> olor=#ff0000 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕">매출액 olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> 가 나 다 라 A olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕">2 olor=#ff0000 size=3 face="맑은 고딕">3 olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕"> olor=#ff0000 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕">20 olor=#0070c0 size=3 face="맑은 고딕">30 olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> B olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕"> olor=#ff0000 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> C olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕"> olor=#ff0000 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> D olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕"> olor=#ff0000 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> 품목설정 기간별 품목명이나 품목그룹, 품목분류로도 조회가능 거래처명 olor=#ff0000 size=3 face="맑은 고딕">매출수량 olor=#ff0000 size=3 face="맑은 고딕"> olor=#ff0000 size=3 face="맑은 고딕"> olor=#ff0000 size=3 face="맑은 고딕"> olor=#ff0000 size=3 face="맑은 고딕"> olor=#ff0000 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕">매출액 olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> 1월 2월 3월 4월 A olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕">2 olor=#ff0000 size=3 face="맑은 고딕">3 olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕"> olor=#ff0000 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕">20 olor=#0070c0 size=3 face="맑은 고딕">30 olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕"> B olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕">1 olor=#ff0000 size=3 face="맑은 고딕"> olor=#ff0000 size=3 face="맑은 고딕"> olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕">10 olor=#0070c0 size=3 face="맑은 고딕"> 경리 · 회계 > 업무자동화 | 조회 3324 | 답변완료(1) -
[지원 이벤트 신청] 중국오더한 의류 사입 자동화프로그램
1. 업종 : 중국 의뢰한 의류 사입
저희는 이번에 중국쪽에서 오더한 의류사입을 맡
2. 예산 :
3. 제작 요청 사항
1) 업무 흐름(프로세스)
안녕하세요 ㈜더블유라인 송성호입니다 ng="EN-US" style="letter-spacold'>ing: 0pt;">.아서 진행하게 되면서 업무의 편의를 위해 프로그램 의뢰합니다 ng="EN-US" style="letter-spacold'>ing: 0pt;">.
업무내용은 백화점 또는 아울렛 재품들을 오더받아서 저희는 각 매장에 주문을 하고 물건
이 나오면 확인하고 국제택배로 중국으로 발송하는 업무입니다 ng="EN-US" style="letter-spacold'>ing: 0pt;">.
각 매장마다 ng="EN-US" style="letter-spacold'>ing: 0pt;">(브랜드ng="EN-US" style="letter-spacold'>ing: 0pt;">) 선입금을 먼저 하면 재품가격에 추가로 할인해주는 협의를 하고 ng="EN-US" style="letter-spacold'>ing: 0pt;">(선입
금 없이도 할인해주는 매장도 있습니다ng="EN-US" style="letter-spacold'>ing: 0pt;">) 매일매일 중국에서 오더 받은 재품을 각 매장으로
주문을 넣고있습니다 ng="EN-US" style="letter-spacold'>ing: 0pt;">. 선입금 없는 매장은 껀바이껀으로 결제함 ng="EN-US" style="letter-spacold'>ing: 0pt;">. (참고로 아울렛 재품은 기
본적으로 이월재품이며 판매가격이 ng="EN-US" style="letter-spacold'>ing: 0pt;">30% 40% 50% 60% 70% 할인 적용되서 판매되는 재품ng="EN-US" style="letter-spacold'>ing: 0pt;">)
2) 기존 업무 방식
(사용중인 프로그램 스크린샷, 양식 첨부)
기존 업무 자료 첨부합니다 .1. 중국 오더 엑셀파일
2. 주문하고 발송 품절 미송 내역
3.브랜드별 선입금 잔액
3)자동화 요청
ng="EN-US" style="letter-spacold'>ing
: 0pt;">1.일일 주문서 등록 ng="EN-US" style="letter-spacold'>ing: 0pt;">( 오더날짜 ng="EN-US" style="letter-spacold'>ing: 0pt;">, 주문날짜 ng="EN-US" style="letter-spacold'>ing: 0pt;">, 주문번호 ng="EN-US" style="letter-spacold'>ing: 0pt;">, 브랜드 ng="EN-US" style="letter-spacold'>ing: 0pt;">, 몇프로할인상품인지ng="EN-US" style="letter-spacold'>ing: 0pt;">? , 품번 ng="EN-US" style="letter-spacold'>ing: 0pt;">,색상 ng="EN-US" style="letter-spacold'>ing: 0pt;">,사이즈 ng="EN-US" style="letter-spacold'>ing: 0pt;">,가격 ng="EN-US" style="letter-spacold'>ing: 0pt;">, 주소 ng="EN-US" style="letter-spacold'>ing: 0pt;">,연락처 ng="EN-US" style="letter-spacold'>ing: 0pt;">,송장번호 ng="EN-US" style="letter-spacold'>ing: 0pt;">, 재품 각각 무게 등등ng="EN-US" style="letter-spacold'>ing: 0pt;">) 몇프로 할인상품인지 ng="EN-US" style="letter-spacold'>ing: 0pt; color: rgb(255, 0, 0);">-> 30% ,40%,50% , 60%,70% 수동으로 표시메뉴별 한국어 중국어 동시 적용 ng="EN-US" style="letter-spacold'>ing: 0pt;">.
ng="EN-US" style="letter-spacold'>ing: 0pt;">2.품절 ng="EN-US" style="letter-spacold'>ing: 0pt;">,반품 ng="EN-US" style="letter-spacold'>ing: 0pt;">,사이즈 ng="EN-US" style="letter-spacold'>ing: 0pt;">,색상 ng="EN-US" style="letter-spacold'>ing: 0pt;">,취소 ng="EN-US" style="letter-spacold'>ing: 0pt;">,가격수정 변경시 날짜와 변경히스토리 표기 ng="EN-US" style="letter-spacold'>ing: 0pt;">( 11.08 bk->wh , 11.08 s-> m )
ng="EN-US" style="letter-spacold'>ing: 0pt;">3. 의류택ng="EN-US" style="letter-spacold'>ing: 0pt;">(품번ng="EN-US" style="letter-spacold'>ing: 0pt;">) 바코드 체크시 검색기능 ng="EN-US" style="letter-spacold'>ing: 0pt;">, 수동검색 ng="EN-US" style="letter-spacold'>ing: 0pt;">->상품번호 ng="EN-US" style="letter-spacold'>ing: 0pt;">, 주문번호
4. 지속적으로 브랜드 추가 될 예정입니다 .
ng="EN-US" style="letter-spacold'>ing: 0pt;">5.각 브랜드별 할인율 적용 예를들면 ng="EN-US" style="letter-spacold'>ing: 0pt;">(?ng="EN-US" style="letter-spacold'>ing: 0pt;">10% , -5% , 30%->40%후 ng="EN-US" style="letter-spacold'>ing: 0pt;">-10% , -5% 후 ?ng="EN-US" style="letter-spacold'>ing: 0pt;">10%)
아울렛판매재품에 추가할인 브랜드마다 틀림 ng="EN-US" style="letter-spacold'>ing: 0pt;">, 어떤브랜드는 전재품 추가 ng="EN-US" style="letter-spacold'>ing: 0pt;">10%할인 ng="EN-US" style="letter-spacold'>ing: 0pt;">, 어떤
브랜드는 ng="EN-US" style="letter-spacold'>ing: 0pt;">5%할인 ng="EN-US" style="letter-spacold'>ing: 0pt;">,어떤 브랜드는 ng="EN-US" style="letter-spacold'>ing: 0pt;">5%할인후 추가 ng="EN-US" style="letter-spacold'>ing: 0pt;">10%할인 ng="EN-US" style="letter-spacold'>ing: 0pt;">,어떤브랜드는 기존에ng="EN-US" style="letter-spacold'>ing: 0pt;">30% 할인해
서 판매되는 상품을 ng="EN-US" style="letter-spacold'>ing: 0pt;">40%할인적용해서 추가 ng="EN-US" style="letter-spacold'>ing: 0pt;">10%할인 ng="EN-US" style="letter-spacold'>ing: 0pt;">, 어떤재품은 시즌오프라서 ng="EN-US" style="letter-spacold'>ing: 0pt;">40%할인된
재품을 ng="EN-US" style="letter-spacold'>ing: 0pt;">60%할인 ng="EN-US" style="letter-spacold'>ing: 0pt;">(40%에서 ?ng="EN-US" style="letter-spacold'>ing: 0pt;">20%할인이 아님 예를들면 ng="EN-US" style="letter-spacold'>ing: 0pt;">10만원짜리를 ng="EN-US" style="letter-spacold'>ing: 0pt;">40%할인해서 ng="EN-US" style="letter-spacold'>ing: 0pt;">6만원에
팔던 재품을 시즌오프또는 행사기간이라 ng="EN-US" style="letter-spacold'>ing: 0pt;">60%할인하면 ng="EN-US" style="letter-spacold'>ing: 0pt;">4만원에 판매한다는 뜻ng="EN-US" style="letter-spacold'>ing: 0pt;">)
이벤트할인 ng="EN-US" style="letter-spacold'>ing: 0pt;">(추가할인 ng="EN-US" style="letter-spacold'>ing: 0pt;">, 날짜적용 ng="EN-US" style="letter-spacold'>ing: 0pt;">) 예를들면 ng="EN-US" style="letter-spacold'>ing: 0pt;">A브랜드 ng="EN-US" style="letter-spacold'>ing: 0pt;">10일부터 추가 ng="EN-US" style="letter-spacold'>ing: 0pt;">10% 할인 수동적용
ng="EN-US" style="letter-spacold'>ing: 0pt;">6.브랜드별로 선입금 ng="EN-US" style="letter-spacold'>ing: 0pt;">500만원ng="EN-US" style="letter-spacold'>ing: 0pt;">-2000만원 수동설정 일별 ng="EN-US" style="letter-spacold'>ing: 0pt;">,월별 매출 ng="EN-US" style="letter-spacold'>ing: 0pt;">,브랜드별 매출 ng="EN-US" style="letter-spacold'>ing: 0pt;">, 선입금 날짜 설정후 매일매일 합산 잔액표시 ng="EN-US" style="letter-spacold'>ing: 0pt;">-> 일일주문서 등록 기준
ng="EN-US" style="letter-spacold'>ing: 0pt;">
ng="EN-US" style="letter-spacold'>ing: 0pt;">7. 택배 무게를 체크하는 이유는 ng="EN-US" style="letter-spacold'>ing: 0pt;">0.5 ,1 ,1.5 ,2 kg마다 국제운송비가 적용되기 때문입니다 ng="EN-US" style="letter-spacold'>ing: 0pt;">.
ng="EN-US"> ng="EN-US" style="letter-spacold'>ing: 0pt;">0.5kg=4500원 ng="EN-US" style="letter-spacold'>ing: 0pt;">, 추가 ng="EN-US" style="letter-spacold'>ing: 0pt;">0.5kg 마다 ng="EN-US" style="letter-spacold'>ing: 0pt;">3500원 ng="EN-US" style="letter-spacold'>ing: 0pt;">(예를들면 ng="EN-US" style="letter-spacold'>ing: 0pt;">0.1-0.5kg =4500원 ng="EN-US" style="letter-spacold'>ing: 0pt;">/ 0.51-1kg =8000원 ng="EN-US" style="letter-spacold'>ing: 0pt;">/ 1.1kg-1.5kg =11500원ng="EN-US" style="letter-spacold'>ing: 0pt;">) 적용됨 ng="EN-US" style="letter-spacold'>ing: 0pt;">,국제운송비는 수시로 조정될수 있음ng="EN-US" style="letter-spacold'>ing: 0pt;">.
ng="EN-US" style="letter-spacold'>ing: 0pt;">8. 주문날짜 기준으로 각 브랜드별 월말결산기능 ng="EN-US" style="letter-spacold'>ing: 0pt;">(매입 ng="EN-US" style="letter-spacold'>ing: 0pt;">,반품 ng="EN-US" style="letter-spacold'>ing: 0pt;">, 품절 ng="EN-US" style="letter-spacold'>ing: 0pt;">) 합계 ng="EN-US" style="letter-spacold'>ing: 0pt;">,국제운송비
첨부파일
중국에서 들어오는 오더 주문서 ng="EN-US" style="letter-spacold'>ing: 0pt;">(거의 매일 매일 ng="EN-US" style="letter-spacold'>ing: 0pt;">)
주문 ng="EN-US" style="letter-spacold'>ing: 0pt;">,품절 ng="EN-US" style="letter-spacold'>ing: 0pt;">,발송 ng="EN-US" style="letter-spacold'>ing: 0pt;">,반품 장부
각브랜드별 매출 및 선입금 잔액
-
공연실적 프로그래밍화
>1.업종 : 공연서비스ng>ng
ng>2.예산 : 처음 제작이라 추정할 수 없음. ng>
ng>3.제작 요청사항 ng>
ng>1)업무흐름 및 기존 업무방식 ng>
ng>2)자동화하고 싶은 업무 ng>
*
*
*공연예술팀 실적관리 시스템
ng="EN-US">
시스템 구축 사유ng="EN-US">: 기존 엑셀 실적자료 수식은 자잘한 실수가 발생하여 원하는 항목 필터링 시 자주 수치가 변경됨ng="EN-US">. 셀통합시 필터링에서 누락되는 경우 발생ng="EN-US">.
ng="EN-US">
구조ng="EN-US">
ng="EN-US">1. 대관공연 실적ng="EN-US">
ng="EN-US">A. ng="EN-US">4개 공연장의 대관정보ng="EN-US">(raw data: 엑셀ng="EN-US">), 연도별 약 ng="EN-US">150건ng="EN-US">, 약 ng="EN-US">10년 이내 누적자료 업로드 필요ng="EN-US">
ng="EN-US">B. ng="EN-US">row 항목ng="EN-US">: 연도ng="EN-US">, 공연장이름ng="EN-US">, 공연일ng="EN-US">, 무대준비일ng="EN-US">, 대관료ng="EN-US">, 관람객 수 등 ng="EN-US">30개ng="EN-US">
ng="EN-US">C. 가공 데이터ng="EN-US">: 연도별 총 대관 횟수ng="EN-US">, 총 관람객 수 등 다양한 항목으로 필터링 되어야 함ng="EN-US">.
ng="EN-US">2. 기획공연 실적ng="EN-US">
ng="EN-US">A. ng="EN-US">4개 공연장의 기획공연 집행 정보ng="EN-US">(raw data: 엑셀ng="EN-US">), 연도별 약 ng="EN-US">100건ng="EN-US">, 약 ng="EN-US">10년 이내 누적자료 업로드 필요ng="EN-US">
ng="EN-US">B. ng="EN-US">Row 항목ng="EN-US">: 연도ng="EN-US">, 공연장이름ng="EN-US">, 공연일ng="EN-US">, 티켓비ng="EN-US">, 관람객 수ng="EN-US">(약 ng="EN-US">20여개 권종 입력ng="EN-US">), 예산 등 ng="EN-US">40개 항목ng="EN-US">
ng="EN-US">C. 공연별 할인내역 상세
ng="EN-US">D. 가공 데이터ng="EN-US">: 연도별 총 기획공연 횟수ng="EN-US">, 관람객 수ng="EN-US">, 장르 구분 등 다양한 항목으로 필터링 되어야 함ng="EN-US">.
ng="EN-US">3. 공연장 가동율ng="EN-US">
ng="EN-US">A. ng="EN-US">3개 공연장의 무대준비ng="EN-US">, 공연당일ng="EN-US">, 유지보수일 등 설정ng="EN-US">
ng="EN-US">B. 가동율 통계 필요ng="EN-US">
ng="EN-US">
공통기능ng="EN-US">
ng="EN-US">1. 모바일 버전 필요 없음ng="EN-US">. PC 접속 기준ng="EN-US">.
ng="EN-US">2. 검색 기능ng="EN-US">: 공연명ng="EN-US">, 공연단체명 등으로 검색 필요ng="EN-US">
ng="EN-US">3. 필터링한 데이터 엑셀 다운로드ng="EN-US">
ng="EN-US">4. 항목은 관리자가 신규 추가할 수 있어야 함ng="EN-US">(ex. 기획공연에서 새로운 할인 권종 등ng="EN-US">)
ng="EN-US">5. 웹 기반으로 구축ng="EN-US">. 담당자 변경시에 로그인만 하면 접속 가능해야 함ng="EN-US">.
ng="EN-US">
비용 결제ng="EN-US">
ng="EN-US">1. 초기구축비용 일괄 지불ng="EN-US">
ng="EN-US">2. 구축 이후 분기 단위 유지보수ng="EN-US">/서버이용 등 비용 지불ng="EN-US">
-