A financial services firm is opening a branch and they need to make staffing decisions. Administrative

profiletutor4helpyou
 (Not rated)
 (Not rated)
Chat

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 $20,000 per week, and the new office has 12,000 ft2 of space available.
Give the LP Model and Excel Solver to find the optimal solution.

  • 9 years ago
A financial services firm is opening a branch and they need to make staffing decisions. Administrative
NOT RATED

Purchase the answer to view it

blurred-text
  • attachment
    answer.docx
  • attachment
    ref.xlsx