1: Below is the problem: Please use excel and POM-QM to solve this problem. Bare Minerals (a makeup company) produces a pink lip gloss and a plum lip gloss. Long-term projections indicate an expected demand of at least 200 pink lip gloss and 180 plum lip gloss each day. Because of limitations on production capacity, no more than 300 pink lip gloss and 260 plum lip gloss can be produced daily. In order to satisfy a shipping contract, a total of at least 300 pink lip gloss must be shipped daily. If each pink lip gloss is sold and results in a $4 loss, and each plum lip gloss is sold and produces a $55 profit, how many of each type should be made daily to maximize net profits? Employees are required to use 2 sheets of pink tissue paper for each package, how much tissue paper will be used daily for both products? Employees are required to use 1 sheet of gold tissue paper for each package, how much gold tissue paper will be used daily for both products? Below are the issues we will solve: 1. How many of each lip-gloss should be made daily in order to maximize net profits? (We are looking for the optimal solution here.) 2. Employees are required to use 2 sheets of pink tissue paper for each package, how much tissue paper will be used daily for both products? 3. Employees are required to use 1 sheet of gold tissue paper for each package, how much gold tissue paper will be used daily for both products? Below are the quantitative methods to be used: (Please use this to solve the problem) 1. Linear programming 2. Integer programming