A Company Produces Three Products Which Must Be Painted, Assembled

question 66

Essay

A company produces three products which must be painted, assembled, and inspected. The machinery must be cleaned and adjusted before each batch is produced. They want to maximize their profits for the amount of operating time they have. The unit profit and setup cost per batch are: The operation time per unit and total operating hours available are: Based on this ILP formulation of the problem and the optimal solution (X₁, X₂, X₃) = (270, 0, 0), what values should appear in the shaded cells in the following Excel spreadsheet?
X_i = amount of product i produced
Y_i = 1 if product i produced, 0 otherwise ​ ​

---

Definitions:

Pairwise Relationship

The type of analysis or comparison made between pairs of objects, observations, or data points to assess their significance or relation.

Scatterplots

Graphical representations where two variables are plotted along two axes, revealing any relationships or patterns between them.

Variables

Elements, features, or factors that are liable to vary or change, often measured, controlled, or manipulated in experiments.

Residual

In statistics, a residual is the difference between the observed value and the value predicted by a model.