Provide lp model and excel solver to find optimal solution


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

Request for Solution File

Ask an Expert for Answer!!
Mathematics: Provide lp model and excel solver to find optimal solution
Reference No:- TGS0542541

Expected delivery within 24 Hours