Fx Chemicals produces two products (P1, P2), which need to be processed in two workstations (W1, W2). It has developed the following LP model to determine the weekly production volume of each product.

Let X1 = cubic metres of P1 to produce weekly; X2 = cubic metres of P2 to produce weekly.

Max z = 5.9 x1 + 4.1 x2

2 X1 + X2 ? 5.5. (1) - for W1

X1 + 3 X2 ? 5.5. (2) - for W2

X1, X2 non-negative

In the above model, the objective function represents revenue (in thousand dollars, i.e. $K), constraints LHS are processing time required (in days), and constraints RHS are processing time available (in days).

The Answer Report and Sensitivity Report created by Excel Solver are shown in Figure 1 and Figure 2, respectively.

Objective Cell (Max) Cell Name Original Value Final Value $D$3 Objective Totals 0 17.49 Variable Cells Cell Name Original Value Final Value Integer $B$10 Solution x1 0 2.2 Contin $C$10 Solution x2 0 1.1 Contin Constraints Cell Name Cell Value Formula Status Slack $D$4 Constraint (1) Totals 5.5 $D$4