Insights | Archilion

Insights

Insights on automation, operations, import & export, and finance/accounting processes for manufacturers and trading businesses

3 production models that show you where your real bottleneck is

Nguyễn Hải Minh

3 production models that show you where your real bottleneck is

A workshop with 10 tabletops but only 20 of 40 needed legs can't finish more than 5 tables — no matter how much wood is sitting in the yard. Three production models explain why more input doesn't always mean more output, and where your real bottleneck actually is.

Operations

Jul 23, 2026

What is a production function — substitutional vs. limitational, and the natural limit on output

Nguyễn Hải Minh

What is a production function — substitutional vs. limitational, and the natural limit on output

Say "production function" and most people picture a dry accounting formula. It's actually one of the most foundational concepts in production economics — and understanding it explains why EVERY line, ...

Operations

Jul 23, 2026

Why adding more workers doesn't always increase output — and how to find your line's real limit

Nguyễn Hải Minh

Why adding more workers doesn't always increase output — and how to find your line's real limit

The most common reflex when a factory's output drops is to hire more people . Sometimes that's right. But a production-theory law more than a century old explains exactly when that reflex stops workin...

Operations

Jul 22, 2026

Why "just add a field" to your ERP is not as simple as it sounds

Nguyễn Hải Minh

Why "just add a field" to your ERP is not as simple as it sounds

A customer wants a new field on the order form — a priority flag, an extra reference number, whatever. It sounds like a five-minute change: one text box, one dropdown. Whoever owns your ERP promises "...

Data & Systems Architecture

Jul 22, 2026

4 reasons spreadsheets and raw files always lose to a real database as a workshop grows

Nguyễn Hải Minh

4 reasons spreadsheets and raw files always lose to a real database as a workshop grows

Most manufacturing workshops start with Excel. Then someone adds a second spreadsheet for inventory, a shared folder for order confirmations, and a third file for supplier contacts. It works for a whi...

Data & Systems Architecture

Jul 22, 2026

The physics of a spinning disk: why your ERP feels slow at the worst possible time

Nguyễn Hải Minh

The physics of a spinning disk: why your ERP feels slow at the worst possible time

Every workshop manager has lived through this moment. It is close to the end of the shift, everyone on the floor is entering the day's production numbers into the ERP at the same time, and the system ...

Data & Systems Architecture

Jul 22, 2026

The Core-Shell model: why "just customize the ERP" is always harder than it sounds

Nguyễn Hải Minh

The Core-Shell model: why "just customize the ERP" is always harder than it sounds

Every workshop that installs an ERP system eventually asks for "just one small change." Add a field to the goods-receipt screen. Change how a discount is calculated. Make the system talk the way the s...

Data & Systems Architecture

Jul 22, 2026

Individual vs. standard software — the "AT-software" trap that makes a system impossible to maintain

Nguyễn Hải Minh

Individual vs. standard software — the "AT-software" trap that makes a system impossible to maintain

Most workshops don't set out to build custom software. They set out to solve one specific problem — connect the warehouse system to the accounting export, or bridge the ERP to a customs portal — and a...

Data & Systems Architecture

Jul 22, 2026

5 types of system integration — a framework for why your two systems "don't talk" to each other

Nguyễn Hải Minh

5 types of system integration — a framework for why your two systems "don't talk" to each other

Every workshop that runs more than one system eventually hits the same wall: the ERP shows one stock number, the shop floor log shows another, and someone has to manually reconcile them every week — o...

Data & Systems Architecture

Jul 22, 2026

OLTP vs. data warehouse — why running the month-end report slows down your entire order system

Nguyễn Hải Minh

OLTP vs. data warehouse — why running the month-end report slows down your entire order system

Every month, the same complaint shows up in workshops running an ERP: someone opens the sales report, and for the next twenty minutes order entry on the shop floor feels sluggish. It's tempting to bla...

Data & Systems Architecture

Jul 22, 2026

The star schema through a real example: measuring delivery time with a fact table and dimensions

Nguyễn Hải Minh

The star schema through a real example: measuring delivery time with a fact table and dimensions

A customer asks why an order shipped three days late last month. Your ERP can answer that for one order, on one screen, in seconds — it was built to run that exact order in the first place: check whic...

Data & Systems Architecture

Jul 22, 2026

Model the process before you automate it — a real example with EPK, XOR and AND

Nguyễn Hải Minh

Model the process before you automate it — a real example with EPK, XOR and AND

A delivery-time calculation sounds like a simple feature: a customer places an order, the system checks stock, and it returns a promised date. Most teams write that logic straight into the ERP's scrip...

Data & Systems Architecture

Jul 22, 2026

1
2

ContactLiên hệ

Send a messageGửi tin nhắn

Zalo