Use solver to answer

Problem 2 New Age Shirts is releasing a batch new promotional raincoats, and the product options are analyzed. Four colors are available. The company has the goal of using all of its available stock of 50,000 ml of colorant and 9,700 ft of fabric; and counts with a budget of $29,700 to invest on this batch. Factor Blue Red Black Transparent Goal Penalty Weight Color 5 7 =50,000 3(+); 3 (-) Material 5 6 = 9,700 3(+); 3 (-) Investment 5 5 7 $ 29,700 6 2 0 4 4 5 a) How many of each color should be produced? b) Which goals were reached? c) From the goals not reached, by how much were they not reached