) (3 points) What are the decision variables? How many decision variables are there? Clearly explain the decision variables in English and provide the mathematical notation used in the algebraic formulation of the decision problem. b) (2 points) What is the objective function? Clearly explain the objective function in English and provide the mathematical formulation. c) (6 points) What are the constraints of the problem? Clearly explain each constraint in English and provide the mathematical formulation. d) (1 point) Are there any sign or type restrictions in your formulation? Why or why not? Clearly explain the sign and type restrictions (if any). e) (8 points) Prepare a spreadsheet model and determine the optimal assignment of expertise level hours as well as the optimal objective function value using Excel Solver. Expertise Level/Job Type (hours) A B C D E F Available Labor Hours Entry-Level 8 10 11 14 16 18 100 Junior 6 8 10 12 14 16 150 Senior 4 6 8 10 12 14 200 Expert 3 4 6 6 7 10 250 Profit ($/job) 1000 1200 1400 1600 1800 2000 Minimum number of jobs to complete 10 15 5 20 5 10

XYZ Consulting is a prestigious consulting firm known for its diverse team of experts. They offer services in multiple domains, and their team members possess different expertise levels: entry level, junior, senior, and expert. The available hours for entry-level, junior, senior, and expert are 100, 150, 200 and 250 hours per month. XYZ Consulting takes on six different types of consulting jobs: A,B,C,D,E, and F. The time (in hours) it takes for each expertise level to complete each type of consulting job as well as available hours for each expertise level, the minimum number of consulting job types that must be completed per month and profit per job type are given as follows: Table-Q4. Information table You are asked to determine the optimal assignment of expertise level hours to various types of consulting jobs that maximizes the monthly total profit. You will formulate a linear programming model to determine the optimal solution using Excel Solver