How do you calculate the landed cost of an enclosure?

Multiply the order quantity by the bare unit price and the landed multiplier, then add the one-time tooling and drawing charge. 100 enclosures at 185 with a 120% multiplier is 22,200; with a 1,200 tooling charge, 23,400, or 234.00 each, the Enclosure Cost calculator's own example.

What is the landed multiplier?

Everything added to the bare price to get the enclosure to your floor, as a percentage of it: 100 x (1 + freight + duty + finishing and other). 120 means 20% added. The workbook builds it from each supplier's charges on Setup, so an imported quote cannot leave duty out.

Why is the lowest bare price not always the lowest landed cost?

Freight and duty scale with the bare price, and tooling is spread over the order. A supplier with a lower bare price but higher charges or a large tooling charge can land above a dearer one, especially on short orders.

What does the saving tile show?

For each enclosure, the landed cost of the quote with the lowest bare price minus the lowest landed quote, times the order quantity, added up. It is what choosing on bare price would add to the build order.

Does it include cutouts, modifications or lead time?

No. Shop cutouts and modifications belong in your labour estimate. Lead time is shown for reference; it does not change the ranking.

Does the workbook use macros?

No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test quotes and shows Self-check: PASS.

Industry Cost Kits

Electrical Enclosure Cost Excel Template

Landed enclosure cost = order quantity × bare unit price × landed multiplier ÷ 100 + the tooling and drawing charge. Give every supplier quote a row and see the lowest landed quote for each enclosure, what freight, duty and finishing add, and what choosing on bare price would cost the order.

Free, and a plain .xlsx with no macros to enable. A CSV with live formulas and a printed how-to guide come with it.

Overview

This electrical enclosure cost template is a working Excel workbook for panel builders, buyers and estimators. Each supplier quote is one row with its bare unit price, tooling and drawing charge and lead time; the supplier's freight, duty and finishing charges on Setup make its landed multiplier, and the enclosure's order quantity spreads the tooling. Every quote gets a landed cost per enclosure and a rank against the other quotes for the same enclosure. It ships with 16 quotes from three suppliers for six enclosure types of a fictional panel builder, so every tile and chart is filled in when you open it.

In the example the importer quotes the lowest bare price on all six enclosures but has the lowest landed cost on only two. For the 800 x 600 x 300 enclosure its 268 bare price becomes 353.76 with 12% freight, 15% duty and 5% finishing, and 416.26 with a 2,500 tooling charge over 40 enclosures, against 376.20 landed from the domestic supplier at a 342 bare price. Choosing on bare price would add 1,602 to that order and 4,305 across the six; on the stainless and polycarbonate enclosures the import is the lowest landed quote.

Shop cutouts and modifications are not in the landed cost. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the dashboard, charts, dropdowns and self-check are in the .xlsx.

What this template includes

Setup sheet with your company and currency, the enclosures in the build order with their quantity, and each supplier's freight, duty and finishing charges, which make its landed multiplier
Quotes table, one row per supplier quote: enclosure, supplier, bare unit price, tooling and drawing charge and lead time, with a Check column
Per quote: landed enclosure price, total landed cost, landed cost per enclosure, how far it is over the bare price, its rank by landed cost and by bare price, the gap to the lowest landed quote and what that gap adds to the order
Dashboard with four tiles (enclosure types quoted, types where the lowest bare price is not the lowest landed, the saving from choosing on landed cost, the order cost at the lowest landed quotes), what each quote adds to the bare price, order cost at the lowest landed and lowest bare-price quote, and the enclosure and quote tables
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Enclosure Cost calculator (Self-check: PASS)
CSV with live formulas for the Quotes table; the dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it to compare domestic and imported enclosure quotes for a panel build, to price enclosures into a panel quote at landed cost, or to show a buyer what a lower bare price really costs once freight, duty and tooling are added.

How to use it

On Setup, type your company and currency, list the enclosures with their order quantity, and each supplier's freight, duty and finishing as a share of the bare price.
On Quotes, give each supplier quote a row: enclosure, supplier, bare unit price, tooling and drawing charge and lead time.
Fix anything the Check column names.
Open the Dashboard: the lowest landed quote for every enclosure and what choosing on bare price would add to the order.

Frequently Asked Questions

How do you calculate the landed cost of an enclosure?: Multiply the order quantity by the bare unit price and the landed multiplier, then add the one-time tooling and drawing charge. 100 enclosures at 185 with a 120% multiplier is 22,200; with a 1,200 tooling charge, 23,400, or 234.00 each, the Enclosure Cost calculator's own example.
What is the landed multiplier?: Everything added to the bare price to get the enclosure to your floor, as a percentage of it: 100 x (1 + freight + duty + finishing and other). 120 means 20% added. The workbook builds it from each supplier's charges on Setup, so an imported quote cannot leave duty out.
Why is the lowest bare price not always the lowest landed cost?: Freight and duty scale with the bare price, and tooling is spread over the order. A supplier with a lower bare price but higher charges or a large tooling charge can land above a dearer one, especially on short orders.
What does the saving tile show?: For each enclosure, the landed cost of the quote with the lowest bare price minus the lowest landed quote, times the order quantity, added up. It is what choosing on bare price would add to the build order.
Does it include cutouts, modifications or lead time?: No. Shop cutouts and modifications belong in your labour estimate. Lead time is shown for reference; it does not change the ranking.
Does the workbook use macros?: No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test quotes and shows Self-check: PASS.