These need to be solved using linear program functions in excel. If you could please show me the formulas to enter in and the constraints for each a-b

Assignment: Homework CH 3 Q1. A company produces two products, A and B, which have profits of $9 and $7, respectively. Each unit of product must be processed on two assembly lines, where the required production times are as follows: Product Resources / Unit 1 2 12 4 A 4 8 Total Hours 60 40 a. Formulate a linear programming model to determine the optimal product mix that will maximize profit. b. Solve graphically and identify the amount of unused resources (slack) at each of the graphical extreme points. c. What would be the effect on the optimal solution if resource Line 1 was reduced to 40 units? d. What would be the effect on the optimal solution if the profit for product B was increased from $7 to $15? To $20? Assignment: Homework CH 3 Q1. A company produces two products, A and B, which have profits of $9 and $7, respectively. Each unit of product must be processed on two assembly lines, where the required production times are as follows: Product Resources / Unit 1 2 12 4 A 4 8 Total Hours 60 40 a. Formulate a linear programming model to determine the optimal product mix that will maximize profit. b. Solve graphically and identify the amount of unused resources (slack) at each of the graphical extreme points. c. What would be the effect on the optimal solution if resource Line 1 was reduced to 40 units? d. What would be the effect on the optimal solution if the profit for product B was increased from $7 to $15? To $20