본문으로 건너뛰기
← 글 목록
SCM·수익성soonsik ahn

No-touch Planning은 왜 다시 엑셀로 돌아갈까?

Post 2.1 — Why No-Touch Planning Still Ends in Spreadsheets

시스템에는 계획을 입력하지만 조건이 바뀌면 엑셀부터 엽니다. 예외 처리와 최종 판단이 여전히 밖에 남아 있다면, 시스템은 수작업을 대신한 것이 아니라 옮겨 놓은 셈입니다.

LinkedIn 최초 발행 · 원문 영어
LinkedIn 원문·댓글 보기 ↗

위에는 한국어 요약을, 아래에는 영어 원문을 실었습니다.

Post 2.1 — Why No-Touch Planning Still Ends in Spreadsheets

No-Touch Planning has been discussed for years as the future of supply chain execution.
Yet in practice, many planning organisations still rely on spreadsheets.

This is often explained as a trust problem.
But the issue is usually more structural.

Planning systems do not all do the same job.

Some mainly consolidate plans.
They collect inputs from different functions, align them, and create a single number for the organisation to work from.

Others are the place where plans are actually formed, adjusted as conditions change, and tested through immediate simulation of operational and financial consequences.

Only the second type moves an organisation materially closer to No-Touch Planning.

And that is where many implementations appear to stall.

Not every planning decision requires the same degree of system sophistication.

In some categories, the room for optimisation is genuinely narrow. Shelf life, production cadence, and other hard constraints already determine most of the answer. In such cases, static rules may be adequate.

In others, they are not.

Where demand variability is high, where SKU and lot complexity matter, and where inventory decisions carry meaningful financial consequences, the gap between static logic and system-led simulation becomes substantial.

That is where regression to spreadsheets destroys the most value.

So the issue is not simply that systems lack flexibility.

It is that organisations rarely distinguish between decisions for which basic control is enough and decisions for which the plan must be actively reshaped within the system itself.

Safety stock illustrates the point.

In volatile and financially material categories, safety stock should not remain a fixed inheritance from legacy logic. It should move as demand moves, as lead times shift, and as inventory positions change. And the implications should be visible immediately for service, inventory, operations, and margin.

In practice, however, something else often happens.

Legacy logic is moved into the system.
Exceptions remain manual.
Final judgement remains external.
And Excel remains the place where confidence is restored.

At that point, the system is not improving planning.
It is formalising an existing manual process.

So the real question is not whether the system can produce a plan.

It is whether, when reality changes, the system is where the plan is genuinely reworked.

Can it absorb change within the planning logic itself?
Can it show the effect on service, inventory, operations, and margin without manual reconstruction?
And can it produce an answer that is genuinely better than manual intervention?

If not, the organisation may plan in the system.
But it will continue to decide in the spreadsheet.

What is easy to automate and what is valuable to automate are not necessarily the same thing.

That distinction is often overlooked.

#SupplyChain #NoTouchPlanning #SCM #PlanningSystems

text
← 글 목록LinkedIn에서 대화 이어가기 ↗

함께 읽을 글

SCM·수익성

진짜 병목은 모델이 아닐 수 있다

영업은 거래처를, 마케팅은 제품 구색을, 생산은 효율을 봅니다. 같은 분석을 보고도 결론이 다른 이유입니다. 시뮬레이션은 갈등을 없애지는 못해도 각 선택에 얼마가 드는지는 보여 줍니다.

영어 원문 · 게시물본문 읽기 →