Instrument Material Take Off (MTO) Template
A material take off for instrument bulk items: tubing, fittings, valves, brackets, glands and cable. Quantity per hook up times the number of hook ups, plus wastage, gives the order quantity.
Download
- How to Use sheet with steps
- Template sheet, blank and ready
- Example sheet, filled in
- 160 built in formulas
- A4 landscape print setup
- Works in Excel, Google Sheets and LibreOffice
Preview of the Filled Example
This is the Example sheet from the download, so you can see exactly how the completed instrument material take off (mto) looks.
Material take off
| Sr | Item | Specification | Material | Size | Unit | Qty per hook up | No of hook ups | Total qty | Wastage (%) | Order qty |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Instrument tube | Seamless, ASTM A269, 0.035" wall | SS 316 | 1/2" OD | m | 6 | 14 | 84 | 10 | 93 |
| 2 | Male connector | Twin ferrule, tube x NPT(M) | SS 316 | 1/2" x 1/2" | no | 2 | 14 | 28 | 5 | 30 |
| 3 | 2 valve manifold | Block and bleed, 6000 psi | SS 316 | 1/2" NPT | no | 1 | 8 | 8 | 0 | 8 |
| 4 | 3 valve manifold | Integral, for DP transmitter | SS 316 | 1/2" NPT | no | 1 | 6 | 6 | 0 | 6 |
| 5 | Root valve | Needle valve, 6000 psi | SS 316 | 1/2" NPT | no | 2 | 6 | 12 | 0 | 12 |
| 6 | 2" pipe stand | Floor mounted, with base plate | Galvanised CS | 2" NB | no | 1 | 14 | 14 | 0 | 14 |
| 7 | Cable gland | Double compression, Ex d / Ex e | Nickel plated brass | M20 | no | 2 | 14 | 28 | 10 | 31 |
About the Instrument Material Take Off (MTO)
Instrument bulk materials are bought long before installation, from hook up drawings rather than finished installations. A clear MTO avoids both shortages that stop work on site and expensive surplus at the end of the project.
How to fill in this template
- List each bulk item once, with a full specification so the buyer can order without questions.
- Count the quantity used in one hook up of each type from the hook up drawing.
- Enter how many instruments use that hook up.
- Set a wastage percentage for cut items such as tube and cable.
- Order quantity rounds up automatically.
What the formulas do
- Total = quantity per hook up × number of hook ups.
- Order quantity = ROUNDUP(total × (1 + wastage % ÷ 100)).
Related tools
Frequently Asked Questions
What is an MTO in instrumentation?
A material take off: a list of all bulk materials needed for instrument installation, calculated from hook up drawings and quantities.
How much wastage should I add to tubing?
Typically 5 to 10 % for tube and cable; fittings and valves are usually ordered exactly or with a small spare.
Where do hook up quantities come from?
From the bill of materials on each standard hook up drawing.
Learn more on the blog
Material take off guide: 7 essential MTO components
A practical guide on instrumentationblog.in that explains the procedure behind this template and how engineers apply it on real plants.
Read Full Article