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 6, 5, 5, and 4 projects per month, respectively.

Implement a LP model in Solver and determine the optimal monthly assignment plan for the firm. What is the total number of hours that will be assigned to projects each month?

Based on their salaries, the engineer, tech 1, tech 2, and intern earn $90, $65, $65, and $45 per hourly, respectively. Change the firm's objective function to minimize staff costs and find the optimal assignment plan. Does it change from the base case?

Please show your excel steps. Thank you.

Survey Design Plan Engineer Technician 1 Technician 2 Intern