Complete the following problems. All work should be performed in a single Excel workbook (.xlsx) with multiple tabs. Repco produces three drugs, A, B, and C, and can sell these drugs in unlimited quantities at unit prices $8, $70, and $100, respectively. Producing a unit of drug A requires one hour of labor. Producing a unit of drug B requires two hours of labor and two units of drug A. Producing one unit of drug C requires three hours of labor and one unit of drug B. Any drug A that is used to produce drug B cannot be sold separately, and any drug B that is used to produce drug C cannot be sold separately. A total of 4000 hours of labor are available. Repco wants to use Linear Optimization to maximize its sales revenue.

a) (2 points) In a separate tab called a, build a spreadsheet model to calculate the total sales revenue for the problem assuming the values of 1, 1, and 1 for the quantities of drugs from each type.

b) (7 points) In a separate tab called b, use solver to optimize your spreadsheet model from part a (you can copy your model from tab a into tab b to start with). c) (3.5 points) Due to a recent regulation set by the DEA, the quantity produced from drug C should be at least 2% of the total drugs produced. In a separate tab called c, build a new spreadsheet model that considers this new constraint (you can copy your model from tab b into tab c to start with), and use solver to optimize your spreadsheet model.