Clueco produces three types of glue on two different production lines. Each line can be utilized by up to seven workers at a time. Workers are paid $500 per week on production line 1 and $900 per week...

Clueco produces three types of glue on two different production lines. Each line can be utilized by up to seven workers at a time. Workers are paid $500 per week on production line 1 and $900 per week on production line 2. For a week of production, it costs $1000 to set up line 1 and $2000 to set up line 2. The outputs of the three products from each line by each worker are provided in the attached spreadsheet. Each week at least 120 units of glue1, at least 150 units of glue 2, and at least 200 units of glue 3 must be produced. We need to determine how to minimize the total cost of meeting weekly demands.

The optimal worker schedule is (enter only the capital letter of the correct answer in the blank):

1. Assign 0 workers to line 1 and 4 to line 2


2. Assign 6 workers to line 1 and 0 to line 2


3. Assign 3 workers to line 1 and 2 to line 2


4. Assign 4 workers to line 1 and 3 to line 2


5. None of the above is optimal

If, in addition, we must produce at least 160 units of glue 1 if any workers assigned to line 1. Modify the spreadsheet to analyze the revised model. The optimal schedule is (enter only the capital letter of the correct answer in the blank):

1. Assign 0 workers to line 1 and 4 to line 2


2. Assign 6 workers to line 1 and 0 to line 2


3. Assign 3 workers to line 1 and 2 to line 2


4. Assign 4 workers to line 1 and 3 to line 2


5. None of the above is optimal

GlueProduction Glue Production Maximum number of workers per line7 Worker pay per week and setup cost on each line Line 1Line 2 Worker pay$500$900 Setup cost$1,000$2,000 Output per worker per week on each line for each type of glue Line 1Line 2Required Glue 12050120 Glue 23035150 Glue 34045200