A multi-tier study on supply chain flexibility in the automotive industry