I've been working on a case for a impending interview to present very shortly. The company presented me with a relatively small data set (17 columns x 18 rows). The question, likely on purpose does not fit within one clear framework. Without providing too much detail - decide where our company should build a new office. The prompt states they value access to engineering & sales talent, (numbers they provide to me over three years) then less so they value the ability to gain significant market share in that city.
Data presented gives me projected headcounts of sales & engineers on LinkedIn in each city, % college graduate rate, total # employed in high-tech software, competitor offices, average engineer and sales salary, then $/per square foot of rental space, average vacancy, corp. tax rate, 12 month recurring rev. and TAM (all in each city). My thought process is weight each component they value (1.access to talent, 2. ability to gain market share, 3. cost). Seems like a general Business Problem framework, perhaps supply demand, however I'm not entirely sure.
Any suggestions on how best approach the case and provide recommendation on where company should build their newest office?
Thanks for any help