Use Excel Solver to solve your Integer Linear Programming.

11-31 Basic Box Company is considering 5 new box designs of different sizes to package 4 up- coming lines of computer monitors. The follow- ing table shows the wasted space that each box would have if used to package each monitor. Missing values indicate a box that cannot be used for a particular monitor. Monitor Box 1 2 3 4 1 5 10 2 20 25 3 40 40 30 4 10 70 5 40 80 Basic wants to choose the smallest number of box designs needed to pack all products and to decide which box design to use for each monitor, to min- imize waste