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

Glueco produces three types of glue on two different production lines. Each line can be used 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 production line 1 and $2000 to set up production line 2. During a week on a production line, each worker produces the number of units of glue shown in the file P06_51.xlsx. Each week, at least 120 units of glue 1, at least 150 units of glue 2, and at least 200 units of glue 3 must be produced. Determine how to minimize the total cost of meeting weekly demands.