Warehouse Network Decision Model — Mô Hình Quyết Định Mạng Lưới Kho

Before: You are leaning toward a second warehouse because delivery is slow and shipping is expensive, but you keep second-guessing. More rent, stock tied up in two places, is it worth it. A multi-billion-dong decision riding on rent and instinct.

After: You have a clear comparison. Which option has the lowest total cost while still hitting your delivery promise, how much it saves per month, and how many orders a month it takes to break even. Enough to brief leadership or sign the lease.

• Enter your demand zones, meaning orders by region, and your current warehouses into the file.
• Add up to 3 candidate sites you are weighing.
• Open the Decision Dashboard. You see the recommended scenario, monthly savings, and break-even months right away.

• The file compares options on total cost, not just rent. It rolls transport, fixed, handling and inventory-carrying costs into a single number, so a cheap site that does not cut shipping is exposed as the burden it is.
• You learn the monthly order volume that pays the warehouse back. The file works out break-even per scenario, turning a strategic bet into a clear volume threshold.
• You do not have to sacrifice service to cut cost. A delivery-quality matrix shows how many orders each scenario delivers on time, so you pick the lowest total cost that still protects the customer experience.
• It counts the inventory you would duplicate. A second site means holding stock in two places, and that added cost is made explicit rather than ignored.
• The file generates a short executive memo, with the action, reason, payback and risk, that you can paste straight into an email or board slide.
• Every assumption is visible and editable. The carrying rate and on-time threshold live in the Settings sheet, so you can test what-if scenarios easily with no numbers hidden in formulas.
• You choose VND or USD, and the sample data is localized to HCMC, Hanoi, Da Nang and Can Tho.

• SME FMCG, retail, beauty or wholesale distributors running 1-5 storage points and weighing a second distribution center.
• Operations and logistics leads who need to build the decision case before signing a multi-year lease.
• Supply-chain consultants who need a transparent, presentable model without expensive optimization software.

• The file is built on standard industry frameworks, including the total-logistics-cost curve, center-of-gravity positioning, and the inventory law as you add warehouses. Each sheet maps to a principle and guards against a common mistake.
• It ships with Vietnam sample data, so you see the model run before entering your own numbers.
• It runs on both Excel and Google Sheets, and you own it for good and use it fully offline.
• It is bilingual Vietnamese and English, presentable to international partners too.

I'm not an analyst. Can I still use it?

Yes. You enter demand zones and candidate sites, and the file handles the cost comparison and payback, then summarizes it into a recommendation.

Does it decide for me?

No. It gives transparent numbers and a recommended scenario, but the final call is yours, and every assumption is editable so you can re-test for your situation.

Can it handle more than two warehouses?

Yes. It compares the current state against up to 3 candidate sites at once.

How do I receive the file after buying?

You download it right after payment.

• The file includes a Guide sheet so you can start quickly.
• When you need help, contact the BEUP team for support using the model.