A financial services firm is opening a branch and they need to make staffing decisions. Administrative assistants are worth $100 in weekly profit but they require $100 from the technology budget and 50 ft2 of office space. Attorneys bring in $2000 a week in profit while using $100 from the technology budget and 400 ft2 of office space. Analysts are worth $500 a week in profit and use $1000 from the technology budget and 100 ft2 of office space. Finally the traders are worth $1500 a week in profit but require $200 from the technology budget and 400 ft2 of space. The office needs to have at least 4 administrative assistants and 10 analysts. There are only 4 attorneys available for the new office and you can bring at most 50 people to the new branch. The technology budget is $20000 per week and the new office has 12000 ft2 of space available. Give the LP Model and Excel Solver to find the optimal solution.