Subject process optimization (using solver) Specialty software is considering 10
ID: 2748452 • Letter: S
Question
Subject process optimization (using solver) Specialty software is considering 10 projects , which is captured in the attached spreadsheet which also Number of programmers required for each project , revenue and the year of the project is listed in the attachment. Company has 100 programmers and at the beginning of the each year it can hire 80 programmers. Regardless of the hired numbers, the training of the new hires is 5 million and the salary of the programmer is 50,000 per year How can Specialty software maximize the software . Use Solver to provide the answer
Explanation / Answer
Hi,
First we mention details what we have
1).10 projects what we have
2).Comapny has 100 programmers
3).At the beginning of each year it can hire 80 programmers
4).Training of new hires is 5 million
5).Salary of the programmer is 50000
as per details we have 100 programmers and 10 projects so 10 people can work simulteneously on 1 project for expedite process and complete it.
In the biginning of each year 80 programmers are joining in organisation will spread in traning first and than can utilise as a programmer .So for more expedite process 8 more programmers can spread between 100 programmes.
as per question there is no attached sheet other wise we cal allocate programmers according to work load and value of product.