A company manufactures three products: x1, x2 and x3. Material and labor requirements per unit are:

The manager has listed the following objectives in order of priority (e.g. preemptive goals )

Goal 1: Minimize overtime in the assembly department. Goal 2: Minimize both idle time and overtime in the packaging department.

1. Formulate algebraically the corresponding goal programming problem.

2. Formulate this same goal programing problem on a spreadsheet

3. Describe clearly and completely the optimal solution to this problem using a managerial statement.

Product Material (lb./unit) Assembly (min./unit) Packing (min./unit) X1 2 9 1 2482 X2 X3 3 7 3 Availability 600 pounds 1800 minutes 250 minutes