A small engineering firm employs one civil engineer, two engineering technicians, and one summer intern. The types of projects the firm does includes surveys (typically 7 per month), designs (5 per month), and construction project plans (four per month). The times, in hours, required for each employee to complete teach type of project are shown below. Based on their capabilities and time spent on travel and administrative tasks, the engineer, tech 1, tech 2, and intern can handle 5, 4, 4, and 3 projects per month, respectively. Survey Design Plan Engineer 30 35 30 Technician 1 25 50 45 Technician 2 20 55 40 Intern 35 45 55 Implement a LP model in Solver and determine the optimal monthly assignment plan for the firm that minimizes total labor hours. What is the total number of hours that will be assigned to projects each month?
A small engineering firm employs one civil engineer, two engineering technicians, and one summer intern. The types of projects the firm does includes surveys (typically 7 per month), designs (5 per month), and construction project plans (four per month). The times, in hours, required for each employee to complete teach type of project are shown below. Based on their capabilities and time spent on travel and administrative tasks, the engineer, tech 1, tech 2, and intern can handle 5, 4, 4, and 3 projects per month, respectively.
Survey
Design
Plan
Engineer
30
35
30
Technician 1
25
50
45
Technician 2
20
55
40
Intern
35
45
55
Implement a LP model in Solver and determine the optimal monthly assignment plan for the firm that minimizes total labor hours. What is the total number of hours that will be assigned to projects each month?
Trending now
This is a popular solution!
Step by step
Solved in 7 steps with 8 images
