2. Tracking Part Information
The main objective of a design team is to define the parts that make up the product. Each part will have input from multiple team members. For instance a CAD designer might be responsible for modeling the part, while a procurement person would be selecting a supplier and yet another team member might determine the QA procedure. This combined effort requires a huge amount of communication.
An Excel file is the most common way to track parts throughout the design process - as people are comfortable using a list to view all information about a product's parts. For instance they might track the part number, description, vendor, material and a status (red, yellow, green) for each part.