Please explain how to do this with excel solver. I know it is as add on$,$ but I don't understand how to utilize it for this problem. Please show and explain your work so I can complete this homework assignment.

As a result, some production must be routed to the older production line. Data for total production requirements, production$-$line capacities, and production

costs are shown in the table below.

Formulate an LP model that can be used to make the production routing decision $($submit xI spread sheet or screen shot$).$

What are the recommended decision and the total optimized cost? $($Use notation of the form xx$11$ units of product $1$ produced on Modern Line, x$12$ units of

product $1$ produced on Old Line, etc.$)$

Use excel solver to determine:

a$)$ product $1$ produced on Modern Line x$11=[$x$11]$

b$)$ product $1$ produced on line Old Line x$11=[$xx$12]$

c$)$ product $2$ produced on Modern Line xx$21=[$x$21]$

d$)$ product $2$ produced on Old Line xx$22=[$xx$22]$

e$)$ total optimized cost $=[$ cost $]$