Goal Programming Do all of the following in one Excel file, separate worksheets for each problem Write the formulations for each of these problems as goal programming problems. Set up and solve in Excel using Solver Report the solutions and the goal attainments. Report in the Excel file, below the problem set up. 1. The As You Like It Co. manufactures three different products: Good, Better, and Best. The profits are respectively $50, $70 and $100. The following table indicates the requirements of material, labor and equipment needed to produce a single unit of each model. Good Better Best Material (parts/ unit) 7 7.5 8 Labor (hours/units) 3 5 4 Equipment (hours/unit) 4 3 2 The general manager has prioritized the following goals: Manufacture at least 20 units of Good, 15 units of Better, and 10 units of Best. Avoid using more than 300 parts of material Avoid using 150 hours of labor Avoid using 120 hours of equipment. Achieve a target profit of $3,000. Formulate and solve the goal programming problem to determine the product mix. Formulate and solve the goal programming problem to determine the number of components produced and purchased next month, according to these ranked goals. 2. The Oregon Atlantic Company produces two kinds of paper - newsprint and white wrapping paper. It requires 5 minutes to produce a yard of newsprint and 8 minutes to produce a yard of wrapping paper. The company has 80 hours of normal production capacity available each week. The profit is $0.20 for a yard of newsprint and $0.25 for a yard of wrapping paper. The weekly demand is for 500 yards of newsprint and 400 yards of wrapping paper. The company has established the following goals, in order of priority: 1. Limit overtime to 8 hours per week. 2. Maximize the profit per week. 3. Fulfill the demand for each of the products. 4. Avoid underutilization of production capacity. Formulate and solve the goal programming model to determine the number of yards of each type of paper to produce weekly to satisfy the various goals