A company manufactures three products: x1, x2 and x3.

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.