Exercise $1$: Construct a mathematical model of an integer programming pro$-$

blem and use Solver to nd the optimal solution $($don$\text{'}$t forget to add integer

constraints in the Constraints$)$:

e$)$ Order Assignment Problem

A company can take on $6$ different orders, which differ in the consumption of production equipment time. The profit from individual orders and material consumption are known. Material and time resources are limited$.$ The parameters of the orders are summarized in the table:

$\backslash$table$[[$Order No$.,1,2,3,4,5,6,$Available Capacity$],[$Profit$,11,63,9,5,4,8,->$ max.$],[$Time Consumption $[$shifts$],1,7,1,1,1,5,15$ shifts$],[$Material Consumption kg$,15,70,10,5,3,2,100$kg$]]$

Design which orders the company should undertake to maximize its profit.