Supply Chain Modeling using Excel

For this HW, feel free to use Excel to calculate your answers. Although, Excel is allowed, it is expected that you write down the formulations of your models when asked to do so. Also, if you do use Excel, you must submit your Excel template with your homework. Please answer the following questions for the following problems: Problem 2. (5 points) Consider a cost-benefit trade-off problem having the following data. Benefit Contribution per Unit of Each Activity Benefit #1 #2 #3 Unit Cost Activity 1 5 2 7 $60 Activity 2 3 2 9 $50 Minimum Acceptance Level 60 30 126 Cost (5) a. Express the model in algebraic form. b. Use the graphical method to solve this model. c. Formulate a linear programming model for this problem on a spreadsheet. d. Use the spreadsheet to check the following solutions: (X,X;) Feasible or not? (7.7) (7.8) (8,7) (8,8) (8,9) (9,8) e. Use Solver to find an optimal solution