Discuss the importance of material selection in mechanical engineering design, covering factors such as mechanical properties, environmental resistance, cost, and manufacturability, and how these factors influence the final product design.