6월 판매 진척 Dashboard6月销售进度 Dashboard

Excel《卖出贩卖进度매출진도》에서 AI 자동 정리 · 주문 기준일订单截止 2026-06-04 · Sell-out 기준일截止 2026-06-03
Powered by BI Team

6월 핵심 진척 통합 모듈6月核心进度统一模块

금액: Gross K위안金额：Gross K元주문 진척 = 주문 금액 ÷ ML 목표订单进度=订单金额÷ML目标
Key Metrics
ML Target = Initial monthly target; denominator for order progress Closed Progress = Closed ÷ ML Target Effective Progress = (Closed + Pick + Open) ÷ ML Target Total Progress = (Closed + Pick + Open + Back/Hold) ÷ ML Target Sell-out AR = Monthly Sell-out ÷ Sell-out Target
ML 목표ML目标 / 分母
90,221K元
LTV 28,373K元 WM 27,255K元 MNT 26,763K元 REF 5,584K元 PC 1,376K元 DEH 856K元 A/P 13K元
Closed 주문Closed订单
4,038K元
Closed 진척 = Closed ÷ ML 목표Closed进度 = Closed ÷ ML目标
4.5%4,038 ÷ 90,221
유효 주문有效订单
18,599K元
유효 주문 = Closed + Pick + Open有效订单 = Closed + Pick + Open
20.6%18,599 ÷ 90,221
전체 주문订单全部
24,067K元
전체 주문 = 유효 주문 + Back/Hold全部订单 = 有效订单 + Back/Hold
26.7%24,067 ÷ 90,221
주문 구성订单构成
16.8% 53.0% 7.3% 23.0%
Closed绿色：已关闭订单 Pick蓝色：已拣货订单 Open橙色：未结订单 Back/Hold红色：积压/保留订单
Closed4,038K元 Pick12,753K元 Open1,748K元 Back/Hold5,528K元
유효 주문 18,599 = Closed + Pick + Open; Risk ratio 23.0% = Back/Hold ÷ 전체 주문有效订单 18,599 = Closed + Pick + Open；Risk ratio 23.0% = Back/Hold ÷ 订单全部
Sell-out 진척Sell-out 表现
Sell-out目标143,161K元 当月Sell-out644.9K元 AR0.5% GR-88.9%
AR = 당월 Sell-out ÷ Sell-out 목표; GR = 당월 Sell-out ÷ Y-1 동기 - 1, Y-1 동기 5,786 K위안AR = 当月Sell-out ÷ Sell-out目标；GR = 当月Sell-out ÷ Y-1同期 - 1，Y-1同期 5,786 K元

제품별 통합 진척 테이블产品别合并进度大表

금액: Gross K위안金额：Gross K元구성/진척/AR/GR: %结构/进度/AR/GR：%
제품产品 ML 목표ML目标Gross K元 목표 비중目标占比 전체 주문订单全部Gross K元 주문 진척订单进度订单全部÷目标 유효 주문有效订单Gross K元 유효 진척有效进度有效订单÷目标 주문 상태 모듈订单状态模块Closed / Pick / Open / Back-HoldRisk=Back/Hold÷订单全部 Sell-out 목표Sell-out目标Gross K元 당월 Sell-out当月Sell-outGross K元 AR GR当月÷同期-1
TOTAL 90,221 K元
100.0%
 24,067 K元
26.7%
 18,599 K元
20.6%
Risk 23.0%
Closed 4,038 Pick 12,753 Open 1,748 Back/Hold 5,468
143,161 K元 645 K元 0.5% -88.9%
LTV 28,373 K元
31.4%
 11,905 K元
42.0%
 9,920 K元
35.0%
Risk 16.7%
Closed 1,346 Pick 7,795 Open 778 Back/Hold 1,985
37,404 K元 22 K元 0.1% -98.5%
MNT 26,763 K元
29.7%
 6,512 K元
24.3%
 4,138 K元
15.5%
Risk 36.4%
Closed 1,338 Pick 1,990 Open 806 Back/Hold 2,373
29,336 K元 83 K元 0.3% -90.9%
WM 27,255 K元
30.2%
 3,200 K元
11.7%
 2,481 K元
9.1%
Risk 22.5%
Closed 865 Pick 1,452 Open 164 Back/Hold 719
56,996 K元 398 K元 0.7% -84.4%
REF 5,584 K元
6.2%
 2,026 K元
36.3%
 1,753 K元
31.4%
Risk 13.5%
Closed 385 Pick 1,312 Open 0 Back/Hold 274
8,350 K元 142 K元 1.7% -83.0%
PC 13 K元
0.0%
 202 K元
1525.8%
 202 K元
1525.8%
Risk 0.0%
Closed 0 Pick 202 Open 0 Back/Hold 0
11,075 K元 0 K元 0.0% -100.0%
DEH 856 K元
0.9%
 220 K元
25.7%
 104 K元
12.1%
Risk 52.8%
Closed 104 Pick 0 Open 0 Back/Hold 116
0 K元 0 K元 - -

사업부별 성과 테이블营业部表现表格

금액: Gross K위안金额：Gross K元진척/AR/GR: %进度/AR/GR：%
사업부营业部ML 목표ML目标전체 주문订单全部주문 진척订单进度订单全部÷目标유효 주문有效订单주문 상태 모듈订单状态模块당월 Sell-out当月Sell-outARGR当月÷同期-1
TOTAL 63,076 K元 17,671 K元
28.0%
 14,577 K元
Risk 17.5%
Closed 2,817 Pick 10,762 Open 942 Back/Hold 3,095
645 K元 0.8% -89.8%
区域营业部 23,190 K元 2,820 K元
12.2%
 2,001 K元
Risk 29.0%
Closed 676 Pick 1,161 Open 164 Back/Hold 819
60 K元 0.2% -89.4%
全渠道营业部 36,790 K元 12,542 K元
34.1%
 10,276 K元
Risk 18.1%
Closed 1,407 Pick 8,036 Open 778 Back/Hold 2,266
-46 K元 -0.1% -100.8%
D2C营业部 3,096 K元 2,309 K元
74.6%
 2,300 K元
Risk 0.4%
Closed 734 Pick 1,565 Open 0 Back/Hold 9.6
631 K元 18.7% 2426.4%

6월 워시타워 통합 테이블6月洗烘塔订单与型号合并表

주문 기준일订单截止 2026-06-04 · Sell-out 기준일截止 2026-06-03수량: 대数量：台진척/AR/GR: %进度/AR/GR：%
사업부 주문 현황营业部订单现状
사업부营业部월초 계획月初预想전체 주문订单全部주문 진척订单进度订单全部÷目标유효 주문有效订单주문 상태 모듈订单状态模块당월 Sell-out当月Sell-outSell-out AR当月÷目标
TOTAL 396 台 31 台
7.8%
 31 台
Risk 0.0%
Closed 15 Pick 15 Open 1 Back/Hold 0
9 台 1.2%
区域营业部 354 台 27 台
7.6%
 27 台
Risk 0.0%
Closed 15 Pick 11 Open 1 Back/Hold 0
8 台 1.7%
全渠道营业部 0 台 -1 台
-
 -1 台
Risk -0.0%
Closed -1 Pick 0 Open 0 Back/Hold 0
0 台 0.0%
D2C营业部 12 台 5 台
41.7%
 5 台
Risk 0.0%
Closed 1 Pick 4 Open 0 Back/Hold 0
1 台 8.3%
모델별 상세 테이블型号明细表
모델型号월초 계획月初预想전체 주문订单全部주문 진척订单进度订单全部÷目标당월 Sell-out当月 Sell-outGR当月÷同期-1
TOTAL 396 台 31 台
7.8%
 9 台 -
FN231QH 62 台 0 台
0.0%
 0 台 -100.0%
FN23BQH 49 台 4 台
8.2%
 1 台 -80.0%
FN23WQH 155 台 13 台
8.4%
 3 台 -66.7%
FN23GQH 93 台 12 台
12.9%
 5 台 -
WT1310BGA 37 台 2 台
5.4%
 0 台 -

6월 Styler 통합 테이블6月 Styler 订单与型号合并表

주문 기준일订单截止 2026-06-04 · Sell-out 기준일截止 2026-06-03수량: 대数量：台진척/AR/GR: %进度/AR/GR：%
사업부 주문 현황营业部订单现状
사업부营业部월초 계획月初预想전체 주문订单全部주문 진척订单进度订单全部÷目标유효 주문有效订单주문 상태 모듈订单状态模块당월 Sell-out当月Sell-outSell-out AR当月÷目标
TOTAL 425 台 34 台
8.0%
 34 台
Risk 0.0%
Closed 14 Pick 20 Open 0 Back/Hold 0
6 台 0.7%
区域营业部 402 台 16 台
4.0%
 16 台
Risk 0.0%
Closed 11 Pick 5 Open 0 Back/Hold 0
2 台 0.3%
全渠道营业部 0 台 -1 台
-
 -1 台
Risk 0.0%
Closed -1 Pick 0 Open 0 Back/Hold 0
0 台 0.0%
D2C营业部 23 台 19 台
82.6%
 19 台
Risk 0.0%
Closed 4 Pick 15 Open 0 Back/Hold 0
4 台 16.7%
모델별 상세 테이블型号明细表
모델型号월초 계획月初预想전체 주문订单全部주문 진척订单进度订单全部÷目标당월 Sell-out当月 Sell-outGR当月÷同期-1
TOTAL 425 台 34 台
8.0%
 6 台 -
S3MF 0 台 -1 台
-
 -1 台 -108.3%
S3BF 24 台 0 台
0.0%
 0 台 -
S3IF 62 台 8 台
12.9%
 1 台 -
S3GHM 7 台 7 台
100.0%
 2 台 -
SC5GMR80H 100 台 10 台
10.0%
 2 台 -66.7%
SC5MSR40 25 台 7 台
28.0%
 1 台 -83.3%
SC5GMR4G 200 台 0 台
0.0%
 0 台 -
SC5MBR80H 7 台 3 台
42.9%
 1 台 -

고객별 진척 통합 모듈客户别进度统一模块

고객별 1행每客户一行상태 자동 분류状态自动分类
고객客户 Team 목표目标Gross K元 주문 TTL订单TTLGross K元 진척 모듈进度模块
赛夫(싸이푸)
Key AccountAhead
 CE平台营业Team 35,708 K元 12,504 K元
On Track 42.4%
OBS(오비에스)
Key AccountAhead
 D2C营业Team 2,933 K元 1,990 K元
On Track 56.8%
深圳顺电(선전순뎬)
Key AccountAhead
 华南营业Team 1,571 K元 673 K元
On Track 46.1%
天津鸿雁百大商贸(톈진홍옌바이다상마오)
Ahead
 华北营业team 346 K元 458 K元
High Progress 111.2%
广州璟宜达(광저우징이다)
Key Account
 华南营业Team 1,097 K元 336 K元
On Track 30.9%
华中营业Team B2B(화중영업팀 B2B)
Ahead
 华中营业team 50 K元 311 K元
High Progress 502.2%
延吉百大(옌지바이다)
Ahead
 东北营业Team 155 K元 193 K元
High Progress 131.6%
沈阳世纪创新(선양세기창신)
Key Account
 东北营业Team 1,936 K元 185 K元
Low Progress 9.9%
东北经贸(둥베이징마오)
Ahead
 东北营业Team 369 K元 146 K元
On Track 39.8%
四川品之尚(쓰촨핀즈상)
Key Account
 华中营业team 1,668 K元 76 K元
Low Progress 4.8%
新七天电子(신치톈전자)
Key Account
 CE POP 营业Team 1,109 K元 73 K元
Low Progress 6.5%
昆明际洲(쿤밍지저우)
Ahead
 华中营业team 136 K元 56 K元
On Track 51.3%
上海亦晶实业(상하이이징실업)
Key AccountFollow Up
 华中营业team 6,574 K元 39 K元
Low Progress 0.6%
汕头振乐(산터우전러)
Follow Up
 华南营业Team 279 K元 4.6 K元
Low Progress 1.9%
盛世恒隆(성스헝룽)
Key AccountFollow Up
 华北营业team 1,841 K元 0 K元
Follow Up 0.0%
黑龙江广汇(헤이룽장광후이)
Follow Up
 东北营业Team 528 K元 0 K元
Follow Up 0.0%
至诚志远(즈청즈위안)
Follow Up
 华北营业team 438 K元 0 K元
Follow Up 0.0%
沈阳品尚勤恒(선양핀상친헝)
Follow Up
 华南营业Team 105 K元 0 K元
Follow Up 0.0%
衡准宝声(헝준바오성)
Follow Up
 华南营业Team 105 K元 0 K元
Follow Up 0.0%
广东金誉电子(광둥진위전자)
Key AccountFollow Up
 华南营业Team 1,766 K元 -180 K元
Follow Up -11.7%
For internal viewing by LG China entity personnel only. Do not forward, distribute, or disclose externally.