Please, could you explain to me how to solve the attached question using SOLVER (Simplex method - Linear Programming) in EXCEL?

Thanks.

Attached: Question and file mentioned in the question (Ch 6_51 from Practical Management Science 5th Ed)

nuual. UL:- UWIHH. The TightBond company produces three types of glue on two different production lines. Each line can he 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 setup productiu line I 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 le Pjlmlsa. Each week, at least 300 units of glue 1. at least 750 units of glue 2, and at least 100 units of glue 3 must he produced. Detetmine how to minimise the total cost of meeting weekly demands. Make sure the number of workers assigned to each line is an integer. TightBond data Output per worker per week on each line for each type of glue Line 1 Line 2 Glue 1 20 50 Glue 2 30 35 Glue 3 40 45