TAB-QA-023 · Q&A · 2026-08-20 · Siwoo 영업·실적

2026년 TA$ 리베이트 잔여 현황 (딜러별)

2026년 잔여 리베이트를 사용하지 못한 딜러들 리스트업해줘

문서번호 TAB-QA-023 주제 영업·실적 일시 2026-08-20질문자 Siwoo 원본 30. Queries

2026-08-20 Q&A - Siwoo

Query

질문: 2026년 잔여 리베이트를 사용하지 못한 딜러들 리스트업해줘
질문자: Siwoo
일시: 2026-08-20 14:45

Answer

Update (2026-08-21) — 실제 데이터로 답변 갱신 (이전 "근거 없음" 답변 대체)

David가 리베이트(TA$/TAD) 잔여 현황이 Google Sheets “TADollar 2026” 탭에 딜러별로 기록되어 있음을 알려줬습니다. 해당 탭을 직접 재조회한 결과를 아래에 정리합니다. 이전 답변(“근거 없음”)은 이 탭의 존재를 모른 채 Sales Data 탭만 조회해서 나온 오답이었습니다 — 데이터가 없던 게 아니라 다른 탭에 있었습니다.

2026년 TA$ 리베이트 잔여 현황 (딜러별)

데이터 기준

Google Sheets “Turbo Air” > TADollar 2026 탭(2026-08-21 직접 조회). 이 시트는 Wiki의 “리베이트 35%/41%” RRP 구간별 지급율 스킴과 같은 프로그램입니다(David 확인, 2026-08-21) — 딜러의 전년도 순 판매건수 구간에 따라 35%/41% 스킴 중 하나가 적용되고, 그 지급율×리베이트 대상 RRP 합계가 이 시트의 Final TA$로 기록됩니다. 계산식: Remains(잔여) = Final TA$(배정액) − Paid(소진액). 컬럼 명세·계산 검증 상세는 Sales Data 테이블 명세 및 KPI 정의 §6을 참고하세요.

잔여 리베이트가 남은 딜러 (Remains 큰 순, 18곳)

순위	딜러	지역	Final TA$	Paid	Remains(잔여)
1	Industry Kitchens	VIC	$25,164	$9,307	$15,857
2	SCK Sydney Commercial Kitchens	NSW	$13,486	$8,138	$5,348
3	D&C CATERING PTY LTD	NSW	$4,807	$1,462	$3,345
4	Cafe ideas	NSW	$8,257	$5,126	$3,131
5	NISON REFRIGERATION	VIC	$5,408	$2,352	$3,056
6	Harvey Norman Commercial	NSW	$4,128	$1,334	$2,794
7	Austmont	NSW	$2,874	$251	$2,623
8	FESS Food Equipment Sales & Service	NSW	$3,841	$1,489	$2,353
9	AGC Catering Equipment	NSW	$10,649	$9,241	$1,408
10	SETPOINT AIR & MECHANICAL	VIC	$4,195	$2,799	$1,396
11	HS EXPRESS	NSW	$4,105	$3,094	$1,011
12	CHEF’S HAT AUSTRALIA	VIC	$4,979	$4,025	$954
13	restaurant equipment online	VIC	$4,772	$3,933	$839
14	Channon Refrigeration Sales	NSW	$4,628	$3,914	$714
15	Bendex Stainless Steel Fabricators	VIC	$5,604	$4,936	$668
16	Ribarovski	NSW	$8,597	$8,083	$514
17	Reward Hospitality	VIC	$3,858	$3,721	$137
18	CATERLINK COMMERCIAL KITCHENS AND BARS	VIC	$2,930	$2,887	$43

합계: 위 18곳 잔여 리베이트 합계 ≈ $46,190.

이미 전액 소진한 딜러 (Remains = $0, 5곳)

QCC(NSW), SuperModern(VIC), Matty’s Catering Equipment(NSW), CaterBuild(NSW), Snowmaster(NSW).

전체 요약

딜러 23곳, Final TA $(배정 총액)$ 144,499, Paid(소진 총액) ≈ $98,309, Remains(잔여 총액) \approx$ 46,190.
Industry Kitchens 1곳이 전체 잔여분의 약 34%( $15,857 /$ 46,190)를 차지 — 압도적 1위입니다.

참고·한계

“잔여”의 의미: Paid에는 이미 완전히 지급된 금액뿐 아니라, 아직 인보이스 전인 진행 중 오더(Ordered 상태)의 예정 TAD도 포함됩니다(TADollar 2026 시트가 그렇게 계산하고 있음을 실측으로 확인). 즉 위 Remains는 “지급 예정분까지 반영한 뒤 남은” 순수 미배정 잔여입니다.
35%/41% 스킴 배정은 여전히 불명: 위 18곳 각각이 35%/41% 중 어느 스킴 대상인지는 시트·모델 어디에도 기록돼 있지 않습니다(영업판매실적 조회 절차 Open Question, 미해결).
이 데이터는 스냅샷(2026-08-21)이며 시트는 계속 갱신됩니다 — /ask에 다시 물어보면 그 시점 최신 수치로 재계산됩니다(2026-08-21부터 /ask 봇이 리베이트 질문 시 이 탭을 자동으로 실시간 조회하도록 연동됨).

참고 문서

Sales Data 테이블 명세 및 KPI 정의 §6 — TADollar 2026 시트 컬럼 명세·계산 검증
영업판매실적 조회 절차 — 리베이트 35%/41% 스킴 구조, 딜러별 스킴 배정 Open Question
Google Sheets “Turbo Air” > TADollar 2026 탭 (2026-08-21 직접 재조회)

Referenced Pages

(답변 본문의 “참고 문서” 섹션 참고)

Gaps Identified

Knowledge Gap

35%/41% 스킴의 딜러별 배정 기준은 여전히 불명(위 “참고·한계” 참고). 이 답변의 딜러별 Remains 순위·합계는 turboairbrain.uk/ask 사이트 채팅이 아니라 사용자 요청으로 직접 재조회·검증되었지만, 중요한 의사결정에 쓰기 전 /verify로 재검토하세요.

ℹ️ 提问 问题：2026년 잔여 리베이트를 사용하지 못한 딜러들 리스트업해줘 提问者： Siwoo时间：2026-08-20T04:45:47.288Z

回答

📝 更新（2026-08-21）— 使用实际数据更新回答（替代之前"无数据依据"的回答） David指出，返利（TA$/TAD）余额情况按经销商记录在Google Sheets"TADollar 2026"标签页中。以下是直接重新查询该标签页的结果整理。之前"无数据依据"的回答是在不知道该标签页存在的情况下，仅查询了Sales Data标签页得出的错误结论——并非数据不存在，而是记录在另一个标签页中。

2026年TA$返利余额情况（按经销商）

数据基准

Google Sheets"Turbo Air" > TADollar 2026标签页（2026-08-21直接查询）。该表与Wiki中"返利35%/41%"的RRP阶梯支付方案是同一项目（David于2026-08-21确认）——根据经销商上一年度净销售件数所处区间，适用35%或41%其中一种方案，该支付率×返利对象RRP合计记录在此表的Final TA$列。计算公式：Remains（余额）= Final TA$（已分配额）− Paid（已消耗额）。列结构说明及计算验证详情请参见"Sales Data 表结构说明及 KPI 定义"§6。

尚有返利余额的经销商（按Remains从大到小排序，共18家）

排名	经销商	地区	Final TA$	Paid	Remains（余额）
1	Industry Kitchens	VIC	$25,164	$9,307	$15,857
2	SCK Sydney Commercial Kitchens	NSW	$13,486	$8,138	$5,348
3	D&C CATERING PTY LTD	NSW	$4,807	$1,462	$3,345
4	Cafe ideas	NSW	$8,257	$5,126	$3,131
5	NISON REFRIGERATION	VIC	$5,408	$2,352	$3,056
6	Harvey Norman Commercial	NSW	$4,128	$1,334	$2,794
7	Austmont	NSW	$2,874	$251	$2,623
8	FESS Food Equipment Sales & Service	NSW	$3,841	$1,489	$2,353
9	AGC Catering Equipment	NSW	$10,649	$9,241	$1,408
10	SETPOINT AIR & MECHANICAL	VIC	$4,195	$2,799	$1,396
11	HS EXPRESS	NSW	$4,105	$3,094	$1,011
12	CHEF'S HAT AUSTRALIA	VIC	$4,979	$4,025	$954
13	restaurant equipment online	VIC	$4,772	$3,933	$839
14	Channon Refrigeration Sales	NSW	$4,628	$3,914	$714
15	Bendex Stainless Steel Fabricators	VIC	$5,604	$4,936	$668
16	Ribarovski	NSW	$8,597	$8,083	$514
17	Reward Hospitality	VIC	$3,858	$3,721	$137
18	CATERLINK COMMERCIAL KITCHENS AND BARS	VIC	$2,930	$2,887	$43

合计：以上18家经销商余额合计 ≈ $46,190。

已全额消耗的经销商（Remains = $0，共5家）

QCC（NSW）、SuperModern（VIC）、Matty's Catering Equipment（NSW）、CaterBuild（NSW）、Snowmaster（NSW）。

整体汇总

经销商共23家，Final TA$（分配总额）$144,499，Paid（消耗总额）≈$98,309，Remains（余额总额）≈$46,190。
Industry Kitchens一家占整体余额的约34%（$15,857 / $46,190）——遥遥领先第一。

说明与局限性

"余额"的含义：Paid不仅包含已完全支付的金额，还包含尚未开票、正在进行中的订单（Ordered状态）的预计TAD（经实测确认TADollar 2026表确实按此方式计算）。也就是说，上方Remains是在反映了已排定待支付部分之后剩余的纯未分配余额。
35%/41%方案分配依据仍不明确：上述18家经销商各自适用35%还是41%方案，在表格或模型中均未记录（"营业销售실적 조회 절차"中的待解决问题，尚未解决）。
此数据为快照（2026-08-21），表格持续更新中——再次向/ask提问将按当时最新数值重新计算（自2026-08-21起，/ask机器人在收到返利相关问题时会自动实时查询该标签页）。

参考文档

Sales Data 表结构说明及 KPI 定义 §6 — TADollar 2026表列结构说明及计算验证
营业销售实绩查询流程 — 返利35%/41%方案结构，经销商方案分配的待解决问题
Google Sheets"Turbo Air" > TADollar 2026标签页（2026-08-21直接查询）

参考文档

（请参考上方回答正文中的"参考文档"部分）

已识别的知识缺口

⚠️ 知识缺口 35%/41%方案的经销商分配依据仍不明确（见上方"说明与局限性"）。本回答中各经销商的Remains排名及合计并非通过turboairbrain.uk/ask网站聊天生成，而是应用户要求直接重新查询并验证的，但在用于重要决策之前，请先用/verify重新核实。

ℹ️ Query Question: 2026년 잔여 리베이트를 사용하지 못한 딜러들 리스트업해줘 Asked by: SiwooDate: 2026-08-20T04:45:47.288Z

Answer

📝 Update (2026-08-21) — updated with actual data (replaces the earlier "no basis" answer) David pointed out that remaining rebate (TA$/TAD) balances are recorded per dealer on the Google Sheets "TADollar 2026" tab. The result of querying that tab directly is summarized below. The earlier "no basis" answer had queried only the Sales Data tab, unaware this tab existed — the data wasn't missing, it was just on a different tab.

2026 TA$ Rebate Balance by Dealer

Data Basis

The Google Sheets "Turbo Air" > TADollar 2026 tab (queried directly on 2026-08-21). This sheet is the same program as the Wiki's "Rebate 35%/41%" RRP-tier payout scheme (confirmed by David, 2026-08-21) — one of the 35%/41% schemes is applied based on a dealer's prior-year net sales-count tier, and that rate × the rebate-eligible RRP total is recorded on this sheet as Final TA$. Formula: Remains = Final TA$ (allocated) − Paid (consumed). See "Sales Data Table Spec & KPI Definitions" §6 for the full column spec and calculation verification.

Dealers with a Remaining Rebate Balance (ranked by Remains, 18 dealers)

Rank	Dealer	Region	Final TA$	Paid	Remains
1	Industry Kitchens	VIC	$25,164	$9,307	$15,857
2	SCK Sydney Commercial Kitchens	NSW	$13,486	$8,138	$5,348
3	D&C CATERING PTY LTD	NSW	$4,807	$1,462	$3,345
4	Cafe ideas	NSW	$8,257	$5,126	$3,131
5	NISON REFRIGERATION	VIC	$5,408	$2,352	$3,056
6	Harvey Norman Commercial	NSW	$4,128	$1,334	$2,794
7	Austmont	NSW	$2,874	$251	$2,623
8	FESS Food Equipment Sales & Service	NSW	$3,841	$1,489	$2,353
9	AGC Catering Equipment	NSW	$10,649	$9,241	$1,408
10	SETPOINT AIR & MECHANICAL	VIC	$4,195	$2,799	$1,396
11	HS EXPRESS	NSW	$4,105	$3,094	$1,011
12	CHEF'S HAT AUSTRALIA	VIC	$4,979	$4,025	$954
13	restaurant equipment online	VIC	$4,772	$3,933	$839
14	Channon Refrigeration Sales	NSW	$4,628	$3,914	$714
15	Bendex Stainless Steel Fabricators	VIC	$5,604	$4,936	$668
16	Ribarovski	NSW	$8,597	$8,083	$514
17	Reward Hospitality	VIC	$3,858	$3,721	$137
18	CATERLINK COMMERCIAL KITCHENS AND BARS	VIC	$2,930	$2,887	$43

Total: combined remaining balance across these 18 dealers ≈ $46,190.

Dealers Who Have Fully Used Their Balance (Remains = $0, 5 dealers)

QCC (NSW), SuperModern (VIC), Matty's Catering Equipment (NSW), CaterBuild (NSW), Snowmaster (NSW).

Overall Summary

23 dealers total, Final TA$ (total allocated) $144,499, Paid (total consumed) ≈ $98,309, Remains (total remaining) ≈ $46,190.
Industry Kitchens alone accounts for approximately 34% of the total remaining balance ($15,857 / $46,190) — a dominant #1.

Notes & Limitations

What "remaining" means: Paid includes not just amounts already fully disbursed, but also the projected TAD for orders still in progress and not yet invoiced (Ordered status) — confirmed by direct inspection that the TADollar 2026 sheet calculates it this way. In other words, the Remains figures above are the true unallocated balance after accounting for what's already scheduled to be paid.
35%/41% scheme assignment is still unknown: which of the two schemes applies to each of the 18 dealers above isn't recorded anywhere in the sheet or the model (an open question in "Sales Performance Lookup Procedure," still unresolved).
This data is a snapshot (2026-08-21) and the sheet is continuously updated — asking /ask again will recalculate with the latest figures at that time (as of 2026-08-21, the /ask bot automatically queries this tab live whenever a rebate question comes in).

Referenced Pages

Sales Data Table Spec & KPI Definitions §6 — TADollar 2026 sheet column spec and calculation verification
Sales Performance Lookup Procedure — the 35%/41% rebate scheme structure, and the open question on per-dealer scheme assignment
Google Sheets "Turbo Air" > TADollar 2026 tab (queried directly on 2026-08-21)

Referenced Pages

(see the "Referenced Pages" section in the answer body above)

Gaps Identified

⚠️ Knowledge Gap Which 35%/41% scheme applies to each dealer remains unknown (see "Notes & Limitations" above). The per-dealer Remains ranking and totals in this answer were re-queried and verified directly at the user's request (not via the turboairbrain.uk/ask site chat), but review it with /verify before using it for any significant decision.