A financial services firm is opening a branch and they need to make staffing dec

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.

You can place an order similar to this with us. You are assured of an authentic custom paper delivered within the given deadline besides our 24/7 customer support all through.