Explain the impact of material selection on the design and performance of a mechanical system, focusing on the trade-offs between strength, weight, corrosion resistance, and manufacturing costs?