Exhibit 5-2 A Small Engineering Firm Employs One Civil Engineer, Two Engineering

question 29

Essay

Exhibit 5-2
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.
 ​
-Refer to Exhibit 5-2.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

---

Definitions:

Major Trading Partners

denotes the most significant countries with which a particular nation conducts a considerable portion of its imports and exports.

Candlemakers

Traditionally, artisans or companies involved in the production of candles for lighting and other purposes.

Tariffs

Taxes imposed on imported goods, typically used to protect domestic industries and raise government revenue.

Tariffs

Taxes imposed by a government on imported goods and services, often used to protect domestic industries from foreign competition or to generate revenue.