Reference no: EM13470308

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 ft²of office space. Attorneys bring in $2000 a week in profit, while using $100 from the technology budget and 400 ft²of office space. Analysts are worth $500 a week in profit and use $1000 from the technology budget and 100 ft²of office space. Finally, the traders are worth $1500 a week in profit, but require $200 from the technology budget and 400 ft²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 $20,000 per week, and the new office has 12,000 ft²of space available. Give the LP Model and Excel Solver to find the optimal solution.