In support of the text, The Mechanical Design Process, there are 25 templates.  Each is a Microsoft Word or Excel form that can be filled in to help fulfill a part of the product development process.

Many of these templates have form fields in them to make “filling in the blanks” easy. This includes Text Form Fields and Drop Down Form Fields.. To edit these fields, display the Forms Toolbar (<View>, <Toolbars>, <Forms>). Unlock the form to edit (right icon that looks like a lock). Be sure to relock it or the drop downs won’t work.

 Those template marked with an “*” are Excel worksheets (5, 6, 13, 14, 18). They automatically calculate important design information.  Click on the title of the template below to download the template.

 1.    Product Decomposition

The goal is to dissect existing products to learn about how things are built. Additional rows can be added as needed. The example of the Irwin Clamp also is used here and in items 6 and 21 below. 

 2. Team contract

This is a blank form for teams to establish goals, performance expectations and performance expectations.

 3. Meeting minutes

This is a simple form for keeping meeting records. It has areas for the agenda, discussion, decisions made and action items.

 4. Team health inventory

A questionnaire with seventeen questions to assess team health and room to add more items as needed.

 5. * Design for Sustainability

This spreadsheet is based on the ECO-indicator 99 from FutureSME. There are four tabs. The first is an introduction with instructions. The second tab <Form> is the sustainability worksheet. . The third tab <Coffee pot> is an example. The remainder of the tabs are support information for the <Form>.

 6. * Plastics ID

This is an Excel spread sheet that can be used to identify the types of plastics used in products that are decomposed (see item 1).

 7. Design Report

This is not a template but a guideline for an engineering design report. The items borrowed heavily from one used by the EE department at the Milwaukee School of Engineering.

8. Product Proposal

This template has all the elements needed for the proposal of a new product. The example is taken from an actual proposal.

 9.   Pro-Con Analysis

This template allows the easy listing Pro and Con factors for making a simple decision.

 10. Project Planning

Project Planning requires the careful definition of tasks , their objectives, deliverables and assignment. This template encourages thinking each task through during the planning process.

 11. SWOT

The “Strength-Weakness-Opportunity-Threat” or SWOT analysis is widely used in business to evaluate situations. It is also useful in engineering design.

 12. Technology Readiness

This is a simple analysis to determine the readiness of a technology for use in a product. A low “readiness” implies that the project is research and development rather than design, a high readiness technology is product-ready.

 13. *  Plastic part cost calculator

This spreadsheet allows the calculation of the cost to produce a plastic part. It is based on the combination of a number of models and includes such factors as material, size, complexity, surface finish, production volume, wall thickness and tolerance. It is fairly accurate and can give a good feel for the effect of design changes, but not intended for actual cost estimation.

 14 .*  Machined part cost calculator

This spreadsheet allows the calculation of the cost to produce a machined metal part. It is based on the combination of a number of models and includes such factors as material, size, complexity, surface finish, production volume, tolerance, and machine tools needed. It is fairly accurate and can give a good feel for the effect of design changes, but not intended for actual cost estimation.

 15. Morphology

A morphology is a basic method to develop new concepts from a basic understanding of the functionality.

 16. Voice of the Customer

This form helps in asking the right questions to understand what a potential customer might want in a product. It is a good starting place for QFD.

 17. Reverse Engineering for Function Understanding

Reverse engineering is a method to understand how a product works. It is like product decomposition (Template 1) but with a focus on function.

 18.* Personal Problem Solving Dimensions

This spreadsheet allows rapid identification of problem solving style

 19. Test Report

This is a simple format to report the results of testing.

 20. Make/Buy or Vendor Selection Decisions

This form can be used to help make decisions about which vendor to choose for a component or product. Alternatively Vendor 1 and be the option to Make the item in-house and Vendors 2-N can be options to Buy the item from others.

21. DFAssy

This is a questionnaire that develops Design for Assembly (DFA) score. Since this is a relative score, it is only good for the comparison of two designs for the same product. The examples are for two designs for hand clamps.

 22. FMEA

This Failure Modes and Effects Analysis (FMEA) template helps organize the information needed for an FMEA study.

 23. Bill of Materials (BOM)

This form is very useful in developing a BOM.

 24. Engineering Change Notice (ECN)

This is a simple form for a change notice

 25. Patent Specification

This form contains all the fields needed to write a patent prospectus.

 

 

 

Go to top