A group of young students earns a (temporary) steady living by picking up ...

     A group of young students earns a (temporary) steady living by   picking up discounted items from electronic stores ($10 per piece) and   reselling them. Each item has a street value, a weight, and a volume; there   are limits on the number of available items, and on the total weight (<   500 pounds) and volume (< 300 cubic feet) that can be managed at one time.   Values,   weights, volumes, and available numbers are given below.                                        value             weight          volume         available number   TV                                  50                  35                  8                           20    Radio                              15                   5                   1                           50    Camera                           85                   4                   2                           20    CD   Player                       40                   3                   1                           30    Laptop                             50                  15                  5                           30    LCD   Monitor                     120                 20                4                           15    Formulate a   LP problem and solve it with Excel Solver to find out how many of each item   the students should pick and resell (include a copy of the software   analysis).