Glueco produces three types of glue on two different production lines. Each line can be used by up to 20 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 20 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 $5000 to set up production line 1 and $4000 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 800 units of glue 1, at least 750 units of glue 2, and at least 100 units of glue 3 must be produced. Determine how to minimize the total cost of meeting weekly demands. Make sure the number of workers assigned to each line is an integer.